Netgate Discussion Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Search
    • Register
    • Login

    SG-1100 package manager not working

    Scheduled Pinned Locked Moved Official Netgate® Hardware
    11 Posts 5 Posters 1.2k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • T
      twigley
      last edited by

      Fresh install of an SG-1100 and in fact freshly re-imaged as the package managed wasn't working initially with a different error.

      Now the web UI 'works' in that it doesn't error but it just displays blank i.e no packages available.

      CLI wise I get as an example:

      [2.4.4-RELEASE][admin@RedDwarf.localnet]/root: pkg install pfSense-pkg-openvpn-client-export
Updating pfSense-core repository catalogue...
pkg: 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: 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: Repository pfSense-core load error: access repo file(/var/db/pkg/repo-pfSense-core.sqlite) failed: No such file or directory
pkg: Repository pfSense-core cannot be opened. 'pkg update' required
pkg: Repository pfSense load error: access repo file(/var/db/pkg/repo-pfSense.sqlite) failed: No such file or directory
pkg: Repository pfSense cannot be opened. 'pkg update' required
pkg: No packages available to install matching 'pfSense-pkg-openvpn-client-export' have been found in the repositories

      The WAN is up and working, I've confirmed it can connect to and resolve the package repo (repo.netgate.com?) but I'm still stuck without a working package manager.

      1 Reply Last reply Reply Quote 0
      • GertjanG
        Gertjan
        last edited by 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.

        No "help me" PM's please. Use the forum, the community will thank you.
        Edit : and where are the logs ??

        1 Reply Last reply Reply Quote 0
        • T
          twigley
          last edited by 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
          1 Reply Last reply Reply Quote 0
          • RicoR
            Rico LAYER 8 Rebel Alliance
            last edited by

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

            -Rico

            T 1 Reply Last reply Reply Quote 0
            • T
              twigley @Rico
              last edited by

              @Rico Just did that before posting ☹

              1 Reply Last reply Reply Quote 0
              • jimpJ
                jimp Rebel Alliance Developer Netgate
                last edited by

                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)

                Remember: Upvote with the 👍 button for any user/post you find to be helpful, informative, or deserving of recognition!

                Need help fast? Netgate Global Support!

                Do not Chat/PM for help!

                T 1 Reply Last reply Reply Quote 1
                • T
                  twigley @jimp
                  last edited by

                  @jimp thanks will do 👍

                  1 Reply Last reply Reply Quote 0
                  • T
                    twigley
                    last edited by

                    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 👍

                    1 Reply Last reply Reply Quote 2
                    • GertjanG
                      Gertjan
                      last edited by

                      Good !

                      But what was the issue ?

                      No "help me" PM's please. Use the forum, the community will thank you.
                      Edit : and where are the logs ??

                      T 1 Reply Last reply Reply Quote 0
                      • T
                        twigley @Gertjan
                        last edited by

                        @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.

                        1 Reply Last reply Reply Quote 0
                        • S
                          stilldirty
                          last edited by

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

                          1 Reply Last reply Reply Quote 0
                          • First post
                            Last post
                          Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.