HORDE [emergency] [imp] DB Error: insufficient permissions
Hammad
hammad at brisksolutions.com
Mon Dec 16 01:34:58 PST 2002
You can try running as vpopmail, you might get away without having to recompile
it. You will only have to recompile if you didn't compile courier-imap as
vpopmail before. But I think you should run courier-imap services as vpopmail
user not as root (For security reason's too). I don't use authdaemon so can't
tell you more about it, I use mysql as backend which is working great for me so
far. I recommend mysql but its personal choice.
I think your problem has something to do with courier-imap or vpopmail, I
suspect courier-imap. I don't think it has anything to do with horde/imp
Good Luck, let me know how it turns out.
--
Hammad
Quoting allie@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/
>
>
More information about the imp
mailing list