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

Mon May 12 14:14:31 CEST 2014

Please see below after our Linux administrator has tried using the Open JDK version 1.7.0_55 along with RHEL -Linux distro, getting the same error.

Still using the same remote DB server: SQLServer 2008 R2 as that’s what we need in our project.

From: Black, Howard
Sent: Monday, May 12, 2014 5:14 PM
To: Selvaganapathy, Alagammai
Cc: Francisco, Sandi; Colson, Suzanne; TPA-DST-Middleware WAS
Subject: RE: [opencms-dev] Help with the OpenCms (9.0.1) installation on Tomcat 7.0.53

We still error out with Open JDK version 1.7.0_55.

[root at test-jboss01 /]# java -version
java version "1.7.0_55"
OpenJDK Runtime Environment (rhel-2.4.7.1.el6_5-x86_64 u55-b13)
OpenJDK 64-Bit Server VM (build 24.51-b03, mixed mode)
[root at test-jboss01 /]#

53:
52:     Shutdown completed, total uptime was 00:01:14.
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<mailto:$%7buser%7d@$%7bproject%7d%3ejava.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 1f6c93f1<mailto:net.sourceforge.jtds.jdbc.JtdsPreparedStatement at 1f6c93f1>.
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/".

Howard Black | WebSphere App Server Engineer
[Description: Description: HPSlogo-RGB transp bkgr]
3501 Frontage Rd.
Tampa, FL 33607

www.healthplan.com<http://www.healthplan.com/>
Email: hblack at HealthPlan.com<mailto:hblack at HealthPlan.com>
Office: (813) 289-1000 7004019
Mobile: (813) 293-4838
Home: (813) 907-9183

From: Black, Howard
Sent: Monday, May 12, 2014 7:17 AM
To: Selvaganapathy, Alagammai
Cc: Francisco, Sandi; Colson, Suzanne; TPA-DST-Middleware WAS
Subject: RE: [opencms-dev] Help with the OpenCms (9.0.1) installation on Tomcat 7.0.53

I can set tomcat to use a different java other than IBM’s java.  Let me do that and we’ll try again.

Howard Black | WebSphere App Server Engineer
[Description: Description: HPSlogo-RGB transp bkgr]
3501 Frontage Rd.
Tampa, FL 33607

www.healthplan.com<http://www.healthplan.com/>
Email: hblack at HealthPlan.com<mailto:hblack at HealthPlan.com>
Office: (813) 289-1000 7004019
Mobile: (813) 293-4838
Home: (813) 907-9183

From: Selvaganapathy, Alagammai
Sent: Monday, May 12, 2014 7:15 AM
To: Black, Howard
Cc: Francisco, Sandi; Colson, Suzanne
Subject: FW: [opencms-dev] Help with the OpenCms (9.0.1) installation on Tomcat 7.0.53

Please see below.

This regarding the issues while we are trying to connect the OpenCms software with SQL server 2008 R2 (HPSSQl11/SQL11) from Linux server test-jboss01.(02)

From: opencms-dev-bounces at opencms.org<mailto:opencms-dev-bounces at opencms.org> [mailto:opencms-dev-bounces at opencms.org]<mailto:[mailto:opencms-dev-bounces at opencms.org]> On Behalf Of Arash Kaffamanesh
Sent: Monday, May 12, 2014 4:39 PM
To: The OpenCms mailing list
Subject: Re: [opencms-dev] Help with the OpenCms (9.0.1) installation on Tomcat 7.0.53

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<mailto:aselvaganapathy at healthplan.com>> wrote:
We are using SQL Server 2008 R2 and the Java version is IBM 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<mailto: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<mailto: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> [mailto: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<mailto: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<mailto:$%7buser%7d@$%7bproject%7d%3ejava.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<mailto: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.

_______________________________________________
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

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20140512/eb6dced4/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 9231 bytes
Desc: image001.png
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20140512/eb6dced4/attachment.png>