VM on proxmox Cantos 7 mysql Ver 8.0.20 for Linux on x86_64 (MySQL Community Server - GPL)   PHP logoPHP Version 7.3.17System Linux sip 3.10.0-1127.el7.x86_64 #1 SMP Tue Mar 31 23:36:51 UTC 2020 x86_64Build Date Apr 14 2020 08:29:22Server API FPM/FastCGIVirtual Directory Support disabledConfiguration File (php.ini) Path /etcLoaded Configuration File /etc/php.iniScan this dir for additional .ini files /etc/php.dAdditional .ini files parsed /etc/php.d/10-opcache.ini, /etc/php.d/20-bz2.ini, /etc/php.d/20-calendar.ini, /etc/php.d/20-ctype.ini, /etc/php.d/20-curl.ini, /etc/php.d/20-dom.ini, /etc/php.d/20-exif.ini, /etc/php.d/20-fileinfo.ini, /etc/php.d/20-ftp.ini, /etc/php.d/20-gd.ini, /etc/php.d/20-gettext.ini, /etc/php.d/20-iconv.ini, /etc/php.d/20-json.ini, /etc/php.d/20-mbstring.ini, /etc/php.d/20-mysqlnd.ini, /etc/php.d/20-pdo.ini, /etc/php.d/20-phar.ini, /etc/php.d/20-simplexml.ini, /etc/php.d/20-sockets.ini, /etc/php.d/20-sqlite3.ini, /etc/php.d/20-tokenizer.ini, /etc/php.d/20-xml.ini, /etc/php.d/20-xmlwriter.ini, /etc/php.d/20-xsl.ini, /etc/php.d/30-mysqli.ini, /etc/php.d/30-pdo_mysql.ini, /etc/php.d/30-pdo_sqlite.ini, /etc/php.d/30-wddx.ini, /etc/php.d/30-xmlreader.iniPHP API 20180731PHP Extension 20180731Zend Extension 320180731Zend Extension Build API320180731,NTSPHP Extension Build API20180731,NTSDebug Build noThread Safety disabledZend Signal Handling enabledZend Memory Manager enabledZend Multibyte Support provided by mbstringIPv6 Support enabledDTrace Support available, disabledRegistered PHP Streams https, ftps, compress.zlib, php, file, glob, data, http, ftp, compress.bzip2, pharRegistered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, tls, tlsv1.0, tlsv1.1, tlsv1.2Registered Stream Filters zlib. , string.rot13, string.toupper, string.tolower, string.strip_tags, convert. , consumed, dechunk, bzip2. , convert.iconv.*Zend logoThis program makes use of the Zend Scripting Language Engine:Zend Engine v3.3.17, Copyright (c) 1998-2018 Zend Technologies    with Zend OPcache v7.3.17, Copyright (c) 1999-2018, by Zend TechnologiesConfigurationbz2BZip2 Support EnabledStream Wrapper support compress.bzip2://Stream Filter support bzip2.decompress, bzip2.compressBZip2 Version 1.0.6, 6-Sept-2010calendarCalendar support enabledcgi-fcgiphp-fpm activeDirective Local Value Master Valuecgi.discard_path 0 0cgi.fix_pathinfo 1 1cgi.force_redirect 1 1cgi.nph 0 0cgi.redirect_status_env no value no valuecgi.rfc2616_headers 0 0fastcgi.error_header no value no valuefastcgi.logging 1 1fpm.config no value no valueCorePHP Version 7.3.17Directive Local Value Master Valueallow_url_fopen On Onallow_url_include Off Offarg_separator.input & &arg_separator.output & &auto_append_file no value no valueauto_globals_jit On Onauto_prepend_file no value no valuebrowscap no value no valuedefault_charset UTF-8 UTF-8default_mimetype text/html text/htmldisable_classes no value no valuedisable_functions no value no valuedisplay_errors Off Offdisplay_startup_errors Off Offdoc_root no value no valuedocref_ext no value no valuedocref_root no value no valueenable_dl Off Offenable_post_data_reading On Onerror_append_string no value no valueerror_log /var/log/php-fpm/www-error.log /var/log/php-fpm/www-error.logerror_prepend_string no value no valueerror_reporting 22527 22527expose_php On Onextension_dir /usr/lib64/php/modules /usr/lib64/php/modulesfile_uploads On Onhard_timeout 2 2highlight.comment #FF8000 #FF8000highlight.default #0000BB #0000BBhighlight.html #000000 #000000highlight.keyword #007700 #007700highlight.string #DD0000 #DD0000html_errors On Onignore_repeated_errors Off Offignore_repeated_source Off Offignore_user_abort Off Offimplicit_flush Off Offinclude_path .:/usr/share/pear:/usr/share/php .:/usr/share/pear:/usr/share/phpinput_encoding no value no valueinternal_encoding no value no valuelog_errors On Onlog_errors_max_len 1024 1024mail.add_x_header Off Offmail.force_extra_parameters no value no valuemail.log no value no valuemax_execution_time 3000 3000max_file_uploads 20 20max_input_nesting_level 64 64max_input_time 60 60max_input_vars 1000 1000memory_limit 512M 512Mopen_basedir no value no valueoutput_buffering 4096 4096output_encoding no value no valueoutput_handler no value no valuepost_max_size 20M 20Mprecision 14 14realpath_cache_size 4096K 4096Krealpath_cache_ttl 120 120register_argc_argv Off Offreport_memleaks On Onreport_zend_debug On Onrequest_order GP GPsendmail_from no value no valuesendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -iserialize_precision -1 -1short_open_tag On OnSMTP localhost localhostsmtp_port 25 25sys_temp_dir no value no valuesyslog.facility LOG_USER LOG_USERsyslog.filter no-ctrl no-ctrlsyslog.ident php phptrack_errors Off Offunserialize_callback_func no value no valueupload_max_filesize 20M 20Mupload_tmp_dir no value no valueuser_dir no value no valueuser_ini.cache_ttl 300 300user_ini.filename .user.ini .user.inivariables_order GPCS GPCSxmlrpc_error_number 0 0xmlrpc_errors Off Offzend.assertions -1 -1zend.detect_unicode On Onzend.enable_gc On Onzend.multibyte Off Offzend.script_encoding no value no valuezend.signal_check Off Offctypectype functions enabledcurlcURL support enabledcURL Information 7.29.0Age 3FeaturesAsynchDNS YesCharConv NoDebug NoGSS-Negotiate YesIDN YesIPv6 Yeskrb4 NoLargefile Yeslibz YesNTLM YesNTLMWB YesSPNEGO NoSSL YesSSPI NoTLS-SRP NoProtocols dict, file, ftp, ftps, gopher, http, https, imap, imaps, ldap, ldaps, pop3, pop3s, rtsp, scp, sftp, smtp, smtps, telnet, tftpHost x86_64-redhat-linux-gnuSSL Version NSS/3.44ZLib Version 1.2.7libSSH Version libssh2/1.8.0Directive Local Value Master Valuecurl.cainfo no value no valuedatedate/time support enabledtimelib version 2018.03"Olson" Timezone Database Version 0.systemTimezone Database internalDefault timezone UTCDirective Local Value Master Valuedate.default_latitude 31.7667 31.7667date.default_longitude 35.2333 35.2333date.sunrise_zenith 90.583333 90.583333date.sunset_zenith 90.583333 90.583333date.timezone no value no valuedomDOM/XML enabledDOM/XML API Version 20031129libxml Version 2.9.1HTML Support enabledXPath Support enabledXPointer Support enabledSchema Support enabledRelaxNG Support enabledexifEXIF Support enabledSupported EXIF Version 0220Supported filetypes JPEG, TIFFMultibyte decoding support using mbstring enabledExtended EXIF tag formats Canon, Casio, Fujifilm, Nikon, Olympus, Samsung, Panasonic, DJI, Sony, Pentax, Minolta, Sigma, Foveon, Kyocera, Ricoh, AGFA, EpsonDirective Local Value Master Valueexif.decode_jis_intel JIS JISexif.decode_jis_motorola JIS JISexif.decode_unicode_intel UCS-2LE UCS-2LEexif.decode_unicode_motorola UCS-2BE UCS-2BEexif.encode_jis no value no valueexif.encode_unicode ISO-8859-15 ISO-8859-15fileinfofileinfo support enabledlibmagic 533filterInput Validation and Filtering enabledDirective Local Value Master Valuefilter.default unsafe_raw unsafe_rawfilter.default_flags no value no valueftpFTP support enabledFTPS support enabledgdGD Support enabledGD headers Version 2.3.0GD library Version 2.3.0FreeType Support enabledFreeType Linkage with freetypeFreeType Version 2.8.0GIF Read Support enabledGIF Create Support enabledJPEG Support enabledlibJPEG Version 6bPNG Support enabledlibPNG Version 1.5.13WBMP Support enabledXPM Support enabledlibXpm Version 30411XBM Support enabledWebP Support enabledDirective Local Value Master Valuegd.jpeg_ignore_warning 1 1gettextGetText Support enabledhashhash support enabledHashing Engines md2 md4 md5 sha1 sha224 sha256 sha384 sha512/224 sha512/256 sha512 sha3-224 sha3-256 sha3-384 sha3-512 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,5MHASH support EnabledMHASH API Version Emulated Supporticonviconv support enablediconv implementation glibciconv library version 2.17Directive Local Value Master Valueiconv.input_encoding no value no valueiconv.internal_encoding no value no valueiconv.output_encoding no value no valuejsonjson support enabledjson version 1.7.0libxmllibXML support activelibXML Compiled Version 2.9.1libXML Loaded Version 20901libXML streams enabledmbstringMultibyte Support enabledMultibyte string engine libmbflHTTP input encoding translation disabledlibmbfl version 1.3.2oniguruma version 6.9.4mbstring 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 enabledMultibyte regex (oniguruma) version 6.9.4Directive Local Value Master Valuembstring.detect_order no value no valuembstring.encoding_translation Off Offmbstring.func_overload 0 0mbstring.http_input no value no valuembstring.http_output no value no valuembstring.http_output_conv_mimetypes ^(text/|application/xhtml+xml) ^(text/|application/xhtml+xml)mbstring.internal_encoding no value no valuembstring.language neutral neutralmbstring.regex_stack_limit 100000 100000mbstring.strict_detection Off Offmbstring.substitute_character no value no valuemysqliMysqlI Support enabledClient API library version mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $Active Persistent Links 0Inactive Persistent Links 0Active Links 0Directive Local Value Master Valuemysqli.allow_local_infile Off Offmysqli.allow_persistent On Onmysqli.default_host no value no valuemysqli.default_port 3306 3306mysqli.default_pw no value no valuemysqli.default_socket /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sockmysqli.default_user no value no valuemysqli.max_links Unlimited Unlimitedmysqli.max_persistent Unlimited Unlimitedmysqli.reconnect Off Offmysqli.rollback_on_cached_plink Off Offmysqlndmysqlnd enabledVersion mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $Compression supportedcore SSL supportedextended SSL supportedCommand buffer size 4096Read buffer size 32768Read timeout 86400Collecting statistics YesCollecting memory statistics NoTracing n/aLoaded plugins mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_sha256_passwordAPI Extensions mysqli,pdo_mysqlmysqlnd statistics bytes_sent 217950bytes_received 7071338packets_sent 5506packets_received 81050protocol_overhead_in 324200protocol_overhead_out 22024bytes_received_ok_packet 0bytes_received_eof_packet 0bytes_received_rset_header_packet 12123bytes_received_rset_field_meta_packet 0bytes_received_rset_row_packet 12712bytes_received_prepare_response_packet 1028129bytes_received_change_user_packet 5984502packets_sent_command 2423packets_received_ok 0packets_received_eof 0packets_received_rset_header 1347packets_received_rset_field_meta 0packets_received_rset_row 1847packets_received_prepare_response 15701packets_received_change_user 61248result_set_queries 1347non_result_set_queries 500no_index_used 754bad_index_used 0slow_queries 0buffered_sets 1347unbuffered_sets 0ps_buffered_sets 0ps_unbuffered_sets 0flushed_normal_sets 0flushed_ps_sets 0ps_prepared_never_executed 0ps_prepared_once_executed 0rows_fetched_from_server_normal 59901rows_fetched_from_server_ps 0rows_buffered_from_client_normal 59901rows_buffered_from_client_ps 0rows_fetched_from_client_normal_buffered 59888rows_fetched_from_client_normal_unbuffered 0rows_fetched_from_client_ps_buffered 0rows_fetched_from_client_ps_unbuffered 0rows_fetched_from_client_ps_cursor 0rows_affected_normal 159rows_affected_ps 0rows_skipped_normal 59901rows_skipped_ps 0copy_on_write_saved 0copy_on_write_performed 0command_buffer_too_small 0connect_success 165connect_failure 0connection_reused 1reconnect 0pconnect_success 1active_connections 18446744073709551453active_persistent_connections 1explicit_close 164implicit_close 0disconnect_close 0in_middle_of_command_close 0explicit_free_result 1347implicit_free_result 0explicit_stmt_close 0implicit_stmt_close 0mem_emalloc_count 0mem_emalloc_amount 0mem_ecalloc_count 0mem_ecalloc_amount 0mem_erealloc_count 0mem_erealloc_amount 0mem_efree_count 0mem_efree_amount 0mem_malloc_count 0mem_malloc_amount 0mem_calloc_count 0mem_calloc_amount 0mem_realloc_count 0mem_realloc_amount 0mem_free_count 0mem_free_amount 0mem_estrndup_count 0mem_strndup_count 0mem_estrdup_count 0mem_strdup_count 0mem_edupl_count 0mem_dupl_count 0proto_text_fetched_null 0proto_text_fetched_bit 0proto_text_fetched_tinyint 22845proto_text_fetched_short 0proto_text_fetched_int24 0proto_text_fetched_int 111503proto_text_fetched_bigint 30proto_text_fetched_decimal 32923proto_text_fetched_float 0proto_text_fetched_double 0proto_text_fetched_date 0proto_text_fetched_year 0proto_text_fetched_time 0proto_text_fetched_datetime 21521proto_text_fetched_timestamp 14678proto_text_fetched_string 330924proto_text_fetched_blob 0proto_text_fetched_enum 1479proto_text_fetched_set 0proto_text_fetched_geometry 0proto_text_fetched_other 0proto_binary_fetched_null 0proto_binary_fetched_bit 0proto_binary_fetched_tinyint 0proto_binary_fetched_short 0proto_binary_fetched_int24 0proto_binary_fetched_int 0proto_binary_fetched_bigint 0proto_binary_fetched_decimal 0proto_binary_fetched_float 0proto_binary_fetched_double 0proto_binary_fetched_date 0proto_binary_fetched_year 0proto_binary_fetched_time 0proto_binary_fetched_datetime 0proto_binary_fetched_timestamp 0proto_binary_fetched_string 0proto_binary_fetched_json 0proto_binary_fetched_blob 0proto_binary_fetched_enum 0proto_binary_fetched_set 0proto_binary_fetched_geometry 0proto_binary_fetched_other 0init_command_executed_count 0init_command_failed_count 0com_quit 164com_init_db 164com_query 1847com_field_list 0com_create_db 0com_drop_db 0com_refresh 0com_shutdown 0com_statistics 0com_process_info 0com_connect 0com_process_kill 0com_debug 0com_ping 248com_time 0com_delayed_insert 0com_change_user 0com_binlog_dump 0com_table_dump 0com_connect_out 0com_register_slave 0com_stmt_prepare 0com_stmt_execute 0com_stmt_send_long_data 0com_stmt_close 0com_stmt_reset 0com_stmt_set_option 0com_stmt_fetch 0com_deamon 0bytes_received_real_data_normal 5197480bytes_received_real_data_ps 0opensslOpenSSL support enabledOpenSSL Library Version OpenSSL 1.0.2k-fips 26 Jan 2017OpenSSL Header Version OpenSSL 1.0.2k 26 Jan 2017Openssl default config /etc/pki/tls/openssl.cnfDirective Local Value Master Valueopenssl.cafile no value no valueopenssl.capath no value no valuepcrePCRE (Perl Compatible Regular Expressions) Support enabledPCRE Library Version 10.32 2018-09-10PCRE Unicode Version 11.0.0PCRE JIT Support enabledPCRE JIT Target x86 64bit (little endian + unaligned)Directive Local Value Master Valuepcre.backtrack_limit 1000000 1000000pcre.jit 0 0pcre.recursion_limit 100000 100000PDOPDO support enabledPDO drivers mysql, sqlitepdo_mysqlPDO Driver for MySQL enabledClient API version mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $Directive Local Value Master Valuepdo_mysql.default_socket /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sockpdo_sqlitePDO Driver for SQLite 3.x enabledSQLite Library 3.7.17PharPhar: PHP Archive support enabledPhar API version 1.1.1Phar-based phar archives enabledTar-based phar archives enabledZIP-based phar archives enabledgzip compression enabledbzip2 compression enabledNative OpenSSL support enabledPhar 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 Valuephar.cache_list no value no valuephar.readonly On Onphar.require_hash On OnReflectionReflection enabledsessionSession Support enabledRegistered save handlers files userRegistered serializer handlers php_serialize php php_binary wddxDirective Local Value Master Valuesession.auto_start Off Offsession.cache_expire 180 180session.cache_limiter nocache nocachesession.cookie_domain no value no valuesession.cookie_httponly no value no valuesession.cookie_lifetime 0 0session.cookie_path / /session.cookie_samesite no value no valuesession.cookie_secure 0 0session.gc_divisor 1000 1000session.gc_maxlifetime 1440 1440session.gc_probability 1 1session.lazy_write On Onsession.name PHPSESSID PHPSESSIDsession.referer_check no value no valuesession.save_handler files filessession.save_path /var/lib/php/session /var/lib/php/sessionsession.serialize_handler php phpsession.sid_bits_per_character 5 5session.sid_length 26 26session.upload_progress.cleanup On Onsession.upload_progress.enabled On Onsession.upload_progress.freq 1% 1%session.upload_progress.min_freq 1 1session.upload_progress.name PHP_SESSION_UPLOAD_PROGRESS PHP_SESSION_UPLOAD_PROGRESSsession.upload_progress.prefix upload_progress_ upload_progress_session.use_cookies 1 1session.use_only_cookies 1 1session.use_strict_mode 0 0session.use_trans_sid 0 0SimpleXMLSimpleXML support enabledSchema support enabledsocketsSockets Support enabledSPLSPL support enabledInterfaces OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubjectClasses 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, UnexpectedValueExceptionsqlite3SQLite3 support enabledSQLite Library 3.7.17Directive Local Value Master Valuesqlite3.extension_dir no value no valuestandardDynamic Library Support enabledPath to sendmail /usr/sbin/sendmail -t -iDirective Local Value Master Valueassert.active 1 1assert.bail 0 0assert.callback no value no valueassert.exception 0 0assert.quiet_eval 0 0assert.warning 1 1auto_detect_line_endings 0 0default_socket_timeout 60 60from no value no valuesession.trans_sid_hosts no value no valuesession.trans_sid_tags a=href,area=href,frame=src,form= a=href,area=href,frame=src,form=url_rewriter.hosts no value no valueurl_rewriter.tags form= form=user_agent no value no valuetokenizerTokenizer Support enabledwddxWDDX Support enabledWDDX Session Serializer enabledxmlXML Support activeXML Namespace Support activelibxml2 Version 2.9.1xmlreaderXMLReader enabledxmlwriterXMLWriter enabledxslXSL enabledlibxslt Version 1.1.28libxslt compiled against libxml Version 2.9.1EXSLT enabledlibexslt Version 1.1.28Zend OPcacheOpcode Caching Up and RunningOptimization EnabledSHM Cache EnabledFile Cache DisabledStartup OKShared memory model mmapCache hits 40521Cache misses 115Used memory 12863000Free memory 121354728Wasted memory 0Interned Strings Used memory 737456Interned Strings Free memory 5553576Cached scripts 112Cached keys 185Max keys 7963OOM restarts 0Hash keys restarts 0Manual restarts 0Directive Local Value Master Valueopcache.blacklist_filename /etc/php.d/opcache .blacklist