Login failed on irtual Users And Domains With Postfix, Courier, MySQL And SquirrelMai

Discussion in 'HOWTO-Related Questions' started by dennis00, Apr 23, 2009.

  1. dennis00

    dennis00 New Member

    Login failed on Virtual Users And Domains With Postfix, Courier, MySQL And Squirrels

    I have followed the plugin at http://howtoforge.com/virtual-users-domains-postfix-courier-mysql-squirrelmail-fedora-10.

    Unfortunately I keep on getting such errors:
    Code:
    Apr 23 21:57:40 dns2 imapd: Connection, ip=[::ffff:127.0.0.1]
    Apr 23 21:57:40 dns2 imapd: LOGIN FAILED, user=[email protected], ip=[::ffff:127.0.0.1]
    Apr 23 21:57:45 dns2 imapd: LOGOUT, ip=[::ffff:127.0.0.1], rcvd=50, sent=332
    Apr 23 21:59:01 dns2 imapd: Connection, ip=[::ffff:127.0.0.1]
    Apr 23 21:59:01 dns2 imapd: LOGIN FAILED, user=[email protected], ip=[::ffff:127.0.0.1]
    Apr 23 21:59:06 dns2 imapd: LOGOUT, ip=[::ffff:127.0.0.1], rcvd=54, sent=332
    Apr 23 21:59:38 dns2 pop3d: Connection, ip=[::ffff:85.92.131.100]
    Apr 23 21:59:38 dns2 pop3d: LOGIN FAILED, user=[email protected], ip=[::ffff:85.92.131.100]
    Apr 23 21:59:43 dns2 pop3d: Disconnected, ip=[::ffff:85.92.131.100]
    Apr 23 22:07:02 dns2 postfix/qmgr[26601]: 2D454570116: from=<[email protected]>, size=500, nrcpt=2 (queue active)
    Apr 23 22:07:02 dns2 postfix/smtp[2544]: connect to mail.mydomain.eu[93.105.102.15]:25: Connection refused
    Apr 23 22:07:02 dns2 postfix/smtp[2543]: connect to dns2.mydomain.nl[93.105.102.15]:25: Connection refused
    Apr 23 22:07:03 dns2 postfix/smtp[2544]: 2D454570116: to=<[email protected]>, relay=none, delay=1274, delays=1274/0.03/0/0, dsn=4.4.1, status=deferred (connect to mail.mydomain.eu[93.105.102.15]:25: Connection refused)
    Apr 23 22:07:04 dns2 postfix/smtp[2543]: 2D454570116: to=<[email protected]>, relay=none, delay=1274, delays=1274/0.03/0.02/0, dsn=4.4.1, status=deferred (connect to dns2.mydomain.nl[93.105.102.15]:25: Connection refused)
    [root@dns2 log]#
    I have tried both IMAP and Squirrelmail, both respond, but give login failed.
     
    Last edited: Apr 25, 2009
  2. dennis00

    dennis00 New Member

    Code:
    [root@dns2 log]# authtest [email protected] secret
    Authentication FAILED: Operation not permitted
     
  3. topdog

    topdog New Member HowtoForge Supporter

    check the error messages in /var/log/secure /var/log/messages and /var/log/audit/audit.log
     
  4. dennis00

    dennis00 New Member

    No lines written in /var/log/messages and /var/log/secure.

    Code:
    [root@dns2 log]# tail audit/audit.log
    type=USER_TTY msg=audit(1240562610.125:770919): user pid=15156 uid=0 auid=0 msg='history | grep auth'
    type=USER_TTY msg=audit(1240562613.909:770920): user pid=15156 uid=0 auid=0 msg='authtest [email protected] secret'
    type=USER_TTY msg=audit(1240562617.446:770921): user pid=15156 uid=0 auid=0 msg='tail messages'
    type=USER_TTY msg=audit(1240562622.965:770922): user pid=15156 uid=0 auid=0 msg='tail maillog'
    type=USER_TTY msg=audit(1240562630.118:770923): user pid=15156 uid=0 auid=0 msg='tail audit/audit.log 
     
  5. topdog

    topdog New Member HowtoForge Supporter

    I suspected it was selinux but it seems not.
     
  6. tebokkel

    tebokkel New Member

    Would you please see if you did step #10 from the HowTo? Especially if you added the authmodulelist and changed the MYSQL_PASSWORD to whatever you use?

    Paul
     
  7. dennis00

    dennis00 New Member

    Thanks for your response, it's seriously appreciated.

    I don't think I forgot anything from step 10 when I look back at the instructions, but I must've certainly done something wrong, as it doesn't properly work.

    Code:
    [root@dns2 ~]# grep authmodule /etc/authlib/authdaemonrc
    ##NAME: authmodulelist:2
    #authmodulelist="authuserdb authpam authpgsql authldap authcustom authpipe"
    authmodulelist="authmysql"
    ##NAME: authmodulelistorig:3
    authmodulelistorig="authuserdb authpam authpgsql authldap authcustom authpipe"
    [root@dns2 ~]#
    Code:
    [root@dns2 authlib]# cat /etc/authlib/authmysqlrc
    MYSQL_SERVER localhost
    MYSQL_USERNAME mail_admin
    MYSQL_PASSWORD mail_admin_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
    [root@dns2 authlib]#
    Code:
    [root@dns2 authlib]# mysql -umail_admin -pmail_admin_password
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 8314
    Server version: 5.1.34 MySQL Community Server (GPL) by Remi
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    mysql> quit
    Bye
    [root@dns2 authlib]#
    Code:
    [root@dns2 authlib]# chkconfig --levels 235 courier-imap on
    [root@dns2 authlib]# /etc/init.d/courier-authlib restart
    Stopping Courier authentication services: authdaemond
    Starting Courier authentication services: authdaemond
    [root@dns2 authlib]# /etc/init.d/courier-imap restart
    Stopping Courier-IMAP server: imap imap-ssl pop3 pop3-ssl
    Starting Courier-IMAP server: imap imap-ssl pop3 pop3-ssl
    [root@dns2 authlib]#
    I would honestly love to have this set-up working!

    Update: The logs show information, at last!
    Code:
    Apr 24 20:47:39 dns2 authdaemond: stopping authdaemond children
    Apr 24 20:47:40 dns2 authdaemond: modules="authmysql", daemons=5
    Apr 24 20:47:40 dns2 authdaemond: Installing libauthmysql
    Apr 24 20:47:40 dns2 authdaemond: libauthmysql.so: cannot open shared object file: No such file or directory
    Troubleshooting...
    Code:
    [root@dns2 log]# locate mysql | grep courier
    /home/dennis/rpm/BUILD/courier-authlib-0.62.1/README.authmysql.html
    /home/dennis/rpm/BUILD/courier-authlib-0.62.1/README.authmysql.myownquery
    /home/dennis/rpm/BUILD/courier-authlib-0.62.1/authmysql.c
    /home/dennis/rpm/BUILD/courier-authlib-0.62.1/authmysql.h
    /home/dennis/rpm/BUILD/courier-authlib-0.62.1/authmysqllib.c
    /home/dennis/rpm/BUILD/courier-authlib-0.62.1/authmysqlrc
    /home/dennis/rpm/BUILD/courier-authlib-0.62.1/authmysqlrc.h
    /home/dennis/rpm/BUILD/courier-authlib-0.62.1/configfiles.mysql
    /home/dennis/rpm/BUILD/courier-authlib-0.62.1/preauthmysql.c
    /home/dennis/rpm/BUILD/courier-authlib-0.62.1/.deps/authmysql.Plo
    /home/dennis/rpm/BUILD/courier-authlib-0.62.1/.deps/authmysqllib.Plo
    /home/dennis/rpm/BUILD/courier-authlib-0.62.1/.deps/preauthmysql.Plo
    /home/dennis/rpm/RPMS/i386/courier-authlib-mysql-0.62.1-1.i386.rpm
    /usr/share/doc/courier-authlib-0.62.1/README.authmysql.html
    /usr/share/doc/courier-authlib-0.62.1/README.authmysql.myownquery
    [root@dns2 log]#
    [root@dns2 log]# rpm -qa | grep auth
    authconfig-5.3.21-5.el5
    courier-authlib-devel-0.62.1-1
    courier-authlib-0.62.1-1
    courier-authlib-mysql-0.62.1-1
    [root@dns2 log]#
    [root@dns2 log]# locate libauthmysql.s
    [root@dns2 log]# locate libauthmysql.so
    rpm: no packages given for install
    [root@dns2 log]# rpm -Uvh --force /home/dennis/rpm/RPMS/i386/courier-authlib-mysql-0.62.1-1.i386.rpm
    Preparing...                ########################################### [100%]
       1:courier-authlib-mysql  ########################################### [100%]
    [root@dns2 log]# 
    Uhm...
     
    Last edited: Apr 24, 2009
  8. tebokkel

    tebokkel New Member

    ok.. so what's your status now?

    Hint: the locate-database is usually updated once a week or possibly daily, so any added files could take a while before they show up. The "find" command always lists current files, but takes longer.

    Would you please find the libauthmysql.so and run the ldd command on it?
    You should get output, stating which libraries are (dynamically) linked in this file. Perhaps that gives a hint where to look..

    Code:
    tebokkel@www1:/usr/lib/courier-authlib$ ldd libauthuserdb.so
            linux-gate.so.1 =>  (0xffffe000)
            libcourierauthcommon.so.0 => /usr/lib/courier-authlib/libcourierauthcommon.so.0 (0xb7f04000)
            libcrypt.so.1 => /lib/tls/i686/cmov/libcrypt.so.1 (0xb7ecf000)
            libgdbm.so.3 => /usr/lib/libgdbm.so.3 (0xb7ec9000)
            libc.so.6 => /lib/tls/i686/cmov/libc.so.6 (0xb7d98000)
            libcourierauth.so.0 => /usr/lib/courier-authlib/libcourierauth.so.0 (0xb7d8e000)
            /lib/ld-linux.so.2 (0x80000000)
    tebokkel@www1:/usr/lib/courier-authlib$ 
    Paul
     
  9. dennis00

    dennis00 New Member

    Unfortunately no improvement as of yet.

    Code:
    [root@dns2 ~]# updatedb
    [root@dns2 ~]# locate libauthmysql.so
    [root@dns2 ~]# rpm -qa | grep courier  | grep mysql
    courier-authlib-mysql-0.62.1-1
    [root@dns2 ~]#
    By rebuilding the rpm's using this howto I have been able to get the .so files installed.

    However still fails for authtest:
    Code:
    [root@dns2 log]# authtest [email protected] secret
    Authentication FAILED: Operation not permitted
    [root@dns2 log]# cat maillog
    [root@dns2 log]# locate libauthmysql.so
    /home/derk/rpm/BUILD/courier-authlib-0.62.1/.libs/libauthmysql.so
    /home/derk/rpm/BUILD/courier-authlib-0.62.1/.libs/libauthmysql.soT
    /usr/lib/courier-authlib/libauthmysql.so
    /usr/lib/courier-authlib/libauthmysql.so.0
    [root@dns2 log]#
     
    Last edited: Apr 25, 2009
  10. falko

    falko Super Moderator ISPConfig Developer

    Are you sure that SELinux is disabled? What's the output of
    Code:
    getenforce
    ?
     
  11. dennis00

    dennis00 New Member

    Code:
    [root@dns2 ~]# getenforce
    Disabled
    [root@dns2 ~]#
     
  12. dennis00

    dennis00 New Member

    If anybody can help me, it would be greatly appreciated.
     
  13. falko

    falko Super Moderator ISPConfig Developer

    I have no idea what's wrong. Did you compare your configuration with the one from the tutorial? Maybe you made a typo somewhere?
     
  14. dennis00

    dennis00 New Member

    I did compare the configurations. I will ask a freelancer to look at it or I might uninstall it and install a VMWare Virtual Machine and just use Plesk for hosting the e-mail using qmail.
     

Share This Page