Return to pureftpd-mysql.conf.sample CVS log

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

Annotation of elwix/config/etc/default/pureftpd-mysql.conf.sample, revision 1.1

1.1     ! misho       1: 
        !             2: ##############################################
        !             3: #                                            #
        !             4: # Sample Pure-FTPd Mysql configuration file. #
        !             5: # See README.MySQL for explanations.         #
        !             6: #                                            #
        !             7: ##############################################
        !             8: 
        !             9: 
        !            10: # Optional : MySQL server name or IP. Don't define this for unix sockets.
        !            11: 
        !            12: # MYSQLServer     127.0.0.1
        !            13: 
        !            14: 
        !            15: # Optional : MySQL port. Don't define this if a local unix socket is used.
        !            16: 
        !            17: # MYSQLPort       3306
        !            18: 
        !            19: 
        !            20: # Optional : define the location of mysql.sock if the server runs on this host.
        !            21: 
        !            22: MYSQLSocket     /tmp/mysql.sock
        !            23: 
        !            24: 
        !            25: # Mandatory : user to bind the server as.
        !            26: 
        !            27: MYSQLUser       root
        !            28: 
        !            29: 
        !            30: # Mandatory : user password. You must have a password.
        !            31: 
        !            32: MYSQLPassword   rootpw
        !            33: 
        !            34: 
        !            35: # Mandatory : database to open.
        !            36: 
        !            37: MYSQLDatabase   pureftpd
        !            38: 
        !            39: 
        !            40: # Mandatory : how passwords are stored
        !            41: # Valid values are : "cleartext", "crypt", "md5" and "password"
        !            42: # ("password" = MySQL password() function)
        !            43: # You can also use "any" to try "crypt", "md5" *and* "password"
        !            44: 
        !            45: MYSQLCrypt      cleartext
        !            46: 
        !            47: 
        !            48: # In the following directives, parts of the strings are replaced at
        !            49: # run-time before performing queries :
        !            50: #
        !            51: # \L is replaced by the login of the user trying to authenticate.
        !            52: # \I is replaced by the IP address the user connected to.
        !            53: # \P is replaced by the port number the user connected to.
        !            54: # \R is replaced by the IP address the user connected from.
        !            55: # \D is replaced by the remote IP address, as a long decimal number.
        !            56: #
        !            57: # Very complex queries can be performed using these substitution strings,
        !            58: # especially for virtual hosting.
        !            59: 
        !            60: 
        !            61: # Query to execute in order to fetch the password
        !            62: 
        !            63: MYSQLGetPW      SELECT Password FROM users WHERE User="\L"
        !            64: 
        !            65: 
        !            66: # Query to execute in order to fetch the system user name or uid
        !            67: 
        !            68: MYSQLGetUID     SELECT Uid FROM users WHERE User="\L"
        !            69: 
        !            70: 
        !            71: # Optional : default UID - if set this overrides MYSQLGetUID
        !            72: 
        !            73: #MYSQLDefaultUID 1000
        !            74: 
        !            75: 
        !            76: # Query to execute in order to fetch the system user group or gid
        !            77: 
        !            78: MYSQLGetGID     SELECT Gid FROM users WHERE User="\L"
        !            79: 
        !            80: 
        !            81: # Optional : default GID - if set this overrides MYSQLGetGID
        !            82: 
        !            83: #MYSQLDefaultGID 1000
        !            84: 
        !            85: 
        !            86: # Query to execute in order to fetch the home directory
        !            87: 
        !            88: MYSQLGetDir     SELECT Dir FROM users WHERE User="\L"
        !            89: 
        !            90: 
        !            91: # Optional : query to get the maximal number of files 
        !            92: # Pure-FTPd must have been compiled with virtual quotas support.
        !            93: 
        !            94: # MySQLGetQTAFS  SELECT QuotaFiles FROM users WHERE User="\L"
        !            95: 
        !            96: 
        !            97: # Optional : query to get the maximal disk usage (virtual quotas)
        !            98: # The number should be in Megabytes.
        !            99: # Pure-FTPd must have been compiled with virtual quotas support.
        !           100: 
        !           101: # MySQLGetQTASZ  SELECT QuotaSize FROM users WHERE User="\L"
        !           102: 
        !           103: 
        !           104: # Optional : ratios. The server has to be compiled with ratio support.
        !           105: 
        !           106: # MySQLGetRatioUL SELECT ULRatio FROM users WHERE User="\L"
        !           107: # MySQLGetRatioDL SELECT DLRatio FROM users WHERE User="\L"
        !           108: 
        !           109: 
        !           110: # Optional : bandwidth throttling.
        !           111: # The server has to be compiled with throttling support.
        !           112: # Values are in KB/s .
        !           113: 
        !           114: # MySQLGetBandwidthUL SELECT ULBandwidth FROM users WHERE User="\L"
        !           115: # MySQLGetBandwidthDL SELECT DLBandwidth FROM users WHERE User="\L"
        !           116: 
        !           117: # Enable ~ expansion. NEVER ENABLE THIS BLINDLY UNLESS :
        !           118: # 1) You know what you are doing.
        !           119: # 2) Real and virtual users match.
        !           120: 
        !           121: # MySQLForceTildeExpansion 1
        !           122: 
        !           123: 
        !           124: # If you upgraded your tables to transactionnal tables (Gemini,
        !           125: # BerkeleyDB, Innobase...), you can enable SQL transactions to
        !           126: # avoid races. Leave this commented if you are using the
        !           127: # traditionnal MyIsam databases or old (< 3.23.x) MySQL versions.
        !           128: 
        !           129: # MySQLTransactions On
        !           130: