[prev in list] [next in list] [prev in thread] [next in thread] 

List:       jetspeed-user
Subject:    RE: Newbie: Can't Jetspeed get starting with postgresql
From:       nick the mytilian <athanasi () csd ! uoc ! gr>
Date:       2003-11-29 13:21:08
[Download RAW message or body]

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:surender.nagar@smartblue.com.au]
> Sent: Friday, November 14, 2003 5:45 PM
> To: michael@michaelrothrock.com
> Cc: jetspeed-user@jakarta.apache.org
> 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: jetspeed-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
>
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org

[prev in list] [next in list] [prev in thread] [next in thread]