📖 ~4 min read • Source: Debian Security Tracker
Related CVEs: CVE-2016-8640
Upstream summary: A SQL injection vulnerability in pycsw all versions before 2.0.2, 1.10.5 and 1.8.6 that leads to read and extract of any data from any table in the pycsw database that the database user has access to. Also on PostgreSQL (at least) it is possible to perform updates/inserts/deletes and database modifications to any table the database user has access to.
Table of contents
Symptom & Impact
On Debian 13 hosts running pycsw, administrators observe behaviour consistent with the Debian Security Tracker entry: apt refusing to install or restart affected services, and — for security-rated advisories — exposure to the vulnerability set above. Impact ranges from a single service restart to wider availability incidents whenever pycsw sits on the serving path.
Environment & Reproduction
Reproduction targets Debian 13. Confirm release with cat /etc/debian_version and lsb_release -a, and the currently installed package with dpkg -l pycsw and apt-cache policy pycsw. Capture system state with sudo reportbug pycsw if you need to file upstream. Trigger the workflow that exposes pycsw — vulnerability — patch and remediation guide while collecting journalctl -b, /var/log/apt/history.log, and dpkg -l output.
Root Cause Analysis
Root cause is tracked at Debian Security Tracker. The Debian Security Team shipped fixes in the corresponding pycsw point release for Debian 13; running an outdated build leaves the host exposed to the failure modes referenced above. Correlate journalctl --since with apt history (/var/log/apt/history.log) and any kernel taint flags in /proc/sys/kernel/tainted to isolate the originating change.
Quick Triage
Quick triage: systemctl status pycsw, journalctl -u pycsw -n 200, sudo apt update && apt list --upgradable, sudo nft list ruleset (or sudo iptables -L), and sudo dpkg --audit. For kernel issues review journalctl -k --since "1 hour ago".
Step-by-Step Diagnosis
1) systemctl --failed. 2) journalctl -xe and journalctl -u pycsw. 3) Validate firewall: sudo nft list ruleset or sudo iptables -L -n -v. 4) dpkg -V pycsw for integrity. 5) sudo apt install --reinstall pycsw if files were tampered. 6) Correlate findings with /var/log/apt/history.log, /var/log/dpkg.log, and Debian Security Tracker to pin the change that introduced pycsw — vulnerability — patch and remediation guide.
Solution – Primary Fix
Primary fix: apply the corrective apt transaction documented in Debian Security Tracker, then reload the affected systemd unit. Typical commands: sudo apt update, sudo apt -y install --only-upgrade pycsw (or sudo unattended-upgrade -v), sudo systemctl daemon-reload, sudo systemctl restart pycsw, then dpkg -l pycsw to validate the new build is installed. For kernel advisories add sudo reboot.
Need help rolling this patch across a Debian fleet? Our IT Solutions & Services team manages Debian patch windows with zero-downtime change controls. Get in touch for a free consultation.
Solution – Alternative Approaches
Alternatives include pinning a known-good version via /etc/apt/preferences.d/pycsw.pref, holding the package with sudo apt-mark hold pycsw, rolling back with sudo apt install pycsw=<old-version>, switching firewall backends between iptables-legacy and nftables via update-alternatives --config iptables, or applying the patch from the security archive only — deb debian-13-security main contrib non-free — while delaying the full point-release upgrade.
Verification & Acceptance Criteria
Acceptance: dpkg -l pycsw shows the expected fixed version, systemctl is-active pycsw is active, journalctl -u pycsw --since "5 minutes ago" shows no errors, apt list --upgradable no longer lists the advisory, sudo nft list ruleset matches the intended policy, and the original reproduction steps for pycsw — vulnerability — patch and remediation guide no longer trigger the failure across two consecutive runs.
Rollback Plan
Capture state with apt list --installed > /root/apt-pre.txt and dpkg --get-selections > /root/dpkg-pre.txt. To revert, run sudo apt install --allow-downgrades pycsw=<old-version> and reload systemctl daemon-reload. Reboot if the kernel or initramfs changed and re-verify symptoms. Where LVM snapshots are in use, sudo lvconvert --merge /dev/<vg>/preupgrade is the fastest rollback path.
Prevention & Hardening
Prevent recurrence by enabling unattended-upgrades with Unattended-Upgrade::Origins-Pattern tuned to origin=Debian,codename=${distro_codename},label=Debian-Security, subscribing to debian-security-announce, mirroring through a local apt-mirror or aptly repo for controlled rollouts, version-locking sensitive packages, and monitoring file integrity with debsums -c or aide --check. Apply CIS Debian hardening and keep needrestart installed so service restarts happen automatically after library upgrades.
Related Errors & Cross-Refs
Related issues that commonly surface alongside pycsw — vulnerability — patch and remediation guide: apt lock contention (dpkg --configure -a), systemd unit ordering cycles, firewall rule drift, and kernel taint flags in cat /proc/sys/kernel/tainted. See sibling common-problem articles in this Debian 13 series for adjacent failure modes.
View all debian-13 tutorials on the Tutorials Hub →
Browse all common problems & solutions on the Tutorials Hub.
References & Further Reading
Primary reference: Debian Security Tracker. Supporting docs: Debian Administrators Handbook, man apt, man systemctl, man nft, man iptables, man journalctl, man debsums, the Debian Security Tracker at security-tracker.debian.org, and Debian Security FAQ at debian.org/security/faq. Review /usr/share/doc/pycsw/ for component-level notes implicated in pycsw — vulnerability — patch and remediation guide.
