[imp] Prefs problem still
David Cake
dave@difference.com.au
Fri, 27 Jul 2001 04:28:44 +0800
>Quoting David Cake <dave@difference.com.au>:
>
>> My prefs are not being saved (or read). I'm running latest
>> cvs as of monday, mysql, and yes I have read previous posting and I
>> have updated to the latest cvs version of PEAR.
>> Ideas?
>
>Nope - can you check your mysql logs to see what's happening on that end?
I get occasional
>010726 0:13:52 Aborted connection 20 to db: 'horde' user:
>'hordemgr' host: `localhost' (Got an error reading communication
>packets)
Messages, but thats about it, and they don't appear to
coincide with anything. No error messages I can see. I checked that I
can read from mysql manually.
Regards
David
imp/config/conf.php includes
$conf['prefs']['driver'] = 'sql';
$conf['prefs']['params'] = array();
$conf['prefs']['params']['phptype'] = 'mysql';
$conf['prefs']['params']['hostspec'] = 'localhost';
$conf['prefs']['params']['username'] = 'hordemgr';
$conf['prefs']['params']['protocol'] = 'unix';
$conf['prefs']['params']['password'] = 'somepassword';
$conf['prefs']['params']['database'] = 'horde';
$conf['prefs']['params']['table'] = 'horde_prefs';
and a describe horde_prefs; in mysql returns
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| uid | varchar(32) | | PRI | | |
| scope | varchar(16) | | PRI | | |
| pref_name | varchar(32) | | PRI | | |
| pref_value | text | YES | | NULL | |
+------------+-------------+------+-----+---------+-------+