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 / ppm.sql
Created May 1, 2017 19:08
Turn off PPM
update psadm.psurldefn set url = 'LOCAL'
where url_id = 'PPM_MONITOR';
update psadm.psurldefn set url = 'LOCAL'
where url_id = 'PPM_PPMI';
@iversond
iversond / PUMManualUpload.sql
Created May 24, 2017 13:56
SQL to manually upload an environment into a PeopleSoft Image and make it accessible in the Update Manager Dashboard.
insert into PS_PTIASPUSERTGTS values ('VP1', 'FS92DEV');
insert into PS_PTIASPTARGETS values ('FS92DEV', ' ', '8.53.10', '8.53', '10', 'ENG');
insert into PS_PTIASPTARGETLNG values ('FS92DEV', 'ENG');
-- REM INSERTING into PS_PTIASPLOGTGT;
Insert into PS_PTIASPLOGTGT (DBNAME,PTIASPRPTNO,PTIASPPKGAPPLYDT) values ('FS92DEV',16245533,to_timestamp('29-MAR-14','DD-MON-RR HH.MI.SSXFF AM'));
@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'
@iversond
iversond / sample_acm_customizations.yaml
Created July 24, 2017 12:44
Sample psft_customizations.yaml file using the ACM to configure Elasticsearch
component_postboot_setup_list:
searching:
run_control_id: searching
os_user: "%{hiera('domain_user')}"
db_settings:
db_name: "%{hiera('db_name')}"
db_type: "%{hiera('db_platform')}"
db_opr_id: "%{hiera('db_user')}"
db_opr_pwd: "%{hiera('db_user_pwd')}"
@iversond
iversond / custom_web_profile.pp
Created July 28, 2017 13:31
Puppet manifest to update the WebProfile in configuration.properties
$pia_domain_list = hiera('pia_domain_list')
if $pia_domain_list {
$pia_domain_list.each |$domain_name, $pia_domain_info| {
$baseWebPath = "${pia_domain_info['ps_cfg_home_dir']}\\webserv\\${domain_name}\\applications\\peoplesoft\\PORTAL.war"
$root_signon_url = $pia_domain_info['root_signon_url']
$pia_site_list = $pia_domain_info['site_list']
$pia_site_list.each |$site_name, $site_info| {
@iversond
iversond / response.cfg
Created August 15, 2017 21:11
Sample 8.56 DPK Bootstrap Response File
psft_base_dir = "c:/psft"
env_type = "fulltier"
db_name = "PSFTDB"
db_service_name = "PSFTDB"
db_host = "localhost"
admin_pwd = "Passw0rd#"
connect_pwd = "peop1e"
access_pwd = "SYSADM"
opr_pwd = "PS"
# domain_conn_pwd = "P@ssw0rd#"
@iversond
iversond / installKibanaService.ps1
Last active October 17, 2017 15:13
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
@iversond
iversond / startKibana.ps1
Last active October 17, 2017 15:05
$env:kibana_home = "c:\elastic\kibana"
Set-Location $env:kibana_home
.\bin\kibana
@iversond
iversond / startLogstash.ps1
Last active October 20, 2017 12:27
$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 / installLogstashService.ps1
Last active October 20, 2017 12:25
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