Hello, I have jetspeed on WIN2000. I did install mysql-4.1.3b and MySQL ODBC 3.51. Then I have built jetspeed database using: - turbine-mysql.sql - dbpsml-schema.sql - populate-mysql.sql
Also, in Torque.properties, i added: ############################### #R torque.dsfactory.default.connection.driver = org.hsqldb.jdbcDriver #R torque.dsfactory.default.connection.url = jdbc:hsqldb:${webappRoot}/WEB- INF/db/jetspeed #R torque.dsfactory.default.connection.user = sa #R torque.dsfactory.default.connection.password = torque.dsfactory.default.connection.driver = sun.jdbc.odbc.JdbcOdbcDriver torque.dsfactory.default.connection.url = jdbc:odbc:jetspeed2 torque.dsfactory.default.connection.user = root torque.dsfactory.default.connection.password = ############################### Still, jetspeed gives the following LoginException and SQLException: There has been an Error! Reason: org.apache.jetspeed.services.security.LoginException: Failed to get anonymous user: : Failed to retrieve user 'anon': [MySQL][ODBC 3.51 Driver] [mysqld-4.1.3b-beta-nt]Unknown column 'TURBINE_USER.PASSWORD_CHANGED' in 'field list' Get/Post Data: password = jetspeed template = ShowError.vm action = JLoginUser submit = Login username = admin Stacktrace: java.sql.SQLException: [MySQL][ODBC 3.51 Driver][mysqld-4.1.3b-beta- nt]Unknown column 'TURBINE_USER.PASSWORD_CHANGED' in 'field list' at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115) at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3111) at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338) at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery (JdbcOdbcStatement.java:253) at com.workingdogs.village.QueryDataSet.(Unknown Source) at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1539) at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1391) . . . $StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:163) at . . . Any help in how to solve this? Regards --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]