RE: sql script error

[Hugh Brien <hu...@novuscg.com>]

In case you did not get this working, an additional field was added to the 
schema between 1.4b1 and present time.  if you check out the source you can build it.
TURBINE_USER was the only one that changed. Here it is.

CREATE TABLE TURBINE_USER (
  USER_ID int(11) NOT NULL auto_increment,
  LOGIN_NAME varchar(32) NOT NULL default '',
  PASSWORD_VALUE varchar(32) NOT NULL default '',
  FIRST_NAME varchar(99) NOT NULL default '',
  LAST_NAME varchar(99) NOT NULL default '',
  EMAIL varchar(99) default NULL,
  CONFIRM_VALUE varchar(99) default NULL,
  MODIFIED timestamp(14) NOT NULL,
  CREATED timestamp(14) NOT NULL,
  LAST_LOGIN timestamp(14) NOT NULL,
  DISABLED char(1) default NULL,
  OBJECTDATA mediumblob,
  PASSWORD_CHANGED timestamp(14) NOT NULL,
  PRIMARY KEY  (USER_ID),
  UNIQUE KEY LOGIN_NAME (LOGIN_NAME)
) TYPE=MyISAM;



-----Original Message-----
From: Stephen Jackson [mailto:swjackso@tampabay.rr.com]
Sent: Saturday, October 12, 2002 2:43 PM
To: jetspeed-dev@jakarta.apache.org
Subject: sql script error


I downloaded the nightly build from 10.12.2002.  
I installed it with the following configuration

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.0_01-b03)
Java HotSpot(TM) Client VM (build 1.4.0_01-b03, mixed mode)

Tomcat 4.1.12 

Postgresql 7.2
I started it up and got the following exception:

Horrible Exception: org.apache.jetspeed.services.security.LoginException: 
Failed to get anonymous user: 
org.apache.jetspeed.services.security.UserException: Failed to retrieve user 
'anon': ERROR:  No such attribute or function 'password_changed'
at 
org.apache.jetspeed.services.security.turbine.TurbineAuthentication.getAnonymousUser(TurbineAuthentication.java:225)
at 
org.apache.jetspeed.services.JetspeedAuthentication.getAnonymousUser(JetspeedAuthentication.java:107)
at 
org.apache.jetspeed.services.JetspeedSecurity.getAnonymousUser(JetspeedSecurity.java:159)

I added password_changed column to the turbine_user table in the file 
turbine-postgresql.sql.  I also updated the populate-postgresql.sql so they 
were in sync.  This fixed the problem.  

I stopped and started tomcat and tried to create a new user.  I got the 
following exception. I was not sure if it was related to the table 
mis-alignment. 

Caused by: org.apache.jetspeed.services.security.UserException: Failed to 
create account 'newuser': Bad conversion: java.lang.NumberFormatException: 
’␀ sr␀ java.util.Hashtable » %!Jä¸ ␀ F␀
loadFactorI␀thresholdxp?@␀␀␀␀␀␀w ␀␀␀ ␀␀␀␀x
at 
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser(TurbineUserManagement.java:316)
at 
org.apache.jetspeed.services.JetspeedUserManagement.addUser(JetspeedUserManagement.java:134)
at 
org.apache.jetspeed.services.JetspeedSecurity.addUser(JetspeedSecurity.java:238)
at 
org.apache.jetspeed.modules.actions.portlets.security.UserUpdateAction.doInsert(UserUpdateAction.java:251)
... 43 more

Thanks,

Stephen Jackson

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>