SG-1100 package manager not working

Gertjan

Hi,

Read https://docs.netgate.com/pfsense/en/latest/packages/fixing-a-broken-pkg-database.html

There are also messages on the forum ( from @jimp ) where he suggests what to do.

edit : check that file system is ok, "df" is happy, etc.

twigley

Thanks, I've followed through that as below:

[2.4.4-RELEASE][admin@RedDwarf.localnet]/root: /bin/mkdir -p /var/db/pkg/ /root/var/db/pkg/
[2.4.4-RELEASE][admin@RedDwarf.localnet]/root: /usr/sbin/pkg-static update -f
/usr/sbin/pkg-static: Command not found.
[2.4.4-RELEASE][admin@RedDwarf.localnet]/root: pkg-static update -f
Updating pfSense-core repository catalogue...
pkg-static: Repository pfSense-core load error: access repo file(/var/db/pkg/repo-pfSense-core.sqlite) failed: No such file or directory
pfSense-core repository is up to date.
Updating pfSense repository catalogue...
pkg-static: Repository pfSense load error: access repo file(/var/db/pkg/repo-pfSense.sqlite) failed: No such file or directory
pfSense repository is up to date.
All repositories are up to date.
[2.4.4-RELEASE][admin@RedDwarf.localnet]/root: pkg-static install -yf pkg pfSense pfSense-kernel-pfSense
Updating pfSense-core repository catalogue...
pkg-static: Repository pfSense-core load error: access repo file(/var/db/pkg/repo-pfSense-core.sqlite) failed: No such file or directory
pfSense-core repository is up to date.
Updating pfSense repository catalogue...
pkg-static: Repository pfSense load error: access repo file(/var/db/pkg/repo-pfSense.sqlite) failed: No such file or directory
pfSense repository is up to date.
All repositories are up to date.
pkg-static: Repository pfSense-core load error: access repo file(/var/db/pkg/repo-pfSense-core.sqlite) failed: No such file or directory
pkg-static: Repository pfSense-core cannot be opened. 'pkg update' required
pkg-static: Repository pfSense load error: access repo file(/var/db/pkg/repo-pfSense.sqlite) failed: No such file or directory
pkg-static: Repository pfSense cannot be opened. 'pkg update' required
pkg-static: No packages available to install matching 'pfSense' have been found in the repositories
[2.4.4-RELEASE][admin@RedDwarf.localnet]/root: /etc/rc.php_ini_setup
[2.4.4-RELEASE][admin@RedDwarf.localnet]/root: df -h
Filesystem                     Size    Used   Avail Capacity  Mounted on
/dev/diskid/DISK-D68FB6C8s3    7.0G    965M    5.5G    15%    /
devfs                          1.0K    1.0K      0B   100%    /dev
/dev/md0                       3.4M     92K    3.0M     3%    /var/run
devfs                          1.0K    1.0K      0B   100%    /var/dhcpd/dev

Noting the "pkg-static: No packages available to install matching 'pfSense' have been found in the repositories" seems very wrong.

This is the pkg config on the system (default that I can see):

[2.4.4-RELEASE][admin@RedDwarf.localnet]/root: cat /usr/local/share/pfSense/pkg/repos/pfSense-repo.conf
FreeBSD: { enabled: no }

pfSense-core: {
  url: "pkg+https://repo.netgate.com/pkg/pfSense_factory-v2_4_4_aarch64-core",
  mirror_type: "srv",
  signature_type: "fingerprints",
  fingerprints: "/usr/local/share/pfSense/keys/pkg",
  enabled: yes
}

pfSense: {
  url: "pkg+https://repo.netgate.com/pkg/pfSense_factory-v2_4_4_aarch64-pfSense_factory-v2_4_4",
  mirror_type: "srv",
  signature_type: "fingerprints",
  fingerprints: "/usr/local/share/pfSense/keys/pkg",
  enabled: yes
}

/edit

disk looks ok too:

[2.4.4-RELEASE][admin@RedDwarf.localnet]/root: df -h
Filesystem                     Size    Used   Avail Capacity  Mounted on
/dev/diskid/DISK-D68FB6C8s3    7.0G    965M    5.5G    15%    /
devfs                          1.0K    1.0K      0B   100%    /dev
/dev/md0                       3.4M     92K    3.0M     3%    /var/run
devfs                          1.0K    1.0K      0B   100%    /var/dhcpd/dev

Rico

Hmmm as 100% reliable fix I probably would just Backup my Config from the WebGUI, clean re-install pfSense and recover the Config.

-Rico

twigley

@Rico Just did that before posting

jimp

Send the support crew a message at https://go.netgate.com and they can help you get moving again.

Since this is an SG-1100 they will also want to know the output of the following commands:

/usr/local/bin/ping-auth.sh

/usr/local/sbin/ping-auth -s

/usr/bin/openssl ec -in /etc/thoth/key.pem -noout -text

(at least the pub: block from that)

twigley

@jimp thanks will do

twigley

Just to confirm support have been able to fix this for me based on the info above and the output from @jimp 's commands. Thanks all

Gertjan

Good !

But what was the issue ?

twigley

@Gertjan It was an issue at Netgates end, rather than mine.

I presume they do some kind of authentication on the repos via the device info/cert mentioned above and that this one just wasn't on the whitelist.

stilldirty

This same thing has happened to me the last 3 installs over the course of a few years.