kdv2.5 не поможет, это аудит и трейс на сервере.
<. . .>
На клиенте логгировать должны компоненты или драйвер.я тя умоляю!
machine #1: linux-server, ip=192.168.0.220, ФБ 2.5 на порту 3253, создаю базу:
1.
2.
3.
4.
5.
6.
7.
8.
9.
$ /opt/fb25/bin/isql -q
SQL> create database 'localhost/3253:/var/db/fb25/foo.fdb';
SQL> show version;
ISQL Version: LI-V2.5.3.26730 Firebird 2.5
Server version:
Firebird/linux AMD64 (access method), version "LI-V2.5.3.26730 Firebird 2.5"
Firebird/linux AMD64 (remote server), version "LI-V2.5.3.26730 Firebird 2.5/tcp (oel64)/P12"
Firebird/linux AMD64 (remote interface), version "LI-V2.5.3.26730 Firebird 2.5/tcp (oel64)/P12"
on disk structure version 11.2
обычная виндузная тачка, но на ней также установлен ФБ 2.5:
C:\MIX\firebird\fb25\bin\fbtracemgr -sta -c zaudit.conf -se 192.168.0.220/3253:service_mgr
SQL> select count(*) from rdb$fields;
COUNT
============
120
machine #2: 1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
2014-01-22T18:17:55.9170 (16817:0x7f04cfea9900) EXECUTE_STATEMENT_START
/var/db/fb25/foo.fdb (ATT_1, SYSDBA:NONE, NONE, TCPv4:127.0.0.1)
/opt/fb25/bin/isql:28234
(TRA_2, CONCURRENCY | WAIT | READ_WRITE)
Statement 206:
-------------------------------------------------------------------------------
select count(*) from rdb$fields
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (RDB$FIELDS NATURAL)
2014-01-22T18:17:55.9180 (16817:0x7f04cfea9900) EXECUTE_STATEMENT_FINISH
/var/db/fb25/foo.fdb (ATT_1, SYSDBA:NONE, NONE, TCPv4:127.0.0.1)
/opt/fb25/bin/isql:28234
(TRA_2, CONCURRENCY | WAIT | READ_WRITE)
Statement 206:
-------------------------------------------------------------------------------
select count(*) from rdb$fields
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (RDB$FIELDS NATURAL)
1 records fetched
0 ms, 247 fetch(es)
Table Natural Index Update Insert Delete
*********************************************************************************
RDB$FIELDS 120
2014-01-22T18:17:55.9190 (16817:0x7f04cfea9900) CLOSE_CURSOR
/var/db/fb25/foo.fdb (ATT_1, SYSDBA:NONE, NONE, TCPv4:127.0.0.1)
/opt/fb25/bin/isql:28234
Statement 206:
-------------------------------------------------------------------------------
select count(*) from rdb$fields
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (RDB$FIELDS NATURAL)
