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
