Recent

Author Topic: [Solved] Problem with IBX "SQL monitor"  (Read 1080 times)

devEric69

  • Hero Member
  • *****
  • Posts: 648
[Solved] Problem with IBX "SQL monitor"
« on: May 05, 2021, 01:35:48 pm »
Hello,

I'm trying to integrate an IBX "SQL monitor" (TIBSQLMonitor component) into an IBX 2.3.2. embedded application. I've studied the "Integrated Monitoring Example" application named IntegratedMonitor. It works very well.

I've tried to port it into an embedded application, on the same development workstation. But, I can't get it to work properly. I believe there are 2 probable causes for "SQL monitor" not working in my embedded application:
a) I've not studied enough its source code to port it in my application properly;
b) there is an incompatibility with my embedded configuration; In the latter case, this is what I've noticed:
• When it works with IntegratedMonitor software, here are the loaded libraries (using a centralized server Firebird 3.0):
/usr/lib/.../.../firebird/3.0/plugins/libfbtrace.so
/usr/lib/.../.../firebird/3.0/plugins/lidnEngine12.so
/usr/lib/.../.../firebird/3.0/intl/libfbintl.so
• When it doesn't work with MyAppli, here are the loaded libraries (using a tar.gz unzipped embedded Firebird 3.0.5, localized in /home):
/home/.../Myappli/config/firebird/3.0/plugins/libfbtrace.so
/home/.../Myappli/config/firebird/3.0/plugins/lidnEngine12.so
/home/.../Myappli/config/firebird/3.0/intl/fbintl                              (<== no more libfbintl.so)
/home/.../Myappli/config/firebird/3.0/lib/libib_util.so
/home/.../Myappli/config/firebird/3.0/lib/libfbclient.so.3.0.5
The library libfbintl.so isn't loaded by embedded MyAppli: does it matter? Anything else incoherent?

Regards
« Last Edit: May 05, 2021, 05:09:57 pm by devEric69 »
use: Linux 64 bits (Ubuntu 20.04 LTS).
Lazarus version: 2.0.4 (svn revision: 62502M) compiled with fpc 3.0.4 - fpDebug \ Dwarf3.

devEric69

  • Hero Member
  • *****
  • Posts: 648
Re: [Solved] Problem with IBX "SQL monitor"
« Reply #1 on: May 05, 2021, 05:16:42 pm »
My "ReaderThread while" loop was reading fine, but could never call receiveMessage, due to the precondition clauses that were always shunting the code leading to writeSQLData (said another way, my FTraceFlags set was always equal to [] leading towards Exit;).

So, "SQL monitor" works with an embedded database too. And a library may not be terminated by *.so extension: strange, but it can be like that.
« Last Edit: May 05, 2021, 05:20:18 pm by devEric69 »
use: Linux 64 bits (Ubuntu 20.04 LTS).
Lazarus version: 2.0.4 (svn revision: 62502M) compiled with fpc 3.0.4 - fpDebug \ Dwarf3.

 

TinyPortal © 2005-2018