11-15-2011 06:44 AM - edited 03-01-2019 02:30 PM
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.
11-16-2011 07:22 AM
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)
11-17-2011 11:40 AM
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!!!
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: