Return to pureftpd-pgsql.conf.sample CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / elwix / config / etc / default

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'