Problem startin/installing icescrum

[Kagilum]

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 ?

[Nicolas Noullet]

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.

[Kagilum]

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

[Kagilum]

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$

[Nicolas Noullet]

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.

[Kagilum]

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"

[Nicolas Noullet]

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"

...

[Autor]

Entradas