Guest User

pureftpd-mysql.conf

a guest
Nov 28th, 2012
171
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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.  
  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
Advertisement
Add Comment
Please, Sign In to add comment