[horde] Cannot Login to Horde...

[KimJohn Quinn]

K, I'm about to jump out a window here...

I have Horde and every concievable plug-in probably installed.  I just
cannot seem to login.

I can see the connection to the db from horde and I can see the records for
the users in the mysql tables when i do it manually.

I run horde on a RHLinux 8 and mysql on a win2k server.  Another app in PHP
I have works fine connecting to the MySQL.

When I go to connect from here, no matter what the setting - it tells me
possibly my password is wrong and maintains the login.

Here are my horde.php settings again...

$conf['auth']['driver'] = 'sql';

// An array holding any parameters that the Auth object will need to
// function correctly.
$conf['auth']['params'] = array();

$conf['auth']['params']['phptype'] = 'mysql';
$conf['auth']['params']['hostspec'] = 's02-w2k';
$conf['auth']['params']['username'] = 'root';
$conf['auth']['params']['password'] = '';
$conf['auth']['params']['database'] = 'horde';
$conf['auth']['params']['table'] = 'horde_users';

...

// What preferences driver should we use? Valid values are 'none'
// (meaning use system defaults and don't save any user preferences),
// 'session' (preferences only persist during the login), 'ldap',
// and 'sql'.
$conf['prefs']['driver'] = 'sql';

// Any parameters that the preferences driver needs. This includes
// database or ldap server, username/password to connect with, etc.
$conf['prefs']['params'] = array();

// 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'] = 's02-w2k';
$conf['prefs']['params']['username'] = 'root';
$conf['prefs']['params']['password'] = '';
$conf['prefs']['params']['database'] = 'horde';
$conf['prefs']['params']['table'] = 'horde_prefs';


Here is another snippet from my error log...

May 01 17:25:15 HORDE [emergency] [horde] Unable to connect to SQL server.
[on line 125 of "/data/www/html/horde/lib/Auth/sql.php"]
May 01 17:25:55 HORDE [emergency] [horde] Unable to connect to SQL server.
[on line 125 of "/data/www/html/horde/lib/Auth/sql.php"]
May 01 17:28:12 HORDE [error] [horde] FAILED LOGIN for dwampler
[192.168.1.201] to Horde [on line 43 of "/data/www/html/horde/login.php"]
May 01 17:28:17 HORDE [error] [horde] FAILED LOGIN for dwampler
[192.168.1.201] to Horde [on line 43 of "/data/www/html/horde/login.php"]
May 01 17:29:49 HORDE [error] [horde] FAILED LOGIN for dwampler
[192.168.1.201] to Horde [on line 43 of "/data/www/html/horde/login.php"]
May 01 17:33:32 HORDE [error] [horde] FAILED LOGIN for dwampler
[192.168.1.201] to Horde [on line 43 of "/data/www/html/horde/login.php"]
May 01 17:34:04 HORDE [error] [horde] FAILED LOGIN for kjq [192.168.1.201]
to Horde [on line 43 of "/data/www/html/horde/login.php"]
May 01 17:38:22 HORDE [error] [horde] FAILED LOGIN for test [192.168.1.201]
to Horde [on line 43 of "/data/www/html/horde/login.php"]
May 01 17:44:54 HORDE [error] [horde] FAILED LOGIN for dwampler
[192.168.1.201] to Horde [on line 43 of "/data/www/html/horde/login.php"]
May 01 17:52:14 HORDE [emergency] [horde] Unable to connect to SQL server.
[on line 118 of "/data/www/html/horde/lib/Auth/sql.php"]
May 01 17:52:35 HORDE [emergency] [horde] Unable to connect to SQL server.
[on line 118 of "/data/www/html/horde/lib/Auth/sql.php"]

Somebody please give offer some insight as to what I can look at or do to
fix this?  I just dont seem to be getting anywhere after a considerable
amount of time on it.

Thanks.


KimJohn Quinn
kjq at logicentrix.com