Guest User

pureftpd-mysql.conf

a guest
Nov 29th, 2012
172
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.51 KB | None | 0 0
  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 /var/lib/mysql/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 password
  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 md5
  46. #MYSQLCrypt cleartext
  47.  
  48.  
  49. # In the following directives, parts of the strings are replaced at
  50. # run-time before performing queries :
  51. #
  52. # \L is replaced by the login of the user trying to authenticate.
  53. # \I is replaced by the IP address the user connected to.
  54. # \P is replaced by the port number the user connected to.
  55. # \R is replaced by the IP address the user connected from.
  56. # \D is replaced by the remote IP address, as a long decimal number.
  57. #
  58. # Very complex queries can be performed using these substitution strings,
  59. # especially for virtual hosting.
  60.  
  61.  
  62. # Query to execute in order to fetch the password
  63.  
  64. MYSQLGetPW SELECT Password FROM users WHERE User='\L'
  65.  
  66.  
  67. # Query to execute in order to fetch the system user name or uid
  68.  
  69. MYSQLGetUID SELECT Uid FROM users WHERE User='\L'
  70.  
  71.  
  72. # Optional : default UID - if set this overrides MYSQLGetUID
  73.  
  74. #MYSQLDefaultUID 1000
  75.  
  76.  
  77. # Query to execute in order to fetch the system user group or gid
  78.  
  79. MYSQLGetGID SELECT Gid FROM users WHERE User='\L'
  80.  
  81.  
  82. # Optional : default GID - if set this overrides MYSQLGetGID
  83.  
  84. #MYSQLDefaultGID 1000
  85.  
  86.  
  87. # Query to execute in order to fetch the home directory
  88.  
  89. MYSQLGetDir SELECT Dir FROM users WHERE User='\L'
  90.  
  91.  
  92. # Optional : query to get the maximal number of files
  93. # Pure-FTPd must have been compiled with virtual quotas support.
  94.  
  95. # MySQLGetQTAFS SELECT QuotaFiles FROM users WHERE User='\L'
  96.  
  97.  
  98. # Optional : query to get the maximal disk usage (virtual quotas)
  99. # The number should be in Megabytes.
  100. # Pure-FTPd must have been compiled with virtual quotas support.
  101.  
  102. # MySQLGetQTASZ SELECT QuotaSize FROM users WHERE User='\L'
  103.  
  104.  
  105. # Optional : ratios. The server has to be compiled with ratio support.
  106.  
  107. # MySQLGetRatioUL SELECT ULRatio FROM users WHERE User='\L'
  108. # MySQLGetRatioDL SELECT DLRatio FROM users WHERE User='\L'
  109.  
  110.  
  111. # Optional : bandwidth throttling.
  112. # The server has to be compiled with throttling support.
  113. # Values are in KB/s .
  114.  
  115. # MySQLGetBandwidthUL SELECT ULBandwidth FROM users WHERE User='\L'
  116. # MySQLGetBandwidthDL SELECT DLBandwidth FROM users WHERE User='\L'
  117.  
  118. # Enable ~ expansion. NEVER ENABLE THIS BLINDLY UNLESS :
  119. # 1) You know what you are doing.
  120. # 2) Real and virtual users match.
  121.  
  122. # MySQLForceTildeExpansion 1
  123.  
  124.  
  125. # If you're using a transactionnal storage engine, you can enable SQL
  126. # transactions to avoid races. Leave this commented if you are using the
  127. # traditionnal MyIsam engine.
  128.  
  129. # MySQLTransactions On
Advertisement
Add Comment
Please, Sign In to add comment