Hello, You advise to get the security-schema.xml file from version 14b1 of jetspeed, in order to get it play with postgres.
But, the installation instructions just say what to do with the *.sql files (security-schema.sql, turbine-postgres.sql, populate.postgres.sql). What can i do with the security-schema.xml file? Anyway, after two months of trying to get postgres (7.1.3) run with my jetspeed (source code from CVS), i am stuck in the following exception: org.apache.jetspeed.services.security.UserException: Failed to create account 'nikos': ERROR: ExecAppend: Fail to add null value in not null attribute user_id This happens at the time i try to add a new user. Following some emails in the jetspeed-dev, jetspeed-user lists, here is what i did: I configured properly my Torque.properties file. In the turbine-postgres.sql file changed the OBJECTDATA field to "OBJECTDATA bytea" . I also added in the CREATE TABLE TURBINE_USER statement the field PASSWORD_CHANGED timestamp before the PRIMARY KEY(USER_ID) field. In the populate-postgres.sql file added a null value in each of 3 INSERT INTO TURBINE_USER VALUES commands. If anyone has already faced all these things and could help me to find out what is going on, please dont keep the solution a secret... Nik. On Mon, 17 Nov 2003, Michael Bishop wrote: > 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] > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]