ServerName "FTP server"
ServerType standalone
DefaultServer on
DeferWelcome                    off
UseIPv6                         on
#IdentLookups                    off
MultilineRFC2228                on
ShowSymlinks                    on

#ModulePath /usr/local/galaxy/downloads/proftpd-1.3.5rc3/modules/

#LoadModule mod_sql.c
#LoadModule mod_sql_postgres.c
#LoadModule mod_sql_passwd.c

#<IfModule mod_sql.c>
SQLBackend postgres
SQLEngine on
SQLAuthenticate users
SQLAuthTypes SHA1 SHA256 pbkdf2
SQLPasswordPBKDF2 SHA256 1000 24
#SQLPasswordSaltFile /path/to/file
SQLConnectInfo galaxydb@localhost:5432 galaxy tigress
SQLUserInfo custom:/LookupGalaxyUser
#SQLNamedQuery   LookupGalaxyUser SELECT "email,password,'galaxy','galaxy','/home/jibesh/uploads/%U','/bin/bash' FROM galaxy_user WHERE email='%U'"

SQLPasswordUserSalt sql:/GetUserSalt


SQLNamedQuery LookupGalaxyUser  SELECT "email, (CASE WHEN substring(password from 1 for 6) = 'PBDKF2' THEN substring(password from 38 for 69) ELSE password END) AS password2,'jibesh','jibesh','/home/jibesh/uploads/%U','/bin/bash' FROM galaxy_user WHERE email='%U'"

SQLNamedQuery GetUserSalt SELECT "(CASE WHEN SUBSTRING (password from 1 for 6) = 'PBDKF2' THEN SUBSTRING (password from 21 for 36) END) AS salt FROM galaxy_user WHERE email='%U'"

SQLLog PASS LookupGalaxyUser
SQLLogFile /foo/var/proftpd-sql

#</IfModule>

SQLDefaultGID                   1000
SQLDefaultUID                   1000

TimeoutNoTransfer               600
TimeoutStalled                  600
TimeoutIdle                     1200

DisplayLogin                    welcome.msg
DisplayChdir                    .message true
ListOptions                     "-l"

DenyFilter                      \*.*/

# Use this to jail all users in their homes
DefaultRoot                     ~
CreateHome                      on dirmode 700
AllowOverwrite                  on
AllowStoreRestart               on
SQLPasswordEngine               on
SQLPasswordEncoding             hex
PassivePorts                  30000 40000



# Port 21 is the standard FTP port.
Port 21

# Don't use IPv6 support by default.
# Umask 022 is a good standard umask to prevent new dirs and files
# from being group and world writable.
Umask 077

# 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 jibesh
Group jibesh

# To cause every FTP user to be "jailed" (chrooted) into their home
# directory, uncomment this line.
#DefaultRoot ~

# Normally, we want files to be overwriteable.
AllowOverwrite on

AuthOrder                       mod_sql.c


# Bar use of SITE CHMOD by default
#<Limit SITE_CHMOD>
#  DenyAll
#</Limit>