In addition to the parameters that apply to all repository types, you can configure the parameters in this section for database repositories.
NOTE: If you want to set up multiple database repositories, you can also configure these parameters in the [Default]
section (if you also have other repository types set up, they are not affected by these settings).
The configuration for each type of database connection is identical, except that:
GroupServerLibrary must be set to the correct library. Set this parameter to one of:
ogs_dboracle
(Windows/UNIX)
ogs_dbodbc
(Windows)
ogs_dbiodbc
(UNIX)
ogs_dbunixodbc
(UNIX)
The following example shows how to retrieve user and group information from a database:
[ODBC] GroupServerLibrary=ogs_dbodbc ConnectionString=DSN=Groups SQLStatement=SELECT DISTINCT Username FROM Groups AddType=USER UserColumn=Username
[Oracle] GroupServerLibrary=ogs_dboracle ConnectionString=USER/PASSWORD@TNS_ALIAS SQLStatement=SELECT DISTINCT Username FROM Groups AddType=USER UserColumn=Username
|