Hi Maxim: Thanks for your quick reply. Yes, I have installed it after unpacking and I am able to login to OM, manage users, rooms, config etc... I can access db via command-line with no problem too... It is really strange...
Thanks. On 2 March 2015 at 14:10, Maxim Solodovnik <[email protected]> wrote: > What do you mean by "installed OM 3.0.3 and everything seems to work > perfectly" > Were you able to login to OM? Have you installed it after unpacking? > > can you check your values from persistence.xml using command-line mysql > client: > > mysql -u*user* --host *host* -p *database* > (please replace everything in bold with your values from persistence.xml) > > > On Mon, Mar 2, 2015 at 6:53 PM, Manu <[email protected]> wrote: > >> Hi all: >> >> I recentlty installed OM 3.0.3 and everything seems to work perfectly. >> But after starting the application, the logs begins to be populated with >> messages like this one: >> >> *ERROR 03-02 13:32:15.233 o.a.o.d.d.b.ConfigurationDao:144 >> [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-7] - >> cannot be cast to return type, you have misconfigured your configuration >> CONF_KEY: smtp_server* >> *org.apache.openjpa.persistence.PersistenceException: Communications link >> failure* >> >> *The last packet successfully received from the server was 34.928 >> milliseconds ago. The last packet sent successfully to the server was 1 >> milliseconds ago.* >> * at >> org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4974) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at >> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4934) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at >> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at >> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:108) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at >> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:60) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at >> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.connect(JDBCStoreManager.java:968) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at >> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.getConnection(JDBCStoreManager.java:242) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:415) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:393) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at >> org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute(LogicalUnion.java:427) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at >> org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:230) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at >> org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:220) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at >> org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:94) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at >> org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:34) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1251) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1007) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:863) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:794) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at >> org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:542) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:275) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at >> org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:291) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at >> org.apache.openmeetings.db.dao.basic.ConfigurationDao.get(ConfigurationDao.java:99) >> ~[openmeetings-db-3.0.3-RELEASE.jar:na]* >> * at >> org.apache.openmeetings.db.dao.basic.ConfigurationDao.getConfValue(ConfigurationDao.java:120) >> ~[openmeetings-db-3.0.3-RELEASE.jar:na]* >> * at >> org.apache.openmeetings.db.dao.basic.ConfigurationDao$$FastClassBySpringCGLIB$$2f9526f2.invoke(<generated>) >> [spring-core-4.0.6.RELEASE.jar:na]* >> * at >> org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) >> [spring-core-4.0.6.RELEASE.jar:4.0.6.RELEASE]* >> * at >> org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:708) >> [spring-aop-4.0.6.RELEASE.jar:4.0.6.RELEASE]* >> * at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) >> [spring-aop-4.0.6.RELEASE.jar:4.0.6.RELEASE]* >> * at >> org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98) >> [spring-tx-jar-4.0.6.RELEASE.jar:4.0.6.RELEASE]* >> * at >> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262) >> [spring-tx-jar-4.0.6.RELEASE.jar:4.0.6.RELEASE]* >> * at >> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95) >> [spring-tx-jar-4.0.6.RELEASE.jar:4.0.6.RELEASE]* >> * at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) >> [spring-aop-4.0.6.RELEASE.jar:4.0.6.RELEASE]* >> * at >> org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:644) >> [spring-aop-4.0.6.RELEASE.jar:4.0.6.RELEASE]* >> * at >> org.apache.openmeetings.db.dao.basic.ConfigurationDao$$EnhancerBySpringCGLIB$$a14e5412.getConfValue(<generated>) >> [spring-core-4.0.6.RELEASE.jar:na]* >> * at org.apache.openmeetings.mail.MailHandler.init(MailHandler.java:88) >> [openmeetings-core-3.0.3-RELEASE.jar:na]* >> * at >> org.apache.openmeetings.mail.MailHandler.sendMails(MailHandler.java:257) >> [openmeetings-core-3.0.3-RELEASE.jar:na]* >> * at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> ~[na:1.7.0_13]* >> * at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >> ~[na:1.7.0_13]* >> * at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> ~[na:1.7.0_13]* >> * at java.lang.reflect.Method.invoke(Method.java:601) ~[na:1.7.0_13]* >> * at >> org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:269) >> [spring-core-4.0.6.RELEASE.jar:4.0.6.RELEASE]* >> * at >> org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:322) >> [spring-context-support-4.0.6.RELEASE.jar:4.0.6.RELEASE]* >> * at >> org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:112) >> [spring-context-support-4.0.6.RELEASE.jar:4.0.6.RELEASE]* >> * at org.quartz.core.JobRunShell.run(JobRunShell.java:213) >> [quartz-2.1.7.jar:na]* >> * at >> org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557) >> [quartz-2.1.7.jar:na]* >> *Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: >> Communications link failure* >> >> *The last packet successfully received from the server was 34.928 >> milliseconds ago. The last packet sent successfully to the server was 1 >> milliseconds ago.* >> * at sun.reflect.GeneratedConstructorAccessor58.newInstance(Unknown >> Source) ~[na:na]* >> * at >> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) >> ~[na:1.7.0_13]* >> * at java.lang.reflect.Constructor.newInstance(Constructor.java:525) >> ~[na:1.7.0_13]* >> * at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) >> ~[mysql-connector-java.jar:na]* >> * at >> com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116) >> ~[mysql-connector-java.jar:na]* >> * at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090) >> ~[mysql-connector-java.jar:na]* >> * at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979) >> ~[mysql-connector-java.jar:na]* >> * at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520) >> ~[mysql-connector-java.jar:na]* >> * at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990) >> ~[mysql-connector-java.jar:na]* >> * at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151) >> ~[mysql-connector-java.jar:na]* >> * at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619) >> ~[mysql-connector-java.jar:na]* >> * at >> com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4997) >> ~[mysql-connector-java.jar:na]* >> * at >> org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:371) >> ~[commons-dbcp-jar-1.4.jar:1.4]* >> * at >> org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:371) >> ~[commons-dbcp-jar-1.4.jar:1.4]* >> * at >> org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:328) >> ~[commons-dbcp-jar-1.4.jar:1.4]* >> * at >> org.apache.openjpa.lib.jdbc.DelegatingConnection.setAutoCommit(DelegatingConnection.java:167) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at >> org.apache.openjpa.lib.jdbc.DelegatingConnection.setAutoCommit(DelegatingConnection.java:167) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at >> org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.setAutoCommit(ConfiguringConnectionDecorator.java:117) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at >> org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.<init>(ConfiguringConnectionDecorator.java:111) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at >> org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator.decorate(ConfiguringConnectionDecorator.java:93) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at >> org.apache.openjpa.lib.jdbc.DecoratingDataSource.decorate(DecoratingDataSource.java:99) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at >> org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:88) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at >> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.connectInternal(JDBCStoreManager.java:979) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * at >> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.connect(JDBCStoreManager.java:964) >> ~[openjpa-bundle-2.3.0.jar:2.3.0]* >> * ... 38 common frames omitted* >> *Caused by: java.io.EOFException: Can not read response from server. >> Expected to read 4 bytes, read 0 bytes before connection was unexpectedly >> lost.* >> * at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2540) >> ~[mysql-connector-java.jar:na]* >> * at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990) >> ~[mysql-connector-java.jar:na]* >> >> >> After a couple of hours later, OM can't get a connection from the >> database and the application remains out of service until I reboot it... It >> should not be a problem of too many database connections as it is a testing >> installation with hardly no users yet... >> >> Thank's and regards. >> >> >> > > > -- > WBR > Maxim aka solomax >
