Great! Thanks for the update :) On Sun, Sep 11, 2016 at 8:13 PM, Daniel Baker <[email protected]> wrote: > Hi Maxim, > > > I decided to do a fresh install on a VM and the install went well. I used > this documentation : > > https://cwiki.apache.org/confluence/display/OPENMEETINGS/Tutorials+for+installing+OpenMeetings+and+Tools?preview=/27838216/62690369/Installation%20OpenMeetings%203.1.x%20on%20Ubuntu%2016.04%20LTS.pdf > > > I can use openmeetings so we no longer need to pursue this error. > > > > Thanks for the help > > Dan > > On 09/11/2016 07:07 PM, Maxim Solodovnik wrote: >> >> Hello Daniel, >> >> What DB are you using? Is it mysql? >> According to error log database with name KAM270 does not exist. >> have you created it with CREATE DATABASE .... query (please don't >> forget to set UTF-8 encoding while DB creating) >> >> On Sun, Sep 11, 2016 at 3:58 PM, Daniel Baker >> <[email protected]> wrote: >>> >>> Hi Hemant, >>> >>> I copied over the mysql-connector-java-5.1.39-bin.jar into >>> ~webapps/OM_CONTEXT/WEB-INF/lib >>> >>> >>> I checked the derby persistence.xml file it has the correct url, >>> username, >>> and password details. >>> >>> >>> The progress bar on the last step moved across about 25% then gave >>> another >>> error : >>> >>> I have not made any other changes to the database. >>> >>> OpenMeetings >>> OpenMeetings >>> Installation is failed >>> >>> org.springframework.orm.jpa.JpaSystemException: The transaction has been >>> rolled back. See the nested exceptions for details on the errors that >>> occurred.; nested exception is <openjpa-2.4.1-r422266:1730418 fatal >>> general >>> error> org.apache.openjpa.persistence.PersistenceException: The >>> transaction >>> has been rolled back. See the nested exceptions for details on the >>> errors >>> that occurred. >>> at >>> >>> org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:418) >>> at >>> >>> org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:122) >>> at >>> >>> org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:521) >>> at >>> >>> org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761) >>> at >>> >>> org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730) >>> at >>> >>> org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:485) >>> at >>> >>> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291) >>> 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:655) >>> at >>> >>> org.apache.openmeetings.db.dao.basic.NavigationDao$$EnhancerBySpringCGLIB$$8d335b5b.addGlobalStructure(<generated>) >>> >>> at >>> >>> org.apache.openmeetings.installation.ImportInitvalues.loadMainMenu(ImportInitvalues.java:118) >>> at >>> >>> org.apache.openmeetings.installation.ImportInitvalues.loadSystem(ImportInitvalues.java:517) >>> at >>> >>> org.apache.openmeetings.installation.ImportInitvalues.loadAll(ImportInitvalues.java:533) >>> at >>> >>> org.apache.openmeetings.web.pages.install.InstallWizard$InstallProcess.run(InstallWizard.java:642) >>> at java.lang.Thread.run(Thread.java:745) >>> Caused by: <openjpa-2.4.1-r422266:1730418 fatal general error> >>> org.apache.openjpa.persistence.PersistenceException: The transaction has >>> been rolled back. See the nested exceptions for details on the errors >>> that >>> occurred. >>> at >>> >>> org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2368) >>> at >>> org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2205) >>> at >>> org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2103) >>> at >>> >>> org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2021) >>> at >>> >>> org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81) >>> at >>> org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1526) >>> at >>> >>> org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:932) >>> at >>> >>> org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:571) >>> at >>> >>> org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:517) >>> ... 13 more >>> Caused by: <openjpa-2.4.1-r422266:1730418 fatal general error> >>> org.apache.openjpa.persistence.PersistenceException: Schema 'KAM270' does >>> not exist {INSERT INTO naviglobal (comment, deleted, icon, inserted, >>> label_id, level_id, name, naviorder, tooltip_label_id, updated) VALUES >>> (?, >>> ?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=20000, state=42Y07] >>> at >>> org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5003) >>> at >>> >>> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4963) >>> at >>> >>> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:133) >>> at >>> >>> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:107) >>> at >>> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:59) >>> at >>> >>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:90) >>> at >>> >>> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:550) >>> at >>> >>> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106) >>> at >>> >>> org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59) >>> at >>> >>> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:104) >>> at >>> >>> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:77) >>> at >>> >>> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:731) >>> at >>> >>> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131) >>> at >>> >>> org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:668) >>> at >>> >>> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131) >>> ... 21 more >>> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Schema >>> 'KAM270' does not exist {INSERT INTO naviglobal (comment, deleted, icon, >>> inserted, label_id, level_id, name, naviorder, tooltip_label_id, updated) >>> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=20000, state=42Y07] >>> at >>> >>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:218) >>> at >>> >>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:198) >>> at >>> >>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:58) >>> at >>> >>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:250) >>> at >>> >>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:133) >>> at >>> >>> org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:139) >>> at >>> >>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:133) >>> at >>> >>> org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.prepareStatement(JDBCStoreManager.java:1642) >>> at >>> >>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:122) >>> at >>> >>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.prepareStatement(PreparedStatementManagerImpl.java:290) >>> at >>> >>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:113) >>> at >>> >>> org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:79) >>> at >>> >>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:100) >>> at >>> >>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:88) >>> ... 30 more >>> >>> >>> >>> >>> >>> >>> On 09/11/2016 03:13 PM, Coscend@OM wrote: >>>> >>>> >>>> Hello Daniel, >>>> >>>> "See the nested exceptions for details on the errors that occurred.; >>>> nested exception is <openjpa-2.4.1-r422266:1730418 fatal general error> >>>> ... >>>> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Schema >>>> 'KAM270' does not exist {INSERT INTO naviglobal (comment, deleted, icon, >>>> inserted, label_id, level_id, name, naviorder, tooltip_label_id, >>>> updated) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=20000, >>>> state=42Y07]" >>>> >>>> Have you made any changes to the database schema? >>>> >>>> Two other pointers to check: >>>> 1. Copy mysql-connector-java-5.1.39-bin.jar in >>>> ~webapps/OM_CONTEXT/WEB-INF/lib >>>> 2. choose right persistence.xml file >>>> url: Database name >>>> Username >>>> password >>>> >>>> Thank you. >>>> >>>> Sincerely, >>>> >>>> Hemant K. Sabat >>>> >>>> Coscend Communications Solutions >>>> Web site: 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----- >>>> From: Daniel Baker [mailto:[email protected]] >>>> Sent: Sunday, September 11, 2016 3:06 AM >>>> To: [email protected] >>>> Subject: error installing 3.1.2 on ubuntu >>>> >>>> Hi, I am trying to install openmeetings 3.1.2 on Ubuntu 14.04 >>>> >>>> I am using the red5.sh script. >>>> >>>> I get the following error at the last stage of the install: >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> OpenMeetings >>>> OpenMeetings >>>> Installation is failed >>>> >>>> org.springframework.orm.jpa.JpaSystemException: The transaction has been >>>> rolled back. See the nested exceptions for details on the errors that >>>> occurred.; nested exception is <openjpa-2.4.1-r422266:1730418 fatal >>>> general >>>> error> org.apache.openjpa.persistence.PersistenceException: The >>>> transaction >>>> has been rolled back. See the nested exceptions for details on the >>>> errors >>>> that occurred. >>>> at >>>> >>>> >>>> org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:418) >>>> at >>>> >>>> >>>> org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:122) >>>> at >>>> >>>> >>>> org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:521) >>>> at >>>> >>>> >>>> org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761) >>>> at >>>> >>>> >>>> org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730) >>>> at >>>> >>>> >>>> org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:485) >>>> at >>>> >>>> >>>> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291) >>>> 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:655) >>>> at >>>> >>>> >>>> org.apache.openmeetings.db.dao.basic.NavigationDao$$EnhancerBySpringCGLIB$$41d64e21.addGlobalStructure(<generated>) >>>> at >>>> >>>> >>>> org.apache.openmeetings.installation.ImportInitvalues.loadMainMenu(ImportInitvalues.java:118) >>>> at >>>> >>>> >>>> org.apache.openmeetings.installation.ImportInitvalues.loadSystem(ImportInitvalues.java:517) >>>> at >>>> >>>> >>>> org.apache.openmeetings.installation.ImportInitvalues.loadAll(ImportInitvalues.java:533) >>>> at >>>> >>>> >>>> org.apache.openmeetings.web.pages.install.InstallWizard$InstallProcess.run(InstallWizard.java:642) >>>> at java.lang.Thread.run(Thread.java:745) >>>> Caused by: <openjpa-2.4.1-r422266:1730418 fatal general error> >>>> org.apache.openjpa.persistence.PersistenceException: The transaction has >>>> been rolled back. See the nested exceptions for details on the errors >>>> that >>>> occurred. >>>> at >>>> >>>> >>>> org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2368) >>>> at >>>> org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2205) >>>> at >>>> org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2103) >>>> at >>>> >>>> >>>> org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2021) >>>> at >>>> >>>> >>>> org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81) >>>> at >>>> org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1526) >>>> at >>>> >>>> >>>> org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:932) >>>> at >>>> >>>> >>>> org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:571) >>>> at >>>> >>>> >>>> org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:517) >>>> ... 13 more >>>> Caused by: <openjpa-2.4.1-r422266:1730418 fatal general error> >>>> org.apache.openjpa.persistence.PersistenceException: Schema 'KAM270' >>>> does not exist {INSERT INTO naviglobal (comment, deleted, icon, >>>> inserted, >>>> label_id, level_id, name, naviorder, tooltip_label_id, >>>> updated) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=20000, >>>> state=42Y07] >>>> at >>>> org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5003) >>>> at >>>> >>>> >>>> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4963) >>>> at >>>> >>>> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:133) >>>> at >>>> >>>> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:107) >>>> at >>>> >>>> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:59) >>>> at >>>> >>>> >>>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:90) >>>> at >>>> >>>> >>>> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:550) >>>> at >>>> >>>> >>>> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106) >>>> at >>>> >>>> >>>> org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59) >>>> at >>>> >>>> >>>> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:104) >>>> at >>>> >>>> >>>> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:77) >>>> at >>>> >>>> >>>> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:731) >>>> at >>>> >>>> >>>> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131) >>>> at >>>> >>>> >>>> org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:668) >>>> at >>>> >>>> >>>> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131) >>>> ... 21 more >>>> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Schema >>>> 'KAM270' does not exist {INSERT INTO naviglobal (comment, deleted, icon, >>>> inserted, label_id, level_id, name, naviorder, tooltip_label_id, >>>> updated) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=20000, >>>> state=42Y07] >>>> at >>>> >>>> >>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:218) >>>> at >>>> >>>> >>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:198) >>>> at >>>> >>>> >>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:58) >>>> at >>>> >>>> >>>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:250) >>>> at >>>> >>>> >>>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:133) >>>> at >>>> >>>> >>>> org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:139) >>>> at >>>> >>>> >>>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:133) >>>> at >>>> >>>> >>>> org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.prepareStatement(JDBCStoreManager.java:1642) >>>> at >>>> >>>> >>>> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:122) >>>> at >>>> >>>> >>>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.prepareStatement(PreparedStatementManagerImpl.java:290) >>>> at >>>> >>>> >>>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:113) >>>> at >>>> >>>> >>>> org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:79) >>>> at >>>> >>>> >>>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:100) >>>> at >>>> >>>> >>>> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:88) >>>> >>>> >>>> >>>> ... 30 more >>>> >>>> >>>> Any ideas how to solve this much appreciated. >>>> >>>> >>>> Thanks, >>>> >>>> >>>> Dan >>>> >>>> >>>> >>>> ----- >>>> No virus found in this message. >>>> Checked by AVG - www.avg.com >>>> Version: 2016.0.7752 / Virus Database: 4649/12992 - Release Date: >>>> 09/11/16 >>>> >>>> >>>> >>> >> >> >> >
-- WBR Maxim aka solomax
