floogy
Forum Replies Created
-
phpinfo() is looking different as well. Now there appears a mysqli section.
# wget --no-check-certificate -O - https://172.16.240.39:62521/phpinfo.php | lynx -stdin --dump | egrep -i 'pdo|mysql|fpm' --2020-08-31 02:40:12-- https://172.16.240.39:62521/phpinfo.php Connecting to 172.16.240.39:62521... failed: Connection refused. root@FAMP:/var/db/acme/.acme.sh # wget --no-check-certificate -O - https://172.16.240.39/phpinfo.php | lynx -stdin --dump | egrep -i 'pdo|mysql|fpm' --2020-08-31 02:40:23-- https://172.16.240.39/phpinfo.php Connecting to 172.16.240.39:443... connected. WARNING: certificate common name ‘*.floogy.selfhost.eu’ doesn't match requested host name ‘172.16.240.39’. HTTP request sent, awaiting response... 200 OK Length: unspecified [text/html] Saving to: ‘STDOUT’ - [ <=> ] 72.48K --.-KB/s in 0.005s 2020-08-31 02:40:23 (15.5 MB/s) - written to stdout [74218] '--enable-mysqlnd' '--enable-fpm' '--with-fpm-user=www' '--with-fpm-group=www' '--enable-embed' '--enable-dtrace' Server API FPM/FastCGI /usr/local/etc/php/ext-20-mysqli.ini, /usr/local/etc/php/ext-20-pdo.ini, /usr/local/etc/php/ext-20-phar.ini, /usr/local/etc/php/ext-30-pdo_mysql.ini, /usr/local/etc/php/ext-30-pdo_sqlite.ini php-fpm active fpm.config no value no value mysqli MysqlI Support enabled Client API library version mysqlnd 7.4.9 mysqli.allow_local_infile Off Off 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 /tmp/mysql.sock /tmp/mysql.sock 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 7.4.9 mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql API Extensions mysqli,pdo_mysql PDO PDO support enabled PDO drivers mysql, sqlite pdo_mysql PDO Driver for MySQL enabled Client API version mysqlnd 7.4.9 pdo_mysql.default_socket /tmp/mysql.sock /tmp/mysql.sock pdo_sqlite PDO Driver for SQLite 3.x enabled Firebird driver for PDO Ard Biesheuvel MySQL driver for PDO George Schlossnagle, Wez Furlong, Ilia MySQLi Zak Greant, Georg Richter, Andrey Hristov, Ulf Wendel MySQLnd Andrey Hristov, Ulf Wendel, Georg Richter, Johannes Schlüter ODBC driver for PDO Wez Furlong Oracle (OCI) driver for PDO Wez Furlong PostgreSQL driver for PDO Edin Kadribasic, Ilia Alshanetsky SQLite 3.x driver for PDO Wez Furlong
- This reply was modified 4 years, 6 months ago by floogy.
Okay, I think I solved it, but I’m uncertain, what exactly caused this error in the first place.
I read about defining
define('WP_USE_EXT_MYSQL', false);
inwp-config.php
, because php_mysql is outdated, and it’s successor is mysqli, mysqlnd or pdo_mysql.nano /www/wp/soliform/wp-config.php [...] // https://www.ads-software.com/support/topic/fatal-error-uncaught-e-call-to-undefined-function-mysql_connect-wp-db-php/#post-13334531 // define('WP_USE_EXT_MYSQL', true); // https://www.ads-software.com/support/topic/php-fatal-error-uncaught-error-call-to-undefined-function-mysql_connect-in/ // define('WP_USE_EXT_MYSQL', false); //https://www.ads-software.com/support/topic/wsod-when-upgrading-to-php-7x-using-mysqli/#post-12212129 [...]
Due to this I was confused and wanted to use nd_mysql (mysqlnd, native driver), and commented mysqli out.
==> /usr/local/etc/php/ext-20-mysqli.ini <== ;extension=mysqli.so
Also I was missing pdo_mysql.so under /usr/local/lib/php/20190902
Therefore I reinstalled php74-pdo_mysql with portmaster.
===>>> The following actions were performed: Re-installation of php74-pdo-7.4.9 Re-installation of php74-pdo_mysql-7.4.9
After removing the ‘;’ in front of the extension=mysqli.so in /usr/local/etc/php/ext-20-mysqli.ini it finally works!
- This reply was modified 4 years, 6 months ago by floogy.
Maybe ‘localhost installs’ is the wrong section for this topic?
$ LANG=EN wget --no-check-certificate -O - https://172.16.240.39/phpinfo.php | lynx -stdin --dump | egrep -i 'mysql|pdo|fpm' --2020-08-30 13:02:48-- https://172.16.240.39/phpinfo.php Connecting to 172.16.240.39:443... connected. WARNING: The certificate of '172.16.240.39' is not trusted. WARNING: The certificate of '172.16.240.39' has expired. The certificate has expired The certificate's owner does not match hostname '172.16.240.39' HTTP request sent, awaiting response... 200 OK Length: unspecified [text/html] Saving to: 'STDOUT' - [ <=> ] 70.79K --.-KB/s in 0.006s 2020-08-30 13:02:48 (11.8 MB/s) - written to stdout [72490] '--enable-mysqlnd' '--enable-fpm' '--with-fpm-user=www' '--with-fpm-group=www' '--enable-embed' '--enable-dtrace' Server API FPM/FastCGI /usr/local/etc/php/ext-20-mysqli.ini, /usr/local/etc/php/ext-20-pdo.ini, /usr/local/etc/php/ext-20-phar.ini, /usr/local/etc/php/ext-30-pdo_mysql.ini, /usr/local/etc/php/ext-30-pdo_sqlite.ini php-fpm active fpm.config no value no value mysqlnd mysqlnd enabled Version mysqlnd 7.4.9 mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql API Extensions pdo_mysql PDO PDO support enabled PDO drivers mysql, sqlite pdo_mysql PDO Driver for MySQL enabled Client API version mysqlnd 7.4.9 pdo_mysql.default_socket /tmp/mysql.sock /tmp/mysql.sock pdo_sqlite PDO Driver for SQLite 3.x enabled Firebird driver for PDO Ard Biesheuvel MySQL driver for PDO George Schlossnagle, Wez Furlong, Ilia MySQLi Zak Greant, Georg Richter, Andrey Hristov, Ulf Wendel MySQLnd Andrey Hristov, Ulf Wendel, Georg Richter, Johannes Schl??ter ODBC driver for PDO Wez Furlong Oracle (OCI) driver for PDO Wez Furlong PostgreSQL driver for PDO Edin Kadribasic, Ilia Alshanetsky SQLite 3.x driver for PDO Wez Furlong
root@FAMP:~ # php-fpm -i | egrep -i ‘abled|ver’
PHP Version => 7.4.9
Server API => FPM/FastCGI
Virtual Directory Support => disabled
Thread Safety => disabled
Zend Signal Handling => enabled
Zend Memory Manager => enabled
IPv6 Support => enabled
DTrace Support => available, disabled
Registered Stream Filters => string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk, bzip2.*, convert.iconv.*, zlib.*
BZip2 Support => Enabled
BZip2 Version => 1.0.7, 27-Jun-2019
PHP Version => 7.4.9
ctype functions => enabled
date/time support => enabled
timelib version => 2018.03
“Olson” Timezone Database Version => 2020.1
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
EXIF Support => enabled
Supported EXIF Version => 0220
Multibyte decoding support using mbstring => enabled
fileinfo support => enabled
Input Validation and Filtering => enabled
GD Support => enabled
GD headers Version => 2.3.0
GD library Version => 2.3.0
FreeType Support => enabled
GIF Read Support => enabled
GIF Create Support => enabled
JPEG Support => enabled
PNG Support => enabled
WBMP Support => enabled
XBM Support => enabled
WebP Support => enabled
BMP Support => enabled
TGA Read Support => enabled
hash support => enabled
iconv support => enabled
iconv library version => 1.16
json support => enabled
libXML Compiled Version => 2.9.10
libXML Loaded Version => 20910
libXML streams => enabled
Multibyte Support => enabled
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) version => 6.9.5
mbstring.func_overload => 0 => 0
MysqlI Support => enabled
Client API library version => mysqlnd 7.4.9
mysqlnd => enabled
Version => mysqlnd 7.4.9
OpenSSL support => enabled
OpenSSL Library Version => OpenSSL 1.0.2s-freebsd 28 May 2019
OpenSSL Header Version => OpenSSL 1.0.2s-freebsd 28 May 2019
PCRE (Perl Compatible Regular Expressions) Support => enabled
PCRE Library Version => 10.34 2019-11-21
PCRE Unicode Version => 12.1.0
PCRE JIT Support => enabled
PDO support => enabled
PDO drivers => mysql, sqlite
PDO Driver for MySQL => enabled
Client API version => mysqlnd 7.4.9
PDO Driver for SQLite 3.x => enabled
Phar: PHP Archive support => enabled
Phar API version => 1.1.1
Phar-based phar archives => enabled
Tar-based phar archives => enabled
ZIP-based phar archives => enabled
gzip compression => enabled
bzip2 compression => enabled
OpenSSL support => enabled
Phar fully realized by Gregory Beaver and Marcus Boerger.
POSIX support => enabled
Reflection => enabled
Session Support => enabled
session.upload_progress.enabled => On => On
SimpleXML support => enabled
Schema support => enabled
SPL support => enabled
Interfaces => 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 support => enabled
Dynamic Library Support => enabled
Tidy support => enabled
Tokenizer Support => enabled
libxml2 Version => 2.9.10
XMLReader => enabled
XMLWriter => enabled
Optimization => Enabled
SHM Cache => Enabled
File Cache => Disabled
opcache.enable_file_override => Off => Off
opcache.log_verbosity_level => 1 => 1
Zip => enabled
Zip version => 1.15.6
Libzip headers version => 1.5.2
Libzip library version => 1.5.2
ZLib Support => enabled
Compiled Version => 1.2.11
Linked Version => 1.2.11
$_SERVER[‘LOGNAME’] => root
$_SERVER[‘SHELL’] => /bin/csh
$_SERVER[‘HOME’] => /root
$_SERVER[‘USER’] => root
$_SERVER[‘BLOCKSIZE’] => K
$_SERVER[‘MAIL’] => /var/mail/root
$_SERVER[‘MM_CHARSET’] => UTF-8
$_SERVER[‘PATH’] => /sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin:/root/bin
$_SERVER[‘PWD’] => /root
$_SERVER[‘TERM’] => xterm-256color
$_SERVER[‘LANG’] => en_US.UTF-8
$_SERVER[‘LC_ALL’] => en_US.UTF-8
$_SERVER[‘HOSTTYPE’] => FreeBSD
$_SERVER[‘VENDOR’] => amd
$_SERVER[‘OSTYPE’] => FreeBSD
$_SERVER[‘MACHTYPE’] => x86_64
$_SERVER[‘SHLVL’] => 1
$_SERVER[‘GROUP’] => wheel
$_SERVER[‘HOST’] => FAMP
$_SERVER[‘EDITOR’] => vi
$_SERVER[‘PAGER’] => more
$_SERVER[‘LE_WORKING_DIR’] => /root/.acme.sh
$_SERVER[‘PHP_SELF’] =>
$_SERVER[‘REQUEST_TIME_FLOAT’] => 1598740444.089
$_SERVER[‘REQUEST_TIME’] => 1598740444- This reply was modified 4 years, 6 months ago by floogy.