Communauté francophone de PostgreSQL

La communauté francophone de PostgreSQL

Outils pour utilisateurs

Outils du site


admin:dokuwiki

Ceci est une ancienne révision du document !


dokuwiki

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

SSO avec le forum

$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
';

Resynchroniser l'environement de test

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

Procédure de mise à jour

Tout se fait via l'interface d'administration !

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

2. Suivre les étapes

plugins nécessaires

  • Note
  • columns
  • ODT
  • googleanalytics
  • redirect
  • upgrade
  • authpdo
admin/dokuwiki.1550657652.txt.gz · Dernière modification: 2019/02/20 11:14 de daamien