temboard icon indicating copy to clipboard operation
temboard copied to clipboard

Invalid key after PostgreSQL version upgrade

Open ced75 opened this issue 5 years ago • 2 comments

Hi,

I have upgraded one of my monitored servers from Pg 10 to Pg 11. After the upgrade, I deleted the old server version in TemBoard. Then, I reinstalled TemBoard agent on the new v11 instance like this:

  • sudo /usr/share/temboard-agent/auto_configure.sh https://inv-monitor.ign.fr:8888
  • sudo -u postgres temboard-agent-adduser -c /etc/temboard-agent/11/main/temboard-agent.conf
  • sudo systemctl start [email protected]
  • sudo -u postgres temboard-agent-register -c /etc/temboard-agent/11/main/temboard-agent.conf --host $(hostname --fqdn) --port 2345 --groups default https://inv-monitor.ign.fr:8888

I think I made a mistake when adding the temboard agent once again, since he already existed on the server. Right ?

The problem is that when I execute the last command, the key automatically generated in TemBoard is the new key. This causes a "Invalid key" error in TemBoard interface for this server. Fortunately, I kept the old key, and if I change it in the Temboard server settings, it works.

My question is: who can I delete the new generated agent (since it is its key that is now used by default, which is wrong)?

Thanks in advance for your help and for Temboard.

Cedric

ced75 avatar Nov 07 '19 11:11 ced75

@ced75 isn't it the same problem you had in #775 ?

pgiraud avatar Jun 29 '20 06:06 pgiraud

@pgiraud not exactly. Here the problem occurred after a PostgreSQL upgrade. Whereas in #775, the problem occurred after a TemBoard upgrade.

I have recently from PostgreSQL 11 to 12 without facing the same issue.

ced75 avatar Jun 29 '20 14:06 ced75

temBoard 8 is dropping authentication using shared secret. Closing.

bersace avatar Oct 17 '22 14:10 bersace