Need help with PureFTPd-mysql [Ubuntu]

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? :<

 

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

Which Ubuntu version are you using?

 

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

 

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?

 

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

 

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.

 

What's the output of

Code:

netstat -tap

?

 

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

 

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