From: Mike H. <Mik...@sh...> - 2016-10-22 14:23:21
|
Hi Rod I did pick up on that but on investigation I found the installer had actually put in the credentials correctly. I also tried manually installing the db which failed so, picking up on a comment from Dave, I'm thinking it's an incompatibility with the latest version of Postgre. I shall reinstall later with a previous version and report back. Thanks for the reply though. Regards Mike Sent from my iPad > On 21 Oct 2016, at 22:46, Rod Ormon <Rod...@sj...> wrote: > > It sounds like the OpenNMS db is not initialized by the Installer. Hope you don't mind, Mike. But I have to ask. > > http://docs.opennms.org/opennms/releases/latest/guide-install/guide-install.html#gi-install-opennms-windows > > > The Windows install instructions say there is currently an open issue in the installer NMS-7831. The postgresql Username and password are not written to the opennms-datasources.xml file and has to be changed manually. The initialize of the database will fail with an authentication error. > > Do you think this is the problem? > > Configuration for database authentication in OpenNMS > > <jdbc-data-source name="opennms" > database-name="opennms" > class-name="org.postgresql.Driver" > url="jdbc:postgresql://localhost:5432/opennms" > user-name="** YOUR-OPENNMS-USERNAME **" > password="** YOUR-OPENNMS-PASSWORD **" /> > > <jdbc-data-source name="opennms-admin" > database-name="template1" > class-name="org.postgresql.Driver" > url="jdbc:postgresql://localhost:5432/template1" > user-name="postgres" > password="** YOUR-POSTGRES-PASSWORD **" /> > > Set the user name to access the OpenNMS database table > Set the password to access the OpenNMS database table > Set the postgres user for administrative access to PostgreSQL > Set the password for administrative changes of the OpenNMS database table > > After setting the username and passwords in opennms-datasources.xml re-run the graphical installer and also initialize the database. OpenNMS can be started and stopped with the start.bat and stop.bat script located in %OPENNMS_HOME%\bin directory. > > > Rod > > > > -----Original Message----- > From: Mike Halsey [mailto:Mik...@sh...] > Sent: Friday, October 21, 2016 9:24 AM > To: General OpenNMS Discussion > Subject: Re: [opennms-discuss] Issue with OpenNMS on Windows > > Hi Dave > > That was a great help. I noticed the start.bat window did indeed close so looked at the manager.log file. It had a mention about the PostGre connection not recognising the 'threads=1' entry so I removed and re-ran. Again it closed but this time I noticed that it had an error connecting to the underlying database. > > On further investigation it seems that the PostGre database gets created but not the OpenNMS database. > > Tried a whole bunch of things without success, even removed the whole thing a rebuilt using v17 of the Windows installer but still don't get a database created. Tried looking for manual instructions to create it without luck. > > Do you mind me asking what version you installed first time around? It may be that the original version you used will create the DB...I can then just upgrade after that. > > Many thanks > > Mike > > > > > MIKE HALSEY > IT Support & Development Officer > ShelterBox > t: +44 1872 302600 > dd: +44 1872 302620 > m: > w: http://www.shelterbox.org > > The information transmitted, including attachments, is intended only for the > person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy any copies of this information. > > ShelterBox is a registered charity (Charity Number 1096479) and a company limited by guarantee (Company Number 4612652) incorporated in England and Wales. Registered Office: ShelterBox, 1, Water-Ma-Trout, Helston, Cornwall, TR13 0LW. > > > -----Original Message----- > From: Ostock,David J. [mailto:OST...@ai...] > Sent: 20 October 2016 18:41 > To: General OpenNMS Discussion <ope...@li...> > Subject: Re: [opennms-discuss] Issue with OpenNMS on Windows > > Mike, > > I'm no expert, but OpenNMS has been working well for me on Windows 2012 R2. I've been running it in prod for almost a year and am in the process of upgrading to version 18. > > I had 2 situations where OpenNMS wouldn't start that and in both cases was able to track down the problem by checking the OpenNMS manager.log file. > - I added an event file include to eventconfig.xml but forgot to copy the new event file to the server. OpenNMS startup failed, but there was an exception in manager.log that showed which file was missing. > - I have a strange problem with version 18 where the new business service monitor daemon fails on startup. It works OK on a fresh install, but fails after I apply my event config customizations. I still don't know what the problem is with that, but was able to work around it by disabling the daemon in service-configuration.xml. > > A couple of other thoughts: > Start.bat should continue to run and not return to the command prompt until you shut it down. If it returns to the command prompt after you run it, something probably errored out and there should be some debug information in manager.log. > OpenNMS takes some time to start, give it a couple of minutes after startup completes and try the console web page again. > > Dave > > -----Original Message----- > From: Mike Halsey [mailto:mik...@sh...] > Sent: Wednesday, October 19, 2016 10:21 AM > To: ope...@li... > Subject: [opennms-discuss] Issue with OpenNMS on Windows > > Hi there > > I've installed OpenNMS on Windows Server 2012R2 together with the Java JDK and Postgre as per the instructions. Whole install ran through fine but, when I try and access the webpage for the initial login I just get a 'page not found' error. > > I've run through the install process twice now, each time on a fresh server install. The Postgre sevrice is running and the start.bat file processes without error. > > Really can't think what else to try. > > Any help would be gratefully accepted. > > Thanks > > Mike > > > > -- > View this message in context: http://opennms.530661.n2.nabble.com/Issue-with-OpenNMS-on-Windows-tp7594356.html > Sent from the OpenNMS - discuss mailing list archive at Nabble.com. > > ------------------------------------------------------------------------------ > 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 > > ------------------------------------------------------------------------------ > 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 > > ------------------------------------------------------------------------------ > 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 > > ------------------------------------------------------------------------------ > 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 |