[cvs] [Wiki] changed: SQLAuthHowTo

[Wiki Guest]

guest [128.83.155.230]  Tue, 16 Sep 2008 17:13:11 -0400

Modified page: http://wiki.horde.org/SQLAuthHowTo
New Revision:  1.9
Change log:  italics for NB:

@@ -27,13 +27,12 @@
  * 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  
crypt-md5 (is this correct?)
  * 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.
+* 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_getpw, enter: {{SELECT password FROM users WHERE userid = \L;}}
-* For query_update, enter: {{UPDATE users SET userid = \L WHERE  
userid = TRIM('@example.org' FROM \O) LIMIT 1;}} NB: Change the domain  
to your domain in the above query.
-* For query_resetpassword, 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_update, enter: {{UPDATE users SET userid = \L WHERE  
userid = TRIM('@example.org' FROM \O) LIMIT 1;}} \\NB: Change the  
domain to your domain in the above query.
+* For query_resetpassword, 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;}}
  * For query_exists, enter: {{SELECT 1 FROM users WHERE userid = \L;}}