Install ODK with Postgres

Support
1

Hello,
I have a problem,
The problem is that it does not install with postgres. Does anyone have a step-by-step manual?

Best regards.

Gabriel Sosa

2

Hi,

of course it does.
Where are you blocked ?

By the way, you need to install postgresql by yourself.
When PostgreSQL runs, you can start to "install" Aggregate with the "installer" and enter the parameters db connection parameters.
The install will generate the SQL code to run over your PostgreSQL instance. Adapt it if your database or schema already exist.
On PostgreSQL 10 the script will throw an error because of the use of the "unencrypted" option for password creation.

You just need to delete the word. here is the code to adapt :

-- Adapt this code to your conf

create database "odk_database_name";
create user "db_user_name" with /* unencrypted */ password 'db_user_password';
grant all privileges on database "odk_database_name" to "db_user_name";
alter database "odk_database_name" owner to "db_user_name";

-- Connect to ODK DATABASE called odk_database_name
\c "odk_database_name";

create schema "odk_schema_name";
grant all privileges on schema "odk_schema_name" to "odk_user_name";
alter schema "odk_schema_name" owner to "odk_user_name";
3

the problem is Apache Tomcat
when I start the application I get: FAIL -Application Context path / ODKAggregate could not be started

4

So it's not tomcat but Aggregate. The parameters you input are certainly wrong. Or the user does not have sufficient rights.
You should check it with pgadmin or psql (same database / schema / user / host adress)

Maybe you will find some info into the tomcat logs.

5

I'm using windows server 2016 does it affect anything?

6

I don't think so, bu I work on linux so I can't be sure.

7

Can you explain me install odk in Ubuntu server? Please..

8

@Gabriel_Sosa A step-by-step guide is going to be hard because those instructions change frequently.

Have you tried the ODK Aggregate VM? It's Ubuntu-based and is backed by PostgreSQL and very easy to install. Start there and get that working.

Once that's done, then in your Ubuntu machine, try installing Tomcat and PostgreSQL separately. Once those two are confirmed working, then follow the instructions at https://docs.opendatakit.org/aggregate-tomcat/#installation-procedure.

9

A post was split to a new topic: Trouble installing Aggregate with PostgreSQL

10

Hi @yanokwa, by what you wrote, we have two options: The first one is using a VM image to get evething up and running. The second one is using the traditional install and separately get Ubuntu and Postgres. After that ODK Aggregate. Am I right? Sorry i am a "nooby player".
Reagards,
Flávio Veras