Thank you for the help .... In your test environment, when you added a user, what USER_ID number was created ?
The reason I ask is that I was able to successfully create a new user. The system created a user with USER_ID of 0. When I try to create subsequent users, the proecess fails. I do not see any errors/stack traces in the logs, but the user is not created. I assume that it is trying to create a user with USER_ID = 1 and getting a duplicate record sort of error. I am going to continue to research this, but thought I would see if you have the same issue. Thank you for your help. -----Original Message----- From: David Sean Taylor [mailto:[EMAIL PROTECTED] Sent: Sunday, August 07, 2005 1:27 PM To: Jetspeed Users List Subject: Re: Jetspeed 1.6/Fusion/mysql working for anyone ? 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
