Examples of JDBCRealm in Glassfish, step by step

PLAIN PASSWORD EXAMPLE:

Properties specific to this Class

Identifier for the login module to use for this realm  

JNDI name of the JDBC resource used by this realm  

Name of the database table that contains the list of authorized users for this realm  

Name of the column in the user table that contains the list of user names  

Name of the column in the user table that contains the user passwords  

Name of the database table that contains the list of groups for this realm  

Name of the column in the user group table that contains the list of groups for this realm  

Name of the column in the group table that contains the list of group names  

Comma-separated list of group names  

Specify the database user name in the realm instead of the JDBC connection pool  

Specify the database password in the realm instead of the JDBC connection pool  

Digest algorithm (default is SHA-256); note that the default was MD5 in GlassFish versions prior to 3.1  

This denotes the algorithm for encrypting the passwords in the database. It is a security risk to leave this field empty.  

Encoding (allowed values are Hex and Base64)  

Character set for the digest algorithm



********************************
Now change Digest Algorithm  from "none" to "SHA-256" or just leave it empty, glassfish defaults to "SHA-256"

Update your password use something like:

update subusers s set s.passwd_a=sha2(s.password,256);

Properties specific to this Class

Identifier for the login module to use for this realm  

JNDI name of the JDBC resource used by this realm  

Name of the database table that contains the list of authorized users for this realm  

Name of the column in the user table that contains the list of user names  

Name of the column in the user table that contains the user passwords  

Name of the database table that contains the list of groups for this realm  

Name of the column in the user group table that contains the list of groups for this realm  

Name of the column in the group table that contains the list of group names  

Comma-separated list of group names  

Specify the database user name in the realm instead of the JDBC connection pool  

Specify the database password in the realm instead of the JDBC connection pool  

Digest algorithm (default is SHA-256); note that the default was MD5 in GlassFish versions prior to 3.1  

This denotes the algorithm for encrypting the passwords in the database. It is a security risk to leave this field empty.  

Encoding (allowed values are Hex and Base64)  

Character set for the digest algorithm  

Featured Post

Updated Coupons / promo codes for Google Apps for Work / Business

To redeem: 1. Sign up for Google Apps   2. Go to your billing settings  3. Choose your payment plan  4. Enter your promo code ...