I am moving from PHP 5.6 to PHP 7.2 and apparently I can't use authmysql any more. I have been told that authPDO is the best way to connect to my (MySQL) user authentication database. However, I'm having trouble finding what to do.
At the moment, everything I need is in a few lines in local.php:
$conf['plugin']['authmysql']['server'] = '10.x.x.x';
$conf['plugin']['authmysql']['user'] = 'DWUsers';
$conf['plugin']['authmysql']['password'] = 'xxxxxxxx';
$conf['plugin']['authmysql']['database'] = 'DWUsers';
All I want to do is to have this authentication continue to work. But I don't understand the documentation that I have seen for authPDO (e.g.,
https://www.dokuwiki.org/plugin:authpdo). It talks about writing SQL statements (which I know how to do), but not where to put them, or whether I have to include them directly in an SQL file or call them from PHP, etc etc.
Does someone perhaps have a working example of a simple authPDO configuration so that I know what files to edit and what syntax to use in there? Or experience of migrating from authpysql to authPDO?
Thanks...
Nick