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

[Hammad]

I think you compiled courier-imap as root user. You should compile as vpopmail 
user which you probably have created when installing vpopmail. Also vpopmail 
needs to be compile and installed first then courier-imap. Read courier-imap 
documentation its all in there, courier-imap connects to mysql database through 
vpopmail. Also read vpopmail/README.mysql

Hope this helps.

--
Hammad


Quoting allie@daneman.net:

> Huh ? Can you explain a little more as to why this is happening and how it
> could
> be courier-imap/vpopmail ? I run both ;) 
> 
> Quoting Hammad <hammad@brisksolutions.com>:
> 
> > 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
> > > 
> > 
> > 
> > 
> 
> 
> 
> 
> -------------------------------------------------
> This mail sent through IMP: http://horde.org/imp/
> 
>