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.
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.
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
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.
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.