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

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: