Skip to content

Instantly share code, notes, and snippets.

View iversond's full-sized avatar

Dan Iverson iversond

54 followers · 52 following
View GitHub Profile
@iversond
iversond / prepareOSKresponse.sh
Last active May 3, 2024 15:20
Script to prepare a pt_osk.config file and encrypt passwords
start_loc=$(pwd)
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
iversond / preparePodman.sh
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
iversond / applyPTPatch.ps1
Last active May 4, 2024 04:42
Sample script to apply PATCH861 to database silently
#$env:PS_HOME='c:\PT8.61.02_Client_ORA'
$env:PS_HOME='c:\PT8.61.03_Client_ORA'
$env:PT_REL='8'
$env:PT_VER='61'
$env:ORACLE_HOME='C:\psft\pt\oracle-client\19.3.0.0'
$env:DB="FSCMCON"
# $env:PSCADBG="true"
$env:PATH="${env:PS_HOME}\bin\client\winx86;${env:PATH}"
@iversond
iversond / conf.html
Last active May 3, 2024 13:56
psadmin.conf Lab Environment Homepage
<html>
<style>
@import url('https://fonts.googleapis.com/css?family=Inconsolata|Lato|Roboto');
@font-face {
font-family: 'Interstate';
src: url('_images/interstate-black.ttf') format('truetype');
font-weight: normal;
font-style: normal;
}
@iversond
iversond / installPodman.sh
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
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
SET
guid = '<static guid>',
shortname = '<DBNAME>',
longname = '<Application> <Environment>',
systemtype = '<XLAT Types>',
@iversond
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
SET
msgnodename = 'HNONPROD',
authoptn = 'P',
@iversond
iversond / refreshtables.sql
Created September 12, 2023 16:02
PS Refresh Tables - rough list
-- 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
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
@iversond
iversond / ca-apply-ptp.ps1
Created May 5, 2023 14:59
#-----------------------------------------------------------[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]----------------------------------------------------------