PostgreSQL La base de donnees la plus sophistiquee au monde.

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

La procédure est ici → http://www.dokuwiki.org/fr:install:upgrade

cd
wget http://www.splitbrain.org/_media/projects/dokuwiki/dokuwiki-2008-05-05.tgz
tar xzvf dokuwiki-2008-05-05.tgz  
cd /data/www
/data/www/fr/postgresql.fr
sudo cp -pr ../../org/postgresqlfr.org/wiki.postgresqlfr.org/ wiki
sudo cp -rf /home/damien/dokuwiki-2008-05-05/* wiki/
cd wiki/
cat /tmp/remove.txt | sudo xargs -n 1 rm -rf
sudo chown -R www-data.www-data .
sudo vi /etc/apache2/sites-enabled/001-www.postgresql.fr
sudo apache2ctl restart

15 minutes top-chrono :-)

plugins nécessaires

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