Hi,
2months ago, I've installed pure-ftpd with users in mysqlDB. All was working fine. Unfortunately when I tried to login today, I was unable to do that.
System: Debian 7 wheezy up2date
Pure-FTPD: 1.0.36-1.1
MySQL: 5.5.40-0
OpenSSL: 1.0.1e-2
1. When I tried to login using filezilla, I get information after entering credentials:
Code:
Response: 331 User MY_USER OK. Password required
Command: PASS **********
Response: 530 Login authentication failed
Error: Critical error: Could not connect to server
PureFTP logs said (with debug mode on):
Code:
Dec 10 00:35:45 bdc pure-ftpd: (?@ppp-46-210-101-69.dynamic.mnet-online.de) [INFO] New connection from ppp-46-210-101-69.dynamic.mnet-online.de
Dec 10 00:35:45 bdc pure-ftpd: (?@ppp-46-210-101-69.dynamic.mnet-online.de) [DEBUG] Command [auth] [TLS]
Dec 10 00:35:46 bdc pure-ftpd: (?@ppp-46-210-101-69.dynamic.mnet-online.de) [INFO] SSL/TLS: Enabled TLSv1/SSLv3 with AES256-GCM-SHA384, 256 secret bits cipher
Dec 10 00:35:46 bdc pure-ftpd: (?@ppp-46-210-101-69.dynamic.mnet-online.de) [DEBUG] Command [user] [MY_USER]
Dec 10 00:35:46 bdc pure-ftpd: (?@ppp-46-210-101-69.dynamic.mnet-online.de) [DEBUG] Command [pass] [<*>]
Dec 10 00:35:49 bdc pure-ftpd: (?@ppp-46-210-101-69.dynamic.mnet-online.de) [WARNING] Authentication failed for user [MY_USER]
Dec 10 00:35:49 bdc pure-ftpd: (?@ppp-46-210-101-69.dynamic.mnet-online.de) [INFO] Logout.
2. I am using correct configuration in filezilla (explict FTP over TLS)
3. Username,password,Host stored in /etc/pure-ftpd/db/mysql.conf are ok, as I am able to open DB. I am also able to run this query which I have set in this file under: MYSQLGetPW.
4. This is not FW issue as it's disabled
5. All users are stored in mySQL DB and they have their folders in local filesystem.
6. I do not touch this configuration from 2months.
Any idea what can be the reason? And how to investigate more? Debug mode is not very helpfull as you see..
UPDATE:
After removing users from DB and adding them again, is starts working.
Unable to connect to pure-ftpd (mysql)
