Forum Replies Created

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter floogy

    (@floogy)

    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.
    Thread Starter floogy

    (@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); in wp-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.
    Thread Starter floogy

    (@floogy)

    Maybe ‘localhost installs’ is the wrong section for this topic?

    Thread Starter floogy

    (@floogy)

    $ 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
    Thread Starter floogy

    (@floogy)

    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.
Viewing 5 replies - 1 through 5 (of 5 total)