Question Remove PHP 7.4 and upgrade sites to PHP 8.1

[klowet]

Server operating system version

Debian 11

Plesk version and microupdate number

18.0.50

Hi

We are planning to remove PHP 7.4 from our servers. Before we do this, we want to move all sites with PHP 7.4 enabled to PHP 8.1.
How can we change the PHP handler via CLI from all sites using PHP 7.4 to PHP 8.1? And leaving sites that are using PHP 8.0 or 8.2 untouched?

Thanks

 

[Peter Debik]

The section "Replace PHP handlers conditionally" of this article may help:

https://support.plesk.com/hc/en-us/articles/213933525-How-to-apply-new-PHP-handler-to-multiple-domains-via-CLI-in-Plesk-for-Linux-

 

[klowet]

I see the query:

plesk db -Ne "SELECT d.name FROM domains d, hosting h WHERE d.id=h.dom_id AND d.htype = 'vrt_hst' AND h.php='true'"

But that selects all domains, also the domains using PHP 8.0 and 8.2 would be moved to the given selector. How can I search for only domains excluding specific handlers? Is there an overview of all Plesk tables?

 

[klowet]

Okay, I found the column 'php_handler_id' in the 'hosting' table. So I'll use something like:

plesk db -Ne "SELECT d.name FROM domains d, hosting h WHERE d.id=h.dom_id AND d.htype = 'vrt_hst' AND h.php='true' AND h.php_handler_id NOT LIKE '%php82%' AND h.php_handler_id NOT LIKE '%php81%'" > /root/domains_hosting_php_enabled.txt

Thanks

 

[klowet]

Or even simpler, just select the PHP version we will remove:

plesk db -Ne "SELECT d.name, h.php_handler_id FROM domains d, hosting h WHERE d.id=h.dom_id AND d.htype = 'vrt_hst' AND h.php='true' AND h.php_handler_id LIKE '%php74%'" > /root/domains_hosting_php_enabled.txt