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

[Hammad]

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