LookupGalaxyUser SELECT "email,password,'504','504','/home/nate/galaxy_dist/database/ftp/%U','/bin/bash' FROM galaxy_user WHERE email='%U'"

---

Date: Fri, 15 Jun 2012 15:55:02 +0200
From: geert.vandeweyer2@ua.ac.be
To: galaxy-dev@lists.bx.psu.edu
Subject: Re: [galaxy-dev] Configuring Proftpd for galaxy.

512 is the unix UID (userid) and GID (groupid) of the user running the galaxy daemon.

This should be adapted to meet your situation. in our case it is 1009 and 100 for example.

Look it up using :

$> id **the username running galaxy**

best regards

Geert Vandeweyer



On 06/15/2012 03:35 PM, Misharl mon wrote:

Hi everybody,

I'm configuring Proftpd so that it can work with Galaxy installed in a cluster. I don't understand why for the UID and GID, it has been chosen the number "512"?

# Define a custom query for lookup that returns a passwd-like entry.  UID and GID should match your Galaxy user.
SQLUserInfo                     custom:/LookupGalaxyUser138.102.49.9
SQLNamedQuery                   LookupGalaxyUser SELECT "email,password,'512','512','/home/nate/galaxy_dist/database/ftp/%U','/bin/bash' FROM galaxy_user WHERE email='%U'"

Because, when a galaxy user tries to connect via filezilla to upload files, the Proftpd server 's logs shows:    chdir (/work/...): Permission denied . I think i have a problem with the UID and GID which doesn't match somehow?

Thanks in advance to all.

Mish

-->

___________________________________________________________
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/

-- 

Geert Vandeweyer, Ph.D.
Department of Medical Genetics
University of Antwerp
Prins Boudewijnlaan 43
2650 Edegem
Belgium
Tel: +32 (0)3 275 97 56
E-mail: geert.vandeweyer@ua.ac.be
http://ua.ac.be/cognitivegenetics
http://www.linkedin.com/pub/geert-vandeweyer/26/457/726 

___________________________________________________________ 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/