[imp] Re: Can not get prefs from mysql db...

[dom]

Check your horde logs in /tmp/horde.log.  I had this issue pulling prefs
from the mysql db and it turned out to be a resolution issue.  The horde sql
scripts inserted localhost as the Host in the Host table, and mysql was
resolving the connection to be from localhost.localdomain.  MySQL is quite
picky when it comes to those things.  I used the following command to insert
another row in the DB tables in the mysql db to allow horde access to the
horde db:

use mysql;
insert into user (Host,User,Password)
values ('localhost.localdomain','horde','<INSERT MD5'ed PASSWORD FROM OTHER
ROW HERE>');

Of course test connectivity manually trying ' mysql -u horde -p', then enter
the password you chose in the sql script you originally ran.

Good Luck,
Dom


"Michael J. Pelletier" <mjpelletier at mjpelletier.com> wrote in message
news:1068619034.3fb1d51aa59c3 at www.mjpelletier.com...
Hello all,

I can not get save or retrieve prefs data from the MySQL DB. I always get
these
messages:
Nov 11 22:07:51 HORDE [notice] [imp] Failed retrieving prefs for mjpelletier
[on
line 315 of "/usr/local/HTTPS/horde/lib/Prefs/sql.php"]
Nov 11 22:17:08 HORDE [notice] [turba] Failed retrieving prefs for
mjpelletier
[on line 315 of "/usr/local/HTTPS/horde/lib/Prefs/sql.php"]
Nov 11 22:17:30 HORDE [notice] [horde] User mjpelletier [24.234.216.141]
logged
out of Horde [on line 23 of "/usr/local/HTTPS/horde/login.php"]
Nov 11 22:18:38 HORDE [notice] [horde] Failed retrieving prefs for
mjpelletier
[on line 315 of "/usr/local/HTTPS/horde/lib/Prefs/sql.php"]
Nov 11 22:20:08 HORDE [notice] [horde] User mjpelletier [24.234.216.141]
logged
out of Horde [on line 23 of "/usr/local/HTTPS/horde/login.php"]
Nov 11 22:22:59 HORDE [notice] [horde] Failed retrieving prefs for
mjpelletier
[on line 315 of "/usr/local/HTTPS/horde/lib/Prefs/sql.php"]
Nov 11 22:26:32 HORDE [notice] [imp] Failed retrieving prefs for mjpelletier
[on
line 315 of "/usr/local/HTTPS/horde/lib/Prefs/sql.php"]

My horde.php File has this:
$conf['prefs']['params']['phptype'] = 'mysql';
$conf['prefs']['params']['hostspec'] = 'localhost';
$conf['prefs']['params']['protocol'] = 'tcp';
$conf['prefs']['params']['username'] = 'horde';
$conf['prefs']['params']['password'] = '******'; (removed)
$conf['prefs']['params']['database'] = 'horde';
$conf['prefs']['params']['table'] = 'horde_prefs';


I am using PHP 4.3.4
MySQL 4.0.16
HORDE checked out via cvs as RELENG_2
IMP checked out via cvs as RELENG_3

Thanks inadvance,
Michael



----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

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