Shibboleth Relational Database DataConnector

Example Shibboleth Relational Database DataConnector configuration for MySQL with column mapping of AES encrypted attribute.

                                xmlns="urn:mace:shibboleth:2.0:resolver:dc"
                            id="MyDatabase">
        
                                                   jdbcURL="jdbc:mysql://localhost:3306/handle"
                                           jdbcUserName="test"
                                           jdbcPassword="test" />

        
                            SELECT AES_DECRYPT(password, 'key') FROM handle WHERE username='$requestContext.principalName'
            ]]>