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

[Hammad]

Your can attach and send me your horde/config/horde.php file and I'll check it 
for you.


--
Hammad


Quoting allie@daneman.net:

> Well see that'e the wierd part... I can log in manually fine so that's why
> I'm
> perplexed. Maybe I'll start over with the dist copy and see if maybe
> there's
> something fat fingered in the file. Has anyone else had this problem ????
> 
> Quoting Hammad <hammad@brisksolutions.com>:
> 
> > From the error you posted looks like its not picking up your username.
> Even
> > if 
> > it denies access it should say:
> > 
> > ['hordemgr@localhost' to database 'horde']
> > 
> > but your error says:
> > ['@localhost' to database 'horde']
> > 
> > Plus investigate this error you got:
> > HORDE [emergency] [imp] DB Error: insufficient permissions:
> > 
> > And, yes I did ran mysql_create script.
> > 
> > --
> > Hammad
> > 
> > 
> > Quoting allie@daneman.net:
> > 
> > > Thanks for the help I guess I should have mentioned that I've already
> done
> > > the
> > > majority if that. You can see below what my setup is.. Do I need to put
> > > anything
> > > in the auth params = array parameter ?
> > > $conf['auth']['params'] = array();
> > > I have it blank, but the following stanza is updated as you can see
> > farther
> > > down
> > > in this thread. Did you use the mysql_create script too ? What does
> your
> > > config
> > > look like (minus the password) ? It must be a config option that I've
> > > missed...but I can't figure out where.
> > > 
> > > Quoting Hammad <hammad@brisksolutions.com>:
> > > 
> > > > One, I think you need to change the $conf['prefs']['driver'] = 'sql';
> > you
> > > > have 
> > > > it as 'session'.
> > > > Second, Try to connect to mysql from command line first, see if you
> can.
> > > > Third, make sure you configured the following section in
> > > > horde/config/horde.php
> > > > 
> > > > $conf['auth']['driver'] = 'sql';
> > > > $conf['auth']['params'] = array();
> > > > 
> > > > $conf['auth']['params']['phptype'] = 'mysql';
> > > > $conf['auth']['params']['hostspec'] = 'localhost';
> > > > $conf['auth']['params']['username'] = 'horde';
> > > > $conf['auth']['params']['password'] = 'horde';
> > > > $conf['auth']['params']['database'] = 'horde';
> > > > $conf['auth']['params']['table'] = 'horde_users';
> > > > 
> > > > --
> > > > Hammad
> > > > 
> > > > 
> > > > Quoting allie@daneman.net:
> > > > 
> > > > > I tried it to no avail. Same error everytime:
> > > > > Dec 13 15:39:27 HORDE [emergency] [imp] DB Error: insufficient
> > > > permissions:
> > > > > 
> > > > > [nativecode=Access denied for user: '@localhost' to database
> 'horde']
> > > **
> > > > > 
> > > > > I'm using the mysql_create.sql script and changed the params per
> below
> > > > with
> > > > > no
> > > > > difference. I'm using horde-2.1 and imp-3.1. I'm just learning
> mysql
> > so
> > > > > that
> > > > > could be part of the problem. Any help would be greatly
> > > > appreciated....doing
> > > > > my
> > > > > preferences by session sucks.
> > > > > 
> > > > > $conf['prefs']['driver'] = 'session';
> > > > > 
> > > > > // Any parameters that the preferences driver needs. This includes
> > > > > // database or ldap server, username/password to connect with, etc.
> > > > > $conf['prefs']['params'] = array();
> > > > > 
> > > > > // 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'] = 'hordemgr';
> > > > > $conf['prefs']['params']['password'] = 'secret_password';
> > > > > $conf['prefs']['params']['database'] = 'horde';
> > > > > $conf['prefs']['params']['table'] = 'horde_prefs';
> > > > > 
> > > > > 
> > > > > Quoting Charly Root <root@papendorf-se.de>:
> > > > > 
> > > > > > I think this is probably because the default horde prefs use
> > > 'hordemgr'
> > > > as
> > > > > 
> > > > > > username but the mysql_create.sql uses 'horde', the
> mysql_create.sql
> > > > should
> > > > > 
> > > > > > look something like this:
> > > > > > 
> > > > > > REPLACE INTO user (host, user, password)
> > > > > >     VALUES (
> > > > > >         'localhost',
> > > > > >         'hordemgr',
> > > > > >   -- IMPORTANT: Change this password!
> > > > > >         password('secret')
> > > > > >     );
> > > > > > 
> > > > > > 
> > > > > > REPLACE INTO db (host, db, user, select_priv, insert_priv,
> > > update_priv,
> > > > > >                  delete_priv, create_priv, drop_priv)
> > > > > >     VALUES (
> > > > > >         'localhost',
> > > > > >         'horde',
> > > > > >         'hordemgr',
> > > > > >         'Y', 'Y', 'Y', 'Y',
> > > > > >         'Y', 'Y'
> > > > > >     );
> > > > > > 
> > > > > > FLUSH PRIVILEGES;
> > > > > > 
> > > > > 
> > > > > 
> > > > > 
> > > > > 
> > > > > -------------------------------------------------
> > > > > 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/
> 
>