VPS侦探论坛

标题: Pureftpd 530 问题。 [打印本页]
作者: 啥都不会    时间: 2016-1-29 17:47
标题: Pureftpd 530 问题。
军哥，遇到另外一个问题
Pureftpd的 530问题
找了下网站上的提示，可能是下面文件和mysql的问题


/usr/local/pureftpd/pureftpd-mysql.conf
和ftp/config.php 都验证过，没问题


我仔细验证过， mysql 用ftp的账户是可以登录的, root 和 ftp的密码都没有问题。


百度了下其他人解决办法，说什么UID 必须大于 100，或者小于100的，都已经试过，也重装过pureftpd，
但是依旧提示 530.


iptables 防火墙，也关闭过，重启过，规则也没有问题。不知道为啥了。

多谢军哥。


环境是 centos7 64位，


刚装完lnmpa1.2的时候是好使的，后来装了IMAP 和 SENDMAIL 之后。。就这样了。。


[attach]3014[/attach]



[attach]3015[/attach]



[attach]3016[/attach]



[attach]3017[/attach]





多谢

作者: licess    时间: 2016-1-29 19:45
开pureftpd日志看看
作者: 啥都不会    时间: 2016-1-31 12:27
军哥日志文件。

多谢。

[attach]3019[/attach]
作者: licess    时间: 2016-2-1 13:29
标题: 回复 3# 的帖子
看一下是否存在其他ftpserver或其他软件占用了21端口
作者: 啥都不会    时间: 2016-2-1 13:36
FTP 只装了这一个[attach]3020[/attach]


多谢军哥
[attach]3021[/attach]



[attach]3022[/attach]

[ 本帖最后由 啥都不会 于 2016-2-1 13:38 编辑 ]
作者: licess    时间: 2016-2-1 20:05
标题: 回复 5# 的帖子
kill掉后，再start看看
作者: 啥都不会    时间: 2016-2-1 20:33
军哥

KILL 掉进程后，再重启 问题依旧。
作者: 啥都不会    时间: 2016-2-1 20:35
最新日志：
[attach]3023[/attach]
作者: 啥都不会    时间: 2016-2-1 20:37
然后

138的这个 IP  是 客户端，本机 IP

LNMP 的主机是 ，在虚拟机里，IP 是 ：220

mysql  再次确认，联通没问题。


[attach]3024[/attach]

[ 本帖最后由 啥都不会 于 2016-2-1 21:28 编辑 ]
作者: licess    时间: 2016-2-2 10:36
标题: 回复 8# 的帖子
后面的日志发完整的文本，别截图
作者: 啥都不会    时间: 2016-2-2 16:49
  1. Jan 31 12:18:08 localhost pure-ftpd: (?@?) [ERROR] Unable to start a standalone server: [Address already in use]
  2. Jan 31 12:18:36 localhost pure-ftpd: (?@?) [ERROR] Unable to start a standalone server: [Address already in use]
  3. Jan 31 12:21:00 localhost pure-ftpd: (?@?) [ERROR] Unable to start a standalone server: [Address already in use]
  4. Jan 31 12:21:20 localhost pure-ftpd: (?@?) [ERROR] Unable to start a standalone server: [Address already in use]
  5. Jan 31 14:18:37 localhost pure-ftpd: (?@192.168.1.138) [INFO] New connection from 192.168.1.138
  6. Jan 31 14:18:37 localhost pure-ftpd: (?@192.168.1.138) [ERROR] The SQL server seems to be down [Can't connect to local MySQL $
  7. Jan 31 14:18:41 localhost pure-ftpd: (?@192.168.1.138) [WARNING] Authentication failed for user [ftp]
  8. Jan 31 14:18:41 localhost pure-ftpd: (?@192.168.1.138) [INFO] Logout.
  9. Jan 31 22:27:14 localhost pure-ftpd: (?@192.168.1.138) [INFO] New connection from 192.168.1.138
  10. Jan 31 22:27:14 localhost pure-ftpd: (?@192.168.1.138) [ERROR] The SQL server seems to be down [Can't connect to local MySQL $
  11. Jan 31 22:27:18 localhost pure-ftpd: (?@192.168.1.138) [WARNING] Authentication failed for user [ftp]
  12. Jan 31 22:27:18 localhost pure-ftpd: (?@192.168.1.138) [INFO] Logout.
  13. Feb  1 05:20:41 localhost pure-ftpd: (?@192.168.1.138) [INFO] New connection from 192.168.1.138
  14. Feb  1 05:20:41 localhost pure-ftpd: (?@192.168.1.138) [ERROR] The SQL server seems to be down [Can't connect to local MySQL $
  15. Feb  1 05:20:47 localhost pure-ftpd: (?@192.168.1.138) [WARNING] Authentication failed for user [ftp]
  16. Feb  1 05:20:47 localhost pure-ftpd: (?@192.168.1.138) [INFO] Logout.
  17. Feb  1 05:26:20 localhost pure-ftpd: (?@192.168.1.138) [INFO] New connection from 192.168.1.138
  18. Feb  1 05:26:20 localhost pure-ftpd: (?@192.168.1.138) [ERROR] The SQL server seems to be down [Can't connect to local MySQL $
  19. Feb  1 05:26:25 localhost pure-ftpd: (?@192.168.1.138) [WARNING] Authentication failed for user [ftp]
  20. Feb  1 05:26:25 localhost pure-ftpd: (?@192.168.1.138) [INFO] Logout.
复制代码
作者: 啥都不会    时间: 2016-2-2 16:58
mysql的FTP 信息，已经验证过
用户名：ftp
密码：ftp
都没问题。


[attach]3026[/attach]


[attach]3027[/attach]
作者: licess    时间: 2016-2-2 20:56
[ERROR] The SQL server seems to be down [Can't connect to local MySQL $
这个不可能就到这个地方吧，后面应该还有吧
作者: 啥都不会    时间: 2016-2-3 14:48
a 啊，还真是。。。SSH 没复制全。。
  1. Jan 31 12:18:08 localhost pure-ftpd: (?@?) [ERROR] Unable to start a standalone server: [Address already in use]
  2. Jan 31 12:18:36 localhost pure-ftpd: (?@?) [ERROR] Unable to start a standalone server: [Address already in use]
  3. Jan 31 12:21:00 localhost pure-ftpd: (?@?) [ERROR] Unable to start a standalone server: [Address already in use]
  4. Jan 31 12:21:20 localhost pure-ftpd: (?@?) [ERROR] Unable to start a standalone server: [Address already in use]
  5. Jan 31 14:18:37 localhost pure-ftpd: (?@192.168.1.138) [INFO] New connection from 192.168.1.138
  6. Jan 31 14:18:37 localhost pure-ftpd: (?@192.168.1.138) [ERROR] The SQL server seems to be down [Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)]
  7. Jan 31 14:18:41 localhost pure-ftpd: (?@192.168.1.138) [WARNING] Authentication failed for user [ftp]
  8. Jan 31 14:18:41 localhost pure-ftpd: (?@192.168.1.138) [INFO] Logout.
  9. Jan 31 22:27:14 localhost pure-ftpd: (?@192.168.1.138) [INFO] New connection from 192.168.1.138
  10. Jan 31 22:27:14 localhost pure-ftpd: (?@192.168.1.138) [ERROR] The SQL server seems to be down [Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)]
  11. Jan 31 22:27:18 localhost pure-ftpd: (?@192.168.1.138) [WARNING] Authentication failed for user [ftp]
  12. Jan 31 22:27:18 localhost pure-ftpd: (?@192.168.1.138) [INFO] Logout.
  13. Feb  1 05:20:41 localhost pure-ftpd: (?@192.168.1.138) [INFO] New connection from 192.168.1.138
  14. Feb  1 05:20:41 localhost pure-ftpd: (?@192.168.1.138) [ERROR] The SQL server seems to be down [Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)]
  15. Feb  1 05:20:47 localhost pure-ftpd: (?@192.168.1.138) [WARNING] Authentication failed for user [ftp]
  16. Feb  1 05:20:47 localhost pure-ftpd: (?@192.168.1.138) [INFO] Logout.
  17. Feb  1 05:26:20 localhost pure-ftpd: (?@192.168.1.138) [INFO] New connection from 192.168.1.138
  18. Feb  1 05:26:20 localhost pure-ftpd: (?@192.168.1.138) [ERROR] The SQL server seems to be down [Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)]
  19. Feb  1 05:26:25 localhost pure-ftpd: (?@192.168.1.138) [WARNING] Authentication failed for user [ftp]
  20. Feb  1 05:26:25 localhost pure-ftpd: (?@192.168.1.138) [INFO] Logout.
  21. Feb  1 08:35:14 localhost pure-ftpd: (?@192.168.1.138) [INFO] New connection from 192.168.1.138
  22. Feb  1 08:35:14 localhost pure-ftpd: (?@192.168.1.138) [ERROR] The SQL server seems to be down [Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)]
  23. Feb  1 08:35:19 localhost pure-ftpd: (?@192.168.1.138) [WARNING] Authentication failed for user [ftp]
  24. Feb  1 08:35:19 localhost pure-ftpd: (?@192.168.1.138) [INFO] Logout.
  25. Feb  1 08:35:38 localhost pure-ftpd: (?@192.168.1.138) [INFO] New connection from 192.168.1.138
  26. Feb  1 08:35:38 localhost pure-ftpd: (?@192.168.1.138) [ERROR] The SQL server seems to be down [Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)]
  27. Feb  1 08:35:42 localhost pure-ftpd: (?@192.168.1.138) [WARNING] Authentication failed for user [ftp]
  28. Feb  1 08:35:42 localhost pure-ftpd: (?@192.168.1.138) [INFO] Logout.
  29. Feb  1 08:36:23 localhost pure-ftpd: (?@192.168.1.138) [INFO] New connection from 192.168.1.138
  30. Feb  1 08:36:23 localhost pure-ftpd: (?@192.168.1.138) [ERROR] The SQL server seems to be down [Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)]
  31. Feb  1 08:36:27 localhost pure-ftpd: (?@192.168.1.138) [WARNING] Authentication failed for user [ftp]
  32. Feb  1 08:36:27 localhost pure-ftpd: (?@192.168.1.138) [INFO] Logout.
  33. Feb  1 09:09:47 localhost pure-ftpd: (?@192.168.1.138) [INFO] New connection from 192.168.1.138
  34. Feb  1 09:09:47 localhost pure-ftpd: (?@192.168.1.138) [ERROR] The SQL server seems to be down [Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)]
  35. Feb  1 09:09:52 localhost pure-ftpd: (?@192.168.1.138) [WARNING] Authentication failed for user [ftp]
  36. Feb  1 09:09:52 localhost pure-ftpd: (?@192.168.1.138) [INFO] Logout.
  37. Feb  1 09:16:41 localhost pure-ftpd: (?@192.168.1.138) [INFO] New connection from 192.168.1.138
  38. Feb  1 09:16:41 localhost pure-ftpd: (?@192.168.1.138) [ERROR] The SQL server seems to be down [Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)]
  39. Feb  1 09:16:44 localhost pure-ftpd: (?@192.168.1.138) [WARNING] Authentication failed for user [ftp]
  40. Feb  1 09:16:44 localhost pure-ftpd: (?@192.168.1.138) [INFO] Logout.
复制代码
作者: 啥都不会    时间: 2016-2-3 14:56
/etc/my.conf 文件 部分摘录：

  1. # Example MySQL config file for medium systems.
  2. #
  3. # This is for a system with little memory (32M - 64M) where MySQL plays
  4. # an important part, or systems up to 128M where MySQL is used together with
  5. # other programs (such as a web server)
  6. #
  7. # MySQL programs look for option files in a set of
  8. # locations which depend on the deployment platform.
  9. # You can copy this option file to one of those
  10. # locations. For information about these locations, see:
  11. # http://dev.mysql.com/doc/mysql/en/option-files.html
  12. #
  13. # In this file, you can use all long options that a program supports.
  14. # If you want to know which options a program supports, run the program
  15. # with the "--help" option.

  17. # The following options will be passed to all MySQL clients
  18. [client]
  19. #password   = your_password
  20. port        = 3306
  21. socket      = /tmp/mysql.sock

  23. # Here follows entries for some specific programs

  25. # The MySQL server
  26. [mysqld]
  27. port        = 3306
  28. socket      = /tmp/mysql.sock
  29. datadir = /usr/local/mysql/var
  30. skip-external-locking
  31. max_connections = 1000
  32. key_buffer_size = 16M
  33. max_allowed_packet = 1M
  34. table_open_cache = 64
  35. sort_buffer_size = 512K
  36. net_buffer_length = 8K
  37. read_buffer_size = 256K
  38. read_rnd_buffer_size = 512K
  39. myisam_sort_buffer_size = 8M

  41. # Don't listen on a TCP/IP port at all. This can be a security enhancement,
  42. # if all processes that need to connect to mysqld run on the same host.
  43. # All interaction with mysqld must be made via Unix sockets or named pipes.
  44. # Note that using this option without enabling named pipes on Windows
  45. # (via the "enable-named-pipe" option) will render mysqld useless!
复制代码
作者: 啥都不会    时间: 2016-2-3 15:02
重启FTP 的提示：
  1. [root@localhost lib]# lnmp restart
  2. +-------------------------------------------+
  3. |    Manager for LNMP, Written by Licess    |
  4. +-------------------------------------------+
  5. |              http://lnmp.org              |
  6. +-------------------------------------------+
  7. Stoping LNMPA...
  8. Stoping nginx...  done
  9. Shutting down MySQL.. SUCCESS!
  10. stop apache...  done
  11. Starting LNMPA...
  12. Starting nginx...  done
  13. Starting MySQL. SUCCESS!
  14. start apache...  done
  15. [root@localhost lib]# lnmp pureftpd restart
  16. +-------------------------------------------+
  17. |    Manager for LNMP, Written by Licess    |
  18. +-------------------------------------------+
  19. |              http://lnmp.org              |
  20. +-------------------------------------------+
  21. Restarting Pure-FTPd...
  22. Stopping Pure-FTPd...   done
  23. Starting Pure-FTPd... Running: /usr/local/pureftpd/sbin/pure-ftpd --daemonize -A -c50 -B -C5 -D -E -fftp -H -I15 -lmysql:/usr/local/pureftpd/pureftpd-mysql.conf -lunix -L2000:8 -m4 -p20000:30000 -s -U133:022 -u100 -k99 -Z
  24. done
复制代码
作者: licess    时间: 2016-2-3 17:04
可能是你系统上后来通过yum或apt-get 安装了mysql-client之类的模块，导致多了一个my.cnf的配置文件
你可以看一下是否存在/etc/mysql/my.cnf

一般删除mysql-client之类的包后重启pureftpd就可以了
可以rpm -qa|grep mysql 或 dpkg -l|grep mysql 进行查看
作者: 啥都不会    时间: 2016-2-3 17:14
军哥

rpm -qa|grep mysql

没有任何提示信息。
( dpkg -l|grep mysql  ，是无效命令，我的是 centos 7)
然后  /etc 下 没有 mysql目录。。。。

，另外这个LNMP 除了我安装了imap和 sendmail没安装其他东西。
好奇怪了。。。
作者: licess    时间: 2016-2-3 19:42
你直接强制这样吧
mkdir -p /var/lib/mysql
ln -sf /tmp/mysql.sock /var/lib/mysql/mysql.sock
作者: 啥都不会    时间: 2016-2-4 11:45
原帖由 licess 于 2016-2-3 19:42 发表
你直接强制这样吧
mkdir -p /var/lib/mysql
ln -sf /tmp/mysql.sock /var/lib/mysql/mysql.sock


果然。成功了。
多谢军哥！！



欢迎光临 VPS侦探论坛 (https://bbs.lnmp.com/) Powered by Discuz! X3.4