Email Server for 500-1000 users
 

Hi,

I am looking for a sturdy mail server that could serve for a middle sized company. What is needed is imap, multi domain support, quotas, webmail and web admin possibility.

I have already tried to install on RH9 the mysql, imap, postfix, postfix admin combo, but the problem what I have is that imap can't connect to the mysql database, to retreive folders. It says password or username is not correct.
Even though I can connect to mysql with the user and password that is given in the authmysql file.
What logs do you need to be able to help me on this?

OR

I read on another forum that there is qmail toaster that is a sort of easy to install mail server. Is there a quota support in it? Would it be sufficent for an environment like I was talking about?

Thanks for any help.

I don't know about qmail-toaster, but qmail itself is designed for small to medium scale email servers so I would suggest sticking with procmail.

Firstly, check your logs in /var/log/messages and in the postfix's error logs.

This could either be that mysql isn't configured to accept network connections, that a firewall is blocking the connection, or MySQL and postfix have differing connection configurations.

Here is the /var/log/messages file:

Jan 2 04:02:05 island syslogd 1.4.1: restart.
Jan 4 16:31:27 island postfix: succeeded

I think it doeasn't indicate any important things.

But here is the maillog file as well:

Jan 4 16:37:29 island imapd: LOGIN FAILED, ip=[::ffff:172.16.1.156]
Jan 4 16:37:36 island imapd: LOGIN: DEBUG: ip=[::ffff:172.16.1.156], command=LOGIN
Jan 4 16:37:36 island imapd: LOGIN: DEBUG: ip=[::ffff:172.16.1.156], username=xy@acomm.ch
Jan 4 16:37:36 island imapd: LOGIN: DEBUG: ip=[::ffff:172.16.1.156], password=xxxxxxxx
Jan 4 16:37:36 island imapd: authdaemon: starting client module
Jan 4 16:37:36 island authdaemond.mysql: received auth request, service=imap, authtype=login
Jan 4 16:37:36 island authdaemond.mysql: authmysql: trying this module
Jan 4 16:37:36 island authdaemond.mysql: failed to connect to mysql server (server=172.16.1.157, userid=postfix)
Jan 4 16:37:36 island authdaemond.mysql: authmysql: TEMPFAIL - no more modules will be tried
Jan 4 16:37:36 island imapd: authdaemon: TEMPFAIL - no more modules will be tried
Jan 4 16:37:41 island imapd: LOGIN FAILED, ip=[::ffff:172.16.1.156]
Jan 4 16:37:46 island imapd: DISCONNECTED, ip=[::ffff:172.16.1.156], time=10

Hope you can give me some more hints on what to do with this.
Thanks

as u see it cannot connet to mysql database with postfix. check mysql settings.
im not familiar to postfix, i cannot help u about postfix. i use qmail.
i have tried qmail-toaster rpms but i prefer to install qmail by following the guide at www.qmailrocks.org . if u install qmail from www.qmailrocks.org , i think u will have all of features that u want.

good luck.

I think there are some improvements, but there is still something wrong, here is the maillog:

Jan 7 15:49:48 island imapd: LOGIN: DEBUG: ip=[::ffff:172.16.1.156], command=LOGIN
Jan 7 15:49:48 island imapd: LOGIN: DEBUG: ip=[::ffff:172.16.1.156], username=xy@acomm.ch
Jan 7 15:49:48 island imapd: LOGIN: DEBUG: ip=[::ffff:172.16.1.156], password=xxxxxx
Jan 7 15:49:48 island imapd: authdaemon: starting client module
Jan 7 15:49:48 island authdaemond.mysql: received auth request, service=imap, authtype=login
Jan 7 15:49:48 island authdaemond.mysql: authmysql: trying this module
Jan 7 15:49:48 island authdaemond.mysql: SQL query: SELECT username, password, "", '89', '89', '/usr/local/virtual', maildir, quota, name, "" FROM mailbox WHERE username = "xy@acomm.ch" AND (server='172.16.1.157')
Jan 7 15:49:48 island authdaemond.mysql: mysql_query failed, reconnecting
Jan 7 15:49:48 island authdaemond.mysql: mysql_query failed second time, giving up
Jan 7 15:49:48 island authdaemond.mysql: authmysql: TEMPFAIL - no more modules will be tried
Jan 7 15:49:48 island imapd: authdaemon: TEMPFAIL - no more modules will be tried
Jan 7 15:49:53 island imapd: LOGIN FAILED, ip=[::ffff:172.16.1.156]
Jan 7 15:50:00 island imapd: DISCONNECTED, ip=[::ffff:172.16.1.156], time=12

thanks

In fact I found the problem.

In the authmysqlrc file, for the MYSQL_WHERE_CLAUSE I put the server's IP. But it needs to be commented out. (in my case of course)

And for the previous problems, I've changed the password to the ones that are in the "how to" that I followed.

thanks for all