[commits] [Wiki] changed: SQLAuthHowTo

[Michael Rubinsky]

mrubinsk  Sat, 12 May 2012 02:33:06 +0000

Modified page: http://wiki.horde.org/SQLAuthHowTo
New Revision:  29
Change log:  This doesn't add anything, and you *can* change passwords  
with this.

@@ -58,18 +58,8 @@
  * For query_resetpassword, enter: {{UPDATE users SET password = \P  
WHERE userid = SUBSTRING_INDEX(\L, '@', 1) AND domain =  
SUBSTRING_INDEX(\L, '@', -1)}}
  * For query_remove, enter: {{DELETE FROM users WHERE userid =  
SUBSTRING_INDEX(\L, '@', 1) AND domain = SUBSTRING_INDEX(\L, '@', -1)}}
  * For query_list, enter: {{SELECT * FROM users}}
  * For query_exists, enter: {{SELECT 1 FROM users WHERE  
SUBSTRING_INDEX(\L, '@', 1) AND domain = SUBSTRING_INDEX(\L, '@', -1)}}
-
-''Comment from a user: please use howto for installing dovecot and  
postfix with mysql found here: ''
-
-http://wiki.dovecot.org/HowTo/DovecotLDAPostfixAdminMySQL
-
-'' Next you need to change the query for auth at least to:''
-For query_auth, enter: {{SELECT * FROM mailbox WHERE username = L AND  
password = P);}}
-Select the encrytption to md5-hex
-
-''This should do it to login, changing passwords and so on, will not  
work with this ''

  NB: We do not (in this wiki page) use the uid/gid fields.  If you  
need these fields, you will need to modify the queries to include  
them, as appropriate.  In the same vain, you could add additional  
fields as well, if needed or desired.

  If you need to use multiple virtual domains, you might see the web  
page  
http://wiki.vpslink.com/HOWTO:_ISP-style_Email_Server_with_Debian-Etch_and_Postfix_2.3 which could provide much inspiration for the sql database  
setup.