Category Archives: Sys Admin

Material related to systems administration.

Mail Call #36: QuickStudy Cheatsheets and Soldering Stuff from Amazon | In The Lab With Jay Jay

Posted on by
Reply

This post is part of my video blog and you can find more information about this video over here.

You can support this channel on Patreon: patreon.com/JohnElliotV

Silly Job Title: Electronics Guru.

In this video we see what arrived in the mail from Amazon. The main haul was my QuickStudy cheatsheets. But I also go this stuff too:

Thanks very much for watching! And please remember to hit like and subscribe! :)

Following is a product I use picked at random from my collection which may appear in my videos. Clicking through on this to find and click on the green affiliate links before purchasing from eBay or AliExpress is a great way to support the channel at no cost to you. Thanks!

Yum Cha 100pcs Heat Shrink Wire ConnectorsThis is an image of the product.

Let’s go shopping!

Destroying single disk ZFS zpool

Posted on by
Reply

This is a note for Future John. I followed the instructions from ChatGPT. They looked reasonable enough. Now I have a spare 2TB SATA drive that has no purpose in life. I am always sad when things have no purpose in life. Who knows. Maybe one day…

-------------------
Tue Jul 01 03:33:54 [bash:5.2.15 jobs:0 error:0 time:0]
root@charisma:/home/jj5
# zpool status sata
  pool: sata
 state: ONLINE
config:

        NAME                               STATE     READ WRITE CKSUM
        sata                               ONLINE       0     0     0
          ata-ST2000DM008-2UB102_ZFL7BGR8  ONLINE       0     0     0

errors: No known data errors
-------------------
Tue Jul 01 03:34:00 [bash:5.2.15 jobs:0 error:0 time:6]
root@charisma:/home/jj5
# zpool destroy sata
-------------------
Tue Jul 01 03:34:08 [bash:5.2.15 jobs:0 error:0 time:14]
root@charisma:/home/jj5
# cat /proc/partitions 
major minor  #blocks  name
...snip...
   8       48 1953514584 sdd
   8       49 1953505280 sdd1
...snip...
-------------------
Tue Jul 01 03:34:23 [bash:5.2.15 jobs:0 error:0 time:29]
root@charisma:/home/jj5
# wipefs -a /dev/sdd
/dev/sdd: 8 bytes were erased at offset 0x00000200 (gpt): 45 46 49 20 50 41 52 54
/dev/sdd: 8 bytes were erased at offset 0x1d1c1115e00 (gpt): 45 46 49 20 50 41 52 54
/dev/sdd: 2 bytes were erased at offset 0x000001fe (PMBR): 55 aa
/dev/sdd: calling ioctl to re-read partition table: Success
-------------------
Tue Jul 01 03:34:58 [bash:5.2.15 jobs:0 error:0 time:64]
root@charisma:/home/jj5
# sgdisk --zap-all /dev/sdd
Creating new GPT entries in memory.
GPT data structures destroyed! You may now partition the disk using fdisk or
other utilities.
-------------------
Tue Jul 01 03:35:28 [bash:5.2.15 jobs:0 error:0 time:94]
root@charisma:/home/jj5
# parted /dev/sdd --script mklabel gpt
-------------------
Tue Jul 01 03:35:50 [bash:5.2.15 jobs:0 error:0 time:116]
root@charisma:/home/jj5
# wipefs /dev/sdd
DEVICE OFFSET        TYPE UUID LABEL
sdd    0x200         gpt       
sdd    0x1d1c1115e00 gpt       
sdd    0x1fe         PMBR      
-------------------
Tue Jul 01 03:36:02 [bash:5.2.15 jobs:0 error:0 time:128]
root@charisma:/home/jj5
# lsblk /dev/sdd
NAME MAJ:MIN RM  SIZE RO TYPE MOUNTPOINTS
sdd    8:48   0  1.8T  0 disk 
-------------------

ORBTrace mini and instrumenting embedded applications

Posted on by
Reply

Today I learned about the ORBTrace mini. Gotta get me a few of those! There’s a video explaining the related software, Orbuculum, over here (but it requires you signup for a free account and validate your email address to watch).

New Zealand’s $16 Billion Public Health System Runs on a Single Excel Sheet

Posted on by
Reply

This is a note for Future John: New Zealand’s $16 Billion Public Health System Runs on a Single Excel Sheet.

From the report:

Notably, one major issue was through a significant reliance on the use of an Excel file to manage the consolidated financials of the organisation. This spreadsheet was the primary data file used by HNZ to manage its financial performance. It consolidated files from each district into a single spreadsheet, and key reports, such as the monthly finance report, were produced from it. The use of an Excel spreadsheet file to track and report financial performance for a $28bn expenditure organisation raises significant concerns, particularly when other more appropriate systems are present on the IT landscape.

This Excel file is flawed in that:

  • Financial information was often ‘hard-coded,’ making it difficult to trace to the source or have updated data flow through.
  • Errors such as incorrectly releasing accruals or double-up releases were not picked up until following periods.
  • Changes to prior periods and FTE errors in district financial reporting Excel submissions, would not flow through to consolidated file.
  • The spreadsheet can be easy to manipulate information as there is limited tracking to source information where information is not flowing directly from accounting systems.
  • It is highly prone to human error, such as accidental typing of a number or omission of a zero.

…

The cumbersome process of collecting data also meant monthly financial reporting usually took 12-15 days to consolidate and 5 days to analyse. Adding to that the time associated with the creation of the monthly finance reports and circulation of these to the Board, there was an inevitable challenge of obtaining real-time financial information from one source of truth.