]
Mohamed Rifni closed WFLY-4460.
-------------------------------
Resolution: Done
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>