Nagios Support Forum

Posted: **Thu Feb 16, 2012 1:43 pm**

Hi all.

Fresh install of Fusion on a barebones CentOS 6 server. I tried updating the license key but I get the following error:

Code: Select all

SQL: INSERT INTO fusion_options (name,value) VALUES ('license_key','my_license_key')	SQL Error [nagiosfusion] : ERROR: duplicate key value violates unique constraint "fusion_options_pkey"	SQL: INSERT INTO fusion_options (name,value) VALUES ('license_key','') SQL Error [nagiosfusion] : ERROR: duplicate key value violates unique constraint "fusion_options_pkey"

Posted: **Mon Feb 20, 2012 4:52 pm**

Posted: **Thu Feb 23, 2012 10:26 am**

There might be something goofy going on with the postgres sequences, XI has a similar error show up from time to time. I'll take a look at the XI fix and see if I can come up with something comparable for Fusion (if it's not already there).

Posted: **Thu Feb 23, 2012 5:21 pm**

Give this script a try and see if it takes care of the issue. Place it in your /usr/local/nagiosfusion/scripts directory and add executable permissions.

Posted: **Thu Feb 23, 2012 6:51 pm**

That fixed it. Thanks!

Posted: **Fri Feb 24, 2012 10:11 am**

Awesome! I'll commit that script so it's available for future releases.

Nagios Support Forum

SQL Failure when updating license key

SQL Failure when updating license key

Re: SQL Failure when updating license key

Re: SQL Failure when updating license key

Re: SQL Failure when updating license key

Re: SQL Failure when updating license key

Re: SQL Failure when updating license key