Hi all, I'm hoping someone can help me. I have inherited a multi server setup with one master and 3 slaves all running Ubuntu. I confess to not reading the documentation on updating before hand (silly me!) On the Master node i ran ispconfig_update.sh Went through it using all the default options and all seemed OK. I then did exactly the same to the slaves using the default options. Since doing this, Monitor has stopped refreshing for all the slaves and still gives the old version numbers. I now know what i have done wrong, i should have ran the update on the slaves first and changed the "reconfigure permissions" option to yes, then updated the master. I would simply like to re-run the update using the correct options but I can't as they are all now on the latest version. Apologies, i'm not that experienced with Linux or ISPConfig. I do have full server backups from before i did this, but i don't want to restore unless i have to as i have just spent a fair bit of time cleaning up full boot partitions and removing old kernels on all four servers. I don't really want to have to do it all again! Many thanks in advance!
Just to update on this... I found this thread: https://www.howtoforge.com/community/threads/monitoring-does-not-updating.73649/#post-346527 I done this on all the slaves, then the master. Monitor is now updating on all but one of the slaves. Not sure why as i did nothing different with this slave. Any help appreciated.
Any error when you run server.sh in debug mode? https://www.faqforge.com/linux/debugging-ispconfig-3-server-actions-in-case-of-a-failure/ Updating the master first was ok, but you probably should have chosen to update permissions in master database on at least one of the slaves.
I've done as described in the above article and I am getting the following error when running server.sh... 03.10.2018-15:14 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock What does this mean? Thanks
there are no other errors showing there. I've attached a screenshot to show whats happening. Web1 is the master. The others are all slaves, ns2 is the only one with the issue since i re ran the upgrade and selected 'yes' to reconfigure permissions on the slaves. ns2 is a mirror of ns1 (so it says in the settings). Strangely in Server IP settings no IP address shows up for ns2 but it does if I refresh the page. Is there any other info i can provide that may help? P.s. The warning on web2 is just saying a couple of packages need updating, however apt-get update followed by apt-get upgrade shows all updated. Thanks
Package updates are checked twice a day, that's not real-time. so the package updates are no indication that the update did not work.
Ok thanks, good to know. For ns2, if i click on any of the server state tabs on the left, they all say no data available. all other servers do return some data.
I've just gone ahead and restored all 4 servers to previous version of ISPConfig from Veeam backups and all working again. I will clean up boot partitions and make another backup set before attempting any further updates. Thanks anyway
So what i thought was fixed, isn't quite fixed... I restored all 4 servers to before i done anything, and noticed that ns2 (one of the slaves), was still not updating in monitor. Also the Job queue is stuck with any jobs to do with this server. I put it in debug mode as per instructions above and this time get the following output: 12.10.2018-09:53 - WARNING - There is already a lockfile set, but no process running with this pid (2528). Continuing. PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv9'@'ns2' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 80 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv9'@'ns2' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv9'@'ns2' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv9'@'ns2' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv9'@'ns2' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv9'@'ns2' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 Zugriff auf Datenbankserver fehlgeschlagen! / Database server not accessible!PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv9'@'ns2' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv9'@'ns2' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv9'@'ns2' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv9'@'ns2' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv9'@'ns2' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv9'@'ns2' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv9'@'ns2' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv9'@'ns2' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv9'@'ns2' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv9'@'ns2' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 DB::query -> reconnectUnable to load the server configuration from database.PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv9'@'ns2' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 80 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv9'@'ns2' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv9'@'ns2' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv9'@'ns2' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv9'@'ns2' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv9'@'ns2' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 There is obviously a mysql permission problem or password problem, but i don't really know where to look to fix this. any help appreciated once again. Thanks
Seems to be a hostname setup problem. Ensure to set the hostnames of all servers in the hosts files on all servers as described in the multiserver tutorials. If you don't do that, then such mysql authentication problems will arise as the nodes don't agree on their hostnames so master thinks that ns2 has a different hostname then the one ns2 used to authenticate itself in mysql on the master.
You sir are a legend! So i went into the hosts file on ns2 and found this: Code: 127.0.0.1 localhost 192.168.51.155 web1 web1.mydomain.com 192.168.51.156 web2 web2.mydomain.com 192.168.51.157 ns1 ns1.mydomain.com 192.168.51.158 ns2 ns2.mydomain.com.mydomain.com.mydomain.com Not sure why the short names were in there, but it was the same on all hosts, not quite sure how the FQDN managed to become so long either but hey ho! i changed all to the following as per tutorials: Code: 127.0.0.1 localhost 192.168.51.155 web1.mydomain.com 192.168.51.156 web2.mydomain.com 192.168.51.157 ns1.mydomain.com 192.168.51.158 ns2.mydomain.com checked /etc/hostname on all servers and all were correct using the FQDN's. restarted the servers but still no joy with ns2 so uninstalled ispconfig, removed it from web interface then reinstalled it. Whilst installing, i got the following prompt: Code: Full qualified hostname (FQDN) of the server, eg server1.domain.tld [ns2.mydomain.com]: which is promising as before it just said [ns2]. After reinstalling, all is now well with my system. Thank you Till so much for your help!
