Skip to content

Instantly share code, notes, and snippets.

View discoposse's full-sized avatar
💭
Life happens. How you interpret the results is what you have control over.

Eric Wright discoposse

💭
Life happens. How you interpret the results is what you have control over.
View GitHub Profile
@discoposse
discoposse / Folder structure
Created July 10, 2020 14:18
Terraform vSphere Folder reference challenged when using a Variable
Datacenter = HawthorneSales
Default root folder (hidden) = HawthorneSales/vm
Folders = Users/eric.wright
@discoposse
discoposse / README.md
Created April 29, 2019 01:41 — forked from tristanm/README.md
Migrating a Rails project from MySQL to PostgreSQL

Migrating a Rails project from MySQL to PostgreSQL

This brief guide is written from my own experience with migrating a large (~5GB) MySQL database to PostgreSQL for a Rails project.

No warranties, guarantees, support etc. Use at your own risk and, as always, ENSURE YOU MAKE BACKUPS FIRST!

I chose [pgloader][1] because it's extremely fast. YMMV.

  1. Replace mysql2 gem with pg in Gemfile.
  2. Update config/database.yml for PostgreSQL. I used [Rails' template][2] as a starting point.
#!/bin/bash
#
# Slack Webhook notification for Turbonomic Action Scripts
#
# Use cURL to post to the Slack API
curl -X POST --data-urlencode 'payload={"channel": "#turbonomic", "username": "discohook", "text": "Move action created for "$VMT_TARGET_NAME" from "$VMT_CURRENT_NAME" to "$VMT_NEW_NAME" with action name = "$VMT_ACTION_NAME"", "icon_emoji": ":bear:"}' https://hooks.slack.com/services/YOURDEDICATEDWEBHOOKURL
# Log locally in the same folder as the action script (optional)
echo "$VMT_TARGET_NAME is moving" >> mylog.txt
#!/bin/bash
# USERID is the starting number for the users to follow
# LASTUSER is your upper bound user ID number
# JIVEUSER is your Jive username
# JIVEPASS is your plaintext password
USERID=38000
LASTUSER=38010
JIVEUSER=
@discoposse
discoposse / rancher-compose.yml
Created November 13, 2015 23:09
GlusterFS Rancher Compose sample
.catalog:
name: "GlusterFS"
version: "3.7.5-rancher1"
description: "Gluster FS (3x) replicated volume"
uuid: glusterfs-0
questions:
- variable: "VOLUME_NAME"
description: "Name to give the Gluster volume"
label: "Volume Name"
required: true
@discoposse
discoposse / docker-compose.yml
Created November 13, 2015 23:08
GlusterFS Docker Compose sample
glusterfs-server:
image: rancher/glusterfs:v0.1.3
devices:
- /dev/fuse:/dev/fuse:rwm
cap_add:
- SYS_ADMIN
volumes_from:
- glusterfs-data
labels:
io.rancher.container.hostname_override: container_name
Out of the box build - command is "ceilometer meter-list"
results:
root@controller:/var/log/ceilometer# cat ceilometer-agent-central.log
2015-05-11 14:58:18.283 24053 ERROR ceilometer.agent [-] Unable to discover resources: 'AuthorizationFailure' object has no attribute 'tenants'
2015-05-11 14:58:18.283 24053 TRACE ceilometer.agent Traceback (most recent call last):
2015-05-11 14:58:18.283 24053 TRACE ceilometer.agent File "/usr/lib/python2.7/dist-packages/ceilometer/agent.py", line 233, in discover
2015-05-11 14:58:18.283 24053 TRACE ceilometer.agent discovered = discoverer.discover(self, param)
2015-05-11 14:58:18.283 24053 TRACE ceilometer.agent File "/usr/lib/python2.7/dist-packages/ceilometer/central/discovery.py", line 61, in discover
@discoposse
discoposse / gist:39045a714249ca7f771c
Created June 3, 2014 22:58
Delete and Rebuild Keystone database
# Log in to MySQL command line as root
drop database keystone;
create database keystone;
GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'localhost' IDENTIFIED BY 'KEYSTONE_DBPASS';
GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'%' IDENTIFIED BY 'KEYSTONE_DBPASS';
exit
# now from the shell
sudo su -c "keystone-manage db_sync" keystone
@discoposse
discoposse / gist:8791513
Created February 3, 2014 20:17
Is this a subquery I need?
people table fields:
id,first_name,last_name,login,manager_id
I need to get all the info, plus the login of the manager where manager_id references the record in the people table.
This is why I'm not a DBA
@discoposse
discoposse / C2OS - vagrant error starting at compute node
Created August 15, 2013 15:38
This is the vagrant output for Windows. The first node loads fine, but the common.sh borks on the Compute node and the rest of the build fails
PS C:\users\ewright\Documents\GitHub\Couch_to_OpenStack> vagrant up
Bringing machine 'controller' up with 'virtualbox' provider...
Bringing machine 'compute' up with 'virtualbox' provider...
Bringing machine 'cinder' up with 'virtualbox' provider...
Bringing machine 'quantum' up with 'virtualbox' provider...
Bringing machine 'client' up with 'virtualbox' provider...
[controller] Importing base box 'precise64'...
←[0K[controller] Matching MAC address for NAT networking...
[controller] Setting the name of the VM...
[controller] Clearing any previously set forwarded ports...