Differences

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

--- auth:mysql_nuked-klan [2011-03-22 17:31] – Aleksandr
+++ auth:mysql_nuked-klan [Unknown date] (current) – removed - external edit (Unknown date) 127.0.0.1
@@ Line 1: / Line 1: @@
-[[mysql|« MySQL Authentification Backend]]
-====== Nuked Klan======
-Use this basic SQL statements in your mysql.conf.php
-<code php>
-/***********************************************************************/
-/*       Basic SQL statements for user authentication (required)       */
-/***********************************************************************/
-/* This statement is used to grant or deny access to the wiki. The result
- * should be a table with exact one line containing at least the password
- * of the user. If the result table is empty or contains more than one
- * row, access will be denied.
- *
- * The module access the password as 'pass' so a alias might be necessary.
- *
- * Following patters will be replaced:
- *   %{user}	user name
- *   %{pass}	encrypted or clear text password (depends on 'encryptPass')
- *   %{dgroup}	default group name
- */
-$conf['auth']['mysql']['checkPass']   = "SELECT pass
-                                         FROM nk_users AS u
-                                         WHERE pseudo='%{user}'";
-/* This statement should return a table with exact one row containing
- * information about one user. The field needed are:
- * 'pass'  containing the encrypted or clear text password
- * 'name'  the user's full name
- * 'mail'  the user's email address
- *
- * Keep in mind that DokuWiki will access this information through the
- * names listed above so aliases might be necessary.
- *
- * Following patters will be replaced:
- *   %{user}	user name
- */
-$conf['auth']['mysql']['getUserInfo'] = "SELECT pass, pseudo AS name, mail
-                                         FROM nk_users
-                                         WHERE pseudo='%{user}'";
-/* This statement is used to get all groups a user is member of. The
- * result should be a table containing all groups the given user is
- * member of. The module access the group name as 'group' so a alias
- * might be necessary.
- *
- * Following patters will be replaced:
- *   %{user}	user name
- */
-$conf['auth']['mysql']['getGroups']   = "SELECT niveau as `group`
-                                         FROM nk_users
-                                         WHERE pseudo='%{user}'";
-</code>
-remind to replace the table prefix (here nk_) with yours.
-a local.php for example
-<code php>
-$conf['title'] = 'Documentation Nuked-Klan';
-$conf['start'] = 'accueil';
-$conf['lang'] = 'fr';
-$conf['baseurl'] = 'http://docs.nuked-klan.org/';
-$conf['dformat'] = 'd/m/Y H:i';
-$conf['useacl'] = 1;
-$conf['authtype'] = 'mysql';
-$conf['passcrypt'] = 'md5';
-$conf['superuser'] = '@9'; //admin level 9 in nuked-klan are super users in DokuWiki
-$conf['manager'] = '@2'; //admin level 2 in nuked-klan are managers in DokuWiki
-$conf['openregister'] = '0';
-@include(DOKU_CONF.'local.protected.php');
-require_once('mysql.conf.php');
-</code>
-note the 2 lines relative to the admin level