aspose file tools*
The moose likes JBoss/WildFly and the fly likes Form based login = please help Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "Form based login = please help" Watch "Form based login = please help" New topic
Author

Form based login = please help

vipul patel
Ranch Hand

Joined: Oct 16, 2005
Posts: 146
Hi All,

I am having an existing project where form based login is implemented. It has database table and login.jsp. I tried to figure out how j_security_check is linked to the database for pulling user out and validating.

i got login-config.xml file in my JBoss server. It has following.

- <application-policy name="ioclpower_domain">
- <!--
A simple server login module, which can be used when the number
of users is relatively small. It uses two properties files:
users.properties, which holds users (key) and their password (value).
roles.properties, which holds users (key) and a comma-separated list of
their roles (value).
The unauthenticatedIdentity property defines the name of the principal
that will be used when a null username and password are presented as is
the case for an unuathenticated web client or MDB. If you want to
allow such users to be authenticated add the property, e.g.,
unauthenticatedIdentity="nobody"


-->
- <authentication>
- <login-module code="org.jboss.security.auth.spi.DatabaseServerLoginModule" flag="required">
<module-option name="dsJndiName">java:/SLBDataSource</module-option>
<module-option name="principalsQuery">Select USERPASS from UM_USERS_FORJAAS where USERID = ?</module-option>
<module-option name="rolesQuery">Select SYSROLE 'Roles', USERROLEGROUPS 'RoleGroups' from UM_USERSYSROLES_FORJAAS where USERID = ?</module-option>
<module-option name="hashAlgorithm">MD5</module-option>
<module-option name="hashEncoding">base64</module-option>
</login-module>
</authentication>
- <!--
<authentication>
<login-module code = "org.jboss.security.auth.spi.UsersRolesLoginModule"
flag = "required" >
<module-option name="usersProperties">iocl.users</module-option>
<module-option name="rolesProperties">iocl.roles</module-option>
</login-module>
</authentication>

-->
</application-policy>


can anybody explain about above thing?
where is it checking the password? is there any standard for database table names and field names?

thanks in advance.
Daniel Rhoades
Ranch Hand

Joined: Jun 30, 2004
Posts: 186
You can use what ever table names and column names you like, you just have to define a valid SQL query in the principlesQuery to select the user's password when their username is queried, i.e.

SELECT password FROM users WHERE user_id = ?

The rolesQuery then selects the primary key from the roles table:

SELECT role_id, 'Roles' FROM roles WHERE user_id = ?

Table structure


Drinking more tea is the key...
 
 
subject: Form based login = please help