[galaxy-dev] Problem about configuring Proftpd with Mysql and galaxy

4 May 2012

      Hi everyone,

I have a problem about configuring Proftpd and Mysql with galaxy, i have followed the steps from the galaxy wiki about ftp. I have created a database 'galaxy' and a user mmonsoor which has all the rights on the database. I think that the reason is about the proftpd.conf, below is a copy of my proftpd.conf:

# 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            "Galaxy Server"
ServerType            standalone
DefaultServer            on

# Port 21 is the standard FTP port.
Port                21

# 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                077

SyslogFacility                  DAEMON
SyslogLevel                     debug

# 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                nobody
Group                nogroup

PassivePorts                    30000 40000

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

# Automatically create home directory if it doesn't exist
CreateHome                      on dirmode 700

# Allow users to overwrite their files
AllowOverwrite                  on

# Allow users to resume interrupted uploads
AllowStoreRestart               on

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

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

# Bar use of RETR (download) since this is not a public file drop
<Limit RETR>
  DenyAll
</Limit>

# A basic anonymous configuration, no upload directories.  If you do not
# want anonymous users, simply delete this entire <Anonymous> section.
<Anonymous ~ftp>
  User                ftp
  Group                ftp

  # We want clients to be able to login with "anonymous" as well as "ftp"
  UserAlias            anonymous ftp

  # Limit the maximum number of anonymous logins
  MaxClients            10

  # We want 'welcome.msg' displayed at login, and '.message' displayed
  # in each newly chdired directory.
  DisplayLogin            welcome.msg
  DisplayChdir            .message

  # Limit WRITE everywhere in the anonymous chroot
  <Limit WRITE>
    DenyAll
  </Limit>
</Anonymous>

# Do not authenticate against real (system) users
#AuthPAM                         off

# 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                        sql
SQLConnectInfo                  galaxy@localhost mmonsoor MyPassword
SQLAuthTypes                    SHA1
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
SQLNamedQuery                   LookupGalaxyUser SELECT "email,password,'512','512','/home/mmonsoor/galaxy-dist/database/files/%U','/bin/bash' FROM galaxy_user WHERE email='%U'"

I don't know what is wrong about my proftpd.conf? 

Thanks in advance to all.

Mish

[galaxy-dev] Problem about configuring Proftpd with Mysql and galaxy

Misharl mon