Mysql – ProFTPd mod_sftp mod_sftp_sql

ftpMySQLpasswordproftpdsftp

I am working on Ubuntu 12.04
I have setup a ProFTPd service with SSL/TLS, virtual users stored in a MySQL database and quota (mod_tls, mod_sql, mod_sql_mysql, mod_quotatab, mod_quotatab_sql).
It works fine.

I want now to setup the same thing over SFTP instead of SSL/TLS.
I have built ProFTPd from sources with mod_sftp and mod_sftp_sql.

Is it possible to authenticate users with passwords over SFTP/SQL ?

I seen the directive SFTPAuthMethods that accepts password.
How to bind this with mod_sftp_sql and an SQL query ?
All found documentation is about public key authentication method.

Best Answer

SFTPAuthorizedUserKeys, SFTPAuthorizedHostKeys and SQLNamedQuery are the parameters you are looking for, I guess.

There is good explanation at the mod_sftp_sql modules documentation page:

http://www.proftpd.org/docs/contrib/mod_sftp_sql.html

Related Solutions

Mysql – how to solve proftpd very slow connection

here's the answer for my problem:

apparently the SQLAuthenticate directive was the problem. it was set to:

SQLAuthenticate users userset

i've changed this to

SQLAuthenticate users

now authentication is fast as hell.

i've found a howto on the proftpd site, that explains why this configuration may cause problems:

http://www.proftpd.org/docs/howto/SQL.html

Ftp – ProFTPD Inconsistent Errors

There is a bug in ProFTPd v1.3.3 with multi-line output.

This line of output shouldn't be there, or at least shouldn't look like it does:

Reply: 230 Ls oi a:2011-11-06 00:44:45

It is being interpreted as the output for 'SYST', so when the 'FEAT' command it issued, the 'SYST' output is being read, and when 'PWD' is issued, some of the feature response is being read.

The second connection doesn't ask for SYST and FEAT, so the timings seem to be more forgiving.

The internet knows of one other person who has had this problem (with that combination of letters missing!) and their workaround is:

Try commenting out the SQLShowInfo lines from your sql.conf file.

This Debian bug says the problem is fixed in 1.3.4 pre-release upstream, and suggests you may have to use a backport to get the correct behaviour as it is unlikely to be considered critical functionality or security, thus warranting a stable patch.

Best Answer

Related Solutions

Mysql – how to solve proftpd very slow connection

Ftp – ProFTPD Inconsistent Errors

Related Topic