Proftpd + MySQL virtual users, can't connect

[geekman]

Is it possible to have MD5 encryptions on passwords at all? At least anything other than plaintext, my mailserver already uses ENCRYPT in mysql whatever encryption that is, but i'd like to use MD5 on FTP (if you could advise on postifx/courier too that'd rock)

Thanks.

[falko]

Are you referring to Proftpd or Pureftpd? The Pureftpd guide uses MD5 passwords, but I'm not aware of a way to do this with Proftpd...

[geekman]

I was referring to proftpd...blah . Can you recommend a decent form of encryption that could be used across most daemons (ftp, mail, etc..) I guess I could have the password stored in the database using multiple records each one with a different encryption...but I don't exactly want to do that.

Thanks.

[falko]

Originally Posted by geekman

Can you recommend a decent form of encryption that could be used across most daemons (ftp, mail, etc..)

Unfortunately no...

[MrMagix]

Hi all,

this discussion saved me a lot of time (even it tooks half a day to find it ) Thanks al lot.

Not yet tested (to tired) there is a way to use hashes - like MD5 - to "encrypt" the password. I found this link - look for "openssl". In short, you can put "openssl" into SQLAuthTypes as we can see here...http://www.castaglia.org/proftpd/mod...l#SQLAuthTypes and here.
http://www.proftpd.org/docs/howto/SQL.html

[MrMagix]

I just found the time to set up the hashed password storage and it worked.

I didn't had openssl installed, a apt-get install openssl worked for me.

[dragon]

Hi all,

this comes a bit late , but I hope someone can use this information.

1. ProFTPD fully supports MySQL authentication with MD5 hashes - the same used by Linux and UNIX systems in the /etc/shadow file. To use it, enter the following directive in your proftpd.conf file along with all other SQL directives:

SQLAuthTypes Crypt Plaintext

(You can probably skip the Plaintext if everything with hashes is working fine and you don't need fallback. I will update you on that later ).

2. When you get a message saying "FTP session requested from unknown class" on Debian Etch 4.0 (ProFTPD Version 1.3.0) and you are trying to use MySQL authentication, this is probably due to the

LoadModule mod_sql_postgres.c

in /etc/proftpd/modules.conf file, which line should be commented out.
I see this as a bug in the proftpd package, since I have NOT installed the proftpd-pgsql package, so this line should not be present, and also, at least it shouldn't affect the work of the proftpd-mysql package, which is successfully installed.

I would like to thank Falko for this line, mentioned in his tutorial (see up).

[Franzus]

that uncomment of postgresql worked for me

Thanks a lot!

[dusktrader]

Originally Posted by dragon

2. When you get a message saying "FTP session requested from unknown class" on Debian Etch 4.0 (ProFTPD Version 1.3.0) and you are trying to use MySQL authentication, this is probably due to the

LoadModule mod_sql_postgres.c

in /etc/proftpd/modules.conf file, which line should be commented out.
I see this as a bug in the proftpd package, since I have NOT installed the proftpd-pgsql package, so this line should not be present, and also, at least it shouldn't affect the work of the proftpd-mysql package, which is successfully installed.

I would like to thank Falko for this line, mentioned in his tutorial (see up).

THANK YOU -- this also fixed my issue immediately. I was tearing my hair out after an upgrade to the latest dapper 6.0.6 release in repo, which is proftpd 1.3.0-9~dapper1

Just comment out the line listed above and restart proftpd. Started working correctly right away after that.