[cvs] [Wiki] changed: SQLAuthHowTo

[Jan Schneider]

jan  Thu, 06 Aug 2009 12:13:57 -0400

Modified page: http://wiki.horde.org/SQLAuthHowTo
New Revision:  1.19
Change log:  Re-apply 1.17 without removing all backslashes

@@ -61,8 +61,18 @@
  * For query_resetpassword, enter: {{UPDATE users SET password =  
MD5(\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.