0 Replies Latest reply on Jun 28, 2014 1:31 PM by kbs

    Login issue after migrating application from Glassfish to Wildfly

    kbs

      I 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>