6.4. Special parameters for database connections

This section describes some special parameters for the database connection.

6.4.1. Pool recyle

This is a special parameter for the SQL Audit module.

After this certain amount of time (in seconds) connections from the database connection pool will not be used anymore:

linotpAudit.sql.pool_recyle = 3600

6.4.2. Implicit returning

PostgreSQL, Oracle and MS SQL support RETURNING 1.

implicit_returning indicates that RETURNING can be used by default to fetch newly inserted primary key values. 2 In certain scenarios like redundant MS SQL servers it is reported that this causes problems. In the linotp.ini this can be turned off by adding the config:

linotpSQL.implicit_returning = False