Error logging in to JasperServer 3.0 using postgre

[paulhussein]

Hi, I am running JasperServer on Centos5.2/glassfish/jdk6/postgres8.3

 

I have created a datasourec for Postgres, edited the hibernate properties etc as per the scripts dir for postgres in the jasperserver-3.0-src/jasperserver/scripts/postgresql/
 

 

I then loaded the databases using the two provided sql scripts

jasperserverCreate-postgresql.ddl

jasperserverCreateDefaultSecurity-postgresql.sql

 

 

However when I try to login, i get an error on the console :

this._previouspasswordchangetime doesnt exist.

 

If I look in the mysql ddl it exists in the JIUSER table, but not  in the postgres DDL JIUSER.

 

Am I doing something wrong, or is the postgres DDL out of date ?

 

Paul.

 

 

 

 

 

 

[gabrielinux]

I haven't used JasperServer with a Postgres database, but if mysql has some tables that postrges doesn't, then perhaps you should add them?

[swood]

Gabriel is right. We missed updating the Postgres scripts. You can regenerate them with the correct schema by following the instructions in the Source Buld guide.

 

Sherman

Jaspersoft