Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

Insight Reporter V3 / CM 3.6.5 Build 301

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
New Member

Insight Reporter V3 / CM 3.6.5 Build 301

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)

New Member

Insight Reporter V3 / CM 3.6.5 Build 301

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!!!

1345
Views
0
Helpful
2
Replies