RHEL5.1\CENT.OS 5.1 VSFTPD auth via mysql

Discussion in 'Server Operation' started by Nikitos, Apr 15, 2008.

  1. Nikitos

    Nikitos New Member

    Hello :)

    I want to setup vsftpd server like Virtual Hosting With vsftpd And MySQL On Debian Etch but on RHEL5.1(Cent.os)
    I`ve install pam_mysql from EPEL, create database, use debian`s config for vsftpd.conf.... add to pam/vsftpd like in debian one ... but then I tried to login I have a message that login is incorrect

    Can you help me?
  2. falko

    falko Super Moderator ISPConfig Developer

    What's in /etc/vsftpd.conf and the vsftpd pam file?
    What's the exact error message? Any errors in your logs?
  3. Nikitos

    Nikitos New Member


    Last edited: Apr 17, 2008
  4. topdog

    topdog Active Member

    Turn on debug and see what is being logged in syslog
  5. Nikitos

    Nikitos New Member

    i add log all querys to my.cnf and i saw in log that
    Last edited: Apr 17, 2008
  6. topdog

    topdog Active Member

    the query is not returning any data connect to the db as that user and run the same query.
  7. Nikitos

    Nikitos New Member

    Query as vsftpd user works normal :(

    When i do your this query Log in /var/logs/secure don`t have any errors
    Last edited: Apr 17, 2008
  8. topdog

    topdog Active Member

    Turn on pam_mysql's own debug such that you see what happens to the whole process.

    logging queries from mysql will not give you the full picture.
  9. Nikitos

    Nikitos New Member

    Enable Pam_mysql log:

    Pam_mysql log
    Mysql query log:
    /var/log/secure doesn`t have any errors

Share This Page