The thread has drifted from "Database triggers" to fbtrace (Fb/2.5).
This might mean that this stuff should be moved to the firebird-devel list.


Vlad Khorsun wrote:

>> I may find a pc where I can install Fb/2.5 so I can test (and also
>> see the layout of the trace and what kind of information it provides).
>
> Feel free to share your expirience with us and keep ask good questions.
>
> Regards,
> Vlad
>

I had no success with tracing.

Having installed Fb/2.5, it seems that it works ok. At least, I can
connect to the EMPLOYEE database and view metadata using IB_SQL
(using IBO/4.8.7).

So, I enable trace by setting
AuditTraceConfigFile = C:\TEMP\FB_TRACE\fbtrace1.conf
in firebird.conf, stop & start server (using the firebird applet).

Trying to connect gives an MSVC++ RTL error:
----------------------------------------------
Runtime Error!
Program: C:\Program Files\Firebird\Firebird_2_5\bin\fbserver.exe
This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.
----------------------------------------------

Followed by errors reported by IB_SQL
----------------------------------------------
ISC ERROR CODE:335544721
ISC ERROR MESSAGE:
Unable to complete network request to host "localhost".
Error writing data to the connection.
&
SQL ERROR CODE:-902
SQL ERROR MESSAGE:
Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements
----------------------------------------------
The connection string is localhost:EMPLOYEE (working ok with disabled
trace). I'm using with SYSDBA/masterkey.

This is from the firebird.log:
----------------------------------------------
INT-352-002 (Client) Fri Sep 25 15:33:26 2009
"C:\Program Files\Firebird\Firebird_2_5\bin\fbserver.exe": terminated
abnormally (4294967295)
----------------------------------------------
It is restarted by the Guardian.

The trace specification (in C:\TEMP\FB_TRACE\fbtrace1.conf) is
something like this (I don't remember exactly).
-----------------------------
<database EMPLOYEE>
enabled true
log_filename C:\TEMP\FB_TRACE\xxx.log
max_log_size 1
log_connections true
</database>
-----------------------------
I forgot to copy the actual file from the pc at work. Maybe this is
where the problem hides.
I have tried with ISQL as well - no success. I think the only
(additional) change to firebird.conf was to allow mixed authentication.


--
Aage J.