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
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 email@example.com who will be pleased to advise you.
Charges may apply.
If you are concerned about about remote exploitation you should edit the firebird.conf file and change:
RemoteBindAddress = 127.0.0.1
which will prevent remote access to Firebird.
Firebird in 'non-Firebird' installations
Firebird is provided in all current versions of Mailtraq to support importing from 'old' Mailtraq FDB files in the Tools | Message Import Wizard
If you do not need this functionality you can [Stop] and then [Disable] the Firebird Server in the Windows Services Manager.
For a discussion about operating in Client/Server mode see this Forum Knowledgebase Article