Specify a database to store SAML data

Follow these steps to specify a database different from the default database for the Genero SAML implementation.

The implementation of Genero SAML Single sign-on (SSO) requires a database, to store SAML data related to the protocol. By default, the database engine is SQLite and the database file is $FGLDIR/web_utilities/services/saml/bin/saml.db. This database is fully functional after installing the Genero Application Server.

Create a new or use a existing database, eventually on a dedicated machine, if several GAS servers are configured for load balancing. There must be a unique database, to centralize all SAML authentication data.
In the file DBase.4gl, modify the functions BDConnect() and DBDisconnect() to handle and customize the database connection. Recompile the DBase.4gl source. DBase.4gl is found in $FGLDIR/web_utilities/services/saml/src.
Modify fglprofile in $FGLDIR/web_utilities/services/saml/res to include the connection information for the database.
Create SAML tables with the CreateDatabase.4gl program. Define the database permissions required to let the Genero Application Server modification the SAML tables in the new database. CreateDatabase.4gl is found in $FGLDIR/web_utilities/services/saml/src.
If needed, define the PATH (Windows^®) or LD_LIBRARY_PATH (Linux^®/UNIX™) environment variables in $FGLDIR/web_utilities/services/SAMLServiceProvider.xcf with ENVIRONMENT_VARIABLE elements, in order to find the database client libraries required by Genero SAML service. Note that if you use SQLite (by default), you do not need to add the path to the library since it is integrated in the ODI driver on most systems. The alternate database is now used for the Genero SAML implementation.