tjlee

# installs to /opt/gradle
# existing versions are not overwritten/deleted
# seamless upgrades/downgrades
# $GRADLE_HOME points to latest *installed* (not released)
gradle_version=2.9
wget -N https://services.gradle.org/distributions/gradle-${gradle_version}-all.zip
sudo unzip -foq gradle-${gradle_version}-all.zip -d /opt/gradle
sudo ln -sfn gradle-${gradle_version} /opt/gradle/latest
sudo printf "export GRADLE_HOME=/opt/gradle/latest\nexport PATH=\$PATH:\$GRADLE_HOME/bin" > /etc/profile.d/gradle.sh
. /etc/profile.d/gradle.sh

tjlee

Download the following ZIPs:
    
    ARM Translation Installer v1.1 (http://www.mirrorcreator.com/files/0ZIO8PME/Genymotion-ARM-Translation_v1.1.zip_links)
    
    Download the correct GApps for your Android version:
      Google Apps for Android 6.0 (https://www.androidfilehost.com/?fid=24052804347835438 - benzo-gapps-M-20151011-signed-chroma-r3.zip)
      Google Apps for Android 5.1 (https://www.androidfilehost.com/?fid=96042739161891406 - gapps-L-4-21-15.zip)
      Google Apps for Android 5.0 (https://www.androidfilehost.com/?fid=95784891001614559 - gapps-lp-20141109-signed.zip)
      Google Apps for Android 4.4.4 (https://www.androidfilehost.com/?fid=23501681358544845 - gapps-kk-20140606-signed.zip)
      Google Apps for Android 4.3 (https://www.androidfilehost.com/?fid=23060877490000124 - gapps-jb-20130813-signed.zip)

tjlee

use master
go
create database test
go
create login test with password test1234
go
exec sp_dboption test, 'abort tran on log full', true
go
exec sp_dboption test, 'allow nulls by default', true
go

tjlee

use test
go

sp_adduser 'test', 'test', null
go

grant create default to test
go
grant create table to test
go

tjlee

use test
go

create schema authorization test
go

tjlee

Ips for Docker Toolbox.

• docker-compose up -d vertica81 vertica91

• Connect to Vertica81 with DG with dbadmin (no password)

• Get gateway to create proper subnet: $docker inspect $(docker ps | grep vertica91 | awk '{print $1}') --format='{{range .NetworkSettings.Networks}}{{.Gateway}}{{end}}' ==> 172.18.0.1

• Get ip for vertica 81:

tjlee

Ho to set up SSL env

docker-compose up -d mysql80X
exec inside
find /var/lib/mysql -name '*.pem' -ls

cd /etc/mysql 
require_secure_transport = ON

restart container

tjlee

create type node_type as enum (
    ''
    );

create table node (
    node_id       serial primary key not null,
    network       cidr               not null,
    mac           macaddr,
    ip_addr       inet               not null,
    serial_number varchar(50),