I deleteded ./openmeetings database, and no get some configuration key crypt_ClassName problems. It seems like a step further.
-- With best regards / с наилучшими пожеланиями, Alexei Fedotov / Алексей Федотов, http://dataved.ru/ +7 916 562 8095 On Mon, Dec 17, 2012 at 1:18 AM, Alexei Fedotov <[email protected]> wrote: > I'm getting the following (derby_persistence.xml is used): > > org.springframework.transaction.CannotCreateTransactionException: > Could not open JPA EntityManager for transaction; nested exception is > <openjpa-2.2.1-r422266:1396819 nonfatal general error> > org.apache.openjpa.persistence.PersistenceException: ALTER TABLE > statement cannot add an IDENTITY column to a table. {stmnt 1208085072 > ALTER TABLE adresses ADD id BIGINT GENERATED BY DEFAULT AS IDENTITY} > [code=30000, state=42601] > at > org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransact > ionManager.java:427) > ~[org.springframework.orm-jar-3.1.1.RELEASE.jar:3.1.1.RELEA > SE] > at > org.springframework.transaction.support.AbstractPlatformTransactionMa > nager.getTransaction(AbstractPlatformTransactionManager.java:371) > ~[org.springfr > amework.transaction-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE] > > No successful interaction with a database is performed. > > -- > With best regards / с наилучшими пожеланиями, > Alexei Fedotov / Алексей Федотов, > http://dataved.ru/ > +7 916 562 8095 > > > On Mon, Dec 10, 2012 at 7:24 PM, Mikael Kurula <[email protected]> wrote: >> Thanks, Solomax! I'm very grateful for your speedy and constant help! I >> created an issue in JIRA about the MySQL timeouts. >> >> I now tried switching back to Derby by renaming derby_persistence to >> persistence and restarting the OM server. Fine. Then I tried connecting with >> the web browser and I got the attached error message. In the log I got the >> curses below. >> >> Friendly greetings, >> Mikael >> >> >> >> >> >> >> WARN 12-10 17:19:02.610 Configurationmanagement.java 94426 104 >> org.openmeetings.app.data.basic.Configurationmanagement >> [http-0.0.0.0-5080-1] - Could not find key in configuration CONF_KEY: >> application.name >> DEBUG 12-10 17:19:13.241 ScopeApplicationAdapter.java 105057 181 >> org.openmeetings.app.remote.red5.ScopeApplicationAdapter [NioProcessor-2] - >> roomConnect : >> DEBUG 12-10 17:19:13.241 ScopeApplicationAdapter.java 105057 193 >> org.openmeetings.app.remote.red5.ScopeApplicationAdapter [NioProcessor-2] - >> ### Client connected to OpenMeetings, register Client StreamId: 0 scope >> hibernate isAVClient false >> DEBUG 12-10 17:19:13.242 ScopeApplicationAdapter.java 105058 195 >> org.openmeetings.app.remote.red5.ScopeApplicationAdapter [NioProcessor-2] - >> params [Ljava.lang.Object;@7aee513 >> DEBUG 12-10 17:19:13.245 ManageCryptStyle.java 105061 41 >> org.openmeetings.utils.crypt.ManageCryptStyle [NioProcessor-2] - >> getInstanceOfCrypt: org.openmeetings.utils.crypt.ManageCryptStyle@6a5d5a2c >> DEBUG 12-10 17:19:13.247 ManageCryptStyle.java 105063 43 >> org.openmeetings.utils.crypt.ManageCryptStyle [NioProcessor-2] - >> getInstanceOfCrypt: >> org.openmeetings.app.data.basic.Configurationmanagement@77158bbe >> DEBUG 12-10 17:19:13.249 ManageCryptStyle.java 105065 50 >> org.openmeetings.utils.crypt.ManageCryptStyle [NioProcessor-2] - >> configKeyCryptClassName: null >> ERROR 12-10 17:19:13.253 ManageCryptStyle.java 105069 58 >> org.openmeetings.utils.crypt.ManageCryptStyle [NioProcessor-2] - >> [getInstanceOfCrypt] >> java.lang.NullPointerException: null >> at java.lang.Class.forName0(Native Method) ~[na:1.6.0_37] >> at java.lang.Class.forName(Unknown Source) ~[na:1.6.0_37] >> at >> org.openmeetings.utils.crypt.ManageCryptStyle.getInstanceOfCrypt(ManageCryptStyle.java:52) >> ~[openmeetings-2.0.0-RELEASE.jar:na] >> at >> org.openmeetings.app.remote.red5.ClientListManager.addClientListItem(ClientListManager.java:88) >> [openmeetings-2.0.0-RELEASE.jar:na] >> at >> org.openmeetings.app.remote.red5.ScopeApplicationAdapter.roomConnect(ScopeApplicationAdapter.java:205) >> [openmeetings-2.0.0-RELEASE.jar:na] >> at >> org.red5.server.adapter.MultiThreadedApplicationAdapter.connect(MultiThreadedApplicationAdapter.java:326) >> [red5.jar:na] >> at >> org.red5.server.adapter.ApplicationAdapter.connect(ApplicationAdapter.java:42) >> [red5.jar:na] >> at org.red5.server.scope.Scope.connect(Scope.java:256) [red5.jar:na] >> at org.red5.server.BaseConnection.connect(BaseConnection.java:326) >> [red5.jar:na] >> at >> org.red5.server.net.rtmp.RTMPConnection.connect(RTMPConnection.java:278) >> [red5.jar:na] >> at >> org.red5.server.net.rtmp.RTMPMinaConnection.connect(RTMPMinaConnection.java:87) >> [red5.jar:na] >> at >> org.red5.server.net.rtmp.RTMPHandler.onInvoke(RTMPHandler.java:268) >> [red5.jar:na] >> at >> org.red5.server.net.rtmp.BaseRTMPHandler.messageReceived(BaseRTMPHandler.java:130) >> [red5.jar:na] >> at >> org.red5.server.net.rtmp.RTMPMinaIoHandler.messageReceived(RTMPMinaIoHandler.java:164) >> [red5.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:716) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.java:427) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:245) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796) >> [mina-core-2.0.4.jar:na] >> at >> org.red5.server.net.rtmpe.RTMPEIoFilter.messageReceived(RTMPEIoFilter.java:124) >> [red5.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapter.java:119) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:426) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:715) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:668) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:657) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.polling.AbstractPollingIoProcessor.access$600(AbstractPollingIoProcessor.java:68) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(AbstractPollingIoProcessor.java:1141) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:64) >> [mina-core-2.0.4.jar:na] >> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown >> Source) [na:1.6.0_37] >> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown >> Source) [na:1.6.0_37] >> at java.lang.Thread.run(Unknown Source) [na:1.6.0_37] >> ERROR 12-10 17:19:13.254 ClientListManager.java 105070 109 >> org.openmeetings.app.remote.red5.ClientListManager [NioProcessor-2] - >> [addClientListItem] >> java.lang.NullPointerException: null >> at >> org.openmeetings.app.remote.red5.ClientListManager.addClientListItem(ClientListManager.java:88) >> ~[openmeetings-2.0.0-RELEASE.jar:na] >> at >> org.openmeetings.app.remote.red5.ScopeApplicationAdapter.roomConnect(ScopeApplicationAdapter.java:205) >> [openmeetings-2.0.0-RELEASE.jar:na] >> at >> org.red5.server.adapter.MultiThreadedApplicationAdapter.connect(MultiThreadedApplicationAdapter.java:326) >> [red5.jar:na] >> at >> org.red5.server.adapter.ApplicationAdapter.connect(ApplicationAdapter.java:42) >> [red5.jar:na] >> at org.red5.server.scope.Scope.connect(Scope.java:256) [red5.jar:na] >> at org.red5.server.BaseConnection.connect(BaseConnection.java:326) >> [red5.jar:na] >> at >> org.red5.server.net.rtmp.RTMPConnection.connect(RTMPConnection.java:278) >> [red5.jar:na] >> at >> org.red5.server.net.rtmp.RTMPMinaConnection.connect(RTMPMinaConnection.java:87) >> [red5.jar:na] >> at >> org.red5.server.net.rtmp.RTMPHandler.onInvoke(RTMPHandler.java:268) >> [red5.jar:na] >> at >> org.red5.server.net.rtmp.BaseRTMPHandler.messageReceived(BaseRTMPHandler.java:130) >> [red5.jar:na] >> at >> org.red5.server.net.rtmp.RTMPMinaIoHandler.messageReceived(RTMPMinaIoHandler.java:164) >> [red5.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:716) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.java:427) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:245) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796) >> [mina-core-2.0.4.jar:na] >> at >> org.red5.server.net.rtmpe.RTMPEIoFilter.messageReceived(RTMPEIoFilter.java:124) >> [red5.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapter.java:119) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:426) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:715) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:668) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:657) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.polling.AbstractPollingIoProcessor.access$600(AbstractPollingIoProcessor.java:68) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(AbstractPollingIoProcessor.java:1141) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:64) >> [mina-core-2.0.4.jar:na] >> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown >> Source) [na:1.6.0_37] >> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown >> Source) [na:1.6.0_37] >> at java.lang.Thread.run(Unknown Source) [na:1.6.0_37] >> ERROR 12-10 17:19:13.256 ScopeApplicationAdapter.java 105072 217 >> org.openmeetings.app.remote.red5.ScopeApplicationAdapter [NioProcessor-2] - >> roomJoin >> java.lang.NullPointerException: null >> at >> org.openmeetings.app.remote.red5.ScopeApplicationAdapter.roomConnect(ScopeApplicationAdapter.java:210) >> ~[na:na] >> at >> org.red5.server.adapter.MultiThreadedApplicationAdapter.connect(MultiThreadedApplicationAdapter.java:326) >> [red5.jar:na] >> at >> org.red5.server.adapter.ApplicationAdapter.connect(ApplicationAdapter.java:42) >> [red5.jar:na] >> at org.red5.server.scope.Scope.connect(Scope.java:256) [red5.jar:na] >> at org.red5.server.BaseConnection.connect(BaseConnection.java:326) >> [red5.jar:na] >> at >> org.red5.server.net.rtmp.RTMPConnection.connect(RTMPConnection.java:278) >> [red5.jar:na] >> at >> org.red5.server.net.rtmp.RTMPMinaConnection.connect(RTMPMinaConnection.java:87) >> [red5.jar:na] >> at >> org.red5.server.net.rtmp.RTMPHandler.onInvoke(RTMPHandler.java:268) >> [red5.jar:na] >> at >> org.red5.server.net.rtmp.BaseRTMPHandler.messageReceived(BaseRTMPHandler.java:130) >> [red5.jar:na] >> at >> org.red5.server.net.rtmp.RTMPMinaIoHandler.messageReceived(RTMPMinaIoHandler.java:164) >> [red5.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:716) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.java:427) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:245) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796) >> [mina-core-2.0.4.jar:na] >> at >> org.red5.server.net.rtmpe.RTMPEIoFilter.messageReceived(RTMPEIoFilter.java:124) >> [red5.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapter.java:119) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:426) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:715) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:668) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:657) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.polling.AbstractPollingIoProcessor.access$600(AbstractPollingIoProcessor.java:68) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(AbstractPollingIoProcessor.java:1141) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:64) >> [mina-core-2.0.4.jar:na] >> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown >> Source) [na:1.6.0_37] >> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown >> Source) [na:1.6.0_37] >> at java.lang.Thread.run(Unknown Source) [na:1.6.0_37] >> DEBUG 12-10 17:19:13.335 Sessionmanagement.java 105151 73 >> org.openmeetings.app.data.basic.Sessionmanagement [NioProcessor-2] - >> startsession :: startsession >> DEBUG 12-10 17:19:13.335 ManageCryptStyle.java 105151 41 >> org.openmeetings.utils.crypt.ManageCryptStyle [NioProcessor-2] - >> getInstanceOfCrypt: org.openmeetings.utils.crypt.ManageCryptStyle@6a5d5a2c >> DEBUG 12-10 17:19:13.336 ManageCryptStyle.java 105152 43 >> org.openmeetings.utils.crypt.ManageCryptStyle [NioProcessor-2] - >> getInstanceOfCrypt: >> org.openmeetings.app.data.basic.Configurationmanagement@77158bbe >> DEBUG 12-10 17:19:13.336 ManageCryptStyle.java 105152 50 >> org.openmeetings.utils.crypt.ManageCryptStyle [NioProcessor-2] - >> configKeyCryptClassName: null >> ERROR 12-10 17:19:13.337 ManageCryptStyle.java 105153 58 >> org.openmeetings.utils.crypt.ManageCryptStyle [NioProcessor-2] - >> [getInstanceOfCrypt] >> java.lang.NullPointerException: null >> at java.lang.Class.forName0(Native Method) ~[na:1.6.0_37] >> at java.lang.Class.forName(Unknown Source) ~[na:1.6.0_37] >> at >> org.openmeetings.utils.crypt.ManageCryptStyle.getInstanceOfCrypt(ManageCryptStyle.java:52) >> ~[openmeetings-2.0.0-RELEASE.jar:na] >> at >> org.openmeetings.app.data.basic.Sessionmanagement.startsession(Sessionmanagement.java:77) >> [openmeetings-2.0.0-RELEASE.jar:na] >> at >> org.openmeetings.app.data.basic.Sessionmanagement$$FastClassByCGLIB$$3de5b4e4.invoke(<generated>) >> [cglib-jar-2.2.2.jar:na] >> at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) >> [cglib-jar-2.2.2.jar:na] >> at >> org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689) >> [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) >> [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] >> at >> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) >> [org.springframework.transaction-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE] >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) >> [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] >> at >> org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622) >> [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] >> at >> org.openmeetings.app.data.basic.Sessionmanagement$$EnhancerByCGLIB$$b669a81.startsession(<generated>) >> [cglib-jar-2.2.2.jar:na] >> at >> org.openmeetings.app.remote.MainService.getsessiondata(MainService.java:205) >> [openmeetings-2.0.0-RELEASE.jar:na] >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> ~[na:1.6.0_37] >> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) >> ~[na:1.6.0_37] >> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) >> ~[na:1.6.0_37] >> at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.6.0_37] >> at >> org.red5.server.service.ServiceInvoker.invoke(ServiceInvoker.java:196) >> [red5.jar:na] >> at >> org.red5.server.service.ServiceInvoker.invoke(ServiceInvoker.java:115) >> [red5.jar:na] >> at >> org.red5.server.net.rtmp.RTMPHandler.invokeCall(RTMPHandler.java:157) >> [red5.jar:na] >> at >> org.red5.server.net.rtmp.RTMPHandler.onInvoke(RTMPHandler.java:399) >> [red5.jar:na] >> at >> org.red5.server.net.rtmp.BaseRTMPHandler.messageReceived(BaseRTMPHandler.java:130) >> [red5.jar:na] >> at >> org.red5.server.net.rtmp.RTMPMinaIoHandler.messageReceived(RTMPMinaIoHandler.java:164) >> [red5.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:716) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.java:427) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:245) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796) >> [mina-core-2.0.4.jar:na] >> at >> org.red5.server.net.rtmpe.RTMPEIoFilter.messageReceived(RTMPEIoFilter.java:124) >> [red5.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapter.java:119) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:426) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:715) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:668) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:657) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.polling.AbstractPollingIoProcessor.access$600(AbstractPollingIoProcessor.java:68) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(AbstractPollingIoProcessor.java:1141) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:64) >> [mina-core-2.0.4.jar:na] >> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown >> Source) [na:1.6.0_37] >> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown >> Source) [na:1.6.0_37] >> at java.lang.Thread.run(Unknown Source) [na:1.6.0_37] >> ERROR 12-10 17:19:13.339 Sessionmanagement.java 105155 87 >> org.openmeetings.app.data.basic.Sessionmanagement [NioProcessor-2] - >> [startsession]: >> java.lang.NullPointerException: null >> at >> org.openmeetings.app.data.basic.Sessionmanagement.startsession(Sessionmanagement.java:77) >> ~[openmeetings-2.0.0-RELEASE.jar:na] >> at >> org.openmeetings.app.data.basic.Sessionmanagement$$FastClassByCGLIB$$3de5b4e4.invoke(<generated>) >> [cglib-jar-2.2.2.jar:na] >> at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) >> [cglib-jar-2.2.2.jar:na] >> at >> org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689) >> [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) >> [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] >> at >> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) >> [org.springframework.transaction-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE] >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) >> [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] >> at >> org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622) >> [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] >> at >> org.openmeetings.app.data.basic.Sessionmanagement$$EnhancerByCGLIB$$b669a81.startsession(<generated>) >> [cglib-jar-2.2.2.jar:na] >> at >> org.openmeetings.app.remote.MainService.getsessiondata(MainService.java:205) >> [openmeetings-2.0.0-RELEASE.jar:na] >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> ~[na:1.6.0_37] >> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) >> ~[na:1.6.0_37] >> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) >> ~[na:1.6.0_37] >> at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.6.0_37] >> at >> org.red5.server.service.ServiceInvoker.invoke(ServiceInvoker.java:196) >> [red5.jar:na] >> at >> org.red5.server.service.ServiceInvoker.invoke(ServiceInvoker.java:115) >> [red5.jar:na] >> at >> org.red5.server.net.rtmp.RTMPHandler.invokeCall(RTMPHandler.java:157) >> [red5.jar:na] >> at >> org.red5.server.net.rtmp.RTMPHandler.onInvoke(RTMPHandler.java:399) >> [red5.jar:na] >> at >> org.red5.server.net.rtmp.BaseRTMPHandler.messageReceived(BaseRTMPHandler.java:130) >> [red5.jar:na] >> at >> org.red5.server.net.rtmp.RTMPMinaIoHandler.messageReceived(RTMPMinaIoHandler.java:164) >> [red5.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:716) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.java:427) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:245) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796) >> [mina-core-2.0.4.jar:na] >> at >> org.red5.server.net.rtmpe.RTMPEIoFilter.messageReceived(RTMPEIoFilter.java:124) >> [red5.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapter.java:119) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:426) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:715) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:668) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:657) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.polling.AbstractPollingIoProcessor.access$600(AbstractPollingIoProcessor.java:68) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(AbstractPollingIoProcessor.java:1141) >> [mina-core-2.0.4.jar:na] >> at >> org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:64) >> [mina-core-2.0.4.jar:na] >> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown >> Source) [na:1.6.0_37] >> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown >> Source) [na:1.6.0_37] >> at java.lang.Thread.run(Unknown Source) [na:1.6.0_37] >> DEBUG 12-10 17:19:13.517 ClientListManager.java 105333 121 >> org.openmeetings.app.remote.red5.ClientListManager [NioProcessor-2] - Tried >> to get a non existing Client 0 >> DEBUG 12-10 17:19:14.399 ScopeApplicationAdapter.java 106215 519 >> org.openmeetings.app.remote.red5.ScopeApplicationAdapter [NioProcessor-2] - >> roomLeave 0 0 /openmeetings/hibernate hibernate >> DEBUG 12-10 17:19:14.400 ClientListManager.java 106216 121 >> org.openmeetings.app.remote.red5.ClientListManager [NioProcessor-2] - Tried >> to get a non existing Client 0 >> DEBUG 12-10 17:19:26.687 MeetingReminderJob.java 118503 34 >> org.openmeetings.app.quartz.scheduler.MeetingReminderJob >> [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-3] - >> MeetingReminderJob.execute >> WARN 12-10 17:19:26.688 Configurationmanagement.java 118504 104 >> org.openmeetings.app.data.basic.Configurationmanagement >> [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-3] - >> Could not find key in configuration CONF_KEY: number.minutes.reminder.send >> DEBUG 12-10 17:19:26.690 AppointmentDaoImpl.java 118506 931 >> org.openmeetings.app.data.calendar.daos.AppointmentDaoImpl >> [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-3] - >> startStamp 2012-12-10 17:19:26.689 >> DEBUG 12-10 17:19:26.690 AppointmentDaoImpl.java 118506 932 >> org.openmeetings.app.data.calendar.daos.AppointmentDaoImpl >> [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-3] - >> stopStamp 2012-12-10 17:34:26.689 >> DEBUG 12-10 17:19:26.694 AppointmentLogic.java 118510 408 >> org.openmeetings.app.data.calendar.management.AppointmentLogic >> [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-3] - >> doScheduledMeetingReminder : no Appointments in range >> >> >> >> >> >> >> On 2012.10.12, at 15:31, Maxim Solodovnik wrote: >> >>> Hello Mikael, >>> >>> I can point to the 2 MySQL advantages: >>> 1 it performs faster >>> 2 you can query it while OM is running :) >>> >>> If you don't like MySQL you can use postgres or oracle, or write >>> persistence.xml to the DB of your choice :) >>> >>> I never saw timeout issues with MySQL. But feel free to file JIRA issue if >>> you feel you found a bug :) >>> >>> On Dec 10, 2012 7:57 PM, "Mikael Kurula" <[email protected]> wrote: >>> Hi again! >>> >>> Now I had no problems with recordings and mysql timeouts, even if I don't >>> think the OM server has been used for days. >>> >>> Anyway, since poor reliability was the only reason for me to switch away >>> from the previous web conference software I was using, I'm not happy with >>> the prospect of losing OM-recordings because of mysql timeouts. Therefore I >>> now ask: why is mysql recommended? What are the drawbacks of using the >>> default derby persistence? >>> >>> Another question: I find it a bit difficult to follow the discussions here >>> in the mailing list. Besides, this seems to be a clear bug, not an issue >>> about how to use OM. Should I file a bug report in the issue tracker? Also, >>> after some testing I might have a few other bugs and feature requests to >>> report. >>> >>> Friendly greetings, >>> Mikael >>> >>> >>> On 2012.4.12, at 10:44, Mikael Kurula wrote: >>> >>> > That's unfortunate... If it's of any help, then I'm using a CentOS 6 >>> > server with the following version of mysql: >>> > >>> > mysql Ver 14.14 Distrib 5.1.66, for redhat-linux-gnu (x86_64) using >>> > readline 5.1 >>> > >>> > My version of openmeetings is this: >>> > apache-openmeetings-incubating-2.0.0.r1361497-14-07-2012_1108.tar.gz >>> > >>> > and the version of the J connector is mysql-connector-java-5.1.22.tar.gz >>> > >>> > Mikael >>> > >>> > >>> > On 4 December 2012 10:16, Maxim Solodovnik <[email protected]> wrote: >>> > We are using OpenJPA (not Hibernate) >>> > and already have "TestOnBorrow=true" and DB connection pool :( >>> > not sure what else can be done ... Never saw such exception on my >>> > machines :( >>> > >>> > >>> > On Tue, Dec 4, 2012 at 3:03 PM, Mikael Kurula <[email protected]> wrote: >>> > Good morning! >>> > >>> > Very nice to see that this issue generates interest. By googling I found >>> > these discussions: >>> > >>> > http://wiki.pentaho.com/display/ServerDoc2x/Configuring+for+MySQL >>> > http://www.coderanch.com/t/564390/Tomcat/CommunicationsException-tomcat-mysql >>> > >>> > I would assume this is the problem. Can the solution outlined in the >>> > first link solve the problem for OM as well? >>> > >>> > Friendly greetings, >>> > Mikael >>> > >>> > >>> > >>> > On 3 December 2012 20:08, Mahmut TEKER <[email protected]> wrote: >>> > Hi, >>> > >>> > There is a connection between this error (or info) and recording and >>> > sharing of the OM (or I guess like that). I have the same problem on >>> > recordings and I am taking same response about com.mysql.jdbc... kind of >>> > reports from the system. I have also checked that "autoReconnect=true" >>> > option is already given on the connection string and also checked the >>> > permission or the connection of mysql server but could not find a proper >>> > solution. Is there a bit more specific information about error message? >>> > >>> > Thanks, >>> > >>> > _Mahmut >>> > >>> > >>> > On 12/3/2012 2:25 PM, Mikael Kurula wrote: >>> > Hi again! >>> > >>> > >>> > Today I have another question. As I understand, it is recommended to >>> > integrate OpenMeetings with MySQL. This I did, but it seems I run into >>> > problems with MySQL timeouts because of inactivity overnight, getting the >>> > following error message in the openmeetings.log: >>> > >>> > Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The >>> > last packet successfully received from the server was 90,881,924 >>> > milliseconds ago. The last packet sent successfully to the server was >>> > 90,881,924 milliseconds ago. is longer than the server configured value >>> > of 'wait_timeout'. You should consider either expiring and/or testing >>> > connection validity before use in your application, increasing the server >>> > configured values for client timeouts, or using the Connector/J >>> > connection property 'autoReconnect=true' to avoid this problem. >>> > >>> > I found rather conflicting information on the appropriateness of setting >>> > autoReconnect=true when I googled. What is the recommended way of dealing >>> > with this in OpenMeetings? >>> > >>> > >>> > I don't know if it is related or not, but these errors showed up when I >>> > finished a test recording. Then when I tried to go and watch the >>> > recording, I only get "The recording is not yet ready for watching" and >>> > it seems the recording didn't consume any disk space. >>> > >>> > >>> > Id' be most grateful for any help! >>> > >>> > Mikael >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > -- >>> > WBR >>> > Maxim aka solomax >>> > >>> >> >>
