Hi Matt, 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. Making pkg-bootstrap-force returns the same error: rm -f /usr/local/etc/pkg.conf fetch -o /tmp/pkgboot.tar.xz https://mirror-master.dragonflybsd.org/dports/bootstraps/bootstrap_pkg_03_x86-64.tar.xz Certificate verification failed for /C=SE/O=AddTrust AB/OU=AddTrust External TTP Network/CN=AddTrust External CA Root 34367976060:error:14007086:SSL routines:CONNECT_CR_CERT:certificate verify failed:/usr/src/lib/libressl/../../crypto/libressl/ssl/ssl_clnt.c:1121: fetch: https://mirror-master.dragonflybsd.org/dports/bootstraps/bootstrap_pkg_03_x86-64.tar.xz : Authentication error *** Error code 1 Stop. make[1]: stopped in /usr ... 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 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.
>Понедельник, 11 ноября 2019, 8:10 +03:00 от Matthew Dillon ><[email protected]>: > >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 < [email protected] > 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 < >>>[email protected] >: >>> >>>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 < [email protected] > 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 -- Ilia Gorstkine
