File: sql.html

package info (click to toggle)
cvm 0.97-2
  • links: PTS, VCS
  • area: main
  • in suites: bullseye
  • size: 1,064 kB
  • sloc: ansic: 4,065; sh: 2,730; makefile: 29; sql: 15
file content (41 lines) | stat: -rw-r--r-- 1,336 bytes parent folder | download | duplicates (8)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
<html>
<body>

<h2><a href="cvm.html">CVM</a></h2>

<h1>CVM SQL Framework</h1>

<p><b>Query Substitution:</b> <tt>$VAR</tt> and <tt>${VAR}</tt> are
replaced with the <i>quoted</i> value of the environment variable
named <tt>VAR</tt>.  Use the second form when <tt>VAR</tt> contains
anything other than alpha-numeric or underscore (<tt>_</tt>)
characters.  Do not include quotes in the query.  The variables
<tt>account</tt> and <tt>domain</tt> contain the account and domain
names given by the CVM client.  <tt>$$</tt> is replaced with a single
dollar sign.</p>

<p><b>Query Results:</b> The query must produce the following fields
exactly in order.  All required fields must not be null or empty.</p>

<ol>
<li>Password, encrypted with <tt>crypt</tt> (required)
<li>Actual account name (required)
<li>User ID (integer) (required)
<li>Group ID (integer) (required)
<li>Directory (required)
<li>Real name (optional)
<li>Login shell (optional)
<li>Group name (optional)
<li>Domain name (optional)
<li>System account name (optional)
<li>System account directory (optional)
<li>Mailbox path (optional)
</ol>

<p><b>Default Query:</b> <tt>SELECT password, username, userid,
groupid, directory, realname, shell, groupname, domain, sys_username,
sys_directory FROM accounts WHERE username=$account AND
domain=$domain</tt></p>

</body>
</html>