iceScrum Forums Discuss on iceScrum

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$

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"