Mailtraq - the Complete Email Server

Enstar for Mailtraq email server sales & support
Making world-class Internet technology affordable  

Search for:

Advanced search

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:




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.|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 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 =


RemoteBindAddress =

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



Download Trial
Buy now
Feature Tree
What's new
Print this pagePrint this Page  
Mailtraq 2.12 PDFDatasheet  
Send a friend an email about MailtraqShareMailtraq - Email Server at Delicious Mailtraq - Mail Server at digg Mailtraq - Mail Server at FacebookMailtraq - Email Server at stumbleupon Tweet about Mailtraq 



Mailtraq Highlights...
 SMTP Server     Mailtraq SMTP email server video IMAP Server     Mailtraq IMAP email Server video
 POP3 Server     Mailtraq POP3 email server video Proxy Server     Mailtraq proxy email server video
 Webmail Server     Mailtraq webmail email server video Mailing-list Server     Mailing list email server video
 Groupware Services     Mailtraq groupware email services video Spam and Virus control     Spam and virus control email server video


   Copyright © 2003 - 2011 Enstar Ltd, Enstar LLC & Fastraq Ltd. All rights reserved. Privacy policy.
   Mailtraq® is a registered trademark of Fastraq Limited.