Steam and pacman failed to connect but some other applications are file

[Nasha]

Hello everyone, I’m quite new with endeavourOs and linux in general and I think I just did something wrong

When looking at the Arch wiki I saw this Pacman/Tips_and_tricks and to keep my system “clean” I ran the commands

pacman -Qdtq | pacman -Rns -
pacman -Qqd | pacman -Rsu -

then I rebooted my computer and now I partialy lost my internet connection.

Steam can’t update when i launch it and pacman command is failing like this

❯ sudo pacman -Syu
:: Synchronizing package databases...
endeavouros.db failed to download
core.db failed to download
extra.db failed to download
multilib.db failed to download
error: failed retrieving file 'core.db' from mirror.cyberbits.eu : error setting certificate file: /etc/ssl/certs/ca-certificates.crt
error: failed retrieving file 'extra.db' from mirror.cyberbits.eu : error setting certificate file: /etc/ssl/certs/ca-certificates.crt
error: failed retrieving file 'multilib.db' from mirror.cyberbits.eu : error setting certificate file: /etc/ssl/certs/ca-certificates.crt
[...]
error: failed retrieving file 'endeavouros.db' from mirror.jingk.ai : error setting certificate file: /etc/ssl/certs/ca-certificates.crt
error: failed retrieving file 'endeavouros.db' from mirrors.nxtgen.com : error setting certificate file: /etc/ssl/certs/ca-certificates.crt
error: failed retrieving file 'endeavouros.db' from mirror.nag.albony.in : error setting certificate file: /etc/ssl/certs/ca-certificates.crt
error: failed retrieving file 'endeavouros.db' from mirror.funami.tech : error setting certificate file: /etc/ssl/certs/ca-certificates.crt
error: failed retrieving file 'endeavouros.db' from mirror.archlinux.tw : error setting certificate file: /etc/ssl/certs/ca-certificates.crt
error: failed retrieving file 'endeavouros.db' from mirror.b-interactive.com.au : error setting certificate file: /etc/ssl/certs/ca-certificates.crt
error: failed retrieving file 'endeavouros.db' from mirrors.tuna.tsinghua.edu.cn : error setting certificate file: /etc/ssl/certs/ca-certificates.crt
error: failed retrieving file 'endeavouros.db' from mirrors.jlu.edu.cn : error setting certificate file: /etc/ssl/certs/ca-certificates.crt
error: failed retrieving file 'endeavouros.db' from www.miraa.jp : error setting certificate file: /etc/ssl/certs/ca-certificates.crt
error: failed retrieving file 'endeavouros.db' from mirror.sjtu.edu.cn : error setting certificate file: /etc/ssl/certs/ca-certificates.crt
error: failed to synchronize all databases (failed to retrieve some files)
but spotify, ping  works fine and I'm writing this post on the very same computer :/www.google.com

But some applications are working fine like spotify or Vivaldi (which I’m using to write this post)

Can someone help me troubleshot the issue ?
Thanks

[thefrog]

@Nasha

When looking at the Arch wiki I saw this Pacman/Tips_and_tricks and to keep my system “clean” I ran the commands

For best practice you should follow these threads for helping to maintain your System

A Complete Idiot's Guide To Endeavour OS Maintenance / Update / Upgrade

I’m a complete idiot - so here’s my guide for you! It has been asked a lot, and fairly frequently recently it seems, especially by new Endeavour/new to Linux users. It was recently asked that I post how I update - so here it is. “How do I maintain / update / upgrade my system?!? Help!!” This is my maintenance plan. I have been using the same install for almost 2 years now without any major issue. I’m VERY aware there’s more than one way to do this. And most importantly - Many of these c…

and

How to run a stress-free EndeavourOS

I have spent a lot of time over the last 8 years helping people fix their broken systems and seeing people constantly describe how much trouble it is to keep their Arch-based systems running. Meanwhile, even though I run many systems with different configs, I never actually have these problems myself.1 I have helped people with so many obscure issues that if I ever did have issues with systems failing after an update I could fix them myself without too much trouble in most cases. However, I d…

Since I have no Idea what was removed you could start by posting your pacman.log
To learn how to include log files check this out
https://discovery.endeavouros.com/forum-log-tool-options/how-to-include-systemlogs-in-your-post/2021/03/

I’m not sure if it would be better to try and reinstall the things you removed you may need or to just do a fresh install and stop running commands you have no Idea of what they do just blindly.

you may need to rebuild your keys as well from what It appears
https://discovery.endeavouros.com/signature-and-keyring/pacman-keyring-issues/2021/03/

[cactux]

@Nasha

pacman -Qqd | pacman -Rsu -

You should have followed Archwiki to see what --print will print before removing.

pacman -Qqd | pacman -Rsu --print -

-u, --unneeded

Removes targets that are not required by any other packages.

But this doesn’t mean that they are not required on their own right for the functioning of the system.

@Nasha

error setting certificate file: /etc/ssl/certs/ca-certificates.crt

Looks you removed this package: ca-certificates-utils
If you haven’t erase your package cache to the ground, you can reinstall it from there.

[Nasha]

Hello, thank you, it was indeed this package that I stupidly dropped …
I was not able to found it in my cache but I’ve create a bootable USB and get it from there and was able to run

sudo pacman -S ca-certificates-utils

I’ll try to be less dumb next time …

[cactux]

It is possible that you have removed other packages that you would have liked to keep.

Use the command line tool eos-packagelist and list the packages that is installed as a base for EndeavourOS and check the packages for your DE.

Check in your /var/log/paman.log what you have removed.

Compare and reinstall what is missing.

Or reinstall the whole group of packages. For example for a base os:

eos-packagelist --install 'Desktop-Base + Common packages'

And so on…