After installation on Tomcat8 : can't start the app / Cannot load JDBC driver class

Support
1

Hello,

I have installed ODK on linux server (debian stable) + tomcat8.
I can access tomcat home page.
I can access app manager from Tomcat
I can load ODK war from the manager tomcat apps

The problem is when I click on start, I got an error :
ECHEC - L'application pour le chemin de contexte /ODKAggregate n'a pas pu
être démarrée
(the app couldn't start)

Looking through catilina.out I found :

Cannot load JDBC driver class 'com.mysql.jdbc.Driver'

and

avr. 20, 2017 4:52:48 PM org.apache.catalina.core.StandardContext
startInternal
GRAVE: Error listenerStart
avr. 20, 2017 4:52:48 PM org.apache.catalina.core.StandardContext
startInternal
GRAVE: Erreur de démarrage du contexte [/ODKAggregate] suite aux erreurs
précédentes
avr. 20, 2017 4:52:48 PM org.apache.catalina.core.ApplicationContext log
INFOS: Closing Spring root WebApplicationContext

It seems, I have no link between tomcat and mysql. I have done apt-get
install limysql-java

I didn't help.

Any idea ? I thik I am not far away from the solution so it's frustrating.
(I am not easy with tomcat, familiar with debian, just trying to install
odk for a teacher in a school).

Thanks a lot,
François

1 Like
2

Hallo Francois,

did you:" download the MySQL Connector/J, unzip it, and copy the
mysql-connector-java-x.x.x-bin.jar file into the Tomcat server's libs
directory. After copying it into that directory, you should stop and
restart the Tomcat server. "
as specified in the https://opendatakit.org/use/aggregate/tomcat-install/ ?

cheers,
Aurelio

··· Il giorno giovedì 20 aprile 2017 08:01:52 UTC+2, Francois Lermigeaux ha scritto: > > Hello, > > I have installed ODK on linux server (debian stable) + tomcat8. > I can access tomcat home page. > I can access app manager from Tomcat > I can load ODK war from the manager tomcat apps > > The problem is when I click on start, I got an error : > ECHEC - L'application pour le chemin de contexte /ODKAggregate n'a pas pu > être démarrée > (the app couldn't start) > > Looking through catilina.out I found : > > Cannot load JDBC driver class 'com.mysql.jdbc.Driver' > > and > > > avr. 20, 2017 4:52:48 PM org.apache.catalina.core.StandardContext > startInternal > GRAVE: Error listenerStart > avr. 20, 2017 4:52:48 PM org.apache.catalina.core.StandardContext > startInternal > GRAVE: Erreur de démarrage du contexte [/ODKAggregate] suite aux erreurs > précédentes > avr. 20, 2017 4:52:48 PM org.apache.catalina.core.ApplicationContext log > INFOS: Closing Spring root WebApplicationContext > > > It seems, I have no link between tomcat and mysql. I have done apt-get > install limysql-java > > I didn't help. > > Any idea ? I thik I am not far away from the solution so it's frustrating. > (I am not easy with tomcat, familiar with debian, just trying to install > odk for a teacher in a school). > > Thanks a lot, > François > > >
3

Hallo Aurelio,

Thanks for the advice, you were right, I had read to quickly and thought
apt-get will do the job. In facts ODK is really hard to install but finaly
it's working after an update of mysql to 5.7.

Thanks a lot,
François

··· On Thursday, April 20, 2017 at 9:42:38 PM UTC+11, Aurelio wrote: > > Hallo Francois, > > did you:" download the MySQL Connector/J, unzip it, and copy the > mysql-connector-java-x.x.x-bin.jar file into the Tomcat server's libs > directory. After copying it into that directory, you should stop and > restart the Tomcat server. " > as specified in the https://opendatakit.org/use/aggregate/tomcat-install/ > ? > > cheers, > Aurelio > > Il giorno giovedì 20 aprile 2017 08:01:52 UTC+2, Francois Lermigeaux ha > scritto: >> >> Hello, >> >> I have installed ODK on linux server (debian stable) + tomcat8. >> I can access tomcat home page. >> I can access app manager from Tomcat >> I can load ODK war from the manager tomcat apps >> >> The problem is when I click on start, I got an error : >> ECHEC - L'application pour le chemin de contexte /ODKAggregate n'a pas pu >> être démarrée >> (the app couldn't start) >> >> Looking through catilina.out I found : >> >> Cannot load JDBC driver class 'com.mysql.jdbc.Driver' >> >> and >> >> >> avr. 20, 2017 4:52:48 PM org.apache.catalina.core.StandardContext >> startInternal >> GRAVE: Error listenerStart >> avr. 20, 2017 4:52:48 PM org.apache.catalina.core.StandardContext >> startInternal >> GRAVE: Erreur de démarrage du contexte [/ODKAggregate] suite aux erreurs >> précédentes >> avr. 20, 2017 4:52:48 PM org.apache.catalina.core.ApplicationContext log >> INFOS: Closing Spring root WebApplicationContext >> >> >> It seems, I have no link between tomcat and mysql. I have done apt-get >> install limysql-java >> >> I didn't help. >> >> Any idea ? I thik I am not far away from the solution so it's >> frustrating. >> (I am not easy with tomcat, familiar with debian, just trying to install >> odk for a teacher in a school). >> >> Thanks a lot, >> François >> >> >>
4

Hi François,

You are correct that ODK requires MySQL 5.7 or greater (or MariaDB
10.1 or greater).

For future reference, that information is at
https://opendatakit.org/use/aggregate/tomcat-install/ under "Select
and Install Database Server".

Yaw

··· On Wed, Apr 26, 2017 at 4:17 AM, Francois Lermigeaux wrote: > Hallo Aurelio, > > Thanks for the advice, you were right, I had read to quickly and thought > apt-get will do the job. In facts ODK is really hard to install but finaly > it's working after an update of mysql to 5.7. > > Thanks a lot, > François > > > > On Thursday, April 20, 2017 at 9:42:38 PM UTC+11, Aurelio wrote: >> >> Hallo Francois, >> >> did you:" download the MySQL Connector/J, unzip it, and copy the >> mysql-connector-java-x.x.x-bin.jar file into the Tomcat server's libs >> directory. After copying it into that directory, you should stop and restart >> the Tomcat server. " >> as specified in the https://opendatakit.org/use/aggregate/tomcat-install/ >> ? >> >> cheers, >> Aurelio >> >> Il giorno giovedì 20 aprile 2017 08:01:52 UTC+2, Francois Lermigeaux ha >> scritto: >>> >>> Hello, >>> >>> I have installed ODK on linux server (debian stable) + tomcat8. >>> I can access tomcat home page. >>> I can access app manager from Tomcat >>> I can load ODK war from the manager tomcat apps >>> >>> The problem is when I click on start, I got an error : >>> ECHEC - L'application pour le chemin de contexte /ODKAggregate n'a pas pu >>> être démarrée >>> (the app couldn't start) >>> >>> Looking through catilina.out I found : >>> >>> Cannot load JDBC driver class 'com.mysql.jdbc.Driver' >>> >>> and >>> >>> >>> avr. 20, 2017 4:52:48 PM org.apache.catalina.core.StandardContext >>> startInternal >>> GRAVE: Error listenerStart >>> avr. 20, 2017 4:52:48 PM org.apache.catalina.core.StandardContext >>> startInternal >>> GRAVE: Erreur de démarrage du contexte [/ODKAggregate] suite aux erreurs >>> précédentes >>> avr. 20, 2017 4:52:48 PM org.apache.catalina.core.ApplicationContext log >>> INFOS: Closing Spring root WebApplicationContext >>> >>> >>> It seems, I have no link between tomcat and mysql. I have done apt-get >>> install limysql-java >>> >>> I didn't help. >>> >>> Any idea ? I thik I am not far away from the solution so it's >>> frustrating. >>> (I am not easy with tomcat, familiar with debian, just trying to install >>> odk for a teacher in a school). >>> >>> Thanks a lot, >>> François >>> >>> > -- > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "ODK Community" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to opendatakit+unsubscribe@googlegroups.com. > For more options, visit https://groups.google.com/d/optout.