Affected versions: FreeBSD 13

📖 ~4 min read  •  Source: FreeBSD VuXML

VuXML topic: postnuke — admin section SQL injection

Related CVEs: CVE-2005-0615 CVE-2005-0616 CVE-2005-0617 CVE-2005-1621 CVE-2005-1695 CVE-2005-1696 CVE-2005-1698 CVE-2005-1777  +3 more

Upstream summary: ISS X-Force reports: PostNuke is vulnerable to SQL injection. A remote attacker could send specially-crafted SQL statements to the admin section using the hits parameter, which could allow the attacker to view, add, modify or delete information in the back-end database.

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

Exploitation of postnuke is user-driven: the danger arrives when someone opens a hostile page, message or attachment, so exposure sits on each FreeBSD 13 workstation rather than on any serving path. Desktop sessions run for weeks, and the package manager only replaces files on disk — a postnuke process started before the update keeps the old code mapped until the user quits and relaunches it. Consequences are local: theft of saved credentials and session cookies, access to the user’s profile data under $HOME, and code execution as the logged-in account. postnuke is a graphical application launched by a user from their desktop session, not a system service: there is no service to restart, and service(8) or /var/log/messages will report nothing for it.

Environment & Reproduction

Reproduction targets FreeBSD 13. Confirm release, installed package, and capture baseline state:

freebsd-version -kru
uname -a
pkg info postnuke
pkg query "%n-%v" postnuke
pkg audit -F
service -e

Exercise the workload that uses postnuke while collecting:

tail -200 /var/log/messages
dmesg -a | tail -200
tail -200 /var/log/pkg.log

Root Cause Analysis

Root cause is tracked at FreeBSD VuXML. The FreeBSD ports security team shipped a corrective postnuke port revision; hosts on an outdated build remain exposed. Correlate package logs with system logs and kernel state to isolate the change that triggered the failure mode:

tail -500 /var/log/pkg.log
tail -500 /var/log/messages
sysctl kern.lastpid
sysctl kern.osreldate     # numeric __FreeBSD_version, e.g. 1400097

Quick Triage

Run these checks on FreeBSD 13 to confirm the failure mode and current state of postnuke:

pkg version -v postnuke                # installed vs available version
pkg audit postnuke                     # advisory match for this package
tail -100 /var/log/messages
dmesg -a | tail -100
kldstat                              # kernel module state (for kernel/driver pkgs)
pfctl -sr 2>/dev/null || ipfw list   # only if pf/ipfw is enabled
# e.g. bind918→named, php83→php-fpm), check it:
pkg query '%Fp' postnuke | sed -n 's|.*/etc/rc\.d/||p'  # FreeBSD: the REAL service name(s) = basename of the rc.d script (bind918 -> named, postgresql16-server -> postgresql, apache24 -> apache24)
pkg query '%b' postnuke  # FreeBSD: shared libraries PROVIDED by postnuke. Non-empty here + no rc.d script = it is a library: patch it, then restart its consumers

Step-by-Step Diagnosis

  1. List enabled services (only relevant if the package provides one).

    service -e
  2. Follow live logs.

    tail -F /var/log/messages
    dmesg
  3. Validate firewall rules (skip if neither pf nor ipfw is enabled).

    pfctl -sr -v 2>/dev/null || ipfw show
  4. Check package integrity for postnuke.

    pkg check -B postnuke
    pkg check -d postnuke    # verify shared-library deps
  5. Reinstall postnuke if integrity check fails.

    pkg install -fy postnuke
  6. Correlate findings with /var/log/pkg.log and FreeBSD VuXML to pin the commit that introduced the regression.

Solution – Primary Fix

Install the corrective postnuke port revision referenced by FreeBSD VuXML:

sudo pkg update
sudo pkg upgrade postnuke              # or: sudo pkg upgrade -y for the whole system
pkg audit postnuke                    # confirm no remaining advisory for this package

For ports-tree builders (FreeBSD 13.x and earlier used portsnap; on FreeBSD 14+ the ports tree is fetched with Git):

# FreeBSD 14+ (portsnap was removed):
sudo pkg install -y git-lite
sudo git clone --depth 1 https://git.FreeBSD.org/ports.git /usr/ports
# FreeBSD 13.x and earlier:
# sudo portsnap fetch update
cd /usr/ports/<category>/postnuke
sudo make deinstall reinstall clean

Reboot only if the package ships a kernel module or replaces a shared library used by long-running daemons.

Need help rolling this patch across a FreeBSD fleet? Our IT Solutions & Services team manages FreeBSD jail/bhyve patch windows. Get in touch for a free consultation.

Solution – Alternative Approaches

If the primary fix is not viable, choose from these alternatives:

  • Lock the package until the fix is vetted:

    sudo pkg lock postnuke
  • Downgrade to a known-good revision. pkg install pkgname-VERSION is not a real downgrade syntax — fetch a specific build instead:

    # 1. Discover available versions across configured repos:
    pkg search -e postnuke
    pkg rquery -r FreeBSD-quarterly '%n-%v' postnuke
    # 2. Install from a specific saved .pkg file:
    sudo pkg add -f /path/to/postnuke-<older-version>.pkg
    # 3. Or switch the host repo to the quarterly branch (see snippet below) and:
    sudo pkg upgrade -fr FreeBSD-quarterly postnuke
  • Switch the pkg repository between quarterly and latest by editing /usr/local/etc/pkg/repos/FreeBSD.conf:

    FreeBSD: {
      url: "pkg+https://pkg.FreeBSD.org/${ABI}/quarterly",
      mirror_type: "srv",
      signature_type: "fingerprints",
      fingerprints: "/usr/share/keys/pkg",
      enabled: yes
    }
  • Isolate the affected service in a jail with stricter firewall rules:

    iocage create -n postnuke-jail -r 13.4-RELEASE
    iocage set allow_raw_sockets=0 postnuke-jail
    # or with Bastille:
    bastille create postnuke-jail 13.4-RELEASE 10.0.0.10
  • Replace the service with a vendored static build for the period between exposure detection and full rollout.

Verification & Acceptance Criteria

All of these should pass after the fix:

pkg info postnuke                # shows the expected fixed version
pkg audit postnuke               # no advisory for this package (exit code 0)
tail -50 /var/log/messages   # no new errors after upgrade
# If postnuke ships a service, confirm it is running under its rc.d name:

The conditions described in the advisory must no longer be reported for postnuke across two consecutive runs.

Rollback Plan

Capture state before any change (only ZFS root has boot environments — UFS hosts skip bectl):

pkg query "%n-%v" > /root/pkg-pre.txt
# ZFS-on-root only:
sudo bectl create pre-postnuke-patch

To revert if the upgrade is bad, reinstall the previously saved .pkg file:

sudo pkg add -f /var/cache/pkg/postnuke-<previous-version>.pkg
# Or activate the pre-patch boot environment and reboot (ZFS-on-root only):
sudo bectl activate pre-postnuke-patch
sudo shutdown -r now

For kernel/loader changes on a UFS host, boot the previous kernel from the loader prompt (press 3 at the menu, then boot kernel.old).

Prevention & Hardening

Prevent recurrence on FreeBSD 13 hosts running postnuke:

  • Enable the daily security pkg audit in /etc/periodic.conf:

    daily_status_security_pkgaudit_enable="YES"
  • Subscribe to freebsd-security-notifications at lists.freebsd.org.

  • Mirror through a local pkg repository managed by poudriere:

    poudriere jail -c -j 13amd64 -v 13.4-RELEASE
    poudriere ports -c -p default
    poudriere bulk -j 13amd64 -p default <category>/postnuke
  • Version-pin sensitive packages:

    sudo pkg lock postnuke
  • Take an automatic ZFS boot-environment snapshot before every upgrade (ZFS root only):

    sudo bectl create pre-upgrade-$(date +%Y%m%d)
  • Monitor file integrity (create a baseline, verify against it later):

    # Create a baseline (use -c; target /usr/local/etc, /etc, /boot — NOT /):
    sudo mtree -c -K sha256digest -p /usr/local/etc > /var/db/usr-local-etc.mtree
    sudo mtree -c -K sha256digest -p /etc          > /var/db/etc.mtree
    # Verify later:
    sudo mtree -p /usr/local/etc < /var/db/usr-local-etc.mtree
    # Or with AIDE for a richer ruleset:
    sudo pkg install -y aide && sudo aide --init && sudo aide --check
  • Harden jails with allow.* tunables in /etc/jail.conf:

    postnuke_jail {
      allow.raw_sockets = 0;
      allow.sysvipc    = 0;
      allow.mount      = 0;
      allow.chflags    = 0;
    }

Issues that commonly surface alongside a postnuke update: pkg lock contention, mismatched ABI after kernel/userland skew, pf rule drift, and stale shared-library references after upgrade. Triage with:

freebsd-version -kru
uname -K
pkg check -d
pfctl -sr

View all freebsd-13 tutorials on the Tutorials Hub →

Browse all common problems & solutions on the Tutorials Hub.

References & Further Reading

Primary reference: FreeBSD VuXML. Useful manual pages on FreeBSD 13:

man pkg
man freebsd-update
man pfctl
man ipfw
man bectl
man periodic.conf

Other resources: the FreeBSD Handbook, the FreeBSD Security Advisories at security.freebsd.org, and the /usr/ports/UPDATING file for port-specific notes implicated in this advisory.