Skip to content

Instantly share code, notes, and snippets.

View iversond's full-sized avatar

Dan Iverson iversond

View GitHub Profile
@iversond
iversond / installPodman.sh
Created October 31, 2023 12:57
Script to install and configure rootless Podman on OEL 8
View installPodman.sh
#! /bin/bash
function echoinfo() {
local GC="\033[1;32m"
local EC="\033[0m"
printf "${GC} ☆ INFO${EC}: %s${GC}\n${EC}" "$@";
}
function echoerror() {
local RC="\033[1;31m"
@iversond
iversond / refresh.sql
Created September 12, 2023 19:26
Useful PeopleSoft Refresh SQL Statements - not a full list, but common and unique statements that have helped me improve the refresh process.
View refresh.sql
-- -----------
-- System Name
-- -----------
-- Persist the GUID across refreshes - used by the EMF Hub
UPDATE sysadm.psoptions
SET
guid = '<static guid>',
shortname = '<DBNAME>',
longname = '<Application> <Environment>',
systemtype = '<XLAT Types>',
@iversond
iversond / renameIBnodes.sql
Created September 12, 2023 19:10
Rename IB nodes from production. Examples show both HR Production and Finance Production nodes renamed.
View renameIBnodes.sql
-- -------------------------
-- Rename Default Local Node
-- -------------------------
-- Rename IB Nodes
UPDATE sysadm.psmsgnodedefn
SET
msgnodename = 'HNONPROD',
authoptn = 'P',
@iversond
iversond / refreshtables.sql
Created September 12, 2023 16:02
PS Refresh Tables - rough list
View refreshtables.sql
-- System Base Tables
ps.psdbowner
sysadm.psstatus
sysadm.psstatus
sysadm.psoprdefn
sysadm.psaccessprfl
sysadm.psaccessprofile
sysadm.psoptions
-- Branding
@iversond
iversond / prebuild_cache.sh
Created September 1, 2023 15:01
Sample bash functions to prebuild cache and then copy to each PSAPPSRV_n folder
View prebuild_cache.sh
function run_loadcache(){
if [[ ${RESET} == 'true' ]]; then
echoinfo "Removing previous cache"
rm -rf ${PS_SERVDIR}/CACHE/1/*.DAT
rm -rf ${PS_SERVDIR}/CACHE/1/*.KEY
rm -rf ${PS_SERVDIR}/CACHE/STAGE/stage/*.DAT
rm -rf ${PS_SERVDIR}/CACHE/STAGE/stage/*.KEY
fi
View ca-apply-ptp.ps1
#-----------------------------------------------------------[Parameters]----------------------------------------------------------
[CmdletBinding()]
Param(
[Parameter(Mandatory=$true)][String]$DATABASE,
[Parameter(Mandatory=$true)][String]$PT_VERSION,
[Parameter()][String]$CA_PATH = "C:\Program Files\PeopleSoft\Change Assistant"
)
#------------------------------------------------------------[Variables]----------------------------------------------------------
View create-ca-env.ps1
#-----------------------------------------------------------[Parameters]----------------------------------------------------------
[CmdletBinding()]
Param(
[Parameter(Mandatory=$true)][String]$ACCESS_ID,
[Parameter(Mandatory=$true)][String]$ACCESS_PWD,
[Parameter(Mandatory=$true)][String]$CONNECT_ID,
[Parameter(Mandatory=$true)][String]$CONNECT_PWD,
[Parameter(Mandatory=$true)][String]$OPR_ID,
[Parameter(Mandatory=$true)][String]$OPR_PWD,
View ps-hide-signon.js
/* Toggle Login */
function hideLogin(isHidden) {
if (isHidden) {
document.getElementsByClassName('ps_signinentry')[0].style.display = "none";
document.getElementById('maint-mode').style.display = "block";
} else {
document.getElementsByClassName('ps_signinentry')[0].style.display = "block";
document.getElementById('maint-mode').style.display = "none";
}
}
View applyPT860.ps1
<#PSScriptInfo
.SYNOPSIS
Apply the PeopleTools 8.60 Upgrade Project
.DESCRIPTION
Automate the Change Assistant job that applies the PTU860 project to a database.
.PARAMETER DATABASE
Which database to encrypt the password
.PARAMETER PT_VERSION
PeopleTools version to apply
.PARAMETER CA_BASE
@iversond
iversond / upgrade_acl.yaml
Created October 5, 2022 12:24
Rundeck ACL to allow access to the "Upgrade" folder
View upgrade_acl.yaml
description: System-level read access
context:
application: rundeck
for:
project:
- allow: '.*' # allow view/admin of all projects
system:
- match:
name: '.*'
allow: [read,write,run,kill]