Maybe you have another server with mysql and can specify it as DB? On Mon, Mar 2, 2015 at 8:55 PM, Manu <[email protected]> wrote:
> 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 >> > > -- WBR Maxim aka solomax
