pure-ftp-mysql login incorrect

Discussion in 'Server Operation' started by Maile Halatuituia, Jun 4, 2020.

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

    [email protected]:~# 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
     
  2. nhybgtvfr

    nhybgtvfr Active Member

    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.
     
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    Or you might have a shell user with the same name. Also FTP user names in ISPConfig normally have a prefix, unless you disabled that prefix. Take care to use the full username incl. prefix.
     
  4. 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 [email protected] 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.... ??
     
  5. hi pleae refer to my reply below to till ....
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    You disabled the prefix. That is fine, I just mentioned it as it happened quite often in the past that such problems were caused by using a wrong username by leaving out the prefix.

    Did you install the ftp server after you installed ispconfig? In that case, an ispconfig update is needed with reconfigure services = yes during update.
     
  7. ok so reconfigure service but not permission ???
     
  8. 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
     
    Last edited: Jun 10, 2020
  9. nhybgtvfr

    nhybgtvfr Active Member

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

Share This Page