[imp] Access denied for user ... in /etc/horde/db_mysql.inc on line 73

[Paul Norris]

Hi Marcus,

There are two places you need to set the password.  Firstly in 
/<path-to-horde>/scripts/db/mysql_create.sql
In this script, the user name and password are both set to "horde".  You 
should run mysql_drop.sql, then set the password (and username if you want) 
in mysql_create.sql and then re-run it.  mysql_create.sql will also do the 
necessary GRANT statement so you don't have to do it yourself.

The second place is in /<path-to-horde>/config/horde.php (the place where I 
had my own recent problem).  Around line 155 you will find Preference 
System Headings.  There is a password in this section, and this is the one 
that will be giving you the error.  The distribution file has a password of 
'*****'.  Your horde won't work unless you set the password to the same 
thing as you have in mysql_create.sql

Also, don't forget to set your $conf ['prefs'] ['driver'] = 'sql'

I forgot so I didn't get any options link.

Hope this helps!

-----Original Message-----
From:	Marcus Buettemeyer [SMTP:mb at secuworks.net]
Sent:	Thursday, March 11, 2004 6:59 AM
To:	imp at lists.horde.org
Subject:	Re: [imp] Access denied for user ... in /etc/horde/db_mysql.inc 
on	line	73

Update: I found a message in the Archives which refers to GRANTing
access to the DB-User, so I did:

mysql> GRANT ALL PRIVILEGES ON horde.* TO 'hordemgr'@'localhost'
IDENTIFIED BY 'T0P_S3CR3T';

The effect, unfortunately, is still the same error message :-/ I
expected that, since dpkg created the correct tables, so DB-Access seems
to be fine.

Bye -mb


--
IMP mailing list - Join the hunt: http://horde.org/bounties/#imp
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: imp-unsubscribe at lists.horde.org