Skip to content

Instantly share code, notes, and snippets.

Avatar

Eric Eastwood MadLittleMods

View GitHub Profile
@MadLittleMods
MadLittleMods / fix-hallmark-card-studio-on-windows-10.md
Last active December 23, 2022 04:48
Fix Hallmark Card Studio failing to launch on Windows 10 - Exception: Unable to load the native components of SQL Server Compact
View fix-hallmark-card-studio-on-windows-10.md

Problem

If you have an old version of Hallmark Card Studio and recently upgraded to Windows 10, you might be running into the following error when launching the program. The specific program I ran into this with was Hallmark Home Card Studio version 22/hcs.

A problem was encountered accessing the SQL database. Exception: Unable to load the native components of SQL Server Compact corresponding to the ADO.NET provider of version 8080. Install the correct version of SQL Server Compact. Refer to KB article 974247 for more details

@MadLittleMods
MadLittleMods / imac-2008-as-monitor.md
Last active February 20, 2023 06:26
Converting an old iMac into a standalone monitor
View imac-2008-as-monitor.md

Converting an old iMac into a standalone monitor

I'm working with an Apple iMac from 2008. Scroll down past the teardown to see the conversaion process.

iMac details:

  • Serial No: QP8390/Z0KM
  • Apple Model No: A1225 (EMC 2211)
  • Model ID: iMac8,1
  • Apple Order No: MB325LL/A
@MadLittleMods
MadLittleMods / oc-cross-project-logs.md
Created September 1, 2022 18:49
View logs across projects in Red Hat OpenShift
View oc-cross-project-logs.md

With Red Hat OpenShift, here's how to view logs of a pod in a different project than the one currently active:

oc logs -n <project> <pod>

Option as documented but obscure and hard to follow because the option is namespace but oc always references them as projects everywhere else:

@MadLittleMods
MadLittleMods / sort-google-photos-dump.md
Last active July 29, 2022 03:08
Fix photos sorted in maddening wrong order by date
View sort-google-photos-dump.md

Problem

We were dealing with an out of order dump of photos from a Google photos album and wanting to upload to Facebook. It consisted of jpg and heic photos from a iPhone 8 and Pixel 4a so the metadata was different.

Sorting by Date Created in the macOS finder was out of order and Facebook seemed to sort in the same way. It didn't make any sense because we were seeing 4:55am photos sorted below 4:56pm photos (same day). Regardless of Italian timezone, they shouldn't be sorting like that (it's only GMT+2 vs my local GMT-6) which is an 8 hour difference compared the 12 hour difference shown in the photo date/times. Even looking at the exif metadata, it didn't make any sense what it was pulling from to make it sort that way.

Solution

This uses exiftool to read and do the file manipulation.

@MadLittleMods
MadLittleMods / golang-escape-forward-slash-in-test-name.md
Last active November 5, 2021 21:13
Golang: Escape forward slash in test name when using `-run` regex
View golang-escape-forward-slash-in-test-name.md

How to escape a forward slash in a test name when using -run to run a single Go test?

I don't think it's possible. The following are some other articles/blog posts reiterating this point.

The key seems to just not use any forward slashes in test names so you can target them individually no matter what.

Go Subtest Tips by Frew Schmidt

@MadLittleMods
MadLittleMods / eufy-robovac-25c.md
Last active September 14, 2021 01:57
Fixing a main rolling brush that is "stuck" on a Eufy RoboVac 25c (Robot Vacuum)
View eufy-robovac-25c.md

Eufy RoboVac 25c (Robot Vacuum)

The Eufy 11S (slim) seems to be pretty much the same vaccuum

Main rolling brush stuck

Eufy would often get stuck and beep 10 times. Since, I didn't have the app on my phone, I thought it was getting stuck on dark edges in the rug/carpet with the drop/cliff sensors but the app was actually saying "Rolling brush is stuck". There wasn't any obstructions in the brush.

View matrix-notes.md

UISI: Unknown Inbound Session ID (when you're unable to decrypt someones message in end-to-end encrypted (E2EE) room)

View fusion-360-notes.md

Autodesk Fusion 360

Autodesk Fusion 360 is free for personal use. It is a CAD program like Autodesk Inventor(which can be free if you have a .edu student school email address). I was familiar with Inventor and found Fusion 360 pretty similar with nice parametric modeling.

  • You can have multiple components in one design (and apply some assembly contraints)
  • For the blueprint type view that you can annotate and add dimensions, it is called a "drawing"

Random guides

@MadLittleMods
MadLittleMods / cmder-restart-ssh-agent.md
Created May 1, 2019 21:13
Restart ssh-agent in Cmder
View cmder-restart-ssh-agent.md

Sometimes the Cmder SSH agent seems to be borked and anything you try to connect to just rejects. I often run into this when running an Ansible command on a remote host

ssh root@xx.xxx.xxx.xxx
root@xx.xxx.xxx.xxx: Permission denied (publickey).
ssh_exchange_identification: Connection closed by remote host

Fix