OpenKM with Mysql

[neil]

Hi All,

I have downloaded OpenKM 3.0. installed it successfully. Also able to set up the new Development environment for it. But now I want o use MySql as a database not a derby database.

SO I have made changes in openkm-ds.xml as suggested.I will copy paste the whole code here

<?xml version=\"1.0\" encoding=\"UTF-8\"?>

<datasources>
<!-- OpenKM User Activity -->
<local-tx-datasource>
<jndi-name>OKMActivityDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/openkm</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password></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>mySQL</type-mapping>
</metadata>
<!-- <depends>jboss:service=Hypersonic,database=OKMActivity</depends> -->
</local-tx-datasource>

<!-- For hsqldb accessed from jboss only, in-process (standalone) mode -->
<!-- changed and commented by me <mbean code=\"com.mysql.jdbc.Driver\"
name=\"jboss:service=mySQL,database=openkm\">
<attribute name=\"Database\">openkm</attribute>
<attribute name=\"InProcessMode\">true</attribute>
</mbean>
Original is
<mbean code=\"org.jboss.jdbc.HypersonicDatabase\"
name=\"jboss:service=Hypersonic,database=OKMActivity\">
<attribute name=\"Database\">OKMActivity</attribute>
<attribute name=\"InProcessMode\">true</attribute>
</mbean>
-->

<!-- OpenKM User Auth -->
<local-tx-datasource>
<jndi-name>OKMAuthDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/openkm</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password></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>mySQL</type-mapping>
</metadata>
<!--<depends>jboss:service=Hypersonic,database=OKMAuth</depends> -->
</local-tx-datasource>

<!-- For hsqldb accessed from jboss only, in-process (standalone) mode -->
<!-- change and commented by me <mbean code=\"com.mysql.jdbc.Driver\"
name=\"jboss:service=mySQL,database=openkm\">
<attribute name=\"Database\">openkm</attribute>
<attribute name=\"InProcessMode\">true</attribute>
</mbean>
original is
<mbean code=\"org.jboss.jdbc.HypersonicDatabase\"
name=\"jboss:service=Hypersonic,database=OKMAuth\">
<attribute name=\"Database\">OKMAuth</attribute>
<attribute name=\"InProcessMode\">true</attribute>
-->

<!-- OpenKM Dashboard Stats -->
<local-tx-datasource>
<jndi-name>OKMDashboardStatsDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/openkm</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password></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>mySQL</type-mapping>
</metadata>
<!-- <depends>jboss:service=Hypersonic,database=OKMDashboardStats</depends>-->
</local-tx-datasource>

<!-- For hsqldb accessed from jboss only, in-process (standalone) mode -->
<!-- changed and commented by me <mbean code=\"com.mysql.jdbc.Driver\"
name=\"jboss:service=mySQL,database=openkm\">
<attribute name=\"Database\">openkm</attribute>
<attribute name=\"InProcessMode\">true</attribute>
</mbean>
Original is
<mbean code=\"org.jboss.jdbc.HypersonicDatabase\"
name=\"jboss:service=Hypersonic,database=OKMDashboardStats\">
<attribute name=\"Database\">OKMDashboardStats</attribute>
<attribute name=\"InProcessMode\">true</attribute>
</mbean>
-->
</datasources>


After making this changes and again starting the openkm it has created users,
user_role,role table in mysql database. It has also inserted the one entry in the users table i.e. \"admin\" entry.


but when I try to use login to OpenKM via browser it shows me Authentication error and it is not even showing any error on jboss server prompt.

Is there any configuration missing from openkm-ds.xml?

Can any one please help me in this issue?

Regards
Neil M