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
https://www.dokuwiki.org/plugin:authpdo
You can send the dumps directly to me:
andi@splitbrain.org - if you have any additional questions feel free to ask here.