]
Darran Lofthouse commented on WFLY-4460:
----------------------------------------
Can you capture TRACE level logging for org.jboss.security and upload your log here to see
if there is any underlying failure being reported.
form login with jdbc realm doesnt work with standalone-full.xml
---------------------------------------------------------------
Key: WFLY-4460
URL:
https://issues.jboss.org/browse/WFLY-4460
Project: WildFly
Issue Type: Feature Request
Components: Security
Affects Versions: 8.2.0.Final
Reporter: Mohamed Rifni
Assignee: Darran Lofthouse
Everytime I try to login i get redirected back to the login form again, this is happening
only with standalone-full.xml in wildfly 8.2. When I switch to standalone.xml it works.
web.xml
<security-constraint>
<display-name>MANAGER</display-name>
<web-resource-collection>
<web-resource-name>Manager</web-resource-name>
<description/>
<url-pattern>/manager-area/*</url-pattern>
</web-resource-collection>
<auth-constraint>
<description/>
<role-name>MANAGER</role-name>
</auth-constraint>
</security-constraint>
<login-config>
<auth-method>FORM</auth-method>
<realm-name>mtaV4-security-jdbcrealm</realm-name>
<form-login-config>
<form-login-page>/login_home.xhtml</form-login-page>
<form-error-page>/login_home.xhtml</form-error-page>
</form-login-config>
</login-config>
jboss-web.xml
<?xml version="1.0" encoding="UTF-8"?>
<jboss-web
xmlns="http://www.jboss.com/xml/ns/javaee">
<context-root/>
<security-domain>mtaV4-security-jdbcrealm</security-domain>
</jboss-web>
standalone-full.xml
<security-domain name="mtaV4-security-jdbcrealm"
cache-type="default">
<authentication>
<login-module code="Database"
flag="required">
<module-option name="dsJndiName"
value="java:/jboss/__MTAV4"/>
<module-option name="principalsQuery"
value="select userpassword from users where email=?"/>
<module-option name="rolesQuery"
value="select role_name, 'Roles' from user_roles where email=?"/>
<module-option name="unauthenticatedIdentity"
value="guest"/>
</login-module>
</authentication>
</security-domain>