Hi,
I found that the module-option's are not used by the authentication policy.
For testing this, I have voluntarly change the principalsQuery from :
<snip>
<module-option name="principalsQuery">select Password from Principals where
PrincipalID=?</module-option>
</snip>
to
<snip>
<module-option name="principalsQuery">select Password from
Princiiiiiiiiiipals where PrincipalID=?</module-option>
</snip>
After restarting JBoss to use the new config, I still get the same error (the
database used is the defaultDS database using hsqldb) and, as you can notice
in the error message provided, the query for retrieving the principal is not
modified with my messed up query.
<snip>
[DatabaseServerLoginModule] Query failed
java.sql.SQLException: Table not found: PRINCIPALS in statement [select
Password from Principals where PrincipalID='valid']
at org.hsqldb.Trace.getError(Trace.java:180)
at org.hsqldb.Result.<init>(Result.java:175)
at org.hsqldb.jdbcConnection.executeHSQL(jdbcConnection.java:907)
</snip>
I don't think JBoss corrects my queries on the fly so I guess these tags (the
three module-option) are not used.
Any ideas ?
thanks,
ionel
Scott M Stark wrote:
> You already have by
> <module-option name="dsJndiName">java:/PasswordDS</module-option>
>
> You have to validate that java:/PasswordDS actually points to your
> database connection factory.
>
> xxxxxxxxxxxxxxxxxxxxxxxx
> Scott Stark
> Chief Technology Officer
> JBoss Group, LLC
> xxxxxxxxxxxxxxxxxxxxxxxx
-------------------------------------------------------
Sponsored by:
ThinkGeek at http://www.ThinkGeek.com/
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
