Re: [Dovecot] Qmail+Vpopmail+Mysql+Dovecot 2.x (Notes on a successful conversion)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/08/2010 06:44 PM, Aaron wrote: > On 10/8/2010 10:14 AM, Matt Brookings wrote: >> -BEGIN PGP SIGNED MESSAGE- >> Hash: SHA1 >> >> On 10/07/2010 06:42 PM, Aaron wrote: >>> 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. >> - -- > You're kidding. > > It works now? > > As of which revisions of Dovecot/Vpopmail? (It was broken with dovecot > 2+vpopmail 5.4.30 & 5.5 the last time I attempted to use it). As of 2.0.4, 5.4 and 5.5 both work. - -- /* Matt BrookingsGnuPG 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/ iEYEARECAAYFAky0c88ACgkQIwet2/rgZyzRMACcDp89/nWiGrl+P5S8RCe8zucU K94AniQHafQdRjghZL4OXcQOCFTNgkD5 =wSPH -END PGP SIGNATURE-
Re: [Dovecot] Qmail+Vpopmail+Mysql+Dovecot 2.x (Notes on a successful conversion)
On 10/8/2010 10:14 AM, Matt Brookings wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/07/2010 06:42 PM, Aaron wrote: 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 BrookingsGnuPG Key FAE0672C Software developer Systems technician Inter7 Internet Technologies, Inc. (815)776-9465 */ You're kidding. It works now? As of which revisions of Dovecot/Vpopmail? (It was broken with dovecot 2+vpopmail 5.4.30 & 5.5 the last time I attempted to use it). Thanks! a.
Re: [Dovecot] Qmail+Vpopmail+Mysql+Dovecot 2.x (Notes on a successful conversion)
-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 BrookingsGnuPG 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-
[Dovecot] Qmail+Vpopmail+Mysql+Dovecot 2.x (Notes on a successful conversion)
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'
3. When integrating Sieve, vpopmail apparently needs to own auth-master
and authdb. (example available on request)
4. If coming from maildrop as the LDA, you can put the following in
your maildroprc to allow a gentler transition (or to keep maildrop's
ability to call external applications)
`test -r /usr/libexec/dovecot/deliver`
if ( $RETURNCODE == 0)
{
`test -r $HOME/$EXT/.sieve`
if ( $RETURNCODE == 0)
{
to "| /usr/libexec/dovecot/deliver -d $...@$user"
}
}
5. When completely switching, you can either replace the .qmail files
or use one of the following in qmail/control/defaultdelivery
|/var/qmail/bin/preline -f /usr/libexec/dovecot/deliver -d $...@$user
|/var/qmail/bin/preline -f /usr/libexec/dovecot/deliver -d
${EXT/-...@$user -a $...@$user
--
This should allow a final conversion to vpopmail 5.5 (from 5.4.30) with
dovecot 2.0.x.. I haven't done that final step yet, but it should now work.
Anyhow, I hope this saves someone a few days of head scratching.
a.
