Sorry, the problem was really stupid mistake at /etc/courier/authmysqlrc
now works like a charm. Thanks.
 
Edmundas
----- Original Message -----
Sent: Wednesday, November 08, 2006 4:10 PM
Subject: [Courier-imap] courier with mysql - can't get it work together

Hi,
i'm having trouble with courier pop3/imap service, i tried to figure it out myselft, but after two days i need your help.
I set up Debian-Sarge few days before and followed tutorial: http://workaround.org/articles/ispmail-sarge/
 
the error i'm getting is follow:
mail:~# tail /var/log/mail.log
Nov  8 15:35:39 mail courierpop3login: Connection, ip=[::ffff:127.0.0.1]
Nov  8 15:35:47 mail courierpop3login: LOGIN: DEBUG: ip=[::ffff:127.0.0.1], command=USER
Nov  8 15:35:51 mail courierpop3login: LOGIN: DEBUG: ip=[::ffff:127.0.0.1], command=PASS
Nov  8 15:35:51 mail courierpop3login: LOGIN: DEBUG: ip=[::ffff:127.0.0.1], [EMAIL PROTECTED]
Nov  8 15:35:51 mail courierpop3login: LOGIN: DEBUG: ip=[::ffff:127.0.0.1], password=secret
Nov  8 15:35:51 mail courierpop3login: authdaemon: starting client module
Nov  8 15:35:51 mail courierpop3login: authdaemon: TEMPFAIL - no more modules will be tried
Nov  8 15:35:56 mail courierpop3login: LOGIN FAILED, ip=[::ffff:127.0.0.1]
Nov  8 15:35:58 mail courierpop3login: LOGIN: DEBUG: ip=[::ffff:127.0.0.1], command=QUIT
Nov  8 15:35:58 mail courierpop3login: LOGOUT, ip=[::ffff:127.0.0.1]
I'm trying configure virtuals domains, so i'm using courier with mysql, smtp is already working.
Below are some details on my system config
 
I have mysql set up and running:
mail:~# netstat -tap | grep mysql
tcp        0      0 localhost.localdo:mysql *:*                     LISTEN     3805/mysqld
There are all needed tables, user mail_admin have access to it.
I can connect to mysql both through 127.0.0.1 and localhost by this command issued:
mail:~# mysql -h 127.0.0.1 -u mail_admin -p
 
/etc/courier/authdaemonrc contains:
authmodulelist="authmysql"
and /etc/courier/authmysqlrc contains:
MYSQL_SERVER            localhost
MYSQL_USERNAME          mail_admin
MYSQL_PASSWORD          mail_admin_password
MYSQL_PORT              0
MYSQL_OPT               0
MYSQL_DATABASE          mail
MYSQL_USER_TABLE        users
MYSQL_CLEAR_PWFIELD     password
MYSQL_UID_FIELD         5000
MYSQL_GID_FIELD         5000
MYSQL_LOGIN_FIELD       email
MYSQL_HOME_FIELD        '/home/vmail'
MYSQL_MAILDIR_FIELD     MYSQL_MAILDIR_FIELD CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')
 
(mail_admin_password - contains real password)
 
i checked it for trailing spaces as it is common problem
also maildir for email i'm trying to check mail for has maildir structure created as i sent mail there:
 
i have created all database mapping definitions files like said in tutorial i mentioned earlier.
 
I would appreciate for any help becouse i'm stucked as i think i checked everything more than twice and non of the solutions which helped other that i found on the net solve my problem and log isn't saying much about this problem.
 
Thanks.
Edmundas (from Lithuania)


-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642


_______________________________________________
Courier-imap mailing list
Courier-imap@lists.sourceforge.net
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-imap
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Courier-imap mailing list
Courier-imap@lists.sourceforge.net
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-imap

Reply via email to