- galaxy-dev - lists.galaxyproject.org

validation for tools
by מירב . 25 Jun '13

25 Jun '13

Hi, I want to do some checks on tools I'm using(in this case I'm checking svdetect). I have a program that creats .fasta file of genome with some structural variants. Now I need a tool wich will simulate the illumina's sequencing read and output .fastq files(or .sam files). Does galaxy have such tool? If not, do you have suggestion for something out of galaxy? Thanks for your help merav

2 1

Proxy error while testing FASTX tools?
by Sebastian Schaaf 25 Jun '13

25 Jun '13

Hi all, I've got a relatively fresh installed Galaxy instance running within a locked network, where internet access is allowed only via a proxy. So far, so simple; indeed I get internet access via a terminal (e.g. calling Google with lynx), also wget and mercurial have the chance to access target URL's. The variables $http_proxy, $https_proxy and $ftp_proxy are set. My problem occurs when I try to execute the automatic tests (using 'run_functional_tests.sh') for the FASTX toolbox, described here right at the end: http://hannonlab.cshl.edu/fastx_toolkit/download.html The calls of the scripts generally end up in an error block of the following scheme: ##### functional_tests.py DEBUG 2013-06-25 14:15:40,406 Attempting to serve app on randomly chosen port: 8720 functional_tests.py INFO 2013-06-25 14:15:40,468 Embedded web server started base.asserts DEBUG 2013-06-25 14:15:40,506 base.asserts.text base.asserts DEBUG 2013-06-25 14:15:40,506 base.asserts.tabular base.asserts DEBUG 2013-06-25 14:15:40,506 base.asserts.xml functional_tests.py INFO 2013-06-25 14:15:40,506 Functional tests will be run against localhost:8720 nose.plugins.manager DEBUG 2013-06-25 14:15:40,518 DefaultPluginManager load plugin nosetestdiff = nosetestdiff.plugin:NoseTes tDiff nose.plugins.manager DEBUG 2013-06-25 14:15:40,520 DefaultPluginManager load plugin nosehtml = nosehtml.plugin:NoseHTML Uncollapse ( cshl_fastx_uncollapser ) > Test-1 ... ERROR ====================================================================== ERROR: Uncollapse ( cshl_fastx_uncollapser ) > Test-1 ---------------------------------------------------------------------- Traceback (most recent call last): File "/home/galaxy/galaxy-dist/test/base/twilltestcase.py", line 53, in setUp self.home() File "/home/galaxy/galaxy-dist/test/base/twilltestcase.py", line 1141, in home self.visit_url( self.url ) File "/home/galaxy/galaxy-dist/test/base/twilltestcase.py", line 1324, in visit_url tc.code( 200 ) File "/home/galaxy/galaxy-dist/eggs/twill-0.9-py2.6.egg/twill/commands.py", line 133, in code should_be)) TwillAssertionError: code is 403 != 200 ---------------------------------------------------------------------- Ran 1 test in 0.011s FAILED (errors=1) ##### For me it reads like there is problem while testing to call the URL in self.url, which resolves to 'localhost:9441'. URL and port are drawn from the environment in the script ".../galaxy-dist/test/base/twilltestcase.py": ##### class TwillTestCase( unittest.TestCase ): def setUp( self ): [...] self.host = os.environ.get( 'GALAXY_TEST_HOST' ) self.port = os.environ.get( 'GALAXY_TEST_PORT ) self.url = "http://%s:%s" % ( self.host, self.port ) [...] ##### I could neither observe any process listening to port 9441 during the test script execution, nor any of the text files within the galaxy root dir contained '9441' as part of a configuration option. Finally I'm a bit confused what that means to me, beyond just not to be able to use the test suite. Anyone an idea what could and/or should be fixed or checked? Thanks in advance, Sebastian -- Sebastian Schaaf, M.Sc. Bioinformatics Department of Medical Informatics, Biometry and Epidemiology (IBE) University of Munich

1 0

How to enable auto option for newly added file formats
by shashi shekhar 24 Jun '13

24 Jun '13

Hi, I want to enable option auto option for some format ..how will i proceed . I have alreadu added the format in galaxy ., which works without auto option. Regards shashi

2 1

account avatar
by Philipe Moncuquet 24 Jun '13

24 Jun '13

Hi, We are running a local instance of Galaxy behind firewall. How can one modify the picture associated with is galaxy account in the configuration ? Regards, Philippe

2 1

GATK tools not showing up in cloudman Galaxy installation
by Marco Ocana 24 Jun '13

24 Jun '13

Hi, When starting up Galaxy from Cloudman and updating the latest version from repository, most of the GATK tools do not show up in the tool bar. I have attached the log file. There are other errors in the log file, but I have pasted what I believe the relavant section of the log. Any pointers on how to fix the problem would be appreciated. Thanks Marco Traceback (most recent call last): File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 396, in load_tool_tag_set tool = self.load_tool( os.path.join( tool_path, path ), guid=guid ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 515, in load_tool return ToolClass( config_file, root, self.app, guid=guid ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 855, in __init__ self.parse( root, guid=guid ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1028, in parse self.parse_inputs( root ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1112, in parse_inputs display, inputs = self.parse_input_page( page, enctypes ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1516, in parse_input_page inputs = self.parse_input_elem( input_elem, enctypes ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1583, in parse_input_elem case.inputs = self.parse_input_elem( case_elem, enctypes, context ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1609, in parse_input_elem param = self.parse_param_elem( elem, enctypes, context ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1621, in parse_param_elem param = ToolParameter.build( self, input_elem ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/parameters/basic.py", line 176, in build return parameter_types[param_type]( tool, param ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/parameters/basic.py", line 1361, in __init__ ToolParameter.__init__( self, tool, elem ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/parameters/basic.py", line 43, in __init__ self.validators.append( validation.Validator.from_element( self, elem ) ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/parameters/validation.py", line 23, in from_element return validator_types[type].from_element( param, elem ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/parameters/validation.py", line 279, in from_element tool_data_table = param.tool.app.tool_data_tables[ table_name ] File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/data/__init__.py", line 25, in __getitem__ return self.data_tables.__getitem__( key ) KeyError: 'gatk_picard_indexes' galaxy.tools ERROR 2013-06-20 17:54:00,272 Error reading tool from path: gatk/indel_realigner.xml Traceback (most recent call last): File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 396, in load_tool_tag_set tool = self.load_tool( os.path.join( tool_path, path ), guid=guid ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 515, in load_tool return ToolClass( config_file, root, self.app, guid=guid ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 855, in __init__ self.parse( root, guid=guid ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1028, in parse self.parse_inputs( root ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1112, in parse_inputs display, inputs = self.parse_input_page( page, enctypes ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1516, in parse_input_page inputs = self.parse_input_elem( input_elem, enctypes ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1583, in parse_input_elem case.inputs = self.parse_input_elem( case_elem, enctypes, context ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1609, in parse_input_elem param = self.parse_param_elem( elem, enctypes, context ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1621, in parse_param_elem param = ToolParameter.build( self, input_elem ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/parameters/basic.py", line 176, in build return parameter_types[param_type]( tool, param ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/parameters/basic.py", line 1361, in __init__ ToolParameter.__init__( self, tool, elem ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/parameters/basic.py", line 43, in __init__ self.validators.append( validation.Validator.from_element( self, elem ) ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/parameters/validation.py", line 23, in from_element return validator_types[type].from_element( param, elem ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/parameters/validation.py", line 279, in from_element tool_data_table = param.tool.app.tool_data_tables[ table_name ] File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/data/__init__.py", line 25, in __getitem__ return self.data_tables.__getitem__( key ) KeyError: 'gatk_picard_indexes' galaxy.tools ERROR 2013-06-20 17:54:00,281 Error reading tool from path: gatk/count_covariates.xml Traceback (most recent call last): File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 396, in load_tool_tag_set tool = self.load_tool( os.path.join( tool_path, path ), guid=guid ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 515, in load_tool return ToolClass( config_file, root, self.app, guid=guid ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 855, in __init__ self.parse( root, guid=guid ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1028, in parse self.parse_inputs( root ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1112, in parse_inputs display, inputs = self.parse_input_page( page, enctypes ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1516, in parse_input_page inputs = self.parse_input_elem( input_elem, enctypes ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1583, in parse_input_elem case.inputs = self.parse_input_elem( case_elem, enctypes, context ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1609, in parse_input_elem param = self.parse_param_elem( elem, enctypes, context ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1621, in parse_param_elem param = ToolParameter.build( self, input_elem ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/parameters/basic.py", line 176, in build return parameter_types[param_type]( tool, param ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/parameters/basic.py", line 1361, in __init__ ToolParameter.__init__( self, tool, elem ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/parameters/basic.py", line 43, in __init__ self.validators.append( validation.Validator.from_element( self, elem ) ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/parameters/validation.py", line 23, in from_element return validator_types[type].from_element( param, elem ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/parameters/validation.py", line 279, in from_element tool_data_table = param.tool.app.tool_data_tables[ table_name ] File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/data/__init__.py", line 25, in __getitem__ return self.data_tables.__getitem__( key ) KeyError: 'gatk_picard_indexes' galaxy.tools ERROR 2013-06-20 17:54:00,290 Error reading tool from path: gatk/table_recalibration.xml Traceback (most recent call last): File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 396, in load_tool_tag_set tool = self.load_tool( os.path.join( tool_path, path ), guid=guid ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 515, in load_tool return ToolClass( config_file, root, self.app, guid=guid ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 855, in __init__ self.parse( root, guid=guid ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1028, in parse self.parse_inputs( root ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1112, in parse_inputs display, inputs = self.parse_input_page( page, enctypes ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1516, in parse_input_page inputs = self.parse_input_elem( input_elem, enctypes ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1583, in parse_input_elem case.inputs = self.parse_input_elem( case_elem, enctypes, context ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1609, in parse_input_elem param = self.parse_param_elem( elem, enctypes, context ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1621, in parse_param_elem param = ToolParameter.build( self, input_elem ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/parameters/basic.py", line 176, in build return parameter_types[param_type]( tool, param ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/parameters/basic.py", line 1361, in __init__ ToolParameter.__init__( self, tool, elem ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/parameters/basic.py", line 43, in __init__ self.validators.append( validation.Validator.from_element( self, elem ) ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/parameters/validation.py", line 23, in from_element return validator_types[type].from_element( param, elem ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/parameters/validation.py", line 279, in from_element tool_data_table = param.tool.app.tool_data_tables[ table_name ] File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/data/__init__.py", line 25, in __getitem__ return self.data_tables.__getitem__( key ) KeyError: 'gatk_picard_indexes' galaxy.tools ERROR 2013-06-20 17:54:00,323 Error reading tool from path: gatk/unified_genotyper.xml Traceback (most recent call last): File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 396, in load_tool_tag_set tool = self.load_tool( os.path.join( tool_path, path ), guid=guid ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 515, in load_tool return ToolClass( config_file, root, self.app, guid=guid ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 855, in __init__ self.parse( root, guid=guid ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1028, in parse self.parse_inputs( root ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1112, in parse_inputs display, inputs = self.parse_input_page( page, enctypes ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1516, in parse_input_page inputs = self.parse_input_elem( input_elem, enctypes ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1583, in parse_input_elem case.inputs = self.parse_input_elem( case_elem, enctypes, context ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1539, in parse_input_elem group.inputs = self.parse_input_elem( elem, enctypes, context ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1609, in parse_input_elem param = self.parse_param_elem( elem, enctypes, context ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/__init__.py", line 1621, in parse_param_elem param = ToolParameter.build( self, input_elem ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/parameters/basic.py", line 176, in build return parameter_types[param_type]( tool, param ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/parameters/basic.py", line 1361, in __init__ ToolParameter.__init__( self, tool, elem ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/parameters/basic.py", line 43, in __init__ self.validators.append( validation.Validator.from_element( self, elem ) ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/parameters/validation.py", line 23, in from_element return validator_types[type].from_element( param, elem ) File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/parameters/validation.py", line 279, in from_element tool_data_table = param.tool.app.tool_data_tables[ table_name ] File "/mnt/galaxyTools/galaxy-central/lib/galaxy/tools/data/__init__.py", line 25, in __getitem__ return self.data_tables.__getitem__( key ) KeyError: 'gatk_picard_indexes'

2 2

[GSoC2013] Week 1 Accomplishments and Week 2 Plans
by Saket Choudhary 24 Jun '13

24 Jun '13

Hi Everyone, Just wrote a blog post for my Week1 tasks and Week 2 to-dos: http://galaxy-gsoc2013.blogspot.in/2013/06/week-1-accomplishments-and-week-… I am maintaining a work log in this doc : https://docs.google.com/document/d/1VCKCpKW6C_Tt1DYWi43GAN_Jo-nebkkj8Ctq7WL… If you have any suggestions for the VCF4.1 issue or otherwise. please do let me know. Thanks Saket Choudhary Undergraduate Dept. of Chemical Engineering IIT Bombay

1 0

Re: [galaxy-dev] [galaxy-user] Problems when downloading a local galaxy tool (old version)
by Dannon Baker 23 Jun '13

23 Jun '13

Hsiong, Could you try 'hg clone --verbose --debug https://bitbucket.org/galaxy/galaxy-dist/' to see if we get more useful error output? If it passed the warning and went ahead and got all the changes then I'm not sure if that's an issue. Also, I'm swapping this thread to the galaxy-dev list, since it's about installing a local instance. -Dannon On Sun, Jun 23, 2013 at 1:15 AM, xiong <lynhsiong(a)hotmail.com> wrote: > ** > Dear friends: > > As a locally installed Genomic-hyperbrowser need a rather old > version of Galaxy, I runed the command "hg clone > https://bitbucket.org/galaxy/galaxy-dist/ -u 26920e20157f galaxy-dist-hb" > according to the website > http://hyperbrowser.uio.no/hb/static/download.html. However, the hg did > not download successfully, but reported > > "warning: bitbucket.org certificate with fingerprint > 24:9c:45:8b:9c:aa:ba:55:4e:01:6d:58:ff:e4:28:7d:2a:14:ae:3b not verified > (check hostfingerprints or web.cacerts config setting) > destination directory: galaxy-dist-hb > requesting all changes > adding changesets" > > and this information on the screen mainteined (at least half a day unless > I hit "ctrl+Z" and kill the job) without any other errors (still in the > destination directory it generated a nearly empty dir > "galaxy-dist-hb" containing a filefold named ".hg”——one "store" filefold > and several small files included). My mercurial version is 2.6, and I use > Xshell to reach CentOS Server. > > Actually, even I downloaded the latest version of galaxy (hg clone > https://bitbucket.org/galaxy/galaxy-dist/) it also reported the same > information on the screen. > On the other hand, I can get the latest tarballs of galaxy, but > it can not be updated to an old version. > > Please give me some clues about problems above, and any ideas to get > tarballs for an old version? > > Thanks in advance! > > Hsiong > > ___________________________________________________________ > The Galaxy User list should be used for the discussion of > Galaxy analysis and other features on the public server > at usegalaxy.org. Please keep all replies on the list by > using "reply all" in your mail client. For discussion of > local Galaxy instances and the Galaxy source code, please > use the Galaxy Development list: > > http://lists.bx.psu.edu/listinfo/galaxy-dev > > 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/ >

1 0

Profile loss
by Marley Yeong 22 Jun '13

22 Jun '13

Dear sir or madam, It seems my profile has been deleted, before galaxy went offline (about two weeks ago) I made a profile with the email address: marleyyeong(a)live.nl.I keep getting the "no such user" error. And I'm pretty sure the login information is typed correctly.It stored a school project, so any help would be greatly appreciated. Thanks in advance, Marley Yeong

2 1

Re: [galaxy-dev] Portable tool identifiers in workflows
by Peter Cock 22 Jun '13

22 Jun '13

On Thu, Jun 13, 2013 at 6:34 PM, Greg Von Kuster <greg(a)bx.psu.edu> wrote: > Hello Peter, > > Unfortunately, workflows are currently not very compatible with > the tool shed - there is a Trello card that details the issues here: > > https://trello.com/card/workflow-issues/506338ce32ae458f6d15e4b3/692 > Thanks Greg - I see that Trello card is "in progress", but it covers quite a broad range of issues. >> So, does Galaxy handle old fashioned tool identifiers and the >> newer toolshed-tool-identifiers gracefully in a situation like this? > > Unfortunately this does not currently work ... > >> Do I need to update the *.ga files to use toolshed-tool-ids? If >> I did that, would it break the workflow on any Galaxy instance >> (like ours) where the tools were installed manually? > > Yes, you would currently need to update the workflows to use > toolshed-tool-ids, and your statement regarding the workflow > not working with older tools is correct. So in the short term the best thing to do is to edit these workflows as posted on the Tool Shed (easy enough as the *.ga files are plain text) to replace the tool identifiers? What would be the easiest way to work out the desired id form from a tool repository page? Other than reinstalling the tools locally but from the Tool Shed this time? ;) Thanks, Peter

2 3

Re: [galaxy-dev] ProFTPD integration with Galaxy
by Perez, Ricardo 21 Jun '13

21 Jun '13

Hi Mr. Tobias, We are having a similar problem. It seems that when the galaxy code was updates, new created/updated passwords are using a different encryption mode. This new mode, PBKDF2 SHA256 is NOT supported by proftpd 1.3.4d that you see to be using. We had to compile proftpd from source since version 1.3.5rc3 does support this encryption. Now in the password PBKDF2$sha256$10000$8h/4HmD1Eu6NTc7F$Slb1H5a9YJvR6A3cUnZCUfh7tOWKfRuh I was able to deduce the following by reading the code from git hub "password.py". The encrypted password is acually Slb1H5a9YJvR6A3cUnZCUfh7tOWKfRuh where the salt is 8h/4HmD1Eu6NTc7F using PBKDF2 SHA256 with an illiteration value of 10000. The most importnat part is that the salt, is right there, from character 21 to 36. With the newly compiled proftpd, I have the following configuration at 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 "Genomics01 ProFTPd" 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 ftpuser mypassword SQLUserInfo custom:/LookupGalaxyUser SQLNamedQuery LookupGalaxyUser SELECT "email,password,'galaxy','galaxy','/usr/local/galaxy/galaxy-dist/database/ftp/%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,'galaxy','galaxy','/usr/local/galaxy/galaxy-dist/database/ftp/%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'" </IfModule> SQLDefaultGID 1002 SQLDefaultUID 1002 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 galaxy Group galaxy # 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> Include /etc/proftpd/conf.d/ With the configuration above, I can still connect to users that have SHA1 passwords, but I think I need a little more tweeking to get it to work with the new passwords. Best, --Ricardo Perez

2 2