i'm using jetspeed 1.4b4-dev, CVS version from 10 days ago with my own custom Authentication,
RedHat7.3, JDK1.4.0_01 and Ant-1.5 and Tomcat-4.0.4
The security-schema.xml and security-schem.sql have been attached and this is the exception i get :
"Column not found: PER_PER_ID ... " although in the select statement i see : TURBINE_USER.PER_PER_ID ...
can anybody shed some light on this please ?
Horrible Exception: org.apache.jetspeed.services.security.LoginException: Failed to get anonymous user: org.apache.jetspeed.services.security.UserException: Failed to retrieve user 'anon': Column not found: PER_PER_ID in statement [SELECT TURBINE_USER.USER_ID, TURBINE_USER.LOGIN_NAME, TURBINE_USER.PASSWORD_VALUE, TURBINE_USER.FIRST_NAME, TURBINE_USER.LAST_NAME, TURBINE_USER.EMAIL, TURBINE_USER.CONFIRM_VALUE, TURBINE_USER.MODIFIED, TURBINE_USER.CREATED, TURBINE_USER.LAST_LOGIN, TURBINE_USER.DISABLED, TURBINE_USER.LANGUAGE, TURBINE_USER.MATRICULE, TURBINE_USER.TYPFOOT, TURBINE_USER.OBJECTDATA, TURBINE_USER.PASSWORD_CHANGED, TURBINE_USER.PER_PER_ID, TURBINE_USER.SEC_SEC_ID, TURBINE_USER.ORGANIZATION, TURBINE_USER.VASCOTOKEN_SERIAL FROM TURBINE_USER WHERE TURBINE_USER.LOGIN_NAME='anon'] at com.shiftat.jetspeed.modules.security.vasco.VacmanAuthentication.getAnonymousUser(VacmanAuthentication.java:225) at org.apache.jetspeed.services.JetspeedAuthentication.getAnonymousUser(JetspeedAuthentication.java:107) at org.apache.jetspeed.services.JetspeedSecurity.getAnonymousUser(JetspeedSecurity.java:159) at org.apache.jetspeed.modules.actions.TemplateSessionValidator.doPerform(TemplateSessionValidator.java:97) at org.apache.jetspeed.modules.actions.JetspeedSessionValidator.doPerform(JetspeedSessionValidator.java:103) at org.apache.turbine.modules.Action.perform(Action.java:87) at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at org.apache.turbine.Turbine.doGet(Turbine.java:521) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:683) at
--
----------------------------------------------------------------------
ir. Werner Ramaekers
Enterprise Java Solutions Architect - Shift@
Sun Certified Java Programmer - BeJUG steering commitee member
"May the source be with you."
Read my Blog at http://www.werner.be
----------------------------------------------------------------------
DROP TABLE VASCOTOKEN CASCADE CONSTRAINTS; CREATE TABLE VASCOTOKEN( SERIAL VARCHAR(255) NOT NULL, AUTHENTICATIONMODE VARCHAR(2) NOT NULL, MODEL VARCHAR(255) NOT NULL, DPDATA LONG RAW NOT NULL, CONSTRAINT VASCOTOKEN_pk PRIMARY KEY (SERIAL) );
-----------------------------------------------------------------------------
-- TURBINE_USER
-----------------------------------------------------------------------------
DROP TABLE TURBINE_USER CASCADE CONSTRAINTS;
DROP SEQUENCE TURBINE_USER_SEQ;
CREATE TABLE TURBINE_USER
(
USER_ID NUMBER NOT NULL,
LOGIN_NAME VARCHAR2 (64) NOT NULL,
PASSWORD_VALUE VARCHAR2 (32) NOT NULL,
FIRST_NAME VARCHAR2 (99) NOT NULL,
LAST_NAME VARCHAR2 (99) NOT NULL,
EMAIL VARCHAR2 (99),
CONFIRM_VALUE VARCHAR2 (99),
MODIFIED DATE,
CREATED DATE,
LAST_LOGIN DATE,
DISABLED CHAR (1),
LANGUAGE CHAR (2),
MATRICULE CHAR (6),
TYPFOOT CHAR (1),
OBJECTDATA LONG RAW,
PASSWORD_CHANGED DATE,
PER_PER_ID NUMBER (8),
SEC_SEC_ID NUMBER (8),
ORGANIZATION VARCHAR2 (60),
VASCOTOKEN_SERIAL VARCHAR2 (255),
CONSTRAINT TURBINE_USER_U_1 UNIQUE (LOGIN_NAME)
);
ALTER TABLE TURBINE_USER
ADD CONSTRAINT TURBINE_USER_PK
PRIMARY KEY (USER_ID);
ALTER TABLE TURBINE_USER ADD CONSTRAINT TURBINE_USER_PER_FK
FOREIGN KEY (PER_PER_ID)
REFERENCES PERSONNE(PER_ID);
ALTER TABLE TURBINE_USER ADD CONSTRAINT TURBINE_USER_SEC_FK
FOREIGN KEY (SEC_SEC_ID)
REFERENCES SECTCLUB(SEC_ID);
ALTER TABLE TURBINE_USER ADD CONSTRAINT TURBINE_USER_VACOTOKEN_SERIAL_FK
FOREIGN KEY (VASCOTOKEN_SERIAL)
REFERENCES VASCOTOKEN(SERIAL);
CREATE SEQUENCE TURBINE_USER_SEQ INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE
NOCACHE ORDER;
-----------------------------------------------------------------------------
-- TURBINE_ROLE
-----------------------------------------------------------------------------
DROP TABLE TURBINE_ROLE CASCADE CONSTRAINTS;
DROP SEQUENCE TURBINE_ROLE_SEQ;
CREATE TABLE TURBINE_ROLE
(
ROLE_ID NUMBER NOT NULL,
ROLE_NAME VARCHAR2 (99) NOT NULL,
OBJECTDATA LONG RAW,
CONSTRAINT TURBINE_ROLE_U_1 UNIQUE (ROLE_NAME)
);
ALTER TABLE TURBINE_ROLE
ADD CONSTRAINT TURBINE_ROLE_PK
PRIMARY KEY (ROLE_ID);
CREATE SEQUENCE TURBINE_ROLE_SEQ INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE
NOCACHE ORDER;
-----------------------------------------------------------------------------
-- TURBINE_GROUP
-----------------------------------------------------------------------------
DROP TABLE TURBINE_GROUP CASCADE CONSTRAINTS;
DROP SEQUENCE TURBINE_GROUP_SEQ;
CREATE TABLE TURBINE_GROUP
(
GROUP_ID NUMBER NOT NULL,
GROUP_NAME VARCHAR2 (99) NOT NULL,
OBJECTDATA LONG RAW,
CONSTRAINT TURBINE_GROUP_U_1 UNIQUE (GROUP_NAME)
);
ALTER TABLE TURBINE_GROUP
ADD CONSTRAINT TURBINE_GROUP_PK
PRIMARY KEY (GROUP_ID);
CREATE SEQUENCE TURBINE_GROUP_SEQ INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE
NOCACHE ORDER;
-----------------------------------------------------------------------------
-- TURBINE_PERMISSION
-----------------------------------------------------------------------------
DROP TABLE TURBINE_PERMISSION CASCADE CONSTRAINTS;
DROP SEQUENCE TURBINE_PERMISSION_SEQ;
CREATE TABLE TURBINE_PERMISSION
(
PERMISSION_ID NUMBER NOT NULL,
PERMISSION_NAME VARCHAR2 (99) NOT NULL,
OBJECTDATA LONG RAW,
CONSTRAINT TURBINE_PERMISSION_U_1 UNIQUE (PERMISSION_NAME)
);
ALTER TABLE TURBINE_PERMISSION
ADD CONSTRAINT TURBINE_PERMISSION_PK
PRIMARY KEY (PERMISSION_ID);
CREATE SEQUENCE TURBINE_PERMISSION_SEQ INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE
NOCACHE ORDER;
-----------------------------------------------------------------------------
-- TURBINE_ROLE_PERMISSION
-----------------------------------------------------------------------------
DROP TABLE TURBINE_ROLE_PERMISSION CASCADE CONSTRAINTS;
CREATE TABLE TURBINE_ROLE_PERMISSION
(
ROLE_ID NUMBER NOT NULL,
PERMISSION_ID NUMBER NOT NULL
);
ALTER TABLE TURBINE_ROLE_PERMISSION
ADD CONSTRAINT TURBINE_ROLE_PERMISSION_PK
PRIMARY KEY (ROLE_ID,PERMISSION_ID);
-----------------------------------------------------------------------------
-- TURBINE_USER_GROUP_ROLE
-----------------------------------------------------------------------------
DROP TABLE TURBINE_USER_GROUP_ROLE CASCADE CONSTRAINTS;
CREATE TABLE TURBINE_USER_GROUP_ROLE
(
USER_ID NUMBER NOT NULL,
GROUP_ID NUMBER NOT NULL,
ROLE_ID NUMBER NOT NULL
);
ALTER TABLE TURBINE_USER_GROUP_ROLE
ADD CONSTRAINT TURBINE_USER_GROUP_ROLE_PK
PRIMARY KEY (USER_ID,GROUP_ID,ROLE_ID);
ALTER TABLE TURBINE_ROLE_PERMISSION
ADD CONSTRAINT TURBINE_ROLE_PERMISSION_FK_1 FOREIGN KEY (ROLE_ID)
REFERENCES TURBINE_ROLE (ROLE_ID)
ON DELETE CASCADE
;
ALTER TABLE TURBINE_ROLE_PERMISSION
ADD CONSTRAINT TURBINE_ROLE_PERMISSION_FK_2 FOREIGN KEY (PERMISSION_ID)
REFERENCES TURBINE_PERMISSION (PERMISSION_ID)
ON DELETE CASCADE
;
ALTER TABLE TURBINE_USER_GROUP_ROLE
ADD CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_1 FOREIGN KEY (USER_ID)
REFERENCES TURBINE_USER (USER_ID)
ON DELETE CASCADE
;
ALTER TABLE TURBINE_USER_GROUP_ROLE
ADD CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_2 FOREIGN KEY (GROUP_ID)
REFERENCES TURBINE_GROUP (GROUP_ID)
ON DELETE CASCADE
;
ALTER TABLE TURBINE_USER_GROUP_ROLE
ADD CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_3 FOREIGN KEY (ROLE_ID)
REFERENCES TURBINE_ROLE (ROLE_ID)
ON DELETE CASCADE
;
<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?> <!DOCTYPE database SYSTEM "http://jakarta.apache.org/turbine/dtd/database.dtd";> <!-- ==================================================================== --> <!-- --> <!-- B A S E J E T S P E E D S E C U R I T Y S C H E M A --> <!-- --> <!-- ==================================================================== --> <!-- This is the the XML schema used by Torque to generate the necessary --> <!-- sources used to create/initialize the base Jetspeed default security --> <!-- Torque creates SQL for the database required by Jetspeed, and the --> <!-- Peer-based Object Model used by Jetspeed internally to manage --> <!-- users, and security. --> <!-- ==================================================================== --> <!-- @author: <a href="mailto:[EMAIL PROTECTED]";>David Sean Taylor</a> --> <!-- @version $Id: security-schema.xml,v 1.4 2003/01/14 20:54:15 crypto_cvs Exp $ --> <!-- ==================================================================== --> <database> <table name="TURBINE_USER" idMethod="native" > <column name="USER_ID" required="true" primaryKey="true" autoIncrement="true" type="INTEGER"/> <column name="LOGIN_NAME" required="true" size="64" type="VARCHAR"/> <column name="PASSWORD_VALUE" required="true" size="32" type="VARCHAR"/> <column name="FIRST_NAME" required="true" size="99" type="VARCHAR"/> <column name="LAST_NAME" required="true" size="99" type="VARCHAR"/> <column name="EMAIL" size="99" type="VARCHAR"/> <column name="CONFIRM_VALUE" size="99" type="VARCHAR"/> <column name="MODIFIED" type="TIMESTAMP"/> <column name="CREATED" type="TIMESTAMP"/> <column name="LAST_LOGIN" type="TIMESTAMP"/> <column name="DISABLED" size="1" type="CHAR"/> <column name="LANGUAGE" size="2" type="CHAR"/> <column name="MATRICULE" size="6" type="CHAR"/> <column name="TYPFOOT" size="1" type="CHAR"/> <column name="OBJECTDATA" type="BINARY"/> <column name="PASSWORD_CHANGED" type="TIMESTAMP"/> <column name="PER_PER_ID" size="8" type="NUMERIC"/> <column name="SEC_SEC_ID" size="8" type="NUMERIC"/> <column name="ORGANIZATION" size="60" type="VARCHAR"/> <column name="VASCOTOKEN_SERIAL" size="255" type="VARCHAR"/> <unique> <unique-column name="LOGIN_NAME"/> </unique> </table> <table name="TURBINE_ROLE" idMethod="native" > <column name="ROLE_ID" required="true" primaryKey="true" autoIncrement="true" type="INTEGER"/> <column name="ROLE_NAME" required="true" size="99" type="VARCHAR"/> <column name="OBJECTDATA" type="BINARY"/> <unique> <unique-column name="ROLE_NAME"/> </unique> </table> <table name="TURBINE_GROUP" idMethod="native" > <column name="GROUP_ID" required="true" primaryKey="true" autoIncrement="true" type="INTEGER"/> <column name="GROUP_NAME" required="true" type="VARCHAR" size="99"/> <column name="OBJECTDATA" type="BINARY"/> <unique> <unique-column name="GROUP_NAME"/> </unique> </table> <table name="TURBINE_PERMISSION" idMethod="native" > <column name="PERMISSION_ID" required="true" primaryKey="true" autoIncrement="true" type="INTEGER"/> <column name="PERMISSION_NAME" required="true" size="99" type="VARCHAR"/> <column name="OBJECTDATA" type="BINARY"/> <unique> <unique-column name="PERMISSION_NAME"/> </unique> </table> <table name="TURBINE_ROLE_PERMISSION" idMethod="none"> <column name="ROLE_ID" required="true" primaryKey="true" type="INTEGER"/> <column name="PERMISSION_ID" required="true" primaryKey="true" type="INTEGER"/> <foreign-key foreignTable="TURBINE_ROLE" onDelete="cascade"> <reference local="ROLE_ID" foreign="ROLE_ID"/> </foreign-key> <foreign-key foreignTable="TURBINE_PERMISSION" onDelete="cascade"> <reference local="PERMISSION_ID" foreign="PERMISSION_ID"/> </foreign-key> </table> <table name="TURBINE_USER_GROUP_ROLE" idMethod="none"> <column name="USER_ID" required="true" primaryKey="true" type="INTEGER"/> <column name="GROUP_ID" required="true" primaryKey="true" type="INTEGER"/> <column name="ROLE_ID" required="true" primaryKey="true" type="INTEGER"/> <foreign-key foreignTable="TURBINE_USER" onDelete="cascade"> <reference local="USER_ID" foreign="USER_ID"/> </foreign-key> <foreign-key foreignTable="TURBINE_GROUP" onDelete="cascade"> <reference local="GROUP_ID" foreign="GROUP_ID"/> </foreign-key> <foreign-key foreignTable="TURBINE_ROLE" onDelete="cascade"> <reference local="ROLE_ID" foreign="ROLE_ID"/> </foreign-key> </table> </database>
-- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
