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

[allie at 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/