Dear all, I am trying to setup sftp connection for my new Galaxy server. I managed to configure sftp_module and I am able to connect to the server as an system user. The problem is that I am not able to login there as Galaxy user. I guess that the problem is with settings for backend and postgresql, but I don't know how to solve it. My configuration for sql is: # Do not authenticate against real (system) users AuthPAM off # Set up mod_sql_password - Galaxy passwords are stored as hex-encoded SHA1 SQLLogFile /home/galaxy/galaxy/log_files/sqlLog.txt SQLPasswordEngine on SQLPasswordEncoding hex # Set up mod_sql to authenticate against the Galaxy database SQLEngine on SQLBackend postgres SQLConnectInfo galaxy@localhost:5432 galaxy SQLAuthTypes SHA1 SQLAuthenticate users # An empty directory in case chroot fails SQLDefaultUID 1001 SQLDefaultGID 1001 SQLDefaultHomedir /var/lib/proftpd/empty # 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,'1001','1001','/home/data/galaxy_ftp/%U','/bin/bash' FROM galaxy_user WHERE email='%U'" Db name is galaxy, user is galaxy, no pass. Any recommendation, please? Regards, Mag. Marija Đurđević Core Facility Computational Bioanalytics Medical University of Graz Center for Medical Research Stiftingtalstraße 24, A-8010 Graz Austria Phone: +43 316/385-73024 Fax:+43 316/385-73009 Email: marija.djurdjevic@medunigraz.at Email: marija.djurdjevic@klinikum-graz.at Web: https://zmf.medunigraz.at/