Page 2 of 2
Re: OpenKM 4 Authentication with Postgresql
PostPosted:Tue Apr 13, 2010 8:46 am
by jllort
Yes, OKMWorkflow database must contains jbpm tables ... but you might not copy directly from hypersonic, rememeber could be some diference between hypersonic tables declaration and postgresql declarion, you must execute scripts in you empty postgresql database to create the structure needed by jbpm
Re: OpenKM 4 Authentication with Postgresql
PostPosted:Tue Apr 13, 2010 10:28 am
by mribeiro
I already created them... I adapted the script to PostgreSQL and successful created the 32 tables.
I don't know hoe to put that database (OKMWorkflow) to use
Re: OpenKM 4 Authentication with Postgresql
PostPosted:Tue Apr 13, 2010 2:27 pm
by jllort
We'll OpenKM users these database defined in openkm-ds.xml if you register some workflow then it'll be used, if not it'll be empty.
Re: OpenKM 4 Authentication with Postgresql
PostPosted:Tue Apr 13, 2010 2:59 pm
by mribeiro
Well... My datasource to the OKMWorkflow database is defined like this (And it structure is created in my postgresql server):
Code: Select all<local-tx-datasource>
<jndi-name>OKMWorkflowDS</jndi-name>
<connection-url>jdbc:postgresql://localhost:5432/OKMWorkflow</connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<user-name>postgres</user-name>
<password>123456</password>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<idle-timeout-minutes>0</idle-timeout-minutes>
<track-statements/>
<!--<security-domain>HsqlDbRealm</security-domain>-->
<prepared-statement-cache-size>32</prepared-statement-cache-size>
<metadata>
<type-mapping>PostgreSQL</type-mapping>
</metadata>
<!--<depends>jboss:service=Hypersonic,database=OKMWorkflow</depends>-->
</local-tx-datasource>
If I start the server with it, I got the error I told before...
Re: OpenKM 4 Authentication with Postgresql
PostPosted:Tue Apr 13, 2010 5:40 pm
by jllort
You're on a testing environment ( non production ) , I would like to delete repository folder under JBOSS_home ( while jboss is stopped ) and restarting jboss trying to recreate a clean starting up. Could you try it or you've got important files in the repository ?
Re: OpenKM 4 Authentication with Postgresql
PostPosted:Tue Apr 13, 2010 6:35 pm
by mribeiro
I'm on a testing evironment, and yes... I already deleted the repository folder but the error persists...
Re: OpenKM 4 Authentication with Postgresql
PostPosted:Thu Apr 15, 2010 10:28 am
by jllort
Put all the error trace log, I want to see it ( upload some file or paste as text -> only the error trace not all the log )