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

Hammad hammad at brisksolutions.com
Fri Dec 13 21:42:26 PST 2002


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
> 




More information about the imp mailing list