How to install ODK Aggregate on Ubuntu Server

Open Data Kit (ODK) is an open-source suite of tools that helps to Build survey form, Collect data on a mobile device and send it to a server and Aggregate the collected data on a server and extract it in useful formats. ODK Aggregate can be deployed on Google’s App Engine, by creating google account. ODK Aggregate can also be deployed locally on a Tomcat server backed with a MySQL or PostgreSQL database server.

After installation of Tomcat and PostgreSQL you can download ODK installation file as like in our instruction here:

Go for and choose the proper version click download

Then while it downloading click the link

Here it will be

~$ wget


After it is downloaded type the below command and follow the instruction (please be informed that the version can be deferred) :

~$ sudo chmod +x ODK*.run

~$ sudo ./ODK*.run 

The installer does not install anything, but will guide you through configuring ODK Aggregate for Tomcat and PostgreSQL.

During instruction, you have given a name for a folder for ODK Aggregate war file and other files. I have given ODK name.

~$ cd ODK/ODK*/

~$ sudo cp ODK*.war /opt/tomcat/webapps/

~$ sudo -i -u postgres

Then go to the folder location inside the folder:

postgres@ubuntu: ~$ cd /home/[user_name_for_the_account]/ODK/ODK*

postgres@ubuntu: ~$ psql

postgres=# \i create_db_and_user.sql

postgres=# \q

postgres@ubuntu: ~$ exit

~$ sudo service tomcat restart

now you can browse for   http://[computer_name_or_IP]:8080/ODKAggregate

ODK user name is what you set and password is aggregate

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.