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
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.
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.
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.
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.
If you followed https://www.howtoforge.com/perfect-server-debian-10-buster-apache-bind-dovecot-ispconfig-3-1/ accordlingly, you should have a working system. The manual is most likely outdated right now, so, better follow the online perfect server tutorial. Did you have any errors when installing ISPConfig?
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
