pure-ftp加载conf不能启动【解决】

如止水

ports安装好pure-ftp， /usr/local/sbin/pure-config.pl /usr/local/etc/pure-ftpd.conf.sample
可以启动，但是当我修改  

# MySQLConfigFile               /etc/pureftpd-mysql.conf 默认项
MySQLConfigFile         /usr/local/etc/pureftpd-mysql.conf  修改后选项

pure不能启动


/usr/local/etc/pureftpd-mysql.conf
内容如下

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

复制代码

我哪里出了问题，请各位朋友给指条明路，小弟现行谢过了

[ 本帖最后由 如止水 于 2008-8-31 17:02 编辑 ]

xpban2006

MySQLConfigFile          /usr/local/etc/pureftpd-mysql.conf
CreateHomeDir           yes

如止水

出上面的问题时      cat /var/log/messages

Unknown authentication method: mysql:/usr/local/etc/pureftpd-mysql.conf

/usr/ports/ftp/pure-ftpd下 make install时没有选择mysql、ldap等支持，后来重新make config时选择了mysql、 pam、ldap多种支持，

最后解决 /usr/ports/ftp/pure-ftpd下 make deinstall;make clean
然后make config 选择一项mysql支持,make install

然后通过