Re: error installing 3.1.2 on ubuntu

Daniel Baker Sun, 11 Sep 2016 06:15:08 -0700

Hi Maxim,

I decided to do a fresh install on a VM and the install went well. Iused 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
<i...@collisiondetection.biz> 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:i...@collisiondetection.biz]
Sent: Sunday, September 11, 2016 3:06 AM
To: user@openmeetings.apache.org
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

Re: error installing 3.1.2 on ubuntu

Reply via email to