Debian 12 — pgpool2 — multiple vulnerabilities (3 CVEs) — patch and remediation guide

📖 ~4 min read  •  Source: Debian Security Tracker

Related CVEs: CVE-2023-22332 CVE-2024-45624 CVE-2025-46801

Upstream summary: Information disclosure vulnerability exists in Pgpool-II 4.4.0 to 4.4.1 (4.4 series), 4.3.0 to 4.3.4 (4.3 series), 4.2.0 to 4.2.11 (4.2 series), 4.1.0 to 4.1.14 (4.1 series), 4.0.0 to 4.0.21 (4.0 series), All versions of 3.7 series, All versions of 3.6 series, All versions of 3.5 series, All versions of 3.4 series, and All versions of 3.3 series. A specific database user's authentication information may be obtained by another database user. As a result, the information stored

Table of contents

1. Symptom & Impact
2. Environment & Reproduction
3. Root Cause Analysis
4. Quick Triage
5. Step-by-Step Diagnosis
6. Solution – Primary Fix
7. Solution – Alternative Approaches
8. Verification & Acceptance Criteria
9. Rollback Plan
10. Prevention & Hardening
11. Related Errors & Cross-Refs
12. References & Further Reading

Symptom & Impact

On Debian 12 (bookworm) hosts that have pgpool2 installed, administrators observe behaviour consistent with Debian Security Tracker: apt reports pending security updates, services backed by pgpool2 fail or restart unexpectedly, and — for security-rated advisories — the host is exposed to the vulnerability set above. Impact ranges from a single service-restart loop to wider availability incidents whenever pgpool2 sits on the serving path.

Environment & Reproduction

Reproduction targets Debian 12 (bookworm). Confirm release and installed package:

cat /etc/debian_version
lsb_release -a 2>/dev/null || cat /etc/os-release
dpkg -l pgpool2 | tail -2
apt-cache policy pgpool2
dpkg-query -W -f='${Status}\n' pgpool2

Trigger the workflow that exposes pgpool2 — multiple vulnerabilities (3 CVEs) — patch and remediation guide while collecting:

sudo journalctl -u pgpool2 -b --no-pager | tail -200
sudo journalctl -xe --no-pager | tail -200
sudo tail -200 /var/log/apt/history.log
sudo tail -200 /var/log/dpkg.log

Root Cause Analysis

Root cause is tracked at Debian Security Tracker. The Debian Security Team shipped fixes in the corresponding pgpool2 point release for Debian 12 (suite bookworm-security); running an outdated build leaves the host exposed to the failure modes referenced above. Correlate apt history with the journal:

grep -A2 -B2 pgpool2 /var/log/apt/history.log
zgrep -A2 -B2 pgpool2 /var/log/apt/history.log.*.gz 2>/dev/null
cat /proc/sys/kernel/tainted   # non-zero = tainted kernel / out-of-tree modules

Quick Triage

Run these on Debian 12 to capture the current state of pgpool2:

dpkg -l pgpool2 | tail -1                   # installed version
dpkg -V pgpool2                              # verify shipped files
sudo apt update && apt list --upgradable 2>/dev/null | grep -i security
systemctl --failed --no-pager
sudo nft list ruleset 2>/dev/null | head -50
sudo aa-status 2>/dev/null | head -20      # AppArmor profiles
# If pgpool2 ships a systemd unit (unit name may differ from pkg, e.g. bind9→named,
# postgresql-NN→postgresql@NN-main, php-fpm→php<ver>-fpm):
systemctl list-unit-files | grep -i pgpool2 | head

Step-by-Step Diagnosis

1. List failed systemd units.

   systemctl --failed --no-pager

2. Tail the journal for pgpool2 and the system bus.

   sudo journalctl -u pgpool2 -f --no-pager
   sudo journalctl -xe -f --no-pager

3. Inspect firewall state (this OS defaults to nftables).

   sudo nft list ruleset
   sudo nft list tables

4. Verify pgpool2 file integrity and reinstall if anything is altered.

   sudo dpkg -V pgpool2
   sudo debsums -c pgpool2 2>/dev/null
   sudo apt install --reinstall -y pgpool2

5. Check AppArmor denials (Debian 11+ default-enabled).

   sudo journalctl -k | grep -i 'apparmor="DENIED"' | tail -30
   sudo aa-status | grep -i pgpool2

6. Correlate findings with /var/log/apt/history.log, /var/log/dpkg.log, and Debian Security Tracker to pin the change that introduced pgpool2 — multiple vulnerabilities (3 CVEs) — patch and remediation guide.

Solution – Primary Fix

Apply the corrective apt transaction documented in Debian Security Tracker from the security suite, then reload the affected unit:

sudo apt update
sudo apt -y install --only-upgrade pgpool2
sudo systemctl daemon-reload
# Unit name may differ from package name; check first:
systemctl list-unit-files | grep -i pgpool2 | head
sudo systemctl restart pgpool2
dpkg -l pgpool2 | tail -1                # confirm new version
systemctl is-active pgpool2 2>/dev/null  # confirm running (if a unit exists)

For kernel / glibc / systemd / openssl advisories a reboot is required:

sudo apt install -y needrestart
sudo needrestart -r l       # list services that need restart
sudo systemctl reboot       # or: sudo shutdown -r now

Solution – Alternative Approaches

If the primary upgrade is not viable, pick from these:

• Pin a known-good version via apt preferences:

  # /etc/apt/preferences.d/pgpool2.pref
  Package: pgpool2
  Pin: version <good-version>
  Pin-Priority: 1001

• Mark the package on hold so apt cannot upgrade it:

  sudo apt-mark hold pgpool2
  apt-mark showhold | grep pgpool2
  # Release the hold later with:
  sudo apt-mark unhold pgpool2

• Downgrade to an older NVR if a regression is suspected:

  apt-cache madison pgpool2
  sudo apt install --allow-downgrades -y pgpool2=<older-version>

• Switch firewall backend between iptables-legacy and nftables (Debian 10+):

  sudo update-alternatives --config iptables
  sudo update-alternatives --config ip6tables
  sudo systemctl restart netfilter-persistent 2>/dev/null

• Take only the security archive update and defer the full point-release upgrade:

  # /etc/apt/sources.list.d/bookworm-security-only.list
  deb http://security.debian.org/debian-security bookworm-security main contrib non-free
  # then:
  sudo apt update && sudo apt -y install --only-upgrade -t bookworm-security pgpool2

• Investigate AppArmor blocking the new binary; switch the profile to complain mode briefly:

  sudo aa-complain /etc/apparmor.d/usr.sbin.pgpool2 2>/dev/null
  # reproduce, capture denials, then re-enforce:
  sudo aa-enforce /etc/apparmor.d/usr.sbin.pgpool2 2>/dev/null

Verification & Acceptance Criteria

All of these should pass after the fix is applied:

dpkg -l pgpool2 | tail -1                                  # expected fixed version
apt list --upgradable 2>/dev/null | grep -i security || echo OK
systemctl is-active pgpool2 2>/dev/null                    # active (if a unit exists)
sudo journalctl -u pgpool2 --since "5 minutes ago" --no-pager   # no new errors
sudo nft list ruleset | head
sudo aa-status 2>/dev/null | head -5

The original reproduction for pgpool2 — multiple vulnerabilities (3 CVEs) — patch and remediation guide must not trigger across two consecutive runs.

Rollback Plan

Capture state before any change:

apt list --installed 2>/dev/null > /root/apt-pre.txt
dpkg --get-selections > /root/dpkg-pre.txt
# LVM snapshot of the root LV (only if root sits on LVM):
sudo lvcreate -L 4G -s -n root_pre_patch /dev/<vg>/<root-lv>

To revert:

sudo apt install --allow-downgrades -y pgpool2=<old-version>
sudo systemctl daemon-reload
sudo systemctl restart pgpool2
# If a kernel was rolled back, reboot and select the previous kernel from GRUB:
sudo systemctl reboot
# LVM snapshot merge (offline / on next reboot):
sudo lvconvert --merge /dev/<vg>/root_pre_patch

Prevention & Hardening

Reduce the chance of this recurring on Debian 12:

• Enable scheduled security updates via unattended-upgrades:

  sudo apt install -y unattended-upgrades apt-listchanges
  sudo dpkg-reconfigure -plow unattended-upgrades
  # /etc/apt/apt.conf.d/50unattended-upgrades:
  Unattended-Upgrade::Origins-Pattern { "origin=Debian,codename=${distro_codename},label=Debian-Security"; };

• Install needrestart so services restart automatically after library upgrades:

  sudo apt install -y needrestart
  # /etc/needrestart/needrestart.conf -> $nrconf{restart} = 'a';

• Subscribe to debian-security-announce and watch security-tracker.debian.org.

• Mirror locally for controlled rollouts:

  sudo apt install -y apt-mirror
  # /etc/apt/mirror.list:
  deb http://deb.debian.org/debian bookworm main contrib non-free
  deb http://security.debian.org/debian-security bookworm-security main contrib non-free
  sudo apt-mirror

• Monitor file integrity with debsums and AIDE:

  sudo apt install -y debsums aide
  sudo debsums -ca           # report only changed conffile-less files
  sudo aideinit && sudo mv /var/lib/aide/aide.db.new /var/lib/aide/aide.db
  sudo aide --check

• Apply CIS Debian Linux Benchmark hardening and review auditd rules in /etc/audit/rules.d/.

Related Errors & Cross-Refs

Issues that commonly surface alongside pgpool2 — multiple vulnerabilities (3 CVEs) — patch and remediation guide: apt lock contention, broken dpkg state, systemd ordering cycles, AppArmor denials, and firewall rule drift. Useful triage:

sudo dpkg --configure -a
sudo apt --fix-broken install
systemd-analyze critical-chain
sudo journalctl -k | grep -i apparmor | tail
cat /proc/sys/kernel/tainted

View all debian-12 tutorials on the Tutorials Hub →

Browse all common problems & solutions on the Tutorials Hub.

References & Further Reading

Primary reference: Debian Security Tracker. Manual pages useful on Debian 12:

man apt
man apt-get
man apt-mark
man dpkg
man systemctl
man journalctl
man nft
man apparmor
man unattended-upgrades

Other resources: The Debian Administrator’s Handbook, Debian Security FAQ, Debian Security Tracker, and per-package notes in /usr/share/doc/pgpool2/ for components implicated in pgpool2 — multiple vulnerabilities (3 CVEs) — patch and remediation guide.