i did find a way....
the problem is here:
<module-option name="principalsQuery">Select password from usuarios where
idusuario =?</module-option>
<module-option name="rolesQuery">Select R.role AS Roles, G.descripcion AS
RoleGroups from gruposusuarios GU,roles R, grupos G where idusuario =? AND
GU.idrole=R.idrole AND GU.idgrupo=G.idgrupo</module-option>
To solve this I did a view of my table to simplify the long query but
for a strange reason the rolesQuery and the principalsQuery does not
work with views so:
I change my tables
<module-option name="principalsQuery">select Password from
Principals where PrincipalID=?</module-option>
<module-option name="rolesQuery">select Role, RoleGroup from RRoles
where PrincipalID=?</module-option>
(notice I used "AS ROLES" insted of ROLE and RoleGroups insted of RoleGroup but
it was not all the reason of the failure mybe i can't use
views neither long querys with joins ???)
And now I can authenticate with out the problem listed before.
But this solution only works for BASIC authentication, FORM based
authentication does not.
I don't know why.
Any idea about why views does not work and why with my configuration
only BASIC authentication works? regards
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3875137#3875137
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3875137
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
