Pureftpd exit 252

Discussion in 'Server Operation' started by Tortanick, Jun 2, 2006.

  1. Tortanick

    Tortanick New Member

    Whenever I start pureftpd useing MySQL it imediately responds with exit 252 <my startup command>

    How can I fix this or at least work out whats causeing this?

    P.S. I compiled pureftpd from source and start it with
    Code:
    sudo /usr/local/sbin/pure-ftpd -switches -l mysql:/ect/pureftpd/mysql.conf &
     
  2. falko

    falko Super Moderator

    Is MySQL running? What's in /ect/pureftpd/mysql.conf?
    Any errors in your log files?
     
  3. Tortanick

    Tortanick New Member

    I got mysql-server, mysql-client and libMySQLclient12-dev client form the ubuntu repositories (probobly some dependencies too). and I can log in to MySQL and make databases, but I don't know the command to check if a program is running.

    I couldn't see any room for improvement on the mysql.conf in your guide so I stuck with that.

    I can give you the mysql.bin.##### logs if you want but I don't seem to have any pure-ftpd logs
     
    Last edited: Jun 3, 2006
  4. falko

    falko Super Moderator

    Do you see it when you run
    Code:
    netstat -tap
    ?

    Do you use Debian on your system?
     
  5. Tortanick

    Tortanick New Member

    yeah its their, tcp 0 0 localhost:mysql *:* LISTEN -


    And I use Ubuntu server edition.
     
  6. falko

    falko Super Moderator

    And your /etc/pure-ftpd/db/mysql.conf looks like this?

    Code:
    MYSQLSocket      /var/run/mysqld/mysqld.sock
    #MYSQLServer     localhost
    #MYSQLPort       3306
    MYSQLUser       pureftpd
    MYSQLPassword   ftpdpass
    MYSQLDatabase   pureftpd
    #MYSQLCrypt md5, cleartext, crypt() or password() - md5 is VERY RECOMMENDABLE uppon cleartext
    MYSQLCrypt      md5
    MYSQLGetPW      SELECT Password FROM ftpd WHERE User="\L" AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
    MYSQLGetUID     SELECT Uid FROM ftpd WHERE User="\L" AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
    MYSQLGetGID     SELECT Gid FROM ftpd WHERE User="\L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
    MYSQLGetDir     SELECT Dir FROM ftpd WHERE User="\L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
    MySQLGetBandwidthUL SELECT ULBandwidth FROM ftpd WHERE User="\L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
    MySQLGetBandwidthDL SELECT DLBandwidth FROM ftpd WHERE User="\L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
    MySQLGetQTASZ   SELECT QuotaSize FROM ftpd WHERE User="\L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
    MySQLGetQTAFS   SELECT QuotaFiles FROM ftpd WHERE User="\L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
    Does /var/run/mysqld/mysqld.sock exist?
     
  7. Tortanick

    Tortanick New Member

    yes to both, and I tried modifying the file to use TCP rather than the socket
     
    Last edited: Jun 3, 2006
  8. Tortanick

    Tortanick New Member

    Ok this is embaressing but I figured out the problem: typo.

    Sorry to waste your time and thanks for all the help
     

Share This Page