sunbiz
(Saptarshi Purkayastha)
10 November 2010 13:50
1
Hi devs,
The sample database backup for 2.0.5 at http://dhis2.org/downloads cannot be restored using pgadmin
When using pgadmin the ‘OK’ button stays gray. I’ve tried this and some say that plan backups cannot be restored, compressed ones work fine
Also after the command-line restore gives the following exception on login:
Exception (org.hibernate.type.SerializationException): could not deserialize
Caused by (java.io.StreamCorruptedException): invalid stream header: BB656430
···
Regards,
Saptarshi PURKAYASTHA
My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE
olatitle
(Ola Hodne Titlestad)
10 November 2010 22:27
2
Saptarshi,
The file on dhis2.org is a plain text sql dump, despite the name .backup, and not a compressed pgadmin backup. I haven’t tried to restore that in pgadmin, but there might be a problem with that, not sure.
Have you tried to restore this plain text dump from the command line?
A compressed backup of the same database is available here:
http://folk.uio.no/olati/filer/dhis2demo-pg-2.0.5_compressed.backup
Ola,
···
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo
Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link
On 10 November 2010 14:50, Saptarshi Purkayastha sunbiz@gmail.com wrote:
Hi devs,
The sample database backup for 2.0.5 at http://dhis2.org/downloads cannot be restored using pgadmin
When using pgadmin the ‘OK’ button stays gray. I’ve tried this and some say that plan backups cannot be restored, compressed ones work fine
Also after the command-line restore gives the following exception on login:
Exception (org.hibernate.type.SerializationException): could not deserialize
Caused by (java.io.StreamCorruptedException): invalid stream header: BB656430
Regards,
Saptarshi PURKAYASTHA
My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
olatitle
(Ola Hodne Titlestad)
10 November 2010 22:43
3
Hi,
Sorry, what I meant to say is that you should try to load/import this dump file using the psql command and not pg_restore (which pgAdmin uses).
Try:
$psql -q -h localhost -p 5432 -U dhis -W test_db < test.sql
···
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo
Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link
On 10 November 2010 23:27, Ola Hodne Titlestad olati@ifi.uio.no wrote:
Saptarshi,
The file on dhis2.org is a plain text sql dump, despite the name .backup, and not a compressed pgadmin backup. I haven’t tried to restore that in pgadmin, but there might be a problem with that, not sure.
Have you tried to restore this plain text dump from the command line?
A compressed backup of the same database is available here:
http://folk.uio.no/olati/filer/dhis2demo-pg-2.0.5_compressed.backup
Ola,
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo
Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link
On 10 November 2010 14:50, Saptarshi Purkayastha sunbiz@gmail.com wrote:
Hi devs,
The sample database backup for 2.0.5 at http://dhis2.org/downloads cannot be restored using pgadmin
When using pgadmin the ‘OK’ button stays gray. I’ve tried this and some say that plan backups cannot be restored, compressed ones work fine
Also after the command-line restore gives the following exception on login:
Exception (org.hibernate.type.SerializationException): could not deserialize
Caused by (java.io.StreamCorruptedException): invalid stream header: BB656430
Regards,
Saptarshi PURKAYASTHA
My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
sunbiz
(Saptarshi Purkayastha)
10 November 2010 22:59
4
Like I wrote in the first email, the command line restore works fine, but then gives the exception
Then after I clear the usersetting table, the exception goes away.
Adding a new report to view in the dashboard (i.e. changes the usersetting) again throws the exception… Until cleared again, keeps throwing the exception!
···
Regards,
Saptarshi PURKAYASTHA
My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE
On 10 November 2010 23:43, Ola Hodne Titlestad olati@ifi.uio.no wrote:
Hi,
Sorry, what I meant to say is that you should try to load/import this dump file using the psql command and not pg_restore (which pgAdmin uses).
Try:
$psql -q -h localhost -p 5432 -U dhis -W test_db < test.sql
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo
Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link
On 10 November 2010 23:27, Ola Hodne Titlestad olati@ifi.uio.no wrote:
Saptarshi,
The file on dhis2.org is a plain text sql dump, despite the name .backup, and not a compressed pgadmin backup. I haven’t tried to restore that in pgadmin, but there might be a problem with that, not sure.
Have you tried to restore this plain text dump from the command line?
A compressed backup of the same database is available here:
http://folk.uio.no/olati/filer/dhis2demo-pg-2.0.5_compressed.backup
Ola,
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo
Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link
On 10 November 2010 14:50, Saptarshi Purkayastha sunbiz@gmail.com wrote:
Hi devs,
The sample database backup for 2.0.5 at http://dhis2.org/downloads cannot be restored using pgadmin
When using pgadmin the ‘OK’ button stays gray. I’ve tried this and some say that plan backups cannot be restored, compressed ones work fine
Also after the command-line restore gives the following exception on login:
Exception (org.hibernate.type.SerializationException): could not deserialize
Caused by (java.io.StreamCorruptedException): invalid stream header: BB656430
Regards,
Saptarshi PURKAYASTHA
My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
jason
(Jason Pickering)
11 November 2010 08:48
5
Just replaced my Postgres JDBC driver with
http://jdbc.postgresql.org/download/postgresql-9.0-801.jdbc4.jar
and this error does not seem to happen. I can enter the GIS and modify
user settings.
Seems there is level of incompatibility between the version currently
included with 2.0.5 and Postgres 9.
Regards,
Jason
···
On Thu, Nov 11, 2010 at 12:59 AM, Saptarshi Purkayastha <sunbiz@gmail.com> wrote:
Like I wrote in the first email, the command line restore works fine, but
then gives the exception
Then after I clear the usersetting table, the exception goes away.
Adding a new report to view in the dashboard (i.e. changes the usersetting)
again throws the exception... Until cleared again, keeps throwing the
exception!
---
Regards,
Saptarshi PURKAYASTHA
My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE
On 10 November 2010 23:43, Ola Hodne Titlestad <olati@ifi.uio.no> wrote:
Hi,
Sorry, what I meant to say is that you should try to load/import this dump
file using the psql command and not pg_restore (which pgAdmin uses).
Try:
$psql -q -h localhost -p 5432 -U dhis -W test_db < test.sql
----------------------------------
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo
Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link
On 10 November 2010 23:27, Ola Hodne Titlestad <olati@ifi.uio.no> wrote:
Saptarshi,
The file on dhis2.org is a plain text sql dump, despite the name .backup,
and not a compressed pgadmin backup. I haven't tried to restore that in
pgadmin, but there might be a problem with that, not sure.
Have you tried to restore this plain text dump from the command line?
A compressed backup of the same database is available here:
http://folk.uio.no/olati/filer/dhis2demo-pg-2.0.5_compressed.backup
Ola,
----------------------------------
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo
Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link
On 10 November 2010 14:50, Saptarshi Purkayastha <sunbiz@gmail.com> >>> wrote:
Hi devs,
The sample database backup for 2.0.5 at
Downloads - DHIS2 cannot be restored using pgadmin
When using pgadmin the 'OK' button stays gray. I've tried this and some
say that plan backups cannot be restored, compressed ones work fine
Also after the command-line restore gives the following exception on
login:
Exception (org.hibernate.type.SerializationException): could not
deserialize
Caused by (java.io.StreamCorruptedException): invalid stream header:
BB656430
---
Regards,
Saptarshi PURKAYASTHA
My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE
_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help
_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help
--
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+260968395190
Lars
(Lars Øverland)
18 November 2010 07:49
6
For the record, both 2.0.5 and trunk has been updated with latest postgres jdbc driver.
The WAR file on dhis2.org is updated regularly as minor bugs/updates are done:
http://dhis2.org/download/dhis2-2.0.5.war
Lars
···
On Thu, Nov 11, 2010 at 9:48 AM, Jason Pickering jason.p.pickering@gmail.com wrote:
Just replaced my Postgres JDBC driver with
http://jdbc.postgresql.org/download/postgresql-9.0-801.jdbc4.jar
and this error does not seem to happen. I can enter the GIS and modify
user settings.
Seems there is level of incompatibility between the version currently
included with 2.0.5 and Postgres 9.
Regards,
Jason
On Thu, Nov 11, 2010 at 12:59 AM, Saptarshi Purkayastha > sunbiz@gmail.com wrote:
Like I wrote in the first email, the command line restore works fine, but
then gives the exception
Then after I clear the usersetting table, the exception goes away.
Adding a new report to view in the dashboard (i.e. changes the usersetting)
again throws the exception… Until cleared again, keeps throwing the
exception!
Regards,
Saptarshi PURKAYASTHA
My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE
On 10 November 2010 23:43, Ola Hodne Titlestad olati@ifi.uio.no wrote:
Hi,
Sorry, what I meant to say is that you should try to load/import this dump
file using the psql command and not pg_restore (which pgAdmin uses).
Try:
$psql -q -h localhost -p 5432 -U dhis -W test_db < test.sql
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo
Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link
On 10 November 2010 23:27, Ola Hodne Titlestad olati@ifi.uio.no wrote:
Saptarshi,
The file on dhis2.org is a plain text sql dump, despite the name .backup,
and not a compressed pgadmin backup. I haven’t tried to restore that in
pgadmin, but there might be a problem with that, not sure.
Have you tried to restore this plain text dump from the command line?
A compressed backup of the same database is available here:
http://folk.uio.no/olati/filer/dhis2demo-pg-2.0.5_compressed.backup
Ola,
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo
Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link
On 10 November 2010 14:50, Saptarshi Purkayastha sunbiz@gmail.com > > >>> wrote:
Hi devs,
The sample database backup for 2.0.5 at
http://dhis2.org/downloads cannot be restored using pgadmin
When using pgadmin the ‘OK’ button stays gray. I’ve tried this and some
say that plan backups cannot be restored, compressed ones work fine
Also after the command-line restore gives the following exception on
login:
Exception (org.hibernate.type.SerializationException): could not
deserialize
Caused by (java.io.StreamCorruptedException): invalid stream header:
BB656430
Regards,
Saptarshi PURKAYASTHA
My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
–
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+260968395190
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
sunbiz
(Saptarshi Purkayastha)
18 November 2010 15:47
7
Should it be called 2.0.5. based on the branch revision??
Just my 2 cents
···
Regards,
Saptarshi PURKAYASTHA
My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE
2010/11/18 Lars Helge Øverland larshelge@gmail.com
For the record, both 2.0.5 and trunk has been updated with latest postgres jdbc driver.
The WAR file on dhis2.org is updated regularly as minor bugs/updates are done:
http://dhis2.org/download/dhis2-2.0.5.war
Lars
On Thu, Nov 11, 2010 at 9:48 AM, Jason Pickering jason.p.pickering@gmail.com wrote:
Just replaced my Postgres JDBC driver with
http://jdbc.postgresql.org/download/postgresql-9.0-801.jdbc4.jar
and this error does not seem to happen. I can enter the GIS and modify
user settings.
Seems there is level of incompatibility between the version currently
included with 2.0.5 and Postgres 9.
Regards,
Jason
On Thu, Nov 11, 2010 at 12:59 AM, Saptarshi Purkayastha > > sunbiz@gmail.com wrote:
Like I wrote in the first email, the command line restore works fine, but
then gives the exception
Then after I clear the usersetting table, the exception goes away.
Adding a new report to view in the dashboard (i.e. changes the usersetting)
again throws the exception… Until cleared again, keeps throwing the
exception!
Regards,
Saptarshi PURKAYASTHA
My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE
On 10 November 2010 23:43, Ola Hodne Titlestad olati@ifi.uio.no wrote:
Hi,
Sorry, what I meant to say is that you should try to load/import this dump
file using the psql command and not pg_restore (which pgAdmin uses).
Try:
$psql -q -h localhost -p 5432 -U dhis -W test_db < test.sql
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo
Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link
On 10 November 2010 23:27, Ola Hodne Titlestad olati@ifi.uio.no wrote:
Saptarshi,
The file on dhis2.org is a plain text sql dump, despite the name .backup,
and not a compressed pgadmin backup. I haven’t tried to restore that in
pgadmin, but there might be a problem with that, not sure.
Have you tried to restore this plain text dump from the command line?
A compressed backup of the same database is available here:
http://folk.uio.no/olati/filer/dhis2demo-pg-2.0.5_compressed.backup
Ola,
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo
Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link
On 10 November 2010 14:50, Saptarshi Purkayastha sunbiz@gmail.com > > > > >>> wrote:
Hi devs,
The sample database backup for 2.0.5 at
http://dhis2.org/downloads cannot be restored using pgadmin
When using pgadmin the ‘OK’ button stays gray. I’ve tried this and some
say that plan backups cannot be restored, compressed ones work fine
Also after the command-line restore gives the following exception on
login:
Exception (org.hibernate.type.SerializationException): could not
deserialize
Caused by (java.io.StreamCorruptedException): invalid stream header:
BB656430
Regards,
Saptarshi PURKAYASTHA
My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
–
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+260968395190
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Lars
(Lars Øverland)
18 November 2010 16:26
8
Should it be called 2.0.5. based on the branch revision??
Just my 2 cents
I don’t think its worth the effort… We can always get the revision from the About page…
···
2010/11/18 Saptarshi Purkayastha sunbiz@gmail.com
Regards,
Saptarshi PURKAYASTHA
My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE
2010/11/18 Lars Helge Øverland larshelge@gmail.com
For the record, both 2.0.5 and trunk has been updated with latest postgres jdbc driver.
The WAR file on dhis2.org is updated regularly as minor bugs/updates are done:
http://dhis2.org/download/dhis2-2.0.5.war
Lars
On Thu, Nov 11, 2010 at 9:48 AM, Jason Pickering jason.p.pickering@gmail.com wrote:
Just replaced my Postgres JDBC driver with
http://jdbc.postgresql.org/download/postgresql-9.0-801.jdbc4.jar
and this error does not seem to happen. I can enter the GIS and modify
user settings.
Seems there is level of incompatibility between the version currently
included with 2.0.5 and Postgres 9.
Regards,
Jason
On Thu, Nov 11, 2010 at 12:59 AM, Saptarshi Purkayastha > > > sunbiz@gmail.com wrote:
Like I wrote in the first email, the command line restore works fine, but
then gives the exception
Then after I clear the usersetting table, the exception goes away.
Adding a new report to view in the dashboard (i.e. changes the usersetting)
again throws the exception… Until cleared again, keeps throwing the
exception!
Regards,
Saptarshi PURKAYASTHA
My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE
On 10 November 2010 23:43, Ola Hodne Titlestad olati@ifi.uio.no wrote:
Hi,
Sorry, what I meant to say is that you should try to load/import this dump
file using the psql command and not pg_restore (which pgAdmin uses).
Try:
$psql -q -h localhost -p 5432 -U dhis -W test_db < test.sql
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo
Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link
On 10 November 2010 23:27, Ola Hodne Titlestad olati@ifi.uio.no wrote:
Saptarshi,
The file on dhis2.org is a plain text sql dump, despite the name .backup,
and not a compressed pgadmin backup. I haven’t tried to restore that in
pgadmin, but there might be a problem with that, not sure.
Have you tried to restore this plain text dump from the command line?
A compressed backup of the same database is available here:
http://folk.uio.no/olati/filer/dhis2demo-pg-2.0.5_compressed.backup
Ola,
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo
Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link
On 10 November 2010 14:50, Saptarshi Purkayastha sunbiz@gmail.com > > > > > > >>> wrote:
Hi devs,
The sample database backup for 2.0.5 at
http://dhis2.org/downloads cannot be restored using pgadmin
When using pgadmin the ‘OK’ button stays gray. I’ve tried this and some
say that plan backups cannot be restored, compressed ones work fine
Also after the command-line restore gives the following exception on
login:
Exception (org.hibernate.type.SerializationException): could not
deserialize
Caused by (java.io.StreamCorruptedException): invalid stream header:
BB656430
Regards,
Saptarshi PURKAYASTHA
My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
–
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+260968395190
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp