Hi there. I've got a running qmail+vpopmail+mysql5 server on FreeBSD and I would like to give IMAP access to it (both for user's sake and to have a decent webmail), so I decided to install dovecot (it certainly does its work on my home box). Problem is: I haven't had success with authentication.
At first I tried the most obvious: using the vpopmail backend. Unfortunately I received lots of "vmysql: MySQL server has gone away" just like in http://article.gmane.org/gmane.mail.imap.dovecot/10321
So I decided to spice up a query to vpopmail's MySQL table, and there another problem was waiting for me: "Access denied" just like in this thread http://article.gmane.org/gmane.mail.imap.dovecot/9077 Only difference: in my case using OLD_PASSWORD() didn't solve the problem and -thinking about it better- couln't possibly have solved it: that FreeBSD is a recent fresh install and I installed MySQL 5.0.18 from sources using the "ports" system, so a library with no support for new PASSWORD() has never seen the light on that box.
I kinda went around the problem using a shell script to dump the MySQL table to a SQLite file and authentication dovecot against that, but while this work-around can do for a little bit I'd really like to solve the problem itself, and avoid having to keep ni sync those two DBs (no, unfortunately vpopmail doesn't support SQLite, else I'd use that: it would also have the nice side-effect that a "down" on mysql side wouldn't hurt the mail subsystem).
Any suggestions or idea how I could solve or, at least, better diagnose the problem(s)?
Yours, Lapo