This is probably more appropriate for the proftpd list at this point, but my thought is that maybe someone has come across this while configuring a proftpd server for galaxy usage. I'm including my current output when I try to log on, a copy of my conf file, and output from the SQL log (in all three cases, with identifying info removed - users, hosts, IPs, etc).

You can see from the SQL Log that it appears the log in is actually successful, but then the connection simply closes the connection. Any ideas as to what I've got configured incorrectly here?


####### Output

[user@host ftp]$ ftp ftphost
Connected to ftphost.
220 ProFTPD 1.3.3d Server (Galaxy FTP) [::ffff:IP]
500 AUTH not understood
500 AUTH not understood
KERBEROS_V4 rejected as an authentication type
Name (ftphost:user): galaxyUserEmail
331 Password required for galaxyUserEmail
Password:
530 Login incorrect.
Login failed.
421 Service not available, remote server has closed connection
ftp>


################ proftpd.conf
ServerName                      "Galaxy FTP"
ServerType                      standalone
DefaultServer                   on
Port                            21
Umask                           077
DefaultRoot                     ~
CreateHome                      on dirmode 700
AllowOverwrite                  on
AllowStoreRestart               on
SyslogFacility                  DAEMON
SyslogLevel                     debug
MaxInstances                    30
User                            nobody
Group                           nogroup

## SQL stuff
<Global>
  ## mod_sql_passwd stuff
  SQLPasswordEngine     on
  SQLPasswordEncoding   hex

  SQLConnectInfo   user@dbHost galaxy MYPASSWD
  SQLAuthTypes     SHA1
  SQLUserInfo      custom:/LookupGalaxyUser
  SQLUserInfo                     custom:/LookupGalaxyUser
SQLNamedQuery LookupGalaxyUser SELECT "email,password,'712','713','/home/galaxy/galaxy_dist/database/ftp/%U','/bin/bash'FROM galaxy_user WHERE email='%U'"
  SQLDefaultHomedir  "/var/opt/local/proftpd"
  RequireValidShell off
  SQLAuthenticate users
  SQLLogFile /var/opt/local/proftpd/sqlLog.txt
</Global>


#### sqlLog.txt
Feb 09 13:55:54 mod_sql/4.2.5[2938]: defaulting to 'postgres' backend
Feb 09 13:55:54 mod_sql/4.2.5[2938]: backend module 'mod_sql_postgres/4.0.4'
Feb 09 13:55:54 mod_sql/4.2.5[2938]: backend api    'mod_sql_api_v1'
Feb 09 13:55:54 mod_sql/4.2.5[2938]: >>> sql_sess_init
Feb 09 13:55:54 mod_sql/4.2.5[2938]: entering postgres cmd_defineconnection
Feb 09 13:55:54 mod_sql/4.2.5[2938]:  name: 'default'
Feb 09 13:55:54 mod_sql/4.2.5[2938]:  user: 'galaxy'
Feb 09 13:55:54 mod_sql/4.2.5[2938]:  host: 'dbHost'
Feb 09 13:55:54 mod_sql/4.2.5[2938]:    db: 'galaxy'
Feb 09 13:55:54 mod_sql/4.2.5[2938]:  port: '5432'
Feb 09 13:55:54 mod_sql/4.2.5[2938]:   ttl: '0'
Feb 09 13:55:54 mod_sql/4.2.5[2938]: exiting postgres cmd_defineconnection
Feb 09 13:55:54 mod_sql/4.2.5[2938]: mod_sql engine     : on
Feb 09 13:55:54 mod_sql/4.2.5[2938]: negative_cache     : off
Feb 09 13:55:54 mod_sql/4.2.5[2938]: authenticate       : users
Feb 09 13:55:54 mod_sql/4.2.5[2938]: usertable          : users
Feb 09 13:55:54 mod_sql/4.2.5[2938]: userid field       : userid
Feb 09 13:55:54 mod_sql/4.2.5[2938]: password field     : passwd
Feb 09 13:55:54 mod_sql/4.2.5[2938]: UID field          : uid
Feb 09 13:55:54 mod_sql/4.2.5[2938]: GID field          : gid
Feb 09 13:55:54 mod_sql/4.2.5[2938]: homedir field      : homedir
Feb 09 13:55:54 mod_sql/4.2.5[2938]: homedir(default) : '/var/opt/local/proftpd'
Feb 09 13:55:54 mod_sql/4.2.5[2938]: shell field        : shell
Feb 09 13:55:54 mod_sql/4.2.5[2938]: SQLMinUserUID      : 999
Feb 09 13:55:54 mod_sql/4.2.5[2938]: SQLMinUserGID      : 999
Feb 09 13:55:54 mod_sql/4.2.5[2938]: <<< sql_sess_init
Feb 09 13:55:59 mod_sql/4.2.5[2938]: >>> sql_pre_pass
Feb 09 13:55:59 mod_sql/4.2.5[2938]: <<< sql_pre_pass
Feb 09 13:55:59 mod_sql/4.2.5[2938]: >>> cmd_getpwnam
Feb 09 13:55:59 mod_sql/4.2.5[2938]: entering   postgres cmd_escapestring
Feb 09 13:55:59 mod_sql/4.2.5[2938]: entering   postgres cmd_open
Feb 09 13:55:59 mod_sql/4.2.5[2938]: Postgres server version: 8.4.2
Feb 09 13:55:59 mod_sql/4.2.5[2938]: connection 'default' opened
Feb 09 13:55:59 mod_sql/4.2.5[2938]: connection 'default' count is now 2
Feb 09 13:55:59 mod_sql/4.2.5[2938]: exiting    postgres cmd_open
Feb 09 13:55:59 mod_sql/4.2.5[2938]: entering   postgres cmd_close
Feb 09 13:55:59 mod_sql/4.2.5[2938]: connection 'default' count is now 1
Feb 09 13:55:59 mod_sql/4.2.5[2938]: exiting    postgres cmd_close
Feb 09 13:55:59 mod_sql/4.2.5[2938]: exiting    postgres cmd_escapestring
Feb 09 13:55:59 mod_sql/4.2.5[2938]: cache miss for user 'galaxyUserEmail'
Feb 09 13:55:59 mod_sql/4.2.5[2938]: >>> sql_lookup
Feb 09 13:55:59 mod_sql/4.2.5[2938]: >>> process_named_query 'LookupGalaxyUser'
Feb 09 13:55:59 mod_sql/4.2.5[2938]: entering   postgres cmd_escapestring
Feb 09 13:55:59 mod_sql/4.2.5[2938]: entering   postgres cmd_open
Feb 09 13:55:59 mod_sql/4.2.5[2938]: connection 'default' count is now 2
Feb 09 13:55:59 mod_sql/4.2.5[2938]: exiting    postgres cmd_open
Feb 09 13:55:59 mod_sql/4.2.5[2938]: entering   postgres cmd_close
Feb 09 13:55:59 mod_sql/4.2.5[2938]: connection 'default' count is now 1
Feb 09 13:55:59 mod_sql/4.2.5[2938]: exiting    postgres cmd_close
Feb 09 13:55:59 mod_sql/4.2.5[2938]: exiting    postgres cmd_escapestring
Feb 09 13:55:59 mod_sql/4.2.5[2938]: entering   postgres cmd_escapestring
Feb 09 13:55:59 mod_sql/4.2.5[2938]: entering   postgres cmd_open
Feb 09 13:55:59 mod_sql/4.2.5[2938]: connection 'default' count is now 2
Feb 09 13:55:59 mod_sql/4.2.5[2938]: exiting    postgres cmd_open
Feb 09 13:55:59 mod_sql/4.2.5[2938]: entering   postgres cmd_close
Feb 09 13:55:59 mod_sql/4.2.5[2938]: connection 'default' count is now 1
Feb 09 13:55:59 mod_sql/4.2.5[2938]: exiting    postgres cmd_close
Feb 09 13:55:59 mod_sql/4.2.5[2938]: exiting    postgres cmd_escapestring
Feb 09 13:55:59 mod_sql/4.2.5[2938]: entering   postgres cmd_select
Feb 09 13:55:59 mod_sql/4.2.5[2938]: entering   postgres cmd_open
Feb 09 13:55:59 mod_sql/4.2.5[2938]: connection 'default' count is now 2
Feb 09 13:55:59 mod_sql/4.2.5[2938]: exiting    postgres cmd_open
Feb 09 13:55:59 mod_sql/4.2.5[2938]: query "SELECT email,password,'712','713','/home/galaxy/galaxy_dist/database/ftp/galaxyUserEmail','/bin/bash'FROM galaxy_user WHERE email='galaxyUserEmail'"
Feb 09 13:55:59 mod_sql/4.2.5[2938]: entering   postgres cmd_close
Feb 09 13:55:59 mod_sql/4.2.5[2938]: connection 'default' count is now 1
Feb 09 13:55:59 mod_sql/4.2.5[2938]: exiting    postgres cmd_close
Feb 09 13:55:59 mod_sql/4.2.5[2938]: exiting    postgres cmd_select
Feb 09 13:55:59 mod_sql/4.2.5[2938]: <<< process_named_query 'LookupGalaxyUser'
Feb 09 13:55:59 mod_sql/4.2.5[2938]: <<< sql_lookup
Feb 09 13:55:59 mod_sql/4.2.5[2938]: user UID 712 below SQLMinUserUID 999, using SQLDefaultUID 65533 Feb 09 13:55:59 mod_sql/4.2.5[2938]: user GID 713 below SQLMinUserGID 999, using SQLDefaultGID 65533
Feb 09 13:55:59 mod_sql/4.2.5[2938]: cache miss for user 'galaxyUserEmail'
Feb 09 13:55:59 mod_sql/4.2.5[2938]: user 'galaxyUserEmail' cached
Feb 09 13:55:59 mod_sql/4.2.5[2938]: + pwd.pw_name  : galaxyUserEmail
Feb 09 13:55:59 mod_sql/4.2.5[2938]: + pwd.pw_uid   : 65533
Feb 09 13:55:59 mod_sql/4.2.5[2938]: + pwd.pw_gid   : 65533
Feb 09 13:55:59 mod_sql/4.2.5[2938]: + pwd.pw_dir : /home/galaxy/galaxy_dist/database/ftp/galaxyUserEmail
Feb 09 13:55:59 mod_sql/4.2.5[2938]: + pwd.pw_shell : /bin/bash
Feb 09 13:55:59 mod_sql/4.2.5[2938]: <<< cmd_getpwnam
Feb 09 13:55:59 mod_sql/4.2.5[2938]: >>> cmd_auth
Feb 09 13:55:59 mod_sql/4.2.5[2938]: entering   postgres cmd_escapestring
Feb 09 13:55:59 mod_sql/4.2.5[2938]: entering   postgres cmd_open
Feb 09 13:55:59 mod_sql/4.2.5[2938]: connection 'default' count is now 2
Feb 09 13:55:59 mod_sql/4.2.5[2938]: exiting    postgres cmd_open
Feb 09 13:55:59 mod_sql/4.2.5[2938]: entering   postgres cmd_close
Feb 09 13:55:59 mod_sql/4.2.5[2938]: connection 'default' count is now 1
Feb 09 13:55:59 mod_sql/4.2.5[2938]: exiting    postgres cmd_close
Feb 09 13:55:59 mod_sql/4.2.5[2938]: exiting    postgres cmd_escapestring
Feb 09 13:55:59 mod_sql/4.2.5[2938]: cache hit for user 'galaxyUserEmail'
Feb 09 13:55:59 mod_sql/4.2.5[2938]: >>> cmd_check
Feb 09 13:55:59 mod_sql/4.2.5[2938]: checking password using SQLAuthType 'sha1' Feb 09 13:55:59 mod_sql/4.2.5[2938]: 'sha1' SQLAuthType handler reports success
Feb 09 13:55:59 mod_sql/4.2.5[2938]: cache hit for user 'galaxyUserEmail'
Feb 09 13:55:59 mod_sql/4.2.5[2938]: <<< cmd_check
Feb 09 13:55:59 mod_sql/4.2.5[2938]: <<< cmd_auth
Feb 09 13:55:59 mod_sql/4.2.5[2938]: >>> cmd_getpwnam
Feb 09 13:55:59 mod_sql/4.2.5[2938]: cache hit for user 'galaxyUserEmail'
Feb 09 13:55:59 mod_sql/4.2.5[2938]: <<< cmd_getpwnam
Feb 09 13:55:59 mod_sql/4.2.5[2938]: >>> cmd_getpwnam
Feb 09 13:55:59 mod_sql/4.2.5[2938]: cache hit for user 'galaxyUserEmail'
Feb 09 13:55:59 mod_sql/4.2.5[2938]: <<< cmd_getpwnam
Feb 09 13:55:59 mod_sql/4.2.5[2938]: entering   postgres cmd_exit
Feb 09 13:55:59 mod_sql/4.2.5[2938]: entering   postgres cmd_close
Feb 09 13:55:59 mod_sql/4.2.5[2938]: connection 'default' closed
Feb 09 13:55:59 mod_sql/4.2.5[2938]: connection 'default' count is now 0
Feb 09 13:55:59 mod_sql/4.2.5[2938]: exiting    postgres cmd_close
Feb 09 13:55:59 mod_sql/4.2.5[2938]: exiting    postgres cmd_exit



_______________________________________________
galaxy-dev mailing list
galaxy-dev@lists.bx.psu.edu
http://lists.bx.psu.edu/listinfo/galaxy-dev

Reply via email to