3 Replies Latest reply on Nov 27, 2002 12:52 AM by patrick

    login-config.xml with mysql questions?

    Adam Smith Newbie

      jboss 3.0.4
      embedded catalina 4.1.12

      I'm trying to follow the doc at
      http://www.purposesolutions.com/Resources/EclipseJ2EE.html#JBOSS_MYSQL_INTEGRATION

      Very helpful, except I have a few questins about the login-config.xml as such:

      <application-policy name = "MySqlDbRealm">

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

      </application-policy>

      what is principal is this some security role you define in web.xml somewhere?

      What is username and password? Is this an admin password?

      Where else is MySqlDS configured? What files?

      Thanx in advance.

        • 1. Re: login-config.xml with mysql questions?
          patrick Novice

          You will need to add a service.

          An mysql example can be found at
          $JBOSS_DIST/docs/examples/jca/mysql-service.xml

          It is some a bit of a hassle to get this working. But rather easy if you know what you are doing.

          It boils down to filling in the connection url and username and password. Copy the modified file to $jboss/server/default/deploy

          And see if he takes this service without any errors.

          You can see the jndi name in
          http://localhost:8080/jmx-console

          Maybe this helps

          • 2. Re: login-config.xml with mysql questions?
            Adam Smith Newbie

            Thank you. I knew about the mysql-service.xml.

            But, I still am searching for answers to the questions about login-config.xml.

            what is principal is this some security role you define in web.xml somewhere?

            What is username and password? Is this an admin password in mysql?

            Where else is MySqlDS configured? What files?

            Thanx in advance

            <application-policy name = "MySqlDbRealm">

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

            </application-policy>

            • 3. Re: login-config.xml with mysql questions?
              patrick Novice

              Those questions are the hard ones.

              I do not know enough about the principle stuff.
              What i do know is that there are 2 file
              users.properties
              roles.properties

              They have something to do with the principle stuff

              Sorry i cannot help you any further