[horde] Can't seem to Login

[Mike Koponick]

Sebastian,

OK, I see now.

I commented out the line because I changed the password in the following
line (copy/paste action) I would think that since it was commented out, it
would read the next "password" line OK.

I'm still having login issues,

Here is a the /tmp/horde.log:

Nov 05 14:18:46 HORDE [error] [horde] FAILED LOGIN for horde [192.168.1.2]
to Horde [on line 43 of "/var/www/html/horde/login.php"]

BTW - I removed the commented line, just to make sure and also double
checked the driver line:

// What backend should we use for authenticating users to Horde? Valid
// options are currently 'imap', 'ldap', 'mcal', 'sql', and 'ftp'.
// $conf['auth']['driver'] = '';
$conf['auth']['driver'] = 'sql';

One question, I didn't see any info on the passwords being MD5'd...

Thanks for your help.

MIke

-----Original Message-----
From: s-beutel at gmx.de [mailto:s-beutel at gmx.de]
Sent: Tuesday, November 05, 2002 2:06 PM
To: Mike Koponick
Cc: horde at lists.horde.org
Subject: RE: [horde] Can't seem to Login


> Here is my horde.php for the authentication portion:
>
> // This is an example configuration for a MySQL preference backend.
> // The SQL script to setup the preference database is placed in
> // horde/scripts/db/prefs.sql.
> $conf['prefs']['params']['phptype'] = 'mysql';
> $conf['prefs']['params']['hostspec'] = 'localhost';
> $conf['prefs']['params']['username'] = 'horde';
> // $conf['prefs']['params']['password'] = '*****';
> $conf['prefs']['params']['password'] = 'milkyway';
> $conf['prefs']['params']['database'] = 'horde';
> $conf['prefs']['params']['table'] = 'horde_prefs';
>

That's what I thought. It's correct for the [prefs] section. For the [auth]
section, you need a similar array (copy it), but have to replace all
['prefs'] in the names with ['auth']; so the section should look like

$conf['auth']['params']['phptype'] = 'mysql';
$conf['auth']['params']['hostspec'] = 'localhost';
$conf['auth']['params']['username'] = 'horde';
$conf['auth']['params']['password'] = '*****';
$conf['auth']['params']['password'] = 'milkyway';
$conf['auth']['params']['database'] = 'horde';
$conf['auth']['params']['table'] = 'horde_prefs';

Don't forget to set the appropriate driver some lines above.

Btw., why did you comment the password line? This will certainly not work.
The user 'horde', pw 'horde' (or however you changed it) is the way how
horde
connects to mysql (Clearly: here, horde is a mysql user, not an entry in the
mysql horde users table). Commenting the pw line will make that connection
impossible.

Hope this helps.

Sebastian