pkg upgrade error after system failure

[Matthew Dillon]

A complete wipe and reinstall... ok, well, you may have to re-bootstrap the
packages.  If you are getting a certificate verification failure you may be
missing /etc/ssl/cert.pem or /usr/local/etc/ssl/cert.pem.

cd /usr
make pkg-bootstrap-force

Then see if the 'pkg' command works again by trying to install a few things.

I'm not sure if that will wipe the corrupt database.  If not you will have
to rm the database... Antonio, do you remember what files must be removed
to do that?

-Matt

On Sun, Nov 10, 2019 at 10:44 AM Ilia Gorstkine <cadavo at mail.ru> wrote:

>
> Hi Antonio,
> I use Hammer.
> How can I reinstall all packages from scratch if both pkgng and dports
> fails with these errors respectively?
> Certificate verification failed for...
> and pkg: sqlite error while executing...
>
> Пятница, 8 ноября 2019, 18:07 +03:00 от Antonio Huete Jiménez <
> tuxillo at quantumachine.net>:
>
> Hi,
>
> I've just made a fresh 5.6.2 installation to a VM and everything
> worked as expected. I suspect your hard reset has caused some kind of
> corruption both in the certificates and the pkgng database. You may
> have to reinstall all the packages again from the scratch.
>
> BTW, which filesystem did you use for the installation?
>
> Regards,
> Antonio Huete
>
>
>
>
> Ilia Gorstkine <cadavo at mail.ru> escribió:
>
> > Sony vaio pcg-41213v
> > 5.6-release DragonFly v5.6.2.4.g39d387-RELEASE #4
> >
> > When updating packages by pkg upgrade at the installation stage my
> > laptop freezes tightly and I had to turn it off via the power button.
> > After booting the system, the pkg upgrade command throws errors:
> > Updating Avalon repository catalogue...
> > Certificate verification failed for /C=SE/O=AddTrust AB/OU=AddTrust
> > External TTP Network/CN=AddTrust External CA Root
> > 34371375740:error:14007086:SSL routines:CONNECT_CR_CERT:certificate
> > verify
> > failed:/usr/src/lib/libressl/../../crypto/libressl/ssl/ssl_clnt.c:1121:
> > pkg:
> >
> https://mirror-master.dragonflybsd.org/dports/dragonfly:5.6:x86:64/LATEST/meta.txz:
> Authentication
> > error...
> > ...
> > pkg:
> >
> https://mirror-master.dragonflybsd.org/dports/dragonfly:5.6:x86:64/LATEST/packagesite.txz:
> Authentication
> > error
> > Unable to update repository Avalon
> > Error updating repositories!
> >
> > I have tried other repositories, but with the same results.
> > I tried installing ca_root_nss, but pkg install ca_root_nss returned
> > the same error.
> > pkg fetch, pkg search, pkg update - same error.
> > pkg backup -r /var/backups.sql.xz - recovery went ok, but nothing
> changed.
> > pkg version returns the following:
> > pkg: sqlite error while executing ALTER TABLE packages ADD
> > licenselogic INTEGER NOT NULL DEFAULT(1); in file pkgdb.c:2477: no
> > such table: packages
> >
> > Can anyone help restore pkg database?
> > Thanks in advance!
> > --
> > Ilia Gorstkine
>
>
>
>
>
> --
> Ilia Gorstkine
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.dragonflybsd.org/pipermail/users/attachments/20191110/66e1aea7/attachment.htm>