[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    |       |
+------------+-------------+------+-----+---------+-------+