<div dir="ltr"><div class="gmail_extra"><div><div dir="ltr"><div><div style="font-family:arial;font-size:small"><div>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.</div>
<div>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.</div><div><div><br><a href="https://www.facebook.com/cloudssky" style="color:rgb(17,85,204)" target="_blank">Like</a> | <a href="https://twitter.com/CLOUDSSKYONE" style="color:rgb(17,85,204)" target="_blank">Follow</a> | <font color="#0000ff"><font color="#0000ff"><a href="http://cloudssky.com/en/cloud_services/cloudsite.html" target="_blank">Build your CloudSite with OpenCms OCCX </a></font></font></div>
</div></div></div></div></div><br><div class="gmail_quote">On Mon, May 12, 2014 at 7:31 AM, Selvaganapathy, Alagammai <span dir="ltr"><<a href="mailto:aselvaganapathy@healthplan.com" target="_blank">aselvaganapathy@healthplan.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word">
We are using SQL Server 2008 R2 and the Java version is <span style="font-family:Arial;font-size:11px">I</span><b style="font-family:Arial;font-size:11px">BM SDK for Linux, Java Technology Edition, Version 7.</b>
<div><font face="Arial"><span style="font-size:11px"><br>
</span></font></div>
<div><font face="Arial"><span style="font-size:11px">And Black Howard, Cced is my Linux Administrator who admins the OpenCms Linux servers.<br>
</span></font><div><div class="h5">
<div><br>
</div>
<div><br>
</div>
<div>On 09-May-2014, at 10:44 pm, Arash Kaffamanesh <<a href="mailto:ak@cloudssky.com" target="_blank">ak@cloudssky.com</a>> wrote:
<div>
<div><br>
<blockquote type="cite">
<div dir="ltr">Hi,
<div><br>
</div>
<div>With which database are you trying to install OpenCms, what's your linux distro? Which java version are you using?</div>
<div>
<div class="gmail_extra"><br clear="all">
<div>
<div dir="ltr">
<div></div>
<div>
<div style="font-family:arial;font-size:small">
<div>
<div>Kind Regards,</div>
<div>Arash</div>
<div><br>
<a href="https://www.facebook.com/cloudssky" style="color:rgb(17,85,204)" target="_blank">Like</a> | <a href="https://twitter.com/CLOUDSSKYONE" style="color:rgb(17,85,204)" target="_blank">Follow</a> | <font color="#0000ff"><font color="#0000ff"><a href="http://cloudssky.com/en/cloud_services/cloudsite.html" target="_blank">Build
your CloudSite with OpenCms OCCX</a></font></font></div>
</div>
<div>
<p style="color:rgb(34,34,34)"><span style="color:rgb(11,83,148)"><b></b></span><font></font></p>
<font size="1"></font></div>
</div>
</div>
</div>
</div>
<br>
<br>
<div class="gmail_quote">On Fri, May 9, 2014 at 6:14 PM, Selvaganapathy, Alagammai
<span dir="ltr"><<a href="mailto:aselvaganapathy@healthplan.com" target="_blank">aselvaganapathy@healthplan.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div lang="EN-US" link="blue" vlink="purple">
<div>
<p class="MsoNormal"><span style="color:#1f497d">Just following up to see any updates.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Thanks,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Alagammai<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<div>
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">
<a href="mailto:opencms-dev-bounces@opencms.org" target="_blank">opencms-dev-bounces@opencms.org</a> [mailto:<a href="mailto:opencms-dev-bounces@opencms.org" target="_blank">opencms-dev-bounces@opencms.org</a>]
<b>On Behalf Of </b>Selvaganapathy, Alagammai<br>
<b>Sent:</b> Thursday, May 08, 2014 4:38 PM<br>
<b>To:</b> '<a href="mailto:opencms-dev@opencms.org" target="_blank">opencms-dev@opencms.org</a>'<br>
<b>Cc:</b> Black, Howard<br>
<b>Subject:</b> [opencms-dev] Help with the OpenCms (9.0.1) installation on Tomcat 7.0.53<u></u><u></u></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Team,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Good Day! <u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">We are trying to install the OpenCms software on our Linux based Apache Tomcat 7.0.53 server.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">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.
<u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">Here is the error.(Stacktrace from the logs)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">53:
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">52: Shutdown completed, total uptime was 00:03:33.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">51: Shutting down OpenCms, version 9.0.1 in web application "opencms"<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">50:
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">49:
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">48: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:202)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">47: at org.opencms.setup.CmsSetupWorkplaceImportThread.kill(CmsSetupWorkplaceImportThread.java:110)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">46: at org.opencms.main.CmsShell.exit(CmsShell.java:571)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">45: java.lang.NullPointerException<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">44: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:187)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">43: at org.opencms.main.CmsShell.start(CmsShell.java:663)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">42: at org.opencms.main.CmsShell.executeCommands(CmsShell.java:835)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">41: at org.opencms.main.CmsShell.executeCommand(CmsShell.java:760)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">40:
<a href="mailto:$%7buser%7d@$%7bproject%7d%3ejava.lang.NullPointerException" target="_blank">
${user}@${project}>java.lang.NullPointerException</a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">39: ${user}@${project}># Turn echo on<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">38: ... 9 more<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">37: at org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:750)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">36: at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">35: at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">34: at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">33: at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">32: at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">31: at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">30: at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">29: at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">28: at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">27: Caused by: java.sql.SQLException: Invalid object name 'CMS_GROUPS'.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">26: ... 8 more<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">25: at org.opencms.db.generic.CmsUserDriver.internalCreateDefaultGroups(CmsUserDriver.java:2173)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">24: at org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:763)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">23: Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query:
<a href="mailto:net.sourceforge.jtds.jdbc.JtdsPreparedStatement@5deb2871" target="_blank">
net.sourceforge.jtds.jdbc.JtdsPreparedStatement@5deb2871</a>. <u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">22: ... 5 more<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">21: at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:3317)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">20: at org.opencms.db.CmsDriverManager.init(CmsDriverManager.java:5129)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">19: at org.opencms.db.generic.CmsUserDriver.fillDefaults(CmsUserDriver.java:816)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">18: at org.opencms.db.generic.CmsUserDriver.internalCreateDefaultGroups(CmsUserDriver.java:2206)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">17: Caused by: org.opencms.main.CmsInitException: Critical error during OpenCms initialization: Unable to initialize the user driver.
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">16: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:148)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">15: at org.opencms.main.CmsShell.<init>(CmsShell.java:447)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">14: at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1964)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">13: at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1239)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">12: at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:165)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">11: at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:3326)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">10: org.opencms.main.CmsInitException: Critical error while loading driver manager.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">9: --------------------<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">8: Giving up, unable to start OpenCms.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">7: Critical error during OpenCms initialization: Unable to initialize the user driver.
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">6: The following critical error occurred:<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">5: --------------------<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">4:
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">3:
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">2: OpenCms property file: "/opt/software/tomcat7/webapps/opencms/WEB-INF/config/opencms.properties".<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Trebuchet MS","sans-serif";color:#1d1b11">1: OpenCms WEB-INF path: "/opt/software/tomcat7/webapps/opencms/WEB-INF/".<u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Please help.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Thanks,<u></u><u></u></p>
<p class="MsoNormal">Alagammai<u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif""><br>
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _<br>
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.<u></u><u></u></span></p>
</div>
</div>
</div>
<div>
<div><br clear="both">
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _<br>
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.<br>
</div>
</div>
</div>
<br>
_______________________________________________<br>
This mail is sent to you from the opencms-dev mailing list<br>
To change your list options, or to unsubscribe from the list, please visit<br>
<a href="http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev" target="_blank">http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev</a><br>
<br>
<br>
<br>
<br>
</blockquote>
</div>
<br>
</div>
</div>
</div>
_______________________________________________<br>
This mail is sent to you from the opencms-dev mailing list<br>
To change your list options, or to unsubscribe from the list, please visit<br>
<a href="http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev" target="_blank">http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev</a><br>
<br>
<br>
<br>
</blockquote>
</div>
<br>
</div>
</div>
</div></div></div><div><div class="h5">
<br clear="both">
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _<br>
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.<br>
</div></div></div>
<br>_______________________________________________<br>
This mail is sent to you from the opencms-dev mailing list<br>
To change your list options, or to unsubscribe from the list, please visit<br>
<a href="http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev" target="_blank">http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev</a><br>
<br>
<br>
<br>
<br></blockquote></div><br></div></div>