Dear All,
I am having a similar problem too. I followed the config setting
provide by Mr. Perez and modified some possible error. I still cannot login
my ftp server. Following is my proftpd.conf. Please help me to figure out
the problem. Thanks a lot!!
# This is a basic ProFTPD configuration file (rename it to
# 'proftpd.conf' for actual use. It establishes a single server
# and a single anonymous login. It assumes that you have a user/group
# "nobody" and "ftp" for normal operation and anon.
ServerName "ProFTPD Default Installation"
ServerType standalone
DefaultServer on
# Port 21 is the standard FTP port
Port 2121
# Don't use IPv6 support by default.
UseIPv6 off
# Umask 022 is a good standard umask to prevent new dirs and files
# from being group and world writable.
Umask 022
# To prevent DoS attacks, set the maximum number of child processes
# to 30. If you need to allow more than 30 concurrent connections
# at once, simply increase this value. Note that this ONLY works
# in standalone mode, in inetd mode you should use an inetd server
# that allows you to limit maximum number of processes per service
# (such as xinetd).
MaxInstances 30
# Set the user and group under which the server will run.
User username
Group groupname
PassivePorts 40000 40999
# To cause every FTP user to be "jailed" (chrooted) into their home
# directory, uncomment this line.
#DefaultRoot ~
CreateHome on dirmode 700
# Normally, we want files to be overwriteable.
AllowOverwrite on
AllowStoreRestart on
# Bar use of SITE CHMOD by default
<Limit SITE_CHMOD>
DenyAll
</Limit>
<Limit RETR>
DenyAll
</Limit>
<IfModule mod_dso.c>
LoadModule mod_sql.c
LoadModule mod_sql_passwd.c
LoadModule mod_sql_postgres.c
</IfModule>
SQLLogFile /pkg/biology/galaxy/proftpd/log/proftpd-sql-local
##
ServerLog /pkg/biology/galaxy/proftpd/var/proftpd-server.log
SystemLog /pkg/biology/galaxy/proftpd/var/proftpd-system.log
#AuthPAMConfig ftp
#AuthOrder mod_auth_pam.c* mod_auth_unix.c
# Do not authenticate against real (system) users
AuthPAM off
#AuthOrder mod_sql.c
# Set up mod_sql_password - Galaxy passwords are stored as hex-encoded SHA1
SQLPasswordEngine on
SQLPasswordEncoding hex
# Set up mod_sql to authenticate against the Galaxy database
SQLEngine on
SQLBackend postgres
SQLConnectInfo galaxy@localhost username password
SQLAuthTypes SHA1 SHA256 pbkdf2
SQLPasswordPBKDF2 SHA256 10000 24
SQLAuthenticate users
# An empty directory in case chroot fails
#SQLDefaultHomedir /var/opt/local/proftpd
# Define a custom query for lookup that returns a passwd-like entry. UID
and GID should match your Galaxy user.
SQLUserInfo custom:/LookupGalaxyUser
SQLPasswordUserSalt sql:/GetUserSalt
#SQLNamedQuery LookupGalaxyUser SELECT
"email,password,'12345','1234','/home/username/galaxyftp/%U','/bin/bash'
FROM galaxy_user WHERE email='%U'"
SQLNamedQuery LookupGalaxyUser SELECT "email, (CASE WHEN
substring(password from 1 for 6) = 'PBKDF2' THEN substring(password from 38
for 32) ELSE password END) AS
password,'12345','1234','/home/username/galaxyftp/%U','/bin/bash' FROM
galaxy_user WHERE email='%U'"
SQLNamedQuery GetUserSalt SELECT "(CASE WHEN SUBSTRING (password from 1
for 6) = 'PBKDF2' THEN SUBSTRING (password from 21 for 16) END) AS salt FROM
galaxy_user WHERE email='%U'"
I still get the message of authentication failed.
2013-07-22 11:07:29,590 mod_sql/4.3[8124]: checking password using
SQLAuthType 'sha1'
2013-07-22 11:07:29,590 mod_sql/4.3[8124]: 'sha1' SQLAuthType handler
reports failure
2013-07-22 11:07:29,590 mod_sql/4.3[8124]: checking password using
SQLAuthType 'sha256'
2013-07-22 11:07:29,590 mod_sql/4.3[8124]: 'sha256' SQLAuthType handler
reports failure
2013-07-22 11:07:29,590 mod_sql/4.3[8124]: checking password using
SQLAuthType 'pbkdf2'
2013-07-22 11:07:29,619 mod_sql/4.3[8124]: 'pbkdf2' SQLAuthType handler
reports failure
Any suggestion on my configuration file, Thanks.