Page 1 of 1

Entering Nagios XI key (free) SQL error

Posted: Fri May 20, 2011 5:08 pm
by AWS
Clean (http) install of CentOS 5.6 32-bit
Fresh download and install of Nagios XI 2011R1.2
Port 80 - one thing of note here: in my System Config/Manage System Config/Program URL I have 'http://nagios.<externaldomainname>.com:8090/nagiosxi/'. I have it like this because I have one external IP and to get to this box I port forward to 8090. Should I have this URL set to the internal LAN URL or external LAN URL?

When I go to /nagiosxi/admin/license.php and try to enter FREE for the license key, the following error is displayed on screen:

Code: Select all

SQL: SQL Error [nagiosxi] : ERROR: duplicate key violates unique constraint "xi_options_pkey"
It is displayed above the orange Notice: This trial copy of Nagios XI will expire in 60 days. Purchase a License Now or Enter your license key. notification line

If I select "FREE" from the License Type and select Update Key, it processes then returns the same error line concatenated to the existing error (same error text twice) but License Key Updated Successfully appears in a blue notification box under the page header/title. Then if I navigate to another page, the orange notification line stating the software is in trial mode still appears. So even though the blue box says the key is updated, it really isn't.

Any ideas?

Re: Entering Nagios XI key (free) SQL error

Posted: Sat May 21, 2011 1:12 pm
by tonyyarusso
Try running this command:

Code: Select all

/usr/local/nagiosxi/tools/fix_postgres_sequences.sh

Re: Entering Nagios XI key (free) SQL error

Posted: Tue May 24, 2011 4:10 pm
by AWS
Thanks! :D
That worked and solved my problem.

AWS

Re: Entering Nagios XI key (free) SQL error

Posted: Tue May 24, 2011 4:59 pm
by mguthrie
Good deal, let us know if you need help with anything else

Re: Entering Nagios XI key (free) SQL error

Posted: Mon Nov 14, 2011 1:29 am
by Muthey
:D thanks