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
galaxy-dev@lists.galaxyproject.org