Guest User

pureftpd-mysql.conf

a guest
Nov 28th, 2012
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.50 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 cijemigra
  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're using a transactionnal storage engine, you can enable SQL
  125. # transactions to avoid races. Leave this commented if you are using the
  126. # traditionnal MyIsam engine.
  127.  
  128. # MySQLTransactions On
Advertisement
Add Comment
Please, Sign In to add comment