ODKAggregate [How to use different DB]

Hello Team,

I have configured ODK Aggregate on Linux.

Now we want separate DB server.

Could you please help me out for these changes.

My Server Details:

OS : RHEL 7.2_x86_64 bit

Database : Postgres (running on 127.0.0.1)

Thanks.
Sonu Kumar Gupta

You should just be able to set up a different server with the database.

Then run the ODK Aggregate installer and specify the correct
"Database server hostname" for that server. This will not be 127.0.0.1.

The create_db_and_user.sql script will then set up the database with the
required access permissions for the ODK Aggregate server to be able to
access the PostgreSQL database.

If you are migrating an existing database to this new server, you will need
to adapt that creation script to make things work.

See
https://opendatakit.org/use/aggregate/tomcat-install/#Configure_for_Network_Access
for issues about making (any) server have a known fixed IP address and/or
DNS name. In this case, your database server does not need to be visible
from the internet, but it needs to be reachable from the server running
your ODK Aggregate server.

ยทยทยท =====================

Good luck. We can't provide assistance beyond this.

On Tue, Aug 2, 2016 at 1:28 AM, sonu.ccna@gmail.com wrote:

Hello Team,

I have configured ODK Aggregate on Linux.

Now we want separate DB server.

Could you please help me out for these changes.

My Server Details:

OS : RHEL 7.2_x86_64 bit

Database : Postgres (running on 127.0.0.1)

Thanks.
Sonu Kumar Gupta

--
You received this message because you are subscribed to the Google Groups
"ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com