(from the mysql client)
mysql> GRANT select,insert,update,delete ON squirrelmail.*
- TO squrreluser@localhost IDENTIFIED BY 'sqpassword';
+ TO squirreluser@localhost IDENTIFIED BY 'sqpassword';
The table structure should be similar to this (for MySQL):
Name) is specified, this can be done using either conf.pl or via the
administration plugin. The DSN should look something like:
- $addrbook_dsn = 'mysql://squirreluser:sqpassword@localhost/squirrelmail';
+ mysql://squirreluser:sqpassword@localhost/squirrelmail
From now on all users' personal addressbooks will be stored in a
database.
Configuring preferences in database
-----------------------------------
-There is no easy way to do this yet. You will have to remove
-functions/prefs.php and replace it with functions/db_prefs.php. Then
-edit the new functions/prefs.php (db_prefs.php) and change the $DSN to
-point to a database you create (can be the same you use for
-addressbooks). Create a table similar to this (for MySQL):
+This is done in much the same way as it is for storing your address
+books in a database.
+
+The table structure should be similar to this (for MySQL):
CREATE TABLE userprefs (
user varchar(128) DEFAULT '' NOT NULL,
PRIMARY KEY (user,prefkey)
);
+Next, edit your configuration so that the preferences DSN (Data Source
+Name) is specified, this can be done using either conf.pl or via the
+administration plugin. The DSN should look something like:
+
+ mysql://squirreluser:sqpassword@localhost/squirrelmail
+
+From now on all users' personal preferences will be stored in a
+database.
Default preferences can be set by altering the $default array in
-prefs.php (db_prefs.php).
+db_prefs.php.