Unable to upgrade from ODKAggregate 1.4.12 to 1.4.13

Piyush_Shah · March 11, 2017, 11:30am

Hi,

I am currently using ODKAggregate 1.4.12 with Postgresql 9.1, JAVA 7,
Tomcat 6.0.35.

Now I am trying to upgrade from 1.4.12 to 1.4.13 for that I replace Tomcat
6.0.35 to Tomcat 8.5.11 and placed "postgresql-9.1-903.jdbc4.jar" file into
Tomcat 8.5.11 lib folder. After doing all the configuration tomcat is
running fine but ODKAggregate 1.4.13 shows "HTTP Status 404 -
/ODKAggregate" page.

Can anyone guide me how to configure JDBC 4 libraries for postgresql9.1
because I think due to improper configuration of JDBC libraries
ODKAggregate 1.4.13 raising an error?

So can anyone help me how to solve above issue?

Thank You

Regards,
Piyush

Piyush_Shah · March 11, 2017, 11:41am

Some more additional information.

Operating System - Windows Server 2008 Enterprises. 32 Bit

···

On Saturday, 11 March 2017 17:00:24 UTC+5:30, Piyush Shah wrote: > > Hi, > > I am currently using ODKAggregate 1.4.12 with Postgresql 9.1, JAVA 7, > Tomcat 6.0.35. > > Now I am trying to upgrade from 1.4.12 to 1.4.13 for that I replace Tomcat > 6.0.35 to Tomcat 8.5.11 and placed "postgresql-9.1-903.jdbc4.jar" file into > Tomcat 8.5.11 lib folder. After doing all the configuration tomcat is > running fine but ODKAggregate 1.4.13 shows "HTTP Status 404 - > /ODKAggregate" page. > > Can anyone guide me how to configure JDBC 4 libraries for postgresql9.1 > because I think due to improper configuration of JDBC libraries > ODKAggregate 1.4.13 raising an error? > > So can anyone help me how to solve above issue? > > Thank You > > Regards, > Piyush > >

Mitch_S · March 13, 2017, 4:36pm

You should upgrade your PostgreSQL server to the latest release when you do
this upgrade.

I've updated the upgrade instructions to include a missing command to issue
on the PostgreSQL. See

···

On Sat, Mar 11, 2017 at 3:41 AM, Piyush Shah wrote:

Some more additional information.

Operating System - Windows Server 2008 Enterprises. 32 Bit

On Saturday, 11 March 2017 17:00:24 UTC+5:30, Piyush Shah wrote:

Hi,

I am currently using ODKAggregate 1.4.12 with Postgresql 9.1, JAVA 7,
Tomcat 6.0.35.

Now I am trying to upgrade from 1.4.12 to 1.4.13 for that I replace
Tomcat 6.0.35 to Tomcat 8.5.11 and placed "postgresql-9.1-903.jdbc4.jar"
file into Tomcat 8.5.11 lib folder. After doing all the configuration
tomcat is running fine but ODKAggregate 1.4.13 shows "HTTP Status 404 -
/ODKAggregate" page.

Can anyone guide me how to configure JDBC 4 libraries for postgresql9.1
because I think due to improper configuration of JDBC libraries
ODKAggregate 1.4.13 raising an error?

So can anyone help me how to solve above issue?

Thank You

Regards,
Piyush

--
--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

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

Piyush_Shah · March 15, 2017, 6:17am

Dear Mitch Sundt,

Thank you for replying.

As I am trying to upgrade my production server from 1.4.12 to 1.4.13, so if
you can guide me how to transfer all the databases from my existing
PostgreSQL 9.1 to 9.4 database or higher or suggest any other method
achieve it.

Regards,

···

On Mon, Mar 13, 2017 at 10:06 PM, Mitch Sundt wrote:

You should upgrade your PostgreSQL server to the latest release when you
do this upgrade.

I've updated the upgrade instructions to include a missing command to
issue on the PostgreSQL. See https://github.com/
opendatakit/opendatakit/wiki/Aggregate-Release-Notes#aggregate-v1413

On Sat, Mar 11, 2017 at 3:41 AM, Piyush Shah piyushsh18@gmail.com wrote:

Some more additional information.

Operating System - Windows Server 2008 Enterprises. 32 Bit

On Saturday, 11 March 2017 17:00:24 UTC+5:30, Piyush Shah wrote:

Hi,

I am currently using ODKAggregate 1.4.12 with Postgresql 9.1, JAVA 7,
Tomcat 6.0.35.

Now I am trying to upgrade from 1.4.12 to 1.4.13 for that I replace
Tomcat 6.0.35 to Tomcat 8.5.11 and placed "postgresql-9.1-903.jdbc4.jar"
file into Tomcat 8.5.11 lib folder. After doing all the configuration
tomcat is running fine but ODKAggregate 1.4.13 shows "HTTP Status 404 -
/ODKAggregate" page.

Can anyone guide me how to configure JDBC 4 libraries for postgresql9.1
because I think due to improper configuration of JDBC libraries
ODKAggregate 1.4.13 raising an error?

So can anyone help me how to solve above issue?

Thank You

Regards,
Piyush

--
--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

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

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/
topic/opendatakit/gfYiW6o6blU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Piyush M Shah

GIS Professional

M.Sc (Geomatics and Space Application), M.Sc (IT and CA)

Phone: +91-79-22860917

Mobile: 09408721451

Mitch_S · March 16, 2017, 5:26pm

Follow the instructions on the PostgreSQL site.

There is usually a backup - upgrade - restore sequence that the database
software demands.

As long as you don't rename the database or modify the contents, you should
be able to use the same database parameters in the ODK Aggregate installer
and everything will work.

···

On Tue, Mar 14, 2017 at 11:17 PM, Piyush Shah wrote:

Dear Mitch Sundt,

Thank you for replying.

As I am trying to upgrade my production server from 1.4.12 to 1.4.13, so
if you can guide me how to transfer all the databases from my existing
PostgreSQL 9.1 to 9.4 database or higher or suggest any other method
achieve it.

Regards,

On Mon, Mar 13, 2017 at 10:06 PM, Mitch Sundt mitchellsundt@gmail.com wrote:

You should upgrade your PostgreSQL server to the latest release when you
do this upgrade.

I've updated the upgrade instructions to include a missing command to
issue on the PostgreSQL. See https://github.com/opendat
akit/opendatakit/wiki/Aggregate-Release-Notes#aggregate-v1413

On Sat, Mar 11, 2017 at 3:41 AM, Piyush Shah piyushsh18@gmail.com wrote:

Some more additional information.

Operating System - Windows Server 2008 Enterprises. 32 Bit

On Saturday, 11 March 2017 17:00:24 UTC+5:30, Piyush Shah wrote:

Hi,

I am currently using ODKAggregate 1.4.12 with Postgresql 9.1, JAVA 7,
Tomcat 6.0.35.

Now I am trying to upgrade from 1.4.12 to 1.4.13 for that I replace
Tomcat 6.0.35 to Tomcat 8.5.11 and placed "postgresql-9.1-903.jdbc4.jar"
file into Tomcat 8.5.11 lib folder. After doing all the configuration
tomcat is running fine but ODKAggregate 1.4.13 shows "HTTP Status 404 -
/ODKAggregate" page.

Can anyone guide me how to configure JDBC 4 libraries for postgresql9.1
because I think due to improper configuration of JDBC libraries
ODKAggregate 1.4.13 raising an error?

So can anyone help me how to solve above issue?

Thank You

Regards,
Piyush

--
--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

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

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/to
pic/opendatakit/gfYiW6o6blU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Piyush M Shah

GIS Professional

M.Sc (Geomatics and Space Application), M.Sc (IT and CA)

Phone: +91-79-22860917 <+91%2079%202286%200917>

Mobile: 09408721451

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

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

Piyush_Shah · March 17, 2017, 4:50am

Dear Mitch Sundt,

Thank you for reply!

I will follow your suggestion and try to upgrade.