[horde] troubleshooting - DB Error: connect failed

[Adrian DeBoer]

3) You are trying to connect over tcp when the
database is unix sockets only, or vice versa.

When I connect to my linux box from my windows box -
I'm using the freeware GUI for mysql - SQLyog - I
believe it connects TCP....it uses port 3306.

Does that mean the horde database could be using unix
sockets??  How do I determine this??  This seems funny
to me b/c I can log into the Horde Framwork just fine,
but when I try logging into the /kronolith part -
that's where I get the error...

Please someone help me!

--- Adrian DeBoer <stud_muffin_540 at yahoo.com> wrote:
> 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
> 
> -- 
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail:
horde-unsubscribe at lists.horde.org


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