Dear Henry,
The first questions to check here would be:
1. Did you happen to place the MySQL Java Connector
(mysql-connector-java-<X.Y.Z>-bin.jar) in the right location:
~~/dist/red5/webapps/openmeetings/WEB-INF/lib
2. Did you use the right database connection file AND correct database
NAME (to match the DB name created in your MS SQL DBMS) in
~~/dist/red5/webapps/openmeetings/WEB-INF/classes/META-INF
You need to copy mssql_persistence.xml to persistence.xml, and then
modify connection properties including userid/ password.
Hope it helps.
--
Sincerely,
Susheel Jalali
Coscend Communications Solutions
www.Coscend.com
----------------------------------------------------------------
CONFIDENTIALITY NOTICE: See 'Confidentiality Notice Regarding E-mail
Messages from Coscend Communications Solutions' posted at:
http://www.Coscend.com/Terms_and_Conditions.html
-------- Original Message --------
Subject: Re: error when install openmeeting on debian 8
From: HENRY <he...@mersi.co.id>
Date: Sun, March 27, 2016 11:17 pm
To: user@openmeetings.apache.org
Hai Vasily,..
thanks a lot for your respon.
i just installed from the tutorial " Installation of Apache
OpenMeetings 3.0.x on Debian 8 " .
if I had been in the right conditions?
Distributor ID: Debian
Description: Debian GNU/Linux 8.3 (jessie)
Release: 8.3
Codename: jessie
this is conditions still need add JDBC driver for MS SQL server ? or
i've to install openmeeting versi 2.x first ?
please your advice. thanks Vasily.
regards
Henry
On 3/28/2016 12:37 PM, Vasiliy Degtyarev wrote:
Hello Henry,
You should add JDBC driver fo MS SQL server.
Please see this
instructionhttp://openmeetings.apache.org/MSSQLConfig.html.
Thanks,
Vasiliy
On 28.03.2016 11:21, HENRY wrote:
dear All,..
why i've got error message like this ?
Installation is failed
org.springframework.transaction.CannotCreateTransactionException: Could not open
JPA EntityManager for transaction; nested exception is
<openjpa-2.4.1-r422266:1730418 fatal general error>
org.apache.openjpa.persistence.PersistenceException: Cannot load JDBC driver class
'com.microsoft.sqlserver.jdbc.SQLServerDriver'
at
org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:431)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:463)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:276)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at
org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653)
at
org.apache.openmeetings.db.dao.basic.NavigationDao$$EnhancerBySpringCGLIB$$ca6c58c.addGlobalStructure(<generated>)
at
org.apache.openmeetings.installation.ImportInitvalues.loadMainMenu(ImportInitvalues.java:117)
at
org.apache.openmeetings.installation.ImportInitvalues.loadSystem(ImportInitvalues.java:607)
at
org.apache.openmeetings.installation.ImportInitvalues.loadAll(ImportInitvalues.java:626)
at
org.apache.openmeetings.web.pages.install.InstallWizard$InstallProcess.run(InstallWizard.java:641)
at java.lang.Thread.run(Thread.java:745)
Caused by: <openjpa-2.4.1-r422266:1730418 fatal general error>
org.apache.openjpa.persistence.PersistenceException: Cannot load JDBC driver class
'com.microsoft.sqlserver.jdbc.SQLServerDriver'
at
org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:106)
at
org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getDBDictionaryInstance(JDBCConfigurationImpl.java:603)
at
org.apache.openjpa.jdbc.meta.MappingRepository.endConfiguration(MappingRepository.java:1520)
at
org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:533)
at
org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:458)
at
org.apache.openjpa.lib.conf.PluginValue.instantiate(PluginValue.java:121)
at
org.apache.openjpa.conf.MetaDataRepositoryValue.instantiate(MetaDataRepositoryValue.java:68)
at
org.apache.openjpa.lib.conf.ObjectValue.instantiate(ObjectValue.java:83)
at
org.apache.openjpa.conf.OpenJPAConfigurationImpl.newMetaDataRepositoryInstance(OpenJPAConfigurationImpl.java:967)
at
org.apache.openjpa.conf.OpenJPAConfigurationImpl.getMetaDataRepositoryInstance(OpenJPAConfigurationImpl.java:958)
at
org.apache.openjpa.kernel.AbstractBrokerFactory.makeReadOnly(AbstractBrokerFactory.java:642)
at
org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:202)
at
org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:154)
at
org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:226)
at
org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:153)
at
org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:59)
at
org.springframework.orm.jpa.JpaTransactionManager.createEntityManagerForTransaction(JpaTransactionManager.java:449)
at
org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:369)
... 12 more
Caused by: java.sql.SQLException: Cannot load JDBC driver class
'com.microsoft.sqlserver.jdbc.SQLServerDriver'
at
org.apache.commons.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2139)
at
org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2033)
at
org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533)
at
org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:110)
at
org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:86)
at
org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:90)
... 29 more
Caused by: java.lang.ClassNotFoundException:
com.microsoft.sqlserver.jdbc.SQLServerDriver
at
org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1332)
at
org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1166)
at
org.apache.commons.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2131)
... 34 more
please anybody can help me,.. thanks a lot
Henry L.S
