postfix virtual users on debian etch

Discussion in 'HOWTO-Related Questions' started by recklessop, Oct 31, 2007.

  1. recklessop

    recklessop New Member

    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, user=recklessop@gemcitystangs.com, 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, user=recklessop@gemcitystangs.com, 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, user=recklessop@gemcitystangs.com, 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?
     
  2. recklessop

    recklessop New Member

    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, user=recklessop@gemcitystangs.com, 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
     
  3. recklessop

    recklessop New Member

    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, user=recklessop@gemcitystangs.com, 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]
     
  4. recklessop

    recklessop New Member

    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:cool:
     
  5. macorama

    macorama New Member

    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.
    info@mail.com
    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, user=info@mail.com, 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
     
  6. falko

    falko Super Moderator ISPConfig Developer

    Did you restart Courier after your changes?
     
  7. macorama

    macorama New Member

    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.
     

Share This Page