I am trying to use a DatabaseServerLoginModule entry in login-conf.xml to authenticate my application users on a MySQL 5 database. According to this page I tried my best to figure out the configuration on both JBoss 4.0.5GA and my web application in Struts. It seems to work, because if I try login with a no existing user I get back to the error login page defined in the web.xml. The problem is when I log in with an existing profile, I get an access denied by the server. It seems that the role assigned doesn't match with the web.xml.
2007-04-20 13:11:03,662 DEBUG [org.jboss.security.plugins.JaasSecurityManager.virtuaLabAccessPolicy] CallbackHandler: org.jboss.security.auth.callback.SecurityAssociationHandler@13cc05f 2007-04-20 13:11:03,663 DEBUG [org.jboss.security.plugins.JaasSecurityManagerService] Created securityMgr=org.jboss.security.plugins.JaasSecurityManager@179a4c9 2007-04-20 13:11:03,665 DEBUG [org.jboss.security.plugins.JaasSecurityManager.virtuaLabAccessPolicy] CachePolicy set to: org.jboss.util.TimedCachePolicy@131b810 2007-04-20 13:11:03,665 DEBUG [org.jboss.security.plugins.JaasSecurityManagerService] setCachePolicy, c=org.jboss.util.TimedCachePolicy@131b810 2007-04-20 13:11:03,665 DEBUG [org.jboss.security.plugins.JaasSecurityManagerService] Added virtuaLabAccessPolicy, org.jboss.security.plugins.SecurityDomainContext@12b523c to map
Thanks in advance [ April 20, 2007: Message edited by: Alessandro Ilardo ]
trying to decode a woman mind....
Joined: Dec 23, 2005
ok, with this line it works fine select userRole, 'Roles' from USR_ROLE where username=? however, what that 'Roles' stands for??