My slave server is not updating. I have received various errors over the last couple of hours: DB::connect()-> mysql_select_db MySQL server has gone away Unable to connect to master server What have a done wrong? The slave server will not see the master unless I remove all DNS servers from /etc/resolv.conf I have also notice on the slave eth0 is a entry for the master ip address eth0:0 is this normal?
If you use a mirror setup, then check that the "Network configuration" checkbox is not enabled on the mster.Otherwise the network configuration is mirrored from master to slave too. After you disabled that checkbox, restore the original network configuration on the slave and ensure that the /etc/hosts files on master and slave contain the correct records for master and slave server as described in the multiserver tutorials.
Hi Till, Again thank you very much for you response. So just to clarify: Only slave should have "Network Configuration" checked, also should the slave have an extra eth0:0 entry? What should be in the /etc/resolv.conf file the local DNS 127.0.0.1 or the actual network DNS Servers? Also is there a way to clear the job queue? I have a job in there since this morning which will not go away: 2012-03-15 08:44 - server1.example.local - Update - server
Dont use network configuration on mirrored setups on master or slave server. The actual dns network servers. The jobqueue will get cleared as soon as your setup is fixed. Dont try to delete any records manually in the database as this will mess up the transaction system.
That's great I have made those amendments but the job it keeps trying to process is produces these errors, including this additional eth0:0 on the slave. Changed Network settings SIOCDELRT: No such device DB::connect()-> mysql_select_db MySQL server has gone away Segmentation fault
Set the filed updated in the ispconfig server table to the hghest datalog_ifd that you find in the sys_datalog table to skip all pending changes.
