OK, it's been awhile since I've worked with Jetspeed. I'm hoping I can help you out and I hope other people on the list can benefit from this. I figured out how to do this by scouring the mail archives.
1. Get the latest version of Jetspeed. At the time I did this, the "latest" version was 1.4b4. I don't know if that makes a difference. 2. Get the source for Jetspeed version 1.4b1. I believe what you need from here is the security-schema.xml. This one's supposedly correct for Postgresql. Details are fuzzy, but I'm pretty sure this is the only file you need to copy from 1.4b1 and simply replace it in your latest build. 3. In turbine-postgres.sql, change all instances of datatype "oid" to datatype "bytea". 4. Run your scripts to create the Postgresql database. 5. Build your WAR file from source and deploy. Hope this helps somewhat. It's been some time. I can't remember all the steps I followed, but I'm looking at my deployed server and the directory I built from. Michael Bishop -----Original Message----- From: Surender Kumar Nagar [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 5:45 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Newbie: Can't Jetspeed get starting with postgresql Hi Michael, I am sending you this email as you have successfully resolved issue with Postgresql. I have downloaded the latest version of jetspeed 1.4 and successfully installed it on XP Professional. I want to change the database to Postgresql 7.3.2 for Windows. I have tested the connection to database with a java test program as well. I have looked at the resolution you provided on mailing list. I have tried all the steps but unable to run Jetspeed with Postgresql. 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 I get following error: org.apache.turbine.util.TurbineException: Error rendering Velocity template: /controls/html/jetspeed.vm: Invocation of method 'getContent' in class org.apache.jetspeed.portal.security.portlets.CacheableStatefulPortletWra pper threw exception class java.lang.Error : Error in BasePeer.initTableSchema(TURBINE_USER): There was no DataSourceFactory configured for the connection default Here are my Torque.properties settings. torque.database.default.adapter=postgresql torque.dsfactory.default.connection.driver = org.postgresql.Driver torque.dsfactory.default.connection.url = jdbc:postgresql://localhost:5432/jetspeed torque.dsfactory.default.connection.user = postgres torque.dsfactory.default.connection.password = Any help in this regard will be appreciable. I have been trying to make it work for last 10 days :-( Thank you, Surender --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]