You don't need to copy mssql_persistence.xml tp persistense.xml, Web installer will do it for you what are your installation steps? What version of OM are you installing?
On Mon, Mar 28, 2016 at 12:54 PM, HENRY <[email protected]> wrote: > thanks Susheel Jalali... > > no 1> it is OK... that the right location > > no 2> done, after copy from command like this : cp mssql_persistence.xml > persistence.xml and then modify connection properties including userid/ > password. > > but it is still error. > > > how am i supposed to do ??? thanks a lot. > > > > > > > On 3/28/2016 1:35 PM, Susheel Jalali wrote: > > 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 <[email protected]> <[email protected]> > Date: Sun, March 27, 2016 11:17 pm > To: [email protected] > > 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 instruction > <http://openmeetings.apache.org/MSSQLConfig.html> > http://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 > > > > > -- WBR Maxim aka solomax
