rch317

#!/bin/sh
for region in $(aws ec2 describe-regions |jq -r '.Regions[] | .RegionName');
  do
    echo "${region}"; aws ec2 describe-instances --region ${region} | \
      jq -r '.Reservations[]
       | .Instances[]
       | select(.PublicIpAddress!=null)
       | "\t" + .PublicIpAddress + " " + .InstanceId'
  done

rch317

    "remote": {
        "type": "s3",
        "config": {
            "bucket": "s3-bucket",
            "key": "/path/to/terraform.tfstate",
            "region": "us-east-1"
        }
    },

rch317

VMWare Fusion: Tips and Tricks

Assign Static IP to VM

• Determine the MAC address of the network interface(s) you wish to assign a static IP to:
  • $ ip link
  • link/ether 00:0c:29:c5:05:d6 brd ff:ff:ff:ff:ff:ff
  • You can also view the vm guest network settings under advanced
• Edit the dhcpd.conf file
• /Library/Preferences/VMware\ Fusion/vmnet8/dhcpd.conf

rch317

#!/bin/bash
# 
# Stole this from an existing jazzdb user script
#
for i in $(db2 list database directory|grep alias|awk '{print $4}')
  do
    db2 connect to $i;
    db2 grant dbadm on database to user cpe_db_user;
    db2 terminate;
  done

rch317

<?xml version="1.0" encoding="UTF-8"?>
<!--The "acceptLicense" attribute has been deprecated. Use "-acceptLicense" command line option to accept license agreements.-->
<agent-input acceptLicense='true'  clean='true' temporary='true'>
<server>
<repository location='/mnt/cdrom/ibm_sds'/>
<repository location='/mnt/cdrom/entitlement/ibm_sds_ent'/>
</server>
<profile id='IBM Security Directory Server' installLocation='/opt/ibm/ldap/V6.4'>
<data key='eclipseLocation' value='/opt/ibm/ldap/V6.4'/>
<data key='user.import.profile' value='false'/>

rch317

Updating Vault

1. Pull existing data from vault vault read -format=json secret/some/vault | tee backup-$(date +%s).json update.json

2. Edit the update.json to include new data, remove unneeded data.

{
		"USER1": "passw0rd",
 "USER2": "s3cr37",

rch317

Join Linux to Active Directory (RHEL/CentOS)

Below is what an admin would do manually. You will need to adjust the variables to work for you, obviously. These steps are similar in debian based Linux distributions, but with a twist. I didn't document that here, as I didn't see the need. They are relatively minor changes.

1. Export some variables that we'll need.

### Set your domain
export adauth_domain=YOURDOMAIN.LAB

rch317

macOS Setup

A collection of tips & tricks I've used to setup my Mac after. Feel free to use whatever you want, or none at all. I'm no export mac user. This is just stuff that works for me.

Preferences

• Keyboard > Text > Disable "Correct spelling automatically".

rch317

SQL1015N The database is in an inconsistent state. SQLSTATE=55025

db2 restart database ${db_name}

[db2inst1@SD00039LINVDAT ~]$ db2 drop database ${db_name}

• SQL1031N The database directory cannot be found on the indicated file system.*
• SQLSTATE=58031*

db2 uncatalog database ${db_name}

rch317

First, commented out all items. Added a data source for the datacenter

data "vsphere_datacenter" "datacenter" {
  name = "${var.vsphere_datacenter}"
}

Re-ran the plan:

terraform plan --out plan.out