[cvs] [Wiki] changed: SQLAuthHowTo

[Eric Rostetter]

ericr  Mon, 15 Sep 2008 23:28:03 -0400

Modified page: http://wiki.horde.org/SQLAuthHowTo
New Revision:  1.3
Change log:  small fixes...

@@ -27,11 +27,11 @@
  * 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
-* Set the database field to the one defined when you configured  
dovecot's SQL database
-* For query auth, enter:
+* Set the encryption to use to store the password in the table to crypt-md5?
+* Set the database field to the one defined when you configured  
dovecot's SQL database (in this case, we will use "users" like on the  
dovecot website)
+* 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.
@@ -41,6 +41,6 @@
  * For query_remove, enter:
  DELETE FROM users WHERE userid = TRIM('@example.org' FROM \L) LIMIT 1;
  * For query_list, enter:
  SELECT * FROM users;
-
+* and so on for the other queries...