Hi.

Thank you for the config, it differs from what you posted before!

Am Donnerstag, 29. März 2007 schrieb James Homuth:

As I wrote before, this can never work as this is a FIELD(-name) here and not a value. So it's passed to mysql without being quoted. This confuses mysql.

I didn't try for myself but your SQL log shows that authdaemon either does *NOT* substiture variables in these field statements but only in a custom MYSQL_SELECT_CLAUSE or that authdaemon substitutes variables only in a quoted string.

Please try two things:

1. Simply quote you home field: MYSQL_HOME_FIELD '/home/vmail/$(domain)/$(local_part)/'

if this does not work (I didn't try), I would recommand this:

2. Build a new MYSQL_SELECT_CLAUSE upon the Query authdaemon issues at the moment with proper quotations.

Try this

MYSQL_SELECT_CLAUSE SELECT email, password, '', 5000, 5000, \ '/home/vmail/$(domain)/$(local_part)/', '', '', '', '' \ FROM users WHERE email = '$(local_part)@$(domain)'

I wonder why the AUXOPTIONS-Field is not evaluated. I left it out because I think you can debug that if the other things are running.

An important note for debugging: run the mysql command line interpreter with the same login credentials as used in authmysqlrc and run the mysql query from the logfile in it when you encounter errors. MySQL will tell you what's wrong or give you the same results that authdaemon gets and you'll propably see what's wrong.

cu, Bernd