[commits] [Wiki] changed: SQLAuthHowTo

[Wiki Guest]

guest [70.119.195.245]  Tue, 21 Feb 2012 04:37:36 +0000

Modified page: http://wiki.horde.org/SQLAuthHowTo
New Revision:  21
Change log:  Fixed query_add

@@ -43,9 +43,9 @@

  If you are not using domains, then use the following queries:

  * For query_auth, enter: {{SELECT * FROM users WHERE userid = \L AND  
password = MD5(\P);}}
-* For query_add, enter: {{INSERT INTO users (userid,password,home)  
VALUES (\L, MD5(\P), '/home/\L');}} //NB: You may need to change the  
"home" value to point to their home directory or file space//
+* For query_add, enter: {{INSERT INTO users (userid,password,home)  
VALUES (\L, MD5(\P), concat('/home/',\L));}} //NB: You may need to  
change the "home" value to point to their home directory or file space//
  * For query_getpw, enter: {{SELECT password FROM users WHERE userid = \L;}}
  * For query_update, enter: {{UPDATE users SET userid = \L WHERE  
userid = \O) LIMIT 1;}}
  * For query_resetpassword, enter: {{UPDATE users SET password =  
MD5(\P) WHERE userid = \L;}}
  * For query_remove, enter: {{DELETE FROM users WHERE userid = \L;}}