Rechercher une page de manuel
cvm-sql
Langue: en
Version: 303119 (debian - 07/07/09)
Section: 7 (Divers)
NAME
cvm-sql - CVM SQL FrameworkQUERY SUBSTITUTION
$VAR and ${VAR} are replaced with the quoted value of the environment variable named VAR. Use the second form when VAR contains anything other than alpha-numeric or underscore (_) characters. Do not include quotes in the query. The variables account and domain contain the account and domain names given by the CVM client. $$ is replaced with a single dollar sign.QUERY RESULTS
The query must produce the following fields exactly in order. All required fields must not be null or empty.- 1.
- Password, encrypted with crypt(3) (required)
- 2.
- Actual account name (required)
- 3.
- User ID (integer) (required)
- 4.
- Group ID (integer) (required)
- 5.
- Directory (required)
- 6.
- Real name (optional)
- 7.
- Login shell (optional)
- 8.
- Group name (optional)
- 9.
- Domain name (optional)
- 10.
- System account name (optional)
- 11.
- System account directory (optional)
- 12.
- Mailbox path (optional)
DEFAULT QUERY
SELECT password, username, userid, groupid, directory, realname, shell, groupname, domain, sys_username, sys_directory FROM accounts WHERE username=$account AND domain=$domainSEE ALSO
cvm-mysql(8), cvm-pgsql(8), cvm-pwfile(8), cvm-qmail(8), cvm-unix(8), cvm-vmailmgr(8), cvm-benchclient(8), cvm-checkpassword(8), cvm-testclient(8)
http://untroubled.org/cvm/cvm.html
Contenus ©2006-2024 Benjamin Poulain
Design ©2006-2024 Maxime Vantorre