Configuration of MySql database

[ravinauluri]

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>jbosservice=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=\"jbosservice=mySQL,database=openkm\">
<attribute name=\"Database\">openkm</attribute>
<attribute name=\"InProcessMode\">true</attribute>
</mbean>
Original is
<mbean code=\"org.jboss.jdbc.HypersonicDatabase\"
name=\"jbosservice=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>jbosservice=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=\"jbosservice=mySQL,database=openkm\">
<attribute name=\"Database\">openkm</attribute>
<attribute name=\"InProcessMode\">true</attribute>
</mbean>
original is
<mbean code=\"org.jboss.jdbc.HypersonicDatabase\"
name=\"jbosservice=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>jbosservice=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=\"jbosservice=mySQL,database=openkm\">
<attribute name=\"Database\">openkm</attribute>
<attribute name=\"InProcessMode\">true</attribute>
</mbean>
Original is
<mbean code=\"org.jboss.jdbc.HypersonicDatabase\"
name=\"jbosservice=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?

[jllort]

openkm-dx.xml must be well done configured for it purpose in concordance with login-config.xml, take a look at query in login-config.xml and make it in your database to look that all goes fine.

Normally for this change you might restart jboss, because this is jboss auth pool and seems is not the same that a normal database jndi pool.

[ravinauluri]

i had changed the datasource name as \"OKMAuthDS\" to \"OKMAuthUniversal\". and then i have restarted the jboss server. In console,

Looking for java:/OKMAuthDS DataSource...
12:16:29,406 WARN [AbstractDAO] DataSource not found: OKMAuthDS not bound
12:16:29,406 INFO [AbstractDAO] Looking for java:/OKMAuthDS DataSource...
12:16:29,406 WARN [AbstractDAO] DataSource not found: OKMAuthDS not bound

same message is getting.

Please help me, how can i change the datasource name .