Subject Re: [firebird-support] Database triggers
Author Vlad Khorsun
> >> Now, catching/logging those failed connection attempts could be a
> >> security feature. Would it be a feature worth considering?
> >
> > It is implemented in new trace services in v2.5
> >
> >> As for username (logged in at the PC) and other info: the client dll
> >> might transfer it, and it could be saved in a monitoring table.
> >
> > This is another feature request. Feel free to register it in tracker.
> >
> > Regards,
> > Vlad
>
>
> Having extracted fbtrace.conf from the Firebird-2.5...zip, it looks
> like I can use someting like the following for a database with alias MYDB:
> -----------------------------
> <database MYDB>
> enabled true
> log_filename D:\TRACE\mydb.log
> max_log_size 10
> log_connections true
> </database>
> -----------------------------

Correct. You also need to set AuditTraceConfigFile in firebird.conf, as you
need system audit as i understand.

> Will failed connection attempts also be logged?

Yes

> Are there any rules regarding the use of database alias or filenames ?

Good question :) I believe pattern must be compared against what user
specified in connection string, but i didn't checked it by myself. Will do.

> 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