Home

Querying Data with PL/SQL: Implicit Cursor FOR Loop

Looping through result sets from SELECT statement using PL/SQLOne day, I was looking to update a bunch of records with a stored procedure via a for loop using PL/SQL. In order to accomplish this, I u

Various Puppet Errors

Error: Could not request certificate: SSL_connect returned=1 errno=0 state=error: certificate verify failed: [CRL is not yet valid for /CN=Puppet CA generated on pemaster at 2015-03-17 12:14:32 -0500]

Home Lab DNS Using dnsmasq and Puppet

It has been a long while since I’ve published anything to my kb site, perhaps just as long since I’ve started a new job nearly 2.5 years ago. In that time, my job responsibilities have shifted from t

Zero byte a File

/dev/null (zero out) a bunch of files at oncecd /var/logcat /dev/null | tee {boot.log,cron,dmesg,lastlog,messages,secure,vzctl.log,vznetcfg.log,wtmp} >boot.log>cron>dmesg>message

netmasks table

Decimal Binary CIDR Hex-------------------------------------------------------------------255.255.255.255 11111111.11111111.11111111.11111111 /32 ffffffff255.

sed Commands

sed one linersInsert character at beginning of lineComment all nfs entries in fstabsed -i '/nfs/s/^/#/' /etc/fstab Uncomment all nfs entries in fstabsed -i '/nfs/s/^#//g' /etc/fstab Su

nmap commands

Scan network for responsive IPsnmap -sS -O 10.199.42.0/23 | tee nmap.log Check if port is opennmap -P0 -p1521 oracle.com Scan UDPnmap -sU -p <port> <target>

tcpdump commands

Capture DHCP requestsPXE pxedhcp01 ~ # tcpdump -i eth1 \(port 67 or port 68\)tcpdump: verbose output suppressed, use -v or -vv for full protocol decodelistening on eth1, link-type EN10MB (Ethernet), c