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

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

 

grr , problem fix , just a problem of a 'space' that was diving in my conf file

 

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