cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1761
Views
0
Helpful
2
Replies

Insight Reporter V3 / CM 3.6.5 Build 301

m.arancibia
Level 1
Level 1

Hi,

I have installed Insight ( with MySQL ) and CM (with Oracle 10g) in the same server. When I after to configure the Remote Database always reiceive the same reponse: Configuration Test Failed.

The data introduced are correct, but I dont know where is the source of the problem.

Name: pqprod

IP: IP Server (localhost)

Schema:

User

Pass

Type:Oracle

Port:1521

Device Type:SCE

Version: 3.7.0

I already add this lines in catalina.policy file , restarted the Tomcat but the problem continue.

grant {

permission java.net.SocketPermission "<CM DB IP ADDRESS>:<1521>", "connect", "resolve";

};

I appreciate your help.

2 Replies 2

m.arancibia
Level 1
Level 1

Hi, more information...

I already added the ojdbc driver (ojdbc14.jar) into the directory:

< [user home directory]/Insight/apache-tomcat-6.0.20/webapps/insight/WEB-INF/lib >

and in the log continue appearing this errors :

2011-11-15 16:47:39  INFO com.cisco.insight.requestprocessor.services.impl.settings.SettingsRestService.testRemoteDatabase(SettingsRestService.java:323) - testRemoteDatabase :false

2011-11-15 16:47:40  INFO com.cisco.insight.auth.bo.impl.AuthBOImpl.isTokenValid(AuthBOImpl.java:194) - Checking if token is valid

2011-11-15 16:47:40  INFO com.cisco.insight.auth.bo.impl.AuthBOImpl.isTokenValid(AuthBOImpl.java:205) - Token valid : 8a698c20-48c9-4717-b809-020c9e52da48

2011-11-15 16:47:40  INFO com.cisco.insight.config.service.impl.ConfigService.testRemoteDB(ConfigService.java:574) - testRemoteDB remoteDB IPAddress::172.18.44.30

2011-11-15 16:47:40  INFO com.cisco.insight.dbmgr.service.impl.RemoteDBManager.testRemoteDBConnection(RemoteDBManager.java:120) - testRemoteDBConnection remoteDB HostName [172.18.44.30]

2011-11-15 16:47:40  INFO com.cisco.insight.dbmgr.bo.impl.RemoteDatabaseBOImpl.getTestConnectionPool(RemoteDatabaseBOImpl.java:202) - Creating TEST PooledDataSource for remote database name [pqprod]

2011-11-15 16:47:40  INFO com.cisco.insight.dbmgr.bo.impl.RemoteDatabaseBOImpl.getTestConnectionPool(RemoteDatabaseBOImpl.java:230) - dbURL {jdbc:oracle:thin:@172.18.44.30:1521/pqb_admin}

2011-11-15 16:47:40  INFO com.cisco.insight.dbmgr.bo.impl.RemoteDatabaseBOImpl.getTestConnectionPool(RemoteDatabaseBOImpl.java:231) - driver {oracle.jdbc.driver.OracleDriver}

2011-11-15 16:47:40  INFO com.cisco.insight.dbmgr.bo.impl.RemoteDatabaseBOImpl.getTestConnectionPool(RemoteDatabaseBOImpl.java:232) - dialect {org.hibernate.dialect.OracleDialect}

2011-11-15 16:47:40  INFO com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getPoolManager(AbstractPoolBackedDataSource.java:462) - Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 1, acquireRetryAttempts -> 1, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 30000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1bqrori8j1atpg3r9pmjey|1299442, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> oracle.jdbc.driver.OracleDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1bqrori8j1atpg3r9pmjey|1299442, idleConnectionTestPeriod -> 1800, initialPoolSize -> 1, jdbcUrl -> jdbc:oracle:thin:@172.18.44.30:1521/pqb_admin, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 300, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 1, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> SELECT 1, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]

2011-11-15 16:47:40  WARN com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(DriverManagerDataSource.java:107) - Could not load driverClass oracle.jdbc.driver.OracleDriver

java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1645)

    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1491)

    at java.lang.Class.forName0(Native Method)

    at java.lang.Class.forName(Unknown Source)

    at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(DriverManagerDataSource.java:100)

    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:132)

    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)

    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)

    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)

    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)

    at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)

    at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)

    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

2011-11-15 16:47:40  WARN com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1841) - com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@c1c2f1 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (1). Last acquisition attempt exception:

java.sql.SQLException: No suitable driver

    at java.sql.DriverManager.getDriver(Unknown Source)

    at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:223)

    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)

    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)

    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)

    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)

    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)

    at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)

    at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)

    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

2011-11-15 16:47:40 ERROR com.cisco.insight.dbmgr.service.impl.RemoteDBManager.testRemoteDBConnection(RemoteDBManager.java:146) - Couldn't connect to Remote Database Name[pqprod]

java.sql.SQLException: Connections could not be acquired from the underlying database!

    at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)

    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)

    at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)

    at com.cisco.insight.dbmgr.service.impl.RemoteDBManager.testRemoteDBConnection(RemoteDBManager.java:144)

    at com.cisco.insight.config.service.impl.ConfigService.testRemoteDB(ConfigService.java:579)

    at com.cisco.insight.requestprocessor.services.impl.settings.SettingsRestService.testRemoteDatabase(SettingsRestService.java:321)

    at sun.reflect.GeneratedMethodAccessor131.invoke(Unknown Source)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

    at java.lang.reflect.Method.invoke(Unknown Source)

    at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)

    at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:252)

    at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:217)

    at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:206)

    at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:514)

    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:491)

    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:120)

    at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:200)

    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:48)

    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:43)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

    at com.cisco.insight.requestprocessor.servlets.filters.RequestFilter.doFilter(RequestFilter.java:140)

    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)

    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)

    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)

    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)

    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)

    at java.lang.Thread.run(Unknown Source)

Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.

    at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)

    at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)

    at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)

    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)

    ... 35 more

2011-11-15 16:47:40 ERROR com.cisco.insight.config.service.impl.ConfigService.testRemoteDB(ConfigService.java:584) - Exception

com.cisco.insight.dbmgr.exception.RemoteDBException: java.sql.SQLException: Connections could not be acquired from the underlying database!

    at com.cisco.insight.dbmgr.service.impl.RemoteDBManager.testRemoteDBConnection(RemoteDBManager.java:156)

    at com.cisco.insight.config.service.impl.ConfigService.testRemoteDB(ConfigService.java:579)

    at com.cisco.insight.requestprocessor.services.impl.settings.SettingsRestService.testRemoteDatabase(SettingsRestService.java:321)

    at sun.reflect.GeneratedMethodAccessor131.invoke(Unknown Source)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

    at java.lang.reflect.Method.invoke(Unknown Source)

    at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)

I solved this problem copying file ojdbc14.jar into this directory:

/opt/insightv3/Insight/apache-tomcat-6.0.20/webapps/insight/WEB-INF/lib

Regards!!!

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: