Bug#687139: proftpd-mod-pgsql: SQLUserInfo custom:/get-user-by-name not honoured in DefaultRoot ~

[gyszabolcs at primerate.hu]

Package: proftpd-mod-pgsql
Version: 1.3.3a-6squeeze4
Severity: normal

I have a custom SQL for userinfo (SQLNamedQuery). If I have no "DefaultRoot ~/" option in VirtualHost config everything is working.
After I add "DefaultRoot ~/" to my VirtualHost I got this in sql.log:

szept 10 09:35:33 mod_sql/4.2.5[13273]: unrecoverable backend error
szept 10 09:35:33 mod_sql/4.2.5[13273]: error: 'mod_sql_postgres/4.0.4'
szept 10 09:35:33 mod_sql/4.2.5[13273]: message: 'ERROR:  permission denied for relation users
'
szept 10 09:35:33 mod_sql/4.2.5[13273]: entering        postgres cmd_exit
szept 10 09:35:33 mod_sql/4.2.5[13273]: entering        postgres cmd_close

but I have a 

SQLNamedQuery get-user-by-name SELECT "a.email as userid, substring(a.password from '[^$]*$') as password, e.uid as uid, e.gid as gid, d.name as homedir, '/bin/false' as shell FROM auth_user as a, user_ext_info as e, directories as d WHERE a.id = e.auth_user_id and e.directories_id = d.id and a.email='%{0}'"

I had to create a VIEW for this SQLNamedQuery so that DefaultRoot ~/ could work.

-- System Information:
Debian Release: 6.0.5
  APT prefers stable-updates
  APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: i386 (i686)

Kernel: Linux 2.6.32-5-686 (SMP w/4 CPU cores)
Locale: LANG=hu_HU.UTF-8, LC_CTYPE=hu_HU.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages proftpd-mod-pgsql depends on:
ii  libc6                   2.11.3-3         Embedded GNU C Library: Shared lib
ii  libpq5                  8.4.13-0squeeze1 PostgreSQL C client library
ii  proftpd-basic           1.3.3a-6squeeze4 Versatile, virtual-hosting FTP dae

proftpd-mod-pgsql recommends no packages.

proftpd-mod-pgsql suggests no packages.

-- no debconf information