proftpd not starting

[jtz]

It seams like all was done correctly in the how to for proftpd with mysql.
The questions I have area as follows:
1. SQLConnectInfo ftpauth@localhost proftpd myPasswd
Is proftpd a local user with a password and is myPasswd that password?
I am not able to log into mysql with proftpd as a user.
Do I need to setup the local user to use a passowd server?

1. How can I tell if proftpd is running, I can not ftp via local or remote. I get service not availalbe. I have enven tried standalone setup.

[Anonymous]

1. Yes. The user is the MySQL user with sufficient privileges to select users from the database. The users who can FTP into your system resides in MySQL only. No password server is needed since your users only will exist in the MySQL.
2. Well. Try switching over to standalone mode in the .conf and then executing the binary. If you have some errors in the .conf it’ll spit them out for you and you can correct them.

Note that you’ll have to have a “valid” hostname, if you don’t set it to ‘localhost’.

[jtz]

I now have it to where it is indicationg login not correct. I have tried the following:
1. Loged into mysql with -u proftpd -p
use ftpauth
select * from usertable where userid=’API1′ and passwd=PASSWORD(‘myPasswd’);

I get the correct record.

How can I see what is returned to proftpd when it does its query??
How can I see why proftpd did not accept login??

[Anonymous]

I have been fighting with the same problem, and what I finally figured out is that proftpd is extremely picky about what it will accept re:mysql.

I have found that it will reject a login with correct username and password if the “homedir” provided in mysql is not accessible. I can only assume that it will not allow connection until it perfoms the chroot, and so if the path doesnt exist, or your ftpuser on the system does not have priveledges on that folder, then it refuses to authenticate.

So far I have found no way to make mysql auth work without the userdirectory being world writable, either. Not terribly dangerous after the chroot, and you block execute, but still not my favorite attribute. Anyone else have better luck?

[Cabbage]

[quote:1113d21ab7] reject a login with correct username and password if the “homedir” provided is not accessible[/quote:1113d21ab7]

The built in FTP Server – wu-ftp acts like this too.

[Author]

Posts