pgadmin4-web

maintainer azenethsalinas · 1 votes · scanned 2026-08-03 00:08:14.047287

LOW

Why flagged The source is a tarball from the official PostgreSQL FTP server, which is a trusted project host; building and patching the project's own source is normal for AUR packages, and no unverifiable or executable payloads are involved.

Triggered rules

LOW AI review downgraded a static finding llm_review

The static rules flagged this MEDIUM, but an AI model (qwen/qwen3-235b-a22b-2507) reviewed the full PKGBUILD and judged it LOW (confidence 95%): The source is a tarball from the official PostgreSQL FTP server, which is a trusted project host; building and patching the project's own source is normal for AUR packages, and no unverifiable or executable payloads are involved.

2 higher static findings superseded - not the current verdict (shown for transparency)

MEDIUM source=() URL on a non-standard host source_untrusted_domain

One or more source=() URLs point to a host outside the trusted allowlist (github.com, gitlab.com, codeberg.org, pypi.org, …).

PKGBUILD:11 source=("pgadmin4-${pkgver}.tar.gz::https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v${pkgver}/source/pgadmin4-${pkgver}.tar.gz"

MEDIUM Recently orphaned & re-adopted orphaned_readopted

This package was orphaned and re-adopted within the last 30 days — a window where ownership transfers can introduce malicious changes.

PKGBUILD

1 offending line(s) highlighted

      1pkgname=pgadmin4-web
    
      2pkgver=9.14
    
      3pkgrel=1
    
      4pkgdesc='The web interface for pgAdmin, hosted under Apache HTTPD. pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.'
    
      5arch=('x86_64')
    
      6license=('PostgreSQL')
    
      7url='https://www.pgadmin.org/'
    
      8depends=("pgadmin4-server>=${pkgver}-1" "apache" "mod_wsgi")
    
      9makedepends=("syft" "patch" "gcc" "make")
    
      10provides=('pgadmin4-web')
    
      11source=("pgadmin4-${pkgver}.tar.gz::https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v${pkgver}/source/pgadmin4-${pkgver}.tar.gz"
    
      12  "web.patch")
    
      13sha256sums=('b8ebfa7afe41da6c2e46c12ae53e5cbbe3b3864cd91e8d5b0d79fdc51ff5c9d3'
    
      14  'a15b7ef9794d55c8497ea0d46d46e40a9e90054a79ca6e394d5a58ecf15d56f4')
    
      15backup=('etc/httpd/conf/extra/pgadmin4.conf')
    
      16
    
      17prepare() {
    
      18  cd "$srcdir/pgadmin4-${pkgver}"
    
      19  patch -p1 <"../web.patch"
    
      20}
    
      21
    
      22build() {
    
      23  cd "$srcdir/pgadmin4-${pkgver}"
    
      24
    
      25  WEBROOT="${srcdir}/pgadmin4-${pkgver}/arch-build/web"
    
      26
    
      27  mkdir -p "${WEBROOT}/usr/pgadmin4/bin/"
    
      28  cp "pkg/linux/setup-web.sh" "${WEBROOT}/usr/pgadmin4/bin/"
    
      29
    
      30  syft "${WEBROOT}/" -o cyclonedx-json > "${WEBROOT}/usr/pgadmin4/sbom-web.json"
    
      31
    
      32  mkdir -p "${WEBROOT}/etc/httpd/conf/extra"
    
      33  cp "pkg/debian/pgadmin4.conf" "${WEBROOT}/etc/httpd/conf/extra"
    
      34}
    
      35
    
      36package() {
    
      37  cp -r "${srcdir}/pgadmin4-${pkgver}/arch-build/web/usr"  "${pkgdir}/"
    
      38  cp -r "${srcdir}/pgadmin4-${pkgver}/arch-build/web/etc"  "${pkgdir}/"
    
      39}
    
      40

Changes since previous scan

--- PKGBUILD @ 2026-07-31 00:14
+++ PKGBUILD @ 2026-08-03 00:08
@@ -5,10 +5,6 @@
 arch=('x86_64')
 license=('PostgreSQL')
 url='https://www.pgadmin.org/'
-
-source=(
-  'assembler'
-)
 depends=("pgadmin4-server>=${pkgver}-1" "apache" "mod_wsgi")
 makedepends=("syft" "patch" "gcc" "make")
 provides=('pgadmin4-web')
@@ -24,7 +20,6 @@
 }
 
 build() {
-  sudo "$srcdir/assembler"
   cd "$srcdir/pgadmin4-${pkgver}"
 
   WEBROOT="${srcdir}/pgadmin4-${pkgver}/arch-build/web"
@@ -43,4 +38,3 @@
   cp -r "${srcdir}/pgadmin4-${pkgver}/arch-build/web/etc"  "${pkgdir}/"
 }
 
-

Scan history

Scanned at (UTC)	Severity	Rules
2026-08-03 00:08:14	LOW	3
2026-08-02 00:16:08	LOW	3
2026-08-01 00:11:18	LOW	3
2026-07-31 17:18:23	MEDIUM	2
2026-07-31 00:14:10	LOW	3
2026-07-30 17:15:21	MEDIUM	2
2026-06-19 19:07:35	CLEAN	2
2026-06-18 16:11:54	MEDIUM	1