This is a static dump of issues in the old "Flyspray" bugtracker for DokuWiki. Bugs and feature requests
are now tracked at the issue tracker at Github.
This task was never closed in our old bug tracker.
Feel free to open a new task at Github if you feel this is still relevant.
FS#2920 authmysql plugin "retrieveusers" filter behaves differently from authplain authenticator
ACL & Authentication
The authplain authenticator filters use regular expressions to search for matching users. This means that some plugins use the '|' character (and possibly others) to allow searching for multiple users/groups.
The authmysql authenticator just uses LIKE '%<text>%' which cannot handle | or other regex operators. So, it behaves differently, when all then authenticators should really behave the same.
It may be possible to rewrite the _createSQLFilter function in authmysql/auth.php to use the REGEXP function of MySQL
I changed the _createSQLFilter function to expand the | regex operator only, as below: