Fresh install getting PHP/Mysqli, and Cronjob, errors

Discussion in 'Installation/Configuration' started by Yarnell, Jan 6, 2021.

  1. Yarnell

    Yarnell New Member

    Good day all,

    I have just installed Ispconfig on a Debian Buster build and all seems well except for the following errors in my php.log
    I see it has something to do with mysqli and I've checked the db_mysql.inc.php file but I can't seem to figure these errors out.

    Debian GNU/Linux 10 (buster)
    ISPConfig version is 3.2.2
    Php (cli) version is 7.4.13
    Mysql Ver 8.0.22 for Linux on x86_64

    Any ideas would be muchly appreciated.
    (PS... My ispconfig installation is up and running fine... despite these few errors)

    Code:
    [05-Jan-2021 23:15:05 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    [05-Jan-2021 23:15:05 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    [05-Jan-2021 23:15:05 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    [05-Jan-2021 23:15:05 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    [05-Jan-2021 23:15:06 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    [05-Jan-2021 23:15:06 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    [05-Jan-2021 23:15:08 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    [05-Jan-2021 23:15:08 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    [05-Jan-2021 23:15:11 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    [05-Jan-2021 23:15:11 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    [05-Jan-2021 23:15:15 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    [05-Jan-2021 23:15:15 America/*****] PHP Fatal error:  Uncaught Error: Call to a member function testConnection() on bool in /usr/local/ispconfig/server/server.php:64
    Stack trace:
    #0 {main}
      thrown in /usr/local/ispconfig/server/server.php on line 64
    [05-Jan-2021 23:15:15 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    [05-Jan-2021 23:15:15 America/*****] PHP Fatal error:  Uncaught Error: Call to a member function queryAllRecords() on bool in /usr/local/ispconfig/server/lib/classes/cronjob.inc.php:103
    Stack trace:
    #0 /usr/local/ispconfig/server/lib/classes/cron.d/100-mailbox_stats.inc.php(43): cronjob->onPrepare()
    #1 /usr/local/ispconfig/server/lib/classes/cronjob.inc.php(84): cronjob_mailbox_stats->onPrepare()
    #2 /usr/local/ispconfig/server/cron.php(116): cronjob->run()
    #3 {main}
      thrown in /usr/local/ispconfig/server/lib/classes/cronjob.inc.php on line 103
    [05-Jan-2021 23:15:16 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    [05-Jan-2021 23:15:16 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
     
  2. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    PHP 7.3 is not the default version for Debian 10. Switch back to 7.3:
    Code:
    update-alternatives --config php
    update-alternatives --config php-cgi
    How did you install this system? Why not use MariaDB instead of MySQL? MySQL 8 is supported, but we prefer MariaDB and this is used in our perfect server guides.
     
  3. Yarnell

    Yarnell New Member

    Hi Th0m,
    Thanks for the reply. Well, updating the php did not seem to fix the problem but you did help me figure out how to switch back to Php7.3. For that I send a ** salute **
    I setup ISP using a combination of the perfect server guide, the actual manual and various resources on the net.
    I still get the same errors when I boot up the computer.
    Code:
    [06-Jan-2021 06:40:04 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    [06-Jan-2021 06:40:04 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    [06-Jan-2021 06:40:04 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    [06-Jan-2021 06:40:04 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    [06-Jan-2021 06:40:05 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    [06-Jan-2021 06:40:05 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    [06-Jan-2021 06:40:07 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    [06-Jan-2021 06:40:07 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    [06-Jan-2021 06:40:10 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    [06-Jan-2021 06:40:10 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    [06-Jan-2021 06:40:14 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    [06-Jan-2021 06:40:14 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    [06-Jan-2021 06:40:14 America/*****] PHP Fatal error:  Uncaught Error: Call to a member function testConnection() on bool in /usr/local/ispconfig/server/server.php:64
    Stack trace:
    #0 {main}
      thrown in /usr/local/ispconfig/server/server.php on line 64
    [06-Jan-2021 06:40:14 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    [06-Jan-2021 06:40:14 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    [06-Jan-2021 06:40:14 America/*****] PHP Fatal error:  Uncaught Error: Call to a member function queryAllRecords() on bool in /usr/local/ispconfig/server/lib/classes/cronjob.inc.php:103
    Stack trace:
    #0 /usr/local/ispconfig/server/lib/classes/cron.d/100-mailbox_stats.inc.php(43): cronjob->onPrepare()
    #1 /usr/local/ispconfig/server/lib/classes/cronjob.inc.php(84): cronjob_mailbox_stats->onPrepare()
    #2 /usr/local/ispconfig/server/cron.php(116): cronjob->run()
    #3 {main}
      thrown in /usr/local/ispconfig/server/lib/classes/cronjob.inc.php on line 103
    [06-Jan-2021 06:40:15 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    [06-Jan-2021 06:40:17 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    As for Mysql, when I first started using linux I setup mysql and just got somewhat familiar with it. Never tried MariaDB or any of those other versions.
     
    Last edited: Jan 6, 2021
  4. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    Is the MySQL server running? Are the credentials correct?
     
  5. Yarnell

    Yarnell New Member

    Yes, the server is up and running and I am able to login and make changes. There are no issues there, so I'm assuming the user/pass is correct. After taking a closer look at the db_mysql.inc.php file I did find this:
    Code:
        private $dbHost = '';  // hostname of the MySQL server
        private $dbPort = '';  // port of the MySQL server
        private $dbName = '';  // logical database name on that server
        private $dbUser = '';  // database authorized user
        private $dbPass = '';  // user's password
        private $dbCharset = 'utf8';// Database charset
        private $dbClientFlags = 0; // MySQL Client falgs
    So I tried filling in my information but it doesnt seem to make a difference.
     
  6. Yarnell

    Yarnell New Member

    Ok, so I thought maybe I would need to enable mysqli in php so I uncommented extension=mysqli in php.ini.
    After restarting apache I get this error:
    Code:
    [06-Jan-2021 08:52:33 America/*****] PHP Warning:  PHP Startup: Unable to load dynamic library 'mysqli' (tried: /usr/lib/php/20180731/mysqli (/usr/lib/php/20180731/mysqli: cannot open shared object file: No such file or directory), /usr/lib/php/20180731/mysqli.so (/usr/lib/php/20180731/mysqli.so: undefined symbol: mysqlnd_global_stats)) in Unknown on line 0
    
    After trying apt-get install php7.3-mysqli (I also tried php7.3-mysql) I get
    Code:
    Reading package lists... Done
    Building dependency tree
    Reading state information... Done
    Note, selecting 'php7.3-mysql' instead of 'php7.3-mysqli'
    php7.3-mysql is already the newest version (7.3.25-1+0~20201130.73+debian10~1.gbp042074).
    0 upgraded, 0 newly installed, 0 to remove and 3 not upgraded.
     
  7. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

  8. Yarnell

    Yarnell New Member

    Ok, so i'm now running:
    Server version: Apache/2.4.38 (Debian)
    PHP 7.3.25-1+0~20201130.73+debian10~1.gbp042074 (cli)
    mariadb Ver 15.1 Distrib 10.3.27-MariaDB, for debian-linux-gnu (x86_64)

    My situation did improved... Nice :) I was down to 6 errors in my php log:
    Code:
    [06-Jan-2021 16:21:20 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    [06-Jan-2021 16:21:20 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    [06-Jan-2021 16:21:20 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    [06-Jan-2021 16:21:20 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    [06-Jan-2021 16:21:21 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    [06-Jan-2021 16:21:21 America/*****] PHP Warning:  mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    After reinstalling buster I kept php7.3/5.6 and deleted the rest:
    Code:
    update-alternatives --config php
    update-alternatives --config php-cgi
    apt-get -y remove php7.0* php7.1* php7.2* php7.4*
    apt-get -y purge php7.0* php7.1* php7.2* php7.4*
    apt-get -y reinstall php5.6 php5.6-common php7.3 php7.3-common
    After playing around with a bunch of different files I found the culprit.
    /usr/local/ispconfig/server/lib/mysql_clientdb.conf

    I replaced:
    Code:
    $clientdb_host = 'localhost';
    with
    Code:
    $clientdb_host = 'localhost:3306';
    Thanks again for your guidance Th0m, Your help was greatly appreciated :)
     
    Last edited: Jan 6, 2021

Share This Page