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

[Hammad]

I can't remember but its coming from either courier-imap or vpopmail. Are you 
using any of it. Which ever one is it, you will have to recompile it.

--
Hammad


Quoting allie@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/
> 
> 
> -- 
> IMP mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe@lists.horde.org
>