[horde] Horde Administrator login failed

[Simon Gao]

Here is my setting for MySQL part:

$conf['sql']['phptype'] = 'mysql';
$conf['sql']['protocol'] = 'tcp';
$conf['sql']['hostspec'] = 'localhost';
$conf['sql']['username'] = 'horde';
$conf['sql']['password'] = 'horde';
$conf['sql']['database'] = 'horde';

horde authenticates successfully with MySQL. I have tried to specify 
socket and port, but it does not help at all.

When setting password for MySQL user, does it use MD5? So maybe the 
problem is generating a MD5 based password?

Simon





Jan Schneider wrote:

>Zitat von Simon Gao <sgao at sci.utah.edu>:
>
>  
>
>>Add horde as one admin user, then add horde to horde_users table with
>>the password extracted from the table, user,  of mysql database.
>>
>>Here is the setting for Horde Authentication in conf.php:
>>
>>
>>$conf['auth']['admins'] = array('root', 'horde');
>>$conf['auth']['driver'] = 'sql';
>>$conf['auth']['params'] = array();
>>    
>>
>
>Did you fill in the sql params further up? Are you able to authenticate at
>all? Or do you just don't get admin rights?
>
>  
>
>>What's the difference between sql and cyrsql?  What kind of password
>>    
>>
>
>You don't need cyrsql. It's a special driver for a sql driven cyrus servers.
>
>  
>
>>scheme is used for Horde auth, plaintext, crypt, md5?
>>    
>>
>
>If you use sql auth, md5.
>
>Jan.
>
>--
>http://www.horde.org - The Horde Project
>http://www.ammma.de - discover your knowledge
>http://www.tip4all.de - Deine private Tippgemeinschaft
>  
>