Raghdan Rabah wrote:
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 =
The jdbc:odbc bridge is a bad idea. Try the MySQL JDBC driver instead.
It is downloadable from the MySQL website.
###############################
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
