[horde] Authentication: Horde-2.2.4 / MySQL

Leonard R Smith II lrsmith at umich.edu
Fri Sep 12 19:44:49 PDT 2003


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';


Shouldn't this cause horde to try and connect to the MySQL database as
horde using <password>? I verified the account exists in the user table,
in the mysql database and that I could connect to the MySQL database using
that pair.

	I checked the config files and I did not find anything to indicate
why horde is trying to connect as root. Any help on what I am missing
would be appreciated.

				Thanks,
					len





More information about the horde mailing list