Jetspeed 1.6 resolved -- was RE: Jetspeed 1.6/Fusion/mysql working for anyone ?

[Greg Buchanan <gm...@cfl.rr.com>]

I think I found the answer to my problems. 

In the database DDL scripts directory/zip file, there are two set's of SQL
scripts for Mysql. One in turbine-mysql-4.sql and the other is
turbine-mysql.sql. 

Assuming that turbine-mysql-4.sql was for mysql versions 4 and later, I had
been using that version. In this file, the USER_ID field is not marked as
auto_increment. 

Re-initializing the database with turbine-mysql.sql fixed the problem. 

Anyone know what the "-4" version was for ? 

Thank you all for the help !!!

-----Original Message-----
From: Greg Buchanan [mailto:gmbuchanan@cfl.rr.com] 
Sent: Sunday, August 07, 2005 2:38 PM
To: 'Jetspeed Users List'
Subject: RE: Jetspeed 1.6/Fusion/mysql working for anyone ?


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:david@bluesunrise.com] 
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
david@bluesunrise.com
[office] +01 707 773-4646
[mobile] +01 707 529 9194

---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org