cloudlinux php Selector, xenforo, mysqli error

horizon2021

Member
Jan 31, 2021
23
1
3
USA
cPanel Access Level
Root Administrator
Strange problem today that I'm running out of ideas on how to troubleshoot.
Have two sites running xenforo and php 5.6.

On old server:
Site A is running EA PHP 5.6
Site B is running ALT PHP 5.6
Using cloudlinux php selector in cpanel, I can change Site A or Site B from ALT PHP 5.6 to EA PHP 5.6 or from EA PHP 5.6 to ALT PHP 5.6 with no errors on the old server.

Imported to a new server.
Site A is running EA PHP 5.6 (no errors)
Site B is running ALT PHP 5.6 (no errors)
However, If I change Site A to ALT PHP 5.6 xenforo errors with a mysqli error. If I change it back to EA PHP 5.6 it works fine.
If I change Site B to EA PHP 5.6 xenforo on that site errors with a mysqli error. If I change it back to ALT PHP 5.6 it works fine.

So it seems like each works with the php version that it was imported from backup running fine, but I can't change the php version on the new server without a mysqli error.

phpinfo and things other than xenforo that don't use mysql seem to operate fine after switching php versions.

Since Site A runs fine with EA PHP 5.6 and Site B runs on the same new server with ALT PHP 5.6, I'm not sure what to try since my logic tells me that both EA PHP 5.6 and ALT PHP 5.6 are running fine on the server with mysqi working fine, as long as I don't use the php selector to switch either site.

php modules specified in /home/siteA/.cl.selector/defaults.cfg match exactly php modules specified in /home/siteB/.cl.selector/defaults.cfg for php 5.6 on new and old servers. Obviously the EA-PHP module options should be the same between the two accounts on the same server.

Any ideas on what could cause this behavior when switching php versions with the cloudlinux php slector?
 
Last edited:

horizon2021

Member
Jan 31, 2021
23
1
3
USA
cPanel Access Level
Root Administrator
On the one server with mysql 5.7, after changing php versions with cloudlinux php selector I simply have to do

service httpd stop
service mysqld stop
service mysqld start
service httpd start

and then everything works fine with xenforo.

xenforo isn't using any custom caching setting that I know of and it's not required to restart mysql on the mysql 5.6 server when I do the same cloudlinux php selector php version change... I could dig deeper, but it only seems to affect xenforo and I don't change php versions often (years between changes), so I'm going to leave it at that.

A simple mysql stop and start on the mysql 5.7 server and there is no error after changing mysql versions with cloudlinux php selector and xenforo.
 

horizon2021

Member
Jan 31, 2021
23
1
3
USA
cPanel Access Level
Root Administrator
Thanks. I have the cloudinux and cpanel license through my datacenter. Since in testing for several days it only affects xenforo and only on the server with mysql 5.7, I think I'll live with it for now since I'm unlikely to change php versions again until either the cloudlinux php selector, mysql, or xenforo have changed versions anyway.
 
  • Like
Reactions: cPRex