Install and configure Open Data Kit

First we will download the proper version of ODK Aggregate.

sudo wget
sudo chmod +x ODK\ Aggregate\ v1.4.12\
sudo ./ODK\ Aggregate\ v1.4.12\

You will meet a long configuration process. You may not need to tweak all of these because most of the time the default value is just fine.

Here the installer will create a .war and .sql file based on the configurations you set. The .sql file will have the codes necessary for the databases and the .war file will set the web application. Keep pressing return (Enter) to scroll through the initial setup files, probably will take seven – nine returns.

And then,

Do you accept this license? [y/n]: y

Here is everything you will meet while the installation.

 Select an output parent directory

This "installer" does not actually install anything. Instead, it guides you
through configuring ODK Aggregate. As the last step of the installer, it will
either launch the upload tool for uploading to Google's AppEngine cloud services
or open a README.html containing the final installation instructions for MySQL
or PostgreSQL deployments.

Please select the parent directory under which an 'ODK Aggregate' directory will
be created to contain the configured software.

[]: /home/sr/odk

Choose Platform

Choose the data storage and execution environment on which you would like ODK Aggregate to run. 
If you choose MySQL or PostgreSQL, you will need to first install that database server and 
an Apache Tomcat 6 webserver.

[1] Google App Engine: Uses Google's cloud-based data storage and webserver services.
[2] MySQL: Uses a MySQL database and an Apache Tomcat 6 webserver that you install.
[3] PostgreSQL: Uses a PostgreSQL database and an Apache Tomcat 6 webserver that you install.
Please choose an option [1] : 2

Pre-installation Requirements - Apache Tomcat

Before continuing, you should download and install an Apache Tomcat 6 webserver
within which you will run ODK Aggregate (instructions on installing your chosen
database will be presented later).

Apache Tomcat 6 can be downloaded from the link below.

If you modify any of the Apache Tomcat defaults, please make note of them. [Y/n]: y

Apache Tomcat SSL configuration

SSL certificates allow a client to verify the identity of a webserver and to
establish secured (encrypted) communications with that webserver (https:). SSL
certificates are typically purchased from Verisign or another issuing authority;
that process can take weeks to complete.

If you do have an SSL certificate, please refer to the Apache Tomcat
documentation for how to install the certificate on your system. Within the
Tomcat 6.0 documentation, refer to the User Guide section 12: SSL. [Y/n]: y

Apache Tomcat SSL configuration

Do you have an SSL certificate?

[1] No, I do not have an SSL certificate: - User logins ARE secure.
- Submitting and/or viewing form data MAY NOT BE secure.
- Changing passwords MAY NOT BE secure.
Security breaches are particularly likely over unsecured WiFi hotspots.

[2] Yes, I have an SSL certificate: - User logins ARE secure.
- Submitting and/or viewing form data IS secure.
- Changing passwords IS secure.

Please choose an option [1] : 1

Apache Tomcat Port Configuration

ODK Aggregate needs to know the port numbers and the Internet-visible IP address
or DNS name through which it can be reached in order to construct links back to
its content when publishing or exporting data files.

Follow the ODK Aggregate Tomcat Install instructions (link below) to make your
computer accessible on the web (using an Internet-visible IP address) and to
establish a DNS name. [Y/n]: y

HTTP/1.1. Connector Port: [8080]: 8080

Internet-visible IP address or DNS name: []:

Pre-installation Database Requirements - MySQL

We have developed and tested against MySQL 5.1 and 5.5

Please download, install and configure MySQL from the link below.

Choose the Downloads (GA) tab, and select the MySQL Community Server edition.
When running the MySQL Server Instance Configuration Wizard, please make note of
your root password and any non-default values you have entered during the
installation process. [Y/n]: y

Pre-installation Database Requirements - MySQL (concluded)

You also must install a MySQL library on the Apache Tomcat instance.
Please download the MySQL Connector/J zip file from the link below.

Unzip or extract the contents of this file to a directory on your system.
The top-level directory should contain a file named:


Copy this file into the /lib directory of your Apache Tomcat 6 installation. On
Windows, the default location for this is 'C:\Program Files\Apache Software
Foundation\Tomcat 6.0\lib'

Stop and restart your Apache webserver (so it can discover this new library). [Y/n]: y

Database server settings

Specify the host and port number used to communicate with the database server.

If the database server is on the same host as the webserver, enter ''

Database port number: [3306]: 3306

Database server hostname: []:

ODK Aggregate database authentication settings

The database server must be configured with an account (username and password)
that ODK Aggregate will employ for accessing the database server. This is not
an account that you will give to anyone; it is only for use by the ODK Aggregate
webserver. Username and password should be alphanumeric strings beginning with a
letter (no spaces or punctuation please!).

The installer will generate a script that can be run on the database server to
establish the required configuration.

Database username: [odk_user]: odk_user

Database password: :
Retype password: :
ODK Aggregate database datastore settings

The database server must be configured with a workspace identified by a database
name, and, if using Postgresql, a schema name. This workspace is where ODK
Aggregate will store uploaded forms, submissions and other information. The
database name (and schema name for Postgresql) can be any alphanumeric strings
beginning with a letter; underscores (_) are OK (no spaces or punctuation

The installer will generate a script that can be run on the database server to
create the workspace.

Database Name: [odk_prod]: odk_prod

ODK Aggregate Instance Name

The ODK Aggregate instance name will be displayed to your users when they log
into ODK Aggregate using their ODK Aggregate username and password. Including
the name of your organization in the instance name can help users confirm that
they have contacted the correct website.

NOTE: During subsequent upgrades, any changes to this text will invalidate all
the ODK Aggregate passwords configured on your webserver. To prevent
disruptions during upgrades, please make a record of the name you have chosen.

Please enter the name of your instance: []: odk_test

Super-user ODK Aggregate Username

The user with this account will always have full permissions on the system.

The first time ODK Aggregate runs, only this user is allowed to log onto the
system. Upon first logging in, they should change their password and complete
the configuration of ODK Aggregate by specifying additional users and what
permissions those users have on the system. This user's password will be set to
'aggregate' upon initial install or upon changing the ODK Aggregate instance

Please enter an ODK Aggregate Username: []: admin

Setup is now ready to begin configuring ODK Aggregate.

Do you want to continue? [Y/n]: y

If you go to the installation folder (/home/sr/odk) you’ll find three files.

  1. ODKAggregate.war
  2. README.html
  3. create_db_and_user.sql

Login to the MySQL and use the .sql file to create the database.

mysql -u root -p
source ~/home/sr/odk/create_db_and_user.sql

You may want to create a mysql-connector for the Tomcat. Extract the tar file and move the mysql-connector-java-5.1.40.jar file to /opt/tomcat/lib directory.

cd /home/sr/odk
sudo wget
sudo tar -xvzf mysql-connector-java-5.1.40.tar.gz
cd mysql-connector-java-5.1.40
sudo mv mysql-connector-java-5.1.40.jar /opt/tomcat/lib/

We are almost there. come back to the ODK installation folder, rename ODKAggregate.war to ROOT.war. Move the ROOT.war file to /opt/tomcat/webapps folder.

sudo mv /home/sr/odk/ODKAggregate.war /opt/tomcat/webapps/ROOT.war

In your browser hit your At first you may end up to a blank page. Hit it again with And there is an error.

There is still some things need to be done. Tomcat 8, Glassfish and Jetty require few additional configuration steps to run ODK Aggregate. All of these webservers require configuration settings to enable cookies under HTTPS. Otherwise, ODK Aggregate uses no special Tomcat features and it should operate correctly within any compliant Servlet web container.

Edit the context.xml file of Tomcat.

sudo vi /opt/tomcat/conf/context.xml
<?xml version="1.0" encoding="UTF-8"?>
  Licensed to the Apache Software Foundation (ASF) under one or more
  contributor license agreements.  See the NOTICE file distributed with
  this work for additional information regarding copyright ownership.
  The ASF licenses this file to You under the Apache License, Version 2.0
  (the "License"); you may not use this file except in compliance with
  the License.  You may obtain a copy of the License at

  Unless required by applicable law or agreed to in writing, software
  distributed under the License is distributed on an "AS IS" BASIS,
  See the License for the specific language governing permissions and
  limitations under the License.
<!-- The contents of this file will be loaded for each web application -->
<Context useHttpOnly="false">

    <!-- Default set of monitored resources. If one of these changes, the    -->
    <!-- web application will be reloaded.                                   -->

    <!-- Uncomment this to disable session persistence across Tomcat restarts -->
    <Manager pathname="" />

If you are not familiar with Vim commands, here is a quick tip. Use vi to start edit a file. Hit i to insert or edit a line. Hit escape to exit the insert mode, hit : to enter the menu mode. In menu mode (with :) type wq to save edits and exit vi mode. Simply hit q! to exit without saving. We used these commands to add useHttpOnly="false" (line-19) to our file.

Create a directory called WEB-INF inside webbapps folder and create two file here.

cd /opt/tomcat/webapps/
sudo mkdir WEB-INF
sudo vi glassfish-web.xml

Add these lines inside the file and save it.

<?xml version="1.0" encoding="UTF-8"?>
            <property name="cookieHttpOnly" value="false" />

Add another file called jetty-web.xml and add these lines.

sudo vi jetty-web.xml
<?xml version="1.0"  encoding="ISO-8859-1"?>
<!DOCTYPE Configure PUBLIC "-//Jetty//Configure//EN" "">
<Configure class="org.eclipse.jetty.webapp.WebAppContext">
    <Get name="sessionHandler">
        <Get name="sessionManager">
            <Set name="secureCookies" type="boolean">true</Set>

Remember : to enter menu, wq to save and quit.

Clean the browser cache, restart the browser. Go to, use admin as username, aggregate as password.

You have successfully reached the shore. Congratz and enjoy!


Design a form with XLSForm. This is as simple as working with Excel sheets, no coding requires. Here is a sample. Once the form is finished, use this page to convert and upload to ODK Aggregate.

Download and install ODK Collect to you android device. Set your credentials from General Stting>Configure Platform Setting. Once set, check if you can fetch blank form with Get Blank Form. Download the form from there, fill it, save and send finalized form back to Aggregate.

If you don’t have internet with you, try ODK Briefcase. It can pull finalized data from your devise to your PC and send later on. It can even download submitted data from ODK Aggregate in bulk.

You can even publish your data to Fusion table in stream. You can export the data as KML and see on Google Earth.

Pages: 1 2