Installation Notes for Base VM for TPCx-V

• Use the following commands to install the software needed as specified in the User's Guide!

---

Dependencies in section 2.2:

yum group install \
    "Server with GUI"\
    "Guest Agents "\
    "File and Storage Server"\
    "Network File System Client"\
    "Large Systems Performance"\
    "Performance Tools"\
    "Compatibility Libraries"\
    "Development Tools"

Java Installation

#/bin/bash

set -xe

cd /opt/
wget --no-cookies --no-check-certificate --header "Cookie: gpw_e24=http%3A%2F%2Fwww.oracle.com%2F; oraclelicense=accept-securebackup-cookie" "http://download.oracle.com/otn-pub/java/jdk/7u79-b15/jdk-7u79-linux-x64.tar.gz"
tar xzf jdk-7u79-linux-x64.tar.gz

cd /opt/jdk1.7.0_79/

alternatives --install /usr/bin/java java /opt/jdk1.7.0_79/bin/java 2
alternatives --config java

alternatives --install /usr/bin/jar jar /opt/jdk1.7.0_79/bin/jar 2
alternatives --set jar /opt/jdk1.7.0_79/bin/jar

alternatives --install /usr/bin/javac javac /opt/jdk1.7.0_79/bin/javac 2
alternatives --set javac /opt/jdk1.7.0_79/bin/javac

alternatives --install /usr/bin/javah javah /opt/jdk1.7.0_79/bin/javah 2
alternatives --set javah /opt/jdk1.7.0_79/bin/javah

alternatives --install /usr/bin/rmic rmic /opt/jdk1.7.0_79/bin/rmic 2
alternatives --set rmic /opt/jdk1.7.0_79/bin/rmic

ODBC

#!/bin/bash 
set -xe

cd /tmp 

yum install postgresql93 postgresql93-libs postgresql93-devel postgresql93-server postgresql93-odbc

wget ftp://bo.mirror.garr.it/1/slc/centos/7.1.1503/os/x86_64/Packages/unixODBC-2.3.1-10.el7.x86_64.rpm
wget ftp://bo.mirror.garr.it/1/slc/centos/7.1.1503/os/x86_64/Packages/unixODBC-devel-2.3.1-10.el7.x86_64.rpm
yum install unixODBC-2.3.1-10.el7.x86_64.rpm unixODBC-devel-2.3.1-10.el7.x86_64.rpm


wget https://yum.postgresql.org/9.3/redhat/rhel-5.2-x86_64/pgdg-centos93-9.3-1.noarch.rpm
rpm -ivh pgdg-centos93-9.3-1.noarch.rpm

wget https://mirror.its.sfu.ca/mirror/CentOS-Third-Party/pgrpm/pgrpm-93/redhat/rhel-7-x86_64/postgresql93-odbc-09.03.0300-1PGDG.rhel7.x86_64.rpm

rpm -ivh postgresql93-odbc-09.03.0300-1PGDG.rhel7.x86_64.rpm

# The downloaded package above was not installed since the newer was installed in its place by the command below
# Maybe check this is something went wrong

Postgres

When setuping the postgres profile remember to change the JAVA_INC to the correct /opt dir

export JAVA_INC=/opt/jdk1.7.0_79/include

Version of pgstatspack:

wget http://pgfoundry.org/frs/download.php/3151/pgstatspack_version_2.3.1.tar.gz

Setup ssh without pass

Accordingly with the documentation "The run-time bash scripts depend on the prime driver being able to ssh into all 13 VMs, as both root and postgres, using the file .ssh/authorized_keys. It's a good idea to set this up on the first VM before making the clones". So we performed :

As postgres:

ssh-keygen -t rsa
ssh-copy-id postgres@localhost
ssh-copy-id root@localhost

As root:

ssh-keygen -t rsa
ssh-copy-id postgres@localhost
ssh-copy-id root@localhost
restorecon -R -v /var/lib/pgsql/.ssh/
restorecon -R -v /root/.ssh

checklist after finishing 2.1.4 Version

• Install the pgstatspack at the database VMs

• lvremove oxum-vg/tpc--v2-swap

• lvremove oxum-vg/tpc-tpc-g1b2-v2-disk

• lvremove oxum-vg/tpc-tpc-g1b2-v2-swap

• ssh scripts