iceScrum | Context initialization failed – iceScrum

iceScrum Forums Discutez d'iceScrum

4 sujets de 1 à 4 (sur un total de 4)

  • Auteur
    Messages
  • #35496

    bpoulain
    Participant

    Hi,

    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.

    #35502

    Nicolas Noullet
    Maître des clés

    Hi,

    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?

    #35504

    bpoulain
    Participant

    Hi,

    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>
    #35874

    Nicolas Noullet
    Maître des clés

    Hi,

    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"

4 sujets de 1 à 4 (sur un total de 4)

Le forum ‘Installation’ est fermé à de nouveaux sujets et réponses.