晕死啊，启动pureftp出现"无效的SQL语句"421错误！

skysnowolf

刚装过pureftp，一切正常，今天在另一台机器上装，出现这种无聊的错误，偶的配置文件是完全一样的啊

#/usr/local/sbin/pure-config.pl /usr/local/etc/pure-ftpd.conf
Running: /usr/local/sbin/pure-ftpd -A -b -c10 -B -C3 -D -E -fftp -H -I15 -lmysql:/usr/local/etc/pureftpd-mysql.conf -L2000:8 -m4 -s -T300 -U133:022 -u2000 -w -Ow3c:/var/log/pureftpd.log -R -j -k99 -Z
421 配置错误: 无效的SQL语句: /usr/local/etc/pureftpd-mysql.conf

pureftpd-mysql.conf:

1. 
   
2. 
   
3. ##############################################
   
4. #                                            #
   
5. # Sample Pure-FTPd Mysql configuration file. #
   
6. # See README.MySQL for explanations.         #
   
7. #                                            #
   
8. ##############################################
   
9. 
   
10. 
    
11. # Optional : MySQL server name or IP. Don't define this for unix sockets.
    
12. 
    
13. MYSQLServer     192.168.0.2
    
14. 
    
15. 
    
16. # Optional : MySQL port. Don't define this if a local unix socket is used.
    
17. 
    
18. MYSQLPort       3306
    
19. 
    
20. 
    
21. # Optional : define the location of mysql.sock if the server runs on this host.
    
22. 
    
23. MYSQLSocket     /tmp/mysql.sock
    
24. 
    
25. 
    
26. # Mandatory : user to bind the server as.
    
27. 
    
28. MYSQLUser       pureftpd
    
29. 
    
30. 
    
31. # Mandatory : user password. You must have a password.
    
32. 
    
33. MYSQLPassword   xxxxx
    
34. 
    
35. 
    
36. # Mandatory : database to open.
    
37. 
    
38. MYSQLDatabase   pureftpd
    
39. 
    
40. 
    
41. # Mandatory : how passwords are stored
    
42. # Valid values are : "cleartext", "crypt", "md5" and "password"
    
43. # ("password" = MySQL password() function)
    
44. # You can also use "any" to try "crypt", "md5" *and* "password"
    
45. 
    
46. MYSQLCrypt      md5
    
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 2000
    
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 2000
    
85. 
    
86. 
    
87. # Query to execute in order to fetch the home directory
    
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 upgraded your tables to transactionnal tables (Gemini,
     
125. # BerkeleyDB, Innobase...), you can enable SQL transactions to
     
126. # avoid races. Leave this commented if you are using the
     
127. # traditionnal MyIsam databases or old (< 3.23.x) MySQL versions.
     
128. 
     
129. MySQLTransactions On
     
130. 
     

复制代码

剑心通明

数据库pureftpd有吗？用户pureftpd有吗？

剑心通明

http://bbs.chinaunix.net/forum/viewtopic.php?t=591054&show_type=
参考这个帖子试试吧

skysnowolf

晕死啊，那个Makefile就算多个空格，都会出些很奇怪的问题。奉劝大家对Makefile添加东西时，小心点。

剑心通明

只知道mrtg的配置文件多空格会不对，Makefile的好像没这么严重吧