Re[4]: pkg upgrade error after system failure

[Ilia Gorstkine]

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 <dillon at backplane.com>:
>
>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


-- 
Ilia Gorstkine
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.dragonflybsd.org/pipermail/users/attachments/20191111/302237b8/attachment-0003.htm>