Oh, I forgot a rather important step:
2.5) Modify jakarta-jetspeed/build/torque/schema/security-schema.xml
Remove every instance of:
autoincrement="true"
(this breaks on the sequences)
Also, step 6 will complain about missing tables for the ID table (you're
using sequences now, so you don't need that one) and the coffee tables--I
didn't bother with the demo data.
-- Michael
On 4/2/03 8:17 PM, "Michael Rothrock" <[EMAIL PROTECTED]> wrote:
> Ok, but at this point I've gone on to tweak some files for performance.
> Specifically, I'm using sequences instead of the idTable, so I had to change
> a few files, but it gives all appearance of working, at least in my
> environment (RH8, Postgresql 7.2, Jetspeed from yesterday's CVS). I have
> successfully tested anonymous usage, logging in and out, changing passwords,
> and creating new users.
>
> I performed the following steps:
>
> 1) Get the latest Jetspeed source from CVS :)
>
> 2) Modify jakarta-jetspeed/build/torque/build.properties
> You need to tell Torque to generate SQL for Postgresql, so change the line
> that says
> torque.database=hypersonic
> to
> torque.database=postgresql
>
> 3) Build Jetspeed
> ant war
> (or whatever)
>
> 4) Create your jetspeed DB
> createdb jetspeed
>
> 5) Create tables
> Instead of using the prepackaged SQL script, you use the Torque-generated
> one. Go to jakarta-jetspeed/src/sql and run:
> cat security-schema.sql | psql jetspeed
>
> 6) Populate tables
> Using the modified populate-postgres.sql I posted yesterday, do:
> cat populate-postgres.sql | psql jetspeed
>
> 7) Set sequence values beyond existing users
> Start "psql jetspeed" and from the psql prompt issue the following commands:
> select setval('turbine_user_seq', 1000);
> select setval('turbine_group_seq', 1000);
> select setval('turbine_permission_seq', 1000);
> select setval('turbine_role_seq', 1000);
>
> 8) Deploy the war (ok, I actually ran 'ant hotdeploy')
>
> 9) Start tomcat
>
> Cross your fingers. Everything should work.
>
> -- Michael
>
> On 4/2/03 5:19 PM, "Jamie Lerner" <[EMAIL PROTECTED]> wrote:
>
>> Michael,
>>
>> I have been trying to get Postgres to work with
>> Jetspeed 1.4b3 for several weeks with no success. Did
>> you have to change build.properties in the Torque
>> directory and rebuild Jetspeed, or did you just take a
>> fresh build of Jetspeed and change the sql scripts and
>> the torque.properties file?
>>
>> Could you attach the complete set of files you have
>> changed? Thanks in advance.
>>
>> Jamie.
>> --- Michael Rothrock <[EMAIL PROTECTED]>
>> wrote:
>>> NB, it seems to have issues with postgresql 7.3, but
>>> 7.2 (I'm using
>>> 7.2.3-5.80) appears to work.
>>>
>>> -- Michael
>>>
>>> On 4/1/03 6:55 PM, "Michael Rothrock"
>>> <[EMAIL PROTECTED]> wrote:
>>>
>>>> I'm in the process of deploying on postgresql as
>>> well, so I spent some time
>>>> investigating this. Just to be sure my own
>>> settings didn't break anything,
>>>> I started with a completely clean CVS dist, and a
>>> completely new deployment.
>>>>
>>>> 1) I modified the turbine-postgres.sql file,
>>> adding the PASSWORD_CHANGED
>>>> timestamp field. This MUST be the last field in
>>> the table, right after the
>>>> oid.
>>>>
>>>> 2) I modified the populate-postgres.sql script,
>>> adding a NULL value at the
>>>> end of the insert statements for each of the three
>>> users corresponding to
>>>> the new timestamp field.
>>>>
>>>> 3) I deployed and started tomcat. Everything
>>> seemed to work.
>>>>
>>>> The postgresql scripts appear to be incorrect, but
>>> are easy to modify. It
>>>> is *essential* that you put the field in the place
>>> that's specified in the
>>>> Torque schema, though.
>>>>
>>>> Here, I'll attach the modified files.
>>>>
>>>> Good luck!
>>>>
>>>> -- Michael
>>>>
>>>>
>>>>
>>>> On 4/1/03 8:35 AM, "Harald Schl??er"
>>> <[EMAIL PROTECTED]> wrote:
>>>>
>>>>> Hi Scott!
>>>>> Hi Jetspeed-Users!
>>>>>
>>>>> I got it finally. It was a missing line in the
>>> sql script
>>>>> 'turbine-postgres.sql' provided for postgresql.
>>>>> The table 'TURBINE_USER' needed the additional
>>> column 'PASSWORD_CHANGED
>>>>> timestamp'
>>>>> The error was caused by accessing this column.
>>> Don't know why I got this
>>>>> error message.
>>>>>
>>>>> But know I'm fighting the next problem. It seems
>>> to be that type
>>>>> imcompatibility thing
>>>>> as it is described on this site:
>>>>> http://db.apache.org/torque/postgres-howto.html
>>>>>
>>>>> Each time I try to create a new user I end up
>>> with:
>>>>>
>>>>>
>>> org.apache.jetspeed.services.security.UserException:
>>> Failed to create
>>>>> account 'cs': Bad conversion:
>>> java.lang.NumberFormatException: For input
>>>>> string: etc etc...
>>>>> com.workingdogs.village.DataSetException: Bad
>>> conversion:
>>>>> java.lang.NumberFormatException: For input
>>> string: " etc. etc.
>>>>> at com.workingdogs.village.Value.asInt(Unknown
>>> Source)
>>>>> at
>>>
>> com.workingdogs.village.Value.setPreparedStatementValue(Unknown
>>> Source)
>>>>> at
>>>
>> com.workingdogs.village.Record.saveWithInsert(Unknown
>>> Source)
>>>>> at com.workingdogs.village.Record.save(Unknown
>>> Source)
>>>>> at com.workingdogs.village.Record.save(Unknown
>>> Source)
>>>>>
>>>>> etc, etc,
>>>>>
>>>>> What I did so far:
>>>>> 1. Got the newest version of the village api
>>>>> 2. Tried the patch, but I learned that the
>>> version of Field.java doesn't
>>>>> contain
>>>>> the code pieces that should be replaced
>>>>> 3. Got the latest Postgresql JDBC-Driver
>>>>>
>>>>> Still the same.
>>>>>
>>>>> Any ideas?
>>>>>
>>>>> Harry
>>>>>
>>>>> -----Urspr?ngliche Nachricht-----
>>>>> Von: Weaver, Scott [mailto:[EMAIL PROTECTED]
>>>>> Gesendet: Dienstag, 1. April 2003 16:12
>>>>> An: 'Jetspeed Users List'
>>>>> Betreff: RE: Newbie: Can't Jetspeed get starting
>>> with postgresql
>>>>>
>>>>>
>>>>> Hi Harald,
>>>>>
>>>>> Are you sure the Torque OM was built correctly?
>>> Try re-running "war" task
>>>>> and re-deploy. This is what line 166 looks line
>>> in the
>>>>> TurbineUserManagement class.
>>>>>
>>>>> criteria.add(TurbineUserPeer.LOGIN_NAME,
>>> principal.getName());
>>>>>
>>>>> The only thing I can see causing the
>>> NoClassDefFoundError would not being
>>>>> able to load the TurbineUserPeer class.
>>>>>
>>>>> I know it's not much help but it's somewhere to
>>> start.
>>>>>
>>>>> hth,
>>>>>
>>>>> *===================================*
>>>>> * Scott T Weaver??????????????????? *
>>>>> * Jakarta Jetspeed Portal Project?? *
>>>>> * [EMAIL PROTECTED] *
>>>>> *===================================*
>>>>> ?
>>>>>
>>>>>
>>>>>> -----Original Message-----
>>>>>> From: Harald Schl??er
>>> [mailto:[EMAIL PROTECTED]
>>>>>> Sent: Tuesday, April 01, 2003 7:43 AM
>>>>>> To: '[EMAIL PROTECTED]'
>>>>>> Subject: Newbie: Can't Jetspeed get starting
>>> with postgresql
>>>>>>
>>>>>> Dear Jetspeed-with-postgresql-users!
>>>>>>
>>>>>> I want to replace Jetspeeds dafault Hypersonic
>>> database by a
>>>>>> postgresql database. The database is already set
>>> up with the Jetspeed
>>>>>> SQL scripts for postgresql.
>>>>>>
>>>>>> My first impression was that actually everything
>>> is set up properly.
>>>>>> The database runs correctly and a connection
>>> seems to be possible. At
>>>>>> least the database rejects unknown users
>>>>>> in the torque configuration.
>>>>>>
>>>>>> But when I start Jetspeed it ends up with an
>>> error message.
>>>>>>
>>>>>> Are there any configuration secrets?
>>>>>> Could somebody give me an example how to
>>> configure Jetspeed with a
>>>>>> Postgresql database or tell me where I can find
>>> such an example?
>>>>>>
>>>>>>
>>>>>> Here's what Jetspeed says:
>>>>>>
>>>>>> Horrible Exception:
>>> java.lang.NoClassDefFoundError
>>>>>> at
>>>>>>
>>>
>> org.apache.jetspeed.services.security.turbine.TurbineUserManagement.ge
>>>>>> tUse
>>>>>> r(
>>>>>> TurbineUserManagement.java:166)
>>>>>> at
>>>>>>
>>>
>> org.apache.jetspeed.services.JetspeedUserManagement.getUser(JetspeedUserMa
>>>>>> na
>>>>>> gement.java:98)
>>>>>> at
>>>>>>
>>>
>> org.apache.jetspeed.services.security.turbine.TurbineAuthentication.getAno
>>>>>> ny
>>>>>> mousUser(TurbineAuthentication.java:215)
>>>>>> at
>>>>>>
>>>
>> org.apache.jetspeed.services.JetspeedAuthentication.getAnonymousUser(Jetsp
>>>
>> === message truncated ===
>>
>>
>> __________________________________________________
>> Do you Yahoo!?
>> Yahoo! Tax Center - File online, calculators, forms, and more
>> http://tax.yahoo.com
>>
>> ---------------------------------------------------------------------
>> 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]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
