""Bürkle wrote:
----------------------
##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...
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 ;-)
Yeah, the connection seems fine
So for me, it looks like that it is no database or connection problem, what
do you think?
I agree.
Good luck,
Rodrigo
3 messages in net.sourceforge.lists.courier-usersRe: AW: AW: [courier-users] authmysql...
