I get the red balloon and "The following changes are not yet populated to all servers".

Discussion in 'General' started by Rikard Jespersen, Jun 8, 2018.

  1. Rikard Jespersen

    Rikard Jespersen New Member

    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
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
    Rikard Jespersen likes this.
  3. Rikard Jespersen

    Rikard Jespersen New Member

    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?
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Run the command:

    which php

    and post the output.
     
  5. Rikard Jespersen

    Rikard Jespersen New Member

    Ahh, sorry, I didn't know it was an actual command. The output is:
    /usr/bin/php

    Best regards,
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    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
     
  7. Rikard Jespersen

    Rikard Jespersen New Member

    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
     
  8. Rikard Jespersen

    Rikard Jespersen New Member

    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.
     
  9. till

    till Super Moderator Staff Member ISPConfig Developer

    That's ok so far, just mysqli is missing completely. Try this:

    yum install php-mysql
     
    Rikard Jespersen likes this.
  10. Rikard Jespersen

    Rikard Jespersen New Member

    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
     
  11. till

    till Super Moderator Staff Member ISPConfig Developer

    The output is fine now and ISPConfig should be able to process changes again.
     
  12. Rikard Jespersen

    Rikard Jespersen New Member

    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
     
  13. till

    till Super Moderator Staff Member ISPConfig Developer

    The message is ok, you can ignore that.
     
  14. Rikard Jespersen

    Rikard Jespersen New Member

    Splendid.
    And again, thank you very much for your excellent guidance and help!

    /Rikard
     

Share This Page