Hi Stevo,
Thanks for sharing your PostgreSQL config! I will add them to the wiki
and see if I can create a config template for PostgreSQL for the CMS.
PostgreSQL is not a "second grade citizen" to Hippo. It's just that most
of our client are using other databases at the moment (oracle, mysql,
etc..), but we do support PostgreSQL. With help from you and others on
the list we even can improve our PostgreSQL support ;)
Regards,
Bart
Stevo Slavić wrote:
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
--
Hippo B.V. - Amsterdam
Oosteinde 11, 1017 WT, Amsterdam, +31(0)20-5224466
Hippo USA Inc. - San Francisco
101 H Street, Suite Q, Petaluma CA, 94952-3329, +1 (707) 773-4646
-----------------------------------------------------------------
http://www.onehippo.com - [EMAIL PROTECTED]
-----------------------------------------------------------------
********************************************
Hippocms-dev: Hippo CMS development public mailinglist
