Bonjour.
Chezmoiçamarche (tm) :-D avec FluxBB v1.5.10 et Dokuwiki "Elenor of Tsort" sur Debian 8.6/PHP 5.6/Postgres 9.4
Juste une mini-correction des requêtes SQL proposées ici:
https://github.com/splitbrain/dokuwiki/blob/master/lib/plugins/authpdo/_test/mysql/fluxbb.php
Je n'ai testé que l'authentification...
Extrait de local.php:
$conf['authtype'] = 'authpdo';
$conf['plugin']['authpdo']['dsn'] = 'pgsql:host=localhost;port=5432;dbname=xxxxxxxxx';
$conf['plugin']['authpdo']['user'] = 'xxxxxxxx';
$conf['plugin']['authpdo']['pass'] = 'xxxxxxxxxxxx';
$conf['plugin']['authpdo']['select-user'] = 'SELECT id AS uid, username AS user, username AS name, password AS hash, email AS mail FROM users WHERE username = :user';
$conf['plugin']['authpdo']['select-user-groups'] = 'SELECT g_title AS group FROM groups G, users U WHERE U.id = :uid AND U.group_id = G.g_id';
$conf['plugin']['authpdo']['select-groups'] = 'SELECT g_id AS gid, g_title AS group FROM groups';
$conf['plugin']['authpdo']['insert-user'] = 'INSERT INTO users (group_id, username, password, email) VALUES (0, :user, :hash, :mail)';
$conf['plugin']['authpdo']['delete-user'] = 'DELETE FROM users WHERE id = :uid';
$conf['plugin']['authpdo']['list-users'] = 'SELECT DISTINCT username AS user FROM users U, groups G WHERE U.id = G.g_id AND G.g_title LIKE :group AND U.username LIKE :user AND U.username LIKE :name AND U.email LIKE :mail ORDER BY username LIMIT :limit OFFSET :start';
$conf['plugin']['authpdo']['count-users'] = 'SELECT COUNT(DISTINCT username) AS count FROM users U, groups G WHERE U.id = G.g_id AND G.g_title LIKE :group AND U.username LIKE :user AND U.username LIKE :name AND U.email LIKE :mail';
$conf['plugin']['authpdo']['update-user-login'] = 'UPDATE users SET username = :newlogin WHERE id = :uid';
$conf['plugin']['authpdo']['update-user-pass'] = 'UPDATE users SET password = :hash WHERE id = :uid';
$conf['plugin']['authpdo']['insert-group'] = 'INSERT INTO groups (g_title) VALUES (:group)';
$conf['plugin']['authpdo']['join-group'] = 'UPDATE users SET group_id = :gid WHERE id = :uid';
$conf['plugin']['authpdo']['leave-group'] = 'SELECT 1';
Reste à mapper les utilisateurs FluxBB vers Dokuwiki: Ça devrait aller.
Et à intégrer le tout pour que ça s'affiche proprement... Là, je suis preneur, si vous avez des billes! Merci.