JasperServer 3.0 login

[ruoso]

Hi,

 

I've recently installed a JasperServer 3.0 instance on my running tomcat. I haven't changed any condiguration except for it to use PostgreSQL instead of MySQL.

 

I have the 'jasperadmin' user in the table jiuser with the 'password' password in plain text.

 

I can see the login page, but it refuses the user listed in the database. No log messages seems to appear anywhere, any idea on what is causing the problem?

 

 

daniel

Post edited by: ruoso, at: 2008/06/26 12:54

[ruoso]

I've just found that the log of the jasperserver is placed inside the webapp dir (instead of in the standard tomcat log dir), and I have the following errors.

 

The database was created using the given ddl file.

 

09:50:52,908 WARN JDBCExceptionReporter,http-8180-Processor24:77 - SQL Error: 0, SQLState: 42703

09:50:52,918 ERROR JDBCExceptionReporter,http-8180-Processor24:78 - ERROR: column this_.previouspasswordchangetime does not exist

09:50:52,926 WARN LoggerListener,http-8180-Processor24:55 - Authentication event AuthenticationFailureServiceExceptionEvent: jasperadmin; details: org.acegisecurity.ui.WebAuthenticationDetails@fffc7f0c: RemoteIpAddress: 127.0.0.1; SessionId: 5ACEF55367D8C7B8D89152F8A7D3F494; exception: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query; nested exception is org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

Post edited by: ruoso, at: 2008/06/26 12:54

[ruoso]

btw,

 

I tried to guess the column, and it seems to have worked, after doing the following statement

 

alter table jiuser add column previouspasswordchangetime timestamp with time zone;

 

the login started to work.

 

daniel

[gabrielinux]

jasperadmin/jasperadmin

[ruoso]

have you actually read the post?

 

The problem is related to the fact that the description of the schema in the distribution does not match the queries made.

[alex.chan]

ruoso

 

The column jiuser.previouspasswordchangetime is a new one for 3.0. You need to update your db by running the upgradescript or manually add to it. It's datetime type.

 

-Alex