---------------------- ##VERSION: $Id: authmysqlrc,v 1.14 2003/05/09 18:15:15 mrsam Exp $ MYSQL_SERVER 127.0.0.1 MYSQL_USERNAME courier MYSQL_PASSWORD ******* MYSQL_PORT 3306 MYSQL_OPT 0 MYSQL_DATABASE mailuser MYSQL_USER_TABLE user MYSQL_CLEAR_PWFIELD passwd MYSQL_UID_FIELD uid MYSQL_GID_FIELD gid MYSQL_LOGIN_FIELD id MYSQL_HOME_FIELD home MYSQL_QUOTA_FIELD concat(quota_size * 1024, "S")
# MYSQL_SELECT_CLAUSE SELECT concat(id, "@mydomain.com"),"",passwd,uid,gid,home,"",concat(quota_size * 1024, "S"),"" FROM user WHERE id = "$(local_part)"
----------------------
Try to change your MYSQL_SELECT_CLAUSE to (spreading to 5 different lines as shown):
MYSQL_SELECT_CLAUSE SELECT concat(id, \ '@mydomain.com'), '', passwd, uid, \ gid, home, '', \ concat(quota_size * 1024, 'S'), '' \ FROM user WHERE id = '$(local_part)'
Strange problems sometimes demand strange solutions...
Yeah, the connection seems fine
About the connection: With the commented MYSQL_SELECT_CLAUSE it works perfect, but when its uncommented its not working at all (just a connect to the mysql, but no query). So both time it should use the same connection, because i just change the single line, or?
About the error "450 Service temporarily unavailable": I tested and found, that when i, for example, change the tablename to a non-existing one, i get the same error. -> So i think its the standard message for those kind of "get-nothing-back-from-database" errors ;-)
I agree.So for me, it looks like that it is no database or connection problem, what do you think?
Good luck,
Rodrigo
-- ---------------------------------------------------- Rodrigo Severo F�brica de Id�ias Fone: +55(61)321 1357 Fax: +55(61)223 1712 SBS - Quadra 2 - Ed. Empire Center - Sala 1301 Bras�lia/DF - Brasil CEP: 70.070-904 ----------------------------------------------------
------------------------------------------------------- This SF.net email is sponsored by: SF.net Giveback Program. Does SourceForge.net help you be more productive? Does it help you create better code? SHARE THE LOVE, and help us help YOU! Click Here: http://sourceforge.net/donate/ _______________________________________________ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
