Package: pure-ftpd-postgresql Version: 1.0.43-3 Severity: important Dear Maintainer,
In stretch I had a working pure-ftpd system with postgresql-based authentication. Passwords were encrypted with crypt. After buster upgrade, authentication fails with no errors in the logs (logs only show authentication failure, even with double verbose flags). Downgrading pure-ftpd-common and pure-ftpd-postgresql to versions in stretch fixes the issue. Various facts: - Postgresql cluster was upgraded to v11 and reindexed. - Queries in postgresql.conf can be manually run on the database without issue. - Postgresql trace shows that all configured queries are successfully running and returning results. - Packages from stretch work fine even with the upgraded Postgresql - Changing the encryption type makes no difference ** contents of /etc/pure-ftpd/db/postgresql.conf: PGSQLServer localhost PGSQLPort 5432 PGSQLUser (redacted) PGSQLPassword (redacted) PGSQLDatabase (redacted) PGSQLCrypt crypt PGSQLGetPW SELECT "passwd" FROM users WHERE "userid"='\L' and not disabled PGSQLGetUID SELECT "uid" FROM users WHERE "userid"='\L' PGSQLGetGID SELECT "gid" FROM users WHERE "userid"='\L' PGSQLGetDir UPDATE users SET last_login=NOW() WHERE userid='\L' RETURNING "homedir"; ** End of /etc/pure-ftpd/db/postgresql.conf -- System Information: Debian Release: 10.0 APT prefers stable-debug APT policy: (500, 'stable-debug'), (500, 'stable'), (500, 'oldstable') Architecture: amd64 (x86_64) Kernel: Linux 4.19.0-5-amd64 (SMP w/2 CPU cores) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE=en_US.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Init: systemd (via /run/systemd/system) LSM: AppArmor: enabled Versions of packages pure-ftpd-postgresql depends on: ii libc6 2.28-10 ii libcap2 1:2.25-2 ii libpam0g 1.3.1-5 ii libpq5 11.4-1 ii libssl1.1 1.1.1c-1 ii lsb-base 10.2019051400 ii openbsd-inetd [inet-superserver] 0.20160825-4 ii pure-ftpd-common 1.0.43-3 ii zlib1g 1:1.2.11.dfsg-1 pure-ftpd-postgresql recommends no packages. pure-ftpd-postgresql suggests no packages. -- Configuration Files: /etc/pure-ftpd/db/postgresql.conf [Errno 13] Permission denied: '/etc/pure-ftpd/db/postgresql.conf' -- no debconf information
