MySQLLoginModule

Last modified by RaffaelloPelagalli on 2005/10/07 15:28

MySQLLoginModule

description

This loginModule permits a MySQL database-based authentication for your web application.

General parameters

namemandatoryvaluesdescription
JG_USERnoAny value valid for a database table nameThis optional parameter permits to override the default user table name (JG_USER) used when this parameter is not set
JG_ROLEnoAny value valid for a database table nameThis optional parameter permits to override the default role table name (JG_ROLE) used when this parameter is not set
JG_USER_ROLEnoAny value valid for a database table nameThis optional parameter permits to override the default name (JG_USER_ROLE),for the table which link user and role, used when this parameter is not set
JG_CREDENTIALnoAny value valid for a database table nameThis optional parameter permits to override the default credentials table name (JG_CREDENTIAL) used when this parameter is not set

DriverManager-related parameters

these parameters are mandatory if JNDI parameters are not set.

namemandataoryvaluesdescription
authenticationUrlyesa jdbc-like URL valueThis URL permits to establish a connection through the driver to the database.
authenticationLoginyesany valueThis parameter defines the database login used to establish the connection.
authenticationPasswordyesany valueThis parameter defines the database password used to establish the connection.
authenticationDriveryesany valueThis parameter defines the driver class name used to establish the connection.

JNDI-related parameters

these parameters, permits to reach a DataSource. there are optional. *note: JNDI parameters are EXPERIMENTAL, and have not been tested.

It appears JNDI references on TOMCAT cannot be reach from outside: jGuard requires this until a better solution will be find, for a classloader reason.
So, these parameters will NOT work on TOMCAT (if you find a way to do it, say it!), but should work on application servers which permit to reach JNDI references from outside the servlet container.*

namemandatoryvaluesdescription
JNDInotrue or falseThis parameter is mandatory if you want to use the JNDI stuff. if this parameter is set to true, DriverManager-related parameters will be ignored, and JNDI-related parameters will be used; otherwise, only DriverManager-related parameters will be used.
INITIAL_CONTEXT_FACTORYnofactory class nameparameter used to retrieve an InitialContext.
PROVIDER_URLno URL of the provider
OBJECT_FACTORIESno  
URL_PKG_PREFIXESno  
DNS_URLno  
STATE_FACTORIESno  
AUTHORITATIVEno  
BATCHSIZEno  
REFERRALno  
SECURITY_PROTOCOLno  
SECURITY_AUTHENTICATIONno  
SECURITY_PRINCIPALno  
SECURITY_CREDENTIALSno  
LANGUAGEno  
Tags:
Created by diabolo512 on 2005/10/07 15:27

jGuard team copyright 2004-2009
3.1.1