[firebird-support] Re: fbtracemgr and embedded
since v2.5 it is possible to use Firebird embedded without install of full CS package. All you need is to create the almost the same folders layout as with full Firebird package, including bin, intl, lib, plugin, UDF folders and its contents. Create simlink lib/libfbembed.so.2.5 pointing to the lib/libfbembed.so.2.5.2 Remove not needed binaries from bin folder, if necessary Set FIREBIRD to the root folder. Set LD_LIBRARY_PATH to the lib folder (not to the root !) Thank you Vlad!! I have followed these steps and it is working perfectly. Actually the symlink was already present. The only other thing I had to do was to delete the /tmp/firebird directory because this did not have user write privileges having been created with the install.sh script.
[firebird-support] Re: fbtracemgr and embedded
--- In firebird-support@yahoogroups.com, Mike Ro wrote: Mark, since v2.5 it is possible to use Firebird embedded without install of full CS package. All you need is to create the almost the same folders layout as with full Firebird package, including bin, intl, lib, plugin, UDF folders and its contents. Create simlink lib/libfbembed.so.2.5 pointing to the lib/libfbembed.so.2.5.2 Remove not needed binaries from bin folder, if necessary Set FIREBIRD to the root folder. Set LD_LIBRARY_PATH to the lib folder (not to the root !) this is all. Good luck, Vlad
[firebird-support] Re: fbtracemgr and embedded
--- In firebird-support@yahoogroups.com, certfb wrote: ... Sorry I should have said that I am using CS 2.5.2 on Ubuntu 12.10. It is still not clear which process handle database connection - your application's embedded attachment or worker process of Firebird CS. I have set up fbtracemgr to use fbemded by setting the following environment variables: export FIREBIRD=/home/myhome/experiments/firebird export LD_LIBRARY_PATH=/home/myhome/experiments/firebird If you already have properly installed and worked CS you should not change environment variables. I have tried putting libfbtrace.so in $FIREBIRD, $FIREBIRD/plugins and even tried /opt/firebird/plugins but fbtracemgr cannot find the plugin, Can not start trace session. There are no trace plugins loaded Don't change environment, make sure your account is a member of a firebird group and all should work without additional steps. Regards, Vlad PS The guide you are referring to is *very* outdated and describes FB 1.5.
Re: [firebird-support] Re: fbtracemgr and embedded
Dear Vlad, thank you for your response and insight. Sorry I should have said that I am using CS 2.5.2 on Ubuntu 12.10. It is still not clear which process handle database connection - your application's embedded attachment or worker process of Firebird CS. For the first testing I have created the database using the command line isql and tried to attach with the command line fbtracemgr. Ultimately I would like to use IBPP, but for my simple requirements (to debug what values are being inserted in to parameterised queries) fbtracemgr is probably still sufficient. I have set up fbtracemgr to use fbemded by setting the following environment variables: export FIREBIRD=/home/myhome/experiments/firebird export LD_LIBRARY_PATH=/home/myhome/experiments/firebird If you already have properly installed and worked CS you should not change environment variables. Okay, my mistake was to think that I could use an embedded server on Linux without a full CS installation, but I have now read in this FAQ that it is not possible: http://www.firebirdsql.org/manual/ufb-cs-embedded.html Which is a pity because apart from tracing it seems to work very well! I have tried putting libfbtrace.so in $FIREBIRD, $FIREBIRD/plugins and even tried /opt/firebird/plugins but fbtracemgr cannot find the plugin, Can not start trace session. There are no trace plugins loaded Don't change environment, make sure your account is a member of a firebird group and all should work without additional steps. Okay, my next step will be a full CS install when I have access to a suitable machine in the next two days. [Non-text portions of this message have been removed]
[firebird-support] Re: fbtracemgr and embedded
--- In firebird-support@yahoogroups.com, certfb wrote: Hi, Sorry for the (possibly) silly question, but is it possible to use fbtracemgr with the embedded server? Yes If so what should the 'connect' string look like, i.e. in... fbtracemgr -SE remote_host:service_mgr -USER SYSDBA -PASS masterkey -LIST ...what would I replace the 'remote_host:service_mgr' with? If you want to trace local database, just use service_mgr and ensure fbtracemgr used fbembed[.dll|.so] instead of fbclient. Regards, Vlad
[firebird-support] Re: fbtracemgr and embedded
Sorry for the (possibly) silly question, but is it possible to use fbtracemgr with the embedded server? Yes Thank you for your answers, that is great news. By the way my purpose for using tracing is to be able to see a how parametrised selects created with IBPP are resolved. ...what would I replace the 'remote_host:service_mgr' with? If you want to trace local database, just use service_mgr and ensure fbtracemgr used fbembed[.dll|.so] instead of fbclient. Sorry I should have said that I am using CS 2.5.2 on Ubuntu 12.10. I have set up fbtracemgr to use fbemded by setting the following environment variables: export FIREBIRD=/home/myhome/experiments/firebird export LD_LIBRARY_PATH=/home/myhome/experiments/firebird I have tried putting libfbtrace.so in $FIREBIRD, $FIREBIRD/plugins and even tried /opt/firebird/plugins but fbtracemgr cannot find the plugin, Can not start trace session. There are no trace plugins loaded Thanks again!
Re: [firebird-support] Re: fbtracemgr and embedded
Sorry for the (possibly) silly question, but is it possible to use fbtracemgr with the embedded server? Yes Thank you for your answers, that is great news. By the way my purpose for using tracing is to be able to see a how parametrised selects created with IBPP are resolved. ...what would I replace the 'remote_host:service_mgr' with? If you want to trace local database, just use service_mgr and ensure fbtracemgr used fbembed[.dll|.so] instead of fbclient. Sorry I should have said that I am using CS 2.5.2 on Ubuntu 12.10. I have set up fbtracemgr to use fbemded by setting the following environment variables: export FIREBIRD=/home/myhome/experiments/firebird export LD_LIBRARY_PATH=/home/myhome/experiments/firebird I have tried putting libfbtrace.so in $FIREBIRD, $FIREBIRD/plugins and even tried /opt/firebird/plugins but fbtracemgr cannot find the plugin, Can not start trace session. There are no trace plugins loaded Is there a particular reason of using Embedded instead of a regular server for your tracing scenario? -- With regards, Thomas Steinmaurer http://www.upscene.com/
[firebird-support] Re: fbtracemgr and embedded
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@... wrote: Sorry for the (possibly) silly question, but is it possible to use fbtracemgr with the embedded server? Yes Thank you for your answers, that is great news. By the way my purpose for using tracing is to be able to see a how parametrised selects created with IBPP are resolved. ...what would I replace the 'remote_host:service_mgr' with? If you want to trace local database, just use service_mgr and ensure fbtracemgr used fbembed[.dll|.so] instead of fbclient. Sorry I should have said that I am using CS 2.5.2 on Ubuntu 12.10. I have set up fbtracemgr to use fbemded by setting the following environment variables: export FIREBIRD=/home/myhome/experiments/firebird export LD_LIBRARY_PATH=/home/myhome/experiments/firebird I have tried putting libfbtrace.so in $FIREBIRD, $FIREBIRD/plugins and even tried /opt/firebird/plugins but fbtracemgr cannot find the plugin, Can not start trace session. There are no trace plugins loaded Is there a particular reason of using Embedded instead of a regular server for your tracing scenario? -- With regards, Thomas Steinmaurer http://www.upscene.com/ Thomas, thanks for your comment. I am making a very basic piece of software using wxWidgets and IBPP that I want to be easily deployable without having to install the server, check firewalls etc. You might think that sqlite or similar is more appropriate but I am happy with Firebird and don't want to preclude scaling things to client server at some point down the road. I have successfully used fbtracemgr before with the normal server, but this is my first attempt at using it with the embedded server which has been setup following the instructions at http://www.firebirdfaq.org/Firebird-Embedded-Linux-HOWTO.html Kind regards