sql-power-architect

maintainer mrxx · 2 votes · scanned 2026-08-03 00:08:14.047287

MEDIUM

Why flagged The binary archive is downloaded from a CDN URL (secureserver.net, which is GoDaddy's hosting infrastructure used by the bestofbi.com site) rather than a canonical upstream release host like GitHub or SourceForge. SQL Power Architect is a real open-source tool, and bestofbi.com appears to be the legitimate vendor site. However, the download URL is a WordPress upload path on a GoDaddy CDN, not a versioned release artifact from a verifiable source like a GitHub releases page or the project's own dedicated download server. The sha256sums are present and pin the content, which mitigates silent substitution risk significantly. The package installs a prebuilt Java application (JARs + shell wrapper), not a native binary, so the attack surface is somewhat lower than a native executable. Overall this is a borderline case: the sha256 checksum provides meaningful protection, but the source host is informal/unofficial for a prebuilt archive. The risk is real but modest — medium is appropriate rather than clean, since the host is not a recognized upstream release channel and the content is executed code.

Triggered rules

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=("https://8hi8a2.p3cdn1.secureserver.net/wp-content/uploads/2022/10/SQL-Power-Architect-generic-${pkgver}.tar.zip"

MEDIUM AI review llm_review

An AI model (anthropic/claude-4.6-sonnet-20260217) reviewed this and agrees it is MEDIUM (confidence 72%): The binary archive is downloaded from a CDN URL (secureserver.net, which is GoDaddy's hosting infrastructure used by the bestofbi.com site) rather than a canonical upstream release host like GitHub or SourceForge. SQL Power Architect is a real open-source tool, and bestofbi.com appears to be the legitimate vendor site. However, the download URL is a WordPress upload path on a GoDaddy CDN, not a versioned release artifact from a verifiable source like a GitHub releases page or the project's own dedicated download server. The sha256sums are present and pin the content, which mitigates silent substitution risk significantly. The package installs a prebuilt Java application (JARs + shell wrapper), not a native binary, so the attack surface is somewhat lower than a native executable. Overall this is a borderline case: the sha256 checksum provides meaningful protection, but the source host is informal/unofficial for a prebuilt archive. The risk is real but modest — medium is appropriate rather than clean, since the host is not a recognized upstream release channel and the content is executed code.

PKGBUILD

1 offending line(s) highlighted

      1# Maintainer: mrxx <mrxx at cyberhome dot at>
    
      2
    
      3pkgname=sql-power-architect
    
      4pkgver=1.0.9
    
      5pkgrel=1
    
      6pkgdesc="Data Modeling & Profiling Tool"
    
      7arch=('any')
    
      8url="http://www.bestofbi.com/page/architect"
    
      9license=('GPL')
    
      10depends=('java-runtime-common' 'libxtst' 'bash' 'hicolor-icon-theme')
    
      11source=("https://8hi8a2.p3cdn1.secureserver.net/wp-content/uploads/2022/10/SQL-Power-Architect-generic-${pkgver}.tar.zip"
    
      12            "$pkgname"
    
      13            "$pkgname.desktop"
    
      14            "$pkgname.png")
    
      15sha256sums=('04db3bd65077d580d8ca9a402d58088cb6376dae3d7a255d74cf0a298cd7a377'
    
      16            '144ea33434ac1584a6517ea1f651f20b5bfce5b6d4f1d6085bb1447d44437c01'
    
      17            'cdb593688a10f1de8d8a4d3447d7df46dcbd8b03f783bf1ae49fc5c160c6a1be'
    
      18            '8589e056924b938efc00cf7f5cfb75285888cfb2f9af28e1be2f0c0500f8bf2e')
    
      19
    
      20package() {
    
      21  unzip SQL-Power-Architect-generic-${pkgver}.tar.zip
    
      22  tar xf SQL-Power-Architect-generic-${pkgver}.tar.gz
    
      23  install -d "$pkgdir/usr/bin"
    
      24  install -d "$pkgdir/usr/lib/$pkgname"
    
      25  install -d "$pkgdir/usr/share/icons/hicolor/64x64/apps"
    
      26  install -d "$pkgdir/usr/share/applications"
    
      27  install -m755 $pkgname "$pkgdir/usr/bin/"
    
      28  cp -r architect-$pkgver/* "$pkgdir/usr/lib/${pkgname}/"
    
      29  install -t "$pkgdir/usr/share/icons/hicolor/64x64/apps" ${pkgname}.png
    
      30  install -t "$pkgdir/usr/share/applications" ${pkgname}.desktop
    
      31}
    
      32

Scan history

Scanned at (UTC)	Severity	Rules
2026-08-03 00:08:14	MEDIUM	2
2026-08-02 00:16:08	MEDIUM	2
2026-08-01 00:11:18	MEDIUM	2
2026-07-31 00:14:10	MEDIUM	2
2026-07-30 00:17:23	MEDIUM	2
2026-07-29 00:25:53	MEDIUM	2
2026-07-28 00:07:28	MEDIUM	2
2026-07-27 00:24:32	MEDIUM	2
2026-07-26 00:07:32	MEDIUM	2
2026-07-25 00:13:44	MEDIUM	2
2026-07-24 00:02:28	MEDIUM	2
2026-07-23 00:14:47	MEDIUM	2
2026-07-22 00:29:32	MEDIUM	2
2026-07-21 00:24:15	MEDIUM	2
2026-07-20 00:19:49	MEDIUM	2
2026-07-19 00:17:08	MEDIUM	2
2026-07-18 00:14:48	MEDIUM	2
2026-07-17 00:06:16	MEDIUM	2
2026-07-16 00:05:41	MEDIUM	2
2026-07-15 00:09:25	MEDIUM	2