Skip to content

Instantly share code, notes, and snippets.

Dan Iverson iversond

Block or report user

Report or block iversond

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@iversond
iversond / domains.yaml
Last active Sep 18, 2019
Default domain configuration for the DPK. Used with Hiera Hashing to allow environments to overrride/add to the defaults
View domains.yaml
---
# TNSnames.ora
tns_admin_list:
"%{hiera('db_name')}":
db_host: "%{hiera('db_server')}"
db_port: "%{hiera('db_port')}"
db_protocol: TCP
db_service_name: "%{hiera('db_name')}.psadmin.io"
# Application Servers
@iversond
iversond / common.yaml
Created Jan 22, 2019
Common configuration shared across all DPK environments
View common.yaml
---
ensure: present
env_type: midtier
server_type: "%{::ps_role}"
domain_type: "%{::ps_role}"
region: "%{::region}"
peoplesoft_base: c:/psft
peoplesoft_base_norm: "c:\\psft"
unicode_db: false
@iversond
iversond / applyPT856Upgrade.ps1
Created Aug 31, 2018
Powershell script to run the PeopleTools 8.56 Upgrade job headlessly. A few assumptions with the script: All manual steps are marked as complete.; your PT Client installs are at c:\client-8.xx.xx
View applyPT856Upgrade.ps1
<#PSScriptInfo
.SYNOPSIS
Apply the PeopleTools 8.56 Upgrade Project
.DESCRIPTION
Automate the Change Assistant job that applies the PTU856 project to a database.
.PARAMETER DATABASE
Which database to encrypt the password
.PARAMETER PT_VERSION
PeopleTools version to apply
.PARAMETER CA_BASE
@iversond
iversond / fixRubyGems.ps1
Created Mar 26, 2018
Script to download the updated CA file to RubyGems on Windows will work. From the blog post: http://wragg.io/using-puppet-modules-forge-and-r10k/
View fixRubyGems.ps1
$CACertFile = Join-Path -Path $ENV:AppData -ChildPath 'RubyCACert.pem'
If (-Not (Test-Path -Path $CACertFile)) {
"Downloading CA Cert bundle.."
[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
Invoke-WebRequest -Uri 'https://curl.haxx.se/ca/cacert.pem' -UseBasicParsing -OutFile $CACertFile | Out-Null
}
"Setting CA Certificate store set to $CACertFile.."
$ENV:SSL_CERT_FILE = $CACertFile
@iversond
iversond / psadmin.conf.2018.md
Last active Apr 23, 2018
psadmin.conf 2018 Session Descriptions
View psadmin.conf.2018.md

Implementing DPK To Build PeopleSoft Servers at Capella University

Peyton Colburn

(Sunday Session)

This session will cover seven lessons we learned from implementing the Deployment Packages. We will discuss how we got management buy-in, how we work collaboratively on the DPK, what resourses we used to learn Puppet, how we structured our Hiera data, and how to bring the entire PS Admin team up to speed.

Running a PeopleSoft Elasticsearch Cluster on Kubernetes

@iversond
iversond / app.rb
Created Mar 2, 2018
Custom facter fact to return the first 2 characters as the Fact `app`
View app.rb
Facter.add(:app) do
setcode do
app = Facter.value(:hostname)[0..1]
if app.downcase.match(/lm/)
app = "hr"
end
app.downcase
end
View psadmin.conf.2018.yaml
---
title: 'psadmin.conf'
version: '2018'
description: 'The only conference for PeopleSoft Administrators.'
long_description: >
psadmin.conf is a conference specifically for PeopleSoft Administrators.
The conference features talks from expert admins on a variety of topics.
The goal of the conference is to expand your knowledge of PeopleSoft
Administration and network with admins from around the country.
@iversond
iversond / enableRubyGems.ps1
Last active Nov 22, 2017
For DPK installations on Windows, this script will fix the RubyGems CA issue and add the Puppet-based RubyGems location to `PATH`
View enableRubyGems.ps1
# Enable RubyGems
#
# The RubyGems included with the DPK can't download from RubyGems.org due to an oudated SSL Certificate
#
# invoke-webrequest https://gist.githubusercontent.com/iversond/e56e608cf8fa65f7160416f4c434da57/raw/5e8cc944ad8a4c261a7eff44cdf4413e4a826b12/enableRubyGems.ps1 -outfile $env:TEMP\enableRubyGems.ps1; . $env:TEMP\enableRubyGems.ps1
#
$puppetGemFolder = Resolve-Path 'C:\Program Files\Puppet Labs\Puppet\sys\ruby\lib\ruby\*\rubygems\ssl_certs\'
Invoke-WebRequest https://raw.githubusercontent.com/rubygems/rubygems/master/lib/rubygems/ssl_certs/index.rubygems.org/GlobalSignRootCA.pem -OutFile $puppetGemFolder\RubyGemsCA.pem
@iversond
iversond / SearchDefnSecurity.sql
Created Nov 10, 2017
SQL to resolve query access security issues with Search Definitions
View SearchDefnSecurity.sql
-- Shows records in a Search Definition
select recname from PSQRYRECORD where qryname in (
select qrynamechild from PSCONQRSMAP where CONQRSNAME in (
select PTSF_SOURCE_NAME from psptsf_sd where PTSF_SBO_NAME = 'SEARCH_DEFINITION_NAME'));
-- Shows query access groups a user as permission to access
select tree_name, access_group from ps_scrty_acc_grp where tree_name like 'SEARCH%' and classid in (
select classid from psroleclass where rolename in (
select rolename from psroleuser where roleuser = 'USERNAME'));
View piaWinServiceUser.pp
$domain_user = hiera('domain_user', undef)
$domain_password = hiera('domain_password', undef)
$pia_domain_list = hiera_hash('pia_domain_list')
$pia_domain_list.each |$domain_name, $pia_domain_info| {
$ps_cfg_home_dir_norm = normalize_path($pia_domain_info['ps_cfg_home_dir'])
exec { "${domain_name}-user":
command => "C:\\Windows\\System32\\cmd.exe /c sc.exe config \"PsftPIADomain${domain_name}Service\" obj= \"${domain_user}\" password= \"${domain_password}\""
}
You can’t perform that action at this time.