portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hans Plum (JIRA)" <jetspeed-...@portals.apache.org>
Subject [jira] Commented: (JS1-565) Postgresql Support for Jetspeed 1.6
Date Fri, 08 Dec 2006 14:34:29 GMT
    [ 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


Mime
View raw message