[opencms-dev] Help with the OpenCms (9.0.1) installation on Tomcat 7.0.53

Arash Kaffamanesh ak at cloudssky.com
Mon May 12 13:08:30 CEST 2014


On your environment, I'd try to install OpenCms with a local MySQL server
and if that works, then your problem might be the MS SQL Server (with
insufficient rights) or your IBM Java.
If you have a chance to use a standard linux distro such as Debian, CentOS,
RHEL, Ubuntu, etc. with OpenJDK and MariaDB (MySQL), then use that.

Like <https://www.facebook.com/cloudssky> |
Follow<https://twitter.com/CLOUDSSKYONE>
 | Build your CloudSite with OpenCms OCCX
<http://cloudssky.com/en/cloud_services/cloudsite.html>

On Mon, May 12, 2014 at 7:31 AM, Selvaganapathy, Alagammai <
aselvaganapathy at healthplan.com> wrote:

>  We are using SQL Server 2008 R2 and the Java version is I*BM SDK for
> Linux, Java Technology Edition, Version 7.*
>
>  And Black Howard, Cced is my Linux Administrator who admins the OpenCms
> Linux servers.
>
>
>  On 09-May-2014, at 10:44 pm, Arash Kaffamanesh <ak at cloudssky.com> wrote:
>
>  Hi,
>
>  With which database are you trying to install OpenCms, what's your linux
> distro? Which java version are you using?
>
>    Kind Regards,
> Arash
>
> Like <https://www.facebook.com/cloudssky> | Follow<https://twitter.com/CLOUDSSKYONE>
>  | Build your CloudSite with OpenCms OCCX<http://cloudssky.com/en/cloud_services/cloudsite.html>
>
>
>
> On Fri, May 9, 2014 at 6:14 PM, Selvaganapathy, Alagammai <
> aselvaganapathy at healthplan.com> wrote:
>
>>  Just following up to see any updates.
>>
>>
>>
>> Thanks,
>>
>> Alagammai
>>
>>
>>
>> *From:* opencms-dev-bounces at opencms.org [mailto:
>> opencms-dev-bounces at opencms.org] *On Behalf Of *Selvaganapathy, Alagammai
>> *Sent:* Thursday, May 08, 2014 4:38 PM
>> *To:* 'opencms-dev at opencms.org'
>> *Cc:* Black, Howard
>> *Subject:* [opencms-dev] Help with the OpenCms (9.0.1) installation on
>> Tomcat 7.0.53
>>
>>
>>
>> Team,
>>
>>
>>
>> Good Day!
>>
>>
>>
>> We are trying to install the OpenCms software on our Linux based Apache
>> Tomcat 7.0.53 server.
>>
>>
>>
>> While the setup wizard is completed with creating the OpenCms database
>> with the needed tables, we have difficulties on launching the OpenCms web
>> app with the below error on the launch and seeing HTTP 500 error  page.
>>
>>
>>
>> Here is the error.(Stacktrace from the logs)
>>
>>
>>
>> 53:
>>
>> 52:     Shutdown completed, total uptime was 00:03:33.
>>
>> 51:     Shutting down OpenCms, version 9.0.1 in web application "opencms"
>>
>> 50:
>>
>> 49:
>>
>> 48:               at
>> org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:202)
>>
>> 47:               at
>> org.opencms.setup.CmsSetupWorkplaceImportThread.kill(CmsSetupWorkplaceImportThread.java:110)
>>
>> 46:               at org.opencms.main.CmsShell.exit(CmsShell.java:571)
>>
>> 45:     java.lang.NullPointerException
>>
>> 44:               at
>> org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:187)
>>
>> 43:               at org.opencms.main.CmsShell.start(CmsShell.java:663)
>>
>> 42:               at
>> org.opencms.main.CmsShell.executeCommands(CmsShell.java:835)
>>
>> 41:               at
>> org.opencms.main.CmsShell.executeCommand(CmsShell.java:760)
>>
>> 40:     ${user}@${project}>java.lang.NullPointerException
>>
>> 39:     ${user}@${project}># Turn echo on
>>
>> 38:               ... 9 more
>>
>> 37:               at
>> org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:750)
>>
>> 36:               at
>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
>>
>> 35:               at
>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
>>
>> 34:               at
>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
>>
>> 33:               at
>> net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
>>
>> 32:               at
>> net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
>>
>> 31:               at
>> net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
>>
>> 30:               at
>> net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
>>
>> 29:               at
>> net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
>>
>> 28:               at
>> net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
>>
>> 27:     Caused by: java.sql.SQLException: Invalid object name
>> 'CMS_GROUPS'.
>>
>> 26:               ... 8 more
>>
>> 25:               at
>> org.opencms.db.generic.CmsUserDriver.internalCreateDefaultGroups(CmsUserDriver.java:2173)
>>
>> 24:               at
>> org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:763)
>>
>> 23:     Caused by: org.opencms.db.CmsDbSqlException: An SQL error
>> occurred when executing the following query:
>> net.sourceforge.jtds.jdbc.JtdsPreparedStatement at 5deb2871.
>>
>> 22:               ... 5 more
>>
>> 21:               at
>> org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:3317)
>>
>> 20:               at
>> org.opencms.db.CmsDriverManager.init(CmsDriverManager.java:5129)
>>
>> 19:               at
>> org.opencms.db.generic.CmsUserDriver.fillDefaults(CmsUserDriver.java:816)
>>
>> 18:               at
>> org.opencms.db.generic.CmsUserDriver.internalCreateDefaultGroups(CmsUserDriver.java:2206)
>>
>> 17:     Caused by: org.opencms.main.CmsInitException: Critical error
>> during OpenCms initialization: Unable to initialize the user driver.
>>
>> 16:               at
>> org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:148)
>>
>> 15:               at org.opencms.main.CmsShell.<init>(CmsShell.java:447)
>>
>> 14:               at
>> org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1964)
>>
>> 13:               at
>> org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1239)
>>
>> 12:               at
>> org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:165)
>>
>> 11:               at
>> org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:3326)
>>
>> 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 occurred:
>>
>> 5:       --------------------
>>
>> 4:
>>
>> 3:
>>
>> 2:       OpenCms property file:
>> "/opt/software/tomcat7/webapps/opencms/WEB-INF/config/opencms.properties".
>>
>> 1:       OpenCms WEB-INF path:
>> "/opt/software/tomcat7/webapps/opencms/WEB-INF/".
>>
>>
>>
>>
>>
>> Please help.
>>
>>
>>
>> Thanks,
>>
>> Alagammai
>>
>>
>> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
>> _
>> CONFIDENTIALITY NOTICE: This email message, including any attachments, is
>> for the sole use of the intended recipient(s) and may contain confidential
>> and privileged information and/or Protected Health Information (PHI)
>> subject to protection under the law, including the Health Insurance
>> Portability and Accountability Act of 1996, as amended (HIPAA). If you are
>> not the intended recipient or the person responsible for delivering the
>> email to the intended recipient, be advised that you have received this
>> email in error and that any use, disclosure, distribution, forwarding,
>> printing, or copying of this email is strictly prohibited. If you have
>> received this email in error, please notify the sender immediately and
>> destroy all copies of the original message.
>>
>> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
>> _
>> CONFIDENTIALITY NOTICE: This email message, including any attachments, is
>> for the sole use of the intended recipient(s) and may contain confidential
>> and privileged information and/or Protected Health Information (PHI)
>> subject to protection under the law, including the Health Insurance
>> Portability and Accountability Act of 1996, as amended (HIPAA). If you are
>> not the intended recipient or the person responsible for delivering the
>> email to the intended recipient, be advised that you have received this
>> email in error and that any use, disclosure, distribution, forwarding,
>> printing, or copying of this email is strictly prohibited. If you have
>> received this email in error, please notify the sender immediately and
>> destroy all copies of the original message.
>>
>> _______________________________________________
>> 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
>>
>>
>>
>>
>>
>   _______________________________________________
> 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
>
>
>
>
>
> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
> CONFIDENTIALITY NOTICE: This email message, including any attachments, is
> for the sole use of the intended recipient(s) and may contain confidential
> and privileged information and/or Protected Health Information (PHI)
> subject to protection under the law, including the Health Insurance
> Portability and Accountability Act of 1996, as amended (HIPAA). If you are
> not the intended recipient or the person responsible for delivering the
> email to the intended recipient, be advised that you have received this
> email in error and that any use, disclosure, distribution, forwarding,
> printing, or copying of this email is strictly prohibited. If you have
> received this email in error, please notify the sender immediately and
> destroy all copies of the original message.
>
> _______________________________________________
> 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/20140512/e8d874b3/attachment.htm>


More information about the opencms-dev mailing list