OpenNMS unable to connect to opennms database with opennms username
Description
Environment
Acceptance / Success Criteria
Lucidchart Diagrams
Activity
Benjamin Reed February 10, 2011 at 7:31 AM
That's not related to this bug, please open a new one to report this issue.
Andrew Clark February 10, 2011 at 2:53 AM
OpenNMS trying to start up, but in svcs log file i see this:
less /var/svc/log/application-opennms:default.log
OpenNMS.Eventd : running
OpenNMS.Trapd : running
OpenNMS.Queued : running
OpenNMS.Dhcpd : running
OpenNMS.Actiond : running
OpenNMS.Capsd : running
OpenNMS.Notifd : running
OpenNMS.Scriptd : running
OpenNMS.Rtcd : running
OpenNMS.Pollerd : running
OpenNMS.PollerBackEnd : running
OpenNMS.Ticketer : running
OpenNMS.Collectd : running
OpenNMS.Threshd : running
OpenNMS.Discovery : running
OpenNMS.Vacuumd : running
OpenNMS.EventTranslator: running
OpenNMS.PassiveStatusd : running
OpenNMS.Statsd : running
OpenNMS.Provisiond : running
OpenNMS.Reportd : running
OpenNMS.Alarmd : running
OpenNMS.AsteriskGateway: running
OpenNMS.Ackd : running
OpenNMS.JettyServer : starting
Started OpenNMS, but it has not finished starting up
failed
[ Feb 10 10:14:25 Method "start" exited with status 1 ]
(END)
in /opt/opennms/log/daemon/output.log
------------------------------------------------------------------------------
Thu Feb 10 10:44:59 MSK 2011
begin ulimit settings:
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 8192
coredump(blocks) unlimited
nofiles(descriptors) 4096
memory(kbytes) unlimited
end ulimit settings
Executing command: /opt/opennms/bin/runjava -r – -Djava.endorsed.dirs=/opt/opennms/lib/endorsed -Dopennms.home=/opt/opennms -Dcom.sun.man
agement.jmxremote.port=18980 -Dcom.sun.management.jmxremote.ssl=false -Dcom.sun.management.jmxremote.authenticate=false -Xmx256m -XX:MaxPerm
Size=128m -verbose:gc -jar /opt/opennms/lib/opennms_bootstrap.jar start
[GC 3072K->670K(7680K), 0.0209031 secs]
[GC 3742K->1392K(10752K), 0.0130371 secs]
[GC 7536K->1947K(11776K), 0.0084831 secs]
[GC 9115K->2715K(18944K), 0.0119799 secs]
[DEBUG] System property 'opennms.library.jicmp' set to '/opt/NMSjicmp/lib/32/libjicmp.so. Attempting to load jicmp library from this locatio
n.
[INFO] Successfully loaded jicmp library.
[GC 17051K->3239K(18432K), 0.0115480 secs]
[GC 17063K->3581K(18880K), 0.0116843 secs]
[GC 16893K->3928K(18432K), 0.0112488 secs]
[GC 16777K->4527K(17920K), 0.0124878 secs]
[Full GC 4527K->4045K(26112K), 0.2169000 secs]
[GC 16461K->5030K(28864K), 0.0307000 secs]
[GC 20070K->7289K(30528K), 0.0251245 secs]
[GC 24057K->7899K(31296K), 0.0298335 secs]
[GC 24667K->8786K(35776K), 0.0234454 secs]
[GC 29842K->9783K(38016K), 0.0319279 secs]
[GC 32567K->10151K(41664K), 0.0272864 secs]
[GC 36391K->10471K(41920K), 0.0211517 secs]
[GC 36711K->10679K(47936K), 0.0279658 secs]
[GC 42615K->11159K(49216K), 0.0299707 secs]
[GC 44055K->11589K(55360K), 0.0615493 secs]
[GC 50181K->14800K(56448K), 0.0632853 secs]
[GC 53968K->19077K(73344K), 0.0816207 secs]
[GC 65349K->24712K(75328K), 0.1642180 secs]
[GC 70984K->33176K(95296K), 0.1333176 secs]
[GC 88536K->36688K(99328K), 0.0979078 secs]
[GC 92048K->42494K(96576K), 0.1248703 secs]
[Full GC 42494K->42161K(112960K), 0.7369677 secs]
[GC 78976K->46410K(113152K), 0.1334696 secs]
[GC 96714K->51247K(104576K), 0.1564681 secs]
[GC 88751K->56686K(117056K), 0.2259537 secs]
[Full GC 56686K->56200K(141632K), 0.8648810 secs]
[GC 90751K->59772K(141632K), 0.1130407 secs]
[GC 98108K->64443K(142464K), 0.0737014 secs]
[GC 104699K->68859K(143552K), 0.0638097 secs]
[GC 111035K->74429K(144384K), 0.0612082 secs]
[Full GC 74429K->71148K(164864K), 1.0595542 secs]
[GC 114860K->74854K(165568K), 0.0235523 secs]
[GC 120294K->75993K(166592K), 0.0315813 secs]
[GC 123097K->78147K(167232K), 0.0461513 secs]
[GC 126787K->79733K(168128K), 0.0551073 secs]
Feb 10, 2011 10:46:39 AM com.noelios.restlet.http.StreamClientHelper start
INFO: Starting the HTTP client
[GC 78976K->46410K(113152K), 0.1334696 secs]
[GC 96714K->51247K(104576K), 0.1564681 secs]
[GC 88751K->56686K(117056K), 0.2259537 secs]
[Full GC 56686K->56200K(141632K), 0.8648810 secs]
[GC 90751K->59772K(141632K), 0.1130407 secs]
[GC 98108K->64443K(142464K), 0.0737014 secs]
[GC 104699K->68859K(143552K), 0.0638097 secs]
[GC 111035K->74429K(144384K), 0.0612082 secs]
[Full GC 74429K->71148K(164864K), 1.0595542 secs]
[GC 114860K->74854K(165568K), 0.0235523 secs]
[GC 120294K->75993K(166592K), 0.0315813 secs]
[GC 123097K->78147K(167232K), 0.0461513 secs]
[GC 126787K->79733K(168128K), 0.0551073 secs]
Feb 10, 2011 10:46:39 AM com.noelios.restlet.http.StreamClientHelper start
INFO: Starting the HTTP client
Feb 10, 2011 10:46:39 AM com.noelios.restlet.http.StreamClientCall sendRequest
WARNING: An error occured during the communication with the remote HTTP server.
java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:367)
at java.net.Socket.connect(Socket.java:524)
at java.net.Socket.connect(Socket.java:474)
at java.net.Socket.<init>(Socket.java:371)
at java.net.Socket.<init>(Socket.java:184)
at com.noelios.restlet.http.StreamClientCall.createSocket(StreamClientCall.java:134)
at com.noelios.restlet.http.StreamClientCall.sendRequest(StreamClientCall.java:297)
at com.noelios.restlet.http.HttpClientConverter.commit(HttpClientConverter.java:418)
at com.noelios.restlet.http.HttpClientHelper.handle(HttpClientHelper.java:108)
at org.restlet.Client.handle(Client.java:157)
at org.restlet.Uniform.handle(Uniform.java:108)
at org.opennms.rancid.RWSClientApi.getMethodRWS(RWSClientApi.java:812)
at org.opennms.rancid.RWSClientApi.getInfo(RWSClientApi.java:210)
at org.opennms.rancid.RWSClientApi.getRWSResourceDeviceTypesPatternList(RWSClientApi.java:178)
at org.opennms.netmgt.provision.RancidProvisioningAdapter.getRancidCategories(RancidProvisioningAdapter.java:174)
at org.opennms.netmgt.provision.RancidProvisioningAdapter.afterPropertiesSet(RancidProvisioningAdapter.java:161)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.
java:1477)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.jav
a:1417)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:
519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:45
6)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:398)
at org.springframework.context.support.AbstractApplicationContext.getBeansOfType(AbstractApplicationContext.java:1146)
at org.springframework.beans.factory.BeanFactoryUtils.beansOfTypeIncludingAncestors(BeanFactoryUtils.java:275)
at org.opennms.netmgt.provision.service.DefaultPluginRegistry.beansOfType(DefaultPluginRegistry.java:148)
at org.opennms.netmgt.provision.service.DefaultPluginRegistry.getAllPlugins(DefaultPluginRegistry.java:128)
at org.opennms.netmgt.provision.service.ProvisioningAdapterManager.afterPropertiesSet(ProvisioningAdapterManager.java:75)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.
java:1477)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.jav
a:1417)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:
519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:45
6)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895
)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:105)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:501)
at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:126)
at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:108)
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:280)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactor
y.java:1003)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory
.java:907)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:
485)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:45
6)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1079)
at org.springframework.beans.factory.access.SingletonBeanFactoryLocator.useBeanFactory(SingletonBeanFactoryLocator.java:397)
at org.opennms.core.utils.BeanUtils.getBeanFactory(BeanUtils.java:59)
at org.opennms.core.utils.BeanUtils.getFactory(BeanUtils.java:101)
at org.opennms.netmgt.daemon.AbstractSpringContextJmxServiceDaemon.init(AbstractSpringContextJmxServiceDaemon.java:109)
at sun.reflect.GeneratedMethodAccessor17.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at com.sun.jmx.mbeanserver.StandardMetaDataImpl.invoke(StandardMetaDataImpl.java:414)
at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(MetaDataImpl.java:220)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:815)
at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:784)
at org.opennms.netmgt.vmmgr.Invoker.invoke(Invoker.java:338)
at org.opennms.netmgt.vmmgr.Invoker.invokeMethods(Invoker.java:261)
at org.opennms.netmgt.vmmgr.Starter.start(Starter.java:266)
at org.opennms.netmgt.vmmgr.Starter.startDaemon(Starter.java:137)
at org.opennms.netmgt.vmmgr.Controller.start(Controller.java:202)
at org.opennms.netmgt.vmmgr.Controller.main(Controller.java:174)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at org.opennms.bootstrap.Bootstrap$3.run(Bootstrap.java:352)
at java.lang.Thread.run(Thread.java:595)
[GC 130549K->81668K(169408K), 0.0687836 secs]
[GC 134404K->83272K(163712K), 0.1750465 secs]
[GC 136520K->84258K(168000K), 0.0864498 secs]
[GC 134946K->85251K(163136K), 0.0908028 secs]
[GC 135939K->88403K(164032K), 0.1125621 secs]
Feb 10, 2011 10:46:59 AM com.sun.jersey.api.core.PackagesResourceConfig init
INFO: Scanning for root resource and provider classes in the packages:
org.opennms.web.rest
Feb 10, 2011 10:46:59 AM com.sun.jersey.api.core.PackagesResourceConfig init
INFO: Root resource classes found:
class org.opennms.web.rest.OnmsCategoryResource
class org.opennms.web.rest.OnmsMapRestService
class org.opennms.web.rest.NodeRestService
class org.opennms.web.rest.ForeignSourceRestService
class org.opennms.web.rest.SnmpConfigRestService
class org.opennms.web.rest.OutageRestService
class org.opennms.web.rest.RequisitionRestService
class org.opennms.web.rest.EventRestService
class org.opennms.web.rest.AssetRecordResource
class org.opennms.web.rest.AcknowledgmentRestService
class org.opennms.web.rest.AlarmRestService
class org.opennms.web.rest.NotificationRestService
Feb 10, 2011 10:46:59 AM com.sun.jersey.api.core.PackagesResourceConfig init
INFO: Provider classes found:
class org.opennms.web.rest.FormPropertiesReader
Feb 10, 2011 10:46:59 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory register
INFO: Registering Spring bean, acknowledgmentRestService, of type org.opennms.web.rest.AcknowledgmentRestService as a root resource class
Feb 10, 2011 10:46:59 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory register
INFO: Registering Spring bean, onmsCategoryResource, of type org.opennms.web.rest.OnmsCategoryResource as a root resource class
Feb 10, 2011 10:46:59 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory register
INFO: Registering Spring bean, onmsMapRestService, of type org.opennms.web.rest.OnmsMapRestService as a root resource class
Feb 10, 2011 10:46:59 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory register
INFO: Registering Spring bean, requisitionRestService, of type org.opennms.web.rest.RequisitionRestService as a root resource class
Feb 10, 2011 10:46:59 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory register
INFO: Registering Spring bean, eventRestService, of type org.opennms.web.rest.EventRestService as a root resource class
Feb 10, 2011 10:46:59 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory register
INFO: Registering Spring bean, assetRecordResource, of type org.opennms.web.rest.AssetRecordResource as a root resource class
Feb 10, 2011 10:46:59 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory register
INFO: Registering Spring bean, snmpConfigRestService, of type org.opennms.web.rest.SnmpConfigRestService as a root resource class
Feb 10, 2011 10:46:59 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory register
INFO: Registering Spring bean, notificationRestService, of type org.opennms.web.rest.NotificationRestService as a root resource class
Feb 10, 2011 10:46:59 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory register
INFO: Registering Spring bean, foreignSourceRestService, of type org.opennms.web.rest.ForeignSourceRestService as a root resource class
Feb 10, 2011 10:46:59 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory register
INFO: Registering Spring bean, nodeRestService, of type org.opennms.web.rest.NodeRestService as a root resource class
Feb 10, 2011 10:46:59 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory register
INFO: Registering Spring bean, outageRestService, of type org.opennms.web.rest.OutageRestService as a root resource class
Feb 10, 2011 10:46:59 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory register
INFO: Registering Spring bean, alarmRestService, of type org.opennms.web.rest.AlarmRestService as a root resource class
[GC 133459K->90194K(162432K), 0.1380024 secs]
Feb 10, 2011 10:47:02 AM de.novanic.eventservice.logger.DefaultServerLogger log
INFO: Server: Configuration changed - EventServiceConfiguration (Default Configuration)
Min.: 0ms; Max.: 20000ms; Timeout: 90000ms
[GC 135250K->92047K(159104K), 0.1352532 secs]
[GC 128271K->93676K(157120K), 0.1679228 secs]
[GC 129900K->94993K(157760K), 0.1587142 secs]
[GC 125073K->95897K(158400K), 0.2054462 secs]
[GC 97662K->95060K(158400K), 0.1420738 secs]
[Full GC 95060K->94790K(158400K), 1.5956637 secs]
[GC 96655K->94870K(158400K), 0.0166318 secs]
[Full GC[Unloading class sun.reflect.GeneratedSerializationConstructorAccessor2]
[Unloading class sun.reflect.GeneratedConstructorAccessor23]
[Unloading class sun.reflect.GeneratedMethodAccessor1]
[Unloading class sun.reflect.GeneratedMethodAccessor6]
[Unloading class sun.reflect.GeneratedConstructorAccessor26]
[Unloading class sun.reflect.GeneratedMethodAccessor4]
[Unloading class sun.reflect.GeneratedConstructorAccessor16]
[Unloading class sun.reflect.GeneratedConstructorAccessor22]
[Unloading class sun.reflect.GeneratedSerializationConstructorAccessor3]
[Unloading class sun.reflect.GeneratedConstructorAccessor13]
[Unloading class sun.reflect.GeneratedMethodAccessor3]
[Unloading class sun.reflect.GeneratedSerializationConstructorAccessor1]
[Unloading class sun.reflect.GeneratedConstructorAccessor21]
[Unloading class sun.reflect.GeneratedConstructorAccessor25]
[Unloading class sun.reflect.GeneratedConstructorAccessor12]
[Unloading class sun.reflect.GeneratedConstructorAccessor24]
[Unloading class sun.reflect.GeneratedConstructorAccessor19]
[Unloading class sun.reflect.GeneratedMethodAccessor5]
94870K->94848K(158400K), 1.5322538 secs]
[Full GC 103993K->95097K(158400K), 1.5286121 secs]
Andrew Clark February 9, 2011 at 1:57 PM
Thank you very much, Benjamin! Tomorrow i will try this fix.
Benjamin Reed February 9, 2011 at 10:50 AM
Oop, and also, for 1.9.4: http://ranger.befunk.com/temp/opennms-daemon-1.9.4.jar
Benjamin Reed February 9, 2011 at 10:41 AM
Alright, I've got a fix for this, now, there was some missing initialization that apparently some combination of javas and postgresql jars caused (or perhaps it's a race condition). Either way, this solves it. We'll do a 1.8.9 release today with the official fix, but in the meantime, you can grab this jar and put it in your $OPENNMS_HOME/lib:
http://ranger.befunk.com/temp/opennms-daemon-1.8.8.jar
[1.8 6724846] https://opennms.atlassian.net/browse/NMS-4392#icft=NMS-4392 - fix initialization of postgresql driver
[master 7edbb75] https://opennms.atlassian.net/browse/NMS-4392#icft=NMS-4392 - fix initialization of postgresql driver
Details
Assignee
Benjamin ReedBenjamin ReedReporter
Andrew ClarkAndrew ClarkComponents
Priority
Blocker
Details
Details
Assignee
Reporter
Components
Priority
PagerDuty
PagerDuty Incident
PagerDuty
PagerDuty Incident
PagerDuty

problem looks like the same as https://opennms.atlassian.net/browse/NMS-4378#icft=NMS-4378
bash-3.00# pkginfo -l opennms
PKGINST: opennms
NAME: OpenNMS
CATEGORY: application
ARCH: all
VERSION: 1.9.4
BASEDIR: /
VENDOR: The OpenNMS Group
DESC: Enterprise-grade open source network management system
PSTAMP: biggayal20110208183617
INSTDATE: Feb 09 2011 11:56
EMAIL: dj@opennms.org
STATUS: completely installed
FILES: 3441 installed pathnames
341 directories
949 executables
280 setuid/setgid executables
525154 blocks used (approx)
bash-3.00#
when i'm try to start opennms, i have this records in logfile:
less /opt/opennms/logs/controller/controller.log
2011-02-09 14:20:58,301 DEBUG [Main] OpenNMS.Manager.org.opennms.netmgt.config.ServiceConfigFactory: ServiceConfigFactory.init: config file p
ath /opt/opennms/etc/service-configuration.xml
2011-02-09 14:20:58,447 DEBUG [Main] org.exolab.castor.util.LocalConfiguration: Trying to load configuration file from jar:file:/opt/opennms/
lib/opennms-services-1.9.4.jar!/castor.properties
2011-02-09 14:21:01,557 DEBUG [Main] OpenNMS.Manager.org.opennms.netmgt.config.ServiceConfigFactory: ServiceConfigFactory.init: config file p
ath /opt/opennms/etc/service-configuration.xml
2011-02-09 14:21:01,768 DEBUG [Main] org.exolab.castor.util.LocalConfiguration: Trying to load configuration file from jar:file:/opt/opennms/
lib/opennms-services-1.9.4.jar!/castor.properties
2011-02-09 14:21:02,930 INFO [Main] OpenNMS.Manager.org.opennms.netmgt.vmmgr.DatabaseChecker: Data source 'opennms-admin' is missing from op
ennms-datasources.xml
2011-02-09 14:21:02,932 ERROR [Main] OpenNMS.Manager.org.opennms.netmgt.vmmgr.DatabaseChecker: Unable to connect to data source 'opennms' wit
h username 'opennms', check opennms-datasources.xml and your database permissions.
2011-02-09 14:21:02,935 ERROR [Main] OpenNMS.Manager.org.opennms.netmgt.vmmgr.Controller: error invoking check command
org.opennms.netmgt.vmmgr.InvalidDataSourceException: Data source 'opennms' failed.
at org.opennms.netmgt.vmmgr.DatabaseChecker.check(DatabaseChecker.java:166)
at org.opennms.netmgt.vmmgr.Controller.check(Controller.java:271)
at org.opennms.netmgt.vmmgr.Controller.main(Controller.java:180)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at org.opennms.bootstrap.Bootstrap$3.run(Bootstrap.java:352)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.opennms.netmgt.vmmgr.DatabaseChecker.check(DatabaseChecker.java:160)
from cli i'm connected with postgres without any problem:
bash-3.00# /usr/postgres/8.3/bin/64/psql -d opennms -U opennms
Welcome to psql 8.3.7, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
opennms=# \l
List of databases
Name | Owner | Encoding
------------------------------- opennms | postgres | UTF8
postgres | postgres | UTF8
template0 | postgres | UTF8
template1 | postgres | UTF8
(4 rows)
opennms=#
i commented out "opennms-admin" section but it don't help
bash-3.00# cat /opt/opennms/etc/opennms-datasources.xml
<?xml version="1.0" encoding="UTF-8"?>
<datasource-configuration xmlns:this="http://xmlns.opennms.org/xsd/config/opennms-datasources"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.opennms.org/xsd/config/opennms-datasources
http://www.opennms.org/xsd/config/opennms-datasources.xsd ">
<jdbc-data-source name="opennms"
database-name="opennms"
class-name="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/opennms"
user-name="opennms"
password="opennms" />
<!--
<jdbc-data-source name="opennms-admin"
database-name="template1"
class-name="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/template1"
user-name="postgres"
password="" /> -->
</datasource-configuration>
bash-3.00#