[horde] troubleshooting - DB Error: connect failed

[Adrian DeBoer]

Folks:

I'm at the stage where I ma getting this error:

A fatal error has occurred:
DB Error: connect failed
[line 108 of /var/www/html/horde/lib/Prefs/sql.php]
Details have been logged for the administrator.

I looked through the archives and found this helpful
thread:

http://lists.horde.org/archives/horde/Week-of-Mon-20030602/007426.html

I don't think my horde.log is logging anything related
to the error...at least giving me any clues to what
the problem might be...

As Eric said:

The usual causes are:

1) Didn't properly setup your preferences storage
config, or made a typo/mistake
   when setting them up, or omitted something
important when setting them up.
2) You have a firewall, tcp_wrappers, or database
permissions  blocking the
   connection to the database
3) You are trying to connect over tcp when the
database is unix sockets only,
   or vice versa.
4) You have a bad user/password specified...

My setup:

1) Here is my horde.php Preferences setup - 

/**
 ** Preference System Settings
 **/

// 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();
$conf['prefs']['params']['phptype'] = 'mysql';
$conf['prefs']['params']['hostspec'] = 'localhost';
$conf['prefs']['params']['username'] = 'horde';
$conf['prefs']['params']['password'] = '*****';
//$conf['prefs']['params']['password'] = 'horde';
$conf['prefs']['params']['database'] = 'horde';
$conf['prefs']['params']['table'] = 'horde_prefs';

Am I supposed to use password as horde.  That is one
question I have:  What does that horde
username/password do....and where is it located - what
table??

2) I don't have a firewall.

3)???? Someone wanna point me in the right direction
of this one...

4) is he referring to the horde username/pass in the
preferences.....or one we created in the horde_users
through mysql..??

Hopefully someone can help me out...

Thanks again guys!

Adrian


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com