I followed the How-To on Debian Etch / Postfix / mysql authentication, and I can send but not receive, I get this error in the log file: Jun 14 12:19:53 mail1 courierpop3login: LOGIN FAILED, [email protected], ip=[::ffff:72.130.152.161] Jun 14 12:19:58 mail1 courierpop3login: Disconnected, ip=[::ffff:72.130.152.161] Jun 14 12:20:03 mail1 courierpop3login: Connection, ip=[::ffff:209.242.153.18] the output on netstat -tap is: Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 localhost:10024 *:* LISTEN 15714/amavisd (mast tcp 0 0 localhost:10025 *:* LISTEN 15504/master tcp 0 0 localhost:mysql *:* LISTEN 2677/mysqld tcp 0 0 *:smtp *:* LISTEN 15504/master tcp6 0 0 *:imaps *:* LISTEN 11464/couriertcpd tcp6 0 0 *op3s *:* LISTEN 11493/couriertcpd tcp6 0 0 *op3 *:* LISTEN 16276/couriertcpd tcp6 0 0 *:imap2 *:* LISTEN 11447/couriertcpd tcp6 0 0 *:www *:* LISTEN 2406/apache2 tcp6 0 0 *:ssh *:* LISTEN 1047/sshd but I get no other errors anywhere, I can send mail, my mail client finds the courier pop3 server okay, so I don't think it's firewall (I checked) or mysql db, my authmysqlrc shows: MYSQL_SERVER localhost MYSQL_USERNAME mail_admin MYSQL_PASSWORD the_right_password MYSQL_PORT 0 MYSQL_DATABASE mail MYSQL_USER_TABLE users MYSQL_CRYPT_PWFIELD password #MYSQL_CLEAR_PWFIELD password MYSQL_UID_FIELD 5000 MYSQL_GID_FIELD 5000 MYSQL_LOGIN_FIELD email MYSQL_HOME_FIELD "/home/vmail" MYSQL_MAILDIR_FIELD CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') #MYSQL_NAME_FIELD MYSQL_QUOTA_FIELD quota Where else should I be looking, there's no apparent errors in auth.log Thanks, Cameron San Diego
Does your Courier configuration look exactly like the one in the tutorial (chapter 7, http://www.howtoforge.com/virtual_users_and_domains_with_postfix_debian_etch_p3 )? Is mydomainname.com in the domains table? Is [email protected] in the users table?
I found the problem, I followed the instructions correctly, but I had to change the mysql connection string in authmysqlrc from MYSQL_SERVER localhost in the instructions, to MYSQL_SERVER 127.0.0.1 now it works, seems Debian is picky about this sometimes Thanks, Cameron San Diego