[Dovecot] Install/configure on FC4 with maildir and mysql
Hello, I have a FC4 x64 server that I am configuring/testing.
It had dovecot 0.99 loaded after I did a yum update. That worked great with mbox, the passwd file, and test users in /home/users/username.
I would like to be able to authenticate virtual users by 'username@domain.com' and have them be able to use squirrelmail or Outlook/Outlook Express to access their email. Users have no reason to have a login (shell) account on this machine. I also would like to use the maildir format for performance.
I also have hundreds of users currently on a RH9 mail server using qpopper in mbox format, hashed mail spool.
Questions: 1)Is a mysql database the best way to support "user@domain.com" email users? (they don't have any reason for a shell account on this machine)
2)What version of dovecot should I be using? I prefer RPMs and at http://www.dovecot.org/list/dovecot/2006-February/011467.html I found http://fedora.ivazquez.net/yum/4/x86_64/RPMS.alternatives/dovecot-1.0-0.iva.... I installed this and then configured procmail for maildir delivery. I configured dovecot-sql.conf for mysql driver...but the mysql driver does not appear to be compiled in this rpm.
3)Anyone have any general tips on how to configure such a beast?
Thanks, Curt
Netlink Tech wrote:
Hello, I have a FC4 x64 server that I am configuring/testing.
It had dovecot 0.99 loaded after I did a yum update. That worked great with mbox, the passwd file, and test users in /home/users/username.
Many people will recommend you update to 1.0beta3 (or later) if at all possible. Especially if you're going to be using MySQL.
I would like to be able to authenticate virtual users by 'username@domain.com' and have them be able to use squirrelmail or Outlook/Outlook Express to access their email. Users have no reason to have a login (shell) account on this machine. I also would like to use the maildir format for performance.
Fairly common setup. Many people on this list are running the same sort of thing.
I also have hundreds of users currently on a RH9 mail server using qpopper in mbox format, hashed mail spool.
Questions: 1)Is a mysql database the best way to support "user@domain.com" email users? (they don't have any reason for a shell account on this machine)
If you already have MySQL installed, then yes. If you don't, and you upgrade to 1.0b3, you may want to consider using SQLite for the database. It's much smaller, lighter, and, in many cases, faster!
2)What version of dovecot should I be using? I prefer RPMs and at http://www.dovecot.org/list/dovecot/2006-February/011467.html I found http://fedora.ivazquez.net/yum/4/x86_64/RPMS.alternatives/dovecot-1.0-0.iva....
Well, that looks like 1.0b3, if I'm reading it right. This is the currently recommended best choice.
I installed this and then configured procmail for maildir delivery. I configured dovecot-sql.conf for mysql driver...but the mysql driver does not appear to be compiled in this rpm.
This is not uncommon. Otherwise the base dovecot package would require MySQL, Postrges and SQLite to be installed as dependencies.
3)Anyone have any general tips on how to configure such a beast?
Have a look through the Wiki, and the archives of this mailing list. This is a very common setup, so there are many discussions about it.
Once you're done, perhaps you'd feel like writing up some notes and hints for the Wiki?
Thanks, Curt
-- Curtis Maloney cmaloney@cardgate.net
O.K.
The problem I am having is that I am not able to get the mysql drivers to compile with the dovecot.spec in dovecot-1.0-0.iva.4.beta3.src.rpm. (anyone have or know of a dovecot 1.x rpm for FC4 that HAS mysql support in it?)
I found this on the list archives:
but those are not standard RPMs in a CentOS 4 CD set. Why the difference?
On 11/2/05, Tomi Hakala
Erick Perez wrote:
Devel RPMs: All devel (mysql, pam, openssl) are installed and they are recognized at building time.
There is a bug in Dovecot configure script which makes it go through clean even when --with-mysql is specified but none of needed libraries are found.
I got MySQL support working on RHEL 4 with following MySQL packages:
$ rpm -qa | grep -i mysql MySQL-devel-standard-4.1.15-0.rhel4 MySQL-shared-standard-4.1.15-0.rhel4
So those should be all you need, you can get them at:
http://dev.mysql.com/downloads/mysql/4.1.html
-- Tomi Hakala
I am trying to build this rpm to support mysql for the userdb and passdb. I am using mysql for other purposes on this machine, so I would like to use it for dovecot-auth rather than also install sqllite or pgsql.
The mysql versions installed on this machine: ]# rpm -qa |grep mysql libdbi-dbd-mysql-0.7.1-3 php-mysql-5.0.4-10 mysql-4.1.16-1.FC4.1 mod_auth_mysql-2.6.1-4 mysql-server-4.1.16-1.FC4.1 mysql-4.1.16-1.FC4.1 php-mysql-5.0.4-10.5 mysql-devel-4.1.16-1.FC4.1 mysqlclient10-3.23.58-6
How can I verify that the required mysql libs in the spec exist and are used by rpmbuild?
How can I find...if it exists...a mysql-shared-xxx-4.1.16-1.FC4.1?
I have been using yum to do updates. (repos of fedora and freshrpms).
<big SNIP>
On Thu, Mar 16, 2006 at 09:13:26AM -0600, Netlink Tech wrote:
O.K.
The problem I am having is that I am not able to get the mysql drivers to compile with the dovecot.spec in dovecot-1.0-0.iva.4.beta3.src.rpm. (anyone have or know of a dovecot 1.x rpm for FC4 that HAS mysql support in it?)
Have you tried http://atrpms.net/dist/fc4/dovecot/ ?
Axel.Thimm at ATrpms.net
Axel Thimm wrote :
On Thu, Mar 16, 2006 at 09:13:26AM -0600, Netlink Tech wrote:
O.K.
The problem I am having is that I am not able to get the mysql drivers to compile with the dovecot.spec in dovecot-1.0-0.iva.4.beta3.src.rpm. (anyone have or know of a dovecot 1.x rpm for FC4 that HAS mysql support in it?)
Have you tried http://atrpms.net/dist/fc4/dovecot/ ?
FYI, mysql support has been missing the in 64bit builds for a long while. It's been fixed in FC5, but is still not in RHEL4 (nor FC4 AFAIK).
This is valid for your packages too, Axel, last I checked ;-)
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=182240
Netlink Tech : You might want to try recompiling the FC development source package if the problem is indeed that you're using x86_64.
Matthias
-- Clean custom Red Hat Linux rpm packages : http://freshrpms.net/ Fedora Core release 4 (Rawhide) - Linux kernel 2.6.15-1.2054_FC5 Load : 0.43 0.32 0.35
On Fri, Mar 17, 2006 at 10:55:42AM +0100, Matthias Saou wrote:
Axel Thimm wrote :
On Thu, Mar 16, 2006 at 09:13:26AM -0600, Netlink Tech wrote:
O.K.
The problem I am having is that I am not able to get the mysql drivers to compile with the dovecot.spec in dovecot-1.0-0.iva.4.beta3.src.rpm. (anyone have or know of a dovecot 1.x rpm for FC4 that HAS mysql support in it?)
Have you tried http://atrpms.net/dist/fc4/dovecot/ ?
FYI, mysql support has been missing the in 64bit builds for a long while. It's been fixed in FC5, but is still not in RHEL4 (nor FC4 AFAIK).
This is valid for your packages too, Axel, last I checked ;-)
Thanks Matthias!
Netlink Tech : You might want to try recompiling the FC development source package if the problem is indeed that you're using x86_64.
Yes, he contacted me privately and he's using x86_64. I was already looking at rpm -qRp output wondering why mysqlclient was on i386, but not x86_64 builds :)
Axel.Thimm at ATrpms.net
On Fri, 2006-03-17 at 10:55 +0100, Matthias Saou wrote:
FYI, mysql support has been missing the in 64bit builds for a long while. It's been fixed in FC5, but is still not in RHEL4 (nor FC4 AFAIK).
Aha, thanks for the heads-up Matthias, I'm now rebuilding my packages and will notify the list when they're ready.
-- Ignacio Vazquez-Abrams ivazquez@ivazquez.net http://fedora.ivazquez.net/
gpg --keyserver hkp://subkeys.pgp.net --recv-key 38028b72
On Fri, 2006-03-17 at 05:48 -0500, Ignacio Vazquez-Abrams wrote:
On Fri, 2006-03-17 at 10:55 +0100, Matthias Saou wrote:
FYI, mysql support has been missing the in 64bit builds for a long while. It's been fixed in FC5, but is still not in RHEL4 (nor FC4 AFAIK).
Aha, thanks for the heads-up Matthias, I'm now rebuilding my packages and will notify the list when they're ready.
Alright, they're ready.
http://fedora.ivazquez.net/yum/4/i386/RPMS.alternatives/dovecot-1.0-0.iva.5.... http://fedora.ivazquez.net/yum/4/i386/SRPMS.alternatives/dovecot-1.0-0.iva.5... http://fedora.ivazquez.net/yum/4/ppc/RPMS.alternatives/dovecot-1.0-0.iva.5.b... http://fedora.ivazquez.net/yum/4/ppc/SRPMS.alternatives/dovecot-1.0-0.iva.5.... http://fedora.ivazquez.net/yum/4/x86_64/RPMS.alternatives/dovecot-1.0-0.iva.... http://fedora.ivazquez.net/yum/4/x86_64/SRPMS.alternatives/dovecot-1.0-0.iva...
-- Ignacio Vazquez-Abrams ivazquez@ivazquez.net http://fedora.ivazquez.net/
gpg --keyserver hkp://subkeys.pgp.net --recv-key 38028b72
Thanks Ignacio, Axel, Matthias and anyone else who worked on this code!!!!!
I installed the x86_64.rpm listed below and set up my conf files and HOORAY!, it is running. Now I have to get the authentication to mysql set up...but that is a separate issue. ...it also looks like FC5 will be released on Monday. I guess I had better think about whether I should use FC5 instead of FC4....since it is a new server that I am setting up! :)
On Fri, 17 Mar 2006, Ignacio Vazquez-Abrams wrote:
On Fri, 2006-03-17 at 05:48 -0500, Ignacio Vazquez-Abrams wrote:
On Fri, 2006-03-17 at 10:55 +0100, Matthias Saou wrote:
FYI, mysql support has been missing the in 64bit builds for a long while. It's been fixed in FC5, but is still not in RHEL4 (nor FC4 AFAIK).
Aha, thanks for the heads-up Matthias, I'm now rebuilding my packages and will notify the list when they're ready.
Alright, they're ready.
http://fedora.ivazquez.net/yum/4/i386/RPMS.alternatives/dovecot-1.0-0.iva.5.... http://fedora.ivazquez.net/yum/4/i386/SRPMS.alternatives/dovecot-1.0-0.iva.5... http://fedora.ivazquez.net/yum/4/ppc/RPMS.alternatives/dovecot-1.0-0.iva.5.b... http://fedora.ivazquez.net/yum/4/ppc/SRPMS.alternatives/dovecot-1.0-0.iva.5.... http://fedora.ivazquez.net/yum/4/x86_64/RPMS.alternatives/dovecot-1.0-0.iva.... http://fedora.ivazquez.net/yum/4/x86_64/SRPMS.alternatives/dovecot-1.0-0.iva...
-- Ignacio Vazquez-Abrams ivazquez@ivazquez.net http://fedora.ivazquez.net/
gpg --keyserver hkp://subkeys.pgp.net --recv-key 38028b72
participants (5)
-
Axel Thimm
-
Curtis Maloney
-
Ignacio Vazquez-Abrams
-
Matthias Saou
-
Netlink Tech