Unfortunately, I can't check system log files as I'm not root user of the server... :(. I don't understand why the connection is lost when trying to get the smtp conf_key... Is there any paratemeter to take care about on persistence.xml file?
Thanks... On 2 March 2015 at 14:29, Maxim Solodovnik <[email protected]> wrote: > can you check the system log regarding any kernel messages regarding > killing processes etc. ? > > On Mon, Mar 2, 2015 at 7:27 PM, Manu <[email protected]> wrote: > >> 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 >>> >> >> > > > -- > WBR > Maxim aka solomax >
