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