Subject | Re: [firebird-support] Database triggers |
---|---|
Author | Vlad Khorsun |
Post date | 2009-09-23T21:24:15Z |
> >> Now, catching/logging those failed connection attempts could be aCorrect. You also need to set AuditTraceConfigFile in firebird.conf, as you
> >> 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>
> -----------------------------
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 alsoFeel free to share your expirience with us and keep ask good questions.
> see the layout of the trace and what kind of information it provides).
Regards,
Vlad