Debugging Firebird DB

[Ondra Knezour]

Dear all,

I'm trying to use some comercial application (Linux binary, no sources 
available) on FreeBSD. This program runs as daemon, receive requests 
from win based clients, process them, connect to Firebird and send 
response back to client.

However, there are some troubles with daemon <-> database communication, 
probably with processing daemons requests in database. I tried to watch 
communication with tcpdump and look on running db server with truss, but 
didn't get any usefull info.

So my question is - can anybody direct me to some method how to watch 
actions taken in Firebird DB upon db client request? Some sql 
debugger/profiler? Or some reading about this? I have no success with 
searching.

And second question - there are some UDFs (user defined functions 
libraries) for Firebird, Linux only again, compiled from Delphi, no 
sources available. Has anybody experince with using such .so files with 
Firebird? Using linuxpluginwrapper, decompilation and compilation on 
FreeBSD, any other way?

Thanks for your time.

-- 
Best Regards

Ondra Knezour