mikegreen

-- sample row
SELECT FIRST CONFNUM, [INTERN NUM], RESERVESTATUS, CHECKIN, CHECKOUT, NIGHTS, BEDTYPE,
                                        [RATE REQ], GROUPCODE, EMAIL, PREFIX, LASTNAME, FIRSTNAME, STREET, CITY, STATE,
                                        ZIPCODE, COUNTRY, PHONE1, ADULTS, CHILD, ROOMRATE, ENDRATE, VIPNUMBER,
                                        HOUSENOTE, NOC, MADEBY, ENTEREDBY, ENTRYDATE, ENTRYTIME,
                                        CAST(CAST(ENTRYDATE AS VARCHAR(20)) + ' ' + CAST(ENTRYTIME AS VARCHAR(20)) AS DATETIME) as ENTRYTIMESTAMP,
                                        CHANGEDATE, CHANGETIME,
                                        CAST(CAST(CHANGEDATE AS VARCHAR(20)) + ' ' + CAST(CHANGETIME AS VARCHAR(20)) AS DATETIME) as CHANGETIMESTAMP,
                                        CXLNUM,
                                        CASE

mikegreen

Keybase proof

I hereby claim:

• I am mikegreen on github.
• I am mikegreenhc (https://keybase.io/mikegreenhc) on keybase.
• I have a public key ASAXCx-MMORzDP1bz5-lzpxfPhDOjzT9eWwoDiscjP505wo

To claim this, I am signing this object:

mikegreen

#!/bin/bash
# supports https://docs.google.com/document/d/1N-5cyHh2YYwvtq5ntw0lKZ4MH_YvVatVqAd3nKu_9-Y/edit?usp=sharing
cd /home/ec2-user/forum-work/pnp_forum
git pull
sudo rm -r -f /var/www/html/forum/cache/
sudo cp -r ./ /var/www/html/forum

mikegreen

#!/bin/bash
# supports https://docs.google.com/document/d/1N-5cyHh2YYwvtq5ntw0lKZ4MH_YvVatVqAd3nKu_9-Y/edit#
cd /home/ec2-user/forum-work/pnp_maps
git pull
cd maps_more
sudo cp -r ./mapsmore* /var/www/html/maps_more

mikegreen

#
# This file loads most of the modules included with the Apache HTTP
# Server itself.
#

#LoadModule access_compat_module modules/mod_access_compat.so
#LoadModule actions_module modules/mod_actions.so
LoadModule alias_module modules/mod_alias.so
#LoadModule allowmethods_module modules/mod_allowmethods.so
#LoadModule auth_basic_module modules/mod_auth_basic.so

mikegreen

gpg --keyserver pool.sks-keyservers.net --recv-key 1285491434D8786F
gpg -a --export 1285491434D8786F | sudo apt-key add -
echo 'deb http://linux.dell.com/repo/community/openmanage/932/bionic bionic main' | sudo tee -a /etc/apt/sources.list.d/linux.dell.com.sources.list
apt-get update

mikegreen

#!/bin/bash
# this was shared by Nick on the Vault gg, all credit to him
# https://groups.google.com/d/msg/vault-tool/hmejXvIFuOU/M3bKDKFBBwAJ

# Test Vault migration from consul to raft.

# Dependencies: vault, consul, nc (netcat)
# Writes to (and blows away) ~/migrate_consul_to_raft.
# Kills any running vault or consul processes.
# Tested on MacOS and Linux.

mikegreen

#!/bin/bash
#Count TFE Metrics
#Requires TFE_TOKEN environment variable to be set to site admin api token

#Check for TFE_TOKEN
if [ -n "$TFE_TOKEN" ]; then
    echo "----------------------------------"
    echo "TFE Token detected!"
    echo "----------------------------------"
else

mikegreen

# vault_config.hcl 
# to start: $ vault server -config=vault_raft.hcl
ui=true
disable_mlock = true
storage "raft" {
 path = "/opt/vault/"
 node_id = "raft_01"
}
listener "tcp" {
 address = "127.0.0.1:8200"

mikegreen

# 2020-06-23 
# this shows creating a Vault instance running integrated storage/raft, 
# then adding a KV and taking a snapshot
# then kill the raft DB files to simulate a storage failure
# repeat new Vault instance, restore snapshot, unseal and auth with orig keys
# and read some data to show how backup/restore works

# not meant to be a live script to run!
# this uses the vault_config.hcl from https://gist.github.com/mikegreen/c2df5eea2283f0dbc5f3a5d3650536fd