On Saturday 23 January 2010 6:59:32 am Karsten Müller wrote: > Hi, > > I a trying to generate reports but it does not work from Web UI (generating > Adhoc report) and CLI. Opsview is "Build: 3.5.1.3761" and OS is a "Ubuntu > 8.04.3 LTS" and java (as recommended) is at version 5. See below for java > debug messages. > > Do I overlook something? Is there someone having the same problem? > > > bye, > Karsten > > > java -versionjava version "1.5.0_20" > > Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_20-b02) > Java HotSpot(TM) Server VM (build 1.5.0_20-b02, mixed mode) > > > cd /usr/local/opsview-reports/types/generic_availability > > java -jar ODWReportLauncher.jar -FConnections.xml -N3 -S2010-01 > > ODWReportLauncher starting... > Using report id: '3' > Loading config... > 0 [main] DEBUG org.springframework.util.ClassUtils - Class > [org.apache.commons.collections.map.CaseInsensitiveMap] or one of its > dependencies is not present: java.lang.ClassNotFoundException: > org.apache.commons.collections.map.CaseInsensitiveMap 2 [main] DEBUG > org.springframework.util.ClassUtils - Class > [edu.emory.mathcs.backport.java.util.concurrent.ConcurrentHashMap] or one > of its dependencies is not present: java.lang.ClassNotFoundException: > edu.emory.mathcs.backport.java.util.concurrent.ConcurrentHashMap 54 [main] > INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader - > Loading XML bean definitions from file > [/usr/local/opsview-reports/types/generic_availability/Connections.xml] 76 > [main] DEBUG org.springframework.beans.factory.xml.DefaultDocumentLoader > - Using JAXP provider [org.apache.xerces.jaxp.DocumentBuilderFactoryImpl] > 343 [main] DEBUG org.springframework.beans.factory.xml.BeansDtdResolver - > Found beans DTD [http://www.springframework.org/dtd/spring-beans.dtd] in > classpath: spring-beans.dtd 390 [main] DEBUG > org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader > - Loading bean definitions 427 [main] DEBUG > org.springframework.beans.factory.xml.BeanDefinitionParserDelegate - No > XML 'id' specified - using 'odwReportGenerator' as bean name and [] as > aliases 444 [main] DEBUG > org.springframework.beans.factory.xml.BeanDefinitionParserDelegate - > Neither XML 'id' nor 'name' specified - using generated bean name > [com.altinity.opsview.odw.bc.AvailabilityReportBC#9df6f1] 446 [main] DEBUG > org.springframework.beans.factory.xml.BeanDefinitionParserDelegate - > Neither XML 'id' nor 'name' specified - using generated bean name > [com.altinity.opsview.odw.bc.WeeklyServiceAvailabilityReportBC#b8bef7] 449 > [main] DEBUG > org.springframework.beans.factory.xml.BeanDefinitionParserDelegate - No > XML 'id' specified - using 'reportDAO' as bean name and [] as aliases 450 > [main] DEBUG > org.springframework.beans.factory.xml.BeanDefinitionParserDelegate - No > XML 'id' specified - using 'daoDataSource' as bean name and [] as aliases > 453 [main] DEBUG > org.springframework.beans.factory.xml.BeanDefinitionParserDelegate - No > XML 'id' specified - using 'reportConfigDAO' as bean name and [] as > aliases 453 [main] DEBUG > org.springframework.beans.factory.xml.BeanDefinitionParserDelegate - No > XML 'id' specified - using 'configDaoDataSource' as bean name and [] as > aliases Config loaded > 460 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - > Creating shared instance of singleton bean 'odwReportGenerator' 462 [main] > DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creating > instance of bean 'odwReportGenerator' with merged definition [Root bean: > class [com.altinity.opsview.odw.ODWReportGenerator]; scope=singleton; > abstract=false; lazyInit=false; autowireCandidate=true; autowireMode=0; > dependencyCheck=0; factoryBeanName=null; factoryMethodName=null; > initMethodName=null; destroyMethodName=null; defined in file > [/usr/local/opsview-reports/types/generic_availability/Connections.xml]] > 491 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - > Eagerly caching bean 'odwReportGenerator' to allow for resolving potential > circular references 495 [main] DEBUG > org.springframework.beans.factory.xml.XmlBeanFactory - Creating instance > of bean 'com.altinity.opsview.odw.bc.AvailabilityReportBC#9df6f1' with > merged definition [Root bean: class > [com.altinity.opsview.odw.bc.AvailabilityReportBC]; scope=singleton; > abstract=false; lazyInit=false; autowireCandidate=true; autowireMode=0; > dependencyCheck=0; factoryBeanName=null; factoryMethodName=null; > initMethodName=null; destroyMethodName=null; defined in file > [/usr/local/opsview-reports/types/generic_availability/Connections.xml]] > 501 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - > Creating shared instance of singleton bean 'reportDAO' 501 [main] DEBUG > org.springframework.beans.factory.xml.XmlBeanFactory - Creating instance > of bean 'reportDAO' with merged definition [Root bean: class > [com.altinity.opsview.odw.dao.ODWReportDAO]; scope=singleton; > abstract=false; lazyInit=false; autowireCandidate=true; autowireMode=0; > dependencyCheck=0; factoryBeanName=null; factoryMethodName=null; > initMethodName=null; destroyMethodName=null; defined in file > [/usr/local/opsview-reports/types/generic_availability/Connections.xml]] > 510 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - > Eagerly caching bean 'reportDAO' to allow for resolving potential circular > references 511 [main] DEBUG > org.springframework.beans.factory.xml.XmlBeanFactory - Creating shared > instance of singleton bean 'daoDataSource' 511 [main] DEBUG > org.springframework.beans.factory.xml.XmlBeanFactory - Creating instance > of bean 'daoDataSource' with merged definition [Root bean: class > [org.springframework.jdbc.datasource.DriverManagerDataSource]; > scope=singleton; abstract=false; lazyInit=false; autowireCandidate=true; > autowireMode=0; dependencyCheck=0; factoryBeanName=null; > factoryMethodName=null; initMethodName=null; destroyMethodName=null; > defined in file > [/usr/local/opsview-reports/types/generic_availability/Connections.xml]] > 517 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - > Eagerly caching bean 'daoDataSource' to allow for resolving potential > circular references 542 [main] INFO > org.springframework.jdbc.datasource.DriverManagerDataSource - Loaded JDBC > driver: com.mysql.jdbc.Driver 553 [main] DEBUG > org.springframework.beans.factory.xml.XmlBeanFactory - Creating shared > instance of singleton bean 'reportConfigDAO' 553 [main] DEBUG > org.springframework.beans.factory.xml.XmlBeanFactory - Creating instance > of bean 'reportConfigDAO' with merged definition [Root bean: class > [com.altinity.opsview.odw.dao.ODWReportConfigDAO]; scope=singleton; > abstract=false; lazyInit=false; autowireCandidate=true; autowireMode=0; > dependencyCheck=0; factoryBeanName=null; factoryMethodName=null; > initMethodName=null; destroyMethodName=null; defined in file > [/usr/local/opsview-reports/types/generic_availability/Connections.xml]] > 554 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - > Eagerly caching bean 'reportConfigDAO' to allow for resolving potential > circular references 554 [main] DEBUG > org.springframework.beans.factory.xml.XmlBeanFactory - Creating shared > instance of singleton bean 'configDaoDataSource' 555 [main] DEBUG > org.springframework.beans.factory.xml.XmlBeanFactory - Creating instance > of bean 'configDaoDataSource' with merged definition [Root bean: class > [org.springframework.jdbc.datasource.DriverManagerDataSource]; > scope=singleton; abstract=false; lazyInit=false; autowireCandidate=true; > autowireMode=0; dependencyCheck=0; factoryBeanName=null; > factoryMethodName=null; initMethodName=null; destroyMethodName=null; > defined in file > [/usr/local/opsview-reports/types/generic_availability/Connections.xml]] > 555 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - > Eagerly caching bean 'configDaoDataSource' to allow for resolving > potential circular references 555 [main] INFO > org.springframework.jdbc.datasource.DriverManagerDataSource - Loaded JDBC > driver: com.mysql.jdbc.Driver 569 [main] DEBUG > org.springframework.beans.factory.xml.XmlBeanFactory - Creating instance > of bean > 'com.altinity.opsview.odw.bc.WeeklyServiceAvailabilityReportBC#b8bef7' > with merged definition [Root bean: class > [com.altinity.opsview.odw.bc.WeeklyServiceAvailabilityReportBC]; > scope=singleton; abstract=false; lazyInit=false; autowireCandidate=true; > autowireMode=0; dependencyCheck=0; factoryBeanName=null; > factoryMethodName=null; initMethodName=null; destroyMethodName=null; > defined in file > [/usr/local/opsview-reports/types/generic_availability/Connections.xml]] > 570 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - > Returning cached instance of singleton bean 'reportDAO' 570 [main] DEBUG > org.springframework.beans.factory.xml.XmlBeanFactory - Returning cached > instance of singleton bean 'reportConfigDAO' 574 [main] DEBUG > org.springframework.beans.factory.xml.XmlBeanFactory - Returning cached > instance of singleton bean 'reportConfigDAO' Generating ODW3 Report... > 612 [main] DEBUG org.springframework.jdbc.core.JdbcTemplate - Executing > prepared SQL query 614 [main] DEBUG > org.springframework.jdbc.core.JdbcTemplate - Executing prepared SQL > statement [select type from reports where id = ?] 620 [main] DEBUG > org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC > Connection from DataSource 620 [main] DEBUG > org.springframework.jdbc.datasource.DriverManagerDataSource - Creating > new JDBC Connection to [jdbc:mysql://localhost/reports] > org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get > JDBC Connection; nested exception is > com.mysql.jdbc.CommunicationsException: Communications link failure > > Last packet sent to the server was 0 ms ago. > at > org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSour > ceUtils.java:82) at > org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:552) > at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:616) > at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641) > at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:673) > at > org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryF > orObject(NamedParameterJdbcTemplate.java:143) at > org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryF > orObject(NamedParameterJdbcTemplate.java:148) at > org.springframework.jdbc.core.simple.SimpleJdbcTemplate.queryForObject(Sim > pleJdbcTemplate.java:158) at > com.altinity.opsview.odw.dao.ODWReportConfigDAO.getReportTypeByReportId(OD > WReportConfigDAO.java:267) at > com.altinity.opsview.odw.ODWReportGenerator.generateReport(ODWReportGenera > tor.java:70) at > com.altinity.opsview.odw.ODWReportLauncher.main(ODWReportLauncher.java:60) > Caused by: com.mysql.jdbc.CommunicationsException: Communications link > failure > > Last packet sent to the server was 0 ms ago. > at > com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070) > at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2104) at > com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729) at > com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:298) at > com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:283) > at java.sql.DriverManager.getConnection(DriverManager.java:525) at > java.sql.DriverManager.getConnection(DriverManager.java:140) at > org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionF > romDriverManager(DriverManagerDataSource.java:283) at > org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionF > romDriverManager(DriverManagerDataSource.java:271) at > org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionF > romDriverManager(DriverManagerDataSource.java:255) at > org.springframework.jdbc.datasource.DriverManagerDataSource.getConnection( > DriverManagerDataSource.java:236) at > org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSo > urceUtils.java:113) at > org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSour > ceUtils.java:79) ... 10 more > Caused by: 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:213) > at > com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:25 > 6) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276) > at > com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2027) ... 21 > more > Exception in thread "main" java.lang.RuntimeException: > org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get > JDBC Connection; nested exception is > com.mysql.jdbc.CommunicationsException: Communications link failure > > Last packet sent to the server was 0 ms ago. > at > com.altinity.opsview.odw.ODWReportLauncher.main(ODWReportLauncher.java:68) > Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: > Could not get JDBC Connection; nested exception is > com.mysql.jdbc.CommunicationsException: Communications link failure > > Last packet sent to the server was 0 ms ago. > at > org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSour > ceUtils.java:82) at > org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:552) > at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:616) > at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641) > at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:673) > at > org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryF > orObject(NamedParameterJdbcTemplate.java:143) at > org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryF > orObject(NamedParameterJdbcTemplate.java:148) at > org.springframework.jdbc.core.simple.SimpleJdbcTemplate.queryForObject(Sim > pleJdbcTemplate.java:158) at > com.altinity.opsview.odw.dao.ODWReportConfigDAO.getReportTypeByReportId(OD > WReportConfigDAO.java:267) at > com.altinity.opsview.odw.ODWReportGenerator.generateReport(ODWReportGenera > tor.java:70) at > com.altinity.opsview.odw.ODWReportLauncher.main(ODWReportLauncher.java:60) > Caused by: com.mysql.jdbc.CommunicationsException: Communications link > failure > > Last packet sent to the server was 0 ms ago. > at > com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070) > at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2104) at > com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729) at > com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:298) at > com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:283) > at java.sql.DriverManager.getConnection(DriverManager.java:525) at > java.sql.DriverManager.getConnection(DriverManager.java:140) at > org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionF > romDriverManager(DriverManagerDataSource.java:283) at > org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionF > romDriverManager(DriverManagerDataSource.java:271) at > org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionF > romDriverManager(DriverManagerDataSource.java:255) at > org.springframework.jdbc.datasource.DriverManagerDataSource.getConnection( > DriverManagerDataSource.java:236) at > org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSo > urceUtils.java:113) at > org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSour > ceUtils.java:79) ... 10 more > Caused by: 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:213) > at > com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:25 > 6) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276) > at > com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2027) ... 21 > more >
I have the exact same issue on my installation as well. I've posted before and never got an answer to why this doesn't work so hopefully this gets answered this time. I've had my installation for well over a year now so there is plenty of data in odw so that can't be the issue in my case. -- Kurt Bechstein Server Administrator Information Technology Services, BGSU (419)372-4075 http://www.bgsu.edu/its _______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
