Re: [opennms-discuss] 19.0.0 install fails

[Dan S. <dan...@pr...>]

Ron,

Thank you for the tip. After searching around some more I finally found 
a way to log in and make the change although it was not as simple as 
your one liner. This is what I ended up doing:
su
su - postgre
psql
\c opennms
DELETE FROM monitoringlocations WHERE id = 'localhost';
\q
exit
exit

I read there were some significant changes in this latest update. I also 
had to edit the /opt/opennms/etc/users.xml file and change each <user 
read-only="false"> to <user> and also add <role>ROLE_ADMIN</role> to the 
admin user section to allow me to access the admin options in the 
console again.

Dan


On 2/16/2017 1:43 PM, Ronald Roskens wrote:
> This should do it:
>
> $ psql -U opennms -c "DELETE FROM monitoringlocations WHERE id = 
> 'localhost’;"
>
> If prompted for a password, you can try the default, or whatever value 
> you are using for the opennms user in the database.
>
> Ron
>
>> On Feb 16, 2017, at 7:26 AM, Dan Stevenson 
>> <dan...@pr... <mailto:dan...@pr...>> wrote:
>>
>> Hello,
>>
>> I was searching google for this error after the latest upgrade:
>>
>> "Error: Error executing SQL INSERT INTO monitoringlocations (id, monitoringarea) VALUES ('localhost', 'localhost'): ERROR: duplicate key value violates unique
>>   constraint "monitoringlocations_pkey""
>>
>> And found this thread with the proposed workaround. The problem is I am not familiar with sql beyond the steps that were necessary to install and setup Opennms.
>>
>> Could someone please explain what steps I need to perform to log into the database and run the command proposed in the solution?
>> DELETE FROM monitoringlocations WHERE id = 'localhost';
>>
>> Thanks,
>> Dan
>>
>>
>>
>> -- 
>> Sanders Home Services
>> Dan Stevenson
>> Network Administrator 	<smalllogo.png> 
>> <http://www.sandershomeservices.com/>
>>
>> *PLUMBING • HEATING • COOLING • ELECTRICAL*
>>
>> Desk: 856-433-6068 | Email: dan...@pr...
>> Main: 856-429-3086 | Fax: 856-429-0551
>> www.SandersHomeServices.com
>>
>> */Invest in Quality, Live in Comfort/*
>> <social-1.gif> <https://www.facebook.com/sandershomeservices> 	 
>> <social-2.gif> <https://twitter.com/sandersservices/> 	 
>> <social-3.gif> 
>> <https://www.linkedin.com/company/sanders-home-services> 	 
>> <social-4.gif> 
>> <https://plus.google.com/+SandersHomeServicesVoorheesTownship/posts>
>>
>>
>> *Sanders Home Services*
>> 100 Park Drive • Voorhees, NJ • 08043
>>
>> Home Improvement Contractor Reg. #13VH00471800
>> NJMP Peter R. Sanders Plumbing Lic #6726
>> PR Sanders Electric James J. Grasso Electrical Lic #4701B
>> Peter R. Sanders Master HVACR Contractor Lic #19HC00334800
>>
>> ------------------------------------------------------------------------------
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, SlashDot.org <http://SlashDot.org>! 
>> http://sdm.link/slashdot_______________________________________________
>> Please read the OpenNMS Mailing List FAQ:
>> http://www.opennms.org/index.php/Mailing_List_FAQ
>>
>> opennms-discuss mailing list
>>
>> To *unsubscribe* or change your subscription options, see the bottom 
>> of this page:
>> https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
>
>
> _______________________________________________
> Please read the OpenNMS Mailing List FAQ:
> http://www.opennms.org/index.php/Mailing_List_FAQ
>
> opennms-discuss mailing list
>
> To *unsubscribe* or change your subscription options, see the bottom of this page:
> https://lists.sourceforge.net/lists/listinfo/opennms-discuss