MySQL issue with php5.6 sites

This was working under CentOS, and Debian, but i had issues with both of them, so I switched to Ubuntu 20,

http://thelastoutpost.com/
Database Error: Unable to connect to the database:Could not connect to MySQLDatabase Error: Unable to connect to the database:Could not connect to MySQL

These commands run fine, it sees php5.6

virtualmin check-config
virtualmin fix-domain-permissions --all-domains
virtualmin validate-domains --all-domains --feature web

I have no choice to be use php5.6, those are old CMS's no one wants to upgrade.

Thanks, Jeff

Status: 
Closed (fixed)
Virtualmin version: 
6.14
Webmin version: 
1.962

Comments

Ilia's picture
Submitted by Ilia on Fri, 11/06/2020 - 11:25

Hi,

Database Error: Unable to connect to the database:Could not connect to MySQLDatabase Error: Unable to connect to the database:Could not connect to MySQL

Perhaps, database credentials are incorrectly setup for an app? Try checking, if you can connect to MySQL database using console, with expected username and password, like:

mysql -u username -p

Besides, check if php5.6-mysql package is installed.

It looks like you're using Virtualmin GPL there though, and the area here is for folks using Virtualmin Pro. Since you're using Virtualmin GPL there, to troubleshoot that issue, what we'd suggest is to post your issue in our Community Forums to get support on that.

This is pro license, php5.6-mysql is installed.

I will look into permissions.

This is the commands I used to install it:

add-apt-repository -y ppa:ondrej/php
apt-get update
apt-get install php5.6 php5.6-mysql php5.6-cgi php5.6-cli php5.6-bz2 php5.6-cgi php5.6-curl php5.6-fpm php5.6-gd php5.6-imap php5.6-json php5.6-mbstring php5.6-mysql php5.6-odbc php5.6-pspell php5.6-soap php5.6-sqlite3 php5.6-xml php5.6-xmlrpc php5.6-zip php5.6-cgi php5.6-snmp php5.6-xsl php5.6-opcache php5.6-intl php5.6-curl
Ilia's picture
Submitted by Ilia on Fri, 11/06/2020 - 11:40

The server returns 500 error. Check Apache error log for the virtual server and test db connectivity using console first.

We are going to restore Debian, I think our backups are failing.

What is the deal with Debian using Ubuntu Repository that has a newer libc6?

I will have to deal with that, which is what caused this issue to begin with.

Thanks, Jeff

I realized I was using the wrong extension, last backup was bz, this time it was gz, but now I face a different issue, when I restored it, I got the error

failed : Starting php7.3-fpm (via systemctl): php7.3-fpm.serviceJob for php7.3-fpm.service failed because the control process exited with error code. See "systemctl status php7.3-fpm.service" and "journalctl -xe" for details.

Trying to update php to 7.4 I get this error

Failed to save PHP versions : Apache virtual host was not found

I have all my domains working for php7.4, but I have 3 domains that run php5.6 that will work with MySQL for some reason, with this error

Database Error: Unable to connect to the database:Could not connect to MySQLDatabase Error: Unable to connect to the database:Could not connect to MySQL

These are php5.6 sites, Joomla and Drupal, and this worked under Debian 10, this is Ubuntu 20, but for some reason I cannot change the PHP versoin of any php5.6 site, I only have 3 of them, two Joomla, and one Drupal, but I really want to get these up.

Thanks Jeff

This was on hold due to 6.14 release, because my php5.6 sites would not change PHP version, that works, so I can now change them php5.6, but I still get the same MySQL Error, and I can ssh in and log into MySQL using the same credentials, so I think PHP is not running at all, since changing it to php7 will only give me a blank screen, and this message is just a default error message from 5.6 days, but it is clear it cannot connect to php-mysql.

This license is under user rremelin

Thanks, Jeff

Ilia's picture
Submitted by Ilia on Sat, 12/05/2020 - 05:37

but I have 3 domains that run php5.6 that will work with MySQL for some reason, with this error

You need to make sure that PHP 5.6 has mysql extensions and other essentials installed and loaded :

apt-get install php5.6-{cli,pdo,fpm,zip,gd,xml,mysql,cgi}

Create a small phpinfo.php file in document root to get more information about what is going on.

<?php
echo phpinfo();
?>

Everything was already installed.

PHP logo
PHP Version 5.6.40-38+ubuntu20.04.1+deb.sury.org+1
System Linux vm.lightwizzard.com 5.4.0-56-generic #62-Ubuntu SMP Mon Nov 23 19:20:19 UTC 2020 x86_64
Server API FPM/FastCGI
Virtual Directory Support disabled
Configuration File (php.ini) Path /etc/php/5.6/fpm
Loaded Configuration File /etc/php/5.6/fpm/php.ini
Scan this dir for additional .ini files /etc/php/5.6/fpm/conf.d
Additional .ini files parsed /etc/php/5.6/fpm/conf.d/10-mysqlnd.ini, /etc/php/5.6/fpm/conf.d/10-opcache.ini, /etc/php/5.6/fpm/conf.d/10-pdo.ini, /etc/php/5.6/fpm/conf.d/15-xml.ini, /etc/php/5.6/fpm/conf.d/20-bz2.ini, /etc/php/5.6/fpm/conf.d/20-calendar.ini, /etc/php/5.6/fpm/conf.d/20-ctype.ini, /etc/php/5.6/fpm/conf.d/20-curl.ini, /etc/php/5.6/fpm/conf.d/20-dom.ini, /etc/php/5.6/fpm/conf.d/20-exif.ini, /etc/php/5.6/fpm/conf.d/20-fileinfo.ini, /etc/php/5.6/fpm/conf.d/20-ftp.ini, /etc/php/5.6/fpm/conf.d/20-gd.ini, /etc/php/5.6/fpm/conf.d/20-gettext.ini, /etc/php/5.6/fpm/conf.d/20-iconv.ini, /etc/php/5.6/fpm/conf.d/20-imap.ini, /etc/php/5.6/fpm/conf.d/20-intl.ini, /etc/php/5.6/fpm/conf.d/20-json.ini, /etc/php/5.6/fpm/conf.d/20-mbstring.ini, /etc/php/5.6/fpm/conf.d/20-mysql.ini, /etc/php/5.6/fpm/conf.d/20-mysqli.ini, /etc/php/5.6/fpm/conf.d/20-odbc.ini, /etc/php/5.6/fpm/conf.d/20-pdo_mysql.ini, /etc/php/5.6/fpm/conf.d/20-pdo_odbc.ini, /etc/php/5.6/fpm/conf.d/20-pdo_sqlite.ini, /etc/php/5.6/fpm/conf.d/20-phar.ini, /etc/php/5.6/fpm/conf.d/20-posix.ini, /etc/php/5.6/fpm/conf.d/20-pspell.ini, /etc/php/5.6/fpm/conf.d/20-readline.ini, /etc/php/5.6/fpm/conf.d/20-shmop.ini, /etc/php/5.6/fpm/conf.d/20-simplexml.ini, /etc/php/5.6/fpm/conf.d/20-snmp.ini, /etc/php/5.6/fpm/conf.d/20-soap.ini, /etc/php/5.6/fpm/conf.d/20-sockets.ini, /etc/php/5.6/fpm/conf.d/20-sqlite3.ini, /etc/php/5.6/fpm/conf.d/20-sysvmsg.ini, /etc/php/5.6/fpm/conf.d/20-sysvsem.ini, /etc/php/5.6/fpm/conf.d/20-sysvshm.ini, /etc/php/5.6/fpm/conf.d/20-tokenizer.ini, /etc/php/5.6/fpm/conf.d/20-wddx.ini, /etc/php/5.6/fpm/conf.d/20-xmlreader.ini, /etc/php/5.6/fpm/conf.d/20-xmlrpc.ini, /etc/php/5.6/fpm/conf.d/20-xmlwriter.ini, /etc/php/5.6/fpm/conf.d/20-xsl.ini, /etc/php/5.6/fpm/conf.d/20-zip.ini
PHP API 20131106
PHP Extension 20131226
Zend Extension 220131226
Zend Extension Build API220131226,NTS
PHP Extension Build API20131226,NTS
Debug Build no
Thread Safety disabled
Zend Signal Handling disabled
Zend Memory Manager enabled
Zend Multibyte Support provided by mbstring
IPv6 Support enabled
DTrace Support enabled
Registered PHP Streams https, ftps, compress.zlib, php, file, glob, data, http, ftp, compress.bzip2, phar, zip
Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv2, tls, tlsv1.0, tlsv1.1, tlsv1.2
Registered Stream Filters zlib.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk, bzip2.*, convert.iconv.*
Zend logo This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies
    with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2016, by Zend Technologies
Configuration
bz2
BZip2 Support Enabled
Stream Wrapper support compress.bzip2://
Stream Filter support bzip2.decompress, bzip2.compress
BZip2 Version 1.0.8, 13-Jul-2019
calendar
Calendar support enabled
cgi-fcgi
php-fpm active
Directive Local Value Master Value
cgi.discard_path 0 0
cgi.fix_pathinfo 1 1
cgi.force_redirect 1 1
cgi.nph 0 0
cgi.redirect_status_env no value no value
cgi.rfc2616_headers 0 0
fastcgi.error_header no value no value
fastcgi.logging 1 1
fpm.config no value no value
Core
PHP Version 5.6.40-38+ubuntu20.04.1+deb.sury.org+1
Directive Local Value Master Value
allow_url_fopen On On
allow_url_include Off Off
always_populate_raw_post_data 0 0
arg_separator.input & &
arg_separator.output & &
asp_tags Off Off
auto_append_file no value no value
auto_globals_jit On On
auto_prepend_file no value no value
browscap no value no value
default_charset UTF-8 UTF-8
default_mimetype text/html text/html
disable_classes no value no value
disable_functions pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,
display_errors Off Off
display_startup_errors Off Off
doc_root no value no value
docref_ext no value no value
docref_root no value no value
enable_dl Off Off
enable_post_data_reading On On
error_append_string no value no value
error_log no value no value
error_prepend_string no value no value
error_reporting 22527 22527
exit_on_timeout Off Off
expose_php Off Off
extension_dir /usr/lib/php/20131226 /usr/lib/php/20131226
file_uploads On On
highlight.comment #FF8000 #FF8000
highlight.default #0000BB #0000BB
highlight.html #000000 #000000
highlight.keyword #007700 #007700
highlight.string #DD0000 #DD0000
html_errors On On
ignore_repeated_errors Off Off
ignore_repeated_source Off Off
ignore_user_abort Off Off
implicit_flush Off Off
include_path .:/usr/share/php .:/usr/share/php
input_encoding no value no value
internal_encoding no value no value
log_errors On On
log_errors_max_len 1024 1024
mail.add_x_header On On
mail.force_extra_parameters no value no value
mail.log no value no value
max_execution_time 30 30
max_file_uploads 20 20
max_input_nesting_level 64 64
max_input_time 60 60
max_input_vars 1000 1000
memory_limit 128M 128M
open_basedir no value no value
output_buffering 4096 4096
output_encoding no value no value
output_handler no value no value
post_max_size 8M 8M
precision 14 14
realpath_cache_size 16K 16K
realpath_cache_ttl 120 120
register_argc_argv Off Off
report_memleaks On On
report_zend_debug On On
request_order GP GP
sendmail_from no value no value
sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i
serialize_precision 17 17
short_open_tag Off Off
SMTP localhost localhost
smtp_port 25 25
sql.safe_mode Off Off
sys_temp_dir no value no value
track_errors Off Off
unserialize_callback_func no value no value
upload_max_filesize 2M 2M
upload_tmp_dir /home/charliephillips/tmp /home/charliephillips/tmp
user_dir no value no value
user_ini.cache_ttl 300 300
user_ini.filename .user.ini .user.ini
variables_order GPCS GPCS
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
zend.detect_unicode On On
zend.enable_gc On On
zend.multibyte Off Off
zend.script_encoding no value no value
ctype
ctype functions enabled
curl
cURL support enabled
cURL Information 7.68.0
Age 5
Features
AsynchDNS Yes
CharConv No
Debug No
GSS-Negotiate No
IDN Yes
IPv6 Yes
krb4 No
Largefile Yes
libz Yes
NTLM Yes
NTLMWB Yes
SPNEGO Yes
SSL Yes
SSPI No
TLS-SRP Yes
Protocols dict, file, ftp, ftps, gopher, http, https, imap, imaps, ldap, ldaps, pop3, pop3s, rtmp, rtsp, scp, sftp, smb, smbs, smtp, smtps, telnet, tftp
Host x86_64-pc-linux-gnu
SSL Version OpenSSL/1.1.1g
ZLib Version 1.2.11
libSSH Version libssh/0.9.3/openssl/zlib
date
date/time support enabled
"Olson" Timezone Database Version 0.system
Timezone Database internal
Default timezone America/Chicago
Directive Local Value Master Value
date.default_latitude 31.7667 31.7667
date.default_longitude 35.2333 35.2333
date.sunrise_zenith 90.583333 90.583333
date.sunset_zenith 90.583333 90.583333
date.timezone no value no value
dom
DOM/XML enabled
DOM/XML API Version 20031129
libxml Version 2.9.10
HTML Support enabled
XPath Support enabled
XPointer Support enabled
Schema Support enabled
RelaxNG Support enabled
ereg
Regex Library Bundled library enabled
exif
EXIF Support enabled
EXIF Version 1.4 $Id: cad29b729548e4206f0697710cc9e177f26fdff3 $
Supported EXIF Version 0220
Supported filetypes JPEG,TIFF
Directive Local Value Master Value
exif.decode_jis_intel JIS JIS
exif.decode_jis_motorola JIS JIS
exif.decode_unicode_intel UCS-2LE UCS-2LE
exif.decode_unicode_motorola UCS-2BE UCS-2BE
exif.encode_jis no value no value
exif.encode_unicode ISO-8859-15 ISO-8859-15
fileinfo
fileinfo support enabled
version 1.0.5
libmagic 517
filter
Input Validation and Filtering enabled
Revision $Id: 5b79667bd9a68977a9b4f7505223a8e216e04908 $
Directive Local Value Master Value
filter.default unsafe_raw unsafe_raw
filter.default_flags no value no value
ftp
FTP support enabled
gd
GD Support enabled
GD headers Version 2.3.0
GD library Version 2.3.0
FreeType Support enabled
FreeType Linkage with freetype
FreeType Version 2.10.1
GIF Read Support enabled
GIF Create Support enabled
JPEG Support enabled
libJPEG Version 8
PNG Support enabled
libPNG Version 1.6.37
WBMP Support enabled
XPM Support enabled
libXpm Version 30411
XBM Support enabled
WebP Support enabled
Directive Local Value Master Value
gd.jpeg_ignore_warning 0 0
gettext
GetText Support enabled
hash
hash support enabled
Hashing Engines md2 md4 md5 sha1 sha224 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost gost-crypto adler32 crc32 crc32b fnv132 fnv1a32 fnv164 fnv1a64 joaat haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5
iconv
iconv support enabled
iconv implementation glibc
iconv library version 2.31
Directive Local Value Master Value
iconv.input_encoding no value no value
iconv.internal_encoding no value no value
iconv.output_encoding no value no value
imap
IMAP c-Client Version 2007f
SSL Support enabled
Kerberos Support enabled
Directive Local Value Master Value
imap.enable_insecure_rsh Off Off
intl
Internationalization support enabled
version 1.1.0
ICU version 66.1
ICU Data version 66.1
Directive Local Value Master Value
intl.default_locale no value no value
intl.error_level 0 0
intl.use_exceptions 0 0
json
json support enabled
json version 1.2.1
libxml
libXML support active
libXML Compiled Version 2.9.10
libXML Loaded Version 20910
libXML streams enabled
mbstring
Multibyte Support enabled
Multibyte string engine libmbfl
HTTP input encoding translation disabled
libmbfl version 1.3.2
mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.
Multibyte (japanese) regex support enabled
Multibyte regex (oniguruma) backtrack check On
Multibyte regex (oniguruma) version 5.9.5
Directive Local Value Master Value
mbstring.detect_order no value no value
mbstring.encoding_translation Off Off
mbstring.func_overload 0 0
mbstring.http_input no value no value
mbstring.http_output no value no value
mbstring.http_output_conv_mimetypes ^(text/|application/xhtml\+xml) ^(text/|application/xhtml\+xml)
mbstring.internal_encoding no value no value
mbstring.language neutral neutral
mbstring.strict_detection Off Off
mbstring.substitute_character no value no value
mhash
MHASH support Enabled
MHASH API Version Emulated Support
mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
Directive Local Value Master Value
mysql.allow_local_infile On On
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off
mysqli
MysqlI Support enabled
Client API library version mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
Active Persistent Links 0
Inactive Persistent Links 0
Active Links 0
Directive Local Value Master Value
mysqli.allow_local_infile On On
mysqli.allow_persistent On On
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.max_persistent Unlimited Unlimited
mysqli.reconnect Off Off
mysqli.rollback_on_cached_plink Off Off
mysqlnd
mysqlnd enabled
Version mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
Compression supported
core SSL supported
extended SSL supported
Command buffer size 4096
Read buffer size 32768
Read timeout 31536000
Collecting statistics Yes
Collecting memory statistics No
Tracing n/a
Loaded plugins mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_sha256_password
API Extensions mysql,mysqli,pdo_mysql
mysqlnd statistics
bytes_sent 0
bytes_received 83790
packets_sent 0
packets_received 882
protocol_overhead_in 3528
protocol_overhead_out 0
bytes_received_ok_packet 0
bytes_received_eof_packet 0
bytes_received_rset_header_packet 0
bytes_received_rset_field_meta_packet 0
bytes_received_rset_row_packet 0
bytes_received_prepare_response_packet 0
bytes_received_change_user_packet 0
packets_sent_command 0
packets_received_ok 0
packets_received_eof 0
packets_received_rset_header 0
packets_received_rset_field_meta 0
packets_received_rset_row 0
packets_received_prepare_response 0
packets_received_change_user 0
result_set_queries 0
non_result_set_queries 0
no_index_used 0
bad_index_used 0
slow_queries 0
buffered_sets 0
unbuffered_sets 0
ps_buffered_sets 0
ps_unbuffered_sets 0
flushed_normal_sets 0
flushed_ps_sets 0
ps_prepared_never_executed 0
ps_prepared_once_executed 0
rows_fetched_from_server_normal 0
rows_fetched_from_server_ps 0
rows_buffered_from_client_normal 0
rows_buffered_from_client_ps 0
rows_fetched_from_client_normal_buffered 0
rows_fetched_from_client_normal_unbuffered 0
rows_fetched_from_client_ps_buffered 0
rows_fetched_from_client_ps_unbuffered 0
rows_fetched_from_client_ps_cursor 0
rows_affected_normal 0
rows_affected_ps 0
rows_skipped_normal 0
rows_skipped_ps 0
copy_on_write_saved 0
copy_on_write_performed 0
command_buffer_too_small 0
connect_success 0
connect_failure 882
connection_reused 0
reconnect 0
pconnect_success 0
active_connections 18446744073709550734
active_persistent_connections 0
explicit_close 0
implicit_close 0
disconnect_close 0
in_middle_of_command_close 0
explicit_free_result 0
implicit_free_result 0
explicit_stmt_close 0
implicit_stmt_close 0
mem_emalloc_count 0
mem_emalloc_amount 0
mem_ecalloc_count 0
mem_ecalloc_amount 0
mem_erealloc_count 0
mem_erealloc_amount 0
mem_efree_count 0
mem_efree_amount 0
mem_malloc_count 0
mem_malloc_amount 0
mem_calloc_count 0
mem_calloc_amount 0
mem_realloc_count 0
mem_realloc_amount 0
mem_free_count 0
mem_free_amount 0
mem_estrndup_count 0
mem_strndup_count 0
mem_estndup_count 0
mem_strdup_count 0
proto_text_fetched_null 0
proto_text_fetched_bit 0
proto_text_fetched_tinyint 0
proto_text_fetched_short 0
proto_text_fetched_int24 0
proto_text_fetched_int 0
proto_text_fetched_bigint 0
proto_text_fetched_decimal 0
proto_text_fetched_float 0
proto_text_fetched_double 0
proto_text_fetched_date 0
proto_text_fetched_year 0
proto_text_fetched_time 0
proto_text_fetched_datetime 0
proto_text_fetched_timestamp 0
proto_text_fetched_string 0
proto_text_fetched_blob 0
proto_text_fetched_enum 0
proto_text_fetched_set 0
proto_text_fetched_geometry 0
proto_text_fetched_other 0
proto_binary_fetched_null 0
proto_binary_fetched_bit 0
proto_binary_fetched_tinyint 0
proto_binary_fetched_short 0
proto_binary_fetched_int24 0
proto_binary_fetched_int 0
proto_binary_fetched_bigint 0
proto_binary_fetched_decimal 0
proto_binary_fetched_float 0
proto_binary_fetched_double 0
proto_binary_fetched_date 0
proto_binary_fetched_year 0
proto_binary_fetched_time 0
proto_binary_fetched_datetime 0
proto_binary_fetched_timestamp 0
proto_binary_fetched_string 0
proto_binary_fetched_json 0
proto_binary_fetched_blob 0
proto_binary_fetched_enum 0
proto_binary_fetched_set 0
proto_binary_fetched_geometry 0
proto_binary_fetched_other 0
init_command_executed_count 0
init_command_failed_count 0
com_quit 0
com_init_db 0
com_query 0
com_field_list 0
com_create_db 0
com_drop_db 0
com_refresh 0
com_shutdown 0
com_statistics 0
com_process_info 0
com_connect 0
com_process_kill 0
com_debug 0
com_ping 0
com_time 0
com_delayed_insert 0
com_change_user 0
com_binlog_dump 0
com_table_dump 0
com_connect_out 0
com_register_slave 0
com_stmt_prepare 0
com_stmt_execute 0
com_stmt_send_long_data 0
com_stmt_close 0
com_stmt_reset 0
com_stmt_set_option 0
com_stmt_fetch 0
com_deamon 0
bytes_received_real_data_normal 0
bytes_received_real_data_ps 0
odbc
ODBC Support enabled
Active Persistent Links 0
Active Links 0
ODBC library unixODBC
ODBC_INCLUDE -I/usr/include
ODBC_LFLAGS -L/usr/lib
ODBC_LIBS -lodbc
Directive Local Value Master Value
odbc.allow_persistent On On
odbc.check_persistent On On
odbc.default_cursortype Static cursor Static cursor
odbc.default_db no value no value
odbc.default_pw no value no value
odbc.default_user no value no value
odbc.defaultbinmode return as is return as is
odbc.defaultlrl return up to 4096 bytes return up to 4096 bytes
odbc.max_links Unlimited Unlimited
odbc.max_persistent Unlimited Unlimited
openssl
OpenSSL support enabled
OpenSSL Library Version OpenSSL 1.1.1g 21 Apr 2020
OpenSSL Header Version OpenSSL 1.1.1g 21 Apr 2020
Openssl default config /usr/lib/ssl/openssl.cnf
Directive Local Value Master Value
openssl.cafile no value no value
openssl.capath no value no value
pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 8.44 2020-02-12
Directive Local Value Master Value
pcre.backtrack_limit 1000000 1000000
pcre.recursion_limit 100000 100000
PDO
PDO support enabled
PDO drivers mysql, odbc, sqlite
pdo_mysql
PDO Driver for MySQL enabled
Client API version mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
Directive Local Value Master Value
pdo_mysql.default_socket /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sock
PDO_ODBC
PDO Driver for ODBC (unixODBC) enabled
ODBC Connection Pooling Enabled, strict matching
pdo_sqlite
PDO Driver for SQLite 3.x enabled
SQLite Library 3.31.1
Phar
Phar: PHP Archive support enabled
Phar EXT version 2.0.2
Phar API version 1.1.1
SVN revision $Id: 6e5cec2462a6ded53d4379ea9a69487a60d5c43c $
Phar-based phar archives enabled
Tar-based phar archives enabled
ZIP-based phar archives enabled
gzip compression enabled
bzip2 compression enabled
Native OpenSSL support enabled
Phar based on pear/PHP_Archive, original concept by Davey Shafik.
Phar fully realized by Gregory Beaver and Marcus Boerger.
Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle.
Directive Local Value Master Value
phar.cache_list no value no value
phar.readonly On On
phar.require_hash On On
posix
Revision $Id: 5f4acc20904b1406142f2a0ede068db048c77e77 $
pspell
PSpell Support enabled
readline
Readline Support enabled
Readline library EditLine wrapper
Directive Local Value Master Value
cli.pager no value no value
cli.prompt \b \> \b \>
Reflection
Reflection enabled
Version $Id: 5f15287237d5f78d75b19c26915aa7bd83dee8b8 $
session
Session Support enabled
Registered save handlers files user
Registered serializer handlers php_serialize php php_binary wddx
Directive Local Value Master Value
session.auto_start Off Off
session.cache_expire 180 180
session.cache_limiter nocache nocache
session.cookie_domain no value no value
session.cookie_httponly Off Off
session.cookie_lifetime 0 0
session.cookie_path / /
session.cookie_secure Off Off
session.entropy_file /dev/urandom /dev/urandom
session.entropy_length 32 32
session.gc_divisor 1000 1000
session.gc_maxlifetime 1440 1440
session.gc_probability 0 0
session.hash_bits_per_character 5 5
session.hash_function 0 0
session.name PHPSESSID PHPSESSID
session.referer_check no value no value
session.save_handler files files
session.save_path /home/charliephillips/tmp /home/charliephillips/tmp
session.serialize_handler php php
session.upload_progress.cleanup On On
session.upload_progress.enabled On On
session.upload_progress.freq 1% 1%
session.upload_progress.min_freq 1 1
session.upload_progress.name PHP_SESSION_UPLOAD_PROGRESS PHP_SESSION_UPLOAD_PROGRESS
session.upload_progress.prefix upload_progress_ upload_progress_
session.use_cookies On On
session.use_only_cookies On On
session.use_strict_mode Off Off
session.use_trans_sid 0 0
shmop
shmop support enabled
SimpleXML
Simplexml support enabled
Revision $Id: d7077fc935154236afb4fe70814ba358efdbdca4 $
Schema support enabled
snmp
NET-SNMP Support enabled
NET-SNMP Version 5.8
PHP SNMP Version 0.1
soap
Soap Client enabled
Soap Server enabled
Directive Local Value Master Value
soap.wsdl_cache 1 1
soap.wsdl_cache_dir /tmp /tmp
soap.wsdl_cache_enabled 1 1
soap.wsdl_cache_limit 5 5
soap.wsdl_cache_ttl 86400 86400
sockets
Sockets Support enabled
SPL
SPL support enabled
Interfaces Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
Classes AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, CallbackFilterIterator, DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveCallbackFilterIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException
sqlite3
SQLite3 support enabled
SQLite3 module version 0.7-dev
SQLite Library 3.31.1
Directive Local Value Master Value
sqlite3.defensive 1 1
sqlite3.extension_dir no value no value
standard
Dynamic Library Support enabled
Path to sendmail /usr/sbin/sendmail -t -i
Directive Local Value Master Value
assert.active 1 1
assert.bail 0 0
assert.callback no value no value
assert.quiet_eval 0 0
assert.warning 1 1
auto_detect_line_endings 0 0
default_socket_timeout 60 60
from no value no value
url_rewriter.tags a=href,area=href,frame=src,input=src,form=fakeentry a=href,area=href,frame=src,input=src,form=fakeentry
user_agent no value no value
sysvmsg
sysvmsg support enabled
Revision $Id: 58590192720bc56939152fde3645d808b348bb9b $
tokenizer
Tokenizer Support enabled
wddx
WDDX Support enabled
WDDX Session Serializer enabled
xml
XML Support active
XML Namespace Support active
libxml2 Version 2.9.10
xmlreader
XMLReader enabled
xmlrpc
core library version xmlrpc-epi v. 0.54
php extension version 0.51
author Dan Libby
homepage http://xmlrpc-epi.sourceforge.net
open sourced by Epinions.com
xmlwriter
XMLWriter enabled
xsl
XSL enabled
libxslt Version 1.1.34
libxslt compiled against libxml Version 2.9.10
EXSLT enabled
libexslt Version 1.1.34
Zend OPcache
Opcode Caching Up and Running
Optimization Enabled
Startup OK
Shared memory model mmap
Cache hits 67679
Cache misses 181
Used memory 17277504
Free memory 49831360
Wasted memory 0
Interned Strings Used memory 2227360
Interned Strings Free memory 1966944
Cached scripts 181
Cached keys 182
Max keys 3907
OOM restarts 0
Hash keys restarts 0
Manual restarts 0
Directive Local Value Master Value
opcache.blacklist_filename no value no value
opcache.consistency_checks 0 0
opcache.dups_fix Off Off
opcache.enable On On
opcache.enable_cli Off Off
opcache.enable_file_override Off Off
opcache.error_log no value no value
opcache.fast_shutdown 0 0
opcache.file_update_protection 2 2
opcache.force_restart_timeout 180 180
opcache.inherited_hack On On
opcache.interned_strings_buffer 4 4
opcache.load_comments 1 1
opcache.lockfile_path /tmp /tmp
opcache.log_verbosity_level 1 1
opcache.max_accelerated_files 2000 2000
opcache.max_file_size 0 0
opcache.max_wasted_percentage 5 5
opcache.memory_consumption 64 64
opcache.optimization_level 0x7FFFBFFF 0x7FFFBFFF
opcache.preferred_memory_model no value no value
opcache.protect_memory 0 0
opcache.restrict_api no value no value
opcache.revalidate_freq 2 2
opcache.revalidate_path Off Off
opcache.save_comments 1 1
opcache.use_cwd On On
opcache.validate_permission Off Off
opcache.validate_root Off Off
opcache.validate_timestamps On On
zip
Zip enabled
Zip version 1.12.5
Libzip version 1.7.3
zlib
ZLib Support enabled
Stream Wrapper compress.zlib://
Stream Filter zlib.inflate, zlib.deflate
Compiled Version 1.2.11
Linked Version 1.2.11
Directive Local Value Master Value
zlib.output_compression Off Off
zlib.output_compression_level -1 -1
zlib.output_handler no value no value
Additional Modules
Module Name
sysvsem
sysvshm
Environment
Variable Value
USER charliephillips
HOME /home/charliephillips
PHP Variables
Variable Value
_COOKIE["templateWidth"] 93
_COOKIE["fontSize"] 100
_COOKIE["__utma"] 265643869.949568837.1597637317.1601574071.1601616918.6
_COOKIE["__utmz"] 265643869.1597637317.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)
_COOKIE["__gads"] ID=28fb3f7a7744ca1d-223341f535c40020:T=1603249469:RT=1603249469:S=ALNI_MYVuotBIIB4Iehp5rT9c0tAMs-PNA
_COOKIE["765c9b3a4cf61a96556dbd778c075cf8"] 21kv4ttvqsh0oqree5f49on976
_COOKIE["__utmc"] 265643869
_COOKIE["73e2b942ff6cca04d0f8329447081de0"] vpqa9ra4m2ismp4df1is5s6nt0
_SERVER["USER"] charliephillips
_SERVER["HOME"] /home/charliephillips
_SERVER["FCGI_ROLE"] RESPONDER
_SERVER["SCRIPT_URL"] /phpinfo.php
_SERVER["SCRIPT_URI"] http://charliephillips.net/phpinfo.php
_SERVER["HTTP_AUTHORIZATION"] no value
_SERVER["proxy-nokeepalive"] 1
_SERVER["HTTP_HOST"] charliephillips.net
_SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (X11; Linux x86_64; rv:83.0) Gecko/20100101 Firefox/83.0
_SERVER["HTTP_ACCEPT"] text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
_SERVER["HTTP_ACCEPT_LANGUAGE"] en-US,en;q=0.5
_SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate
_SERVER["HTTP_CONNECTION"] keep-alive
_SERVER["HTTP_COOKIE"] templateWidth=93; fontSize=100; __utma=265643869.949568837.1597637317.1601574071.1601616918.6; __utmz=265643869.1597637317.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); __gads=ID=28fb3f7a7744ca1d-223341f535c40020:T=1603249469:RT=1603249469:S=ALNI_MYVuotBIIB4Iehp5rT9c0tAMs-PNA; 765c9b3a4cf61a96556dbd778c075cf8=21kv4ttvqsh0oqree5f49on976; __utmc=265643869; 73e2b942ff6cca04d0f8329447081de0=vpqa9ra4m2ismp4df1is5s6nt0
_SERVER["HTTP_UPGRADE_INSECURE_REQUESTS"] 1
_SERVER["PATH"] /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
_SERVER["SERVER_SIGNATURE"] no value
_SERVER["SERVER_SOFTWARE"] Apache
_SERVER["SERVER_NAME"] charliephillips.net
_SERVER["SERVER_ADDR"] 207.244.225.110
_SERVER["SERVER_PORT"] 80
_SERVER["REMOTE_ADDR"] 74.113.146.211
_SERVER["DOCUMENT_ROOT"] /home/charliephillips/public_html
_SERVER["REQUEST_SCHEME"] http
_SERVER["CONTEXT_PREFIX"] no value
_SERVER["CONTEXT_DOCUMENT_ROOT"] /home/charliephillips/public_html
_SERVER["SERVER_ADMIN"] [no address given]
_SERVER["SCRIPT_FILENAME"] /home/charliephillips/public_html/phpinfo.php
_SERVER["REMOTE_PORT"] 45878
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["REQUEST_METHOD"] GET
_SERVER["QUERY_STRING"] no value
_SERVER["REQUEST_URI"] /phpinfo.php
_SERVER["SCRIPT_NAME"] /phpinfo.php
_SERVER["PHP_SELF"] /phpinfo.php
_SERVER["REQUEST_TIME_FLOAT"] 1607187650.8086
_SERVER["REQUEST_TIME"] 1607187650
PHP Credits
PHP Group
Thies C. Arntzen, Stig Bakken, Shane Caraveo, Andi Gutmans, Rasmus Lerdorf, Sam Ruby, Sascha Schumann, Zeev Suraski, Jim Winstead, Andrei Zmievski
Language Design & Concept
Andi Gutmans, Rasmus Lerdorf, Zeev Suraski, Marcus Boerger
PHP Authors
Contribution Authors
Zend Scripting Language Engine Andi Gutmans, Zeev Suraski, Stanislav Malyshev, Marcus Boerger, Dmitry Stogov, Xinchen Hui, Nikita Popov
Extension Module API Andi Gutmans, Zeev Suraski, Andrei Zmievski
UNIX Build and Modularization Stig Bakken, Sascha Schumann, Jani Taskinen
Windows Port Shane Caraveo, Zeev Suraski, Wez Furlong, Pierre-Alain Joye, Anatol Belski
Server API (SAPI) Abstraction Layer Andi Gutmans, Shane Caraveo, Zeev Suraski
Streams Abstraction Layer Wez Furlong, Sara Golemon
PHP Data Objects Layer Wez Furlong, Marcus Boerger, Sterling Hughes, George Schlossnagle, Ilia Alshanetsky
Output Handler Zeev Suraski, Thies C. Arntzen, Marcus Boerger, Michael Wallner
SAPI Modules
Contribution Authors
AOLserver Sascha Schumann
Apache 1.3 (apache_hooks) Rasmus Lerdorf, Zeev Suraski, Stig Bakken, David Sklar, George Schlossnagle, Lukas Schroeder
Apache 1.3 Rasmus Lerdorf, Zeev Suraski, Stig Bakken, David Sklar
Apache 2.0 Filter Sascha Schumann, Aaron Bannert
Apache 2.0 Handler Ian Holsman, Justin Erenkrantz (based on Apache 2.0 Filter code)
Caudium / Roxen David Hedbor
CGI / FastCGI Rasmus Lerdorf, Stig Bakken, Shane Caraveo, Dmitry Stogov
CLI Edin Kadribasic, Marcus Boerger, Johannes Schlueter, Moriyoshi Koizumi, Xinchen Hui
Continuity Alex Leigh (based on nsapi code)
Embed Edin Kadribasic
FastCGI Process Manager Andrei Nigmatulin, dreamcat4, Antony Dovgal, Jerome Loyet
ISAPI Andi Gutmans, Zeev Suraski
litespeed George Wang
NSAPI Jayakumar Muthukumarasamy, Uwe Schindler
phpdbg Felipe Pena, Joe Watkins, Bob Weinand
phttpd Thies C. Arntzen
pi3web Holger Zimmermann
Sendmail Milter Harald Radi
thttpd Sascha Schumann
tux Sascha Schumann
WebJames Alex Waugh
Module Authors
Module Authors
BC Math Andi Gutmans
Bzip2 Sterling Hughes
Calendar Shane Caraveo, Colin Viebrock, Hartmut Holzgraefe, Wez Furlong
COM and .Net Wez Furlong
ctype Hartmut Holzgraefe
cURL Sterling Hughes
Date/Time Support Derick Rethans
DB-LIB (MS SQL, Sybase) Wez Furlong, Frank M. Kromann
DBA Sascha Schumann, Marcus Boerger
DOM Christian Stocker, Rob Richards, Marcus Boerger
enchant Pierre-Alain Joye, Ilia Alshanetsky
ereg Rasmus Lerdorf, Jim Winstead, Jaakko Hyvätti
EXIF Rasmus Lerdorf, Marcus Boerger
fileinfo Ilia Alshanetsky, Pierre Alain Joye, Scott MacVicar, Derick Rethans
Firebird driver for PDO Ard Biesheuvel
FTP Stefan Esser, Andrew Skalski
GD imaging Rasmus Lerdorf, Stig Bakken, Jim Winstead, Jouni Ahto, Ilia Alshanetsky, Pierre-Alain Joye, Marcus Boerger
GetText Alex Plotnick
GNU GMP support Stanislav Malyshev
Iconv Rui Hirokawa, Stig Bakken, Moriyoshi Koizumi
IMAP Rex Logan, Mark Musone, Brian Wang, Kaj-Michael Lang, Antoni Pamies Olive, Rasmus Lerdorf, Andrew Skalski, Chuck Hagenbuch, Daniel R Kalowsky
Input Filter Rasmus Lerdorf, Derick Rethans, Pierre-Alain Joye, Ilia Alshanetsky
InterBase Jouni Ahto, Andrew Avdeev, Ard Biesheuvel
Internationalization Ed Batutis, Vladimir Iordanov, Dmitry Lakhtyuk, Stanislav Malyshev, Vadim Savchuk, Kirti Velankar
JSON Omar Kilani, Scott MacVicar
LDAP Amitay Isaacs, Eric Warnke, Rasmus Lerdorf, Gerrit Thomson, Stig Venaas
LIBXML Christian Stocker, Rob Richards, Marcus Boerger, Wez Furlong, Shane Caraveo
mcrypt Sascha Schumann, Derick Rethans
MS SQL Frank M. Kromann
Multibyte String Functions Tsukada Takuya, Rui Hirokawa
MySQL driver for PDO George Schlossnagle, Wez Furlong, Ilia Alshanetsky, Johannes Schlueter
MySQL Zeev Suraski, Zak Greant, Georg Richter, Andrey Hristov
MySQLi Zak Greant, Georg Richter, Andrey Hristov, Ulf Wendel
MySQLnd Andrey Hristov, Ulf Wendel, Georg Richter, Johannes Schlüter
OCI8 Stig Bakken, Thies C. Arntzen, Andy Sautins, David Benson, Maxim Maletsky, Harald Radi, Antony Dovgal, Andi Gutmans, Wez Furlong, Christopher Jones, Oracle Corporation
ODBC driver for PDO Wez Furlong
ODBC Stig Bakken, Andreas Karajannis, Frank M. Kromann, Daniel R. Kalowsky
OpenSSL Stig Venaas, Wez Furlong, Sascha Kettler, Scott MacVicar
Oracle (OCI) driver for PDO Wez Furlong
pcntl Jason Greene, Arnaud Le Blanc
Perl Compatible Regexps Andrei Zmievski
PHP Archive Gregory Beaver, Marcus Boerger
PHP Data Objects Wez Furlong, Marcus Boerger, Sterling Hughes, George Schlossnagle, Ilia Alshanetsky
PHP hash Sara Golemon, Rasmus Lerdorf, Stefan Esser, Michael Wallner, Scott MacVicar
Posix Kristian Koehntopp
PostgreSQL driver for PDO Edin Kadribasic, Ilia Alshanetsky
PostgreSQL Jouni Ahto, Zeev Suraski, Yasuo Ohgaki, Chris Kings-Lynne
Pspell Vlad Krupin
Readline Thies C. Arntzen
Recode Kristian Koehntopp
Reflection Marcus Boerger, Timm Friebe, George Schlossnagle, Andrei Zmievski, Johannes Schlueter
Sessions Sascha Schumann, Andrei Zmievski
Shared Memory Operations Slava Poliakov, Ilia Alshanetsky
SimpleXML Sterling Hughes, Marcus Boerger, Rob Richards
SNMP Rasmus Lerdorf, Harrie Hazewinkel, Mike Jackson, Steven Lawrance, Johann Hanne, Boris Lytochkin
SOAP Brad Lafountain, Shane Caraveo, Dmitry Stogov
Sockets Chris Vandomelen, Sterling Hughes, Daniel Beulshausen, Jason Greene
SPL Marcus Boerger, Etienne Kneuss
SQLite 3.x driver for PDO Wez Furlong
SQLite3 Scott MacVicar, Ilia Alshanetsky, Brad Dewar
Sybase-CT Zeev Suraski, Tom May, Timm Friebe
System V Message based IPC Wez Furlong
System V Semaphores Tom May
System V Shared Memory Christian Cartus
tidy John Coggeshall, Ilia Alshanetsky
tokenizer Andrei Zmievski, Johannes Schlueter
WDDX Andrei Zmievski
XML Stig Bakken, Thies C. Arntzen, Sterling Hughes
XMLReader Rob Richards
xmlrpc Dan Libby
XMLWriter Rob Richards, Pierre-Alain Joye
XSL Christian Stocker, Rob Richards
Zip Pierre-Alain Joye, Remi Collet
Zlib Rasmus Lerdorf, Stefan Roehrich, Zeev Suraski, Jade Nicoletti, Michael Wallner
PHP Documentation
Authors Mehdi Achour, Friedhelm Betz, Antony Dovgal, Nuno Lopes, Hannes Magnusson, Georg Richter, Damien Seguy, Jakub Vrana, Adam Harvey, Peter Cowburn
Editor Philip Olson
User Note Maintainers Daniel P. Brown, Thiago Henrique Pojda
Other Contributors Previously active authors, editors and other contributors are listed in the manual.
PHP Quality Assurance Team
Ilia Alshanetsky, Joerg Behrens, Antony Dovgal, Stefan Esser, Moriyoshi Koizumi, Magnus Maatta, Sebastian Nohn, Derick Rethans, Melvyn Sopacua, Jani Taskinen, Pierre-Alain Joye, Dmitry Stogov, Felipe Pena, David Soria Parra, Stanislav Malyshev, Julien Pauli, Stephen Zarkos, Anatol Belski, Remi Collet, Ferenc Kovacs
Websites and Infrastructure team
PHP Websites Team Rasmus Lerdorf, Hannes Magnusson, Philip Olson, Lukas Kahwe Smith, Pierre-Alain Joye, Kalle Sommer Nielsen, Peter Cowburn, Adam Harvey, Ferenc Kovacs, Levi Morrison
Event Maintainers Damien Seguy, Daniel P. Brown
Network Infrastructure Daniel P. Brown
Windows Infrastructure Alex Schoenmaker
PHP License

This program is free software; you can redistribute it and/or modify it under the terms of the PHP License as published by the PHP Group and included in the distribution in the file: LICENSE

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

If you did not receive a copy of the PHP license, or have any questions about PHP licensing, please contact license@php.net.
1
Ilia's picture
Submitted by Ilia on Sat, 12/05/2020 - 11:14

.. then you would need :

  1. Check Apache error logs
  2. If needed enable error displaying on PHP app to get clearer picture of what's failing

I would start from changing virtual server to use PHP version 7.3.

These sites are php5.6 only, and will not be getting upgraded, this one is Joomla, my php7 sites work fine.

This is my only error.

[Wed Nov 25 00:46:21.574410 2020] [proxy_fcgi:error] [pid 282122] [client 193.106.31.130:59774] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Error: Call to undefined function set_magic_quotes_runtime() in /home/charliephillips/public_html/administrator/includes/framework.php:21\nStack trace:\n#0 /home/charliephillips/public_html/administrator/index.php(22): require_once()\n#1 {main}\n  thrown in /home/charliephillips/public_html/administrator/includes/framework.php on line 21'

set_magic_quotes_runtime does not exist in php7, but should in php5.6, and this is 5.6, deprecated in 5.3, phpinfo proved that.

I added with no help.

if (!function_exists('set_magic_quotes_runtime')) {
    function set_magic_quotes_runtime($new_setting) {
        return true;
    }
}

I commented out the line did not help.

Thanks, Jeff

Ilia's picture
Submitted by Ilia on Sat, 12/05/2020 - 12:04

Jeff, I will be be able to help you rewrite your PHP app.

As set_magic_quotes_runtime() function was removed in PHP 7, you should use PHP 5.6 for this virtual server or for this particular directory.

I commented out that line since it is setting it off anyways, and off is the default, I do not get this error now, but MySQL still does not work, so there are no current errors in the error log, and I think I got this error switching to php7, to begin with, it is the only error in the log.

I have an old Joomla and Drupal site that needs 5.6, I cannot upgrade them due to other parts written for php5.6, these are historical sites only, nothing new is added to them, so this is affecting both Joomla and Drupal, both older versions that only run under php5.6, installed using the script installer.

If I switch to php7 I get a blank screen.

Thanks, Jeff

Ilia's picture
Submitted by Ilia on Sat, 12/05/2020 - 17:35

but MySQL still does not work

Have you imported the database? Is the database credentials on the PHP app (database name, username, password and etc are set correctly?

Can you connect to the database using console and query something?

If you create a simple PHP file, and try to connect and then run a simple select MySQL query on some table in a database, how does it behave? (remember, you would need to enable error printing, either in PHP config or in the script itself.

For the script try to go with:

ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

PHP global config can be controlled from PHP configuration page under given virtual server.

I made the changes to php configuration global for php5.6, I am sure this does the same thing, but I am not seeing any new errors.

error_reporting = E_ALL
display_errors = On
display_startup_errors = On

I can ssh into MySQL and using the same credentials as VM log in, and I can see the databases are there, I have tried to restore the backups since the 6.14 release, I can now change the PHP version.

This is only php5.6 sites, all my php7 sites work fine.

Thanks, Jeff

Ilia's picture
Submitted by Ilia on Sat, 12/05/2020 - 18:18

Now, you should be able to see warnings and errors?

If you don't, perhaps you need to change something on the app itself.

Under PHP-FPM-Configuration -> Error Logging.

Now I see a bunch of stuff, but nothing that is causing this issue.

I attached the errors.

Thanks, Jeff

Today Charlie Philips Domain died, so it died with him, I think rremelin did not renew it since Charlie did not like the Alpha version, no reason to keep the site up, now I have a different Joomla site to deal with, and this time I noticed that Mail still works, it does not use MySQL, so this seems to prove that php5.6 MySQL is not working, and I did try to uninstall and reinstall them, this is David Hinson's web site, he is in prison for political reasons, I want it up because I knew him, and hosted the site before he was arrested, like most sites that put out the message our Constitution in the U.S. is gone, and this is all Treason, is a message I put out, and all my sites do as well, so we are always getting pounded on, I am Retired Military, and they know this is the truth, the Law even proves the US is a Franchise, but this is not a Politial Issue, it is a php5.6 and MySql issue, and should be much easier to fix then the issues the sites deal with, taking an Oath to Defend and Protect the Constition always comes at a cost, allowing anyone buy Congress to Print Money is Tresason, ask JFK, but I do not need political advice, I need the web sites back up, if this cannot be done, just level with me as to why, can you get Joomla 1.5 to work under php5.6 or not, you should be able to reproduce this, just install it, and test it, not much to ask, I tried it on CentOS, Debian and Ubuntu, just duplicate it, that is all I ask, you are looking at this like it is my issue, when Joomla 1.5 was a support script, and not your fault it is not now, but we need to put this to bed if you cannot reproduce this error, I have multiple Joomla sites with the same issue as the old Drupal sites with the same issue, this is Php5.6 and MySQL issue, and after moving from one server to the next chasing this issue, you can understand why I sound upset, not at you guys, I understand this bug has nothing to do with VM, I get it, I have cancer and get cranky, and do not mean to be mean, I would not have these site is not for Virtual Min, it is worth the LIcense fee, and we will continue as loyal customers with you, as long as we live, but I need you to reproduce this, so we can both know this is not my issue with this server, and is in fact, a bug in the php5.6 MySQL, and has been reproduced, otherwise, this server has a serious issue, and I need to fix it, even if I delete all the php5.6 sites, which me and rremelin, the one this licenses is under, are about to give up on php5.6, but want to know if this is something you can reprocude, just install Joomla 1.5 and I upgraded my only Drupal site, so I do not care about it, but it does have the same issue, but I could not have it down, so I was force to switch to WordPress, who is going to release a security risk today, so much fun having cancer and dealing with all this at the same time.

http://davidhinkson.info

http://davidhinkson.info/mail/src/login.php

and

http://thelastoutpost.com/

Only two sites now that Charlie is dead.

Thanks, Jeff

Let's close all php5.6 issues, we are done with it, and so is everyone else.

Is this the right way to remove it on Ubuntu 20?

apt-get remove php56-php-{cli,pdo,fpm,zip,gd,xml,mysqlnd}
apt-get purge php5.6\*
apt autoremove

I talked to rremelin, we are going to let it go, and not update the sites, but start new with WordPress.

The server is much more stable without it.

Thanks, Jeff