Transmenu powered by JoomlArt.com - Mambo Joomla Professional Templates Club

I want to change authentication,use database user

I don't understant your question ¿?

I want to create user and role of openkm system in db,not openkm-roles.properties and openkm-users.properties .when I login use users and roles of db.


I am very thank you

You have two ways:

1. OpenKM 2.0. Enterprise edition will come with database user autentication ( you could use it, but it's pay supported version).

2- If you want to connect to existing database take a Look at this documentation entry point OpenKM Configuration.

You must change OpenKM login to autenticate to your database ( really simply ).
For full integration you need to extend PrincipalAdapter class ( really simply too ).

If you decide to do the second option, see Developer guide ( on les 10 minuts you've got running).

Hope It could help you.

I am trying to integrate my openkm with postgresql but it gives me error that my repository home is locked by another process,i remove .lock in repository directory/remove repository directory/shutdown and start properly/install and configure multiple times with my previous configuration but..... but................ nothing works for me ,i take full Oracle integration as example from openkm documentation, i successfully integrate ldap with openkm ,please anyone guide me how i integrade my postgresql with openkm???????.........

About user autentication it must be something like it:

On login-config.xml

<application-policy name="OpenKM">
<authentication>
<login-module code ="org.jboss.security.auth.spi.DatabaseServerLoginModule" flag="required">
<module-option name = "unauthenticatedIdentity">Anonymous</module-option>
<module-option name="dsJndiName">java:/jndi.datasource.name.db</module-option>
<module-option name="principalsQuery">select user_pwd_table as PASSWD from user_table where user_name=?</module-option>
<module-option name="rolesQuery">select role_name as ROLEID, 'Roles' from user_table, roles_table where user_roles_name=user_name and user_name=?</module-option>
</login-module>
</authentication>
</application-policy>

The query it'll be dependant on your table structure ( remember it, it's only and exemple of how could be )

Some file called datasource-ds.xml or something fileXXX-ds.xml to create jndi name like it

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

<datasources>
<local-tx-datasource>
<jndi-name>jndi.datasource.name.db</jndi-name>
<connection-url>jdbcostgresql://localhost/you_databasename</connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<user-name>user</user-name>
<password>pwd</password>
</local-tx-datasource>
</datasources>