Very cool stuff:
dbmail-imapd : Error:[sql] dbmysql.c,db_mysql_check_collations(+138): collation mismatch, your MySQL configuration specifies a different charset than the data currently in your DBMail database. Apr 21 09:21:49 bart111 dbmail-imapd : FATAL:[server] server.c,StartServer(+129): Unable to connect to database.
dpkg-reconfigure -plow dbmail
telnet localhost 144 Trying 127.0.0.1... Connected to localhost.localdomain. Escape character is '^]'.* OK dbmail imap (protocol version 4r1) server 2.2.10 ready to run * BAD No tag specified * BAD No tag specified/etc/default/dbmail:
After the initial problems with dbmail, I'm pleased to report it works! I was able to connect RoundCube to dbmail, and authenticate via ldap. That's awesome!
More interesting links:
I planned to try out mysql-proxy right away with dbmail, but it looks like its not ready yet. There is no init script that I can find.
This would be a perfect time to give perdition a spin! I would like to be able to route only a few accounts to receive mail for mailboxes stored in dbmail.
To-do: * Setup public smtp server for delivery of low-volume email to dbmail
Looks like it will be fairly easy to set this up for a single domain - thanks to the flexibility of postfix configuration. Specifically, you can specify the transport for each domain separately.
While it is possible to use ldap, I'm now using the built in sql authentication capabilities of dbmail for testing it out.