ok so im having problems getting logged in using outlook express as the client here is the log file /var/log/mail.log as it shows i cant login at all (pop3 or smtp) Oct 30 21:58:28 webserver1 authdaemond: modules="authmysql", daemons=5 Oct 30 21:58:28 webserver1 authdaemond: Installing libauthmysql Oct 30 21:58:28 webserver1 authdaemond: Installation complete: authmysql Oct 30 21:58:21 webserver1 postfix/master[2849]: daemon started -- version 2.3.8, configuration /etc/postfix Oct 30 22:01:25 webserver1 courierpop3login: Connection, ip=[::ffff:192.168.1.153] Oct 30 22:01:25 webserver1 courierpop3login: LOGIN FAILED, [email protected], ip=[::ffff:192.168.1.153] Oct 30 22:01:31 webserver1 courierpop3login: Disconnected, ip=[::ffff:192.168.1.153] Oct 30 22:01:42 webserver1 courierpop3login: Connection, ip=[::ffff:192.168.1.153] Oct 30 22:01:42 webserver1 courierpop3login: LOGIN FAILED, [email protected], ip=[::ffff:192.168.1.153] Oct 30 22:01:47 webserver1 courierpop3login: Disconnected, ip=[::ffff:192.168.1.153] Oct 30 22:03:52 webserver1 courierpop3login: Connection, ip=[::ffff:192.168.1.153] Oct 30 22:03:52 webserver1 courierpop3login: LOGIN FAILED, [email protected], ip=[::ffff:192.168.1.153] Oct 30 22:03:57 webserver1 courierpop3login: Disconnected, ip=[::ffff:192.168.1.153] Oct 30 22:04:37 webserver1 postfix/smtpd[3118]: connect from armada.debianbox.net[192.168.1.153] Oct 30 22:04:37 webserver1 postfix/smtpd[3118]: warning: armada.debianbox.net[192.168.1.153]: SASL LOGIN authentication faile$ Oct 30 22:04:37 webserver1 postfix/smtpd[3118]: lost connection after AUTH from armada.debianbox.net[192.168.1.153] i also checked /var/log/auth.log and found Oct 30 22:04:37 webserver1 postfix/smtpd[3118]: sql auxprop plugin using mysql engine Oct 30 22:04:37 webserver1 saslauthd[2869]: DEBUG: auth_pam: pam_authenticate failed: Authentication failure Oct 30 22:04:37 webserver1 saslauthd[2869]: do_auth : auth failure: [service=smtp] [realm=gemcitystangs.com] [mech=pam] [reason=PAM auth error] Oct 30 22:04:40 webserver1 saslauthd[2870]: DEBUG: auth_pam: pam_authenticate failed: Authentication failure Oct 30 22:04:40 webserver1 saslauthd[2870]: do_auth : auth failure: [service=smtp] [realm=gemcitystangs.com] [mech=pam] [reason=PAM auth error] any ideas?
just to add a little ive tried logging in through squirrelmail and it says : Unknown user or password incorrect. and the logs show: /var/log/mail.log Oct 30 22:29:17 webserver1 imapd: Connection, ip=[::ffff:127.0.0.1] Oct 30 22:29:17 webserver1 imapd: LOGIN FAILED, [email protected], ip=[::ffff:127.0.0.1] Oct 30 22:29:22 webserver1 imapd: LOGOUT, ip=[::ffff:127.0.0.1], rcvd=67, sent=332 its like the database isnt configured right or something but ive looked at it serveral times and logged in manually with my username and password and it all works and looks good
i think i found the problem and its within how the passwords are encrypted i turned up the debugging level and got this Oct 30 23:30:00 webserver1 authdaemond: received auth request, service=pop3, authtype=login Oct 30 23:30:00 webserver1 authdaemond: authmysql: trying this module Oct 30 23:30:00 webserver1 authdaemond: SQL query: SELECT email, password, "", 5000, 5000, "/home/vmail", CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_$ Oct 30 23:30:00 webserver1 authdaemond: supplied password 'mypasshere' does not match encrypted password 'Go/8AmrizFkOM' Oct 30 23:30:00 webserver1 courierpop3login: LOGIN FAILED, [email protected], ip=[::ffff:192.168.1.200] Oct 30 23:30:00 webserver1 authdaemond: authmysql: REJECT - try next module Oct 30 23:30:00 webserver1 authdaemond: FAIL, all modules rejected Oct 30 23:30:05 webserver1 courierpop3login: Disconnected, ip=[::ffff:192.168.1.200]
solved my own problem ... when i used the encrypt function on the cli it must not work, when i use phpmyadmin it worked without a charm... i wont delete the thread just incase someone is having the same issue and it helps
Hello! I've also followed the tutorial with no problem. But after I was done I couldn't login with imap nor pop3. All I get with telnet is: Code: Trying <IP>... Connected to <HOST>. Escape character is '^]'. +OK Hello there. [email protected] pass test -ERR Temporary problem, please try again later Connection closed by foreign host. Checking my /etc/log/mail.log I get this: Code: May 19 22:50:20 b098 courierpop3login: Connection, ip=[::ffff:84.168.27.40] May 19 22:50:39 b098 authdaemond: authmysql: MYSQL_USERNAME not set in /etc/courier/authmysqlrc. May 19 22:50:39 b098 courierpop3login: LOGIN FAILED, [email protected], ip=[::ffff:84.168.27.40] May 19 22:50:39 b098 courierpop3login: authentication error: Input/output error From this, I check my /etc/courier/authmysqlrc Code: MYSQL_SERVER 127.0.0.1 # tried also localhost, same problem MYSQL_USERNAME mail_admin MYSQL_PASSWORD test 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 I'm clueless. Does anyone has an idea? Best regards, Daniel
It's working now. I've done a few things one of them was restarting every service. I don't know, this could've be the solution.