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     ! 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'