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]
