Hi yanokwa, I am having an issue setting up ODK aggregate. I am using tomcat7 and the latest version of ODK Aggregate. I have also edited the context file and copied the .war file to the webapps folder however, when i access the ipaddress:8080/ODKAggregate url it gives me a 404 error and a description that the resource file is not there. what could be causing it not to be visible to tomcat?
in first of all you have to copey the file
MySQL\Connector J 5.1.31
Apache Software Foundation\Tomcat 8.5\lib
in my case i use apach 8.5 mysql 5.6
in fact you have to check Aggregate is loaded an it's running.
it will show you this screen
click on manage app:
it will show you this screen :
When troubleshooting Aggregate, I find it's best to look at the Tomcat logs first. The logs will tell give you a big hint as to why the application isn't loading.
I have have set the java path, the connector, i also ran the db script successfully and i copied the ODKaggregate.war file to /opt/tomcat/webapps directory but still there is something that is making it to not access the odkaggregate through myipaddress:8080 url. Since i am new to the forum i cant upload a file so heres a link to the catalina.out file https://docs.google.com/document/d/1BNCy13omQ7TrMsx92c1emVQJsugfcECARhE4WsQC9gg/edit?usp=sharing
The log had the hint I was looking for...
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL ,
_LAST_UPDATE_URI_USERVARCHAR(80) CHARACTER SET utf8 NULL ,
_L' at line 1
ODK Aggregate requires MySQL 5.7 or higher. You are probably using MySQL 5.5.
am sorry for my late respond,
in fact YAW is right it looks like you are using version of MYSQL older than MYSQL 5.6
would you please check the version of your MYSQL
I am using version 5.5.57. Does the version of mysql affect the odk webapp from being accessed?
Thanks a lot guys, apparently with MySQL 5.7 everything works okay