[opencms-dev] Unable to initialize user driver during Upgrade to V7.0.3

[Michael Moossen]

Hi!

somehow i have the feeling that OpenCms tries to startup before the 
database has been updated.

during the update first the database is updated, then OpenCms is started 
and the modules are updated.

what says your WEB-INF/logs/db-update.log file?

Kind regards,
Michael

-------------------

Alkacon Software GmbH - The OpenCms Experts
Michael Moossen

http://www.alkacon.com
http://www.opencms.org



djano wrote:
> The full stack if it helps is:
> 
> 54:	
> 53:	Shutdown completed, total uptime was 00:00:50.
> 52:	Shutting down OpenCms, version 7.0.3 in web application "ROOT"
> 51:	
> 50:	
> 49:		at org.opencms.setup.CmsUpdateThread.run(CmsUpdateThread.java:198)
> 48:		at org.opencms.setup.CmsUpdateThread.kill(CmsUpdateThread.java:114)
> 47:		at org.opencms.main.CmsShell.exit(CmsShell.java:557)
> 46:	java.lang.NullPointerException
> 45:		at org.opencms.setup.CmsUpdateThread.run(CmsUpdateThread.java:187)
> 44:		at org.opencms.main.CmsShell.start(CmsShell.java:646)
> 43:		at org.opencms.main.CmsShell.executeCommands(CmsShell.java:818)
> 42:		at org.opencms.main.CmsShell.executeCommand(CmsShell.java:743)
> 41:	${user}@${project}>java.lang.NullPointerException
> 40:	${user}@${project}># Turn echo on
> 39:		... 10 more
> 38:		at
> org.opencms.db.generic.CmsUserDriver.readUsersOfGroup(CmsUserDriver.java:1513)
> 37:		at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
> 36:		at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
> 35:		at
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1448)
> 34:		at
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
> 33:		at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
> 32:		at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
> 31:		at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
> 30:		at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
> 29:		at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
> 28:	Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown
> column 'U.USER_DATECREATED' in 'field list'
> 27:		... 7 more
> 26:		at
> org.opencms.db.generic.CmsUserDriver.fillDefaults(CmsUserDriver.java:769)
> 25:		at
> org.opencms.db.generic.CmsUserDriver.internalCreateDefaultGroups(CmsUserDriver.java:2049)
> 24:		at
> org.opencms.db.generic.CmsUserDriver.internalUpdateRoleGroup(CmsUserDriver.java:2462)
> 23:		at
> org.opencms.db.generic.CmsUserDriver.readUsersOfGroup(CmsUserDriver.java:1519)
> 22:	Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when
> executing the following query: com.mysql.jdbc.PreparedStatement at 1da6868:
> SELECT
> U.USER_ID,U.USER_NAME,U.USER_PASSWORD,U.USER_FIRSTNAME,U.USER_LASTNAME,U.USER_EMAIL,U.USER_LASTLOGIN,U.USER_FLAGS,U.USER_OU,U.USER_DATECREATED
> FROM CMS_GROUPS G, CMS_USERS U, CMS_GROUPUSERS GU WHERE
> G.GROUP_NAME='Administrators' AND G.GROUP_OU='/' AND G.GROUP_OU=U.USER_OU
> AND U.USER_ID=GU.USER_ID AND GU.GROUP_ID=G.GROUP_ID ORDER BY
> U.USER_OU,U.USER_NAME. 
> 21:		... 5 more
> 20:		at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2711)
> 19:		at org.opencms.db.CmsDriverManager.init(CmsDriverManager.java:4306)
> 18:		at
> org.opencms.db.generic.CmsUserDriver.fillDefaults(CmsUserDriver.java:774)
> 17:	Caused by: org.opencms.main.CmsInitException: Critical error during
> OpenCms initialization: Unable to initialize the user driver. 
> 16:		at org.opencms.setup.CmsUpdateThread.run(CmsUpdateThread.java:150)
> 15:		at org.opencms.main.CmsShell.<init>(CmsShell.java:450)
> 14:		at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1692)
> 13:		at
> org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1117)
> 12:		at
> org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:156)
> 11:		at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2720)
> 10:	org.opencms.main.CmsInitException: Critical error while loading driver
> manager.
> 9:	--------------------
> 8:	Giving up, unable to start OpenCms.
> 7:	Critical error during OpenCms initialization: Unable to initialize the
> user driver. 
> 6:	The following critical error occured:
> 5:	--------------------
> 4:	
> 3:	
> 2:	OpenCms property file:
> "C:\local\tomcat_5.5-PublicWebDEV\webapps\ROOT\WEB-INF\config\opencms.properties".
> 1:	OpenCms WEB-INF path: 
> "C:\local\tomcat_5.5-PublicWebDEV\webapps\ROOT\WEB-INF\". 
>