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
