pureftpd mysql auth failing

Discussion in 'Installation/Configuration' started by HooGLaNDeR, Mar 30, 2009.

  1. HooGLaNDeR

    HooGLaNDeR Member

    Hello,

    I have 2 separate servers both running pureftpd and 1 of them i can't log in to.
    Both are, i believe, setup the same, and both are sharing a database on the same MySQL server.

    Does anyone have an idea where i could find out whats going wrong?
    I checked logs, but i only see the testuser isn't getting in.

    Thanks,

    HooGLaNDeR
     
  2. falko

    falko Super Moderator Howtoforge Staff

    Which distribution are you using?
    Have you tried both active and passive transfers in your FTP client?
     
  3. HooGLaNDeR

    HooGLaNDeR Member

    On both machines im using Debian. Debian 5.
    I can connect both passive as active on the one working machine and neither on the other.

    Both servers connect to a third machine where mysql is installed.
    The working machine doesn't show anything except succesfull logins. The other states

    "pure-ftpd: pam_unix_auth(pure-ftpd:auth): authentication failure; logname= uid=0 euid=0 tty=pure-ftpd ruser=t3st rhost=hosted.by.myself.com"
     
  4. deconectat

    deconectat New Member

    Are you sure your server connects to the mysql server?
     
  5. HooGLaNDeR

    HooGLaNDeR Member

    I think so, both config files (/etc/pure-ftpd/db/mysql.conf) point to the same MySQL server.

    But how could i see that for sure ?
     
  6. deconectat

    deconectat New Member

    Maybe you have some iptables rules on your mysql server. Just try telnet mysql.ip:port and see if it connects. If that works, use netstat -ap to see if your mail server connects to mysql.
     
  7. HooGLaNDeR

    HooGLaNDeR Member

    Hmm, i dont know exactly why. but i "fixed" it, by copying the /conf directory from my working server to the non working server, replacing all files.

    And, after restarting, its working...

    Weird huh :O
     
  8. HooGLaNDeR

    HooGLaNDeR Member

    file:
    containing text :

    AllowUserFXP
    yes

    AltLog
    clf:/var/log/pure-ftpd/transfer.log

    MinUID
    1000

    MySQLConfigFile
    /etc/pure-ftpd/db/mysql.conf

    NoAnonymous
    yes

    PAMAuthentication
    yes

    PureDB
    /etc/pure-ftpd/pureftpd.pdb

    UnixAuthentication
    no
     

Share This Page