You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by "David Sean Taylor (JIRA)" <je...@portals.apache.org> on 2006/11/20 22:39:08 UTC
[jira] Created: (JS1-565) Postgresql Support for Jetspeed 1.6
Postgresql Support for Jetspeed 1.6
-----------------------------------
Key: JS1-565
URL: http://issues.apache.org/jira/browse/JS1-565
Project: Jetspeed
Issue Type: Bug
Components: Database
Affects Versions: 1.6
Reporter: David Sean Taylor
Assigned To: David Sean Taylor
Priority: Minor
Fix For: 1.6-dev
Im attaching SQL scripts for Postgresql
They work for me. Please test
The attached build.xml has three new targets: drops, ddl, populate
You can run something like:
ant drops ddl populate
Place the attached 3 SQL files in src/sql/external directory
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org
[jira] Commented: (JS1-565) Postgresql Support for Jetspeed 1.6
Posted by "David Sean Taylor (JIRA)" <je...@portals.apache.org>.
[ http://issues.apache.org/jira/browse/JS1-565?page=comments#action_12451444 ]
David Sean Taylor commented on JS1-565:
---------------------------------------
Forgot to mention, you will need to edit the build.xml to set the path to your posgresql jdbc driver
> Postgresql Support for Jetspeed 1.6
> -----------------------------------
>
> Key: JS1-565
> URL: http://issues.apache.org/jira/browse/JS1-565
> Project: Jetspeed
> Issue Type: Bug
> Components: Database
> Affects Versions: 1.6
> Reporter: David Sean Taylor
> Assigned To: David Sean Taylor
> Priority: Minor
> Fix For: 1.6-dev
>
> Attachments: build.xml, drops.sql, populate-postgres.sql, turbine-postgres.sql
>
>
> Im attaching SQL scripts for Postgresql
> They work for me. Please test
> The attached build.xml has three new targets: drops, ddl, populate
> You can run something like:
> ant drops ddl populate
> Place the attached 3 SQL files in src/sql/external directory
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org
[jira] Updated: (JS1-565) Postgresql Support for Jetspeed 1.6
Posted by "David Sean Taylor (JIRA)" <je...@portals.apache.org>.
[ http://issues.apache.org/jira/browse/JS1-565?page=all ]
David Sean Taylor updated JS1-565:
----------------------------------
Attachment: turbine-postgres.sql
drop this file in src/sql/external
> Postgresql Support for Jetspeed 1.6
> -----------------------------------
>
> Key: JS1-565
> URL: http://issues.apache.org/jira/browse/JS1-565
> Project: Jetspeed
> Issue Type: Bug
> Components: Database
> Affects Versions: 1.6
> Reporter: David Sean Taylor
> Assigned To: David Sean Taylor
> Priority: Minor
> Fix For: 1.6-dev
>
> Attachments: build.xml, drops.sql, populate-postgres.sql, turbine-postgres.sql
>
>
> Im attaching SQL scripts for Postgresql
> They work for me. Please test
> The attached build.xml has three new targets: drops, ddl, populate
> You can run something like:
> ant drops ddl populate
> Place the attached 3 SQL files in src/sql/external directory
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org
[jira] Updated: (JS1-565) Postgresql Support for Jetspeed 1.6
Posted by "David Sean Taylor (JIRA)" <je...@portals.apache.org>.
[ http://issues.apache.org/jira/browse/JS1-565?page=all ]
David Sean Taylor updated JS1-565:
----------------------------------
Attachment: drops.sql
place this file in src/sql/external
> Postgresql Support for Jetspeed 1.6
> -----------------------------------
>
> Key: JS1-565
> URL: http://issues.apache.org/jira/browse/JS1-565
> Project: Jetspeed
> Issue Type: Bug
> Components: Database
> Affects Versions: 1.6
> Reporter: David Sean Taylor
> Assigned To: David Sean Taylor
> Priority: Minor
> Fix For: 1.6-dev
>
> Attachments: build.xml, drops.sql, populate-postgres.sql, turbine-postgres.sql
>
>
> Im attaching SQL scripts for Postgresql
> They work for me. Please test
> The attached build.xml has three new targets: drops, ddl, populate
> You can run something like:
> ant drops ddl populate
> Place the attached 3 SQL files in src/sql/external directory
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org
[jira] Commented: (JS1-565) Postgresql Support for Jetspeed 1.6
Posted by "David Sean Taylor (JIRA)" <je...@portals.apache.org>.
[ https://issues.apache.org/jira/browse/JS1-565?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12465600 ]
David Sean Taylor commented on JS1-565:
---------------------------------------
Full support for Postgresql with Add User support
Updated Postgresql scripts
Added a little tester goals for creating and population db (dbdrops, db, dbpop)
Requirements to run:
1. Postgresql version of torque-om jar
2. only tested on Postgresql server 8.1.5
3. only tested on driver postgresql-8.1-407.jdbc3.jar
4. only tested on Jetspeed trunk
see commit list here:
http://svn.apache.org/viewvc?view=rev&revision=497236
> Postgresql Support for Jetspeed 1.6
> -----------------------------------
>
> Key: JS1-565
> URL: https://issues.apache.org/jira/browse/JS1-565
> Project: Jetspeed
> Issue Type: Bug
> Components: Database
> Affects Versions: 1.6
> Reporter: David Sean Taylor
> Assigned To: David Sean Taylor
> Priority: Minor
> Fix For: 1.6-dev
>
> Attachments: build.xml, drops.sql, populate-postgres.sql, turbine-postgres.sql
>
>
> Im attaching SQL scripts for Postgresql
> They work for me. Please test
> The attached build.xml has three new targets: drops, ddl, populate
> You can run something like:
> ant drops ddl populate
> Place the attached 3 SQL files in src/sql/external directory
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org
[jira] Updated: (JS1-565) Postgresql Support for Jetspeed 1.6
Posted by "David Sean Taylor (JIRA)" <je...@portals.apache.org>.
[ http://issues.apache.org/jira/browse/JS1-565?page=all ]
David Sean Taylor updated JS1-565:
----------------------------------
Attachment: build.xml
drop this in the root jetspeed source directory, replacing existing build.xml there
> Postgresql Support for Jetspeed 1.6
> -----------------------------------
>
> Key: JS1-565
> URL: http://issues.apache.org/jira/browse/JS1-565
> Project: Jetspeed
> Issue Type: Bug
> Components: Database
> Affects Versions: 1.6
> Reporter: David Sean Taylor
> Assigned To: David Sean Taylor
> Priority: Minor
> Fix For: 1.6-dev
>
> Attachments: build.xml
>
>
> Im attaching SQL scripts for Postgresql
> They work for me. Please test
> The attached build.xml has three new targets: drops, ddl, populate
> You can run something like:
> ant drops ddl populate
> Place the attached 3 SQL files in src/sql/external directory
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org
[jira] Commented: (JS1-565) Postgresql Support for Jetspeed 1.6
Posted by "Hans Plum (JIRA)" <je...@portals.apache.org>.
[ http://issues.apache.org/jira/browse/JS1-565?page=comments#action_12456848 ]
Hans Plum commented on JS1-565:
-------------------------------
Some follow up:
I have tested the scripts against Jetspeed 1.6 after adding the password_changed field ... (used the precompiled torque-oms from here [1]). Unfortunately I got the same errors.
Regards,
Hans
[1] - http://www.bluesunrise.com/maven/jetspeed/distributions/torque-om/postgresql/
> Postgresql Support for Jetspeed 1.6
> -----------------------------------
>
> Key: JS1-565
> URL: http://issues.apache.org/jira/browse/JS1-565
> Project: Jetspeed
> Issue Type: Bug
> Components: Database
> Affects Versions: 1.6
> Reporter: David Sean Taylor
> Assigned To: David Sean Taylor
> Priority: Minor
> Fix For: 1.6-dev
>
> Attachments: build.xml, drops.sql, populate-postgres.sql, turbine-postgres.sql
>
>
> Im attaching SQL scripts for Postgresql
> They work for me. Please test
> The attached build.xml has three new targets: drops, ddl, populate
> You can run something like:
> ant drops ddl populate
> Place the attached 3 SQL files in src/sql/external directory
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org
[jira] Updated: (JS1-565) Postgresql Support for Jetspeed 1.6
Posted by "David Sean Taylor (JIRA)" <je...@portals.apache.org>.
[ http://issues.apache.org/jira/browse/JS1-565?page=all ]
David Sean Taylor updated JS1-565:
----------------------------------
Attachment: populate-postgres.sql
place this file in src/sql/external
> Postgresql Support for Jetspeed 1.6
> -----------------------------------
>
> Key: JS1-565
> URL: http://issues.apache.org/jira/browse/JS1-565
> Project: Jetspeed
> Issue Type: Bug
> Components: Database
> Affects Versions: 1.6
> Reporter: David Sean Taylor
> Assigned To: David Sean Taylor
> Priority: Minor
> Fix For: 1.6-dev
>
> Attachments: build.xml, drops.sql, populate-postgres.sql, turbine-postgres.sql
>
>
> Im attaching SQL scripts for Postgresql
> They work for me. Please test
> The attached build.xml has three new targets: drops, ddl, populate
> You can run something like:
> ant drops ddl populate
> Place the attached 3 SQL files in src/sql/external directory
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org
[jira] Resolved: (JS1-565) Postgresql Support for Jetspeed 1.6
Posted by "David Sean Taylor (JIRA)" <je...@portals.apache.org>.
[ https://issues.apache.org/jira/browse/JS1-565?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Sean Taylor resolved JS1-565.
-----------------------------------
Resolution: Fixed
Fix Version/s: (was: 1.6-dev)
1.6
tested under several different environments
> Postgresql Support for Jetspeed 1.6
> -----------------------------------
>
> Key: JS1-565
> URL: https://issues.apache.org/jira/browse/JS1-565
> Project: Jetspeed
> Issue Type: Bug
> Components: Database
> Affects Versions: 1.6
> Reporter: David Sean Taylor
> Assigned To: David Sean Taylor
> Priority: Minor
> Fix For: 1.6
>
> Attachments: build.xml, drops.sql, populate-postgres.sql, turbine-postgres.sql
>
>
> Im attaching SQL scripts for Postgresql
> They work for me. Please test
> The attached build.xml has three new targets: drops, ddl, populate
> You can run something like:
> ant drops ddl populate
> Place the attached 3 SQL files in src/sql/external directory
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org
[jira] Commented: (JS1-565) Postgresql Support for Jetspeed 1.6
Posted by "Hans Plum (JIRA)" <je...@portals.apache.org>.
[ http://issues.apache.org/jira/browse/JS1-565?page=comments#action_12456846 ]
Hans Plum commented on JS1-565:
-------------------------------
Hi David,
I still does not work for me. What I did:
1) clean svn checkout of trunk
2) exchanged build.xml's and adapted path to postgresql jdbc driver
3) moved SQL-files into src/sql/external
4) created postgresql DB with scripts
5) compiled new torque-om's against postgresql (by maven)
6) build jetspeed.war (by maven)
7) added postgres jdbc driver in war
8) corrected /WEB-INF/conf/Torque.properties for postgresl-binding
=> Error when starting the Homepage: message that field password_changed in turbine_user was missing
9) added field password_changed "PASSWORD_CHANGED timestamp"
10) Homepage worked
11) Tried to add new user:
2006-12-08 15:15:46,701 [http-8080-Processor24] WARN CastorPsmlManagerService - PSMLManager: /home/hp/software/jetspeed/jetspeed-trunk/trunk/target/jetspeed-pg2/WEB-INF/p
sml/user/admin/html/de/default.psml not found, returning null document
2006-12-08 15:15:46,733 [http-8080-Processor24] ERROR TurbineUserManagement - Failed to create account 'test'
org.apache.torque.TorqueException: java.sql.SQLException: ERROR: null value in column "user_id" violates not-null constraint
at org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:236)
at org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:903)
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:742)
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:639)
at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTurbineUserPeer.java:241)
at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTurbineUserPeer.java:214)
at org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser(TurbineUserManagement.java:283)
at org.apache.jetspeed.services.JetspeedUserManagement.addUser(JetspeedUserManagement.java:95)
at org.apache.jetspeed.services.JetspeedSecurity.addUser(JetspeedSecurity.java:213)
at org.apache.jetspeed.modules.actions.portlets.security.UserUpdateAction.doInsert(UserUpdateAction.java:200)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.jetspeed.modules.actions.portlets.PortletActionEvent.fireEvent(PortletActionEvent.java:176)
at org.apache.jetspeed.modules.actions.portlets.PortletActionEvent.executeEvents(PortletActionEvent.java:133)
at org.apache.jetspeed.modules.actions.portlets.SecureVelocityPortletAction.executeEvents(SecureVelocityPortletAction.java:42)
at org.apache.jetspeed.modules.actions.portlets.GenericMVCAction.perform(GenericMVCAction.java:115)
at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
at org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:143)
at org.apache.turbine.modules.Page.build(Page.java:90)
at org.apache.turbine.modules.PageLoader.exec(PageLoader.java:123)
at org.apache.turbine.Turbine.doGet(Turbine.java:563)
at org.apache.turbine.Turbine.doPost(Turbine.java:658)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Seems to be the same problem - could you give me a hint where to look at. Something wrong with the steps, I took.
TIA,
Hans
> Postgresql Support for Jetspeed 1.6
> -----------------------------------
>
> Key: JS1-565
> URL: http://issues.apache.org/jira/browse/JS1-565
> Project: Jetspeed
> Issue Type: Bug
> Components: Database
> Affects Versions: 1.6
> Reporter: David Sean Taylor
> Assigned To: David Sean Taylor
> Priority: Minor
> Fix For: 1.6-dev
>
> Attachments: build.xml, drops.sql, populate-postgres.sql, turbine-postgres.sql
>
>
> Im attaching SQL scripts for Postgresql
> They work for me. Please test
> The attached build.xml has three new targets: drops, ddl, populate
> You can run something like:
> ant drops ddl populate
> Place the attached 3 SQL files in src/sql/external directory
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org