Open Source Document Management System | OpenKM

PostPosted:**Mon Jun 06, 2011 9:47 am**

Hi there

For support members that can access the wiki page MySQL-OpenKM 5.0, I have to make a minor correction regarding the JBoss Login configuration.
Instead of the proposed change of $JBOSS_HOME/server/default/conf/login-config.xml :

Code: Select all

<!-- OpenKM -->
<application-policy name = "OpenKM">
    <authentication>
        <login-module code="org.jboss.security.auth.spi.DatabaseServerLoginModule" flag = "required">
            <module-option name="dsJndiName">java:/OpenKMDS</module-option>
            <module-option name="principalsQuery">select usr_password as PASSWD from OKM_USER where usr_id=? and usr_active=true</module-option>
            <module-option name="rolesQuery">select ur_role as ROLEID, 'Roles' from OKM_USER_ROLE where ur_user=?</module-option>
            <module-option name="hashAlgorithm">md5</module-option>
            <module-option name="hashEncoding">hex</module-option>
        </login-module>
    </authentication>
</application-policy>

I think, it should be changed to

Code: Select all

<!-- OpenKM -->
<application-policy name = "OpenKM">
    <authentication>
        <login-module code="org.jboss.security.auth.spi.DatabaseServerLoginModule" flag = "required">
            <module-option name="dsJndiName">java:/OpenKMDS</module-option>
            <module-option name="principalsQuery">select usr_password as PASSWD from OKM_USER where usr_id=? and usr_active='T'</module-option>
            <module-option name="rolesQuery">select ur_role as ROLEID, 'Roles' from OKM_USER_ROLE where ur_user=?</module-option>
            <module-option name="hashAlgorithm">md5</module-option>
            <module-option name="hashEncoding">hex</module-option>
        </login-module>
    </authentication>
</application-policy>

And this is because the table OKM_USER has column usr_active declared as char(1) not as boolean.

Best regards.

PostPosted:**Thu Jun 09, 2011 8:46 pm**

But this change was made in OpenKM 5.1.x Which OpenKM version are you using?

EDIT: Ok, I understand now. Thanks, I have added this info to the wiki.

Open Source Document Management System | OpenKM

Error in Wiki Support page for MySQL-OpenKM 5.0

Error in Wiki Support page for MySQL-OpenKM 5.0

Re: Error in Wiki Support page for MySQL-OpenKM 5.0