[OSGeo] #3036: Mastodon search for strk at video.osgeo.org yelds: 503 Remote data could not be fetched

[OSGeo]

#3036: Mastodon search for strk at video.osgeo.org yelds: 503 Remote data could not
be fetched
-------------------------------+---------------------------------------
 Reporter:  strk               |       Owner:  sac@…
     Type:  task               |      Status:  closed
 Priority:  normal             |   Milestone:  Sysadmin Contract 2024-I
Component:  SysAdmin/Peertube  |  Resolution:  fixed
 Keywords:                     |
-------------------------------+---------------------------------------
Changes (by robe):

 * status:  new => closed
 * resolution:   => fixed
 * milestone:  Unplanned => Sysadmin Contract 2024-I

Comment:

 Okay I did this update in the db and seems to have fixed our webfingers

 {{{
 su postgres
 psql -d peertube_prod

 -- in psql
 UPDATE actor SET "outboxUrl" = replace("outboxUrl", 'videos.osgeo.org',
 'video.osgeo.org'), "inboxUrl" = replace("inboxUrl", 'videos.osgeo.org',
 'video.osgeo.org') WHERE "outboxUrl" LIKE '%videos.osgeo.org%';

 UPDATE actor SET "url" = replace("url", 'videos.osgeo.org',
 'video.osgeo.org')
         , "sharedInboxUrl" = replace("sharedInboxUrl", 'videos.osgeo.org',
 'video.osgeo.org')
         , "followersUrl" = replace("followersUrl", 'videos.osgeo.org',
 'video.osgeo.org')
         , "followingUrl" = replace("followingUrl", 'videos.osgeo.org',
 'video.osgeo.org')
         WHERE "url" LIKE '%videos.osgeo.org%';


 UPDATE "actorFollow" SET url = replace(url, 'videos.osgeo.org',
 'video.osgeo.org') WHERE url LIKE '%videos.osgeo.org%';

 }}}

 It updated 9 records of which two were ours.

 I confirm I can now follow robe at video.osgeo.org on my mapstodon account
 where as I couldn't before.
-- 
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/3036#comment:12>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.