Re[2]: pkg upgrade error after system failure

[Ilia Gorstkine]

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/5f34fc4b/attachment-0003.htm>