[opencms-dev] OpenCms 8.0.3 installation fail -SOLVED-
Carl-Erik Herheim
carl-erik.herheim at nsd.uib.no
Mon Jan 23 13:00:34 CET 2012
Hi,
thank you Tobias. It turns out the problem was that the install wizard
can't handle domain-users for logging on to SQL server. Since the domain
has to be specified in the jdbc link it becomes invalid because OpenCms
just adds '/databasename' at the end.
- Carl-Erik
Den 13.01.2012 12:00, skrev opencms-dev-request at opencms.org:
>
> Message: 2
> Date: Thu, 12 Jan 2012 17:43:16 +0100
> From: Tobias Herrmann<t.herrmann at alkacon.com>
> To: The OpenCms mailing list<opencms-dev at opencms.org>
> Subject: Re: [opencms-dev] OpenCms 8.0.3 installation fail
> Message-ID:<4F0F0DA4.1060502 at alkacon.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Hi Carl-Erik,
>
> this error could be due to missing permissions for the database user you configured during the setup. Make sure the database user has enough permissions to create new tables and access them.
>
> Greetings, Tobias
>
> --
>
> Alkacon Software GmbH - The OpenCms Experts
>
> http://www.alkacon.com -- http://www.opencms.org
>
>
>
> Am 12.01.2012 13:43, schrieb Carl-Erik Herheim:
>> >
>> > Thanks Tobias, here's setup.log and catalina*.log
>> > We're using MS-SQL 2005, could that be a problem? We've been using it for several other OpenCms installations, so we assumed it would work here as well...
>> > According to the wizard the database creation was successful, and it does create the database.
>> >
>> > Thanks,
>> > Carl-Erik
>> >
>> >
>> > setup.log:
>> >
>> > 1: OpenCms WEB-INF path: "/var/lib/tomcat6/webapps/ROOT/WEB-INF/".
>> > 2: OpenCms property file: "/var/lib/tomcat6/webapps/ROOT/WEB-INF/config/opencms.properties".
>> > 3:
>> > 4:
>> > 5: --------------------
>> > 6: The following critical error occurred:
>> > 7: Critical error during OpenCms initialization: Unable to initialize the user driver.
>> > 8: Giving up, unable to start OpenCms.
>> > 9: --------------------
>> > 10: org.opencms.main.CmsInitException: Critical error while loading driver manager.
>> > 11: at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:3114)
>> > 12: at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:160)
>> > 13: at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1156)
>> > 14: at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1816)
>> > 15: at org.opencms.main.CmsShell.<init>(CmsShell.java:447)
>> > 16: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:148)
>> > 17: Caused by: org.opencms.main.CmsInitException: Critical error during OpenCms initialization: Unable to initialize the user driver.
>> > 18: at org.opencms.db.generic.CmsUserDriver.internalCreateDefaultGroups(CmsUserDriver.java:2204)
>> > 19: at org.opencms.db.generic.CmsUserDriver.fillDefaults(CmsUserDriver.java:826)
>> > 20: at org.opencms.db.CmsDriverManager.init(CmsDriverManager.java:4993)
>> > 21: at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:3105)
>> > 22: ... 5 more
>> > 23: Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: net.sourceforge.jtds.jdbc.JtdsPreparedStatement at 378feca1.
>> > 24: at org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:773)
>> > 25: at org.opencms.db.generic.CmsUserDriver.internalCreateDefaultGroups(CmsUserDriver.java:2171)
>> > 26: ... 8 more
>> > 27: Caused by: java.sql.SQLException: Invalid object name 'CMS_GROUPS'.
>> > 28: at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
>> > 29: at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
>> > 30: at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
>> > 31: at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
>> > 32: at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
>> > 33: at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
>> > 34: at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
>> > 35: at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
>> > 36: at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
>> > 37: at org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:760)
>> > 38: ... 9 more
>> > 39: ${user}@${project}># Turn echo on
>> > 40: ${user}@${project}>java.lang.NullPointerException
>> > 41: at org.opencms.main.CmsShell.executeCommand(CmsShell.java:760)
>> > 42: at org.opencms.main.CmsShell.executeCommands(CmsShell.java:835)
>> > 43: at org.opencms.main.CmsShell.start(CmsShell.java:663)
>> > 44: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:187)
>> > 45: java.lang.NullPointerException
>> > 46: at org.opencms.main.CmsShell.exit(CmsShell.java:571)
>> > 47: at org.opencms.setup.CmsSetupWorkplaceImportThread.kill(CmsSetupWorkplaceImportThread.java:110)
>> > 48: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:202)
>> > 49:
>> > 50:
>> > 51: Shutting down OpenCms, version 8.0.3 in web application "ROOT"
>> > 52: Shutdown completed, total uptime was 00:01:15.
>> >
>> > catalina.log:
>> >
>> > 12-Jan-2012 11:52:40 org.apache.coyote.http11.Http11Protocol init
>> > INFO: Initializing Coyote HTTP/1.1 on http-8080
>> > 12-Jan-2012 11:52:40 org.apache.catalina.startup.Catalina load
>> > INFO: Initialization processed in 1442 ms
>> > 12-Jan-2012 11:52:40 org.apache.catalina.core.StandardService start
>> > INFO: Starting service Catalina
>> > 12-Jan-2012 11:52:40 org.apache.catalina.core.StandardEngine start
>> > INFO: Starting Servlet Engine: Apache Tomcat/6.0.28
>> > 12-Jan-2012 11:52:40 org.apache.catalina.startup.HostConfig deployWAR
>> > INFO: Deploying web application archive ROOT.war
>> > 12-Jan-2012 11:52:42 org.apache.coyote.http11.Http11Protocol start
>> > INFO: Starting Coyote HTTP/1.1 on http-8080
>> > 12-Jan-2012 11:52:42 org.apache.catalina.startup.Catalina start
>> > INFO: Server startup in 2660 ms
>> > 12-Jan-2012 11:54:18 org.apache.coyote.http11.Http11Protocol pause
>> > INFO: Pausing Coyote HTTP/1.1 on http-8080
>> > 12-Jan-2012 11:54:19 org.apache.catalina.core.StandardService stop
>> > INFO: Stopping service Catalina
>> > 12-Jan-2012 11:54:21 org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
>> > SEVERE: The web application [] registered the JBDC driver [com.ibm.db2.jcc.DB2Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
>> > 12-Jan-2012 11:54:21 org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
>> > SEVERE: The web application [] registered the JBDC driver [org.apache.derby.jdbc.AutoloadedDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
>> > 12-Jan-2012 11:54:21 org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
>> > SEVERE: The web application [] registered the JBDC driver [org.h2.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
>> > 12-Jan-2012 11:54:21 org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
>> > SEVERE: The web application [] registered the JBDC driver [com.ingres.jdbc.IngresDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
>> > 12-Jan-2012 11:54:21 org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
>> > SEVERE: The web application [] registered the JBDC driver [org.postgresql.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
>> > 12-Jan-2012 11:54:21 org.apache.coyote.http11.Http11Protocol destroy
>> > INFO: Stopping Coyote HTTP/1.1 on http-8080
>> > 12-Jan-2012 11:54:49 org.apache.coyote.http11.Http11Protocol init
>> > INFO: Initializing Coyote HTTP/1.1 on http-8080
>> > 12-Jan-2012 11:54:49 org.apache.catalina.startup.Catalina load
>> > INFO: Initialization processed in 1176 ms
>> > 12-Jan-2012 11:54:49 org.apache.catalina.core.StandardService start
>> > INFO: Starting service Catalina
>> > 12-Jan-2012 11:54:49 org.apache.catalina.core.StandardEngine start
>> > INFO: Starting Servlet Engine: Apache Tomcat/6.0.28
>> > 12-Jan-2012 11:54:49 org.apache.catalina.startup.HostConfig deployWAR
>> > INFO: Deploying web application archive ROOT.war
>> > 12-Jan-2012 11:54:53 org.apache.coyote.http11.Http11Protocol start
>> > INFO: Starting Coyote HTTP/1.1 on http-8080
>> > 12-Jan-2012 11:54:53 org.apache.catalina.startup.Catalina start
>> > INFO: Server startup in 4300 ms
>> >
>> >
>> >
>> > Den 10.01.2012 12:00, skrevopencms-dev-request at opencms.org:
>>> >> Message: 1
>>> >> Date: Mon, 09 Jan 2012 13:09:03 +0100
>>> >> From: Tobias Herrmann<t.herrmann at alkacon.com>
>>> >> To: The OpenCms mailing list<opencms-dev at opencms.org>
>>> >> Subject: Re: [opencms-dev] OpenCms 8.0.3 installation fail
>>> >> Message-ID:<4F0AD8DF.2010205 at alkacon.com>
>>> >> Content-Type: text/plain; charset="iso-8859-1"; Format="flowed"
>>> >>
>>> >> Hi Carl-Erik,
>>> >>
>>> >> could you provide the /WEB-INF/logs/setup.log and the latest /tomcat/logs/catalina*.log? A full stack-trace to this and any preceding errors would help to find the cause of your problem.
>>> >>
>>> >> Greetings, Tobias
>>> >>
>>> >> --
>>> >>
>>> >> Alkacon Software GmbH - The OpenCms Experts
>>> >>
>>> >> http://www.alkacon.com --http://www.opencms.org
>>> >>
>>> >>
>>> >>
>>> >> Am 09.01.2012 11:06, schrieb Carl-Erik Herheim:
>>>> >>> We're having trouble installing opencms 803. Did Deiverson's solution work for you Sandrine? Unfortunately it didn't work for us.
>>>> >>> We're having a similar problem, it happens during the module import when installing. We're also using Linux (Debian), Tomcat 6.
>>>> >>>
>> > <snip>
>> > _______________________________________________
>> > This mail is sent to you from the opencms-dev mailing list
>> > To change your list options, or to unsubscribe from the list, please visit
>> > http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev
>> >
>> >
>> >
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20120123/eb360dc2/attachment.htm>
More information about the opencms-dev
mailing list