Your message dated Sat, 20 Jul 2019 11:05:42 +0200
with message-id <[email protected]>
and subject line Re: Bug#797773: proftpd-basic: Problem with mod_sql (no
queries sent)
has caused the Debian Bug report #797773,
regarding proftpd-basic: Problem with mod_sql (no queries sent)
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
797773: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=797773
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
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
--- End Message ---
--- Begin Message ---
On 07.03.18 08:46, Hilmar Preuße wrote:
> On 02.09.2015 14:51, Michal Rydlikowski wrote:
>> 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)
>>
> Between 1.3.5 and 1.3.5d a few bugs in this area where fixed. Do you
> have the chance to test w/ Debian unstable or to compile the 1.3.5.d
> package on stable to test if the problem is solved?
>
> Moreover 1.3.6 was uploaded for testing.
>
No reaction from submitter for > two years and bug eventually solved.
Closing.
H.
--
sigfault
#206401 http://counter.li.org
signature.asc
Description: OpenPGP digital signature
--- End Message ---
