Skip to content

Instantly share code, notes, and snippets.

View iversond's full-sized avatar

Dan Iverson iversond

View GitHub Profile
iversond /
Last active May 3, 2024 15:20
Script to prepare a pt_osk.config file and encrypt passwords
echo "Copy OSK zip file to /tmp"
cp OSK*.zip /tmp/
cd /tmp && unzip -o OSK*.zip > /dev/null 2>&1
echo "Extract JDK and OS archives to encrypt password"
cd archives
if [[ -f jdk/README.* ]]; then
iversond /
Last active May 2, 2024 13:07
Prepare a host server to run PeopleSoft Containers with Podman
# Configure current user for rootless containers
echo "${USER}:231072:65536" | sudo tee -a "/etc/subuid"
echo "${USER}:231072:65536" | sudo tee -a "/etc/subgid"
/bin/systemctl --user daemon-reload
podman system migrate
# Configure container.conf
sudo cp "/usr/share/containers/containers.conf" "/etc/containers"
sudo sed -i 's/network_backend = "cni"/network_backend = "netavark"/g' "/etc/containers/containers.conf"
sudo sed -i 's/#stop_timeout = 10/stop_timeout = 90/g' "/etc/containers/containers.conf"
iversond / applyPTPatch.ps1
Last active May 4, 2024 04:42
Sample script to apply PATCH861 to database silently
# $env:PSCADBG="true"
iversond / conf.html
Last active May 17, 2024 15:59
psadmin.conf Lab Environment Homepage
@import url('|Lato|Roboto');
@font-face {
font-family: 'Interstate';
src: url('_images/interstate-black.ttf') format('truetype');
font-weight: normal;
font-style: normal;
iversond /
Created October 31, 2023 12:57
Script to install and configure rootless Podman on OEL 8
#! /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 / 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.
-- -----------
-- System Name
-- -----------
-- Persist the GUID across refreshes - used by the EMF Hub
UPDATE sysadm.psoptions
guid = '<static guid>',
shortname = '<DBNAME>',
longname = '<Application> <Environment>',
systemtype = '<XLAT Types>',
iversond / renameIBnodes.sql
Last active April 24, 2024 15:00
Rename IB nodes from production. Examples show both HR Production and Finance Production nodes renamed.
-- -------------------------
-- Rename Default Local Node
-- -------------------------
-- Rename IB Nodes
UPDATE sysadm.psmsgnodedefn
msgnodename = 'HNONPROD',
authoptn = 'P',
iversond / refreshtables.sql
Created September 12, 2023 16:02
PS Refresh Tables - rough list
-- System Base Tables
-- Branding
iversond /
Created September 1, 2023 15:01
Sample bash functions to prebuild cache and then copy to each PSAPPSRV_n folder
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
[Parameter()][String]$CA_PATH = "C:\Program Files\PeopleSoft\Change Assistant"