Problem after cloudlinux upgrade. Many users have no PHP selected and see mysql errors. How can we query to find any cloudlinux user that has NO php version selected?

[emin]

Hello,

How can we query ALL customer accounts and discover which ones do not have any PHP version selected for them in cloudlinux php selector? This "php version" field is blank for some customers... so how can we find them, so we can fix it before they contact us or realize there is a problem.

Here is the issue:

We just upgraded from EA3 to EA4 on a cloudlinux server, and now many customers are having the same problem. The symptom is that their website stops working and shows a "mysql is not installed for php" error. After checking their cpanel, we can see that the PHP Selector does not show ANY php version is selected for their account.

In the PHP selector page, we see:

-------------
Current PHP version: [This is blank here]
-------------

Once we choose a PHP version for them and save it.. their site works correctly.

So... we do not want to wait for more customers to contact us with the problem Thats bad customer service.

How can we query ALL customer accounts and discover which ones do not have any PHP version selected for them in cloudlinux php selector? This "php version" field is blank for some customers... so how can we find them, so we can fix it before they contact us or realize there is a problem.

Thanks!

[vmarchuk]

Hello,

Unfortunately, selectorctl utility does not have such option. But you can check PHP versions for all users inside CageFS
with the following simple script:
# for user in `cagefsctl --list-enabled| tail -n +2`; do echo $user && selectorctl -c -u $user; done

Let me know if you need further assistance.