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

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

 

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/

 

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.

 

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

 

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

 

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

 

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>

 

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).