[horde] Horde and SQL authentication

[bittehier at nurfuerspam.de]

Hello,
 
I want to use the sql database from postfixadmin (http://sourceforge.net/projects/postfixadmin/) to manage and authenticate users via horde.
 
I changed in imp/config/server.php:
 
'hordeauth' => full 
 
and in config/conf.php:
 
$conf['auth']['params']['phptype'] = 'mysql';
$conf['auth']['params']['socket'] = '/var/run/mysqld/mysqld.sock';
$conf['auth']['params']['protocol'] = 'unix';
$conf['auth']['params']['hostspec'] = 'localhost';
$conf['auth']['params']['username'] = 'postfix';
$conf['auth']['params']['password'] = XXXXXX';
$conf['auth']['params']['database'] = 'postfix';
$conf['auht']['params']['debug'] = 'true';
$conf['auth']['params']['query_auth'] = 'SELECT * FROM mailbox WHERE username = \L  AND password = MD5(\P);';
$conf['auth']['params']['query_add'] = INSERT INTO users (username,password,maildir) VALUES (\L, MD5(\P), '/var/mail/\L');
$conf['auth']['params']['query_getpw'] = 'SELECT password FROM mailbox WHERE username = \L;';
$conf['auth']['params']['query_update'] = 'UPDATE mailbox SET username = \L WHERE username = \O;';
$conf['auth']['params']['query_resetpassword'] = 'UPDATE mailbox SET password = MD5(\P) WHERE username = \L;';
$conf['auth']['params']['query_remove'] = 'DELETE FROM mailbox WHERE username = \L;';
$conf['auth']['params']['query_list'] = 'SELECT * FROM mailbox;';
$conf['auth']['params']['query_exists'] = 'SELECT 1 FROM mailbox WHERE username = \L;';
$conf['auth']['params']['encryption'] = 'crypt-md5';
$conf['auth']['params']['show_encryption'] = false;
$conf['auth']['driver'] = 'customsql';

But it doesn´t works! How can I enable debug only for authentication? Which sql queries are necessary for the login process?
 
Bye,
Michael
-- 
Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger