SQLUserInfo

Name

SQLUserInfo -- Configure the user table and fields that hold user information

Synopsis

SQLUserInfo [ user-table user-name passwd uid gid home-dir shell]

Default

"users userid passwd uid gid homedir shell"

Context

server config, <Global>, <VirtualHost>

Module

mod_sql

Compatibility

1.2.5rc1 and later

Description

The SQLUserInfo directive configures the user table and fields that hold user information. If you need to change any of these field names from the default, you must specify all of them, whether NULL or not. The parameters are described below:

As of 1.2.9rc1, the SQLUserInfo directive accepts an alternate syntax:

  SQLUserInfo custom:/name

where name refers to a configured SELECT SQLNamedQuery. This named query must return one row, and return the following columns, in this order: username, passwd, uid, gid, homedir, shell. The configured query may make use of the variables mentioned in the SQLLog description. This syntax allows the administrator a flexible way of constructing queries as needed. Note that if you want use the given USER name, you should use the %U variable, not %u; the latter requires the locally authenticated user name, which is exactly what SQLUserInfo is meant to provide.

See also

SQLLog SQLNamedQuery

Examples