pure-ftp-mysql login incorrect

all app is correctly run and installed but it seems that pure-ftp is not query mysql for password

root@web2:~# dpkg -l | grep pure
ii pure-ftpd-common 1.0.36-3.2build1 all Pure-FTPd FTP server (Common Files)
ii pure-ftpd-mysql 1.0.36-3.2build1 amd64 Secure and efficient FTP server with MySQL user authentication
Jun 4 15:08:48 web2 pure-ftpd: ([email protected]) [INFO] New connection from 202.134.31.158
Jun 4 15:08:48 web2 pure-ftpd: ([email protected]) [DEBUG] Command [user] [raeworx]
Jun 4 15:08:48 web2 pure-ftpd: ([email protected]) [DEBUG] Command [pass] [<*>]
Jun 4 15:08:48 web2 pure-ftpd: ([email protected]) [INFO] PAM_RHOST enabled. Getting the peer address
Jun 4 15:09:01 web2 pure-ftpd: ([email protected]) [WARNING] Authentication failed for user [raeworx]
Jun 4 15:09:01 web2 pure-ftpd: ([email protected]) [INFO] Logout.

If you note there is delay of more than 30 sec before authentication failed ....

if i could see any more logs that would be usefull ...

Appreciate any help on this

 

are you absolutely sure that your entering the correct password?
it's also possible that the password contains some character that the system doesn't like.

I would suggest setting the password to a very simple single case word, something you can't possibly get wrong and which doesn't include any symbols, and see what happens with using that.

obviously don't leave the password like that long term, but it's a quick easy test to see if there is actually a login process/configuration problem, or just something wrong in the username/password combination.
it probably is the former, as the wrong username/password should fail without such a delay.

 

hi till ...been quitre a while i have not come back with question ...

I create a totally new user (rae) with password 12345 just to make sure i don't use a shell user and also simple pasword as seen on the replication log from master

05.06.2020-08:53 - DEBUG - Replicated from master: REPLACE INTO `ftp_user` (`ftp_user_id`,`sys_userid`,`sys_groupid`,`sys_perm_user`,`sys_perm_group`,`sys_perm_other`,`server_id`,`parent_domain_id`,`username`,`username_prefix`,`password`,`quota_size`,`active`,`uid`,`gid`,`dir`,`quota_files`,`ul_ratio`,`dl_ratio`,`ul_bandwidth`,`dl_bandwidth`,`expires`,`user_type`,`user_config`) VALUES ('120','1','21','riud','riud','',46,'141','rae','','$1$H/lxMg9j$/ux9S6MXBUFWjx2RhXCRf0','-1','y','web141','client20','/var/www/clients/client20/web141','-1','-1','-1','-1','-1',NULL,'user',NULL)

however i don't see any prefix as you mentioned above

Not only that the same pure-ftpd log shows the same error login failed.
5 08:54:38 web2 pure-ftpd: ([email protected]) [INFO] New connection from 202.134.31.158
Jun 5 08:54:38 web2 pure-ftpd: ([email protected]) [DEBUG] Command [auth] [TLS]
Jun 5 08:54:38 web2 pure-ftpd: ([email protected]) [INFO] SSL/TLS: Enabled TLSv1/SSLv3 with AES256-GCM-SHA384, 256 secret bits cipher
Jun 5 08:54:41 web2 pure-ftpd: ([email protected]) [DEBUG] Command [user] [rae]
Jun 5 08:54:41 web2 pure-ftpd: ([email protected]) [DEBUG] Command [pass] [<*>]
Jun 5 08:54:41 web2 pure-ftpd: ([email protected]) [INFO] PAM_RHOST enabled. Getting the peer address
Jun 5 08:54:53 web2 pure-ftpd: ([email protected]) [WARNING] Authentication failed for user [rae]
Jun 5 08:54:53 web2 pure-ftpd: ([email protected]) [INFO] Logout.

What i don't see happen is the mysql query eventough i enabe mysql log ....

Below this is a log when i try to access mysql promt
2020-06-04T19:59:54.873874Z 7830 Connect root@localhost on using Socket
2020-06-04T19:59:54.892192Z 7830 Query select @@version_comment limit 1

and i expect to see some query when i log in through FTP but i don't . Maybe pure-ftpd-mysql is installed but not correctly works .... or anything else.... ??

 

hi pleae refer to my reply below to till ....

 

ok so reconfigure service but not permission ???

 

now i test with local unix user and i can login fine but not with the ispconfig ftp user !!!

Jun 11 10:37:34 web2.kalianet.to pure-ftpd[15581]: pam_unix(pure-ftpd:auth): check pass; user unknown
Jun 11 10:37:34 web2.kalianet.to pure-ftpd[15581]: pam_unix(pure-ftpd:auth): authentication failure; logname= uid=0 euid=0 tty=pure-ftpd ruser=raeworx rhost=
Jun 11 10:37:40 web2.kalianet.to pure-ftpd[15581]: ([email protected]) [WARNING] Authentication failed for user [raeworx]

this is the log

 

have you tried deleting and recreating that ftp account? or testing with a new ftp account?