1 Reply Latest reply on Mar 4, 2003 3:43 PM by sazabo

    DataSourceLoginModule problem Error 403

    sazabo

      I am getting a 403 error when using this login module. Does anyone know if you must use Text types for the password or can you use varchar with MySQL?

      Do the password need to be encypted in the DB or is plain text ok. Here is my login-config.xml
      <application-policy name = "LoginDB">

      <login-module code = "org.jboss.security.auth.spi.DatabaseServerLoginModule"
      flag = "required">
      <module-option name = "dsJndiName">java:/XAMySqlDS</module-option>
      <module-option name = "principalsQuery">select Password from principals where PrincipalID=?</module-option>
      <module-option name = "rolesQuery">select Role, RoleGroup from roles where PrincipalID=?</module-option>
      <module-option name = "managedConnectionFactoryName">jboss.jca:service=XATxCM,name=XAMySqlDS</module-option>
      </login-module>

      </application-policy>

      thanks