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.

      jboss-web.xml
      <jboss-web>
      <security-domain>java:/jaas/MySqlDbRealm</security-domain>
      </jboss-web>

      login-config.xml
      <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>
      </login-module>

      </application-policy>

      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,
      Mike