Specify username in PrincipalMappingProperties
I have exactly the same problem, that username and password are not picked up from the mysql-service.xml. I end up having to start mysql with grant tables off ( bad...) to connect.
On the other side I'm able to connect from a servlet using jdbc to mysql with the username-password combo ( and grant tables turned on.)
I have a un/pw combo specified in the login-config.xml. It works without problems. I am using JBoss 3.0 RC2.
However, I have another problem: I have specified an additional datasource within the same security domain i.e. in the mysql service I have two definitions of Datasources pointing to two different tables. When I try to deploy a bean, the second un/pw combo in login-config.xml is not picked up.