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

< code> $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

'; </code>

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.1501911221.txt.gz · Dernière modification: 2017/08/05 07:33 de daamien