X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=doc%2Fdb-backend.txt;h=3712c3765889afcf8a1b0f11f43a7b06366d4c2b;hb=aaf168225bc5cc8def549a0a7e3d916d56c49751;hp=9c24ba5ad013f7ac1623f6c6b91d97cdfbdfd868;hpb=4dccdc0118cb0cf46e154170a2baa90a910d0b09;p=squirrelmail.git diff --git a/doc/db-backend.txt b/doc/db-backend.txt index 9c24ba5a..3712c376 100644 --- a/doc/db-backend.txt +++ b/doc/db-backend.txt @@ -40,7 +40,7 @@ For MySQL you would normally do something like: (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): @@ -60,7 +60,7 @@ Next, edit your configuration so that the address book 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: - $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. @@ -70,11 +70,10 @@ 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, @@ -83,7 +82,15 @@ addressbooks). Create a table similar to this (for MySQL): 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.