Hi there,
I am really in need of help to resolve this issue.
I had installed OpenKM5.1.9 on a Windows Server and also onto Apache Server 2.2.
I was able to access the login page. But once i try to login with a valid user, i hit the an error:
HTTP Status 403 - Access to the requested resource has been denied
type Status report
message Access to the requested resource has been denied
description Access to the specified resource (Access to the requested resource has been denied) has been forbidden.
JBossWeb/2.0.1.GA
<!-- 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> --> <module-option name="dsJndiName">java:/MySqlDS</module-option> <module-option name="principalsQuery">Select cryptpassword as PASSWD from OKM_USER where login_name=?</module-option> <module-option name="rolesQuery">select ROLEID, 'Roles' from OKM_USER_ROLE where user_id=?</module-option> </login-module> <!-- <login-module code="org.jboss.security.ClientLoginModule" flag="required" /> --> </authentication> </application-policy>
Please advise. Really need to resolve this asap.
Let me know if more information is required to resolve it.
Thanks in advance!!!
Has your "valid user" been assigned to one or more roles in the OKM_USER_ROLE table?