How to authenticate a user using jdbc realm in Elytron Wildfly 17?

Question

I have been working on Wildfly 17 Elytron. I have configured it using these jboss-cli with following commands.

/subsystem=elytron/jdbc-realm=test-realm:add(principal-query=[{sql="SELECT hash FROM invientusers WHERE emailid = ?", data-source="dataSourcePoolName", clear-password-mapper={password-index=1}},{sql="SELECT Roles FROM Roles WHERE emailid = ?", data-source="dataSourcePoolName", attribute-mapping=[{index=1, to=roles}]}])

/subsystem=elytron/simple-role-decoder=from-roles-attribute:add(attribute=roles)

/subsystem=elytron/security-domain=test-security-sd:add(default-realm=test-realm, realms=[{realm=test-realm, role-decoder=from-roles-attribute}], permission-mapper=default-permission-mapper)

/subsystem=elytron/http-authentication-factory=test-security-http-auth:add(http-server-mechanism-factory=global,security-domain=test-security-sd,mechanism-configurations=[{mechanism-name=BASIC,mechanism-realm-configurations=[{realm-name=test-realm}]}])

 /subsystem=undertow/application-security-domain=test-security-sd:add(http-authentication-factory=test-security-http-auth)

/subsystem=elytron/sasl-authentication-factory=test-sasl-authentication:add(sasl-server-factory=configured,security-domain=test-security-sd,mechanism-configurations=[{mechanism-name=PLAIN}])

/subsystem=remoting/http-connector=http-remoting-connector:write-attribute(name=sasl-authentication-factory,value=test-sasl-authentication)

/subsystem=ejb3/application-security-domain=test-domain:add(security-domain=test-security-sd)

Ejb code

@SecurityDomain("test-domain")
public class SecuredEJB {

web.xml

<login-config>
    <auth-method>BASIC</auth-method>
    <realm-name>test-sasl-authentication</realm-name>
</login-config>

I am expecting this code to validate using JDBC test-realm. but its using file based default realm for ejb validations.

Answer 1

You also need to add the domain mapping in the EJB3 subsytem:

/subsystem=ejb3/application-security-domain=other:add(security-domain=test-security-sd)

Take a look at this example on how to secure EJBs using the File System Realm. The script configure-elytron.cli has all the management operations you will need to configure your server. Most steps should be applicable to your scenario, except you are configuring a JDBC realm instead.