Skip to content

Instantly share code, notes, and snippets.

View johnweldon's full-sized avatar

John Weldon johnweldon

50 followers · 27 following
View GitHub Profile
@johnweldon
johnweldon / start-sshagent
Created December 20, 2011 00:43
powershell script to start the ssh-agent
$ gcm start-sshagent | fl
Name : start-sshagent
CommandType : Function
Definition :
if($env:SSH_AGENT_PID) { echo "ssh-agent running"; return }
$private:gp = get-gitbinpath
if($private:gp) {
$private:out = & (join-path $private:gp "ssh-agent")
@johnweldon
johnweldon / test_12063689.sql
Created August 22, 2012 19:32
SQLite Test Case for http://stackoverflow.com/a/12063689/102371
DROP TABLE tempA; CREATE TABLE tempA ( style_cd CHAR(3), id_cd VARCHAR(15) );
DROP TABLE tempB; CREATE TABLE tempB ( item_desc VARCHAR(50), item_num CHAR(4), style_cd CHAR(3), id_cd VARCHAR(15) );
INSERT INTO tempA
SELECT 'A', 123456
UNION SELECT 'A', 654321
UNION SELECT 'B', 321456
UNION SELECT 'A', 654123
UNION SELECT 'C', 424242;
@johnweldon
johnweldon / read_xlsx.cs
Created October 9, 2012 20:44
Read Excel .xlsx file and return first worksheet as a DataTable
using System.Data;
using System.Data.OleDb;
using System.Diagnostics;
namespace JW4.DB.Util
{
public static class Excel
{
public static DataTable GetFirstWorksheetAsTable(string filename)
{
@johnweldon
johnweldon / git-recent
Created March 13, 2015 23:33
#!/bin/bash
read -r -d '' AWK <<EOF
{
date=\$1;
refname=\$2;
subject=substr(\$3,1,72);
sha=\$4;
len=split(refname, ref, "/");
@johnweldon
johnweldon / synmon-prod-2016.04.08-14.00.04.log.txt
Last active April 8, 2016 22:02
-------------------- Starting drone test 1 ------------------------
TRACE 2016/04/08 14:00:04 synmon.go:130: Starting task id 1 Login Test for iteration 0
TRACE 2016/04/08 14:00:04 drone.go:35: Start Drone Login Test
TRACE 2016/04/08 14:00:04 drone.go:44: Successfully got current user: syntheticmonitortool@gmail.com
TRACE 2016/04/08 14:00:04 drone.go:45: {"remote":"","login":"syntheticmonitor","name":"","email":"syntheticmonitortool@gmail.com","gravatar":"","admin":false,"active":true,"syncing":false,"created_at":0,"updated_at":0,"token":""}
TRACE 2016/04/08 14:00:04 util.go:96: file(2016.04.08/synmon-prod-2016.04.08-14.00.04.log) url() errorstring()
14:00 | Login Test | ID: 1 | 19.365907ms | | 👍 OK
INFO 2016/04/08 14:00:05 util.go:184: Task Info:
Task Status: Ok
@johnweldon
johnweldon / debug.go
Created April 26, 2016 02:54
Useful http debugging file. Replaces http.DefaultTransport with a logger of all http traffic.
package main
import (
"fmt"
"io"
"net/http"
"net/http/httputil"
"os"
)
@johnweldon
johnweldon / keybase.md
Created August 18, 2016 15:32

Keybase proof

I hereby claim:

  • I am johnweldon on github.
  • I am johnweldon (https://keybase.io/johnweldon) on keybase.
  • I have a public key whose fingerprint is 77E9 1E85 501D 0B6A 476D 9B39 9CF9 AF9D 7956 0500

To claim this, I am signing this object:

@johnweldon
johnweldon / crash.log
Created October 24, 2016 23:41
2016/10/24 23:09:18 [INFO] Terraform version: 0.7.7
2016/10/24 23:09:18 [INFO] CLI args: []string{"/usr/local/Cellar/terraform/0.7.7/bin/terraform", "state", "show"}
2016/10/24 23:09:18 [DEBUG] Detected home directory from env var: /Users/weldon
2016/10/24 23:09:18 [DEBUG] Detected home directory from env var: /Users/weldon
2016/10/24 23:09:18 [DEBUG] Attempting to open CLI config file: /Users/weldon/.terraformrc
2016/10/24 23:09:18 [DEBUG] File doesn't exist, but doesn't need to. Ignoring.
2016/10/24 23:09:18 [DEBUG] Detected home directory from env var: /Users/weldon
2016/10/24 23:09:18 [TRACE] Preserving existing state lineage "bd67628c-5cf1-46c6-adb0-036a829b75e1"
2016/10/24 23:09:18 [TRACE] Preserving existing state lineage "bd67628c-5cf1-46c6-adb0-036a829b75e1"
2016/10/24 23:09:18 [DEBUG] plugin: waiting for all plugin processes to complete...
@johnweldon
johnweldon / update_dynamic_dns
Created March 4, 2018 05:42
bash script to update dynamic dns ip address on google domains from a Zyxel C3000Z modem
#!/usr/bin/env bash
#
# Update Google Domains Dynamic DNS from Zyxel C3000Z modem information.
# Tested on a Centurylink issued modem, YMMV
#
# See https://support.google.com/domains/answer/6147083?hl=en for
# Google Domains help and credentials information
#
@johnweldon
johnweldon / exception.txt
Created March 13, 2018 17:15
13-Mar-2018 15:19:18.744 INFO [http://stage.cacurrent.net/rest/job] org.apache.catalina.core.ApplicationContext.log RestletServlet: [Restlet] ServerServlet: component class is null
13-Mar-2018 17:01:18.624 SEVERE [ContainerBackgroundProcessor[StandardEngine[Catalina]]] org.apache.catalina.core.StandardContext.listenerStart Exception sending context initialized event to listener instance of class [org.xwiki.container.servlet.XWikiServletContextListener]
java.lang.ClassCastException: org.xwiki.environment.internal.StandardEnvironment cannot be cast to org.xwiki.environment.internal.ServletEnvironment
at org.xwiki.container.servlet.XWikiServletContextListener.contextInitialized(XWikiServletContextListener.java:85)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4579)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5041)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catal