Re: [galaxy-dev] ProFTPD integration with Galaxy

Federico Zambelli Mon, 22 Jul 2013 01:32:57 -0700

I noticed the errors in the SUBSTRING length too and I modified myconfiguration file accordingly but still not able to authenticate :(

F.


Il 22/07/13 05.40, TerryYeh@NARL ha scritto:

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.



___________________________________________________________
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
   http://lists.bx.psu.edu/

To search Galaxy mailing lists use the unified search at:
   http://galaxyproject.org/search/mailinglists/







--
============================================
Federico Zambelli, Ph.D.
Bioinformatics, Evolution and Comparative Genomics Lab
Dept. of Biosciences
University of Milano - Italy

What can be asserted without proof can be dismissed without proof.
============================================
___________________________________________________________
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
 http://lists.bx.psu.edu/

To search Galaxy mailing lists use the unified search at:
 http://galaxyproject.org/search/mailinglists/

Re: [galaxy-dev] ProFTPD integration with Galaxy

Reply via email to