Remove dead links in database

[gilles1]

Hello,

My NC’s journal shows errors like following
RequestException
cURL error 60: SSL: no alternative certificate subject name matches target host name ‘GFXX.freeboxos.fr’ (see libcurl - Error Codes) for https://GFXX.freeboxos.fr/ocm-provider/
error while discovering ocm provider

In fact, hostname https://GFXX.freeboxos.fr should not be used (it is invalid), and it does not have a SSL certificate.
I want to remove those links that generate this error.

When I do a “grep -E freeboxos nextcloud-sqlbkp_20240725.bak” in my SQL database backup, I find two entries that link to the invalid host GFXX.freeboxos.fr :
(15,6,‘agnes@GFXX.freeboxos.fr’,NULL,‘gilles’,‘gilles’,NULL,‘folder’,‘456159’,NULL,456159,‘’,17,1609006807,0,NULL,‘Yo7Ysp3T1sfhwCN’,0,NULL,0,NULL,0,NULL,NULL,NULL),
(1,-1,0,‘https://GFXX.freeboxos.fr/‘,‘15’,‘Yo7Ysp3T1sfhwCN’,’‘,’/20201226_velo’,‘gilles’,‘agnes’,'/Partages de Gilles/Photos/2021/Partages de Gilles/20201226_velo’,‘eb88fe476110f7db3e174ea1071948db’,1),

This entry corresponds to this share:

Unfortunately, the contextual menu does not provide any operation to remove it from the NC web interface:

How can I remove safely these links and solve these journal errors ?

Thanks in advance

Best regards

Gilles

[gilles1]

I found a solution there

root@nextcloudpi:/home/pi# mariadb
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 190627
Server version: 10.11.6-MariaDB-0+deb12u1 Debian 12

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases
    -> ;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| nextcloud          |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0,037 sec)

MariaDB [(none)]> use nextcloud;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

MariaDB [nextcloud]> SELECT * FROM oc_share_external;
+----+--------+------------+--------------------------------------+-----------+-----------------+----------+------------------------------------------------------+--------+--------+------------------------------------------------------------------------+----------------------------------+----------+
| id | parent | share_type | remote                               | remote_id | share_token     | password | name                                                 | owner  | user   | mountpoint                                                             | mountpoint_hash                  | accepted |
+----+--------+------------+--------------------------------------+-----------+-----------------+----------+------------------------------------------------------+--------+--------+------------------------------------------------------------------------+----------------------------------+----------+
|  1 |     -1 |          0 | https://GFXX.freeboxos.fr/ | 15        | Yo7Ysp3T1sfhwCN |          | /20201226_velo                                       | gilles | agnes  | /Partages de Gilles/Photos/2021/Partages de Gilles/20201226_velo       | eb88fe476110f7db3e174ea1071948db |        1 |
|  2 |     -1 |          0 | https://<hidden hostname>/                | 136       | F3AH9MiKIdAV7YM |          | /Anniv Hélène                                        | helene | gilles | /Photos de Helene/Anniv Hélène                                         | a2bd7d16a588299101de0467d7cf1210 |        1 |
|  3 |     -1 |          0 | https://<hidden hostname>/                | 137       | lFl51PkGPu6GdZQ |          | /Anniv Hélène                                        | helene | agnes  | /Photos/2021/Anniv Hélène                                              | d29d483e38b6ff8282838be25e17f3ff |        1 |
|  5 |     -1 |          0 | https://<hidden hostname>/                | 174       | u81cN95eSmy4FGt |          | /20210211_Séjour à Marseille du 11 au 14 février.    | agnes  | helene | /Photos partagées/20210211_Séjour à Marseille du 11 au 14 février.     | 3f24c0f233a614d4a617b13df414022a |        1 |
|  6 |     -1 |          0 | https://<hidden hostname>/                | 199       | YP2PG1IUcu9uMKo |          | /20210221_Ballade à La Bastille.                     | agnes  | helene | /Photos partagées/20210221_Ballade à La Bastille.                      | fe965ce6b58b203055b4eae75d2369f9 |        1 |
+----+--------+------------+--------------------------------------+-----------+-----------------+----------+------------------------------------------------------+--------+--------+------------------------------------------------------------------------+----------------------------------+----------+
5 rows in set (0,001 sec)

MariaDB [nextcloud]> delete FROM oc_share_external where owner="gilles";
Query OK, 1 row affected (0,002 sec)

MariaDB [nextcloud]> quit
Bye