Not logged in. · Lost password · Register
Forum: Announcements and Rules RSS
Help needed for future database authentication plugin
authmysql and authpgsql users be aware!
andi (Administrator) #1
User title: splitbrain
Member since May 2006 · 3542 posts · Location: Berlin Germany
Group memberships: Administrators, Members
Show profile · Link to this post
Subject: Help needed for future database authentication plugin
Currently DokuWiki ships with the authmysql and authpgsql plugins to configure authentication against an existing database. The authmysql plugin relies on the mysql PHP extension which has been deprecated and no longer exists in PHP5. Thus we need a new solution. That new solution is the new authpdo plugin I am currently working on.

This plugin will allow DokuWiki to talk to any database supported by the PHP PDO extension.

To make sure the plugin works as intended, it should be automatically tested against real world examples. To do that I need your help.

What I need are SQL dumps from real world databases that contain user data that would be used for authenticating in DokuWiki. This could be Forums, Blogs, CMS, Bug Trackers or any other database driven tool.

I want to include them in the plugin's unit tests, so they will be public and thus need to be cleaned up. A suitable dump would contain only the following:

  • table creation commands for all user and group related tables (no others)
  • a handful of users and groups (make sure to adjust those to be not real users)

In addition I need a short description of where the dump is from, what database system is used and what the passwords for the above users are.

I estimate that creating such a prepared dump would take about 20 to 30 minutes for someone already running a suitable system.

You can see examples of such dumps from Wordpress and fluxBB here already. I would be especially interested in having dumps from PostgreSQL.

If you are a current authmysql or authpgsql user and feel especially adventurous you could also checkout the authpdo branch and try to configure your database directly in the wiki. A first rough documentation is available at

You can send the dumps directly to me: - if you have any additional questions feel free to ask here.
Read this if you don't get any useful answers.
Lies dies wenn du keine hilfreichen Antworten bekommst.
This post was edited on 2016-08-03, 11:04 by andi.
Close Smaller – Larger + Reply to this post:
Verification code: VeriCode Please enter the word from the image into the text field below. (Type the letters only, lower case is okay.)
Smileys: :-) ;-) :-D :-p :blush: :cool: :rolleyes: :huh: :-/ <_< :-( :'( :#: :scared: 8-( :nuts: :-O
Special characters:
Go to forum
This board is powered by the Unclassified NewsBoard software, 20150713-dev, © 2003-2015 by Yves Goergen
Current time: 2020-04-10, 08:59:46 (UTC +02:00)