Innovators in Mail server, Webmail and appliance solutions

By default @Mail uses the InnoDB database format via mySQL for the most frequently used database tables.

This increases performance for the application, however uses more memory and disk resources via MySQL.

If you experience problems using the InnoDB format you can switch to the default table format of MySQL ( MyISAM )

For technical details on the different database formats of MySQL see:

http://dev.mysql.com/tech-resources/articles/storage-engine/part_3.html

To change the table types:

#!/usr/bin/perl
# Switch DB to MyISM
foreach('UserSession', 'Users', 'Groups', 'Log_Error', 'Log_Login', 'Log_RecvMail', 'Log_SMS', 'Log_SendMail', 'Log_Spam', 'Log_Virus', 'awl')  {
my $table = $_;
print("alter table $table TYPE=myisam;n");
}

Usage:

perl /tmp/switchdb.pl | mysql -u root -p atmail

Question: I have installed @Mail under my Apple OS X machine, and I would like to configure @Mail to automatically start on boot, and have the ability to stop/start the @Mail server processes ( Exim, Spamassassin, POP3/IMAP, etc )

Answer: Under OS-X the default Linux/Unix layout for startup items differs. Under OS X the directory:

/System/Library/StartupItems/

Is used to control which services start on boot.

To configure the startup script of @Mail under OS X extract:

http://kb.atmail.com/attach/osx-startup-atmail.tgz

As root:

root# tar xfvz osx-startup-atmail.tgz -C /System/Library/StartupItems/

Then as root you can control the services of @Mail using the command:

root# SystemStarter @Mail start
root# SystemStarter @Mail stop

Technical details for the Startup script for OS X follow. The file:

/System/Library/StartupItems/Atmail/Atmail is used to control the services:

#!/bin/sh

##
# @Mail Software
##

. /etc/rc.common

StartService ()
{
echo "Starting @Mail server"
/usr/local/atmail/webmail/modules/atmailserver.sysvinit start
}

StopService ()
{
echo "Stopping @Mail server"
/usr/local/atmail/webmail/modules/atmailserver.sysvinit stop
}

RestartService ()
{
echo "Restarting @Mail server"
StopService
StartService
}

RunService "$1"

Next, the Startup preferences are defined under:

/System/Library/StartupItems/Atmail/StartupParameters.plist

{
  Description     = "@Mail Server";
  Provides        = ("@Mail");
  Uses            = ("Disks");
  Requires        = ("Network", "MySQL");
}

Note the Requires MySQL option, this is dependent on installing the MySQL server for @Mail to start.

Q: do you have an E-Mail Push Service solution like Blackberry or funambol.com for your Mail Server ? Or do you have an idear how we can deliver this Service with your Mail Server ?

(more...)