Greg Buchanan wrote:
I have been trying to get Jetspeed 1.6 w/Fusion and mysql working for some
time now.
Regardless of building from source or using 1.6 binary distribution, I
always end up with the following error when trying to subscribe as a user:
Exception: Failed to retrieve user 'greg': java.sql.SQLException: Cannot
convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP.
A user record is successfully created in the turbine_user table in the
database, but the LAST_LOGIN column (column 10) is not initialized.
Has anyone successfully gotten this configuration to work ? Is this a known
problem ?
OK, Im working my way back through emails, so ignore my question about
which database you are using on another thread. Its MySQL.
I've just configured Jetspeed 1.6 with MySQL (not with Fusion, but this
problem seems unrelated to Fusion), followed the instructions here:
http://portals.apache.org/jetspeed-1/database.html
and then created a user (via the Admin administration), and it created
fine. The LAST_LOGIN field was correctly updated
I am using mysql 4.1.12a, tomcat 5.5.9 binary distribution.
As an alternative, if I stick with the hsql database, how many users can
this database realistically support on a 1.0Ghz, 512M memory class of
machine ?
I wouldn't recommend using it in production
--
David Sean Taylor
Bluesunrise Software
[EMAIL PROTECTED]
[office] +01 707 773-4646
[mobile] +01 707 529 9194
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
