[JBoss-user] DatabaseServerLoginModule problem

Hello!

I am having problems validating users with DatabaseServerLoginModule. I am trying to validate users with

MySQL and Firebird, but with no success in both of them. I am using Jboss 3.0.0 with bundled Tomcat 4.0.3.

When I use UsersRolesLoginModule, I can do the Login correctly.

I have one ConfiguredIdentityLoginModule for each database. My CMP tables are correctly created.

When I try lo Login using "DatabaseServerLoginModule" I always get redirected to the error page,

without any log message on the server. My login-config.xml has the following Policies:

<application-policy name="MyFirebirdDBRealm">

<login-module code="org.jboss.resource.security.auth.spi.DatabaseServerLoginModule" flag="required">

<module-option name="dsJndiName">java:/FirebirdDS</module-option>

<module-option name="principalsQuery">SELECT passorwd FROM USERS WHERE USERNAME=?</module-option>

<module-option name="rolesQuery">SELECT roles, 'Roles' FROM USERROLES WHERE USERNAME=?</module-option>

</login-module>

</authentication>

</application-policy>

<application-policy name="MyMysql">

<login-module code="org.jboss.resource.security.auth.spi.DatabaseServerLoginModule" flag="required">

<module-option name="dsJndiName">java:/MySqlDS</module-option>

<module-option name="principalsQuery">SELECT password FROM users WHERE username='?'</module-option>

<module-option name="rolesQuery">SELECT roles, 'Roles' FROM userroles WHERE username='?'</module-option>

</login-module>

</authentication>

</application-policy>

Can any one help me, please?

Are "DatabaseServerLoginModule" and "ConfiguredIdentityLoginModule" indepenents?

Can I use "ConfiguredIdentityLoginModule" to log into one database (ex:mysql) and "DatabaseServerLoginModule" (Ex:Firebird) to validate my users?

Thanks in advance,

Victor Batista

Reply via email to