So I tried a new version of ProFTPd I was not able to locate lines in universe_wsgi.ini which disable PBKDF2 Lines from SQLLogFile.txt 2014-01-21 18:09:33,191 mod_sql/4.3[2275]: checking password using SQLAuthType 'sha1' 2014-01-21 18:09:33,191 mod_sql/4.3[2275]: 'sha1' SQLAuthType handler reports failure 2014-01-21 18:09:33,191 mod_sql/4.3[2275]: checking password using SQLAuthType 'sha256' 2014-01-21 18:09:33,191 mod_sql/4.3[2275]: 'sha256' SQLAuthType handler reports failure 2014-01-21 18:09:33,191 mod_sql/4.3[2275]: checking password using SQLAuthType 'pbkdf2' 2014-01-21 18:09:33,193 mod_sql/4.3[2275]: 'pbkdf2' SQLAuthType handler reports failure 2014-01-21 18:09:33,193 mod_sql/4.3[2275]: <<< cmd_check 2014-01-21 18:09:33,193 mod_sql/4.3[2275]: <<< cmd_auth 2014-01-21 18:13:54,383 mod_sql/4.3[2275]: entering postgres cmd_exit Proftpd.conf # Set up mod_sql to authenticate against the Galaxy database SQLEngine on SQLBackend postgres SQLConnectInfo galaxy_prod@:1234 user password SQLAuthTypes SHA1 SHA256 PBKDF2 SQLPasswordPBKDF2 SHA256 1000 24 SQLAuthenticate users Launch interactive session to test /ProFTPd-1.3.5rc3/sbin/proftpd -d9 -n Std_Out shows: opening scoreboard '/shared/app/ProFTPd-1.3.5rc3/var/proftpd.scoreboard' RELINQUISH PRIVS at mod_auth.c:132 connected - local : ::ffff:128.23.191.200:21 connected - remote : 128.23.163.166:54865 FTP session opened. dispatching PRE_CMD command 'USER galaxy@musc.edu' to mod_core dispatching PRE_CMD command 'USER galaxy@musc.edu' to mod_core dispatching PRE_CMD command 'USER galaxy@musc.edu' to mod_delay dispatching PRE_CMD command 'USER galaxy@musc.edu' to mod_auth dispatching CMD command 'USER galaxy@musc.edu' to mod_auth dispatching POST_CMD command 'USER galaxy@musc.edu' to mod_sql dispatching POST_CMD command 'USER galaxy@musc.edu' to mod_delay dispatching LOG_CMD command 'USER galaxy@musc.edu' to mod_sql dispatching LOG_CMD command 'USER galaxy@musc.edu' to mod_lo dispatching PRE_CMD command 'PASS (hidden)' to mod_core dispatching PRE_CMD command 'PASS (hidden)' to mod_core dispatching PRE_CMD command 'PASS (hidden)' to mod_sql_passwd dispatching PRE_CMD command 'PASS (hidden)' to mod_sql dispatching PRE_CMD command 'PASS (hidden)' to mod_delay dispatching PRE_CMD command 'PASS (hidden)' to mod_auth dispatching CMD command 'PASS (hidden)' to mod_auth no supplemental groups found for user 'galaxy@musc.edu' ROOT PRIVS at mod_auth_pam.c:338 RELINQUISH PRIVS at mod_auth_pam.c:508 mod_sql_passwd/0.6: expected 'PBKDF2$sha256$10000$vHKjTtvJsQSB2BuH$dGmwtBwxQ9yAz5kxzn9nF704PKeMnReV', got '1fd439fa1297e68426765a5c0b80a6ca4591888a' mod_sql_passwd/0.6: expected 'PBKDF2$sha256$10000$vHKjTtvJsQSB2BuH$dGmwtBwxQ9yAz5kxzn9nF704PKeMnReV', got '268f784ba4c2283244e9730500f2a8126c84169ef985a70313c16464358ecc5c' mod_sql_passwd/0.6: expected 'PBKDF2$sha256$10000$vHKjTtvJsQSB2BuH$dGmwtBwxQ9yAz5kxzn9nF704PKeMnReV', got '5f40c627d580e898f9742508c3aa0f0fbe87850e3b389ac1' USER galaxy@musc.edu (Login failed): No such user found. I upgraded to ProFTPd-1.3.5rc3 because v 1.3.4 could not authenticate users on my local Galaxy instance. I understood that Galaxy was using SHA1 SHA256 PBKDF2 authentication but the programs are not yet compatible I used a proftpd conf file based on http://dev.list.galaxyproject.org/ProFTPD-integration-with-Galaxy-td4660295 .html I get the same problems when I use the following line in profited.conf SQLPasswordPBKDF2 SHA256 10000 24 Why am I seeing this mismatch? I tried to create a new user to see if the extant user accounts had somehow been left over from a previous build of the Galaxy user files, but the new user had the same issues. Puzzled Starr On 1/8/14, 5:26 PM, "Hazard, E. Starr" <hazards@musc.edu> wrote:
Well when I declare
SQLAuthTypes SHA1 SHA256 PBKDF2 SQLPasswordPBKDF2 SHA256 10000 24 (per
I get this response
/shared/app/ProFFTPd-1.3.4d/sbin/proftpd -d9 -n hpcc3 proftpd[31522]: using TCP receive buffer size of 87380 bytes hpcc3 proftpd[31522]: using TCP send buffer size of 16384 bytes hpcc3 proftpd[31522]: mod_sql_passwd/0.4: registered 'md5' SQLAuthType handler hpcc3 proftpd[31522]: mod_sql_passwd/0.4: registered 'sha1' SQLAuthType handler hpcc3 proftpd[31522]: mod_sql_passwd/0.4: registered 'sha256' SQLAuthType handler hpcc3 proftpd[31522]: mod_sql_passwd/0.4: registered 'sha512' SQLAuthType handler hpcc3 proftpd[31522]: disabling runtime support for IPv6 connections hpcc3 proftpd[31522]: Fatal: SQLAuthTypes: unknown SQLAuthType 'PBKDF2' on line 106 of '/shared/app/ProFFTPd-1.3.4d/etc/proftpd.conf¹
SO ProFTPd-1.3.4d does not do PBKDF2
Just saw this post
http://dev.list.galaxyproject.org/ProFTPD-integration-with-Galaxy-td466029 5 .html
Will move to the release candidate version of ProFTPD And try that
THANKS for responding
Starr
On 1/8/14, 5:05 PM, "James Taylor" <james@jamestaylor.org> wrote:
PBKDF2