Errors trying to install or uninstall packages

davey_bones

System info:

2.4.4-RELEASE-p2 (amd64)
built on Wed Dec 12 07:40:18 EST 2018
FreeBSD 11.2-RELEASE-p6

The system is on the latest version.
Version information updated at Mon Feb 25 10:25:31 EST 2019

Whenever I try to install any Package I get this dialogue:

Installing pfSense-pkg-iperf...
Updating pfSense-core repository catalogue...
pfSense-core repository is up to date.
Updating pfSense repository catalogue...
pfSense repository is up to date.
All repositories are up to date.
Checking integrity... done (0 conflicting)
The following 2 package(s) will be affected (of 0 checked):

New packages to be INSTALLED:
pfSense-pkg-iperf: 2.0.5.5_3 [pfSense]
iperf: 2.0.12 [pfSense]

Number of packages to be installed: 2
[1/2] Installing iperf-2.0.12...
pkg-static: sqlite error while executing INSERT OR REPLACE INTO packages( origin, name, version, comment, desc, message, arch, maintainer, www, prefix, flatsize, automatic, licenselogic, mtree_id, time, manifestdigest, dep_formula, vital)VALUES( ?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12, ?13, (SELECT id FROM mtree WHERE content = ?14), NOW(), ?15, ?16, ?17 ) in file pkgdb.c:1723: database disk image is malformed
Failed

When I try to uninstall a package it just sits at:

Package Removal
Please wait while the update system initializes

It looks like there is a error in the package manager database is there a way to rebuild it?

Grimson

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

davey_bones

@grimson Thank you for pointing that out for me, I swear I googled the issue for a good hour or two to no avail.

I get an error whenever I run the command /usr/sbin/pkg-static update -f
/usr/sbin/pkg-static command not found

ls
.csrc .k5login .profile .tcshrc var
.hushlogin .login .shrc pkg-static

looks like im missing /usr/ all together.

Gertjan

@davey_bones said in Errors trying to install or uninstall packages:

looks like im missing /usr/ all together.

A small hope : reboot to single user mode, and be friends with fsck a while.
Your system is in a real bad shape.
Put on your todo list : Get a copy of your config.xml file.