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

[allie at daneman.net]

Recompile... how about just running courier as vpopmail ? Is this from personal
experience ? Also what boggles my mind is that I'm not using mysql for
authentication...just for preferences. Is it happening if authdaemon is running
as root ? I just want to know "why" this is happening to further strengthen your
theory. All I want is a sql backend for preferences only...or is that not the
best decision in the first place, should I go LDAP ?

Quoting Hammad <hammad@brisksolutions.com>:

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




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