Resync hangs

We have a multi-server install with separate DNS, Web, DB and Panel servers based on ISPConfig Manual. Recently, the System State was indicating incorrect versions of ISPConig installed on the various servers. We ran a resync of all services and the information is still incorrect. In addition, there are 134 sync operations that are now hung and will not complete.

Also, one server needs to be completely deleted from the system manually, as the physical server is now out of service and cannot be brought back online. A new server was added to the cluster and it and is functioning.

1. How best to start troubleshooting the sync issues?
2. How do we remove the server that is no longer in service?

Thank you for your help.

 

Maybe the syncs are to the server that is no longer up?

There was in the previous few days thread about removing jobs from the queue.

 

Thanks for the reply. The sync items all appear to be for the web server. The server that is no longer available was a DNS server, so I don't believe that they are related. I'm reluctant to remove the jobs from the queue, as there may be updates that need to be applied. These are the pending updates:

 

Anyone?

 

Using Internet Search Engines with

Code:

site:howtoforge.com delete ispconfig server

I found this:
https://www.howtoforge.com/community/threads/uninstall-ispconfig-3-from-a-slave.67278/

 

Thanks Taleman, the link was helpful.
For the sync issue, I think I've finally figured out what the issue is, but not sure how to correct it. during the last ISPConfig upgrade, must have enabled the control panel on the web server. The ISPConfig control panel I now functional on the web server and the admin server. I'm assuming there's a conflict that's preventing the sync operations. Is there a way to verify that this is the issue? If so, how do I correct the problem?
Thanks I advance for your help.

 

Thanks Jesse. What I'm seeing is that, on the slave (web) server, there is a section in the config.inc.php file, as follows:

//** Database settings for the master DB. This setting is only used in multiser$
$conf['dbmaster_type'] = 'mysql';
$conf['dbmaster_host'] = '';
$conf['dbmaster_port'] = '';
$conf['dbmaster_database'] = 'dbispconfig';
$conf['dbmaster_user'] = '';
$conf['dbmaster_password'] = 'hidden_password';
$conf['dbmaster_new_link'] = false;

Seeing the host, port, etc., with blank entries suggested to me that the info was overwritten because the web server was no longer part of a multi-server config. At least that was my assumption.

I looked at the config file on another member server in the cluster and the info was there so the install of the control panel must override the settings because it becomes its own master. Unfortunately, the local backups performed during the upgrades are too new to be able to grab the settings. I'll restore a machine from our remote backup and hope I'll be able to gather the info needed. I'm assuming it will resolve the issue (if I have the info available).

Pointing me to the config file was extremely helpful. Thank you.

 

Already tried that but it indicates there are no updates available. Tried selecting the git-stable and it gets to the point where it tries to connect to the master's db and hangs. Keep running into road blocks.

 

The saga continues! I cannot connect to the master's db from the webserver through mysql, so there's something else that's happened.

 

Thanks Jesse, it was a mysql issue that has been resolved. But the sync from the panel to the web server is still an issue. I've not been able to resolve the problem as mentioned above (Thurs, 3:29PM). In the master database, I've found at least 10 different entries for the web server (no idea why that many, as we've only ever had two) and can find entries for the dbmaster_user but substituting them in the slave server does nothing to resolve the issue. Still stuck in limbo.

 

Thank you, again.

I must be missing something. I've checked the ispcsrv* setting on both the slave server (config.inc.php), the mysql.user table and they match. I seem to recall finding the table in ispdbconfig db that included the ispcsrv* values but cannot locate it again. Do you know which table includes it? I'm not sure if its entry matches everything else. It's the only thing I can think of.

 

Thanks Till. I'm at a loss. It looks like everything matches but the control panel indicates the incorrect version of ISPConfig and the sync is still hung. Any other suggestions?

 

is there a way to determine which server (ispcsrv*) the sync is destined for? As mentioned previously there are numerous ispcsrv* listed for the web server that cannot be updated. I still have no idea why there are so many, as we've only ever had two machines. I'm wondering if the ispcrv that is listed is incorrect.

 

Or, might there be a log file that ight give info relating to the error?

 

I ran the server.sh script from the webserver and got a access denied error. I then tried logging in with the ispcsrv* user and realized the password was auto-generated, so I have no idea what it is. Is there a way to reset the password in the db on the control panel server and on the web server?