Upcoming IT Changes - Mon 28th Oct 0000 UTC (Part 1)

As has been hinted in several threads recently, there are upcoming changes to the SOTA IT systems, that will go live on 28th Oct 2024 at or about 0000 UTC. These changes are substantial from the back end, and will require a bit of work to deploy, but hopefully should not require much actual outage time for the systems affected. I would expect the total outage to be less than 1 hour.

The changes are as follows:

Major update to SSO server

  • A major version upgrade to the SSO server, and a move to a new backend database system, will require an SSO outage.
  • Starting from Sunday 27th, new user registration on SSO will be disabled. This will allow our normal backups to represent a particular static state in time, and reduce the outage window on the Monday.
  • Any users who were asked to update their passwords and have not updated their passwords will not be able to log in.

Changes to API2

  • Users of API2 are advised that API2 is now deprecated and will be removed in a few months time.
  • Most endpoints have been migrated to api-db2 and can be utilised with the same path.
  • The underlying database for API2 is being decommissioned, saving SOTA approximately GBP 70 a month in hosting costs.
  • The technology and development environment used for API2 is no longer easy to configure, making changes to the environment difficult, which is the main driver for change, and to address some niggling little bugs and semantics issues that have existed in the API for years.
  • Consumers of the Spots API are advised that the spots endpoints and schema are changing, in order to allow simpler consumption for downstream tools, better filtering and to align with the new database.
  • As the underlying schema and database is changing, I cannot guarantee the old endpoints will return correct data for all query types (if at all), and it is advised to update to use the new endpoints.
  • The expected procedure for pulling spots is also changing to allow better caching and improve scalability of the API, and downstream consumers that do not follow the new procedure may find themselves blocked if usage is deemed to be excessive.
  • Users of the API are reminded that the APIs are private and that, while we don’t mind people using them, users must always accept that schema changes may be made with little or no notice before they use them.
  • I have reached out to several downstream consumers who should be ready for the cutover. Anyone who is not aware, or who I have not been able to find listed as a consumer of the API, can reach me via PM to discuss the changes. I would have preferred to give more notice to API consumers but as I have some serious work and personal travel coming up, I needed to push this sooner rather than later so that I can address issues as they come up. If I delay it, we’re likely to not push live until December/January, and I’d rather spend that time on a SOTA summit than on a SOTA server.

SOTAWatch changes

  • Perhaps the biggest visible change will be to SOTAWatch. There will be a new layout for both desktop and mobile use that addresses some of the challenges with the current interface.
  • We introduce two new kinds of spots:
    • QRT spots: It is now possible to indicate that you are going QRT, rather than the usual approach now of using the “other” mode.
    • Test spots: Test spots are now a specific type of spot, and can be easily and readily filtered out.
  • Spots and Alerts are now only fetched when new spots (or alerts) exist, reducing network traffic on constrained links.
  • Filtering by multiple modes is now supported (multiple bands has been supported for a while). Multiple bands or modes selection is logical-OR (ie, 2m or 4m or 6m or 10m; ssb or cw), and the two lists of filters are combined in a logical-AND (ie, (2m or 6m) AND (ssb or cw) ).
  • Regex filtering on Alerts is made consistent to apply to most of the same fields as the Spots regex filter.
  • The reflector links panel will move to a separate tab like Spots and Alerts
  • The reflector tab will now have notifications of “unseen” reflector topics. Please note that this will indicate that you haven’t seen the topic on SOTAWatch, rather than indicating whether you’ve viewed the topic on the reflector (which cannot be queried to find this out in a manner acceptable to our hosting provider)
  • The settings menu is moved from behind the Logged In dropdown so that settings can be adjusted without needing to be logged in. Settings are as always per-browser, not per-user.
  • Many thanks to Andrew @VK1AD and Joe @OE5JFE for their debugging and feedback on the initial beta, as well as feedback from fellow MT members.

There is a lot of work that’s gone into these changes, and the deployment is probably the most complex multiple environment upgrade we’ve ever done. As such, there’s always a good possibility that everything will just collapse in a big heap because I’ve forgotten something important. We have plans to back out the changes if it all turns into a steaming pile of number-twos and the brown stuff hits the airconditioning. If there are any minor teething problems post upgrade, we crave your patience while we sort them out.

Andrew
VK3ARR
obo SOTA MT IT Group

63 Likes

Good luck with the upgrades Andrew!
Ed.

1 Like

Just from the description of the changes it is evident that you have undertaken an enormous amount of work on this Andrew for which we give our thanks and appreciation. Hopefully there will not be any brown stuff flying around.

73, Gerald

7 Likes

Sounds Awesome :ok_hand:

Thanks to everyone concerned for all the hard work that’s gone and going into this. :smiley:

6 Likes

Exciting! Thanks for the heads up and to the whole team for their ongoing efforts to improve the SOTA IT systems!

4 Likes

Like I’m sure others on here I activate on other schemes such as POTA and WWFF and by a very long way SOTA IT leads the pack. The POTA systems are not bad but WWFF is a long way behind.

Many thanks to all those involved in the SOTA systems.

7 Likes

Heck of a lot of work there by a lot of people.

I wish the “wind be at your back” for the implementation.

To quote the spirit of Donald Rumsfeld. Beware of the “unknown unknowns”… hopefully none significant pop up.

You and all those involved continue to have my thanks for volunteering your time and expertise.

7 Likes

There’s actually a document detailing the individual upgrade steps as there’s a lot going on. Often the upgrade process boils down to “go on, push the new software and let’s see what happens” :slight_smile:

Saving on one of the DB costs will be nice. It’s your money we spend but the thought we should now be able to do a better job for less money is always pleasing even if it’s someone else paying.

Note the SMS spotter should just work but the cluster may have a period of downtime.

7 Likes

100% this - SOTA IT infrastructure and particularly having the API to allow other great projects like sotlas exist do make SOTA stand out.

I enjoy using the API to access summit information and my logs to plan future trips, and make my own stats page.

I appreciate that and it makes complete sense. I would like to ask if, in time, they can be listed though, rather than reverse engineering them through the browser’s network inspection, or gathering info shared here.

2 Likes

Someone could start a wiki?

1 Like

5 Likes

4 Likes

I like the QRT Spot I often send a Spot to say QRT and TNX to my Chasers. It adds another personal safety aspect to SOTA as well, or at least your chasers will be the first to know you are on the hike down or leaving the summit area. I always TXT the land owner too to say I am safely off his hill and a thank you for access as well. Thanks for the good work.
Regards
Ian vk5cz …

6 Likes

I hear you. :sweat_smile: I’m happy writing a list and sharing it.

I’m meaning things like:

  • List users activations: https://api-db.sota.org.uk/admin/activator_log_by_id?year=all&id=94131
  • List users per region: https://api-db.sota.org.uk/admin/activator_roll?associationID=03
  • Retrieve log of an activation (requires authentication) https://api-db.sota.org.uk/admin/secure/my_activator_log_detailed?id=917403
  • Retrieve my chases (requires authentication) https://api-db.sota.org.uk/admin/secure/my_chaser_uniques?start=1

Which of course will all be wrong shortly :smiley:

2 Likes

Thanks for your programming and debugging efforts! I look forward to the results.

73,
Andy, N4LAG

2 Likes

Have been wrong for a while - api-db2 has been around for since the SotaData3 rollout whenever that was :slight_smile:

2 Likes

Haha, how ironic! All the best for the migration! :+1:

3 Likes

Great big THANKS! to all who have worked (and who may do additional work) on this upgrade.
Ken

2 Likes

Well done everyone on all the hard work so far.

As one of the users of the API for APRS2SOTA I have had chance to perform some tests and changes to my code for APRS2SOTA and all being well these will be deployed around 06:00 UTC on Monday (when I get out of bed) which does mean that APRS2SOTA may NOT function normally for a few hours after the expected change-over of the SOTA sites.

7 Likes