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

[Paolo Cavicchini]

I resolved the problem changing in the .sql scripts from "...@localhost" to
"...@<the_real_IP_address_of_the_server>".
It works.

Bye
Paolo


-----Messaggio originale-----
Da: imp-bounces@lists.horde.org [mailto:imp-bounces@lists.horde.org]Per
conto di BHilburn
Inviato: lunedì 16 dicembre 2002 15.48
A: allie@daneman.net; Hammad
Cc: imp@lists.horde.org
Oggetto: Re: HORDE [emergency] [imp] DB Error: insufficient permissions


I see this whenever a user or application tries to login to MySQL and does
not have and account, MySQL will try to use the 'anonymous' account
'@localhost'...

Login to MySQL as root, check that there is indeed an account for user
'horde' '@proper_machine', then try to login to MySQL as user horde from
that machine.

----- Original Message -----
From: <allie@daneman.net>
To: "Hammad" <hammad@brisksolutions.com>
Cc: <imp@lists.horde.org>
Sent: Sunday, December 15, 2002 12:52 AM
Subject: Re: HORDE [emergency] [imp] DB Error: insufficient permissions


> No difference... I keep gettting the same error everytime. I can =
reproduce
the
> output like so:
> # mysql --user= --password= horde
> ERROR 1044: Access denied for user: '@localhost' to database 'horde'
>
> So that mean it's a Horde problem ??????? Or still a config problem =
on my
end ???
> I have updated the correct parameters like so in horde.php under
preferences and
> logged in fine from the command line.
>
> // What preferences driver should we use? Valid values are 'none'
> // (meaning use system defaults and don't save any user preferences),
> // 'session' (preferences only persist during the login), 'ldap',
> // and 'sql'.
> $conf['prefs']['driver'] = 'sql';
>
> // 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'] = 'horde';
> $conf['prefs']['params']['password'] = 'the_correct_password';
> $conf['prefs']['params']['database'] = 'horde';
> $conf['prefs']['params']['table'] = 'horde_prefs';
>
>
> >> Dec 13 15:39:27 HORDE [emergency] [imp] DB Error: insufficient
> > permissions: [nativecode=Access denied for user: '@localhost' to
database
> 'horde'] **
>
>
>
>
> -------------------------------------------------
> 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
>



-- 
IMP mailing list
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: imp-unsubscribe@lists.horde.org