Hi I'm running ispConfig 3.1.11 on a CentOS Linux release 7.4.1708 and I have 8 sites running that I have setup over the last few months. Everything has been working just fine but today when I created my 9th site the changes made aren't populated. I get the red balloon and it just increases in number with every new change I make. When I look in the jobqueue it looks fine, but when I look in the ISPCOnfig Cron log I see that nothing has been executed. It doesn't say that the service is off either, but perhaps this won't show here. I have tried to restart the server, I have also tried to manually start cron after reading some forum posts but without any result. I have tried to remove the stale lock file. When I check the error on console level I get: WARNING - There is already a lockfile set, but no process running with this pid (3982). Continuing. PHP Fatal error: Call to undefined function mysqli_connect() in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 79 PHP Fatal error: Call to undefined function mysqli_connect() in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 79 The line 79 is: $this->_iConnId = mysqli_connect($this->dbHost, $this->dbUser, $this->dbPass, '', (int)$this->dbPort); It is almost as if the mysqli "driver" isn't running or something. I don't know how to check that though, and it seems a bit weird since all the sites are working. So my question is, where should I start looking for what might be the problem, and what can I do about it? I see that there is a new version of ISPConfig availible, but since it worked before, I thought it best to try and solve the problem before updating. If you are of a different opinion, please do tell me. Best regards, Rikard
The commandline PHP is missing mysql support. First, cehck with: which php where the commandline php is located, it might be that unintentionally override the system php with a manually compiled one.
Thanks Brehm. Unfortunently I don't fully understand what to do. I have checked what files are in use by running: rpm -qc php-common. Which gave me: /etc/php.d/curl.ini /etc/php.d/fileinfo.ini /etc/php.d/json.ini /etc/php.d/phar.ini /etc/php.d/zip.ini /etc/php.ini If php.ini is the file I should look in, then I see neither dbHost, _iConnid, dbUSer nor dbPass in it so I don't know how to proceed. Any thoughts?
Ok, this seems to be the system php. Next thing is to check which version, run: php --version and you can run this to check for mysqli in commandline php: echo '<?php phpinfo();' | php | grep mysqli
Thank you very much for helping me, this is the output php --version: PHP 5.4.16 (cli) (built: Apr 12 2018 19:02:01) Copyright (c) 1997-2013 The PHP Group Zend Engine v2.4.0, Copyright (c) 1998-2013 Zend Technologies echo '<?php phpinfo();' | php | grep mysqli: PHP Warning: phpinfo(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in - on line 1
I've checked the cron.log in the ispconfig directory and this is the first instance of the error: Tue May 29 10:53:01 CEST 2018 PHP Fatal error: Call to undefined function mysqli_connect() in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 79 this is then repeated every minute since.
Thank you very much, that did the trick. Can't figure out how/why it was removed in the first place though. The output for echo '<?php phpinfo();' | php | grep mysqli: is now: /etc/php.d/mysqli.ini, mysqli mysqli.allow_local_infile => On => On 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 => no value => no value mysqli.default_user => no value => no value mysqli.max_links => Unlimited => Unlimited mysqli.max_persistent => Unlimited => Unlimited mysqli.reconnect => Off => Off Best regards, Rikard
Yes it does, the log reports the following : Fri Jun 8 15:09:01 CEST 2018 PHP Warning: mysqli_connect(): Headers and client library minor version mismatch. Headers:50556 Library:100130 in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 79 but it does indeed populate now. Thanks again, Rikard
Is is possible to run some shell script in order to avoid wait the whole minute? Sorry if this is not the right place to ask.
