iceScrum | Problem startin/installing icescrum – iceScrum

iceScrum Forums Discuss on iceScrum

Viewing 7 posts - 1 through 7 (of 7 total)

  • Author
    Posts
  • #10680

    Kagilum
    Keymaster

    Hi,

    I have a working tomcat7 enviroment en icescrum 6_13_2. I can find icescrum between my applications but it wont start it says: FAIL – Application at context path /icescrum could not be started

    And the icescrum.log says this http://pastebin.com/WPZg2XMM

    Do you guys have an idea what is wrong ?

    #10965

    Nicolas Noullet
    Keymaster

    Hi,

    The root error here is “java.io.FileNotFoundException: prodDba.properties.new (Permission denied)”.

    By default, iceScrum comes with an embedded DBMS: HSLQDB, which attempts to create files on the path from where Tomcat is started. Here the attempt fails because the user who started Tomcat doesn’t have sufficient permissions on this path so the file cannot be created.

    To solve this issue, you can add permissions on this path for this user, change the path from where Tomcat is started or configure the connection to an external DBMS. Please note that HSQLDB is not suited for real life usages so we recommend to use an external DBMS as soon as possible.

    #10968

    Kagilum
    Keymaster

    Thnx for the reply. Guess I’ll install sql then 🙂 thank you, wil let you know if it works

    #10969

    Kagilum
    Keymaster

    Back from my vacation.

    I found a tutorial http://jramier.wordpress.com/2014/04/08/install-icescrum-for-agile-project/

    Only in the last step he mentions jbdc.jar but I cant find that file. not even with

    sudo find -name jbdc.jar

    I installed mysql-server and added this line to
    /etc/icescrum/icescrum_config.properties


    //Project
    icescrum.project.import.enable = true
    icescrum.project.export.enable = true
    icescrum.project.creation.enable = true
    icescrum.project.private.enable = true
    icescrum.project.private.default = false


    // Users
    icescrum.gravatar.secure = false
    icescrum.gravatar.enable = true
    icescrum.registration.enable = true
    icescrum.login.retrieve.enable = true


    // Alerts
    icescrum.auto_follow_productowner = true
    icescrum.auto_follow_stakeholder = true
    icescrum.auto_follow_scrummaster = true
    icescrum.alerts.errors.to = "jonathan.ramier@kolibri.com"
    icescrum.alerts.subject_prefix = "[icescrum]"
    icescrum.alerts.enable = true
    icescrum.alerts.default.from = "webmaster@icescrum.org"


    //Attachments
    icescrum.attachments.enable = true

    // Server Url
    grails.serverURL = http://it.aramisautode.com/icescrum


    // Logging
    icescrum.debug.enable = false
    icescrum.securitydebug.enable = false


    // Working directory
    icescrum.baseDir = /usr/local/icescrum


    // Cross Origin
    icescrum.cors.enable = true
    icescrum.cors.allow.origin.regex = "*"


    // DataBase MySQL
    dataSource.driverClassName=com.mysql.jdbc.Driver
    dataSource.dialect=org.hibernate.dialect.MySQLDialect
    dataSource.url=jdbc:mysql://localhost:3306/icescrum?useUnicode=true&characterEncoding=utf8&autoReconnect=true
    //dataSource.dbCreate=update // permit to update database
    dataSource.dbCreate=create // permit to recreate database, uncomment at first launching
    dataSource.username = root
    dataSource.password =

    I now get this error in the tomcat log

    INFO: Deploying web application archive /var/lib/tomcat7/webapps/icescrum.war
    Oct 29, 2014 1:28:01 PM org.apache.catalina.loader.WebappClassLoader validateJarFile
    INFO: validateJarFile(/var/lib/tomcat7/webapps/icescrum/WEB-INF/lib/geronimo-servlet_3.0_spec-1.0.jar) - jar not loaded. See Servlet Spec 3.0, section 10.7.2. Offending class: javax/servlet/Servlet.class
    Oct 29, 2014 1:28:27 PM org.apache.catalina.core.StandardContext startInternal
    SEVERE: Error listenerStart
    Oct 29, 2014 1:28:27 PM org.apache.catalina.core.StandardContext startInternal
    SEVERE: Context [/icescrum] startup failed due to previous errors
    Oct 29, 2014 1:28:27 PM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
    SEVERE: The web application [/icescrum] registered the JDBC driver [org.hsqldb.jdbcDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has bee$
    Oct 29, 2014 1:28:27 PM org.apache.catalina.startup.HostConfig deployDirectory
    INFO: Deploying web application directory /var/lib/tomcat7/webapps/ROOT
    Oct 29, 2014 1:28:27 PM org.apache.coyote.AbstractProtocol start
    INFO: Starting ProtocolHandler ["http-bio-8080"]
    Oct 29, 2014 1:28:28 PM org.apache.catalina.startup.Catalina start
    INFO: Server startup in 27745 ms
    Oct 29, 2014 1:28:43 PM org.apache.catalina.loader.WebappClassLoader validateJarFile
    INFO: validateJarFile(/var/lib/tomcat7/webapps/icescrum/WEB-INF/lib/geronimo-servlet_3.0_spec-1.0.jar) - jar not loaded. See Servlet Spec 3.0, section 10.7.2. Offending class: javax/servlet/Servlet.class
    Oct 29, 2014 1:28:57 PM org.apache.catalina.core.StandardContext startInternal
    SEVERE: Error listenerStart
    Oct 29, 2014 1:28:57 PM org.apache.catalina.core.StandardContext startInternal
    SEVERE: Context [/icescrum] startup failed due to previous errors
    Oct 29, 2014 1:28:57 PM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
    SEVERE: The web application [/icescrum] registered the JDBC driver [org.hsqldb.jdbcDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has bee$
    #10980

    Nicolas Noullet
    Keymaster

    Hello,

    This tutorial is wrong 🙁

    You can remove the icescrum_config.properties file and the icescrum_config_location=/etc/icescrum/icescrum_config.properties
    configuration.

    Then, you can create a new file named config.groovy (in /etc/icescrum/ if you want, it does not really matter). Next, follow our documentation to configure the connection to MySQL: https://www.icescrum.com/documentation/install-guide/#database_2.

    Then, as indicated in our documentation, the preferred way to make iceScrum use your config.groovy file is adding the variable to your CATALINA_OPTS:
    -Dicescrum_config_location=/path/to/dir/where/i/can/write/config.groovy
    This can be done in the Tomcat setenv.sh configuration script.

    Finally, you should remove (or rename with .bak) the tomcat-jdbc.jar from the tomcat lib directory. Again, this is explained in our documentation! Actually it should cover everything that is needed to configure a full working iceScrum server.

    #11003

    Kagilum
    Keymaster

    Still no luck, I now get this error when i Use tail -f /var/log/tomcat7/catalina.out



    Configuring Spring Security ACL ...
    ... finished configuring Spring Security ACL

    Nov 25, 2014 2:17:57 PM org.apache.catalina.core.StandardContext startInternal
    SEVERE: Error listenerStart
    Nov 25, 2014 2:17:57 PM org.apache.catalina.core.StandardContext startInternal
    SEVERE: Context [/icescrum] startup failed due to previous errors
    Nov 25, 2014 2:17:57 PM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
    SEVERE: The web application [/icescrum] registered the JDBC driver [org.hsqldb.jdbcDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.

    and this in the icescrum.log

    2014-11-25 14:29:44,466 [http-nio-8080-exec-6] INFO  grails.spring.BeanBuilder  - [RuntimeConfiguration] Configuring data source for environment: PRODUCTION
    2014-11-25 14:29:47,647 [http-nio-8080-exec-6] 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.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is 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 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': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is java.sql.SQLException: File input/output error prodDba.properties java.io.FileNotFoundException: prodDba.properties.new (Permission denied)
    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 bean property 'sessionFactory'; nested exception is 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 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': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is java.sql.SQLException: File input/output error prodDba.properties java.io.FileNotFoundException: prodDba.properties.new (Permission denied)
    ... 3 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 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': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is java.sql.SQLException: File input/output error prodDba.properties java.io.FileNotFoundException: prodDba.properties.new (Permission denied)
    ... 3 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': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is java.sql.SQLException: File input/output error prodDba.properties java.io.FileNotFoundException: prodDba.properties.new (Permission denied)
    ... 3 more
    Caused by: 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 DatabaseMetaData; nested exception is java.sql.SQLException: File input/output error prodDba.properties java.io.FileNotFoundException: prodDba.properties.new (Permission denied)
    ... 3 more
    Caused by: org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is java.sql.SQLException: File input/output error prodDba.properties java.io.FileNotFoundException: prodDba.properties.new (Permission denied)
    ... 3 more
    Caused by: java.sql.SQLException: File input/output error prodDba.properties java.io.FileNotFoundException: prodDba.properties.new (Permission denied)
    at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)
    at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
    at org.hsqldb.jdbcDriver.connect(Unknown Source)
    at com.sun.proxy.$Proxy28.getMetaData(Unknown Source)
    ... 3 more

    1 thing, I couldnt find the setenv.sh so I put it in catalina.sh in the same directory

    So it looks like this

    if [ $have_tty -eq 1 ]; then
    echo "Using CATALINA_BASE: $CATALINA_BASE"
    echo "Using CATALINA_HOME: $CATALINA_HOME"
    echo "Using CATALINA_TMPDIR: $CATALINA_TMPDIR"
    if [ "$1" = "debug" ] ; then
    echo "Using JAVA_HOME: $JAVA_HOME"
    else
    echo "Using JRE_HOME: $JRE_HOME"
    fi
    echo "Using CLASSPATH: $CLASSPATH"
    if [ ! -z "$CATALINA_PID" ]; then
    echo "Using CATALINA_PID: $CATALINA_PID"
    fi
    fi

    if [ "$1" = "jpda" ] ; then
    if [ -z "$JPDA_TRANSPORT" ]; then
    JPDA_TRANSPORT="dt_socket"
    fi
    if [ -z "$JPDA_ADDRESS" ]; then
    JPDA_ADDRESS="8000"
    fi
    if [ -z "$JPDA_SUSPEND" ]; then
    JPDA_SUSPEND="n"
    fi
    if [ -z "$JPDA_OPTS" ]; then
    JPDA_OPTS="-agentlib:jdwp=transport=$JPDA_TRANSPORT,address=$JPDA_ADDRESS,server=y,suspend=$JPDA_SUSPEND"
    fi
    CATALINA_OPTS="$CATALINA_OPTS $JPDA_OPTS"
    -Duser.timezone=UTC
    -Dicescrum_config_location=/icescrum/config.groovy
    -Xmx512m
    -XX:MaxPermSize=256m




    shift
    fi

    if [ "$1" = "debug" ] ; then
    if $os400; then
    echo "Debug command not available on OS400"
    exit 1
    else
    shift
    if [ "$1" = "-security" ] ; then
    if [ $have_tty -eq 1 ]; then
    echo "Using Security Manager"
    fi
    shift
    exec "$_RUNJDB" "$LOGGING_CONFIG" $LOGGING_MANAGER $JAVA_OPTS $CATALINA_OPTS
    -Djava.endorsed.dirs="$JAVA_ENDORSED_DIRS" -classpath "$CLASSPATH"
    -sourcepath "$CATALINA_HOME"/../../java
    -Djava.security.manager
    -Djava.security.policy=="$CATALINA_BASE"/work/catalina.policy
    -Dcatalina.base="$CATALINA_BASE"
    -Dcatalina.home="$CATALINA_HOME"
    -Djava.io.tmpdir="$CATALINA_TMPDIR"
    org.apache.catalina.startup.Bootstrap "$@" start
    else

    and my config.groovy

    //Project
    icescrum.project.import.enable = true
    icescrum.project.export.enable = true
    icescrum.project.creation.enable = true
    icescrum.project.private.enable = true
    icescrum.project.private.default = false

    //user
    icescrum.gravatar.secure = false
    icescrum.gravatar.enable = false
    icescrum.registration.enable = true
    icescrum.login.retrieve.enable = true

    //Alerts
    cescrum.auto_follow_productowner = true
    icescrum.auto_follow_stakeholder = true
    icescrum.auto_follow_scrummaster = true
    icescrum.alerts.errors.to = "jvantuil@landstede.nl"
    icescrum.alerts.subject_prefix = "[icescrum]"
    icescrum.alerts.enable = true
    icescrum.alerts.default.from = "icescrum@compict.nl"

    //Attachments
    icescrum.attachments.enable = true

    //server UTL
    grails.serverURL = "http://localhost:8080/icescrum"

    //Logging
    icescrum.debug.enable = false
    icescrum.securitydebug.enable = false

    //Working Directory
    icescrum.baseDir = "/icescrum/work"

    //Cross-domain (CORS) support for API
    icescrum.cors.enable = true
    icescrum.cors.allow.origin.regex = "*"

    //Mail server
    grails.mail.host = "smtp.gmail.com"
    grails.mail.port = 465
    grails.mail.username = "an email"
    grails.mail.password = "blA"
    grails.mail.props = ["mail.smtp.auth":"true",
    "mail.smtp.socketFactory.port":"465",
    "mail.smtp.socketFactory.class":"javax.net.ssl.SSLSocketFactory",
    "mail.smtp.socketFactory.fallback":"false"]

    //Database
    dataSource.dialect = "org.hibernate.dialect.MySQL5InnoDBDialect"
    dataSource.driverClassName = "com.mysql.jdbc.Driver"
    dataSource.url = "jdbc:mysql://localhost:3306/icescrum?useUnicode=true&characterEncoding=utf8"
    dataSource.username = "root"
    dataSource.password = "Not gonna tell"
    #10963

    Nicolas Noullet
    Keymaster

    Hello,

    If the setenv.sh file doesn’t exist, you can create it and give it write permissions. It is possible to use the catalina.sh file as an alternative but you cannot put the configuration anywhere. It must be assigned to the CATALINA_OPTS variable.

    That means that you should rather have something like:

    ...
    CATALINA_OPTS="$CATALINA_OPTS $JPDA_OPTS -Duser.timezone=UTC -Dicescrum_config_location=/icescrum/config.groovy -Xmx512m -XX:MaxPermSize=256m"
    ...
Viewing 7 posts - 1 through 7 (of 7 total)

The forum ‘Installation’ is closed to new topics and replies.