Cannot start Aggregate 1.0 with Apache Tomcat 6.0

Hi everyone, I'm not an expert with ODK at all but have managed to
follow instructions to get the previous Aggregate version to work.

However, with Aggregate 1.0, I'm running into a lot of problems. I've
successfully installed Tomcat 6.0, MySQL 5.5 and followed all the
steps in the configuration of Aggregate 1.0 for MySQL. Right now, I'm
stuck after putting the ODKAggregate.war file into the webapps folder
of Apache Tomcat. I go to the Manager page of localhost:8080 and I
see ODKAggregate application there. I click "Start" but it gives me
this error message "FAIL - Application at context path /ODKAggregate
could not be started".

If you have any idea at all on where I might have committed an error,
please let me know. I could provide you with more details of my
installation if you want.

As far as I'm aware, I've followed all the instructions successfully
up until this point. Thanks in advance for your help. I really
appreciate it.

Hi Du,

One thing to double-check is that going to
http://localhost:8080/ODKAggregate
doesn't work itself (the application should have already been started).

For MySQL, be sure you copy the MySQL Connector/J jar into the
lib directory of the tomcat web server. After copying it into the lib
directory, you will probably need to stop and start the web server
so that it finds it.

And just to double-check the obvious -- you have created the database
as described in the README.html with the database creation script.

Finally, if none of that resolves your issue, look at the catalina log file
for today under tomcat's installation directory (e.g.,
logs\catalina.2011-06-28.log).
Search for SEVERE or WARNING (search upwards from the bottom of the file).
If it isn't clear what the problem is from the error, paste the log file
into
dpaste.com and send me the link.

Mitch

··· On Tue, Jun 28, 2011 at 1:50 PM, Du wrote:

Hi everyone, I'm not an expert with ODK at all but have managed to
follow instructions to get the previous Aggregate version to work.

However, with Aggregate 1.0, I'm running into a lot of problems. I've
successfully installed Tomcat 6.0, MySQL 5.5 and followed all the
steps in the configuration of Aggregate 1.0 for MySQL. Right now, I'm
stuck after putting the ODKAggregate.war file into the webapps folder
of Apache Tomcat. I go to the Manager page of localhost:8080 and I
see ODKAggregate application there. I click "Start" but it gives me
this error message "FAIL - Application at context path /ODKAggregate
could not be started".

If you have any idea at all on where I might have committed an error,
please let me know. I could provide you with more details of my
installation if you want.

As far as I'm aware, I've followed all the instructions successfully
up until this point. Thanks in advance for your help. I really
appreciate it.

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer


University of Washington
mitchellsundt@gmail.com

pls am using postgreSQL and i can see my ODKAggregate listen on my tomcat application list but i cant start it in the tomcat

Hi all,

My first time out testing ODK.

Just to follow on to this thread and to provide a little more detail
for users who are somewhat technically challenged (as I am :D).

I was deploying ODK on my local system (Ubuntu Linux) with my own
Tomcat 6 and MySQL. Used the rather awesome v1.0 rev 3 linux
installer. Did the MySQL setup and had similar errors trying to deploy
the war (snippets from catalina.out below for searchability).

As per mitch's instructions. I downloaded mysql-connector-
java-5.1.17.zip from the MySQL website (http://dev.mysql.com/downloads/
connector/j/)

I unzipped it and copied the jar into /var/lib/tomcat6/webapps/
ODKAggregate/WEB-INF/lib/

Restarted tomcat6 and it all works great!

Thanks,

Bird

SEVERE: Context [/ODKAggregate] startup failed due to previous errors
Caused by: java.sql.SQLException: ------
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
Caused by: java.sql.SQLException: ------
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException:
Could not get JDBC Connection; nested exception is
java.sql.SQLException: ------
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
SEVERE: Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'hierarchicalRoleRelationships' defined in
ServletContext resource [/WEB-INF/ap
plicationContext-security.xml]: Invocation of init method failed;
nested exception is
org.opendatakit.common.persistence.exception.ODKDatastoreException:
org.springfr
amework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC
Connection; nested exception is java.sql.SQLException: ------
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

··· On Jun 28, 2:11 pm, Mitch Sundt wrote: > Hi Du, > > One thing to double-check is that going tohttp://localhost:8080/ODKAggregate > doesn't work itself (the application should have already been started). > > For MySQL, be sure you copy the MySQL Connector/J jar into the > lib directory of the tomcat web server. After copying it into the lib > directory, you will probably need to stop and start the web server > so that it finds it. > > And just to double-check the obvious -- you have created the database > as described in the README.html with the database creation script. > > Finally, if none of that resolves your issue, look at the catalina log file > for today under tomcat's installation directory (e.g., > logs\catalina.2011-06-28.log). > Search for SEVERE or WARNING (search upwards from the bottom of the file). > If it isn't clear what the problem is from the error, paste the log file > into > dpaste.com and send me the link. > > Mitch > > > > > > > > > > On Tue, Jun 28, 2011 at 1:50 PM, Du wrote: > > Hi everyone, I'm not an expert with ODK at all but have managed to > > follow instructions to get the previous Aggregate version to work. > > > However, with Aggregate 1.0, I'm running into a lot of problems. I've > > successfully installed Tomcat 6.0, MySQL 5.5 and followed all the > > steps in the configuration of Aggregate 1.0 for MySQL. Right now, I'm > > stuck after putting the ODKAggregate.war file into the webapps folder > > of Apache Tomcat. I go to the Manager page of localhost:8080 and I > > see ODKAggregate application there. I click "Start" but it gives me > > this error message "FAIL - Application at context path /ODKAggregate > > could not be started". > > > If you have any idea at all on where I might have committed an error, > > please let me know. I could provide you with more details of my > > installation if you want. > > > As far as I'm aware, I've followed all the instructions successfully > > up until this point. Thanks in advance for your help. I really > > appreciate it. > > > -- > > Post: opendatakit@googlegroups.com > > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > > Options:http://groups.google.com/group/opendatakit?hl=en > > -- > Mitch Sundt > Software Engineerhttp://www.OpenDataKit.org > University of Washington > mitchellsu...@gmail.com

This did the trick;

Copy mysql-connector-java-5.1.17-bin.jar to /var/lib/tomcat6/webapps/
ODKAggregate/WEB-INF/lib/

I was previously copying the .jar file to /var/lib/tomcat6/ but this was
NOT working.

··· On Sep 28, 2015 12:08 PM, wrote:

pls am using postgreSQL and i can see my ODKAggregate listen on my tomcat
application list but i cant start it in the tomcat

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/2TIpP0Wlu1I/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Read your Tomcat and PostgreSQL logs. What do they say?

Yaw

··· -- Need ODK services? http://nafundi.com provides form design, server setup, professional support, and software development for ODK.

On Mon, Sep 28, 2015 at 4:08 PM, senyoab@gmail.com wrote:

pls am using postgreSQL and i can see my ODKAggregate listen on my tomcat application list but i cant start it in the tomcat

--

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.

This did the trick;

Copy mysql-connector-java-5.1.17-bin.jar to /var/lib/tomcat6/webapps/
ODKAggregate/WEB-INF/lib/

I was previously copying the .jar file to /var/lib/tomcat6/ but this was NOT working.

Hi, can i have some help.

I have the same issue, my catalina log is attached. I don't know where is the error.

Thanks in advance

catalina.2016-06-21.log (21.2 KB)

Either you are out of RAM or you did not properly install your JDBC
driver. If this is the first time you are using Aggregate, it's likely
the latter.

Yaw

··· -- Need ODK consultants? Nafundi provides form design, server setup, in-field training, and software development for ODK. Go to https://nafundi.com to get started.

On Tue, Jun 21, 2016 at 11:15 PM, nordinotitus.mz@gmail.com wrote:

Hi, can i have some help.

I have the same issue, my catalina log is attached. I don't know where is the error.

Thanks in advance

--

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.

I manage to downgrade my server to Ubuntu 12.04 to see what will happen. Thank you for the tip. Soon as i finish i'll post on the group the results.

Best

-----Mensagem original-----

··· De: opendatakit@googlegroups.com [mailto:opendatakit@googlegroups.com] Em nome de Yaw Anokwa Enviada em: quinta-feira, 23 de junho de 2016 14:57 Para: ODK Community Cc: dtv2031 Assunto: Re: [ODK Community] Re: Cannot start Aggregate 1.0 with Apache Tomcat 6.0

Either you are out of RAM or you did not properly install your JDBC driver. If this is the first time you are using Aggregate, it's likely the latter.

Yaw

Need ODK consultants? Nafundi provides form design, server setup, in-field training, and software development for ODK. Go to https://nafundi.com to get started.

On Tue, Jun 21, 2016 at 11:15 PM, nordinotitus.mz@gmail.com wrote:

Hi, can i have some help.

I have the same issue, my catalina log is attached. I don't know where is the error.

Thanks in advance

--

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.

--

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 a topic in the Google Groups "ODK Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/opendatakit/2TIpP0Wlu1I/unsubscribe.
To unsubscribe from this group and all its topics, send an email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.