cancel
Showing results for 
Search instead for 
Did you mean: 

PEM 7 Quickstart (Single Server Installation)

EDB Team Member

Objective

Quickly (less than five minutes) install and run a default PEM 7 installation on RHEL 6/7. This is a single server configuration in which both database and PEM server will reside in a single host. At a high level we will install EPAS 9.6 first and then use it to store the PEM repository database. 

 

Prerequisites

Running instance of RHEL 6/7 with root access that can display a GUI

 

 

Components

There are three primary components to PEM:

  1. PEM Server

    • PEM Repository (database for storing metrics)

    • Apache HTTPD (provides browser interface and backend to thick client)

  2. PEM Agent (a daemon that can run on each operating system that PEM monitors)

  3. PEM Client (a thick client GUI)


Steps (as root user)
#!/bin/bash

#
# Make sure umask is 0022
#
umask 0022

#
# Make sure /tmp can be executed from (if in a hardened
# environment)
# Make sure anything in the Postgres registry is valid
#
cat /etc/postgres-reg.ini

#
# Setup YUM repository for installing EPAS as the PEM
# repository
#
export YUM_USER=<yum user>
export YUM_PASSWORD=<yum password>


rpm -Uvh http://yum.enterprisedb.com/edbrepos/edb-repo-latest.noarch.rpm
sed -i "s/<username>:<password>/$EDB_YUM_USERNAME:$EDB_YUM_PASSWORD/g" /etc/yum.repos.d/edb.repo \
&& sed -i "\/edbas96/,/gpgcheck/ s/enabled=0/enabled=1/" /etc/yum.repos.d/edb.repo \
&& sed -i "\/enterprisedb-dependencies/,/gpgcheck/ s/enabled=0/enabled=1/" /etc/yum.repos.d/edb.repo \
&& sed -i "\/enterprisedb-tools/,/gpgcheck/ s/enabled=0/enabled=1/" /etc/yum.repos.d/edb.repo \
&&
yum -y install edb-as96-server

 

#
# Start the EPAS server and initialize a new Postgres
# data directory using the appropriate mechanism
# for the operating system
#
if [ `cat /etc/redhat-release | grep "release 7" | wc -l` = 1 ]
 then
   /usr/edb/as9.6/bin/edb-as-96-setup initdb
   su - enterprisedb -c "sed -i \"s/ident/md5/g\" /var/lib/edb/as9.6/data/pg_hba.conf" \
  && echo "host all all 0.0.0.0/0 md5" >>pg_hba.conf
  systemctl start edb-as-9.6

elif [ `cat /etc/redhat-release | grep "release 6" | wc -l` = 1 ]
 then
  service edb-as-9.6 initdb
  su - enterprisedb -c "sed -i 's/ident/md5/g' /var/lib/edb/as9.6/data/pg_hba.conf" \
  && echo "host all all 0.0.0.0/0 md5" >>/var/lib/edb/as9.6/data/pg_hba.conf
  service edb-as-9.6 start
fi

#
# Set a default password for the enterprisedb user
#
su - enterprisedb -c "psql -d postgres -c 'alter user enterprisedb identified by enterprisedb'"

#
# Get the PEM Server installer, currently not available
# via RPMs
#

setenforce permissive

cd /tmp \
&& curl https://get.enterprisedb.com/pem/pem-server-7.1.0-1-linux-x64.run > ./installer.run \
&& chmod 777 installer.run \
&& ./installer.run --extract-dependents .

 

#
# Install the language pack
#
./edb-languagepack-*.run --mode unattended

#
# Install Apache for the PEM server (disable SELinux for the install)
#

./pem-httpd*.run --mode unattended --prefix /opt/PEM/EnterpriseDB-Apache

#
# Install the PEM application (DB schema and Appache app), this
# installer includes an agent so does not need separately
# installed (user/password only needed if connected to internet)
#
export EDB_PORTAL_USER=<web portal user>
export EDB_PORTAL_PASSWORD=<web portal password>

export DATABASEHOST=localhost

 

./installer.run --mode unattended --prefix /opt/PEM/pem --pguser enterprisedb --pgpassword enterprisedb --pgport 5444 --servicename edb-as-9.6 --cidr-address 0.0.0.0/0 --existing-user $EDB_PORTAL_USER --existing-password $EDB_PORTAL_PASSWORD

 

setenforce Enforcing


##Now you can access these in a browser on your local machine:

# http://localhost:8080/pem (login as enterprisedb/enterprisedb, change host to localhost on database if it won't connect)

 

 






 Tips

Summary

This guide is intended to get you up and started with a default installation of PEM as quickly as possible.  This is just the beginning though.  Please stay tuned for more tutorials and demos of specific features available in PEM.