SessionDB
Specify the name of a table to use to store DBI-based user sessions.
Synopsis
The parameter is expected to be a table name, defined using
the Database directive.
The default is blank.
Scope
This directive is only available for use in the local
(catalog.cfg) configuration file.
It will not affect any other website in any way.
This directive will not work in the global
(interchange.cfg) configuration file.
Description
This directive specifies the name of a table that should be used
to store user session information.
This is only appropriate if "DBI" is specified as the
SessionType.
|
Warning
Do not confuse this configuration directive with the similarly-named
SessionDatabase directive.
|
The parameter is expected to be a table name, defined using
the Database directive.
To make use of DBI sessions,
the SessionType
and SessionDB directives will need to be set up as follows:
SessionType DBI
SessionDB sessions
|
The "sessions" table will need to have four columns,
as follows:
Database sessions sessions.txt __SESSION_DSN__
Database sessions USER __SESSION_USER__
Database sessions PASS __SESSION_PASS__
Database sessions COLUMN_DEF "code=VARCHAR(64) NOT NULL PRIMARY KEY"
Database sessions COLUMN_DEF "session=TEXT"
Database sessions COLUMN_DEF "sessionlock=VARCHAR(64) DEFAULT '' NOT NULL"
Database sessions COLUMN_DEF "last_accessed=TIMESTAMP(14)"
|
|
|
Warning
DBI-based sessions are not recommended unless you absolutely
need them,
and know exactly what you are doing and why you're doing it.
|
