How did you do the upgrade?
Does it upgrade the client and server parts (assuming they are split for MariaDB?) Was the MariaDB server restarted?
Wondering if there is anything that would need the client side to be rebuilt/relinked with the newer version but might be dragging red herrings in front of you!
So maybe the server side is actually fine (it looks fine from the logs, doesn't it?) but there's something to do with PHP/the client library that needs upgrading/restarting? Did you restart the webserver (if mod_php) or php_fpm or whatever? Don't think it would be anything to do with those just wondering if the focus is on the server and config when in fact more of a client/caller issue.
Good luck.
Good ideas.
Yes, there are separate packages for the client and server. I upgraded by running
pkg upgrade
which is the way I've always done it. I restarted all services and even restarted the server just to make sure. I just checked and there are currently no packages that need to be upgraded
Something odd I just realized is that I have 2 other servers with websites running the CMS MODX Revolution and they are running fine after the mariadb upgrade. I'd totally forgotten about them as they are working and didn't throw any errors.
I compared the installed packages on the Wordpress servers and the MODX Revolution servers and, as far as mariadb, php, apache, and other relevant dependencies go, they are exactly the same versions. Out of interest I installed phpmyadmin on the MODX Revolution server and it does not work, it gives the same errors that the text php script gave which I noted in an above post.
Does that make any sense to you?
Not sure if it will help but here's the database config info from phpmyadmin, wordpress, and modx revolution:
Code:
phpmyadmin:
$cfg['Servers'][$i]['verbose'] = 'test';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['compress'] = true;
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'user';
$cfg['Servers'][$i]['password'] = 'pass';
$cfg['Servers'][$i]['only_db'] = array('database');
$cfg['Servers'][$i]['AllowRoot'] = false;
wordpress:
define('DB_NAME', 'database');
define('DB_USER', 'user');
define('DB_PASSWORD', 'pass');
define('DB_HOST', 'localhost');
define('DB_CHARSET', 'utf8');
define('DB_COLLATE', '');
modx revolution:
$database_type = 'mysql';
$database_server = 'localhost';
$database_user = 'user';
$database_password = 'pass';
$database_connection_charset = 'latin1';
$dbase = 'database';
$table_prefix = 'modx_';
$database_dsn = 'mysql:host=localhost;dbname=database;charset=latin1';