Skip to content

Instantly share code, notes, and snippets.

View iversond's full-sized avatar

Dan Iverson iversond

View GitHub Profile
@iversond
iversond / conf.html
Last active January 16, 2024 04:52
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
Created September 12, 2023 19:10
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
#-----------------------------------------------------------[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]----------------------------------------------------------
#-----------------------------------------------------------[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,
/* 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";
}
}
<#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