Re: [firebird-support] Re: Starting auditing session

[hv...@users.sourceforge.net [firebird-support]]

> In which DLL are the isc_action_svc_trace_* functions located? I am 
 > planning to call it from a Lazarus project

  As i already wrote, you should work with Services API. If you never works 
with it before i suggest to 
read IB6 "API Guide" 

https://www.firebirdsql.org/en/reference-manuals/ 
https://www.firebirdsql.org/en/reference-manuals/

and corresponding docs for Lazarus access components you used to work with 
Firebird.

isc_action_svc_trace_* is not a functions exported from DLL.
This is numeric constants (tags) used to work with Services API.

Hope it helps,
Vlad

PS avoid overquoting, please

Re: [firebird-support] Re: Starting auditing session

[Chris ch...@vp44.net [firebird-support]]

On 2017-02-22 08:42, hv...@users.sourceforge.net [firebird-support] 
wrote:

> ---In firebird-support@yahoogroups.com,  wrote :
> 
>> I've started looking into Firebird tracing capabilities and there 
>> seems to
>> be very little documentation on the topic besides the official manual 
>> and
>> a few commercial applications that are well known.
> 
> Does you read
> https://www.firebirdsql.org/file/documentation/release_notes/html/en/2_5/rnfb25-trace.html
> and
> https://www.firebirdsql.org/file/documentation/release_notes/html/en/2_5/rnfb25-apiods-api.html#rnfb25-apiods-api-svctrace
> ?
> 
>> I am aware of the "fbtracemgr" utility but I would like to handle 
>> things
>> myself.
> 
> Good. Note, you need not "auditing" session but usual "user trace" 
> session.
> Audit is a bit different, read the docs, please.
> 
>> First of all: how do I start a tracing session? Is it a sql command 
>> that I
>> call like a function or I select from like in a procedure?
> 
> FIrst, you need to know how to work with Services API.
> Second, read again
> https://www.firebirdsql.org/file/documentation/release_notes/html/en/2_5/rnfb25-apiods-api.html#rnfb25-apiods-api-svctrace
> 
> Also, you can read source code of fbtracemgr
> https://github.com/FirebirdSQL/firebird/blob/B2_5_Release/src/utilities/fbtracemgr/traceMgrMain.cpp
> 
>> Second: how do I feed Firebird the tracing session configuration file?
>> Does it need to be a "physical" file on the same server as FB or can 
>> it be
>> read from like STDIN?
> If you read docs, you know that trace configuration is sent as a part 
> of SPB
> 
> Hope it helps,
> Vlad


Hi Vlad,

thank you for your response.
In which DLL are the isc_action_svc_trace_* functions located? I am 
planning to call it from a Lazarus project