Subject Re: Verbose Logging
Author Svein Erling Tysvær
Hi Jason,
I see that noone has answered your question (including me, who tried
to send something yesterday). This may either be due to you hijacking
the thread "'Invalid connection path' error msg " rather than starting
a new thread (we do not like this, some people use threading to sort
the messages, and intertwining threads means that they either don't
see your message or get irritated because they find your message
'spamming' a thread that interests them) or people not knowing the
answer to your question (like me).

In general, only the database owner, SYSDBA and users with root
priviledge may issue DROP DATABASE. That statement deletes the entire
database including its logs, and should not be issued by accident.
Hence, if you're even unable to identify 'someone somewhere', then you
also have a problem with your staff.

Of course, deleting a file by accident (at least if no-one is
connected to the database) is easier to do, but in general your users
should not have direct access to your database files anyway, so this
ought not to be a problem. And there's no way Firebird could log what
is done through the operating system (note, I'm all Windows, I don't
know whether deleting files on Linux are safer).

I don't know whether it is possible to have more verbose logging (due
to my lacking knowledge, not because it isn't possible). Hopefully,
someone knowing the answer will read this mail and reply to you.

Set

> Yesterday we had some sort of complication to where someone
> somewhere deleted the database. Unfortunatly, we do not have enough
> information as to why/when/how this happened... BUT it compells me
> to at least find out if there is some sort of logging that is more
> verbose then what is default for firebird.log. Thus far, the only
> thing in that file is when the server stopped/started the firebird
> service. Id like to, at least, see entries for the
> creation/modification/deletion of database objects.
>
> I am using the 1.5.2 SS linux build if that matters... any ideas?
>
> Jason