Cron won't run anymore on slave server [SOLVED]

Discussion in 'General' started by Private Hosting, Sep 12, 2019.

  1. Private Hosting

    Private Hosting New Member

    Today, my wife did some changes on her domain emails, and since then, all the jobs on my slave server are stuck.
    When I run the server.php cron by hand, here's the message I get:

    Datenbank nicht gefunden / Database not foundPHP Fatal error: Call to a member function testConnection() on boolean in /usr/local/ispconfig/server/server.php on line 64
    Datenbank nicht gefunden / Database not found

    All my mysql credentials are correct. And the jobs on my main server is running correctly. The only service running on my slave server is DNS and MAIL.

    Running ISPConfig 3.1.15 on CentOS 7.6.1810, PHP 5.6.40 cli, and MariaDB 5.5.60
     
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    My guess is the slave can not connect to the database on master. I am assuming that by slave you mean a server in ISPConfig multiserver setup.
    But you wrote
    Have you verified the slave can connect to the ispconfig database on master?
    Also, is the error message you posted from running in debug mode? There are instructions on how to do that at end of this post:
    https://www.howtoforge.com/community/threads/please-read-before-posting.58408/
     
  3. Private Hosting

    Private Hosting New Member

    Yes, I'm in multiserver setup. And that's what I meant by all MySQL credentials are good. I tested all of them from the slave to the master, directly on the master, etc.

    I cannot put it in debug mode from the web interface since changes are not sync. I changed the variable log_priority directly in config.inc.php to 0 but the output is the same.

    I did run the htf_report and everything is good too. The issue happened suddenly, no updates were done before.
     
  4. ahrasis

    ahrasis Well-Known Member

    What were the changes made? Can you undo the changes or restore the previous state?
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    Do it anyway in the UI of the master for this slave server and then run server.sh as root on the slave and post the result.
     
  6. Private Hosting

    Private Hosting New Member

    I think it was just "mail aliases" modifications. How I can I see what's in the queue?
     
  7. Private Hosting

    Private Hosting New Member

    Always the same error. The job queue seems stuck...

    Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    Datenbank nicht gefunden / Database not found
    PHP Fatal error: Call to a member function testConnection() on boolean in /usr/local/ispconfig/server/server.php on line 64
    Datenbank nicht gefunden / Database not found
     
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    Either the database is not there or the login details are wrong or the PHP cli that you have installed on this server lacks mysql functions.
     
  9. Private Hosting

    Private Hosting New Member

    PHP cli and MySQL functions seems ok, unless something changes in recent packages, but the bug append before updating...

    From my slave server:

    PHP Version
    Code:
    # php -v
    PHP 5.6.40 (cli) (built: Aug 28 2019 15:03:50)
    Copyright (c) 1997-2016 The PHP Group
    Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies
    MySQL functions
    Code:
    # rpm -qa |grep php |grep mysql
    php-mysqlnd-5.6.40-13.el7.remi.x86_64
    Connection to MySQL using the credentials in /usr/local/ispconfig/server/lib/config.inc.php. Note that database was name ispconfig2 differentiate from the master database.
    Code:
    # mysql -D ispconfig2 -u ispconfig -p
    Enter password:
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A
    
    Welcome to the MariaDB monitor.  Commands end with ; or \g.
    Your MariaDB connection id is 20241
    Server version: 5.5.60-MariaDB MariaDB Server
    
    Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    MariaDB [ispconfig2]> show tables;
    +--------------------------+
    | Tables_in_ispconfig2     |
    +--------------------------+
    | aps_instances            |
    | aps_instances_settings   |
    | aps_packages             |
    | aps_settings             |
    | attempts_login           |
    | client                   |
    | client_circle            |
    | client_message_template  |
    | client_template          |
    | client_template_assigned |
    | country                  |
    | cron                     |
    | directive_snippets       |
    | dns_rr                   |
    | dns_slave                |
    | dns_soa                  |
    | dns_ssl_ca               |
    | dns_template             |
    | domain                   |
    | firewall                 |
    | ftp_traffic              |
    | ftp_user                 |
    | help_faq                 |
    | help_faq_sections        |
    | iptables                 |
    | mail_access              |
    | mail_backup              |
    | mail_content_filter      |
    | mail_domain              |
    | mail_forwarding          |
    | mail_get                 |
    | mail_mailinglist         |
    | mail_relay_recipient     |
    | mail_traffic             |
    | mail_transport           |
    | mail_user                |
    | mail_user_filter         |
    | monitor_data             |
    | openvz_ip                |
    | openvz_ostemplate        |
    | openvz_template          |
    | openvz_traffic           |
    | openvz_vm                |
    | remote_session           |
    | remote_user              |
    | server                   |
    | server_ip                |
    | server_ip_map            |
    | server_php               |
    | shell_user               |
    | software_package         |
    | software_repo            |
    | software_update          |
    | software_update_inst     |
    | spamfilter_policy        |
    | spamfilter_users         |
    | spamfilter_wblist        |
    | support_message          |
    | sys_config               |
    | sys_cron                 |
    | sys_datalog              |
    | sys_dbsync               |
    | sys_filesync             |
    | sys_group                |
    | sys_ini                  |
    | sys_log                  |
    | sys_remoteaction         |
    | sys_session              |
    | sys_theme                |
    | sys_user                 |
    | web_backup               |
    | web_database             |
    | web_database_user        |
    | web_domain               |
    | web_folder               |
    | web_folder_user          |
    | web_traffic              |
    | webdav_user              |
    | xmpp_domain              |
    | xmpp_user                |
    +--------------------------+
    80 rows in set (0.01 sec)[/code>
     
  10. Private Hosting

    Private Hosting New Member

    Finally got it fixed. Strangely, there was some MySQL rights not correct on my master database. Seems like the connector change the way it connect (using IP and not hostname).
     

Share This Page