[Dovecot] Qmail+Vpopmail+Mysql+Dovecot 2.x (Notes on a successful conversion)

[Matt Brookings]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 10/07/2010 06:42 PM, Aaron wrote:
>  SoI had a hell of a time converting my qmail install to dovecot 2.0.5,
> so I thought I'd pass on what I learned.
> 
> 1. When using vpopmail, do not use " --disable-many-domains".  If you
> do, you'll need to recompile vpopmail without that setting and use the
> script found at
> http://qmailrocks.thibs.com/downloads/scripts/migrate-vpopmail-many-domains
> to collapse the tables.
> 
> 2.  Switch to mysql authentication.  The following snippet works well.
> 
> driver = mysql
> connect = host=/var/run/mysqld/mysqld.sock user=vpopmail
> password=YOURPASS dbname=vpopmail
> default_pass_scheme = PLAIN
> password_query = SELECT CONCAT(pw_name, '@', pw_domain) AS user,
> pw_clear_passwd AS password FROM vpopmail WHERE pw_name = '%n' AND
> pw_domain = '%d'
> user_query = SELECT pw_dir as home, 1008 AS uid, 1003 AS gid FROM
> vpopmail WHERE pw_name = '%n' AND pw_domain = '%d'

Just a quick FYI: You could just use the vpopmail driver that comes
with Dovecot.  It's easier to configure, and it does not matter what
backend database you use.
- -- 
/*
    Matt Brookings <matt at inter7.com>       GnuPG Key FAE0672C
    Software developer                     Systems technician
    Inter7 Internet Technologies, Inc.     (815)776-9465
*/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkyvUXkACgkQIwet2/rgZyzYRwCfbYROYzuoMkgv6Erdwib7Ybnv
AP8AmQFcrsrJMIo7v+lceynm0dGzZZOW
=Xfyb
-----END PGP SIGNATURE-----