LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Networking
User Name
Password
Linux - Networking This forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game.

Notices


Reply
  Search this Thread
Old 01-05-2005, 05:50 AM   #1
Gregi76
LQ Newbie
 
Registered: Jan 2005
Posts: 10

Rep: Reputation: 0
Question 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.
 
Old 01-05-2005, 06:25 AM   #2
rjlee
Senior Member
 
Registered: Jul 2004
Distribution: Ubuntu 7.04
Posts: 1,991

Rep: Reputation: 76
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.
 
Old 01-07-2005, 06:10 AM   #3
Gregi76
LQ Newbie
 
Registered: Jan 2005
Posts: 10

Original Poster
Rep: Reputation: 0
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
 
Old 01-07-2005, 07:31 AM   #4
maxut
Senior Member
 
Registered: May 2003
Location: istanbul
Distribution: debian - redhat - others
Posts: 1,188

Rep: Reputation: 50
Quote:
Originally posted by Gregi76

Jan 4 16:37:36 island authdaemond.mysql: failed to connect to mysql server (server=172.16.1.157, userid=postfix)
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.
 
Old 01-07-2005, 08:51 AM   #5
Gregi76
LQ Newbie
 
Registered: Jan 2005
Posts: 10

Original Poster
Rep: Reputation: 0
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
 
Old 01-07-2005, 09:22 AM   #6
Gregi76
LQ Newbie
 
Registered: Jan 2005
Posts: 10

Original Poster
Rep: Reputation: 0
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
backup email users to new server wauchula Linux - Newbie 2 10-11-2005 03:33 PM
Users can't log into Webmail - Error 500 Twistedlizzard Linux - Software 17 06-14-2005 04:37 AM
Email Server for remote users, can it be secure? javiergt Linux - Software 2 02-04-2005 09:44 AM
mailing list with 1000 users alaios Linux - Networking 2 12-09-2004 10:08 AM
Redhat 9 users , need help with email server ! Drogo Linux - Software 4 11-15-2003 07:06 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Networking

All times are GMT -5. The time now is 11:36 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration