jboss 3.0.0 & Mysql

[showyou]

Hi all,

I used JBoss RC1 3.0.0, mysql(max-3.23.49) and mm.driver(2.0.12).

my problem was as follows:

1. drop mm.driver.2.0.12 into jboss\lib
2. drop mysql-service.xml into jboss\server\default\deploy

when i execute run.bat, i got some info:

1. 2002-04-17 00:58:47,529 DEBUG [org.jboss.system.ServiceCreator] About to create bean: jboss.jca:service=ConnectionFactoryLoader,name=warmwinterDS

2. 2002-04-17 00:58:47,529 DEBUG [org.jboss.system.ServiceCreator] code: org.jboss.resource.ConnectionFactoryLoader

3. 2002-04-17 00:58:47,629 DEBUG [org.jboss.system.ServiceCreator] Class not found for mbean: jboss.jca:service=ConnectionFactoryLoader,name=warmwinterDS

[rsal]

Hi,

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>
</login-module>

</application-policy>

That should do the trick :)

HTH,
/rick

[feeling]

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.

Fee

[rsal]

No problem. Glad to help. :)

/rick

[adtran]

Hello,

I download the file "mysql-service.xml" but can not VI it. Is this file encrypted ? can you help out.

Thank alots,
PS. this is my email address [e-mail] or [e-mail]

[adtran]

Hi,

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.

Ai Tran

[benw]

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.

[adtran]

Where is Jboss RC2? I could not find it. Could you tell me where it is?

Thank you

Adtran

[davidjencks]

http://sourceforge.net/project/showfiles.php?group_id=22866

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?