Hi - hoping someone can help me with a login problem I have on a system I have inherited and trying to replicate. The problem appears to be the fact that the authdaemond, I'm using mysql for authentication fails. The mysql table that holds the login details is not a default one as per the README.authmysql.html. So my understanding is that the "/usr/local/etc/authlib/authmysqlrc" file needs to have a specific "MYSQL_SELECT_CLAUSE" defined, but it is this that I cannot seem to get right.

My mysql tables fields are:

username type password home owner password_type suspended leftover

And a sample record looks like:

username | type | password | home | owner | password_type | suspended | leftover | +-----------------+---------+----------+------------------------------------ ---+----------+---------------+-----------+----------+ | julian | mailbox | julian | /fs/home/44/b/a/julian/users/julian | julian | Password | N | 0

cat /var/log/maillog Jul 25 10:55:52 wm01 authdaemond: stopping authdaemond children Jul 25 10:55:56 wm01 authdaemond: modules="authmysql", daemons=5 Jul 25 10:55:56 wm01 authdaemond: Installing libauthmysql Jul 25 10:55:56 wm01 authdaemond: Installation complete: authmysql

If I attempt to login via the web frontend it fails with "INVALID USERNAME OR PASSWORD" and the logfile has:

Jul 25 11:08:19 wm01 authdaemond: received auth request, service=webmail, authtype=login Jul 25 11:08:19 wm01 authdaemond: authmysql: trying this module Jul 25 11:08:19 wm01 authdaemond: SQL query: SELECT username,password,home,owner,type FROM mailboxes where username='julian' Jul 25 11:08:19 wm01 authdaemond: incomplete row, only 5 fields returned Jul 25 11:08:19 wm01 authdaemond: authmysql: TEMPFAIL - no more modules will be tried Jul 25 11:08:19 wm01 sqwebmaild: LOGIN FAILED, user=julian, ip=[x.x.x.x]

So I see that it states there are only 5 fields returned, but based on my table layout what fields do I need to be used?

Apologies if I've missed anything, or if this seems a bit vague but I've hit a brick wall trying to get this to work.

Thanks - Julian.

Julian Grunnell 3rd Line Technical Support Pipex Communications

Tel: 0113 344 1304 Mob: 07803 649593 Web: http://www.pipex.com/

This e-mail is subject to: http://www.pipex.net/disclaimer.html