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.

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

Hi, Where can I find the jasperserver 3.0 sources? The license from the binary says it's GPL, but I couldn't find the sources anywhere and the scm is blocked for anonymous access or with my jasperforge user. daniel

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

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