Working with Firebird

Reducing the Database size

Users are often surprised that when they delete a large amount of messages from Mailtraq they don't see a matching reduction in the size of the mailtraq.fdb file.  As messages are stored in the database the size of the database grows, but when the messages are removed the structure remains.

Why is this ?   It may be helpful to think of the database as a honeycomb - as more honey is stored so the honeycomb grows, however if you later remove the honey, the honeycomb remains the same overall size, even when the honey is gone.

There are tools for manipulating Firebird directly (see below) but a Firebird 'backup and restore' may be sufficient.

Now is a good time to review your backup regime: www.mailtraq.com/backup

Client/Server Mode

For Firebird familiar users:

The Firebird database system as automatically installed is embedded into Mailtraq's process and can only be accessed by Mailtraq. If you wish to access the database directly you will need to change over to the Client/Server mode.

This procedure is for experienced administrators and is not officially supported

You can easily install the full Firebird client-server system and replace the FB registry entry with the database address and alias followed by credentials, e.g.192.168.1.1:mailtraq|SYSDBA|masterkey, providing you copy the Metabase from the file Mailtraq creates and replace gds32.dll with the contents of fbclient.dll

Naturally, you need to take precautions against compromising your email system, so if you wish to work with Firebird we suggest you contact development@novitraq.com who will be pleased to advise you.
Charges may apply.

Firebird vulnerabilities

If you are concerned about  about remote exploitation you should edit the firebird.conf file and change:

#RemoteBindAddress =

To

RemoteBindAddress = 127.0.0.1

which will prevent remote access to Firebird.   

Firebird in 'non-Firebird' installations

For a discussion about operating in Client/Server mode see this Forum Knowledgebase Article