Hi, sorry, I can see that master -> slave replication is working properly - thankyou
If there are no users in the ftp_user table; pureftpd only runs one query, gets 0 rows then shows invalid username message. If there are entries in the table and they match the credentials given to the client, it will run more than one query.
When i login to mysql as the same user that pureftpd has to run, and run the same queries it runs, i get a row returned. I get the username, the password, the uid, the directory so it can get the info, it just fails after that which is why I think it's a user-mapping issue. Should it create a new local unix user? Because it doesn't
I might setup a standalone box on ubuntu today and see what the differences are
Someone with working proftpd; can you see one of your ftp accounts and see what the uid field contains then run