<HTML><BODY>Hi Matt,<br><br>I've installed ca_root_nss-3.47 with perl5-5.30 via dports. I have now a symlink to /usr/local/share/certs/ca-root-nss.crt in /etc/ssl/cert.pem and /usr/local/etc/ssl/cert.pem.<br>Making pkg-bootstrap-force returns the same error:<br>rm -f /usr/local/etc/pkg.conf<br>fetch -o /tmp/pkgboot.tar.xz <a href="https://mirror-master.dragonflybsd.org/dports/bootstraps/bootstrap_pkg_03_x86-64.tar.xz">https://mirror-master.dragonflybsd.org/dports/bootstraps/bootstrap_pkg_03_x86-64.tar.xz</a> <br>Certificate verification failed for /C=SE/O=AddTrust AB/OU=AddTrust External TTP Network/CN=AddTrust External CA Root<br> 34367976060:error:14007086:SSL routines:CONNECT_CR_CERT:certificate verify failed:/usr/src/lib/libressl/../../crypto/libressl/ssl/ssl_clnt.c:1121:<br>fetch: <a href="https://mirror-master.dragonflybsd.org/dports/bootstraps/bootstrap_pkg_03_x86-64.tar.xz" data-mce-href="https://mirror-master.dragonflybsd.org/dports/bootstraps/bootstrap_pkg_03_x86-64.tar.xz">https://mirror-master.dragonflybsd.org/dports/bootstraps/bootstrap_pkg_03_x86-64.tar.xz</a> : Authentication error<br>*** Error code 1<br>Stop.<br>make[1]: stopped in /usr <br>...<br>Removing of database give nothing in my case. It is just created local.sqlite in /var/db/pkg and pkg does not still work properly. A<span class="tlid-translation translation" lang="en"><span title="">lthough it helped get rid of the sqlite error when calling pkg version (pkg: sqlite error while executing ALTER TABLE packages ADD licenselogic INTEGER NOT NULL DEFAULT(1); in file pkgdb.c:2477: no such table: packages). But I just can't install any package via pkg or make pkg upgrade due to certificate verification error.</span></span><br><br><blockquote style="border-left:1px solid #0857A6; margin:10px; padding:0 0 0 10px;">
Понедельник, 11 ноября 2019, 8:10 +03:00 от Matthew Dillon <dillon@backplane.com>:<br>
<br>
<div id="">
<div class="js-helper js-readmsg-msg">
<style type="text/css"></style>
<div>
<div id="style_15734490290260171800_BODY"><div class="class_1573465332"><div dir="ltr">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.<div><br></div><div>cd /usr</div><div>make pkg-bootstrap-force</div><div><br></div><div>Then see if the 'pkg' command works again by trying to install a few things.</div><div><br></div><div>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?</div><div><br></div><div>-Matt</div></div><br><div class="gmail_quote_mailru_css_attribute_postfix"><div class="gmail_attr_mailru_css_attribute_postfix" dir="ltr">On Sun, Nov 10, 2019 at 10:44 AM Ilia Gorstkine <<a rel="noopener noreferrer" href="//e.mail.ru/compose/?mailto=mailto%3acadavo@mail.ru">cadavo@mail.ru</a>> wrote:<br></div><blockquote style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex" class="gmail_quote_mailru_css_attribute_postfix">
<div><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 lang="en"><span title=""> <span 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 rgb(8,87,166);margin:10px;padding:0px 0px 0px 10px">
Пятница, 8 ноября 2019, 18:07 +03:00 от Antonio Huete Jiménez <<a rel="noopener noreferrer" href="//e.mail.ru/compose/?mailto=mailto%3atuxillo@quantumachine.net">tuxillo@quantumachine.net</a>>:<br>
<br>
<div id="gmail-m_-3027898771493760335_mailru_css_attribute_postfix">
<div>
<div>
<div id="gmail-m_-3027898771493760335style_15732256282119098367_BODY_mailru_css_attribute_postfix">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 rel="noopener noreferrer" href="//e.mail.ru/compose/?mailto=mailto%3acadavo@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 rel="noopener noreferrer" 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 rel="noopener noreferrer" 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></div>
</blockquote></div>
</div></div>
</div>
</div>
</div>
</blockquote>
<br>
<br>-- <br>Ilia Gorstkine<br></BODY></HTML>