[cvs] [Wiki] changed: SQLAuthHowTo

[Eric Rostetter]

ericr  Mon, 15 Sep 2008 23:23:49 -0400

Modified page: http://wiki.horde.org/SQLAuthHowTo
New Revision:  1.2
Change log:  Add some details...

@@ -1,4 +1,8 @@
+NOTE: This page is a work in progress, and has not been tested.  It may
+or may not be of any use, may contain numerous errors, and may turn your
+tongue a strange color.  Use at your own risk.
+
  First, install MySQL, following the directions found on numerous web  
sites on the internet.

  Next, install Horde and IMP, following directions elsewhere on this wiki.

@@ -17,13 +21,26 @@
  * Backup your horde/config/conf.php file
  * Backup any relevant MySQL databases
  * Log in to Horde as an administrative user.
  * Navigate: Administration -> Setup -> Horde select the Authentication tab.
-* Switch authentication backend to SQL authentication w/custom-made queries
+* Switch authentication backend ($conf[auth][driver]) to SQL  
authentication w/custom-made queries
+* Set the phptype setting to MySQL
+* Set the protocol setting to TCP/IP
+* Leave port as the default 5432
+* Set the hostspec to localhost
+* Set the username and password paramters to the SQL database  
username and password you set when creating the database
  * Set the encryption to use to store the password in the table to plain
-* Adjust Database/Table names to the ones defined when you configured  
dovecot.
-
-
-
-
+* Set the database field to the one defined when you configured  
dovecot's SQL database
+* For query auth, enter:
+SELECT * FROM users WHERE userid = \L AND password = MD5(\P);
+* For query_add, enter:
+INSERT INTO users (domain,userid,password) VALUES ('example.org', \L,  
MD5(\P));
+NB: Change the domain to your domain in the above query.
+* For query_update, enter:
+UPDATE users SET password = MD5(\P) WHERE userid =  
TRIM('@example.org' FROM \L) LIMIT 1;
+NB: Change the domain to your domain in the above query.
+* For query_remove, enter:
+DELETE FROM users WHERE userid = TRIM('@example.org' FROM \L) LIMIT 1;
+* For query_list, enter:
+SELECT * FROM users;