1 Reply Latest reply on Jun 27, 2002 7:45 AM by Wouter Beheydt

    Setting up Security with Mysql and Jboss 3.0

    Mike Newbie

      I had no trouble getting security with mysql and jboss 2.4.6. However, with 3.0 my web site returns "Access to the requested resource has been denied". My setup is as follows.


      <application-policy name = "MySqlDbRealm">

      <login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule" flag = "required">
      <module-option name = "principal">Principals</module-option>
      <module-option name = "userName">root</module-option>
      <module-option name = "password">password</module-option>
      <module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=MySqlDS</module-option>


      and I copied the mysql-service.xml into the deploy directory. In the previous version you had to specify the principalsQuery and the rolesQuery, but I can't find that in the 3, I think that's what my problem is.

      Any help would be appreicated,