PHP-FPM PHP 7 compatibility wrapper for deprecated mysql extension

haven't tried it myself so not sure. Will check it out

 

Testing adding legacy mysql extesion to PHP 7.1.4

Code (Text):

php -v
PHP 7.1.4 (cli) (built: Apr 13 2017 21:43:15) ( NTS )
Copyright (c) 1997-2017 The PHP Group
Zend Engine v3.1.0, Copyright (c) 1998-2017 Zend Technologies
    with Zend OPcache v7.1.4, Copyright (c) 1999-2017, by Zend Technologies

Actual install steps as per How to put MySQL functions back into PHP 7 just tailored for Centmin Mod PHP-FPM installs. You will have to do these manual steps everytime you upgrade PHP.

Code (Text):

# http://php.net/manual/en/mysql.php
# http://php.net/manual/en/mysql.installation.php
# http://php.net/manual/en/mysqlinfo.api.choosing.php
# https://ckon.wordpress.com/2015/08/06/put-mysql-functions-back-into-php-7/
# https://github.com/php/pecl-database-mysql
cd /svr-setup/php-7.1.4/ext
git clone https://github.com/php/pecl-database-mysql mysql --recursive
cd /svr-setup/php-7.1.4/ext/mysql
phpize
./configure --with-php-config=/usr/local/bin/php-config
make
make install
echo "extension=mysql.so" > /etc/centminmod/php.d/mysql.ini
fpmrestart
php --ri mysql

Unfortunately phpinfo for mysql shows the updated newer mysqlnd native instead of legacy mysql extension as Centmin Mod php-fpm is compiled with newer mysqlnd native driver

Code (Text):

php --ri mysql

mysql

MySQL Support => enabled
Active Persistent Links => 0
Active Links => 0
Client API version => mysqlnd 5.0.12-dev - 20150407 - $Id: b396954eeb2d1d9ed7902b8bae237b287f21ad9e $

Directive => Local Value => Master Value
mysql.allow_persistent => On => On
mysql.max_persistent => Unlimited => Unlimited
mysql.max_links => Unlimited => Unlimited
mysql.default_host => no value => no value
mysql.default_user => no value => no value
mysql.default_password => no value => no value
mysql.default_port => no value => no value
mysql.default_socket => /var/lib/mysql/mysql.sock => /var/lib/mysql/mysql.sock
mysql.connect_timeout => 60 => 60
mysql.trace_mode => Off => Off
mysql.allow_local_infile => On => On

However, php list extension module command does report mysql extension as loaded so you will have to test your web app which utilises legacy mysql extension to see

Code (Text):

php -m
[PHP Modules]
bcmath
bz2
calendar
Core
ctype
curl
date
dom
enchant
exif
filter
ftp
gd
geoip
gettext
gmp
hash
iconv
igbinary
imagick
imap
intl
json
ldap
libxml
mailparse
mbstring
mcrypt
memcache
memcached
mysql
mysqli
mysqlnd
openssl
pcntl
pcre
PDO
pdo_mysql
pdo_sqlite
Phar
posix
pspell
readline
redis
Reflection
session
shmop
SimpleXML
snmp
soap
sockets
SPL
sqlite3
standard
sysvmsg
sysvsem
sysvshm
tidy
tokenizer
xml
xmlreader
xmlrpc
xmlwriter
xsl
Zend OPcache
zip
zlib

[Zend Modules]
Zend OPcache

if you need to temp disable legacy mysql extension comment out with semi-colon ; in from of load extension line in mysql extension .ini file at /etc/centminmod/php.d/mysql.ini and restart php-fpm

Code (Text):

;extension=mysql.so

 

Great to hear.. might add it to php upgrade routine to prompt users if they want to add legacy mysql extension for php 7.x installs

 

what they mean at GitHub - php/pecl-database-mysql: Legacy MySQL extension, is you should update your web app/script to support newer mysqli and pdo_mysql extension and not rely on this legacy mysql extension compiled into PHP 7.

 

yes mysql extension is deprecated hence it's removal from PHP 7

 

Well mysql extension is still in PHP 5.6 and is okay. Though most modern web app/scripts have moved to mysqli/mysqlnd or PDO mysql extension method of PHP communication with MySQL server. So having mysql extension in PHP doesn't matter.

 

Just about to commit the update to 123.09beta01 branch for php upgrades detecting PHP 7+. You'll be prompted to whether you want to install legacy mysql extension for PHP 7+

Code (Text):

PHP 7+ detected which uses newer mysqlnd
or PDO MySQL extensions and removed the
legacy mysql extension. You can optionally
re-add the removed legacy mysql extension
to PHP 7+ by answering yes to next question
Only answer yes if you know for sure you
have very old web scripts which need mysql
legacy extension re-added. Otherwise answer
no which is recommended for best stability

Re-add legacy mysql extension to PHP 7+ [y/n] ? y

It gets installed into PHP 7+ binary itself so no need for separate /etc/centminmod/php.d/mysql.ini settings file to load mysql.so extension this way. Confirm mysql extension is loaded via listing php loaded extensions and look for = mysql

Code (Text):

php -m

Code (Text):

php -m
[PHP Modules]
bcmath
bz2
calendar
Core
ctype
curl
date
dom
enchant
exif
filter
ftp
gd
geoip
gettext
gmp
hash
iconv
igbinary
imagick
imap
intl
json
ldap
libxml
mailparse
mbstring
mcrypt
memcache
memcached
mysql
mysqli
mysqlnd
openssl
pcntl
pcre
PDO
pdo_mysql
pdo_sqlite
Phar
posix
pspell
readline
redis
Reflection
session
shmop
SimpleXML
snmp
soap
sockets
SPL
sqlite3
standard
sysvmsg
sysvsem
sysvshm
tidy
tokenizer
xml
xmlreader
xmlrpc
xmlwriter
xsl
Zend OPcache
zip
zlib

[Zend Modules]
Zend OPcache

 

yup correct.. if /etc/centminmod/php.d/mysql.ini is still there afterwards, restarting php-fpm gives error

Code (Text):

PHP Warning:  Module 'mysql' already loaded in Unknown on line 0

remove /etc/centminmod/php.d/mysql.ini and restart php-fpm should be fine

 

try another centmin.sh menu option 23 submenu option 2 update or do it manually via git command line

Code (Text):

cd /usr/local/src/centminmod
git stash
git pull

i made a last minute fix https://community.centminmod.com/threads/fix-inc-mysql_legacy-inc.11519/#post-48956