Talk:Complete Virtual Mail Server/Postfix to database

Unix sockets is an option for postgres, tcp-ip connections are also possible.

It is said mysql doesn't require that step. Is that because:

a) mysql can't be used with only socket communication? b) mysql has permission to the socket per default?

if b) then that would be really weird and almost impossible (depending on the distro) if a) then mysql doesn't support sockets and it should be mentioned as such.

It would be possible to change 'false' and 'true' in the boolean statements to '0' and '1' for the postgres stuff to get it more in line with mysql, but postgres does require the quotes.


 * 1) Not working. query = SELECT maildir FROM mailbox WHERE username='%u' AND domain='%d' AND active=1

When I initially created this document, I was coming from an old postfix +postgres install that wasn't using postfixadmin's database as base. postfixadmin in the meantime has changed or something, and they now user the 'username' actually as the e-mail address and the local_part as only the username, sorta. What it boils down to, is that local_part is what is conciderd to be the username; and thus local_part@domain is what will be used from now on.

UID and GID usage in the database is stupid. Maybe see it as a 'per daemon' thing or something. Or, when maildirs are stored in homedirs and thus those id's would have to match. postfixadmin doesn't use it, courier doesn't use it, it's not used.