NagiosXI SQL error

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
Muthey
Posts: 3
Joined: Mon Nov 14, 2011 1:06 am

NagiosXI SQL error

Post by Muthey »

I have been facing the following error message when tried to update Nagiosxi activation key.
SQL: SQL Error [nagiosxi] : ERROR: duplicate key violates unique constraint "xi_options_pkey"
Appreciate you quick support as usual. thanks
User avatar
lmiltchev
Bugs find me
Posts: 13589
Joined: Mon May 23, 2011 12:15 pm

Re: NagiosXI SQL error

Post by lmiltchev »

I believe you can solve this problem by running in terminal (as root):

Code: Select all

# /usr/local/nagiosxi/tools/fix_postgres_sequences.sh
Hope this helps!
Be sure to check out our Knowledgebase for helpful articles and solutions!
Muthey
Posts: 3
Joined: Mon Nov 14, 2011 1:06 am

Re: NagiosXI SQL error

Post by Muthey »

thanks a lot it helped me
User avatar
lmiltchev
Bugs find me
Posts: 13589
Joined: Mon May 23, 2011 12:15 pm

Re: NagiosXI SQL error

Post by lmiltchev »

Glad I could help!
Be sure to check out our Knowledgebase for helpful articles and solutions!
Locked