You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by Daniel Baker <in...@collisiondetection.biz> on 2016/09/11 08:06:26 UTC
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
Re: How to host openmeetings for the public
Posted by Daniel Baker <in...@collisiondetection.biz>.
I followed the tutorial you have.
https://cwiki.apache.org/confluence/display/OPENMEETINGS/Tutorials+for+installing+OpenMeetings+and+Tools?preview=/27838216/30966783/Installing%20OM2.x%20On%20Ubuntu64%20-%20Headless%20-%2012.10.pdf
Step 13: Installing Reverse Proxy using Apache Web Server (Optional)
Is this config appropriate for web access and not just local LAN access?
Thanks,
Dan
On 09/28/2016 05:49 AM, Daniel Baker wrote:
> Hi Maxim,
>
> I have implemented option 1 but I still can not access OpenMeetings from
> the web.
>
> Is there any special changes I need to make ? Maybe in Apache ?
>
>
> Thanks,
>
> Dan
>
>
>
>
> On 09/12/2016 10:38 PM, Maxim Solodovnik wrote:
>> Hello Daniel,
>>
>> you have 2 options:
>> 1) open necessary ports and access your OM as
>> http://your_host:5080/openmeetings instead of ...localhost:5080...
>> 2) set up front-end apache/nginx and use it as proxy for your OM
>>
>> On Mon, Sep 12, 2016 at 9:17 PM, Daniel Baker
>> <in...@collisiondetection.biz> wrote:
>>> Hi,
>>>
>>>
>>> I recently set up OpenMeetings 3.1.2 in a Ububtu 16.04 Virtual
>>> Machine. It
>>> works great on my local LAN. Now I would like others on the internet to
>>> join my meetings.
>>>
>>>
>>> I have a vague idea how to do this but could someone please detail the
>>> steps necessary.
>>>
>>> I have checked with my ISP and they said they can give me a fixed
>>> public IP.
>>> I have a domain name ready to use.
>>>
>>>
>>>
>>> Thanks for the help.
>>>
>>> Dan
>>
>>
>>
>
>
Re: Connection testing shows errors
Posted by Daniel Baker <in...@collisiondetection.biz>.
Ok thanks, I will try that if I need to change the ports again.
On 09/30/2016 12:04 PM, Coscend@OM wrote:
> Hello Daniel,
>
> When you change ports from its default 5080/1935 to something else, you might want to change it in four places, wherever applicable:
> 1. Firewall hardware: policy
> 2. OS firewall: policy
> OpenMeetings: 3. config.xml and 4. red5.properties
>
> 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:info@collisiondetection.biz]
> Sent: Thursday, September 29, 2016 11:58 PM
> To: user@openmeetings.apache.org
> Subject: Re: Connection testing shows errors
>
> I just changed the port 5080 to 80 in config.xml which caused the network testing to stop working. It looks like it is always searching for port 5080 to do the tests.
>
> When I went back to port 5080 it started working again.
>
>
> Thanks,
>
> Dan
>
> On 09/30/2016 11:30 AM, Maxim Solodovnik wrote:
>> Actually NetworkTesting should read config.xml to be able to check the
>> exact ports/paths as OM will use so I would appreciate detailed
>> configuration to reprobuce the issue
>>
>> On Fri, Sep 30, 2016 at 11:27 AM, Daniel Baker
>> <info@collisiondetection.biz <ma...@collisiondetection.biz>> wrote:
>>
>> Yes I changed the config.xml file.
>>
>>
>> Since port forwarding is working ok now I just changed it back to
>> 5080. I could see from the error report it was looking for port 5080.
>>
>>
>> So the Connection testing is working as expected now.
>>
>>
>>
>> Thanks,
>>
>> Dan
>>
>>
>>
>>
>> On 09/29/2016 11:00 PM, Maxim Solodovnik wrote:
>>
>> have you changed ports in config.xml?
>>
>> On Thu, Sep 29, 2016 at 9:33 PM, Daniel Baker
>> <info@collisiondetection.biz
>> <ma...@collisiondetection.biz>
>> <mailto:info@collisiondetection.biz
>> <ma...@collisiondetection.biz>>> wrote:
>>
>> Hi,
>>
>>
>> I'm using OpenMeetings Version: 3.1.2 Revision 1756072
>>
>>
>>
>> When I perform a test of the ping, jitter,download and
>> upload they
>> fail.
>>
>>
>> The RTMP port test works ok.
>>
>>
>> Are the ping, jitter,download and upload ports always
>> working over
>> port 5080.
>>
>>
>> I have changed the default port 5080 to 80. Would this
>> make the
>> test fail ?
>>
>>
>>
>> Here are my logs :
>>
>>
>>
>> Ping: start test...
>>
>> http://aseanenglish.info:5080/meetings/services/networktest?type=ping
>> <http://aseanenglish.info:5080/meetings/services/networktest?type=ping>
>> <http://aseanenglish.info:5080/meetings/services/networktest?type=ping
>> <http://aseanenglish.info:5080/meetings/services/networktest?type=ping>>
>> Ping: stopped
>> Port: : start test...
>> rtmp://aseanenglish.info:1935/meetings/hibernate
>> <http://aseanenglish.info:1935/meetings/hibernate>
>> <http://aseanenglish.info:1935/meetings/hibernate
>> <http://aseanenglish.info:1935/meetings/hibernate>>
>> Port: port is available
>>
>> Jitter: start test...
>>
>> http://aseanenglish.info:5080/meetings/services/networktest?type=jitter
>>
>> <http://aseanenglish.info:5080/meetings/services/networktest?type=jitt
>> er>
>>
>> <http://aseanenglish.info:5080/meetings/services/networktest?type=jitter
>> <http://aseanenglish.info:5080/meetings/services/networktest?type=jitter>>
>> Jitter: stopped
>> Download speed: start test...
>>
>> http://aseanenglish.info:5080/meetings/services/networktest?type=download
>>
>> <http://aseanenglish.info:5080/meetings/services/networktest?type=down
>> load>
>>
>> <http://aseanenglish.info:5080/meetings/services/networktest?type=download
>> <http://aseanenglish.info:5080/meetings/services/networktest?type=download>>
>> Download speed: report: connection error
>> Upload speed: start test...
>> http://aseanenglish.info:5080/meetings/services/networktest
>> <http://aseanenglish.info:5080/meetings/services/networktest>
>> <http://aseanenglish.info:5080/meetings/services/networktest
>> <http://aseanenglish.info:5080/meetings/services/networktest>>
>> Upload speed: error - [IOErrorEvent type="ioError" bubbles=false
>> cancelable=false eventPhase=2 text="Error #2032"]
>>
>>
>>
>>
>> Thanks,
>>
>> Dan
>>
>>
>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2016.0.7797 / Virus Database: 4656/13115 - Release Date: 09/29/16
>
>
>
RE: Connection testing shows errors
Posted by "Coscend@OM" <OM...@Coscend.com>.
Hello Daniel,
When you change ports from its default 5080/1935 to something else, you might want to change it in four places, wherever applicable:
1. Firewall hardware: policy
2. OS firewall: policy
OpenMeetings: 3. config.xml and 4. red5.properties
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:info@collisiondetection.biz]
Sent: Thursday, September 29, 2016 11:58 PM
To: user@openmeetings.apache.org
Subject: Re: Connection testing shows errors
I just changed the port 5080 to 80 in config.xml which caused the network testing to stop working. It looks like it is always searching for port 5080 to do the tests.
When I went back to port 5080 it started working again.
Thanks,
Dan
On 09/30/2016 11:30 AM, Maxim Solodovnik wrote:
> Actually NetworkTesting should read config.xml to be able to check the
> exact ports/paths as OM will use so I would appreciate detailed
> configuration to reprobuce the issue
>
> On Fri, Sep 30, 2016 at 11:27 AM, Daniel Baker
> <info@collisiondetection.biz <ma...@collisiondetection.biz>> wrote:
>
> Yes I changed the config.xml file.
>
>
> Since port forwarding is working ok now I just changed it back to
> 5080. I could see from the error report it was looking for port 5080.
>
>
> So the Connection testing is working as expected now.
>
>
>
> Thanks,
>
> Dan
>
>
>
>
> On 09/29/2016 11:00 PM, Maxim Solodovnik wrote:
>
> have you changed ports in config.xml?
>
> On Thu, Sep 29, 2016 at 9:33 PM, Daniel Baker
> <info@collisiondetection.biz
> <ma...@collisiondetection.biz>
> <mailto:info@collisiondetection.biz
> <ma...@collisiondetection.biz>>> wrote:
>
> Hi,
>
>
> I'm using OpenMeetings Version: 3.1.2 Revision 1756072
>
>
>
> When I perform a test of the ping, jitter,download and
> upload they
> fail.
>
>
> The RTMP port test works ok.
>
>
> Are the ping, jitter,download and upload ports always
> working over
> port 5080.
>
>
> I have changed the default port 5080 to 80. Would this
> make the
> test fail ?
>
>
>
> Here are my logs :
>
>
>
> Ping: start test...
>
> http://aseanenglish.info:5080/meetings/services/networktest?type=ping
> <http://aseanenglish.info:5080/meetings/services/networktest?type=ping>
> <http://aseanenglish.info:5080/meetings/services/networktest?type=ping
> <http://aseanenglish.info:5080/meetings/services/networktest?type=ping>>
> Ping: stopped
> Port: : start test...
> rtmp://aseanenglish.info:1935/meetings/hibernate
> <http://aseanenglish.info:1935/meetings/hibernate>
> <http://aseanenglish.info:1935/meetings/hibernate
> <http://aseanenglish.info:1935/meetings/hibernate>>
> Port: port is available
>
> Jitter: start test...
>
> http://aseanenglish.info:5080/meetings/services/networktest?type=jitter
>
> <http://aseanenglish.info:5080/meetings/services/networktest?type=jitt
> er>
>
> <http://aseanenglish.info:5080/meetings/services/networktest?type=jitter
> <http://aseanenglish.info:5080/meetings/services/networktest?type=jitter>>
> Jitter: stopped
> Download speed: start test...
>
> http://aseanenglish.info:5080/meetings/services/networktest?type=download
>
> <http://aseanenglish.info:5080/meetings/services/networktest?type=down
> load>
>
> <http://aseanenglish.info:5080/meetings/services/networktest?type=download
> <http://aseanenglish.info:5080/meetings/services/networktest?type=download>>
> Download speed: report: connection error
> Upload speed: start test...
> http://aseanenglish.info:5080/meetings/services/networktest
> <http://aseanenglish.info:5080/meetings/services/networktest>
> <http://aseanenglish.info:5080/meetings/services/networktest
> <http://aseanenglish.info:5080/meetings/services/networktest>>
> Upload speed: error - [IOErrorEvent type="ioError" bubbles=false
> cancelable=false eventPhase=2 text="Error #2032"]
>
>
>
>
> Thanks,
>
> Dan
>
>
>
>
>
> --
> WBR
> Maxim aka solomax
>
>
>
>
> --
> WBR
> Maxim aka solomax
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2016.0.7797 / Virus Database: 4656/13115 - Release Date: 09/29/16
Re: Connection testing shows errors
Posted by Daniel Baker <in...@collisiondetection.biz>.
I just changed the port 5080 to 80 in config.xml which caused the
network testing to stop working. It looks like it is always searching
for port 5080 to do the tests.
When I went back to port 5080 it started working again.
Thanks,
Dan
On 09/30/2016 11:30 AM, Maxim Solodovnik wrote:
> Actually NetworkTesting should read config.xml to be able to check the
> exact ports/paths as OM will use
> so I would appreciate detailed configuration to reprobuce the issue
>
> On Fri, Sep 30, 2016 at 11:27 AM, Daniel Baker
> <info@collisiondetection.biz <ma...@collisiondetection.biz>> wrote:
>
> Yes I changed the config.xml file.
>
>
> Since port forwarding is working ok now I just changed it back to
> 5080. I could see from the error report it was looking for port 5080.
>
>
> So the Connection testing is working as expected now.
>
>
>
> Thanks,
>
> Dan
>
>
>
>
> On 09/29/2016 11:00 PM, Maxim Solodovnik wrote:
>
> have you changed ports in config.xml?
>
> On Thu, Sep 29, 2016 at 9:33 PM, Daniel Baker
> <info@collisiondetection.biz
> <ma...@collisiondetection.biz>
> <mailto:info@collisiondetection.biz
> <ma...@collisiondetection.biz>>> wrote:
>
> Hi,
>
>
> I'm using OpenMeetings Version: 3.1.2 Revision 1756072
>
>
>
> When I perform a test of the ping, jitter,download and
> upload they
> fail.
>
>
> The RTMP port test works ok.
>
>
> Are the ping, jitter,download and upload ports always
> working over
> port 5080.
>
>
> I have changed the default port 5080 to 80. Would this
> make the
> test fail ?
>
>
>
> Here are my logs :
>
>
>
> Ping: start test...
>
> http://aseanenglish.info:5080/meetings/services/networktest?type=ping
> <http://aseanenglish.info:5080/meetings/services/networktest?type=ping>
> <http://aseanenglish.info:5080/meetings/services/networktest?type=ping
> <http://aseanenglish.info:5080/meetings/services/networktest?type=ping>>
> Ping: stopped
> Port: : start test...
> rtmp://aseanenglish.info:1935/meetings/hibernate
> <http://aseanenglish.info:1935/meetings/hibernate>
> <http://aseanenglish.info:1935/meetings/hibernate
> <http://aseanenglish.info:1935/meetings/hibernate>>
> Port: port is available
>
> Jitter: start test...
>
> http://aseanenglish.info:5080/meetings/services/networktest?type=jitter
> <http://aseanenglish.info:5080/meetings/services/networktest?type=jitter>
>
> <http://aseanenglish.info:5080/meetings/services/networktest?type=jitter
> <http://aseanenglish.info:5080/meetings/services/networktest?type=jitter>>
> Jitter: stopped
> Download speed: start test...
>
> http://aseanenglish.info:5080/meetings/services/networktest?type=download
> <http://aseanenglish.info:5080/meetings/services/networktest?type=download>
>
> <http://aseanenglish.info:5080/meetings/services/networktest?type=download
> <http://aseanenglish.info:5080/meetings/services/networktest?type=download>>
> Download speed: report: connection error
> Upload speed: start test...
> http://aseanenglish.info:5080/meetings/services/networktest
> <http://aseanenglish.info:5080/meetings/services/networktest>
> <http://aseanenglish.info:5080/meetings/services/networktest
> <http://aseanenglish.info:5080/meetings/services/networktest>>
> Upload speed: error - [IOErrorEvent type="ioError" bubbles=false
> cancelable=false eventPhase=2 text="Error #2032"]
>
>
>
>
> Thanks,
>
> Dan
>
>
>
>
>
> --
> WBR
> Maxim aka solomax
>
>
>
>
> --
> WBR
> Maxim aka solomax
Re: How to host openmeetings for the public
Posted by Maxim Solodovnik <so...@gmail.com>.
Great
Thanks for the feedback
WBR, Maxim
(from mobile, sorry for the typos)
On Sep 29, 2016 17:00, "Daniel Baker" <in...@collisiondetection.biz> wrote:
> It turns out the problem was when port forwarding from the router I had
> to enable TCP/UDP then it worked.
>
>
> There are a couple of other problems but will write those up in another
> thread.
>
>
> Thanks,
>
>
> Dan
>
>
>
> On 09/28/2016 07:48 AM, Maxim Solodovnik wrote:
>
>> In case of option 1 you don't need apache
>> Are you able to
>> telnet yourhost 5080
>> In case of timeout it is firewall issue
>>
>> WBR, Maxim
>> (from mobile, sorry for the typos)
>>
>>
>> On Sep 28, 2016 05:50, "Daniel Baker" <info@collisiondetection.biz
>> <ma...@collisiondetection.biz>> wrote:
>>
>> Hi Maxim,
>>
>> I have implemented option 1 but I still can not access OpenMeetings
>> from the web.
>>
>> Is there any special changes I need to make ? Maybe in Apache ?
>>
>>
>> Thanks,
>>
>> Dan
>>
>>
>>
>>
>>
>> On 09/12/2016 10:38 PM, Maxim Solodovnik wrote:
>>
>> Hello Daniel,
>>
>> you have 2 options:
>> 1) open necessary ports and access your OM as
>> http://your_host:5080/openmeetings
>> <http://your_host:5080/openmeetings> instead of
>> ...localhost:5080...
>> 2) set up front-end apache/nginx and use it as proxy for your OM
>>
>> On Mon, Sep 12, 2016 at 9:17 PM, Daniel Baker
>> <info@collisiondetection.biz
>> <ma...@collisiondetection.biz>> wrote:
>>
>> Hi,
>>
>>
>> I recently set up OpenMeetings 3.1.2 in a Ububtu 16.04
>> Virtual Machine. It
>> works great on my local LAN. Now I would like others on the
>> internet to
>> join my meetings.
>>
>>
>> I have a vague idea how to do this but could someone please
>> detail the
>> steps necessary.
>>
>> I have checked with my ISP and they said they can give me a
>> fixed public IP.
>> I have a domain name ready to use.
>>
>>
>>
>> Thanks for the help.
>>
>> Dan
>>
>>
>>
>>
>>
>>
Re: Connection testing shows errors
Posted by Maxim Solodovnik <so...@gmail.com>.
Actually NetworkTesting should read config.xml to be able to check the
exact ports/paths as OM will use
so I would appreciate detailed configuration to reprobuce the issue
On Fri, Sep 30, 2016 at 11:27 AM, Daniel Baker <in...@collisiondetection.biz>
wrote:
> Yes I changed the config.xml file.
>
>
> Since port forwarding is working ok now I just changed it back to 5080. I
> could see from the error report it was looking for port 5080.
>
>
> So the Connection testing is working as expected now.
>
>
>
> Thanks,
>
> Dan
>
>
>
>
> On 09/29/2016 11:00 PM, Maxim Solodovnik wrote:
>
>> have you changed ports in config.xml?
>>
>> On Thu, Sep 29, 2016 at 9:33 PM, Daniel Baker
>> <info@collisiondetection.biz <ma...@collisiondetection.biz>> wrote:
>>
>> Hi,
>>
>>
>> I'm using OpenMeetings Version: 3.1.2 Revision 1756072
>>
>>
>>
>> When I perform a test of the ping, jitter,download and upload they
>> fail.
>>
>>
>> The RTMP port test works ok.
>>
>>
>> Are the ping, jitter,download and upload ports always working over
>> port 5080.
>>
>>
>> I have changed the default port 5080 to 80. Would this make the
>> test fail ?
>>
>>
>>
>> Here are my logs :
>>
>>
>>
>> Ping: start test...
>> http://aseanenglish.info:5080/meetings/services/networktest?type=ping
>> <http://aseanenglish.info:5080/meetings/services/networktest?type=ping>
>> Ping: stopped
>> Port: : start test...
>> rtmp://aseanenglish.info:1935/meetings/hibernate
>> <http://aseanenglish.info:1935/meetings/hibernate>
>> Port: port is available
>>
>> Jitter: start test...
>> http://aseanenglish.info:5080/meetings/services/networktest?
>> type=jitter
>> <http://aseanenglish.info:5080/meetings/services/networktest
>> ?type=jitter>
>> Jitter: stopped
>> Download speed: start test...
>> http://aseanenglish.info:5080/meetings/services/networktest?
>> type=download
>> <http://aseanenglish.info:5080/meetings/services/networktest
>> ?type=download>
>> Download speed: report: connection error
>> Upload speed: start test...
>> http://aseanenglish.info:5080/meetings/services/networktest
>> <http://aseanenglish.info:5080/meetings/services/networktest>
>> Upload speed: error - [IOErrorEvent type="ioError" bubbles=false
>> cancelable=false eventPhase=2 text="Error #2032"]
>>
>>
>>
>>
>> Thanks,
>>
>> Dan
>>
>>
>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>
--
WBR
Maxim aka solomax
Re: Connection testing shows errors
Posted by Daniel Baker <in...@collisiondetection.biz>.
Yes I changed the config.xml file.
Since port forwarding is working ok now I just changed it back to 5080.
I could see from the error report it was looking for port 5080.
So the Connection testing is working as expected now.
Thanks,
Dan
On 09/29/2016 11:00 PM, Maxim Solodovnik wrote:
> have you changed ports in config.xml?
>
> On Thu, Sep 29, 2016 at 9:33 PM, Daniel Baker
> <info@collisiondetection.biz <ma...@collisiondetection.biz>> wrote:
>
> Hi,
>
>
> I'm using OpenMeetings Version: 3.1.2 Revision 1756072
>
>
>
> When I perform a test of the ping, jitter,download and upload they
> fail.
>
>
> The RTMP port test works ok.
>
>
> Are the ping, jitter,download and upload ports always working over
> port 5080.
>
>
> I have changed the default port 5080 to 80. Would this make the
> test fail ?
>
>
>
> Here are my logs :
>
>
>
> Ping: start test...
> http://aseanenglish.info:5080/meetings/services/networktest?type=ping <http://aseanenglish.info:5080/meetings/services/networktest?type=ping>
> Ping: stopped
> Port: : start test...
> rtmp://aseanenglish.info:1935/meetings/hibernate
> <http://aseanenglish.info:1935/meetings/hibernate>
> Port: port is available
>
> Jitter: start test...
> http://aseanenglish.info:5080/meetings/services/networktest?type=jitter
> <http://aseanenglish.info:5080/meetings/services/networktest?type=jitter>
> Jitter: stopped
> Download speed: start test...
> http://aseanenglish.info:5080/meetings/services/networktest?type=download
> <http://aseanenglish.info:5080/meetings/services/networktest?type=download>
> Download speed: report: connection error
> Upload speed: start test...
> http://aseanenglish.info:5080/meetings/services/networktest
> <http://aseanenglish.info:5080/meetings/services/networktest>
> Upload speed: error - [IOErrorEvent type="ioError" bubbles=false
> cancelable=false eventPhase=2 text="Error #2032"]
>
>
>
>
> Thanks,
>
> Dan
>
>
>
>
>
> --
> WBR
> Maxim aka solomax
Re: Connection testing shows errors
Posted by Maxim Solodovnik <so...@gmail.com>.
have you changed ports in config.xml?
On Thu, Sep 29, 2016 at 9:33 PM, Daniel Baker <in...@collisiondetection.biz>
wrote:
> Hi,
>
>
> I'm using OpenMeetings Version: 3.1.2 Revision 1756072
>
>
>
> When I perform a test of the ping, jitter,download and upload they fail.
>
>
> The RTMP port test works ok.
>
>
> Are the ping, jitter,download and upload ports always working over port
> 5080.
>
>
> I have changed the default port 5080 to 80. Would this make the test
> fail ?
>
>
>
> Here are my logs :
>
>
>
> Ping: start test... http://aseanenglish.info:5080/
> meetings/services/networktest?type=ping
> Ping: stopped
> Port: : start test... rtmp://aseanenglish.info:1935/meetings/hibernate
> Port: port is available
>
> Jitter: start test... http://aseanenglish.info:5080/
> meetings/services/networktest?type=jitter
> Jitter: stopped
> Download speed: start test... http://aseanenglish.info:5080/
> meetings/services/networktest?type=download
> Download speed: report: connection error
> Upload speed: start test... http://aseanenglish.info:5080/
> meetings/services/networktest
> Upload speed: error - [IOErrorEvent type="ioError" bubbles=false
> cancelable=false eventPhase=2 text="Error #2032"]
>
>
>
>
> Thanks,
>
> Dan
>
>
>
--
WBR
Maxim aka solomax
Connection testing shows errors
Posted by Daniel Baker <in...@collisiondetection.biz>.
Hi,
I'm using OpenMeetings Version: 3.1.2 Revision 1756072
When I perform a test of the ping, jitter,download and upload they fail.
The RTMP port test works ok.
Are the ping, jitter,download and upload ports always working over port
5080.
I have changed the default port 5080 to 80. Would this make the test
fail ?
Here are my logs :
Ping: start test...
http://aseanenglish.info:5080/meetings/services/networktest?type=ping
Ping: stopped
Port: : start test... rtmp://aseanenglish.info:1935/meetings/hibernate
Port: port is available
Jitter: start test...
http://aseanenglish.info:5080/meetings/services/networktest?type=jitter
Jitter: stopped
Download speed: start test...
http://aseanenglish.info:5080/meetings/services/networktest?type=download
Download speed: report: connection error
Upload speed: start test...
http://aseanenglish.info:5080/meetings/services/networktest
Upload speed: error - [IOErrorEvent type="ioError" bubbles=false
cancelable=false eventPhase=2 text="Error #2032"]
Thanks,
Dan
Re: How to host openmeetings for the public
Posted by Daniel Baker <in...@collisiondetection.biz>.
It turns out the problem was when port forwarding from the router I had
to enable TCP/UDP then it worked.
There are a couple of other problems but will write those up in
another thread.
Thanks,
Dan
On 09/28/2016 07:48 AM, Maxim Solodovnik wrote:
> In case of option 1 you don't need apache
> Are you able to
> telnet yourhost 5080
> In case of timeout it is firewall issue
>
> WBR, Maxim
> (from mobile, sorry for the typos)
>
>
> On Sep 28, 2016 05:50, "Daniel Baker" <info@collisiondetection.biz
> <ma...@collisiondetection.biz>> wrote:
>
> Hi Maxim,
>
> I have implemented option 1 but I still can not access OpenMeetings
> from the web.
>
> Is there any special changes I need to make ? Maybe in Apache ?
>
>
> Thanks,
>
> Dan
>
>
>
>
>
> On 09/12/2016 10:38 PM, Maxim Solodovnik wrote:
>
> Hello Daniel,
>
> you have 2 options:
> 1) open necessary ports and access your OM as
> http://your_host:5080/openmeetings
> <http://your_host:5080/openmeetings> instead of ...localhost:5080...
> 2) set up front-end apache/nginx and use it as proxy for your OM
>
> On Mon, Sep 12, 2016 at 9:17 PM, Daniel Baker
> <info@collisiondetection.biz
> <ma...@collisiondetection.biz>> wrote:
>
> Hi,
>
>
> I recently set up OpenMeetings 3.1.2 in a Ububtu 16.04
> Virtual Machine. It
> works great on my local LAN. Now I would like others on the
> internet to
> join my meetings.
>
>
> I have a vague idea how to do this but could someone please
> detail the
> steps necessary.
>
> I have checked with my ISP and they said they can give me a
> fixed public IP.
> I have a domain name ready to use.
>
>
>
> Thanks for the help.
>
> Dan
>
>
>
>
>
Re: How to host openmeetings for the public
Posted by Maxim Solodovnik <so...@gmail.com>.
In case of option 1 you don't need apache
Are you able to
telnet yourhost 5080
In case of timeout it is firewall issue
WBR, Maxim
(from mobile, sorry for the typos)
On Sep 28, 2016 05:50, "Daniel Baker" <in...@collisiondetection.biz> wrote:
Hi Maxim,
I have implemented option 1 but I still can not access OpenMeetings from
the web.
Is there any special changes I need to make ? Maybe in Apache ?
Thanks,
Dan
On 09/12/2016 10:38 PM, Maxim Solodovnik wrote:
> Hello Daniel,
>
> you have 2 options:
> 1) open necessary ports and access your OM as
> http://your_host:5080/openmeetings instead of ...localhost:5080...
> 2) set up front-end apache/nginx and use it as proxy for your OM
>
> On Mon, Sep 12, 2016 at 9:17 PM, Daniel Baker
> <in...@collisiondetection.biz> wrote:
>
>> Hi,
>>
>>
>> I recently set up OpenMeetings 3.1.2 in a Ububtu 16.04 Virtual Machine.
>> It
>> works great on my local LAN. Now I would like others on the internet to
>> join my meetings.
>>
>>
>> I have a vague idea how to do this but could someone please detail the
>> steps necessary.
>>
>> I have checked with my ISP and they said they can give me a fixed public
>> IP.
>> I have a domain name ready to use.
>>
>>
>>
>> Thanks for the help.
>>
>> Dan
>>
>
>
>
>
Re: How to host openmeetings for the public
Posted by Daniel Baker <in...@collisiondetection.biz>.
Hi Maxim,
I have implemented option 1 but I still can not access OpenMeetings from
the web.
Is there any special changes I need to make ? Maybe in Apache ?
Thanks,
Dan
On 09/12/2016 10:38 PM, Maxim Solodovnik wrote:
> Hello Daniel,
>
> you have 2 options:
> 1) open necessary ports and access your OM as
> http://your_host:5080/openmeetings instead of ...localhost:5080...
> 2) set up front-end apache/nginx and use it as proxy for your OM
>
> On Mon, Sep 12, 2016 at 9:17 PM, Daniel Baker
> <in...@collisiondetection.biz> wrote:
>> Hi,
>>
>>
>> I recently set up OpenMeetings 3.1.2 in a Ububtu 16.04 Virtual Machine. It
>> works great on my local LAN. Now I would like others on the internet to
>> join my meetings.
>>
>>
>> I have a vague idea how to do this but could someone please detail the
>> steps necessary.
>>
>> I have checked with my ISP and they said they can give me a fixed public IP.
>> I have a domain name ready to use.
>>
>>
>>
>> Thanks for the help.
>>
>> Dan
>
>
>
Re: How to host openmeetings for the public
Posted by Maxim Solodovnik <so...@gmail.com>.
Hello Daniel,
you have 2 options:
1) open necessary ports and access your OM as
http://your_host:5080/openmeetings instead of ...localhost:5080...
2) set up front-end apache/nginx and use it as proxy for your OM
On Mon, Sep 12, 2016 at 9:17 PM, Daniel Baker
<in...@collisiondetection.biz> wrote:
> Hi,
>
>
> I recently set up OpenMeetings 3.1.2 in a Ububtu 16.04 Virtual Machine. It
> works great on my local LAN. Now I would like others on the internet to
> join my meetings.
>
>
> I have a vague idea how to do this but could someone please detail the
> steps necessary.
>
> I have checked with my ISP and they said they can give me a fixed public IP.
> I have a domain name ready to use.
>
>
>
> Thanks for the help.
>
> Dan
--
WBR
Maxim aka solomax
How to host openmeetings for the public
Posted by Daniel Baker <in...@collisiondetection.biz>.
Hi,
I recently set up OpenMeetings 3.1.2 in a Ububtu 16.04 Virtual
Machine. It works great on my local LAN. Now I would like others on the
internet to join my meetings.
I have a vague idea how to do this but could someone please detail the
steps necessary.
I have checked with my ISP and they said they can give me a fixed public
IP. I have a domain name ready to use.
Thanks for the help.
Dan
Re: error installing 3.1.2 on ubuntu
Posted by Maxim Solodovnik <so...@gmail.com>.
Great!
Thanks for the update :)
On Sun, Sep 11, 2016 at 8:13 PM, Daniel Baker
<in...@collisiondetection.biz> 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
>> <in...@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:info@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
>>>>
>>>>
>>>>
>>>
>>
>>
>>
>
--
WBR
Maxim aka solomax
Re: error installing 3.1.2 on ubuntu
Posted by Daniel Baker <in...@collisiondetection.biz>.
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
> <in...@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:info@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
Posted by Maxim Solodovnik <so...@gmail.com>.
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
<in...@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:info@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
>>
>>
>>
>
--
WBR
Maxim aka solomax
Re: error installing 3.1.2 on ubuntu
Posted by Daniel Baker <in...@collisiondetection.biz>.
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:info@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
Posted by "Coscend@OM" <OM...@Coscend.com>.
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:info@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