Skip to content

Instantly share code, notes, and snippets.

View ceesco53's full-sized avatar

John Nelson ceesco53

6 followers · 1 following
View GitHub Profile
@ceesco53
ceesco53 / haproxy-bosh-manifest.yml
Created July 26, 2023 17:03
HA Proxy BOSH deploy yaml for version 12.1.0+2.7.7
addons:
- jobs:
- name: bpm
release: bpm
name: bpm
instance_groups:
- azs:
- az1
instances: 1
jobs:
@ceesco53
ceesco53 / tkg-setup-elk-docker.sh
Created August 16, 2021 18:49
curl -XPOST -D- 'http://localhost:5601/api/saved_objects/index-pattern' \
-H 'Content-Type: application/json' \
-H 'kbn-version: 7.14.0' \
-u elastic:<changeme> \
-d '{"attributes":{"title":"logstash-*","timeFieldName":"@timestamp"}}'
@ceesco53
ceesco53 / patterns.grok
Created August 12, 2021 18:18
GROK PATTERNS
# crashd log analysis
# I0802 01:01:28.711691 1 server.go:618] external host was not specified, using 10.252.43.236
(?<severity>.{1})%{MONTHNUM:month}%{MONTHDAY:day}%{SPACE}%{TIME:time}%{SPACE}%{NUMBER:number}%{SPACE}(?<filename>\b\w+\.?\w*):%{NUMBER:linenum}]%{SPACE}%{GREEDYDATA:message}
@ceesco53
ceesco53 / backup.sh
Last active November 8, 2019 01:50 — forked from zmb3/backup.sh
Backup/Restore Concourse DB
# from Concourse DB VM:
# /var/vcap/packages/postgres-9.6.8/bin/psql -U vcap -d atc
# \l
# backup
cd /var/vcap/packages/postgres-9.6.8/bin
./pg_dump -U vcap -d atc --format=c --schema-only --file=concourse-schema.sql
./pg_dump -U vcap -d atc --format=c --data-only --file=concourse-data.sql
# restore
@ceesco53
ceesco53 / gist:28c060e68824d0275e57095f783b722e
Created October 17, 2019 15:09
cf.json
{
"client_id": "sso-temp-cf-client",
"client_secret": "'${CF_CLI_CLIENT_SECRET}'",
"authorized_grant_types": ["client_credentials"],
"authorities": ["cloud_controller.admin"],
"access_token_validity": 1209600,
"refresh_token_validity": 1209600
}

@ceesco53
ceesco53 / bloat sql
Created September 27, 2019 13:52
bloat checker
WITH constants AS (
SELECT current_setting('block_size')::numeric AS bs, 23 AS hdr, 4 AS ma
), bloat_info AS (
SELECT
ma,bs,schemaname,tablename,
(datawidth+(hdr+ma-(case when hdr%ma=0 THEN ma ELSE hdr%ma END)))::numeric AS datahdr,
(maxfracsum*(nullhdr+ma-(case when nullhdr%ma=0 THEN ma ELSE nullhdr%ma END))) AS nullhdr2
FROM (
SELECT
schemaname, tablename, hdr, ma, bs,
@ceesco53
ceesco53 / jmeter-tornado-mode.yml
Last active June 24, 2019 20:29
jmeter-tornado.yml
---
name: jmeter-tornado
releases:
- name: jmeter-tornado
version: 2.1.1
url: git+https://github.com/jamlo/jmeter-bosh-release
stemcells:
- alias: default
@ceesco53
ceesco53 / error
Created May 12, 2017 15:02
Hash: 347cee980a7f9c95a72a
Version: webpack 2.2.1
Time: 3977ms
Asset Size Chunks Chunk Names
bundle.js 1.62 MB 0 [emitted] [big] main
bundle.js.map 2.05 MB 0 [emitted] main
assets/icons.svg 3.34 kB [emitted]
[5] ./~/react/react.js 56 bytes {0} [built]
[6] ./lib/utils/plugins.js 9.34 kB {0} [built]
[18] ./lib/rpc.js 57 bytes {0} [built]
@ceesco53
ceesco53 / moonlight.conf
Created December 3, 2015 00:25
arm_freq=900 sdram_freq=450 over_voltage_avs=0x1b774 hdmi_drive=2 hdmi_force_hotplug=1 disable_overscan=1 framebuffer_width=1920 framebuffer_height=1080 framebuffer_depth=16 disable_l2cache=1 program_serial_random=1 config_hdmi_boost=4 disable_commandline_tags=2 emmc_pll_core=1 hdmi_ignore_edid=0xa5000080 hdmi_force_cec_address=65535 ignore_lcd=1 framebuffer_ignore_alpha=1 framebuffer_swap=1 disable_splash=1 arm_control=0xa5800010 temp_limit=85 force_pwm_open=1 pause_burst_frames=1 second_boot=1 avoid_fix_ts=1
@ceesco53
ceesco53 / moonlight-pi-install.sh
Last active December 3, 2015 00:21
sudo apt-get install libasound2-dev libopus-dev cec-utils libevdev-tools libevdev-dev libudev-dev libcurl4-openssl-dev libssl-dev libavahi-client-dev build-essential libcec3 libcec-dev libcec-platform1v5
git clone https://github.com/irtimmer/moonlight-embedded.git
cd moonlight-embedded
git submodule init && git submodule update
mkdir build
cd build
cmake ../
make
sudo make install
sudo echo '/usr/local/lib' > /etc/ld.so.conf.d/moonlight.conf