Annotation of elwix/config/etc/default/pureftpd-pgsql.conf.sample, revision 1.1.1.1
1.1 misho 1:
2: ###################################################
3: # #
4: # Sample Pure-FTPd PostgreSQL configuration file. #
5: # See README.PGSQL for explanations. #
6: # #
7: ###################################################
8:
9:
10: # If PostgreSQL listens to a TCP socket
11: PGSQLServer localhost
12: PGSQLPort 5432
13:
14: # *or* if PostgreSQL can only be reached through a local Unix socket
15: # PGSQLServer /tmp
16: # PGSQLPort .s.PGSQL.5432
17:
18: # Mandatory : user to bind the server as.
19: PGSQLUser postgres
20:
21: # Mandatory : user password. You *must* have a password.
22: PGSQLPassword rootpw
23:
24: # Mandatory : database to open.
25: PGSQLDatabase pureftpd
26:
27: # Mandatory : how passwords are stored
28: # Valid values are : "cleartext", "crypt", "md5" and "any"
29: PGSQLCrypt cleartext
30:
31: # In the following directives, parts of the strings are replaced at
32: # run-time before performing queries :
33: #
34: # \L is replaced by the login of the user trying to authenticate.
35: # \I is replaced by the IP address the user connected to.
36: # \P is replaced by the port number the user connected to.
37: # \R is replaced by the IP address the user connected from.
38: # \D is replaced by the remote IP address, as a long decimal number.
39: #
40: # Very complex queries can be performed using these substitution strings,
41: # especially for virtual hosting.
42:
43:
44: # Query to execute in order to fetch the password
45:
46: PGSQLGetPW SELECT Password FROM users WHERE User='\L'
47:
48:
49: # Query to execute in order to fetch the system user name or uid
50:
51: PGSQLGetUID SELECT Uid FROM users WHERE User='\L'
52:
53:
54: # Optional : default UID - if set this overrides PGSQLGetUID
55:
56: #PGSQLDefaultUID 1000
57:
58:
59: # Query to execute in order to fetch the system user group or gid
60:
61: PGSQLGetGID SELECT Gid FROM users WHERE User='\L'
62:
63:
64: # Optional : default GID - if set this overrides PGSQLGetGID
65:
66: #PGSQLDefaultGID 1000
67:
68:
69: # Query to execute in order to fetch the home directory
70:
71: PGSQLGetDir SELECT Dir FROM users WHERE User='\L'
72:
73:
74: # Optional : query to get the maximal number of files
75: # Pure-FTPd must have been compiled with virtual quotas support.
76:
77: # PGSQLGetQTAFS SELECT QuotaFiles FROM users WHERE User='\L'
78:
79:
80: # Optional : query to get the maximal disk usage (virtual quotas)
81: # The number should be in Megabytes.
82: # Pure-FTPd must have been compiled with virtual quotas support.
83:
84: # PGSQLGetQTASZ SELECT QuotaSize FROM users WHERE User='\L'
85:
86:
87: # Optional : ratios. The server has to be compiled with ratio support.
88:
89: # PGSQLGetRatioUL SELECT ULRatio FROM users WHERE User='\L'
90: # PGSQLGetRatioDL SELECT DLRatio FROM users WHERE User='\L'
91:
92:
93: # Optional : bandwidth throttling.
94: # The server has to be compiled with throttling support.
95: # Values are in KB/s .
96:
97: # PGSQLGetBandwidthUL SELECT ULBandwidth FROM users WHERE User='\L'
98: # PGSQLGetBandwidthDL SELECT DLBandwidth FROM users WHERE User='\L'
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>