OpenKM 4 Authentication with Postgresql

[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

[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

[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.

[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...

[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 ?

[mribeiro]

I'm on a testing evironment, and yes... I already deleted the repository folder but the error persists...

[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 )