Talk:Complete Virtual Mail Server/Postfix to Database

Actually 'testuser' was not used during this howto, I used it on my own production database, so some copy/paste/modify cycle may have gone wrong.

When I wrote this bit, I used an existing mail storage. As such, quota files where in each userdir and thus postfix vda may have gotten confused by this. Since at this stage, quota support isn't configured yet, e.g. postfix doesn't know how or where to check for them, things may get messed up. Enabling quota's as described later, it works as expected. Obviously disabling quota's all together will work just as well, as postfix won't care about quota's.

postfix/main.cf
$myhostname is needed for sending mail to gmx users, otherweise gmx bounces with: Sorry, your helo has been denied. 550 5.7.1 (http://portal.gmx.net/serverrules ) (in reply to RCPT TO command)

but, $myhhostname needs to be excluded from $mydestination, postfix bounced everything and gave the following error: postfix/trivial-rewrite[15109]: warning: do not list domain [DOMAIN] in BOTH mydestination and virtual_mailbox_domains

MySQL
I'm adding the MySQL configuration to the wikki. I would like your opinion of something. 1. Add MySQL after PostgreSQL subparagraphs or; 2. Add MySQL paragraph and PostgreSQL paragraph and then cover the whole configuration? There are two way of doing this. The first is what I'm doing now. elmar283 08-06-2014

There are multiple problems with genericmailsql.sql

1. it is not found at http://www.gentoo.org/doc/en/files/genericmailsql.sql but rather at   http://wwwold.gentoo.org/doc/en/files/genericmailsql.sql 2. it throws the following error

ERROR 1064 (42000) at line 12: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 6

Which probably is due to the fact that it's a 3.23.52 Server version file and is being used on a MySQL 5.6 installation

An update would be nice.

rico666 - 2015-06-24


 * I cannot reproduce ERROR 1064 for that link and instead get uncool 404. However, genericmailsql.sql can be downloaded without problems.   --Charles17 (talk) 08:06, 25 June 2015 (UTC)


 * the 1064 error comes from MySQL when you try to issue the "mysql -u root -p mailsql < genericmailsql.sql" command. I was able to fix it by removing the 'TYPE=MyISAM' parts in the sql file. Rico666 (talk) 08:29, 25 June 2015 (UTC)

virtual_mailbox_domains.cf
This part of the documentation ( virtual_mailbox_domains.cf ) looks like it includes a typo where we select for the description.

In Postfix Admin, the "description" field is optional.

Selecting for the domain may be the better approach.

query          = SELECT domain FROM domain WHERE domain = '%s' AND backupmx = '0' AND active = '1';

Spot on. Of course it won't work with description and in fact doesn't. Made the proposed change.