Security

Hi everyone,

After a suddently shutdown of the VM that was hosting my Subscriber ClearPass, once it was powered on again, the Subscriber appeared as "Out of Sync" and lately as "Node Disabled". 

In order to fix it, i need to:
1. Drop the failed Subscriber from the Publisher
2. Reset db in Subscriber via CLI (cluster reset-database)
3. Rejoin the Subscriber to the Publisher again

In the Step 2 I faced an issue as it prompts the following error: 
ERROR - Failed to reset database. Error: Command cd /tmp && sudo -H -u postgres pg_dump --schema=public -F c -t license_info tipsdb > /tmp/tmph4yLEb exited with error return or signal. Retcode=1. Status=256

I thought it could be for the lack of space in the VM so I added the "-b" in the previous command in order to not to backup the db before reseting them, but the error remain the same.

Any thoughts about it?

Thanks!!
A.

Hi

As you get an error message of this type when running the reset-database command after the power outage I would recommend a TAC case if you would like to troubleshoot.

But as it's a VM a fresh install of a new VM server will solve the issue. In that case you need to have license, certificates and any settings changed on the server node under server manager, like SNMP settings, service specific settings, ACL's etc. Backups is also needed to restore the databases.
The same information is also required if you continue with TAC and troubleshooting.

------------------------------
Best Regards
Jonas Hammarbäck
ACCX #1335, ACMP, ACDP, ACNSP, ACEP, ACSA
Aranya AB
If you find my answer useful, consider giving kudos and/or mark as solution
------------------------------

Original Message:
Sent: Nov 25, 2022 02:19 AM
From: Alberto Miras Gil
Subject: Can't "cluster reset-database" on dropped Subscriber

Hi everyone,

After a suddently shutdown of the VM that was hosting my Subscriber ClearPass, once it was powered on again, the Subscriber appeared as "Out of Sync" and lately as "Node Disabled".

In order to fix it, i need to:
1. Drop the failed Subscriber from the Publisher
2. Reset db in Subscriber via CLI (cluster reset-database)
3. Rejoin the Subscriber to the Publisher again

In the Step 2 I faced an issue as it prompts the following error:
ERROR - Failed to reset database. Error: Command cd /tmp && sudo -H -u postgres pg_dump --schema=public -F c -t license_info tipsdb > /tmp/tmph4yLEb exited with error return or signal. Retcode=1. Status=256

I thought it could be for the lack of space in the VM so I added the "-b" in the previous command in order to not to backup the db before reseting them, but the error remain the same.

Any thoughts about it?

Thanks!!
A.