Skip to content

Instantly share code, notes, and snippets.

View sodre's full-sized avatar

Patrick Sodré sodre

  • ZeroAE LLC
  • Bethesda, MD
View GitHub Profile
@sodre
sodre / pkcs12_as_pem.py
Last active December 3, 2015 09:35
PKCS#12 to PEM Converter Context
class context:
def __init__(self, pkcs12, password=None, separate_key=False):
from OpenSSL.crypto import load_pkcs12
from getpass import getpass
from os.path import basename
if not password:
prompt = '{} Password: '.format(basename(pkcs12))
password = getpass(prompt)
with open(pkcs12, 'rb') as f:
self.__p12 = load_pkcs12(f.read(), password)
@sodre
sodre / cartesian_job.py
Created November 30, 2015 13:15
The start of a cartesian job runner.
def partition(start, end, step):
'''
Partitions the interval [start, end) into 'k' intervals [a_i, a_{i+1}).
'''
from itertools import takewhile, chain, islice, tee
# itertools.count does not work with datetime.
def count(firstval=0, step=1):
x = firstval
while 1:
$ ac_cv_header_sys_ucred_h=no ../postgres-xl/configure \
--with-gnu-ld \
--enable-dtrace \
--with-libraries=-lumem \
--with-openssl \
--with-libxml \
--with-libxslt \
--with-ossp-uuid \
--enable-nls
@sodre
sodre / aggregates.out
Created April 4, 2016 02:42
../postgres-xl/configure ac_cv_header_sys_ucred_h=no && make -j2 install && make check
--
-- AGGREGATES
--
SELECT avg(four) AS avg_1 FROM onek;
avg_1
--------------------
1.5000000000000000
(1 row)
SELECT avg(a) AS avg_32 FROM aggtest WHERE a < 100;
@sodre
sodre / stack.gtm.78636
Last active April 4, 2016 03:05
GTM spurious crash during make check
[postgres@pgxl-dev ~/cores/archive]$ mdb -e '::stack' core.gtm.78636
libc.so.1`strlen+0x30(840f0e8, fe6127c8, fe612720, 0, 400, 83fa8a8)
libc.so.1`vsnprintf+0x78(840f4f0, 3ff, 840f0e8, fe6127c8)
appendStringInfoVA+0x47(fe612790, 840f0e8, fe6127c8, 8087060)
elog_finish+0x12c(f, 8086e74, 104fa9dc, 1d299, 34203f40, 1d299)
GTM_HandleGlobalXmin+0x5f2(4, fe61388f, 4fcc, fe613878, fe613ce4, 8415890)
ProcessReportXminCommand+0x93(840ae68, fe613ce4, 0, 0)
GTM_ThreadMain+0xeb0(83f9f98, 83f9f98, 8, fef126c0, 0, fe613fc8)
GTM_ThreadMainWrapper+0x48(83f9f98, 0, 0, 0)
libc.so.1`_thrp_setup+0x88(fec53240)
@sodre
sodre / stack.core.gtm.31850
Created April 4, 2016 03:09
GTM and Coordinator crash during make check.
[postgres@pgxl-dev ~/cores/archive]$ mdb -e '::stack' core.gtm.31850
libc.so.1`strlen+0xb(840f1a8, fe6127c8, fe612720, 0, 400, 83fa968)
libc.so.1`vsnprintf+0x78(840f5b0, 3ff, 840f1a8, fe6127c8)
appendStringInfoVA+0x47(fe612790, 840f1a8, fe6127c8, 8087120)
elog_finish+0x12c(f, 8086f34, bc913569, 1d296, e06239f0, 1d296)
GTM_HandleGlobalXmin+0x5f2(4, fe61388f, 5a21, fe613878, fe613ce4, 8415950)
ProcessReportXminCommand+0x93(840af28, fe613ce4, 0, 0)
GTM_ThreadMain+0xeb0(83fa058, 83fa058, 8, fef126c0, 0, fe613fc8)
GTM_ThreadMainWrapper+0x48(83fa058, 0, 0, 0)
libc.so.1`_thrp_setup+0x88(fec53240)
@sodre
sodre / 0.stack.core.postgres.77690
Last active April 4, 2016 03:32
make check with "--enable-cassert" using serial_schedule instead of parallel.
[postgres@pgxl-dev ~/cores]$ mdb -e '::stack' core.postgres.80981
AllocSetCheck+0x122(87feb90, 87367cc, 9e, 0, 87feb90, 8046b44)
AllocSetDelete+0x14(87feb90, 0, 9e, 0, 8716960, 885c650)
MemoryContextDelete+0x6c(87feb90, 3, 0, 0, 0, 885c650)
MemoryContextDeleteChildren+0x29(885c650, fef0e000, 8046b38, fee8f0b7, 8767794,
885c08c)
MemoryContextDelete+0x33(885c650, 86f7790, 8046b28, 0, 8046b44, 87ac874)
MemoryContextDeleteChildren+0x29(885c08c, 8767794, 8046b58, fee8f122)
AtAbort_Portals+0x96(0, 0, 0, 815f23d, 35363236, 86e0000)
AbortTransaction+0x12d(837e990, 0, 8046f38, 839e1c9, 0, fefce76d)
@sodre
sodre / install.sh
Last active April 4, 2016 05:04 — forked from mattconnolly/install.sh
Pseudo script for installing Jenkins CI on Smart OS. SMF service manifest file included.
#!/bin/pseudo-bash
# Read through this and modify to taste.
# Tested on:
# image_uuid: bad2face-8738-11e2-ac72-0378d02f84de
# smartos base64 1.9.0
#
# jenkins is run as the "admin" user, with its home directory set to /home/admin/jenkins
mkdir ~/jenkins
@sodre
sodre / install-oracle-jdk-smartos.sh
Last active April 5, 2016 03:22 — forked from sr75/wget-jdk-oracle-install-example.txt
wget command to install Oracle JAVA JDK from stupid oracle website for centos and ubuntu
#!/bin/bash
# http://d.stavrovski.net/blog/post/how-to-install-and-setup-oracle-java-jdk-in-centos-6
wget --no-cookies \
--no-check-certificate \
--header "Cookie: oraclelicense=accept-securebackup-cookie" \
"http://download.oracle.com/otn-pub/java/jdk/8u77-b03/server-jre-8u77-solaris-x64.tar.gz" \
-O jdk.tar.gz
mkdir -p /opt/local/java
<?xml version="1.0"?>
<!DOCTYPE service_bundle SYSTEM "/usr/share/lib/xml/dtd/service_bundle.dtd.1">
<!--
Copyright (C) 2007 Paul Oswald
Permission is hereby granted, free of charge, to any person obtaining a copy
of this software and associated documentation files (the "Software"), to deal
in the Software without restriction, including without limitation the rights
to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
copies of the Software, and to permit persons to whom the Software is