Hi there, I've just installed ispconfig3 on two fresh Ubuntu18.04 machines combining to manual for Ubuntu 18.04 and the Debian cluster tutorial. I'm running version 3.1dev. After some initial problems replication between the two MySQL nodes seems to be working like a charm. After concluding both manuals I noticed in the ispconfig3 admin interface that changed are not being populated. After doing some digging on this forum I was unable to find an answer to this situation. I've enabled DEBUG and commented out the server.sh in crontab. For server-01 I receive the following messages when running the server.sh manually: 19.09.2018-00:34 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'. 19.09.2018-00:34 - DEBUG - Found 6 changes, starting update process. 19.09.2018-00:34 - DEBUG - Calling function 'update' from plugin 'apps_vhost_plugin' raised by event 'server_update'. 19.09.2018-00:34 - DEBUG - Calling function 'update' from plugin 'network_settings_plugin' raised by event 'server_update'. 19.09.2018-00:34 - DEBUG - Calling function 'update' from plugin 'postfix_server_plugin' raised by event 'server_update'. 19.09.2018-00:34 - DEBUG - Processed datalog_id 51 19.09.2018-00:34 - DEBUG - Calling function 'update' from plugin 'apps_vhost_plugin' raised by event 'server_update'. 19.09.2018-00:34 - DEBUG - Calling function 'update' from plugin 'network_settings_plugin' raised by event 'server_update'. 19.09.2018-00:34 - DEBUG - Calling function 'update' from plugin 'postfix_server_plugin' raised by event 'server_update'. 19.09.2018-00:34 - DEBUG - Processed datalog_id 53 19.09.2018-00:34 - DEBUG - Calling function 'update' from plugin 'apps_vhost_plugin' raised by event 'server_update'. 19.09.2018-00:34 - DEBUG - Calling function 'update' from plugin 'network_settings_plugin' raised by event 'server_update'. 19.09.2018-00:34 - DEBUG - Calling function 'update' from plugin 'postfix_server_plugin' raised by event 'server_update'. 19.09.2018-00:34 - DEBUG - Processed datalog_id 55 19.09.2018-00:34 - DEBUG - Calling function 'update' from plugin 'apps_vhost_plugin' raised by event 'server_update'. 19.09.2018-00:34 - DEBUG - Calling function 'update' from plugin 'network_settings_plugin' raised by event 'server_update'. 19.09.2018-00:34 - DEBUG - Calling function 'update' from plugin 'postfix_server_plugin' raised by event 'server_update'. 19.09.2018-00:34 - DEBUG - Processed datalog_id 57 19.09.2018-00:34 - DEBUG - Processed datalog_id 59 19.09.2018-00:34 - DEBUG - Processed datalog_id 61 19.09.2018-00:34 - DEBUG - Calling function 'restartHttpd' from module 'web_module'. 19.09.2018-00:34 - DEBUG - Checking nginx configuration... 19.09.2018-00:34 - DEBUG - nginx configuration ok! 19.09.2018-00:34 - DEBUG - Restarting httpd: systemctl reload nginx.service 19.09.2018-00:34 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock finished. When running the script in server-02 I receive the following: 19.09.2018-00:36 - WARNING - There is already a lockfile set, but no process running with this pid (7025). Continuing. PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'node-02.vpn' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'node-02.vpn' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91 Database connection failedPHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'node-02.vpn' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91 Database connection failedPHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'node-02.vpn' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91 Database connection failedPHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'node-02.vpn' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91 Database connection failedPHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'node-02.vpn' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91 Database connection failedZugriff auf Datenbankserver fehlgeschlagen! / Database server not accessible!PHP Fatal error: Uncaught Error: Call to a member function testConnection() on boolean in /usr/local/ispconfig/server/server.php:64 Stack trace: #0 {main} thrown in /usr/local/ispconfig/server/server.php on line 64 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'node-02.vpn' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'node-02.vpn' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91 Database connection failedPHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'node-02.vpn' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91 Database connection failedPHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'node-02.vpn' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91 Database connection failedPHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'node-02.vpn' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91 Database connection failedPHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'node-02.vpn' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91 Database connection failedZugriff auf Datenbankserver fehlgeschlagen! / Database server not accessible! I'm not sure what to make of this. I can ping both hosts using their hostname (node-01.vpn/node-02.vpn). I'm also able to manually connect to the mysql root account from the remote host. I hope anyone can help me solve this situation.
Fix that access denied error. Have you made that database user? Is the password correct? Did you grant the rights?
Thanks for your reply. I had already checked, the user did exist. However after checking again I noticed it was created with my external hostname instead of the local hostname used over the VPN connection between the two MySQL servers. I've renamed the user and all seems to fine now. Thanks a lot.
