Skip to content

Instantly share code, notes, and snippets.

View iversond's full-sized avatar

Dan Iverson iversond

View GitHub Profile
@iversond
iversond / psadmin.conf.2017.yaml
Last active September 7, 2017 12:43
psadmin.conf 2017
---
title: 'psadmin.conf'
description: 'The first conference for PeopleSoft Administrators.'
long_description: >
psadmin.conf is a 1 day 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 make you a better admin.
location: 'University of Minnesota (West Bank Office Building)'
address: '1300 2nd Street S, Minneapolis, MN, 55455'
$env:kibana_home = "c:\elastic\kibana"
Set-Location $env:kibana_home
.\bin\kibana
Start-Process -FilePath c:\ProgramData\chocolatey\bin\nssm.exe -ArgumentList 'install kibana-5.6.3 "C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe" "-command "& { c:\elastic\kibana\bin\startKibana.ps1 }"" ' -NoNewWindow -Wait
Start-Process -FilePath c:\ProgramData\chocolatey\bin\nssm.exe -ArgumentList 'install logstash-5.6.3 "C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe" "-command "& { c:\elastic\logstash\bin\startLogstash.ps1 }"" ' -NoNewWindow -Wait
$env:logstash_home = "c:\elastic\logstash"
cd $env:logstash_home
.\bin\logstash -f .\pipeline.conf -r -l .\logs\logstash.log --config.reload.automatic
@iversond
iversond / SearchDefnSecurity.sql
Created November 10, 2017 19:20
SQL to resolve query access security issues with Search Definitions
-- 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'));
$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}\""
}
@iversond
iversond / app.rb
Created March 2, 2018 20:17
Custom facter fact to return the first 2 characters as the Fact `app`
Facter.add(:app) do
setcode do
app = Facter.value(:hostname)[0..1]
if app.downcase.match(/lm/)
app = "hr"
end
app.downcase
end
@iversond
iversond / fixRubyGems.ps1
Created March 26, 2018 00:17
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/
$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 April 23, 2018 18:56
psadmin.conf 2018 Session Descriptions

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