thank you, taht solved my problem :)

-----Ursprungliche Nachricht-----
Von: Kenji Ichikawa [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 7. Februar 2003 02:19
An: Jetspeed Users List; [EMAIL PROTECTED]
Betreff: Re: problems with adding a new user



Hello!

I've fixed this problem.

First, you have to modify the definition of table 'TURBINE_USER'
in 'security-schema.xml' that is included in source code archive
of Jetspeed 1.4b3.

Like below

   <!--<table name="TURBINE_USER" idMethod="native" >-->
   <table name="TURBINE_USER" idmethod="idbroker" >
     <!--<column name="USER_ID" required="true" primaryKey="true"
     autoIncrement="true" type="INTEGER"/>-->
     <column name="USER_ID" required="true" primarykey="true"
type="INTEGER"/>
     <column name="LOGIN_NAME" required="true" size="32"
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="OBJECTDATA" type="BINARY"/>
     <column name="PASSWORD_CHANGED" type="TIMESTAMP"/>
     <unique>
       <unique-column name="LOGIN_NAME"/>
     </unique>
   </table>

And, you have to rebuild Jetspeed.

I'm using Jetspeed 1.4b3 with PostgreSQL 7.3.1 with no problem !



At 午前 11:06 03/02/06 +0100, Markus Strau゜ wrote:

>hello,
>
>I managed to get Jetspeed running with a Postgresql database. When
using
>the 1.4.1b-release, everything seems fine. but switching to
>1.4.3b-release, well I could build it, and start it. but I wasn't able
>to add any new user, as Jetspeed kept telling me: setting a multiple
key
>to a unique attribute (user_id). So I'd like to know: Can I fix this
>easily and migrate to 1.4.3, or should I stay with my good working
>1.4.1?
>
>tia
>
>Mit freundlichen Gr?en / With best regards
>
>Markus Strau゜
>
>Softwareentwickler
>KRUSCHE LAGERTECHNIK AG
>Am Kleinfeld 11
>85456 Wartenberg
>Tel.: 08762/7259 22
>Fax.: 08762/7259 99
>[EMAIL PROTECTED]
>www.klt-ag.de
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]

------------------------------
Kenji Ichikawa
mailto:[EMAIL PROTECTED]
http://www.acvt.co.jp/


---------------------------------------------------------------------
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]


Reply via email to