<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi,<br>
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. <br>
<br>
- Carl-Erik<br>
<br>
Den 13.01.2012 12:00, skrev <a class="moz-txt-link-abbreviated" href="mailto:opencms-dev-request@opencms.org:">opencms-dev-request@opencms.org:</a>
<blockquote
cite="mid:mailman.1.1326452404.30372.opencms-dev@opencms.org"
type="cite">
<pre wrap="">
Message: 2
Date: Thu, 12 Jan 2012 17:43:16 +0100
From: Tobias Herrmann <a moz-do-not-send="true" class="moz-txt-link-rfc2396E" href="mailto:t.herrmann@alkacon.com"><t.herrmann@alkacon.com></a>
To: The OpenCms mailing list <a moz-do-not-send="true" class="moz-txt-link-rfc2396E" href="mailto:opencms-dev@opencms.org"><opencms-dev@opencms.org></a>
Subject: Re: [opencms-dev] OpenCms 8.0.3 installation fail
Message-ID: <a moz-do-not-send="true" class="moz-txt-link-rfc2396E" href="mailto:4F0F0DA4.1060502@alkacon.com"><4F0F0DA4.1060502@alkacon.com></a>
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
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.alkacon.com">http://www.alkacon.com</a> -- <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.opencms.org">http://www.opencms.org</a>
Am 12.01.2012 13:43, schrieb Carl-Erik Herheim:
</pre>
<blockquote type="cite" style="color: #000000;">
<pre wrap=""><span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">> </span>Thanks Tobias, here's setup.log and catalina*.log
<span class="moz-txt-citetags">> </span>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...
<span class="moz-txt-citetags">> </span>According to the wizard the database creation was successful, and it does create the database.
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">> </span>Thanks,
<span class="moz-txt-citetags">> </span>Carl-Erik
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">> </span>setup.log:
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">> </span>1: OpenCms WEB-INF path: "<i class="moz-txt-slash"><span class="moz-txt-tag">/</span>var/lib/tomcat6/webapps/ROOT/WEB-INF<span class="moz-txt-tag">/</span></i>".
<span class="moz-txt-citetags">> </span>2: OpenCms property file: "/var/lib/tomcat6/webapps/ROOT/WEB-INF/config/opencms.properties".
<span class="moz-txt-citetags">> </span>3:
<span class="moz-txt-citetags">> </span>4:
<span class="moz-txt-citetags">> </span>5: --------------------
<span class="moz-txt-citetags">> </span>6: The following critical error occurred:
<span class="moz-txt-citetags">> </span>7: Critical error during OpenCms initialization: Unable to initialize the user driver.
<span class="moz-txt-citetags">> </span>8: Giving up, unable to start OpenCms.
<span class="moz-txt-citetags">> </span>9: --------------------
<span class="moz-txt-citetags">> </span>10: org.opencms.main.CmsInitException: Critical error while loading driver manager.
<span class="moz-txt-citetags">> </span>11: at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:3114)
<span class="moz-txt-citetags">> </span>12: at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:160)
<span class="moz-txt-citetags">> </span>13: at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1156)
<span class="moz-txt-citetags">> </span>14: at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1816)
<span class="moz-txt-citetags">> </span>15: at org.opencms.main.CmsShell.<init>(CmsShell.java:447)
<span class="moz-txt-citetags">> </span>16: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:148)
<span class="moz-txt-citetags">> </span>17: Caused by: org.opencms.main.CmsInitException: Critical error during OpenCms initialization: Unable to initialize the user driver.
<span class="moz-txt-citetags">> </span>18: at org.opencms.db.generic.CmsUserDriver.internalCreateDefaultGroups(CmsUserDriver.java:2204)
<span class="moz-txt-citetags">> </span>19: at org.opencms.db.generic.CmsUserDriver.fillDefaults(CmsUserDriver.java:826)
<span class="moz-txt-citetags">> </span>20: at org.opencms.db.CmsDriverManager.init(CmsDriverManager.java:4993)
<span class="moz-txt-citetags">> </span>21: at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:3105)
<span class="moz-txt-citetags">> </span>22: ... 5 more
<span class="moz-txt-citetags">> </span>23: Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: net.sourceforge.jtds.jdbc.JtdsPreparedStatement@378feca1.
<span class="moz-txt-citetags">> </span>24: at org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:773)
<span class="moz-txt-citetags">> </span>25: at org.opencms.db.generic.CmsUserDriver.internalCreateDefaultGroups(CmsUserDriver.java:2171)
<span class="moz-txt-citetags">> </span>26: ... 8 more
<span class="moz-txt-citetags">> </span>27: Caused by: java.sql.SQLException: Invalid object name 'CMS_GROUPS'.
<span class="moz-txt-citetags">> </span>28: at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
<span class="moz-txt-citetags">> </span>29: at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
<span class="moz-txt-citetags">> </span>30: at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
<span class="moz-txt-citetags">> </span>31: at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
<span class="moz-txt-citetags">> </span>32: at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
<span class="moz-txt-citetags">> </span>33: at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
<span class="moz-txt-citetags">> </span>34: at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
<span class="moz-txt-citetags">> </span>35: at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
<span class="moz-txt-citetags">> </span>36: at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
<span class="moz-txt-citetags">> </span>37: at org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:760)
<span class="moz-txt-citetags">> </span>38: ... 9 more
<span class="moz-txt-citetags">> </span>39: ${user}@${project}># Turn echo on
<span class="moz-txt-citetags">> </span>40: ${user}@${project}>java.lang.NullPointerException
<span class="moz-txt-citetags">> </span>41: at org.opencms.main.CmsShell.executeCommand(CmsShell.java:760)
<span class="moz-txt-citetags">> </span>42: at org.opencms.main.CmsShell.executeCommands(CmsShell.java:835)
<span class="moz-txt-citetags">> </span>43: at org.opencms.main.CmsShell.start(CmsShell.java:663)
<span class="moz-txt-citetags">> </span>44: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:187)
<span class="moz-txt-citetags">> </span>45: java.lang.NullPointerException
<span class="moz-txt-citetags">> </span>46: at org.opencms.main.CmsShell.exit(CmsShell.java:571)
<span class="moz-txt-citetags">> </span>47: at org.opencms.setup.CmsSetupWorkplaceImportThread.kill(CmsSetupWorkplaceImportThread.java:110)
<span class="moz-txt-citetags">> </span>48: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:202)
<span class="moz-txt-citetags">> </span>49:
<span class="moz-txt-citetags">> </span>50:
<span class="moz-txt-citetags">> </span>51: Shutting down OpenCms, version 8.0.3 in web application "ROOT"
<span class="moz-txt-citetags">> </span>52: Shutdown completed, total uptime was 00:01:15.
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">> </span>catalina.log:
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">> </span>12-Jan-2012 11:52:40 org.apache.coyote.http11.Http11Protocol init
<span class="moz-txt-citetags">> </span>INFO: Initializing Coyote HTTP/1.1 on http-8080
<span class="moz-txt-citetags">> </span>12-Jan-2012 11:52:40 org.apache.catalina.startup.Catalina load
<span class="moz-txt-citetags">> </span>INFO: Initialization processed in 1442 ms
<span class="moz-txt-citetags">> </span>12-Jan-2012 11:52:40 org.apache.catalina.core.StandardService start
<span class="moz-txt-citetags">> </span>INFO: Starting service Catalina
<span class="moz-txt-citetags">> </span>12-Jan-2012 11:52:40 org.apache.catalina.core.StandardEngine start
<span class="moz-txt-citetags">> </span>INFO: Starting Servlet Engine: Apache Tomcat/6.0.28
<span class="moz-txt-citetags">> </span>12-Jan-2012 11:52:40 org.apache.catalina.startup.HostConfig deployWAR
<span class="moz-txt-citetags">> </span>INFO: Deploying web application archive ROOT.war
<span class="moz-txt-citetags">> </span>12-Jan-2012 11:52:42 org.apache.coyote.http11.Http11Protocol start
<span class="moz-txt-citetags">> </span>INFO: Starting Coyote HTTP/1.1 on http-8080
<span class="moz-txt-citetags">> </span>12-Jan-2012 11:52:42 org.apache.catalina.startup.Catalina start
<span class="moz-txt-citetags">> </span>INFO: Server startup in 2660 ms
<span class="moz-txt-citetags">> </span>12-Jan-2012 11:54:18 org.apache.coyote.http11.Http11Protocol pause
<span class="moz-txt-citetags">> </span>INFO: Pausing Coyote HTTP/1.1 on http-8080
<span class="moz-txt-citetags">> </span>12-Jan-2012 11:54:19 org.apache.catalina.core.StandardService stop
<span class="moz-txt-citetags">> </span>INFO: Stopping service Catalina
<span class="moz-txt-citetags">> </span>12-Jan-2012 11:54:21 org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
<span class="moz-txt-citetags">> </span>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.
<span class="moz-txt-citetags">> </span>12-Jan-2012 11:54:21 org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
<span class="moz-txt-citetags">> </span>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.
<span class="moz-txt-citetags">> </span>12-Jan-2012 11:54:21 org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
<span class="moz-txt-citetags">> </span>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.
<span class="moz-txt-citetags">> </span>12-Jan-2012 11:54:21 org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
<span class="moz-txt-citetags">> </span>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.
<span class="moz-txt-citetags">> </span>12-Jan-2012 11:54:21 org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
<span class="moz-txt-citetags">> </span>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.
<span class="moz-txt-citetags">> </span>12-Jan-2012 11:54:21 org.apache.coyote.http11.Http11Protocol destroy
<span class="moz-txt-citetags">> </span>INFO: Stopping Coyote HTTP/1.1 on http-8080
<span class="moz-txt-citetags">> </span>12-Jan-2012 11:54:49 org.apache.coyote.http11.Http11Protocol init
<span class="moz-txt-citetags">> </span>INFO: Initializing Coyote HTTP/1.1 on http-8080
<span class="moz-txt-citetags">> </span>12-Jan-2012 11:54:49 org.apache.catalina.startup.Catalina load
<span class="moz-txt-citetags">> </span>INFO: Initialization processed in 1176 ms
<span class="moz-txt-citetags">> </span>12-Jan-2012 11:54:49 org.apache.catalina.core.StandardService start
<span class="moz-txt-citetags">> </span>INFO: Starting service Catalina
<span class="moz-txt-citetags">> </span>12-Jan-2012 11:54:49 org.apache.catalina.core.StandardEngine start
<span class="moz-txt-citetags">> </span>INFO: Starting Servlet Engine: Apache Tomcat/6.0.28
<span class="moz-txt-citetags">> </span>12-Jan-2012 11:54:49 org.apache.catalina.startup.HostConfig deployWAR
<span class="moz-txt-citetags">> </span>INFO: Deploying web application archive ROOT.war
<span class="moz-txt-citetags">> </span>12-Jan-2012 11:54:53 org.apache.coyote.http11.Http11Protocol start
<span class="moz-txt-citetags">> </span>INFO: Starting Coyote HTTP/1.1 on http-8080
<span class="moz-txt-citetags">> </span>12-Jan-2012 11:54:53 org.apache.catalina.startup.Catalina start
<span class="moz-txt-citetags">> </span>INFO: Server startup in 4300 ms
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">> </span>Den 10.01.2012 12:00, skrev <a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:opencms-dev-request@opencms.org:">opencms-dev-request@opencms.org:</a>
</pre>
<blockquote type="cite" style="color: #000000;">
<pre wrap=""><span class="moz-txt-citetags">>> </span>Message: 1
<span class="moz-txt-citetags">>> </span>Date: Mon, 09 Jan 2012 13:09:03 +0100
<span class="moz-txt-citetags">>> </span>From: Tobias Herrmann<a moz-do-not-send="true" class="moz-txt-link-rfc2396E" href="mailto:t.herrmann@alkacon.com"><t.herrmann@alkacon.com></a>
<span class="moz-txt-citetags">>> </span>To: The OpenCms mailing list<a moz-do-not-send="true" class="moz-txt-link-rfc2396E" href="mailto:opencms-dev@opencms.org"><opencms-dev@opencms.org></a>
<span class="moz-txt-citetags">>> </span>Subject: Re: [opencms-dev] OpenCms 8.0.3 installation fail
<span class="moz-txt-citetags">>> </span>Message-ID:<a moz-do-not-send="true" class="moz-txt-link-rfc2396E" href="mailto:4F0AD8DF.2010205@alkacon.com"><4F0AD8DF.2010205@alkacon.com></a>
<span class="moz-txt-citetags">>> </span>Content-Type: text/plain; charset="iso-8859-1"; Format="flowed"
<span class="moz-txt-citetags">>></span>
<span class="moz-txt-citetags">>> </span>Hi Carl-Erik,
<span class="moz-txt-citetags">>></span>
<span class="moz-txt-citetags">>> </span>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.
<span class="moz-txt-citetags">>></span>
<span class="moz-txt-citetags">>> </span>Greetings, Tobias
<span class="moz-txt-citetags">>></span>
<span class="moz-txt-citetags">>> </span>--
<span class="moz-txt-citetags">>></span>
<span class="moz-txt-citetags">>> </span>Alkacon Software GmbH - The OpenCms Experts
<span class="moz-txt-citetags">>></span>
<span class="moz-txt-citetags">>> </span><a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.alkacon.com">http://www.alkacon.com</a> -- <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.opencms.org">http://www.opencms.org</a>
<span class="moz-txt-citetags">>></span>
<span class="moz-txt-citetags">>></span>
<span class="moz-txt-citetags">>></span>
<span class="moz-txt-citetags">>> </span>Am 09.01.2012 11:06, schrieb Carl-Erik Herheim:
</pre>
<blockquote type="cite" style="color: #000000;">
<pre wrap=""><span class="moz-txt-citetags">>>> </span>We're having trouble installing opencms 803. Did Deiverson's solution work for you Sandrine? Unfortunately it didn't work for us.
<span class="moz-txt-citetags">>>> </span>We're having a similar problem, it happens during the module import when installing. We're also using Linux (Debian), Tomcat 6.
<span class="moz-txt-citetags">>>></span>
</pre>
</blockquote>
</blockquote>
<pre wrap=""><span class="moz-txt-citetags">> </span><snip>
<span class="moz-txt-citetags">> </span>_______________________________________________
<span class="moz-txt-citetags">> </span>This mail is sent to you from the opencms-dev mailing list
<span class="moz-txt-citetags">> </span>To change your list options, or to unsubscribe from the list, please visit
<span class="moz-txt-citetags">> </span><a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev">http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev</a>
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">></span>
</pre>
</blockquote>
</blockquote>
<br>
</body>
</html>