fedora-infrastructure

Clone
Source Code
GIT

#9980 calendar [pointing to location freenode
Closed: Fixed 2 years ago by pingou. Opened 2 years ago by jbwillia.

Closed: Fixed
Reopen Issue

Describe what you would like us to do:

make sure all the calendar locations point to the correct network location
example currently https://apps.fedoraproject.org/calendar/location/fedora-meeting-2%40irc.freenode.net

When do you need this to be done by? (YYYY/MM/DD)

----as soon we switch to the other network

Tried to log in, but got OpenID request was cancelled. What access rights are needed to fix this? Looks likes it takes two steps:
-First to add new locations,
- then later on change to various active calendars.

Once we change to libera.chat, we need to update the links.

Metadata Update from @mohanboddu:
- Issue priority set to: Waiting on Assignee (was: Needs Review)
- Issue tagged with: medium-gain, medium-trouble, ops
2 years ago

@copperi There were some auth issues, should be fixed now.

I think however, that this might need changing in the db... I am not sure if there's a way to add/edit locations in the web interface?
@pingou would know.

I think however, that this might need changing in the db... I am not sure if there's a way to add/edit locations in the web interface?

Admins can edit all meetings and can thus edit the locations. However, based on the number of item involved, doing this at the DB level will be faster.

Few info:

# select count(distinct(meeting_location)) from meetings;
 count 
-------
   175

# select count(distinct(meeting_location)) from meetings WHERE meeting_location ILIKE '%freenode%';
 count 
-------
    57

So that's 57 update queries :)

I've ended up scripting the creation of these requests, here is the output:

UPDATE meetings SET meeting_location='fedora-coreos@libera.net' WHERE meeting_location = 'fedora-coreos@freenode.net';
UPDATE meetings SET meeting_location='fedora-zh@irc.libera.net' WHERE meeting_location = 'fedora-zh@irc.freenode.net';
UPDATE meetings SET meeting_location='fedora-neuro@libera' WHERE meeting_location = 'fedora-neuro@freenode';
UPDATE meetings SET meeting_location='fedora-meeting-1@irc.libera.net' WHERE meeting_location = 'fedora-meeting-1@irc.freenode.net';
UPDATE meetings SET meeting_location='fedora-blocker-review@irc.libera.net' WHERE meeting_location = 'fedora-blocker-review@irc.freenode.net';
UPDATE meetings SET meeting_location='fedora-meeting-1@chat.libera.net' WHERE meeting_location = 'fedora-meeting-1@chat.freenode.net';
UPDATE meetings SET meeting_location='fedora-classroom@irc.libera.net' WHERE meeting_location = 'fedora-classroom@irc.freenode.net';
UPDATE meetings SET meeting_location='fedora-join@irc.libera.net' WHERE meeting_location = 'fedora-join@irc.freenode.net';
UPDATE meetings SET meeting_location='fedora-hubs@irc.libera.net' WHERE meeting_location = 'fedora-hubs@irc.freenode.net';
UPDATE meetings SET meeting_location='libera@fedora-test-day' WHERE meeting_location = 'freenode@fedora-test-day';
UPDATE meetings SET meeting_location='fedora-modularity@chat.libera.net' WHERE meeting_location = 'fedora-modularity@chat.freenode.net';
UPDATE meetings SET meeting_location='fedora-haskell@chat.libera.net' WHERE meeting_location = 'fedora-haskell@chat.freenode.net';
UPDATE meetings SET meeting_location='packit@libera' WHERE meeting_location = 'packit@freenode';
UPDATE meetings SET meeting_location='fedora-india@libera.net' WHERE meeting_location = 'fedora-india@freenode.net';
UPDATE meetings SET meeting_location='fedora-server@irc.libera.net' WHERE meeting_location = 'fedora-server@irc.freenode.net';
UPDATE meetings SET meeting_location='fedora-design@chat.libera.net' WHERE meeting_location = 'fedora-design@chat.freenode.net';
UPDATE meetings SET meeting_location='fedora-golang@FreeNode' WHERE meeting_location = 'fedora-golang@FreeNode';
UPDATE meetings SET meeting_location='fedora-meeting-2@irc.libera.net' WHERE meeting_location = 'fedora-meeting-2@irc.freenode.net';
UPDATE meetings SET meeting_location='fedora-testday@libera' WHERE meeting_location = 'fedora-testday@freenode';
UPDATE meetings SET meeting_location='rdo@irc.libera.net' WHERE meeting_location = 'rdo@irc.freenode.net';
UPDATE meetings SET meeting_location='fedora-i3@irc.libera.net' WHERE meeting_location = 'fedora-i3@irc.freenode.net';
UPDATE meetings SET meeting_location='fedora-mindshare@irc.libera.net' WHERE meeting_location = 'fedora-mindshare@irc.freenode.net';
UPDATE meetings SET meeting_location='fedora-commops@irc.libera.net' WHERE meeting_location = 'fedora-commops@irc.freenode.net';
UPDATE meetings SET meeting_location='fedora-test-day@libera' WHERE meeting_location = 'fedora-test-day@freenode';
UPDATE meetings SET meeting_location='fudcon-planning@irc.libera.net' WHERE meeting_location = 'fudcon-planning@irc.freenode.net';
UPDATE meetings SET meeting_location='fedora-test-day@irc.libera.net' WHERE meeting_location = 'fedora-test-day@irc.freenode.net';
UPDATE meetings SET meeting_location='fedora-docs@irc.libera.net' WHERE meeting_location = 'fedora-docs@irc.freenode.net';
UPDATE meetings SET meeting_location='fedora-releng@irc.libera.net' WHERE meeting_location = 'fedora-releng@irc.freenode.net';
UPDATE meetings SET meeting_location='fedora-meeting@irc.libera.net' WHERE meeting_location = 'fedora-meeting@irc.freenode.net';
UPDATE meetings SET meeting_location='fedora-meeting@chat.libera.net' WHERE meeting_location = 'fedora-meeting@chat.freenode.net';
UPDATE meetings SET meeting_location='fedora-admin@irc.libera.net' WHERE meeting_location = 'fedora-admin@irc.freenode.net';
UPDATE meetings SET meeting_location='fedora-websites@irc.libera.net' WHERE meeting_location = 'fedora-websites@irc.freenode.net';
UPDATE meetings SET meeting_location='fedora-uk@irc.libera.net' WHERE meeting_location = 'fedora-uk@irc.freenode.net';
UPDATE meetings SET meeting_location='atomic@libera' WHERE meeting_location = 'atomic@freenode';
UPDATE meetings SET meeting_location='@fedora-i3@irc.libera.net' WHERE meeting_location = '@fedora-i3@irc.freenode.net';
UPDATE meetings SET meeting_location='fedora-meetings@libera' WHERE meeting_location = 'fedora-meetings@freenode';
UPDATE meetings SET meeting_location='fedora-containers@irc.libera.net' WHERE meeting_location = 'fedora-containers@irc.freenode.net';
UPDATE meetings SET meeting_location='fedora-security@chat.libera.net' WHERE meeting_location = 'fedora-security@chat.freenode.net';
UPDATE meetings SET meeting_location='fedora-iot@irc.libera.net' WHERE meeting_location = 'fedora-iot@irc.freenode.net';
UPDATE meetings SET meeting_location='libera@fedora-meeting' WHERE meeting_location = 'freenode@fedora-meeting';
UPDATE meetings SET meeting_location='fedora-i3@irc.libera.net' WHERE meeting_location = 'fedora-i3@irc.freenode.net';
UPDATE meetings SET meeting_location='fedora-golang@irc.libera.net' WHERE meeting_location = 'fedora-golang@irc.freenode.net';
UPDATE meetings SET meeting_location='fedora-it@irc.libera.net' WHERE meeting_location = 'fedora-it@irc.freenode.net';
UPDATE meetings SET meeting_location='irc://irc.libera.net/fedora-zh' WHERE meeting_location = 'irc://irc.freenode.net/fedora-zh';
UPDATE meetings SET meeting_location='fedora-i18n@irc.libera.net' WHERE meeting_location = 'fedora-i18n@irc.freenode.net';
UPDATE meetings SET meeting_location='fedora-id@irc.libera.net' WHERE meeting_location = 'fedora-id@irc.freenode.net';
UPDATE meetings SET meeting_location='fedora-diversity@irc.libera.net' WHERE meeting_location = 'fedora-diversity@irc.freenode.net';
UPDATE meetings SET meeting_location='fedora-ci@irc.libera.net' WHERE meeting_location = 'fedora-ci@irc.freenode.net';
UPDATE meetings SET meeting_location='fedora-meeting-1@libera.net' WHERE meeting_location = 'fedora-meeting-1@freenode.net';
UPDATE meetings SET meeting_location='fedora-meeting-3@irc.libera.net' WHERE meeting_location = 'fedora-meeting-3@irc.freenode.net';
UPDATE meetings SET meeting_location='fedora-meeting@irc.libera.net' WHERE meeting_location = 'fedora-meeting@irc.freenode.net';
UPDATE meetings SET meeting_location='epel@irc.libera.net' WHERE meeting_location = 'epel@irc.freenode.net';
UPDATE meetings SET meeting_location='fedora-classroom@chat.libera.net' WHERE meeting_location = 'fedora-classroom@chat.freenode.net';
UPDATE meetings SET meeting_location='gedora-design@chat.libera.net' WHERE meeting_location = 'gedora-design@chat.freenode.net';
UPDATE meetings SET meeting_location='libera@epel' WHERE meeting_location = 'freenode@epel';
UPDATE meetings SET meeting_location='fedora-g11n@irc.libera.net' WHERE meeting_location = 'fedora-g11n@irc.freenode.net';
UPDATE meetings SET meeting_location='rdo@libera' WHERE meeting_location = 'rdo@freenode';

Metadata Update from @pingou:
- Issue assigned to pingou
2 years ago

I had to adjust a few of these queries to account for some location having trailing spaces but:

# select meeting_id, meeting_location, meeting_name from meetings WHERE meeting_location ILIKE '%freenode%';
 meeting_id | meeting_location | meeting_name 
------------+------------------+--------------
(0 rows)

All good :)

Let us know if you need anything else

Metadata Update from @pingou:
- Issue close_status updated to: Fixed
- Issue status updated to: Closed (was: Open)
2 years ago

So, this is wrong.

It's irc.libera.chat

.chat, not .net.

The .net one is being domain squatted. ;(

Metadata Update from @kevin:
- Issue status updated to: Open (was: Closed)
2 years ago

Updated:

chans = """
...  fedora-test-day@irc.libera.net
...  fedora-security@chat.libera.net
...  fedora-meeting-2@irc.libera.chat
...  fedora-websites@irc.libera.net
...  fedora-meeting@irc.libera.net
...  fedora-haskell@libera.chat
...  fedora-india@libera.chat
...  fedora-i18n@irc.libera.net
...  fedora-testday@libera
...  fedora-docs@irc.libera.net
...  fedora-it@irc.libera.net
...  fedora-server@irc.libera.net
...  fedora-meeting-3@irc.libera.net
...  gedora-design@chat.libera.net
...  fedora-releng@irc.libera.net
...  fedora-iot@irc.libera.net
...  fedora-zh@irc.libera.net
...  fedora-coreos@libera.net
...  libera@epel
...  fedora-uk@irc.libera.net
...  fedora-meeting-2@irc.libera.net
...  fedora-meeting-1@chat.libera.net
...  fedora-meeting@irc.libera.chat
...  fedora-test-day@libera
...  fedora-blocker-review@irc.libera.net
...  fedora-meeting-1@libera.chat
...  fedora-golang@irc.libera.net
...  irc://irc.libera.net/fedora-zh
...  fedora-id@irc.libera.net
...  rdo@libera
...  libera@fedora-meeting
...  fedora-meeting-1@irc.libera.net
...  fedora-ci@irc.libera.net
...  fedora-meeting-1@libera.net
...  fedora-meeting@chat.libera.net
...  fedora-ci@irc.libera.chat
...  rdo@irc.libera.net
...  fedora-admin@irc.libera.net
...  fedora-join@irc.libera.net
...  fedora-commops@irc.libera.net
...  fedora-hubs@irc.libera.net
...  fedora-golang@libera
...  fedora-modularity@chat.libera.net
...  fedora-mindshare@irc.libera.net
...  atomic@libera
...  fedora-classroom@chat.libera.net
...  fedora-design@chat.libera.net
...  fedora-diversity@irc.libera.net
...  fedora-classroom@irc.libera.net
...  fedora-neuro@libera
...  libera@fedora-test-day
...  fedora-india@libera.net
...  fedora-containers@irc.libera.net
...  fedora-i3@irc.libera.net
...  fedora-meetings@libera
...  packit@libera
...  fudcon-planning@irc.libera.net
...  fedora-meeting-1@irc.libera.chat
...  fedora-golang@libera.chat
...  epel@irc.libera.net
...  fedora-haskell@chat.libera.net
...  fedora-g11n@irc.libera.net
... """
>>> 
>>> for chan in chans.split("\n"):
...    chan = chan.strip()
...    if not chan:
...         continue
...    dest_chan = chan.replace("libera.net", "libera.chat")
...    print(f"UPDATE meetings SET meeting_location='{dest_chan}' WHERE meeting_location = '{chan}';")
... 
UPDATE meetings SET meeting_location='fedora-test-day@irc.libera.chat' WHERE meeting_location = 'fedora-test-day@irc.libera.net';
UPDATE meetings SET meeting_location='fedora-security@chat.libera.chat' WHERE meeting_location = 'fedora-security@chat.libera.net';
UPDATE meetings SET meeting_location='fedora-meeting-2@irc.libera.chat' WHERE meeting_location = 'fedora-meeting-2@irc.libera.chat';
UPDATE meetings SET meeting_location='fedora-websites@irc.libera.chat' WHERE meeting_location = 'fedora-websites@irc.libera.net';
UPDATE meetings SET meeting_location='fedora-meeting@irc.libera.chat' WHERE meeting_location = 'fedora-meeting@irc.libera.net';
UPDATE meetings SET meeting_location='fedora-haskell@libera.chat' WHERE meeting_location = 'fedora-haskell@libera.chat';
UPDATE meetings SET meeting_location='fedora-india@libera.chat' WHERE meeting_location = 'fedora-india@libera.chat';
UPDATE meetings SET meeting_location='fedora-i18n@irc.libera.chat' WHERE meeting_location = 'fedora-i18n@irc.libera.net';
UPDATE meetings SET meeting_location='fedora-testday@libera' WHERE meeting_location = 'fedora-testday@libera';
UPDATE meetings SET meeting_location='fedora-docs@irc.libera.chat' WHERE meeting_location = 'fedora-docs@irc.libera.net';
UPDATE meetings SET meeting_location='fedora-it@irc.libera.chat' WHERE meeting_location = 'fedora-it@irc.libera.net';
UPDATE meetings SET meeting_location='fedora-server@irc.libera.chat' WHERE meeting_location = 'fedora-server@irc.libera.net';
UPDATE meetings SET meeting_location='fedora-meeting-3@irc.libera.chat' WHERE meeting_location = 'fedora-meeting-3@irc.libera.net';
UPDATE meetings SET meeting_location='gedora-design@chat.libera.chat' WHERE meeting_location = 'gedora-design@chat.libera.net';
UPDATE meetings SET meeting_location='fedora-releng@irc.libera.chat' WHERE meeting_location = 'fedora-releng@irc.libera.net';
UPDATE meetings SET meeting_location='fedora-iot@irc.libera.chat' WHERE meeting_location = 'fedora-iot@irc.libera.net';
UPDATE meetings SET meeting_location='fedora-zh@irc.libera.chat' WHERE meeting_location = 'fedora-zh@irc.libera.net';
UPDATE meetings SET meeting_location='fedora-coreos@libera.chat' WHERE meeting_location = 'fedora-coreos@libera.net';
UPDATE meetings SET meeting_location='libera@epel' WHERE meeting_location = 'libera@epel';
UPDATE meetings SET meeting_location='fedora-uk@irc.libera.chat' WHERE meeting_location = 'fedora-uk@irc.libera.net';
UPDATE meetings SET meeting_location='fedora-meeting-2@irc.libera.chat' WHERE meeting_location = 'fedora-meeting-2@irc.libera.net';
UPDATE meetings SET meeting_location='fedora-meeting-1@chat.libera.chat' WHERE meeting_location = 'fedora-meeting-1@chat.libera.net';
UPDATE meetings SET meeting_location='fedora-meeting@irc.libera.chat' WHERE meeting_location = 'fedora-meeting@irc.libera.chat';
UPDATE meetings SET meeting_location='fedora-test-day@libera' WHERE meeting_location = 'fedora-test-day@libera';
UPDATE meetings SET meeting_location='fedora-blocker-review@irc.libera.chat' WHERE meeting_location = 'fedora-blocker-review@irc.libera.net';
UPDATE meetings SET meeting_location='fedora-meeting-1@libera.chat' WHERE meeting_location = 'fedora-meeting-1@libera.chat';
UPDATE meetings SET meeting_location='fedora-golang@irc.libera.chat' WHERE meeting_location = 'fedora-golang@irc.libera.net';
UPDATE meetings SET meeting_location='irc://irc.libera.chat/fedora-zh' WHERE meeting_location = 'irc://irc.libera.net/fedora-zh';
UPDATE meetings SET meeting_location='fedora-id@irc.libera.chat' WHERE meeting_location = 'fedora-id@irc.libera.net';
UPDATE meetings SET meeting_location='rdo@libera' WHERE meeting_location = 'rdo@libera';
UPDATE meetings SET meeting_location='libera@fedora-meeting' WHERE meeting_location = 'libera@fedora-meeting';
UPDATE meetings SET meeting_location='fedora-meeting-1@irc.libera.chat' WHERE meeting_location = 'fedora-meeting-1@irc.libera.net';
UPDATE meetings SET meeting_location='fedora-ci@irc.libera.chat' WHERE meeting_location = 'fedora-ci@irc.libera.net';
UPDATE meetings SET meeting_location='fedora-meeting-1@libera.chat' WHERE meeting_location = 'fedora-meeting-1@libera.net';
UPDATE meetings SET meeting_location='fedora-meeting@chat.libera.chat' WHERE meeting_location = 'fedora-meeting@chat.libera.net';
UPDATE meetings SET meeting_location='fedora-ci@irc.libera.chat' WHERE meeting_location = 'fedora-ci@irc.libera.chat';
UPDATE meetings SET meeting_location='rdo@irc.libera.chat' WHERE meeting_location = 'rdo@irc.libera.net';
UPDATE meetings SET meeting_location='fedora-admin@irc.libera.chat' WHERE meeting_location = 'fedora-admin@irc.libera.net';
UPDATE meetings SET meeting_location='fedora-join@irc.libera.chat' WHERE meeting_location = 'fedora-join@irc.libera.net';
UPDATE meetings SET meeting_location='fedora-commops@irc.libera.chat' WHERE meeting_location = 'fedora-commops@irc.libera.net';
UPDATE meetings SET meeting_location='fedora-hubs@irc.libera.chat' WHERE meeting_location = 'fedora-hubs@irc.libera.net';
UPDATE meetings SET meeting_location='fedora-golang@libera' WHERE meeting_location = 'fedora-golang@libera';
UPDATE meetings SET meeting_location='fedora-modularity@chat.libera.chat' WHERE meeting_location = 'fedora-modularity@chat.libera.net';
UPDATE meetings SET meeting_location='fedora-mindshare@irc.libera.chat' WHERE meeting_location = 'fedora-mindshare@irc.libera.net';
UPDATE meetings SET meeting_location='atomic@libera' WHERE meeting_location = 'atomic@libera';
UPDATE meetings SET meeting_location='fedora-classroom@chat.libera.chat' WHERE meeting_location = 'fedora-classroom@chat.libera.net';
UPDATE meetings SET meeting_location='fedora-design@chat.libera.chat' WHERE meeting_location = 'fedora-design@chat.libera.net';
UPDATE meetings SET meeting_location='fedora-diversity@irc.libera.chat' WHERE meeting_location = 'fedora-diversity@irc.libera.net';
UPDATE meetings SET meeting_location='fedora-classroom@irc.libera.chat' WHERE meeting_location = 'fedora-classroom@irc.libera.net';
UPDATE meetings SET meeting_location='fedora-neuro@libera' WHERE meeting_location = 'fedora-neuro@libera';
UPDATE meetings SET meeting_location='libera@fedora-test-day' WHERE meeting_location = 'libera@fedora-test-day';
UPDATE meetings SET meeting_location='fedora-india@libera.chat' WHERE meeting_location = 'fedora-india@libera.net';
UPDATE meetings SET meeting_location='fedora-containers@irc.libera.chat' WHERE meeting_location = 'fedora-containers@irc.libera.net';
UPDATE meetings SET meeting_location='fedora-i3@irc.libera.chat' WHERE meeting_location = 'fedora-i3@irc.libera.net';
UPDATE meetings SET meeting_location='fedora-meetings@libera' WHERE meeting_location = 'fedora-meetings@libera';
UPDATE meetings SET meeting_location='packit@libera' WHERE meeting_location = 'packit@libera';
UPDATE meetings SET meeting_location='fudcon-planning@irc.libera.chat' WHERE meeting_location = 'fudcon-planning@irc.libera.net';
UPDATE meetings SET meeting_location='fedora-meeting-1@irc.libera.chat' WHERE meeting_location = 'fedora-meeting-1@irc.libera.chat';
UPDATE meetings SET meeting_location='fedora-golang@libera.chat' WHERE meeting_location = 'fedora-golang@libera.chat';
UPDATE meetings SET meeting_location='epel@irc.libera.chat' WHERE meeting_location = 'epel@irc.libera.net';
UPDATE meetings SET meeting_location='fedora-haskell@chat.libera.chat' WHERE meeting_location = 'fedora-haskell@chat.libera.net';
UPDATE meetings SET meeting_location='fedora-g11n@irc.libera.chat' WHERE meeting_location = 'fedora-g11n@irc.libera.net';

Output:

fedocal=# select distinct(meeting_location) from meetings WHERE meeting_location ILIKE '%libera.net';
 meeting_location 
------------------
(0 rows)

fedocal=# select distinct(meeting_location) from meetings WHERE meeting_location ILIKE '%libera%';
           meeting_location            
---------------------------------------
 fedora-i3@irc.libera.chat
 fedora-meeting-1@chat.libera.chat
 fedora-server@irc.libera.chat
 epel@irc.libera.chat
 fedora-commops@irc.libera.chat
 fedora-classroom@irc.libera.chat
 fedora-releng@irc.libera.chat
 fedora-meeting-2@irc.libera.chat
 fedora-mindshare@irc.libera.chat
 fedora-it@irc.libera.chat
 fedora-haskell@libera.chat
 fedora-diversity@irc.libera.chat
 fedora-india@libera.chat
 fedora-i18n@irc.libera.chat
 fedora-modularity@chat.libera.chat
 fedora-security@chat.libera.chat
 fedora-testday@libera
 fedora-meeting@chat.libera.chat
 fedora-test-day@irc.libera.chat
 gedora-design@chat.libera.chat
 libera@epel
 fedora-meeting@irc.libera.chat
 fedora-test-day@libera
 fedora-meeting-1@libera.chat
 fedora-coreos@libera.chat
 fedora-hubs@irc.libera.chat
 fedora-iot@irc.libera.chat
 libera@fedora-meeting
 rdo@libera
 fedora-haskell@chat.libera.chat
 fedora-ci@irc.libera.chat
 fedora-g11n@irc.libera.chat
 irc://irc.libera.chat/fedora-zh
 fedora-join@irc.libera.chat
 fedora-id@irc.libera.chat
 fedora-golang@libera
 fedora-golang@irc.libera.chat
 fedora-docs@irc.libera.chat
 atomic@libera
 fedora-design@chat.libera.chat
 fedora-uk@irc.libera.chat
 fudcon-planning@irc.libera.chat
 rdo@irc.libera.chat
 fedora-meeting-3@irc.libera.chat
 fedora-neuro@libera
 libera@fedora-test-day
 fedora-classroom@chat.libera.chat
 fedora-meetings@libera
 packit@libera
 fedora-containers@irc.libera.chat
 fedora-websites@irc.libera.chat
 fedora-meeting-1@irc.libera.chat
 fedora-golang@libera.chat
 fedora-zh@irc.libera.chat
 fedora-admin@irc.libera.chat
 fedora-blocker-review@irc.libera.chat
(56 rows)

Metadata Update from @pingou:
- Issue close_status updated to: Fixed
- Issue status updated to: Closed (was: Open)
2 years ago

Login to comment on this ticket.

Metadata

ops medium-gain medium-trouble

None
None
Waiting on Assignee
Boards 1
ops Status: Done
Powered by Pagure 5.13.3
Documentation • File an Issue • About • SSH Hostkey/Fingerprint
© Red Hat, Inc. and others.