Skip to content

Information Technology

macOS 11 Compatibily Check

Yesterday, Apple announced macOS 11. I need to know what members of my computer fleet are compatible. William Smith, aka talkingmoose, was kind enough to post the regex for what models are compatible with macOS 11. You can find that here. I tested Smith’s regex in BBEdit and it worked as expected. The question was, how do I get an easy list of my fleet in our MDM, Mosyle? I sent a Custom Command to my fleet, it’s here on GitHub. I told it to run that custom command on all computers and to store the results as “Big Sur.” So now I needed to use that data to create… Read More »macOS 11 Compatibily Check

FileMaker Export to Tab Delimited

I want to export a table to a tab delimited text file1. FileMaker supports that without any question. What it doesn’t do is create a header row. I’m using this file to import into PickATime, a software designed to book parent-teacher conferences. I want to automate this as much as possible. So how do I get the header rows that are required? In FileMaker my field might be called OpenApplyID, whereas PickATime requires the field to be called StudentID. So I can’t just take those field titles. There’s new script steps in FileMaker 18 that will let me do this. Script Go to Layout [ “StudentContacts” (StudentContacts) ] Show All… Read More »FileMaker Export to Tab Delimited

Rename Computer using Scripting and Google Sheets

UPDATE: You need to allow redirects in your cURL by adding -L. See this post. With Apple’s Device Enrollment program, when a organization-owned device first turns on, it checks in with Device Enrollment and gets the information to know what MDM is managing it and how to contact it. That MDM system can then install what’s known as a bootstrapping package. In our old bootstrapping package, which was developed by an employee no longer here, was a giant if statement. If SerialNumber = x then set ComputerName to Bob, elseif SerialNumber = y then set ComputerName to Frank, elseif SerialNumber = z then set ComputerName to Jane. Pretty simple and… Read More »Rename Computer using Scripting and Google Sheets

Let’s Encrypt with CPanel

A lot of web hosts have Let’s Encrypt built into the CPanel. Not mine. I was kinda annoyed. I tweeted at them to ask if they’d support it. They wouldn’t. So I decided I would make it work myself. To do this is pertty simple. I’m just going to start by copying and pasting text from a previous article. Open up your Terminal.app (Go to the Go menu, choose Utilities, double-click on Terminal). This isn’t even a step, you should know this. Step One – Install Homebrew /usr/bin/ruby -e “$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)” At this point, you will be prompted to press RETURN to continue. Press the return key. It will… Read More »Let’s Encrypt with CPanel

OMG! APPLE IS GUTTING SERVER.APP!!!! Part 3 DNS to BIND

In July, I will be presenting at MacAdmins at PSU. My talk will be called “OMG! APPLE IS GUTTING SERVER.APP!!!!” I will be using my blog to document all the processes taken to get all the data. The goal of this is to find easy ways to move away from Server.app while utilizing the existing Apple hardware in your server closet and macOS. Sure you can move to a new system, but you might not have the money or time. You can find the slide deck here. Server.app -> BIND So before I start, I should say that this is fully documented in Apple’s macOS Server Service Migration documentation, which… Read More »OMG! APPLE IS GUTTING SERVER.APP!!!! Part 3 DNS to BIND

OMG! APPLE IS GUTTING SERVER.APP!!!! Part 2 Web to Apache

In July, I will be presenting at MacAdmins at PSU. My talk will be called “OMG! APPLE IS GUTTING SERVER.APP!!!!” I will be using my blog to document all the processes taken to get all the data. The goal of this is to find easy ways to move away from Server.app while utilizing the existing Apple hardware in your server closet and macOS. Sure you can move to a new system, but you might not have the money or time. You can find the slide deck here. Server.app -> Apache First step is to test the server. After booting this VM, I visited my testserver. Mine was at testserver.leobaeck.ca. It… Read More »OMG! APPLE IS GUTTING SERVER.APP!!!! Part 2 Web to Apache

OMG! APPLE IS GUTTING SERVER.APP!!!! Part 1 Web to MAMP

In July, I will be presenting at MacAdmins at PSU. My talk will be called “OMG! APPLE IS GUTTING SERVER.APP!!!!” I will be using my blog to document all the processes taken to get all the data. The goal of this is to find easy ways to move away from Server.app while utilizing the existing Apple hardware in your server closet and macOS. Sure you can move to a new system, but you might not have the money or time. You can find the slide deck here. Server.app -> MAMP I started with a simple MunkiReport instance running in Server.app. I figured this would be using enough resources to move.… Read More »OMG! APPLE IS GUTTING SERVER.APP!!!! Part 1 Web to MAMP

Find a Mac’s serial number in Recovery Partition or the macOS installer

I couldn’t find this anywhere, so I thought I’d blog about this. Thanks to the #general channel on the MacAdmins Slack for the help. To find a serial number for a Mac when booted into the Recovery Partition or the macOS installer, to go Utilities and choose Terminal, type in ioreg -rd1 -c IOPlatformExpertDevice | awk -F'”‘ ‘/IOPlatformSerialNumber/{print $4}’ That’s it, it will output the serial number for the computer.

Importing Data to FileMaker 16 via APIs

I’m new to APIs. Have quite a bit of FileMaker experience. I’ve decided to see if I can build a system to track parent-teacher contact. This is a system that once existed for the school in an ASP system that I mocked up and outsourced. It was replaced with Edsby, an LMS system that wasn’t truly designed for this purpose. We were smashing a square peg into a round hole. My proof of concept for this system involves seeing if I can build something that does three things I’ve never done in FileMaker before. OAuth login using Google authentication Sending nightly emails of any records that have changed for those… Read More »Importing Data to FileMaker 16 via APIs

Renewing Let’s Encrypt on a macOS machine running 10.12.6 and Server.app

Last time on Never Had To Fight… Adam installed a certificate using Let’s Encrypt for a macOS server running 10.12.6 and Server.app. It wasn’t exciting, but it worked. Now, three months later, we need to renew. It was actually really easy. Renew the certificates sudo certbot renew Transfer the .pem files to desktop Using the cp command enter these to copy your files. Replace <<FQDN>> with your FQDN. Replace <<USER>> with your username. sudo cp /etc/letsencrypt/live/<<FQDN>>/privkey.pem /Users/<<USER>>/Desktop/privkey.pem sudo cp /etc/letsencrypt/live/<<FQDN>>/fullchain.pem /Users/<<USER>>/Desktop/fullchain.pem Hooray, now these files are on your desktop. Install Certs Open Server.app Go to Certificates. Click on the + Choose Import Certificate Identity… Drag and drop the two .pem… Read More »Renewing Let’s Encrypt on a macOS machine running 10.12.6 and Server.app