[imp] Preference System Settings

[Michael Geier, CDM Systems Admin]

Is 'Horde' the name of the MySQL database on your server?
If the MySQL server is on localhost, did you specify localhost or the
servername?
Is the user that you specified allowed to connect from the above server?
(localhost or FQDN)

check your MySQL::user table for permissions for individuals.

-----Original Message-----
From: guillen@zeus.ccip.udg.mx [mailto:guillen@zeus.ccip.udg.mx]On
Behalf Of Guillermo Guillen Angel
Sent: Monday, November 26, 2001 10:49 AM
To: imp@lists.horde.org
Subject: Re: [imp] Preference System Settings


Hi.

I edited the horde.php file to add the parameters and when I try to log in
to IMP it sends me this message

A fatal error has occurred
                object(db_error)(10) {
                  ["error_message_prefix"]=>
                  string(0) ""
                  ["error_prepend"]=>
                  string(0) ""
                  ["error_append"]=>
                  string(0) ""
                  ["mode"]=>
                  int(1)
                  ["level"]=>
                  int(1024)
                  ["code"]=>
                  int(-24)
                  ["message"]=>
                  string(24) "DB Error: connect failed"
                  ["debuginfo"]=>
                  string(0) ""
                  ["userinfo"]=>
                  string(93) " [nativecode=Host 'zeus.ccip.udg.mx' is not
allowed to connect to this MySQL server] ** Array"
                  ["callback"]=>
                  NULL
                }
                [/usr/local/apache/htdocs/horde-2.0/lib/Prefs/sql.php :
102]


What can be causing this?

thanks

Guillén



"Michael Geier, CDM Systems Admin" wrote:

> $conf['prefs']['driver'] = 'sql';
>
> $conf['prefs']['params'] = array();
> $conf['prefs']['params']['phptype'] = 'mysql';
> $conf['prefs']['params']['hostspec'] = '[ insert host ]';
> $conf['prefs']['params']['username'] = '[ insert user ]';
> $conf['prefs']['params']['password'] = '[ insert pass ]';
> $conf['prefs']['params']['database'] = 'horde';
> $conf['prefs']['params']['table'] = 'horde_prefs';
>
> --
> IMP mailing list: http://horde.org/imp/
> Archive: http://marc.theaimsgroup.com/?l=imp&r=1&w=2
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe@lists.horde.org

--
+----------------------------------------------------------------------+

L.I. Guillermo Guillén Angel                 tels. 36194028  ext. 117
Jefe del                                           36196910
Centro de Computo de Investigación y Posgrado      36192379
CUCEI                                              36196017
Universidad de Guadalajara                         36503680
                                             fax.  36194028
+----------------------------------------------------------------------+