Bug#797773: proftpd-basic: Problem with mod_sql (no queries sent)

[Michal Rydlikowski]

Package: proftpd-basic
Version: 1.3.5-1.1+deb8u1
Severity: normal

Dear Maintainer,

mod_sql doesn't work with odbc and postgresql, there is connection with database, but no querys are sent.
It works on the same configuration with the wheezy package (I builded package with wheezy version of proftpd)

Logs with ODBC:
2015-09-02 13:51:17,832 mod_sql/4.3[5935]: defaulting to 'odbc' backend
2015-09-02 13:51:17,832 mod_sql/4.3[5935]: backend module 'mod_sql_odbc/0.3.3'
2015-09-02 13:51:17,832 mod_sql/4.3[5935]: backend api    'mod_sql_api_v1'
2015-09-02 13:51:17,832 mod_sql/4.3[5935]: >>> sql_sess_init
2015-09-02 13:51:17,832 mod_sql/4.3[5935]: warning: no homedir field and no default specified. User authentication is OFF
2015-09-02 13:51:17,832 mod_sql/4.3[5935]: entering 	odbc cmd_defineconnection
2015-09-02 13:51:17,832 mod_sql/4.3[5935]:  name: 'default'
2015-09-02 13:51:17,832 mod_sql/4.3[5935]:  user: 'fittipaldi'
2015-09-02 13:51:17,832 mod_sql/4.3[5935]:   dsn: 'swift'
2015-09-02 13:51:17,832 mod_sql/4.3[5935]: exiting 	odbc cmd_defineconnection
2015-09-02 13:51:17,832 mod_sql/4.3[5935]: connection 'default' successfully established
2015-09-02 13:51:17,832 mod_sql/4.3[5935]: mod_sql engine     : on
2015-09-02 13:51:17,832 mod_sql/4.3[5935]: negative_cache     : off
2015-09-02 13:51:17,833 mod_sql/4.3[5935]: authenticate       : groups 
2015-09-02 13:51:17,833 mod_sql/4.3[5935]: group table        : Auth.FTPGroup
2015-09-02 13:51:17,833 mod_sql/4.3[5935]: groupname field    : groupName
2015-09-02 13:51:17,833 mod_sql/4.3[5935]: grp GID field      : groupId
2015-09-02 13:51:17,833 mod_sql/4.3[5935]: grp members field  : login
2015-09-02 13:51:17,833 mod_sql/4.3[5935]: SQLDefaultUID      : 65533
2015-09-02 13:51:17,833 mod_sql/4.3[5935]: SQLDefaultGID      : 65533
2015-09-02 13:51:17,833 mod_sql/4.3[5935]: <<< sql_sess_init
2015-09-02 13:51:17,836 mod_sql/4.3[5935]: >>> sql_pre_pass
2015-09-02 13:51:17,836 mod_sql/4.3[5935]: <<< sql_pre_pass
2015-09-02 13:51:17,837 mod_sql/4.3[5935]: entering 	odbc cmd_exit
2015-09-02 13:51:17,837 mod_sql/4.3[5935]: exiting 	odbc cmd_exit

Logs with postgres:
2015-09-02 14:23:46,695 mod_sql/4.3[6466]: using SQLBackend 'postgres'
2015-09-02 14:23:46,695 mod_sql/4.3[6466]: backend module 'mod_sql_postgres/4.0.4'
2015-09-02 14:23:46,696 mod_sql/4.3[6466]: backend api    'mod_sql_api_v1'
2015-09-02 14:23:46,696 mod_sql/4.3[6466]: >>> sql_sess_init
2015-09-02 14:23:46,696 mod_sql/4.3[6466]: warning: no homedir field and no default specified. User authentication is OFF
2015-09-02 14:23:46,696 mod_sql/4.3[6466]: entering 	postgres cmd_defineconnection
2015-09-02 14:23:46,696 mod_sql/4.3[6466]:  name: 'default'
2015-09-02 14:23:46,696 mod_sql/4.3[6466]:  user: 'authenticator'
2015-09-02 14:23:46,696 mod_sql/4.3[6466]:  host: 'localhost'
2015-09-02 14:23:46,696 mod_sql/4.3[6466]:    db: 'MarynaOnLine2'
2015-09-02 14:23:46,696 mod_sql/4.3[6466]:  port: '5432'
2015-09-02 14:23:46,696 mod_sql/4.3[6466]:   ttl: '0'
2015-09-02 14:23:46,696 mod_sql/4.3[6466]: exiting 	postgres cmd_defineconnection
2015-09-02 14:23:46,696 mod_sql/4.3[6466]: connection 'default' successfully established
2015-09-02 14:23:46,696 mod_sql/4.3[6466]: mod_sql engine     : on
2015-09-02 14:23:46,696 mod_sql/4.3[6466]: negative_cache     : off
2015-09-02 14:23:46,696 mod_sql/4.3[6466]: authenticate       : groups 
2015-09-02 14:23:46,696 mod_sql/4.3[6466]: group table        : Auth.FTPGroup
2015-09-02 14:23:46,696 mod_sql/4.3[6466]: groupname field    : groupName
2015-09-02 14:23:46,696 mod_sql/4.3[6466]: grp GID field      : groupId
2015-09-02 14:23:46,696 mod_sql/4.3[6466]: grp members field  : login
2015-09-02 14:23:46,696 mod_sql/4.3[6466]: SQLDefaultUID      : 65533
2015-09-02 14:23:46,696 mod_sql/4.3[6466]: SQLDefaultGID      : 65533
2015-09-02 14:23:46,696 mod_sql/4.3[6466]: <<< sql_sess_init
2015-09-02 14:23:46,698 mod_sql/4.3[6466]: >>> sql_pre_pass
2015-09-02 14:23:46,698 mod_sql/4.3[6466]: <<< sql_pre_pass
2015-09-02 14:23:46,700 mod_sql/4.3[6466]: entering 	postgres cmd_exit
2015-09-02 14:23:46,700 mod_sql/4.3[6466]: exiting 	postgres cmd_exit

-- System Information:
Debian Release: 8.1
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 3.16.0-4-amd64 (SMP w/2 CPU cores)
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages proftpd-basic depends on:
ii  adduser            3.113+nmu3
ii  debconf            1.5.56
ii  debianutils        4.4+b1
ii  libacl1            2.2.52-2
ii  libc6              2.19-18
ii  libcap2            1:2.24-8
ii  libmemcached11     1.0.18-4
ii  libmemcachedutil2  1.0.18-4
ii  libncurses5        5.9+20140913-1+b1
ii  libpam-runtime     1.1.8-3.1
ii  libpam0g           1.1.8-3.1
ii  libpcre3           2:8.35-3.3
ii  libssl1.0.0        1.0.1k-3+deb8u1
ii  libtinfo5          5.9+20140913-1+b1
ii  libwrap0           7.6.q-25
ii  netbase            5.3
ii  sed                4.2.2-4+b1
ii  ucf                3.0030
ii  zlib1g             1:1.2.8.dfsg-2+b1

proftpd-basic recommends no packages.

Versions of packages proftpd-basic suggests:
pn  openbsd-inetd | inet-superserver  <none>
ii  openssl                           1.0.1k-3+deb8u1
pn  proftpd-doc                       <none>
pn  proftpd-mod-geoip                 <none>
pn  proftpd-mod-ldap                  <none>
pn  proftpd-mod-mysql                 <none>
ii  proftpd-mod-odbc                  1.3.5-1.1+deb8u1
ii  proftpd-mod-pgsql                 1.3.5-1.1+deb8u1
pn  proftpd-mod-sqlite                <none>

-- debconf information:
* shared/proftpd/inetd_or_standalone: standalone