login-config.xml with mysql questions?

[adam2001usa]

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.

[pvamstel]

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

[adam2001usa]

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>

[pvamstel]

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