DatabaseLoginModule does not recognize password (but finds P

[jochenriekhof]

Hi...

I am stuck with the DatabaseLoginModule. I made a simple table (Oracle) containing a user/password pair.
Module config is:
testapp {
org.jboss.security.auth.spi.DatabaseServerLoginModule required
dsJndiName="java:/OraConnTest"
principalsQuery="select Password from Principals where PrincipalID=?"
rolesQuery="select Role, RoleGroup from Roles where PrincipalID=?"
;
};

Here is the error message:
...
User 'jri' authenticated.
[TestSession] Bad password for username=jri
[TestSession] LoginException: Password Incorrect/Password Required
...

Any idea? I had a look into the DatabaseLoginModule code and it seems that the query succeded (password is definitely the same as in client).
I also made a test app with the copied-out code from DatabaseLoginModule an it worked. Also when I remove the PrincipalID form the db the error reads:
...
[TestSession] LoginException: No matching username found in Principals
[TestSession] Authentication exception, principal=jri
...

Ciao

...Jochen

[juliaac]

Everything looks OK to me, I have the same setup and it works. The only time I get that error is when the password is actually wrong. All I can suggest is, check the password in the DB for leading or trailing spaces and make sure the password is in the correct case (Oracle passwords are not case sensitive, but JBoss passwords are).

G'luck.

[jochenriekhof]

thanks for your reply. As I found out the problem lies elsewhere: the other-config is called in addition to my own. See thread "Why is auth.conf-other always called". Still no good solution :-( (I copied my config settings into other, too, so my ejbs get authenticated twice, but at least, it works).