phpdave

I. Prepare and Understand

Set up Public Keys between your Deployment Machine and the Remote Machines to deploy to

1. On your local machine generate a public key that will be exchanged with the remote servers you'll be deploying to. This will authorize your computer to connect and not require a password

ssh-keygen -t rsa -b 4096 -f ~/.ssh/id_rsa_abccompany -C "Comment to remember whos key"

also setup your ~/.ssh/config with this info to tie your key to which host

Host 192.168.1.5
    Port 22

phpdave

<?php
$sql="SELECT 
CAST(1 as smallint) as smallint,
CAST(2 as INTEGER) as INTEGER,
CAST(3 as BIGINT) as BIGINT,
CAST(4. as real) as real,
CAST(5.1 as FLOAT) as FLOAT,
CAST(6.1 as DOUBLE) as DOUBLE,
CAST(7.1 as DECIMAL) as DECIMAL,
CAST(8.1 as NUMERIC) as NUMERIC,

phpdave

<?
//only output the error if we're in the development environment
$APPLICATION_ENV="dev";

//set error handler to the callback function defined later
set_error_handler("myErrorHandler");

//connect to db
$db2Connection = db2_connect( '', '' , '',array('i5_lib' => 'QSYS'));
if (!$db2Connection) 

phpdave

Location of Log Files (PHP Error log, Apache Error log, Apache Access Log, FCGI error log, and Log Maintenance)

cat /usr/local/zendphp7/var/log/php.log
cat /www/zendphp7/logs/error_log.Q117040600
cat /www/zendphp7/logs/access_log.Q117040600
cat /www/zendphp7/logs/error_zfcgi.Q117040600
cat /www/zendphp7/logs/maint.log

Document root

phpdave

<?
//CSP only works in modern browsers Chrome 25+, Firefox 23+, Safari 7+
$headerCSP = "Content-Security-Policy:".
        "connect-src 'self' ;". // XMLHttpRequest (AJAX request), WebSocket or EventSource.
        "default-src 'self';". // Default policy for loading html elements
        "frame-ancestors 'self' ;". //allow parent framing - this one blocks click jacking and ui redress
        "frame-src 'none';". // vaid sources for frames
        "media-src 'self' *.example.com;". // vaid sources for media (audio and video html tags src)
        "object-src 'none'; ". // valid object embed and applet tags src
        "report-uri https://example.com/violationReportForCSP.php;". //A URL that will get raw json data in post that lets you know what was violated and blocked

phpdave

# .aliases
# vim:syntax=shexit
# Reload bash aliases
alias reload="source ~/.bash_profile"

# enable color support of ls and also add handy aliases
if [ -x /usr/bin/dircolors ]; then
    test -r ~/.dircolors && eval "$(dircolors -b ~/.dircolors)" || eval "$(dircolors -b)"
    alias ls='ls --color=auto'
    #alias dir='dir --color=auto'

phpdave

<?php
$xml = simplexml_load_file('jcrcmds.xml');
$outputdir='./results';
!file_exists($outputdir)?mkdir(outputdir, 0700):"";
foreach ($xml->mbr as $mbr) 
{
	$filename=$outputdir.'/'.trim($mbr['mbrname']).'.rpg';
	$data=(string) $mbr->copysrc;
	file_put_contents($filename,$data);
	echo $filename.' created.'.PHP_EOL;

phpdave

CALL PGM(QP2SHELL) PARM('/usr/local/zendsvr/bin/php-cli batchphp/CopyMembersToStreamFiles.php')

phpdave

--Authority Collection - https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/rzarl/rzarlautcolstart.htm

--https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/cl/strautcol.htm
STRAUTCOL USRPRF(USER1) LIBINF(*ALL) OBJ(*ALL) OBJTYPE(*ALL)  OMITLIB((MYLIB1))

--https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/cl/endautcol.htm
ENDAUTCOL   USER(USER1)

--View Data collected
SELECT * FROM QSYS2.AUTHORITY_COLLECTION 

phpdave

String DEBUG_TEMPLATE  = 'C:[C] R:[R] U:[U] D:[D] MA:[MA] RA:[RA] | [PROFILE_NAME] | [OBJECT_NAME]';
String TRUE_TEMPLATE   = '[X]'; // do not use space, horizontal char alignment will be off
String FALSE_TEMPLATE  = '[_]'; // same
Integer PROFILE_NAME_MAX_LENGTH;

// Grab the max chars of each, so we can get an evenly formatted / spaced output later
List<Integer> nameLengths = new List<Integer>();
for (Profile profile : [SELECT Name FROM Profile]) {
  nameLengths.add(profile.Name.length());
}