Skip to content

Instantly share code, notes, and snippets.

View sbailliez's full-sized avatar

Stephane B. sbailliez

View GitHub Profile
@sbailliez
sbailliez / vagrant-vmware-fusion-13-apple-m1-pro.md
Last active March 26, 2024 15:38
Vagrant and VMWare Fusion 13 on Apple M1 Pro

Vagrant and VMWare Fusion 13 Player on Apple M1 Pro

This document summarizes notes taken to make VMWare Fusion 13 Player work on Apple M1 Pro. It builds upon a previous document based on VMWare Tech Preview 21H1

VMWare Fusion 13 was released on November 17, 2022 and Fusion 13.5 on October 19, 2023

Created on: November 20, 2022

Updated on: December 12, 2023

@sbailliez
sbailliez / vagrant-vmware-no-network.log
Created November 20, 2022 04:29
Log file showing failure to run vmrun getGuestIPAddress
This file has been truncated, but you can view the full file.
[11/19/2022, 11:19:07.391 PM] INFO global: Vagrant version: 2.3.2
[11/19/2022, 11:19:07.391 PM] INFO global: Ruby version: 2.7.6
[11/19/2022, 11:19:07.391 PM] INFO global: RubyGems version: 3.1.6
[11/19/2022, 11:19:07.391 PM] INFO global: VAGRANT_LOG="debug"
[11/19/2022, 11:19:07.393 PM] INFO global: VAGRANT_EXECUTABLE="/opt/vagrant/embedded/gems/2.3.2/gems/vagrant-2.3.2/bin/vagrant"
[11/19/2022, 11:19:07.393 PM] INFO global: VAGRANT_INSTALLER_ENV="1"
[11/19/2022, 11:19:07.393 PM] INFO global: VAGRANT_INSTALLER_EMBEDDED_DIR="/opt/vagrant/embedded"
[11/19/2022, 11:19:07.393 PM] INFO global: VAGRANT_INSTALLER_VERSION="2"
@sbailliez
sbailliez / vagrant-vmware-tech-preview-apple-m1-pro.md
Last active April 10, 2024 07:51
Vagrant and VMWare Tech Preview 21H1 on Apple M1 Pro

Vagrant and VMWare Tech Preview 21H1 on Apple M1 Pro

UPDATE November 20, 2022: VMWare Fusion 13

VMWare Fusion 13 is now released. Read Vagrant and VMWare Fusion 13 Player on Apple M1 Pro for the latest.

Summary

This document summarizes notes taken while to make the VMWare Tech preview work on Apple M1 Pro, it originated

@sbailliez
sbailliez / postgresql_11_upgrade.md
Last active May 7, 2021 14:11
Upgrading from Postgresql 10.6 to Postgresql 11.1

Spent a few hours dealing with errors on RDS when upgrading from a postgresql 10.6 to 11.1. In case someone else is dealing with the same problems, this might be helpful.

A few things to know about this database:

  • PostGIS extension was installed but was not being used
  • ip4r extension was installed but was also not used

This probably turned out to be a Good Thing (tm). If you are using PostGIS extensively, I wish you good luck.

Upgrades

Keybase proof

I hereby claim:

  • I am sbailliez on github.
  • I am sbailliez (https://keybase.io/sbailliez) on keybase.
  • I have a public key ASBKBaDbi1k-vE33JKl3XDKxxhj-K6OANQ1lIJ0WRNZjMwo

To claim this, I am signing this object:

@sbailliez
sbailliez / gist:0a741dc5e21b42ef6736
Created March 24, 2015 14:21
index on element of json array ?
SELECT so._id AS order_id,
oi.value ->> 'id'::text AS id,
(oi.value -> 'sku_id'::text) ->> '$oid'::text AS sku_id,
FROM orders so,
LATERAL jsonb_array_elements(so._extra_props -> 'order_items'::text) oi(value);
Customer customer = new Customer();
.... save customer ...
Card card = new Card(cardHref);
if (card.customer == null) {
card.associateToCustomer(customer);
}
Debit debit = card.debit(...);
DebitResult result = from(debit);
@sbailliez
sbailliez / gist:11268423
Created April 24, 2014 20:27
Scalyr RDS Postgresql log parser
{
lineGroupers: [
{
// groups line used to display stats
start: "^[^\\s]",
continueThrough: "^[\\s]+!"
},
{
// try to group lines that do have queries with text data containing newlines. Over simplification.
start: "^\\d+-\\d+-\\d+\\s+\\d+:\\d+:\\d+ UTC",
@sbailliez
sbailliez / gist:8876660
Created February 8, 2014 04:20
Provision vagrant with ssh keys, pem file, git config, aws config, etc...
#
# Allows copying ssh keys, directly to vagrant.. quick hack for my needs
#
# It is basically reading the file, encoding it in base64, pass it in the shell, decode it and write it
# in the file with the same name in /home/vagrant, chown it and set 600 permissions
def provision_home(config, from, to = nil, user = 'vagrant', permission = "600")
if File.exists?(File.join(Dir.home, from))
require "base64"
to = to.nil? ? "/home/vagrant/#{from}" : to
require 'etc'
ssh_user = Etc.getlogin
public_key_path = "~/.ssh/id_dsa.pub"
ssh_public_key = File.read(File.expand_path(public_key_path)).strip
Vagrant.configure("2") do |config|
....
config.vm.provision :shell, :inline => "cat >>/tmp/ssh_key_pub <<EOF\n#{ssh_public_key}\nEOF"
config.vm.provision :shell, :inline => "cat >>/tmp/ssh_user <<EOF\n#{ssh_user}\nEOF"