Actually the configuration has changed now. Use the 2.0.11 driver for it to work. I have attached how the new config file for mysql-service.xml looks now.
You will need to include something like this in $JBOSS_DIST/server/default/deploy/login-conf.xml:
<application-policy name = "MySqlDbRealm">
<login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule"
flag = "required">
<module-option name = "principal">foo</module-option>
<module-option name = "userName">foo</module-option>
<module-option name = "password">mysql</module-option>
<module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=warmwinterDS</module-option>
That should do the trick :)
Thank you for sharing your knowledge. I have been struggling for a few days now with the mysql configuration problems and after using your file, everything works great.
No problem. Glad to help. :)
I downloaded the mysql-service.xml and created the login-conf.xml. After I started JBoss 3.0RC1, I found alots of WARNING messages. I attached these WARNING in a file named jboss.log for you to look at. Is this the same WARN that you had or I did something very smart that causes this WARN. By the way, thank you for your file which was great help to me. If you know how to fix these WARNING(s) please tell me so.
I am guessing you downloaded the latest configuration file from SourceForge. If so, it will only work with RC2. The configuration files have changed from RC1 to RC2. Try using it with RC2. You should upgrade anyway as RC1 is no longer supported by the powers that be.
Where is Jboss RC2? I could not find it. Could you tell me where it is?
What would make this easier to find? Eliminating links to individual downloads from the jboss web site download page and just referring to this page? Any other ideas?