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

[Marcus Buettemeyer]

Hi and thanks for the fast response!
I'm starting to get the Problem and maybe this List is the wrong place 
to ask, maybe debian-users would be better :-/ Any Debian Users around??
On Woody, I have 4 "mysql_create.sql" Scripts (and a .in) lying around, 
but none of them contain any Grant Statements. But again, since I can 
connect to the MySQL DB using the "mysql" command I assume the DB Setup 
(at least for authentication) is OK

And for modifying  Line 155 in horde.php, my file only contains the 
following 19 Lines:
---cut here
<?php

$default->horde_root_url        = '/horde';
$default->horde_graphics_url    = '/horde/graphics';
$default->faq_url               = 'http://faq.horde.org/';
$default->horde_include_dir     = './templates';

/* Path to sendmail */
$default->path_to_sendmail      = '/usr/sbin/sendmail';

/* Problem Reporting */
$default->problem_email         = 'root at localhost';
$default->problem_reporting     = false;

/* Account Signup */
$default->signup_email          = 'root at localhost';
$default->signup                = false;

?>
---cut here

But then again, I wouldn't mind not having an options link, if I could 
get anything at all! Has anybody got the Debian-Stable DEBs to work? I 
would really like to stay within the distribution as opposed to "roll 
your own"...

Thnx -mb

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

-- 
Marcus Büttemeyer - Security Consultant
secuworks - security integration services
Heiliger Weg 15 - 44135 Dortmund - Germany
Tel:  +49-231-5346670  Fax: +49-231-5346670
Cell: +49-172-9727552  Web: www.secuworks.net