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