DokuWiki

It's better when it's simple

User Tools

Site Tools


auth:mysql_phorum

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
auth:mysql_phorum [2013-01-27 18:13] – old revision restored (2011/03/22 17:25) achauth:mysql_phorum [Unknown date] (current) – removed - external edit (Unknown date) 127.0.0.1
Line 1: Line 1:
-[[mysql|« MySQL Authentification Backend]] 
  
-====== Phorum ====== 
- 
-User authentication with [[http://phorum.org/|Phorum]]. 
- 
-Tested on Phorum version 5.1.24b and DokuWiki version 2007-06-26b.\\ 
-Update on 2008/12/07: works fine with Phorum 5.2.8 and DokuWiki 2008-05-05. 
- 
-This assumes that all user accounts will be created and maintained through Phorum. 
- 
-Do not forget to either create a "user" group in Phorum, or to add the name of the Phorum user group in the **conf/acl.auth.php** file. 
- 
-Eventually, change the table prefix in the queries below (here it is **phorum5**). 
- 
-<code php> 
-$conf['auth']['mysql']['checkPass'] = 
-    "SELECT password AS pass 
-    FROM phorum5_users 
-    WHERE username='%{user}' 
-    AND password=MD5('%{pass}')"; 
- 
-$conf['auth']['mysql']['getUserInfo'] = 
-    "SELECT password AS pass, username AS name, email AS mail 
-    FROM phorum5_users 
-    WHERE username='%{user}'"; 
- 
-$conf['auth']['mysql']['getGroups'] = 
-    "SELECT name AS `group` 
-    FROM phorum5_groups g, phorum5_users u, phorum5_user_group_xref ug 
-    WHERE u.user_id = ug.user_id 
-    AND g.group_id = ug.group_id 
-    AND u.username='%{user}' 
-    AND ug.status='1'"; 
- 
-</code> 
- 
- --- //[[yann@cactuspro.com|Yann Cochard]] 2007-11-22 22:22// 

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki