[horde] Authentication: Horde-2.2.4 / MySQL

[Jan Schneider]

Zitat von Leonard R Smith II <lrsmith at umich.edu>:

>
> To all,
> 	I am trying to set up a fresh install of horde-2.2.4, using
> MySQL 4.0.x for authentication, on Solaris 8.
>
> 	I've followed the INSTALL docs and created the database and
> popultate horde_users with accounts, where the passwords are MD5 and not
> MySQLs password. However I am running into problems with the
> communication
> between horde and MySQL.
>
> # Syslog excerpt
>
> Sep 12 22:33:35 foo.bar.org HORDE[11009]: [ID 800047 syslog.emerg]
> [horde]
> Unable to connect to SQL server. [on line 119 of
> "/opt/www/htdocs/horde/lib/Auth/sql.php"]
>
> # Excerpt from MySQL Log 030912 22:33:35 6 Connect Access denied for
> user:
> 'root at localhost' (Using password: YES)
>
> It looks like Horde is trying to connect to the database as root rather
> than the "horde" account. My config/horde.php has
>
> $conf['auth']['driver'] = 'sql';
> $conf['auth']['params'] = array();
> $conf['auth']['params']['phptype'] = 'mysql';
> $conf['auth']['params']['hostspec'] = 'localhost';
> $conf['auth']['params']['username'] = 'horde';
> $conf['auth']['params']['password'] = '<password>';
> $conf['auth']['params']['database'] = 'horde';
> $conf['auth']['params']['table'] = 'horde_users';

This looks good, but make sure that you don't overwrite this setting (e.g.
by a copy and paste error) later in the configuration script.

Jan.

--
http://www.horde.org - The Horde Project
http://www.ammma.de - discover your knowledge
http://www.tip4all.de - Deine private Tippgemeinschaft