[opencms-dev] ERROR: phase 4 - connecting to the database

Raul Duarte raulduarte.info at gmail.com
Fri Mar 1 15:50:00 CET 2019


Hello guys.

I'm  deploying OPENCMS 10.5.4 with TomCat 8 in a container structure
(DOCKER), and the Oracle 11g DB in another container.
In phase 4 we have the follow problem:

"Inicialization error on the user driver", this problem impacts in a
creation of DBTables.

Could anybody help me about this problem?

Like log above:

opencms.logr
ERROR [encms.db.generic.CmsUserDriver:2217] . User Driver          : System
roles creation failed
org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the
following query: oracle.jdbc.driver.T4CPreparedStatement at 46ed6632. 
	at org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:773)
	at
org.opencms.db.generic.CmsUserDriver.internalCreateDefaultGroups(CmsUserDriver.java:2208)
	at
org.opencms.db.generic.CmsUserDriver.fillDefaults(CmsUserDriver.java:827)
	at org.opencms.db.CmsDriverManager.init(CmsDriverManager.java:5163)
	at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:3410)
	at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:166)
	at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1365)
	at org.opencms.main.OpenCmsCore.initContext(OpenCmsCore.java:1541)
	at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:2097)
	at
org.opencms.main.OpenCmsListener.contextInitialized(OpenCmsListener.java:85)
	at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4817)
	at
org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5283)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
	at
org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1140)
	at
org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1875)
	at
java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

	at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
	at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
	at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:810)
	at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
	at
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:850)
	at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
	at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
	at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3384)
	at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	at org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:759)
	... 22 more
01 Mar 2019 12:47:09,845 ERROR [  org.opencms.main.OpenCmsCore: 370]
Critical error during OpenCms initialization: Unable to initialize the user
driver. 
org.opencms.main.CmsException: Critical error during OpenCms initialization:
Unable to initialize the user driver. 
	at org.opencms.main.OpenCmsCore.setErrorCondition(OpenCmsCore.java:370)
	at
org.opencms.main.CmsInitException.setErrorCondition(CmsInitException.java:113)
	at org.opencms.main.CmsInitException.<init>(CmsInitException.java:84)
	at
org.opencms.db.generic.CmsUserDriver.internalCreateDefaultGroups(CmsUserDriver.java:2219)
	at
org.opencms.db.generic.CmsUserDriver.fillDefaults(CmsUserDriver.java:827)
	at org.opencms.db.CmsDriverManager.init(CmsDriverManager.java:5163)
	at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:3410)
	at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:166)
	at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1365)
	at org.opencms.main.OpenCmsCore.initContext(OpenCmsCore.java:1541)
	at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:2097)
	at
org.opencms.main.OpenCmsListener.contextInitialized(OpenCmsListener.java:85)
	at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4817)
	at
org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5283)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
	at
org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1140)
	at
org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1875)
	at
java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at java.base/java.lang.Thread.run(Thread.java:834)
01 Mar 2019 12:47:09,846 FATAL [.opencms.db.CmsSecurityManager:3417]
Critical error while loading driver manager.
org.opencms.main.CmsInitException: Critical error during OpenCms
initialization: Unable to initialize the user driver. 
	at
org.opencms.db.generic.CmsUserDriver.internalCreateDefaultGroups(CmsUserDriver.java:2219)
	at
org.opencms.db.generic.CmsUserDriver.fillDefaults(CmsUserDriver.java:827)
	at org.opencms.db.CmsDriverManager.init(CmsDriverManager.java:5163)
	at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:3410)
	at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:166)
	at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1365)
	at org.opencms.main.OpenCmsCore.initContext(OpenCmsCore.java:1541)
	at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:2097)
	at
org.opencms.main.OpenCmsListener.contextInitialized(OpenCmsListener.java:85)
	at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4817)
	at
org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5283)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
	at
org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1140)
	at
org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1875)
	at
java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when
executing the following query:
oracle.jdbc.driver.T4CPreparedStatement at 46ed6632. 
	at org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:773)
	at
org.opencms.db.generic.CmsUserDriver.internalCreateDefaultGroups(CmsUserDriver.java:2208)
	... 21 more
Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

	at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
	at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
	at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:810)
	at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
	at
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:850)
	at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
	at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
	at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3384)
	at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	at org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:759)
	... 22 more
01 Mar 2019 12:47:09,846 ERROR [g.opencms.main.OpenCmsListener:  89]
Critical error while loading driver manager.
org.opencms.main.CmsInitException: Critical error while loading driver
manager.
	at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:3419)
	at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:166)
	at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1365)
	at org.opencms.main.OpenCmsCore.initContext(OpenCmsCore.java:1541)
	at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:2097)
	at
org.opencms.main.OpenCmsListener.contextInitialized(OpenCmsListener.java:85)
	at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4817)
	at
org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5283)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
	at
org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1140)
	at
org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1875)
	at
java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: org.opencms.main.CmsInitException: Critical error during OpenCms
initialization: Unable to initialize the user driver. 
	at
org.opencms.db.generic.CmsUserDriver.internalCreateDefaultGroups(CmsUserDriver.java:2219)
	at
org.opencms.db.generic.CmsUserDriver.fillDefaults(CmsUserDriver.java:827)
	at org.opencms.db.CmsDriverManager.init(CmsDriverManager.java:5163)
	at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:3410)
	... 18 more
Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when
executing the following query:
oracle.jdbc.driver.T4CPreparedStatement at 46ed6632. 
	at org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:773)
	at
org.opencms.db.generic.CmsUserDriver.internalCreateDefaultGroups(CmsUserDriver.java:2208)
	... 21 more
Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

	at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
	at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
	at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:810)
	at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
	at
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:850)
	at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
	at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
	at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3384)
	at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	at org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:759)
	... 22 more




--
Sent from: http://opencms.996256.n3.nabble.com/



More information about the opencms-dev mailing list