Found a solution, which seems to work, so maybe it will be useful for
others too.
First of all,
http://www.hippocms.org/display/CMS/Configuring+the+workflow+databases
seems not to be up-to-date, at least for PostgreSQL.
Three files need to be changed (used MySQL settings as base):
* localdevWorkflowStore.xml, for projectWorkflowStore bean
o comment out
+ entry with key="entry.sequence.increment"
+ entry with key="entry.sequence.retrieve"
+ entry with key="step.sequence"
+ entry with key="step.sequence.increment"
+ entry key="step.sequence.retrieve"
o append
+ <entry key="entry.sequence">
<value>SELECT nextVal('seq_os_wfentry')</value>
</entry>
+ <entry key="step.sequence">
<value>SELECT nextVal('seq_os_currentsteps')</value>
</entry>
o change class to
"nl.hippo.servermanager.util.SpringJdbcWorkflowStore"
* localdevSchedulerStore.xml for bean with id="projectSchedulerStore"
o append
+ <property name="driverDelegateClass">
<value>org.quartz.impl.jdbcjobstore.PostgreSQLDelegate</value>
</property>
* osworkflow.sql
o in create table OS_PROPERTYENTRY, data type of DATA_VALUE
column needs to be changed from oid to bytea
My impressions is that PostgreSQL is second grade citizen to Hippo, and
I don't understand why - it's only enterprise level open source
relational db. Similarly, there are init scripts for redhat, opensuse,
and gentoo, but not for ubuntu.
Jeroen Reijn wrote:
Hi Slavic,
did you also use the correct workflow configuration? I just noticed there is
nog workflow template defined for PostgreSQL eventhough I know people are using
postgress.
See [1] for workflow templates for other databases.
Regards,
Jeroen Reijn
[1]
http://svn.hippocms.org/repos/hippo/hippo-cms/branches/Branch-CMS-v6_05_xx/editor/templates/
-----Original Message-----
From: [EMAIL PROTECTED] on behalf of Stevo Slavic
Sent: Wed 4/16/2008 1:59 PM
To: [email protected]
Subject: [HippoCMS-dev] Hippo CMS 6.05.02 on PostgreSQL 8.2.7 issue
When selecting a document in Hippo CMS which is on Postgres 8.2.7, on
right hand side following error message gets displayed:
An error occured during loading:
com.opensymphony.workflow.StoreException: Error creating new workflow
instance: root cause: ERROR: relation "os_wfentryids" does not exist
(file:/home/hippo/miles/editor-v6.05.02/cocoon/../sites/h
When inspecting "osworkflow" database in Postgres and comparing it to
the same database in MySQL, table "os_wfentryids" is not present in
Postgres, but sequence "seq_os_wfentry" is. Similarly, table
"os_stepids" is not present in Postgres but there is a sequence
"seq_os_currentsteps". osworkflow database schema was initialized with
SQL script found in latest Hippo CMS sources. What should I do to
resolve the issue? Thanks in advance!
********************************************
Hippocms-dev: Hippo CMS development public mailinglist
********************************************
Hippocms-dev: Hippo CMS development public mailinglist
--
Met vriendelijke groet / Kind regards,
Stevo Slavić
Senior Software Developer
Levi9 Global Sourcing
------------------------------------------------------------------------
. Jan van Goyenkade 8, 1075 HP Amsterdam, The Netherlands
( (+31) (0) 20 6701 947
È (+381) (0) 63 7 258 458
* [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
^ Skype: sslavic
ü http://www.levi9.com/
Chamber of commerce Levi9 Global Sourcing BV: 34221951
Chamber of commerce Levi9 Global Sourcing Benelux BV: 34224746
------------------------------------------------------------------------
This e-mail may contain confidential or privileged information. If you
are not (one of) the intended recipient(s), please notify the sender
immediately by reply e-mail and delete this message and any attachments
permanently without retaining a copy. Any review, disclosure, copying,
distribution or taking any action in reliance on the contents of this
e-mail by persons or entities other than the intended recipient(s) is
strictly prohibited and may be unlawful.
The services of Levi9 are exclusively subject to its general terms and
conditions. These general terms and conditions can be found on
http://www.levi9.com/ and a copy will be promptly submitted to you on
your request and free of charge.
********************************************
Hippocms-dev: Hippo CMS development public mailinglist
