Dokuwiki c'est le wiki dont on rêve : simple, modulaire, flexible.

$conf['plugin']['authpdo']['dsn'] = 'pgsql:dbname=fluxbb;host=localhost';
$conf['plugin']['authpdo']['user'] = 'fluxbb';
$conf['plugin']['authpdo']['pass'] = 'XXXXXXXXXXXXXXXXXX';
$conf['plugin']['authpdo']['select-user'] = 'SELECT id AS uid,
       username AS user,
       COALESCE(realname,username) AS "name",
       password AS hash,
       email AS mail
  FROM fbb_users
 WHERE username = :user';
$conf['plugin']['authpdo']['select-user-groups'] = 'SELECT g.g_title AS group
FROM fbb_users u JOIN fbb_groups g ON u.group_id = g.g_id
WHERE u.id = :uid';
$conf['plugin']['authpdo']['select-groups'] = 'SELECT g_id, g_title FROM fbb_groups';
$conf['plugin']['authpdo']['list-users'] = 'SELECT DISTINCT u.username AS user
FROM fbb_users u JOIN fbb_groups g ON u.group_id = g.g_id
WHERE g.g_title LIKE :group
  AND u.username LIKE :user
  AND u.realname  LIKE :name
  AND u.email  LIKE :mail
ORDER BY u.username
LIMIT :limit OFFSET :start';
$conf['plugin']['authpdo']['count-users'] = 'SELECT COUNT(DISTINCT u.username) AS count
FROM fbb_users u JOIN fbb_groups g ON u.group_id = g.g_id
WHERE g.g_title LIKE :group
  AND u.username LIKE :user
  AND u.realname  LIKE :name
  AND u.email  LIKE :mail
';

1. Cloner la toolbox sur Celeste2

git clone https://gitlab.com/postgresqlfr/pgfr_toolbox.git

2. Lancer la synchro

make dokuwiki_sync_test_env

3. http://testwww.postgresql.fr

Tout se fait via l'interface d'administration !

1. Aller dans la section Administrer > Mise à jour du wiki

2. Suivre les étapes

• Note
• columns
• ODT
• googleanalytics
• redirect
• upgrade
• authpdo