Need help with PureFTPd-mysql [Ubuntu]

Discussion in 'Server Operation' started by Thildir, May 17, 2008.

  1. Thildir

    Thildir New Member

    I've followed the guide here on HowtoForge three times and two of the times i even nuked the computer to start fresh. BUT i can't get the bloody thing to work, when Im done with all the parts and try to log on using Filezilla i get the message;

    Status: Connecting to 213.65.210.163:21...
    Status: Connection established, waiting for welcome message...
    Response: 220---------- Welcome to Pure-FTPd [privsep] [TLS] ----------
    Response: 220-You are user number 2 of 50 allowed.
    Response: 220-Local time is now 17:26. Server port: 21.
    Response: 220-This is a private system - No anonymous login
    Response: 220-IPv6 connections are also welcome on this server.
    Response: 220 You will be disconnected after 15 minutes of inactivity.
    Command: USER test
    Response: 331 User test OK. Password required
    Command: PASS ****
    Response: 530 Login authentication failed
    Error: Could not connect to server
    ------------------------------------------------
    And the same message comes up even if the username isnt created in mysql -.-

    Anyone who had the same prb or know how to fix it? :<
     
  2. falko

    falko Super Moderator ISPConfig Developer

    Any errors in your logs?
    What's in /etc/pure-ftpd/db/mysql.conf?

    Which Ubuntu version are you using?
     
  3. Thildir

    Thildir New Member

    What logs?

    MYSQLSocket /var/run/mysqld/mysqld.sock
    #MYSQLServer localhost
    #MYSQLPort 3306
    MYSQLUser pureftpd
    MYSQLPassword hampusftp
    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")

    Ubuntu 7,10
     
  4. Thildir

    Thildir New Member

    Ok, now you might get a new clue what the problem is;

    Today i downloaded the normal pureftpd not mySQL, also I got the GUI for PureFTPD. There I saw some text about users on the computer might be able to login and i tried it. Guess what happened? It worked! I got into my server with FTP and using the "ftpuser" User. And for some reason virutal users are not able to be created. Any clue what this might be?
     
  5. falko

    falko Super Moderator ISPConfig Developer

    Are you sure that you followed the tutorial to the letter? Please compare your configuration again with the one from the tutorial.
     
  6. Thildir

    Thildir New Member

    Sure, Ill check again, but Im sure I followed it completely, copied the configuration settings right off the tutorial. And as I said I even re installed the entire operating system to try it of with a fresh new start.
     
  7. falko

    falko Super Moderator ISPConfig Developer

    What's the output of
    Code:
    netstat -tap
    ?
     
  8. Thildir

    Thildir New Member

    Sorry, Im a complete noob at this ;P Whats Netstat?
     
  9. falko

    falko Super Moderator ISPConfig Developer

    Just open a terminal, execute
    Code:
    netstat -tap
    and post the output here.

    If oyu want to learn more aout netstat, run
    Code:
    man netstat
     

Share This Page