Skip to content

Instantly share code, notes, and snippets.

View iversond's full-sized avatar

Dan Iverson iversond

View GitHub Profile
[elasticsearch-2.x]
name=Elasticsearch repository for 2.x packages
baseurl=https://packages.elastic.co/elasticsearch/2.x/centos
gpgcheck=1
gpgkey=https://packages.elastic.co/GPG-KEY-elasticsearch
enabled=1
@iversond
iversond / appConfig.pp
Created December 7, 2016 20:08
Puppet manifest to update App Server config file from psft_customizations.yaml config_settings: section
$ensure = hiera('ensure')
$appserver_domain_list = hiera('appserver_domain_list')
$appserver_domain_list.each |$domain_name, $appserver_domain_info| {
notice("Configuration for AppServer domain ${domain_name}")
$cfgFile = "${appserver_domain_info['ps_cfg_home_dir']}\\appserv\\${domain_name}\\psappsrv.cfg"
$config_settings = $appserver_domain_info['config_settings']
$config_settings.each |$setting, $config_info| {
host {'localapp':
ensure => present,
host => 'localapp',
ip => "${::ipaddress}",
}
$pia_domain_list = hiera('pia_domain_list')
$pia_domain_list.each | $domain_name, $pia_domain_info | {
$ps_cfg_home_dir = $pia_domain_info['ps_cfg_home_dir']
@iversond
iversond / app_dynamic_cfg.pp
Created December 30, 2016 03:44
Uses a custom `dynamic_config:` hash in `psft_customizations.yaml` to update dynamic changes in `psappsrv.cfg`
$ensure = hiera('ensure')
$base = hiera('peoplesoft_base')
$appserver_domain_list = hiera('appserver_domain_list')
$appserver_domain_list.each | $domain_name, $appserver_domain_info | {
$cfg_file = "${appserver_domain_info['ps_cfg_home_dir']}/appserv/${domain_name}/psappsrv.cfg"
$dynamic_config = $appserver_domain_info['dynamic_config']
$dynamic_config.each | $setting, $config_value | {
@iversond
iversond / touch-icons.pp
Last active March 23, 2017 15:05
Deploy a favicon.zip file to PORTAL.war and signin.html to each site. Uses the PowerShell 4+ command 'Expand-Archive'.
$share_path = "//lm-d1/temp"
$pia_domain_list = hiera('pia_domain_list')
$pia_domain_list.each | $domain_name, $pia_domain_info | {
$cfg_home = $pia_domain_info['ps_cfg_home_dir']
$baseWebPath = "${cfg_home}/webserv/${domain_name}/applications/peoplesoft/PORTAL.war"
file {"io-favicons-zip-${domain_name}":
ensure => $ensure,
@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 / 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#"