Select Page

SLES 15, missing zypper creds – again

Ran into this again – zyoper losing credentials – and something breaks in the Python dependencies.

/usr/sbin/registercloudguest –force-new

Traceback (most recent call last):
   File “/usr/sbin/registercloudguest”, line 42, in <module>
     import cloudregister.registerutils as utils
   File “/usr/lib/python3.6/site-packages/cloudregister/registerutils.py”, line 32, in <module>
     from lxml import etree
ImportError: /usr/lib64/python3.6/site-packages/lxml/etree.cpython-36m-x86_64-linux-gnu.so: undefined symbol: PyFPE_jbuf

Fix is to download the “old” Python library (here for this specific example) – and wedge it in. Then do the usual zypper up.

rpm –force –nodeps libpython3_6m1_0-3.6.10-lp152.3.7.x86_64.rpm

Optimal sizing in Azure

More a personal note. Regular website sizing (normal traffic, fronted with CloudFlare and Azure) compared with active use (voting/ballots and interaction).

The website is all WordPress on LAMP – so RAM and disk writes are key for the voting.

Normal use: B2ms – 2 vCPU, 8GB RAM

Surge use: E16s_v3 – 16 vCPU, 128GB RAM

Planning around this – and it’s a few extra dollars per month.

COVID week 42 – Dec 28 – Jan 3

New Year and weekend – entering the New Year with some hope that the multiple vaccines will slow and eventually eradicate the pandemic. All signs from the US are that distribution is being botched.

Weekend numbers from The Seattle Times – cases have decreased (yay!) and deaths seem to have peaked. Hospital beds are >85% utilised which is a big concern.

Thursday – looking back at the first year of Coronavirus: 83M reported, positive cases, 1.8M deaths. That curve isn’t slowing down. Data from JHU

imageimage

US data shows a more pronounced jump since November. Thanksgiving, Christmas, New Year…

imageimage

Wednesday – vaccination is slow in the US.

Tuesday – When the history of Covid and 2020-202? is written, there will be a lot said about how the US responded. Reading today that 40M+ Americans are behind in mortgage, car and credit card payments. Those payments all become due in mid 2021.

Monday – Already writing about 2021 – soon this will be a full year of working from home, school from home. The disruption to normal life has been immense. The loss of life, livelihoods and the elimination of societal norms will be here for a long time. UK, US and around the globe new cases are reaching new peaks. 41,385 new positive cases in the UK, NHS warns of collapse.

The Guardian The Seattle Times
28 Dec here here
29 Dec here here
30 Dec here here
31 Dec here here
1 Jan here here
2 Jan here here
3 Jan here here

https://www.theguardian.com/world/series/coronavirus-live

https://www.seattletimes.com/tag/coronavirus/

COVID week 41 of lockdown – Dec 21 – Dec 27

Christmas and Weekend – The UK mutation is everywhere; reported by the UK because of good virus genomics teams. Some delays in reporting new numbers because of Christmas and the weekend – but Washington State continues to look bleak. Graphics from The Seattle Times.

Thursday – Call for whole of England to move into Tier 4 immediately. Almost 40k daily cases in the UK. Lots of breaking the travel ban happening.

Wednesday – 1M vaccines given in US so far.

Tuesday – UK positive cases up by 18k!

image

Monday – slight dip in WA case numbers – which is encouraging. Massive spikes in the UK. More vaccines arriving.

The Guardian The Seattle Times
21 Dec here here
22 Dec here here
23 Dec here here
24 Dec here here
25 Dec here
26 Dec here here
27 Dec here here

https://www.theguardian.com/world/series/coronavirus-live

https://www.seattletimes.com/tag/coronavirus/

COVID week 40 of lockdown – Dec 14 – Dec 20

Weekend – UK U-turns into severe lockdown for London and SE. I can’t find the words to understand the last minute “escape from London” mentality – as folk try and beat the deadline.

Numbers from The Seattle Times again – format changed up a little.

 Starting on Dec. 21, we will not have this daily COVID-19 graphic in our Monday print edition, as the state Department of Health will no longer be reporting coronavirus data on Sundays. Data on Mondays will now incorporate the case and hospitalization counts from the previous day.

Friday – UK looks to be in the grip of a more transmissible mutation. Rt increases. Hoping the vaccines still effective – but runaway cases.

Thursday – Oh UK – your cases and hospitalisation is picking up again. From The Guardian.

image

Wednesday – UK reporting COVID mutation, with unknown results against the various vaccines. WA changes guidance on school re-opening – perhaps January/February?

Tuesday – NHS under extreme pressure. UK cases pick up again, after peaking and declining. First vaccines in Seattle given at UW. This certainly feels like the end of the beginning.

image

Monday – first vaccines have been given in the US. It’ll be a year and more to vaccinate the US or the UK. Sandra Lindsay will be the answer to a trivia question in the future.

The Guardian The Seattle Times
14 Dec here here
15 Dec here here
16 Dec here here
17 Dec here here
18 Dec here here
19 Dec here here
20 Dec here here

https://www.theguardian.com/world/series/coronavirus-live

COVID week 39 of lockdown – Dec 7 – Dec 13

Weekend – it’s Saturday and the graph from The Seattle Times is grim reading. Average number of positive cases >3000 per day for a few days. Positive cases >12.5%. We were doing so well. Is this “mask and isolation and lockdown” fatigue – or just the follow on from Thanksgiving where it seemed like everyone travelled.

Friday – Hanukkah, Christmas – following on from Thanksgiving. Flu season. Lots to be really concerned about. Vaccines are being approved. Vaccines are being withdrawn for more testing.

Thursday – US recordbreaking deaths – 3000 in one 24 hour period.

Wednesday – The US cumulative cases curve isn’t slowing down..

image

Tuesday – UK starts vaccinations. The beginning of the end? Perhaps. More closures and restrictions to come. Margaret Keenan, William Shakespeare first and second on the NHS.

Monday – week 39. Is this still “lockdown” – yes. It’s been nine months of social distancing, working from home, near zero normal social activity (football, movies, eating out). What we have done has been just us, masks on, six+ feet apart.

The Guardian The Seattle Times
7 Dec here here
8 Dec here here
9 Dec here here
10 Dec here here
11 Dec here here
12 Dec here here
13 Dec here

https://www.theguardian.com/world/series/coronavirus-live

COVID week 38 of lockdown – Nov 30 – Dec 6

Weekend – Discussion is moving to “how to promote vaccine adoption” – and breaking through the antivax/COVID hoax rhetoric, as well as reaching to BIPOC communities that have been historically underserved and abused by the medical professions. Tough message to land.

Washington State still seeing record positive cases per day, and a steady uptick in deaths and hospitalisation.

Friday – full steam ahead for vaccine production. Rollouts starting across many countries this month. Even with “500M doses in a year” – it’s going to be a long slog.

Thursday – Italy record deaths. Biden will launch “masks for 100 days”.

Wednesday – vaccine rollout starts in Russia. Germany extends lockdown to mid January.

Tuesday – Washington State notification app goes live.

Monday – Record deaths across the globe; following the surge and hospitalisations.

The Guardian The Seattle Times
30 Nov here here
1 Dec here here
2 Dec here here
3 Dec here here
4 Dec here here
5 Dec here here
6 Dec

https://www.theguardian.com/world/series/coronavirus-live

COVD week 37 of lockdown – Nov 23 – Nov 29

Weekend – no end to the positive cases in Washington. As always weekend graphic from The Seattle Times.

Friday – positive tests spiking at around 20% in parts of Washington State. That is alarming.

Thursday – Thanksgiving Day. 3M+ travelled.

Wednesday – 60M global cases, vast numbers of US cases. Records broken across the globe.

Tuesday – Italy and Spain hit hard again. UK and French lockdowns easing.

Monday – today Russia with peak cases. 12% positive test rate in Washington State.

The Guardian The Seattle Times
23 Nov here here
24 Nov here here
25 Nov here here
26 Nov here here
27 Nov here here
28 Nov here here
29 Nov here here

https://www.theguardian.com/world/series/coronavirus-live

Kusto queries that work for me

Azure Resource Graph explorer is awesome.

Here’s my running list of useful queries.

Resources, by name, subscription name, resource group and location. Switch out the “where” for the resource type. e.g. microsoft.compute/virtualmachines

Resources

| join kind=leftouter (ResourceContainers | where type==’microsoft.resources/subscriptions’ | project SubName=name, subscriptionId) on subscriptionId

| where type =~ ‘Microsoft.network/loadbalancers’

| project name, SubName, resourceGroup, location


Linux machines, including appliance MarketPlace identifiers (i.e. CentOS, SLES, RHEL)

Resources

| join kind=leftouter (ResourceContainers | where type==’microsoft.resources/subscriptions’ | project SubName=name, subscriptionId) on subscriptionId

| where type =~ ‘Microsoft.compute/virtualmachines’

| where properties.storageProfile.osDisk.osType =~ ‘Linux’

| project name, SubName, resourceGroup, location, properties.storageProfile.imageReference.offer