Skip to content

Instantly share code, notes, and snippets.

View iversond's full-sized avatar

Dan Iverson iversond

View GitHub Profile
@iversond
iversond / user_data.ps1
Created May 6, 2020 14:19
.conf 2020 user provisioning script
# Escape any variables that are not passed by Terraform ($$)
$hostname = "${hostname}"
# Set NODENAME Env Var
[Environment]::SetEnvironmentVariable("NODENAME", $hostname)
[Environment]::SetEnvironmentVariable("NODENAME", $hostname, [System.EnvironmentVariableTarget]::Machine)
# Add hosts Entry
# This is needed so the pt_pia status checking works
# The cloned instance does not update hosts, so we do it ourselves
@iversond
iversond / disable_prcs_pn.sql
Created December 17, 2019 20:36
Disable Process Scheduler Push Notifications
-- Remove PRCS Request Submitted notifications
update sysadm.PSPTPNCOLLEVTS set event_name = ' ' where PTPNCOLLNAME = 'PRCSPTPNCOLLECTION';
commit;
-- Validation: Collection PRCSPTPNCOLLECTION should have no event_name set
select * from sysadm.PSPTPNCOLLEVTS where PTPNCOLLNAME = 'PRCSPTPNCOLLECTION';
@iversond
iversond / .bashrc
Created December 9, 2019 15:47
Cloud Manager profile
# Source global definitions
if [ -f /etc/bashrc ]; then
. /etc/bashrc
fi
# User specific aliases and functions
PATH=$PATH:/opt/puppetlabs/puppet/bin; export PATH
if tput setaf 1 &> /dev/null; then
@iversond
iversond / fixdpkbug.pp
Last active July 9, 2021 17:15
Fix a DPK bug that prevents non-ACM app engines from running. This manifest expects the puppetlabs-powershell modules to be installed.
$dpk_location = hiera('dpk_location')
case $::osfamily {
'windows': {
exec { 'fix-dpk-bug':
command => "(gc ${dpk_location}/puppet/production/modules/pt_config/lib/puppet/provider/psae.rb) | %{ \$_ -replace \"ae_program_name=`\"PTEM_CONFIG`\"\", \"ae_program_name=resource[:program_id]\" } | set-content ${dpk_location}/puppet/production/modules/pt_config/lib/puppet/provider/psae.rb",
provider => powershell,
}
}
'RedHat', 'linux': {
@iversond
iversond / loadcache.pp
Last active November 21, 2021 00:55
This manifest can be used to run the LOADCACHE job on a fresh PeopleSoft Image. In your `psft_customizations.yaml` file, add `Cache Settings/ServerCacheMode: 1` to the app server `config_settings` section. This manifest expects the puppetlabs-powershell modules to be installed.
$ps_home_dir = hiera('ps_home_location')
$oracle_home_location = hiera('oracle_server_location')
$tns_dir = hiera('tns_dir')
case $::osfamily {
'windows': {
$gem_home = 'c:/program files/puppet labs/puppet/bin'
exec { 'install-psadmin_plus':
command => "${gem_home}/gem install psadmin_plus",
provider => 'powershell'
@iversond
iversond / shell_template.sh
Last active February 21, 2022 18:45
Shell script template to use when creating new scripts. Borrows work from JR Bing's provision.sh in ps-vagabond
#!/usr/bin/env bash
# shellcheck disable=2059,2154,2034,2155,2046,2086
#===============================================================================
# vim: softtabstop=2 shiftwidth=2 expandtab fenc=utf-8 spelllang=en ft=sh
#===============================================================================
#
# FILE: shell_template.sh
#
# USAGE: ./shell_template.sh
#
@iversond
iversond / slack_history.py
Created August 11, 2019 03:23 — forked from minniel/slack_history.py
Download Slack Channel/PrivateChannel/DirectMessage History
from slacker import Slacker
import json
import argparse
import os
import shutil
import copy
from datetime import datetime
# This script finds all channels, private channels and direct messages
# that your user participates in, downloads the complete history for
<?
/////////////////////
// slack2html
// by @levelsio
/////////////////////
//
/////////////////////
// WHAT DOES THIS DO?
/////////////////////
//
@iversond
iversond / psft.sh
Created July 14, 2019 20:01
David's Kurtz's wrapper script - using bash instead of ksh - http://www.go-faster.co.uk/scripts/psft.sh
#!/bin/bash
# (c) David Kurtz 2007
# Script: psft.sh
#
# Syntax: psft.sh DBNAME ACCESSID ACCESSPSWD PRCSINSTANCE
# where
# DBNAME is the name of the PeopleSoft datbase with a corresponding TNS entry
# ACCESSID is the schema containing the PeopleSoft database
# ACCESSPSWD is the password to ACCESSID
# PRCSINSTANCE is the process instance number supplied by PeopleSoft
@iversond
iversond / shell_sample.sh
Last active July 14, 2019 19:59
A sample shell script to test the psft.sh wrapper (from David Kurtz: http://blog.psftdba.com/2017/02/process-scheduler-shell-script.html)
#!/bin/bash
#A silly script to test psft.sh
#(c) David Kurtz 2017
if [ "$PSPRCSLOGDIR" ] ; then
cd $PSPRCSLOGDIR
fi
(
while [ $# -gt 0 ]