HORDE [emergency] [imp] DB Error: insufficient permissions

[allie at daneman.net]

Thanks to everyone for your help so far...and I'm getting closer to solving
this. I checked my logs on mysqld and found the following info:

/usr/local/libexec/mysqld, Version: 3.23.49-log, started with:
Tcp port: 3306  Unix socket: /var/run/mysql/mysql.sock
Time                 Id Command    Argument
021215 14:42:31       1 Connect     Access denied for user: 'root@localhost'
(Using password: YES)
021215 14:45:25       2 Connect     Access denied for user: 'root@localhost'
(Using password: YES)
021215 14:45:36       3 Connect     Access denied for user: 'root@localhost'
(Using password: YES)
021215 14:46:14       4 Connect     Access denied for user: 'root@localhost'
(Using password: YES)

And my horde.php is below:
$conf['prefs']['driver'] = 'sql';
// This is an example configuration for a MySQL preference backend.
// The SQL script to setup the preference database is placed in
// horde/scripts/db/prefs.sql.
$conf['prefs']['params']['phptype'] = 'mysql';
$conf['prefs']['params']['hostspec'] = 'localhost';
$conf['prefs']['params']['username'] = 'horde';
$conf['prefs']['params']['password'] = 'XXXX';
$conf['prefs']['params']['database'] = 'horde';
$conf['prefs']['params']['table'] = 'horde_prefs';

So, can someone explain to me why Horde is trying to log in as root@localhost
when I'm explicitly using a username of horde ? I looked averywhere in all
config files and can't even find the word "root" in that context. Has anyone
seen this before ???? Or am I missing a config file to change it ? I guess I
could use the root user but I'd rather not for good reason. Any help would be
greatly appreciated.

Quoting Marc Fellman <mfellman@xs4all.nl>:

> Hi,
> 
> > ----- Bericht van allie@daneman.net ---------
> >     Datum: Fri, 13 Dec 2002 02:07:48 -0800
> >       Van: allie@daneman.net
> > Antwoorden aan:allie@daneman.net
> >  Onderwerp: HORDE [emergency] [imp] DB Error: insufficient permissions
> >       Aan: imp@lists.horde.org
> > 
> > 
> > I think I have a config problem but can't find adequate docs to help out.
> I
> > have an sql backend for imp preferences and I get the following error when
> > trying to use it:
> > 
> > Dec 13 01:13:24 HORDE [emergency] [imp] DB Error: insufficient
> permissions:
> > [nativecode=Access denied for user: '@localhost' to database 'horde'] **
> > Array
> > [on line 102 of "/var/www/horde/lib/Prefs/sql.php"]
> > 
> 
> Looks to me as if you have forgotten to fill the username in a config file.
> ('@localhost' probably should be 'horde@localhost') Look in the 
> horde/config/conf.php. I don't think that in horde/imp/config/conf.php there
> is 
> a section for a database (but you should check anyway). I can't look at my 
> configuration for an example but this could help (I hope).
> 
> 
> > Can anyone provide a little guidance... I'm thinking the fact that
> @localhost
> > without the username is part of it ;) I setup up the horde database per
> the
> > scripts in the db directory and tested the login manually successfully.
> > Hmmm......anyone ????
> > 
> > 
> <SNIP> ----- Einde bericht van allie@daneman.net -----
> 
> -- 
> M.Vr.Gr.
> 
> Marc Fellman
> 
> 
> 
> 
> -------------------------------------------------
> This mail sent through IMP: http://horde.org/imp/
> 
> -- 
> IMP mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe@lists.horde.org
> 




-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/