</web-app> login-config.xml conatins <application-policy name = "wizomLogin"> <authentication> <login-module code = "org.jboss.security.auth.spi.DatabaseServerLoginModule" flag = "required"> <module-option name = "dsJndiName">java:mySqlWizom</module-option> <module-option name = "principalsQuery">Select password from userInfo where userInfo.username=?</module-option> <module-option name = "rolesQuery">Select role,'Roles' from wizomRole where wizomRole.username=?</module-option> <module-option name="unauthenticatedIdentity">guest</module-option> </login-module> </authentication> </application-policy> database conatins tables userInfo with username and password wizom wizom wizomRole with username and role wizom WebUserApp
still login does not work instead if i used application policy that reads username password roles from file that will work.
It would help if you used ubb tags so that the source would be easier to read. (You can edit your post to add the codes, click on the icon showing a pencil over a piece of paper at the top of your post.)
Are there an error shown in the console log? Is the mySqlWizom data source properly define (you did not post the *-ds.xml file)? Did the console log show the data source being deployed?
"sumeet s", Your account is about to be closed. You've been given the following instructions more that 3 times now and continue to set your account up with invalid screen names. If you post to the ranch again with an invalid screen name or change your screen name to something else that is invalid, your account will be closed.
PS: Disabling your private messages is not the way to deal with this issue.
In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious. Initials are OK for the first and middle names but not the last. You can change it here
subject: jboss form based database login using login-config