[
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
