iceScrum Forums Discutez d'iceScrum
- Ce sujet contient 3 réponses, 2 participants et a été mis à jour pour la dernière fois par Nicolas Noullet, le il y a 8 années et 3 mois.
-
AuteurMessages
-
14/09/2016 à 4:29 #35496
bpoulainParticipantHi,
I am using ICESCRUM R6.14.11 with Tomcat 7.0.68 and MySQL 5.7.12.
When Tomcat start, icescrum.log contains:
2016-09-14 14:17:24,164 [localhost-startStop-1] INFO grails.spring.BeanBuilder - [RuntimeConfiguration] Configuring data source for environment: PRODUCTION 2016-09-14 14:17:24,623 [localhost-startStop-1] DEBUG org.icescrum.core.support.ApplicationSupport - Retrieving appID... 2016-09-14 14:17:24,633 [localhost-startStop-1] DEBUG org.icescrum.core.support.ApplicationSupport - Retrieved appID: 1688339a-3eac-2fab-b215-40919f1ef914 2016-09-14 14:17:27,526 [localhost-startStop-1] ERROR org.springframework.web.context.ContextLoader - Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'messageSource': Initialization of bean failed; nested exception is org.springframework.beans.fact ory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exc eption is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Cannot resolve reference to bean 'hibernateProperties' while setting b ean property 'hibernateProperties'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateProperties': Cannot resolve refe rence to bean 'dialectDetector' while setting bean property 'properties' with key [hibernate.dialect]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialectDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Error while extracting Databa seMetaData; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean 'sessionFactory' while setting b ean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Cannot resolve reference to b ean 'hibernateProperties' while setting bean property 'hibernateProperties'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ' hibernateProperties': Cannot resolve reference to bean 'dialectDetector' while setting bean property 'properties' with key [hibernate.dialect]; nested exception is org.springframework.b eans.factory.BeanCreationException: Error creating bean with name 'dialectDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAcces sException: Error while extracting DatabaseMetaData; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. ... 5 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Cannot resolve reference to bean 'hibernateProperties' while setting bean property 'hibernateProperties'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateProperties': Cannot resolve ref erence to bean 'dialectDetector' while setting bean property 'properties' with key [hibernate.dialect]; nested exception is org.springframework.beans.factory.BeanCreationException: Erro r creating bean with name 'dialectDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Error while extracting Datab aseMetaData; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. ... 5 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateProperties': Cannot resolve reference to bean 'dialectDetector' while setting bean property 'properties' with key [hibernate.dialect]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialectDetector': I nvocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is com.mysql.jdb c.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. ... 5 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialectDetector': Invocation of init method failed; nested exception is org.springfram ework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link fai lure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. ... 5 more Caused by: org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException : Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. ... 5 more Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:983) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:339) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2252) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2285) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2084) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:795) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44) at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:327) at com.sun.proxy.$Proxy23.getMetaData(Unknown Source) ... 5 more Caused by: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:579) at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:214) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:298) ... 14 more
MySQL DB and JDBC string (login/password) are OK.
Can you help me ?
Thank you.
14/09/2016 à 5:08 #35502
Nicolas NoulletMaître des clésHi,
This really looks like the DB URL is wrong or not accessible from the iceScrum server:
The driver has not received any packets from the server.
Do you use the setup GUI or the config.groovy file? What URL did you enter?
14/09/2016 à 5:09 #35504
bpoulainParticipantHi,
I use config.groovy:
icescrum.alerts.subject_prefix="[icescrum] " dataSource.password="xxxx" icescrum.baseDir="/root/icescrum" grails.mail.host="mail.abc.fr" dataSource.driverClassName="com.mysql.jdbc.Driver" icescrum.alerts.default.from="icescrum@abc.fr" dataSource.username="root" icescrum.login.retrieve.enable=true icescrum.project.import.enable=true icescrum.log.dir="/root/logs/" icescrum.alerts.enable=true grails.mail.username="icescrum@bc.fr" icescrum.gravatar.enable=false icescrum.project.private.default=false icescrum.project.creation.enable=true icescrum.project.private.enable=true icescrum.invitation.enable=true icescrum.debug.enable=true grails.mail.password="yyyy" dataSource.url="jdbc:mysql://icescrum-mysql:3306/icescrum?useUnicode=true&characterEncoding=utf8" icescrum.project.export.enable=true grails.mail.port="25" icescrum.registration.enable=true icescrum.securitydebug.enable=false
Ping icescrum-mysql is OK (172.17.0.2).
MySQL is OK too.# mysql -h 172.17.0.2 -u root -p icescrum Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.7.12 MySQL Community Server (GPL) Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>
20/09/2016 à 9:48 #35874
Nicolas NoulletMaître des clésHi,
The error message is quite unambiguous: it means that either icescrum-mysql is not accessible on port 3306 from the iceScrum process, or that this URL is not the one used by your iceScrum server (another config.groovy file that would compete with this one?)
Can you try executing that from the server where iceScrum is started using the user who starts iceScrum?
mysql -h icescrum-mysql -u root -p icescrum
You config seems to be fine, I would perhaps add:
dataSource.dialect="org.hibernate.dialect.MySQL5InnoDBDialect"
-
AuteurMessages
Le forum ‘Installation’ est fermé à de nouveaux sujets et réponses.