Page 1 of 1

NagiosXI SQL error

Posted: Mon Nov 14, 2011 1:22 am
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

Re: NagiosXI SQL error

Posted: Mon Nov 14, 2011 11:58 am
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!

Re: NagiosXI SQL error

Posted: Mon Nov 14, 2011 10:54 pm
by Muthey
thanks a lot it helped me

Re: NagiosXI SQL error

Posted: Tue Nov 15, 2011 12:30 pm
by lmiltchev
Glad I could help!