[Postfix / courier / mysql]Temporary authentication failure from module authdaemon

Discussion in 'Installation/Configuration' started by b_52globemaster, Aug 23, 2006.

  1. b_52globemaster

    b_52globemaster New Member

    Hi i am using this Tuto http://workaround.org/articles/ispmail-sarge/#components

    and i i can't not make my users that are stored in mysql DB authentified

    mail:/var/log# courierauthtest [email protected] secret
    Trying authdaemon...
    Temporary authentication failure from module authdaemon
    Authentication FAILED!
    mail:/var/log#


    ok the DB content :
    mysql> select * from domains;
    +------------------+
    | domain |
    +------------------+
    | XXXX.XX |
    | virtual.test |
    +------------------+
    2 rows in set (0.22 sec)

    mysql> select * from users;
    +-----------------------+-------------+
    | email | password |
    +-----------------------+-------------+
    | [email protected] | test |
    | [email protected] | secret |
    +-----------------------+--------------+
    2 rows in set (0.04 sec)


    the content of /etc/courier/authmysqlrc

    MYSQL_SERVER 127.0.0.1
    MYSQL_USERNAME provider_admin
    MYSQL_PASSWORD root
    MYSQL_PORT 0
    MYSQL_DATABASE provider
    MYSQL_USER_TABLE users
    MYSQL_CRYPT_PWFIELD
    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(em$
    MYSQL_NAME_FIELD

    the content of /etc/courier/authdaemonrc:

    authmodulelist="authmysql"
    authmodulelistorig="authcustom authcram authuserdb authldap authpgsql #authmysql authpam




    and thanks
     
  2. b_52globemaster

    b_52globemaster New Member

    grr , problem fix , just a problem of a 'space' that was diving in my conf file :)
     
  3. falko

    falko Super Moderator ISPConfig Developer

    Yes, Courier is very finicky about the formatting... :rolleyes:
     

Share This Page