Login issue after migrating application from Glassfish to Wildfly
kbs Jun 28, 2014 1:31 PMI had followed Arun Gupta blob on Migrating to Wildfly 8 from Glassfish 4.0 and successfully deploy my eclipselink application on wildfly 8. But, I am not able to login to my application. Please refer to my datasource below and security domain and let me know what is wrong.
<datasource jta="false" jndi-name="java:/jdbc/appDS" pool-name="appDS" enabled="true" use-ccm="false">
<connection-url>jdbc:mysql://localhost:3306/myapp</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<driver>mysql</driver>
<pool>
<min-pool-size>5</min-pool-size>
<max-pool-size>15</max-pool-size>
</pool>
<security>
<user-name>xxxx</user-name>
<password>xxxx</password>
</security>
<validation>
<validate-on-match>false</validate-on-match>
<background-validation>false</background-validation>
</validation>
<statement>
<share-prepared-statements>false</share-prepared-statements>
</statement>
</datasource>
<security-domain name="app" cache-type="default">
<authentication>
<login-module code="Database" flag="required">
<module-option name="dsJndiName" value="java:/jdbc/appDS"/>
<module-option name="principalsQuery" value="select u.password from user_role_view u where u.username = ?"/>
<module-option name="rolesQuery" value="select u.rolename group_name, 'Roles' from user_role_view u where u.username = ?"/>
<module-option name="hashAlgorithm" value="SHA-256"/>
<module-option name="hashEncoding" value="BASE64"/>
<module-option name="unauthenticatedIdentity" value="guest"/>
</login-module>
<login-module code="RoleMapping" flag="required">
<module-option name="rolesProperties" value="file:${jboss.server.config.dir}/app.properties"/>
<module-option name="replaceRole" value="false"/>
</login-module>
</authentication>
</security-domain>