Install failure on Bluefin

[remingtonc]

Uncertain if it's a system issue as Bluefin base OS is fairly minimal or a brew installation issue. brew is the userspace package manager essentially, so hoping to install sqitch via brew on Linux.

Full build log attached. Looks like a failure in building Stash.c missing a header.
build.log

Excerpt:

cc -c   -D_REENTRANT -D_GNU_SOURCE -fwrapv -fno-strict-aliasing -pipe -fstack-protector-strong -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2   -DVERSION=\"3.102\" -DXS_VERSION=\"3.102\" -fPIC "-I/home/linuxbrew/.linuxbrew/opt/perl/lib/perl5/5.42/x86_64-linux-thread-multi/CORE"   Stash.c
cp lib/Template/Plugin/Wrap.pm blib/lib/Template/Plugin/Wrap.pm
cp lib/Template/Plugin/Table.pm blib/lib/Template/Plugin/Table.pm
cp lib/Template/Tools/ttree.pod blib/lib/Template/Tools/ttree.pod
cp lib/Template/Tutorial.pod blib/lib/Template/Tutorial.pod
cp lib/Template/Plugin/String.pm blib/lib/Template/Plugin/String.pm
cp lib/Template/Plugin/Format.pm blib/lib/Template/Plugin/Format.pm
cp lib/Template/Plugin/View.pm blib/lib/Template/Plugin/View.pm
cp lib/Template/Stash/Context.pm blib/lib/Template/Stash/Context.pm
cp lib/Template/Plugin/Procedural.pm blib/lib/Template/Plugin/Procedural.pm
cp lib/Template/Stash/XS.pm blib/lib/Template/Stash/XS.pm
cp lib/Template/Tutorial/Web.pod blib/lib/Template/Tutorial/Web.pod
cp lib/Template/View.pm blib/lib/Template/View.pm
cp lib/Template/Plugin/Pod.pm blib/lib/Template/Plugin/Pod.pm
cp lib/Template/Plugin/HTML.pm blib/lib/Template/Plugin/HTML.pm
cp lib/Template/Tools.pod blib/lib/Template/Tools.pod
cp lib/Template/Toolkit.pm blib/lib/Template/Toolkit.pm
cp lib/Template/Tools/tpage.pod blib/lib/Template/Tools/tpage.pod
cp lib/Template/Plugin/Iterator.pm blib/lib/Template/Plugin/Iterator.pm
cp lib/Template/Plugin/Scalar.pm blib/lib/Template/Plugin/Scalar.pm
cp lib/Template/Provider.pm blib/lib/Template/Provider.pm
cp lib/Template/Plugin/Math.pm blib/lib/Template/Plugin/Math.pm
cp lib/Template/Service.pm blib/lib/Template/Service.pm
cp lib/Template/Plugin/Image.pm blib/lib/Template/Plugin/Image.pm
cp lib/Template/Plugin/URL.pm blib/lib/Template/Plugin/URL.pm
cp lib/Template/Stash.pm blib/lib/Template/Stash.pm
cp lib/Template/Test.pm blib/lib/Template/Test.pm
cp lib/Template/Plugins.pm blib/lib/Template/Plugins.pm
cp lib/Template/Tutorial/Datafile.pod blib/lib/Template/Tutorial/Datafile.pod
cp lib/Template/VMethods.pm blib/lib/Template/VMethods.pm
Stash.xs:35:10: fatal error: EXTERN.h: No such file or directory
   35 | #include "EXTERN.h"
      |          ^~~~~~~~~~
compilation terminated.
make[1]: *** [Makefile:320: Stash.o] Error 1

extern.h is present in linuxbrew:

❯ find /home/linuxbrew -name EXTERN.h
/home/linuxbrew/.linuxbrew/Cellar/perl/5.42.0/lib/perl5/5.42/x86_64-linux-thread-multi/CORE/EXTERN.h
/home/linuxbrew/.linuxbrew/lib/perl5/5.42/x86_64-linux-thread-multi/CORE/EXTERN.h

Maybe a mismatch in -fPIC "-I/home/linuxbrew/.linuxbrew/opt/perl/lib/perl5/5.42/x86_64-linux-thread-multi/CORE" path?

cc -c   -D_REENTRANT -D_GNU_SOURCE -fwrapv -fno-strict-aliasing -pipe -fstack-protector-strong -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2   -DVERSION=\"3.102\" -DXS_VERSION=\"3.102\" -fPIC "-I/home/linuxbrew/.linuxbrew/opt/perl/lib/perl5/5.42/x86_64-linux-thread-multi/CORE"   Stash.c

Brief Failure Output

❯ brew install sqitch --with-postgres-support --with-sqlite-support
==> Fetching downloads for: sqitch
✔︎ Formula sqitch (1.6.1)                                                                                                                                                                        Verified    686.5KB/686.5KB
==> Installing sqitch from sqitchers/sqitch
==> cpm install --local-lib-contained instutil --no-test Menlo::CLI::Compat Module::Build
==> perl Build.PL --install_base /home/linuxbrew/.linuxbrew/Cellar/sqitch/1.6.1 --etcdir /home/linuxbrew/.linuxbrew/etc/sqitch --with postgres --with sqlite
==> ./Build bundle
Last 15 lines from /var/home/remington/.cache/Homebrew/Logs/sqitch/03.Build.log:
--> Working on Template
Fetching http://www.cpan.org/authors/id/T/TO/TODDR/Template-Toolkit-3.102.tar.gz ... OK
Configuring Template-Toolkit-3.102 ... OK
==> Found dependencies: AppConfig
--> Working on AppConfig
Fetching http://www.cpan.org/authors/id/N/NE/NEILB/AppConfig-1.71.tar.gz ... OK
Configuring AppConfig-1.71 ... OK
Building AppConfig-1.71 ... OK
Successfully installed AppConfig-1.71
Building Template-Toolkit-3.102 ... ! Installing Template failed. See /var/tmp/sqitch-20260305-106388-pfokfj/App-Sqitch-v1.6.1/.brew_home/.cpanm/work/1772757185.109157/build.log for details. Retry with --force to force install it.
! Installing the dependencies failed: Module 'PerlIO::utf8_strict' is not installed, Module 'Locale::Messages' is not installed, Module 'DBD::Pg' is not installed, Module 'namespace::autoclean' is not installed, Module 'DBD::SQLite' is not installed, Module 'Clone' is not installed, Module 'DBI' is not installed, Module 'Locale::TextDomain' is not installed, Module 'Sub::Exporter' is not installed, Module 'List::MoreUtils' is not installed, Module 'DateTime' is not installed, Module 'DateTime::TimeZone' is not installed, Module 'Sub::Exporter::Util' is not installed, Module 'IO::Pager' is not installed, Module 'String::Formatter' is not installed
! Bailing out the installation for App-Sqitch-v1.6.1.
Error installing modules: 
FAIL
52 distributions installed

If reporting this issue please do so at (not Homebrew/* repositories):
  https://github.com/sqitchers/homebrew-sqitch/issues

These open issues may also help:
brew install sqitch --with-postgres-support error   macos/14.4.1/M2 https://github.com/sqitchers/homebrew-sqitch/issues/64

brew config

❯ brew config
HOMEBREW_VERSION: 5.0.16
ORIGIN: https://github.com/Homebrew/brew
HEAD: a0bd077aafa7dcdf3562fa39afd0eb70f36af08c
Last commit: 4 days ago
Branch: stable
Core tap JSON: 06 Mar 00:29 UTC
HOMEBREW_PREFIX: /home/linuxbrew/.linuxbrew
HOMEBREW_CASK_OPTS: []
HOMEBREW_DISPLAY: :0
HOMEBREW_DOWNLOAD_CONCURRENCY: 24
HOMEBREW_EDITOR: /usr/bin/nano
HOMEBREW_FORBID_PACKAGES_FROM_PATHS: set
HOMEBREW_MAKE_JOBS: 12
Homebrew Ruby: 3.4.8 => /var/home/linuxbrew/.linuxbrew/Homebrew/Library/Homebrew/vendor/portable-ruby/3.4.8/bin/ruby
CPU: dodeca-core 64-bit zen3
Clang: N/A
Git: 2.53.0 => /bin/git
Curl: 8.15.0 => /bin/curl
Kernel: Linux 6.18.7-200.fc43.x86_64 x86_64 GNU/Linux
OS: Bluefin (Version: 43.20260303) (Deinonychus)
Host glibc: 2.42
Host libstdc++: 6.0.34
/usr/bin/gcc: 15.2.1
/usr/bin/ruby: N/A
glibc: N/A
gcc@12: N/A
gcc: N/A
xorg: N/A

[remingtonc]

Ah I see now this is addressed for MacOS in...

homebrew-sqitch/README.md

Lines 21 to 27 in ce66431

	If you see an error about missing headers on Mojave, like
	`fatal error: 'EXTERN.h' file not found`, install the headers like so and try
	again:
	``` sh
	sudo installer -pkg /Library/Developer/CommandLineTools/Packages/macOS_SDK_headers_for_macOS_10.14.pkg -target /
	```

Is there an equivalent for Linux?

[remingtonc]

Likely due to brew binaries de-prioritized in path:

❯ which perl
/usr/bin/perl

❯ echo "$PATH" | tr ':' '\n'
...
/usr/lib64/ccache
/usr/local/sbin
/usr/local/bin
/usr/bin
/home/linuxbrew/.linuxbrew/bin
/home/linuxbrew/.linuxbrew/sbin
/home/linuxbrew/.linuxbrew/bin
/home/linuxbrew/.linuxbrew/sbin

Moving linuxbrew up the hierarchy to see if it resolves via ensuring homebrew perl.
If this does fix the issue the followup question is whether this is an expected requirement for PATH order or if the brew formula should already have the paths isolated/injected/... (idk how brew does things).

[remingtonc]

This is a bluefin issue as system binaries are prioritized:

/etc/profile.d🔒 
❯ cat brew.sh
#!/usr/bin/env bash

# Prioritize system binaries to prevent brew overriding things like dbus
# See: https://github.com/ublue-os/brew/blob/54b30cc07d3211fca65ca5cc724e9812c8c79b77/system_files/usr/lib/systemd/system/brew-upgrade.service#L17-L22
if [[ -d /home/linuxbrew/.linuxbrew && $- == *i* ]] ; then
  eval "$(/home/linuxbrew/.linuxbrew/bin/brew shellenv | grep -Ev '\bPATH=')"
  HOMEBREW_PREFIX="${HOMEBREW_PREFIX:-/home/linuxbrew/.linuxbrew}"
  export PATH="${PATH}:${HOMEBREW_PREFIX}/bin:${HOMEBREW_PREFIX}/sbin"
fi

Should this formula prioritize brew perl on its own or rely on shell path?

[remingtonc]

Shoot, still fails even with path order prioritizing homebrew perl. Looks like it is trying to use homebrew perl even in original, so path is not the culprit.

❯ file /home/linuxbrew/.linuxbrew/opt/perl/lib/perl5/5.42/x86_64-linux-thread-multi/CORE/EXTERN.h
/home/linuxbrew/.linuxbrew/opt/perl/lib/perl5/5.42/x86_64-linux-thread-multi/CORE/EXTERN.h: ASCII text

Tried --with-std-env to see if it would behave and it did move past Template-Toolkit install but then failed at DBD::Pg despite libpq being installed.

❯ brew install --keep-tmp sqitch --with-std-env --with-postgres-support --with-sqlite-support
✔︎ JSON API cask.jws.json                                                                                                                                                 Downloaded   15.3MB/ 15.3MB
✔︎ JSON API formula.jws.json                                                                                                                                              Downloaded   31.9MB/ 31.9MB
==> Fetching downloads for: sqitch
✔︎ Formula sqitch (1.6.1)                                                                                                                                                 Verified    686.5KB/686.5KB
==> Installing sqitch from sqitchers/sqitch
==> cpm install --local-lib-contained instutil --no-test Menlo::CLI::Compat Module::Build
==> perl Build.PL --install_base /home/linuxbrew/.linuxbrew/Cellar/sqitch/1.6.1 --etcdir /home/linuxbrew/.linuxbrew/etc/sqitch --with postgres --with sqlite
==> ./Build bundle
Last 15 lines from /var/home/remington/.cache/Homebrew/Logs/sqitch/03.Build.log:
--> Working on Template
Fetching http://www.cpan.org/authors/id/T/TO/TODDR/Template-Toolkit-3.102.tar.gz ... OK
Configuring Template-Toolkit-3.102 ... OK
==> Found dependencies: AppConfig
--> Working on AppConfig
Fetching http://www.cpan.org/authors/id/N/NE/NEILB/AppConfig-1.71.tar.gz ... OK
Configuring AppConfig-1.71 ... OK
Building AppConfig-1.71 ... OK
Successfully installed AppConfig-1.71
Building Template-Toolkit-3.102 ... OK
Successfully installed Template-Toolkit-3.102
! Installing the dependencies failed: Module 'DBD::Pg' is not installed
! Bailing out the installation for App-Sqitch-v1.6.1.
Error installing modules: 
91 distributions installed
==> Temporary files retained at:
/var/tmp/sqitch-20260305-210920-hgxzwy

If reporting this issue please do so at (not Homebrew/* repositories):
  https://github.com/sqitchers/homebrew-sqitch/issues

These open issues may also help:
brew install sqitch --with-postgres-support error   macos/14.4.1/M2 https://github.com/sqitchers/homebrew-sqitch/issues/64

Now curious for an opinion. :)

[theory]

I've only ever tried it on macOS, so impressed you got this far. Curious what the output is for the DBD::Pg failure. Does /var/tmp/sqitch-20260305-210920-hgxzwy/App-Sqitch-v1.6.1/.brew_home/.perl-cpm/build.log or similar exist? Need to see what DBD::Pg complains about.

[remingtonc]

cc -c  -I/var/home/linuxbrew/.linuxbrew/opt/libpq/include -I/home/linuxbrew/.linuxbrew/Cellar/sqitch/1.6.1/lib/perl5/x86_64-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fwrapv -fno-stri
ct-aliasing -pipe -fstack-protector-strong -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPGLIBVERSION=180003 -DPGDEFPORT=5432 -DHAS64BITLO -O2  -DPERL_EXTMALLOC_DEF -Dmalloc=Pe
rl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\"3.18.0\" -DXS_VERSION=\"3.18.0\" -fPIC "-I/home/linuxbrew/.linuxbrew/opt/perl/lib/perl5/5.42/x86_64-linux-thread
-multi/CORE"   Pg.c
types.c:18:98: error: initialization of ‘char * (*)(void)’ from incompatible pointer type ‘char * (*)(PerlInterpreter *, const char *, STRLEN,  STRLEN *, int)’ {aka ‘char * (*)(struct interpreter 
*, const char *, long unsigned int,  long unsigned int *, int)’} [-Wincompatible-pointer-types]
   18 |  {PG_ACLITEMARRAY                  ,"_aclitem"                     ,1,',',"array_out"           ,quote_string,dequote_string,{0},0},
      |                                                                                                  ^~~~~~~~~~~~
types.c:18:98: note: (near initialization for ‘pg_types[0].quote’)
In file included from Pg.h:68,
                 from types.c:15:
quote.h:3:8: note: ‘quote_string’ declared here
    3 | char * quote_string(pTHX_ const char *string, STRLEN len, STRLEN *retlen, int estring);
      |        ^~~~~~~~~~~~

Looks like a failure to build Pg.c et al. Big build file included.

build.log

Might try having an AI bash at it.