Install RabbitMQ and Percona Mongo on CentOS 6.6

centos66-rabbitmq-mongo-bi.md

Install RabbitMQ and Percona Mongo on CentOS 6.6

Erlang

Intall Erlang from Erlang Solutions:

wget https://packages.erlang-solutions.com/erlang-solutions-1.0-1.noarch.rpm
rpm -Uvh erlang-solutions-1.0-1.noarch.rpm
sudo yum install erlang

Note the following warning(TODO We can ignore this?):

warning: rpmts_HdrFromFdno: Header V3 RSA/SHA256 Signature, key ID c105b9de: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6
Importing GPG key 0xC105B9DE:
 Userid : CentOS-6 Key (CentOS 6 Official Signing Key) <centos-6-key@centos.org>
 Package: centos-release-6-6.el6.centos.12.2.x86_64 (@anaconda-CentOS-201410241409.x86_64/6.6)
 From   : /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6
Is this ok [y/N]: y

RabitMQ

RabbitMQ needs socat we need to source it from EPEL:

wget https://dl.fedoraproject.org/pub/epel/epel-release-latest-6.noarch.rpm
rpm -i epel-release-latest-6.noarch.rpm
yum install socat

Now we can install RabbitMQ:

wget https://github.com/rabbitmq/rabbitmq-server/releases/download/rabbitmq_v3_6_2/rabbitmq-server-3.6.2-1.noarch.rpm
rpm --import https://www.rabbitmq.com/rabbitmq-release-signing-key.asc
yum install rabbitmq-server-3.6.2-1.noarch.rpm

Percona Mongo

Install Percona Mongo:

sudo yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
yum install Percona-Server-MongoDB-32

Note the following warning:

warning: rpmts_HdrFromFdno: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-Percona
Importing GPG key 0xCD2EFD2A:
 Userid : Percona MySQL Development Team <mysql-dev@percona.com>
 Package: percona-release-0.1-3.noarch (@/percona-release-0.1-3.noarch)
 From   : /etc/pki/rpm-gpg/RPM-GPG-KEY-Percona
Is this ok [y/N]: y

Mongo BI Connector

The MongoDB Connector for Business Intelligence (BI) allows users to visualize their MongoDB Enterprise data using existing relational business intelligence tools such as Jasper.

Note the Mongo BI Adopter that is based on multicorn is not available to the public, so we use the EnterpriseDB Mongo FDW as a alternative.

Install PostgreSQL

wget https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-6-x86_64/pgdg-centos95-9.5-2.noarch.rpm
rpm -i pgdg-centos95-9.5-2.noarch.rpm
yum install postgresql95  postgresql95-server postgresql95-libs postgresql95-contrib postgresql95-devel
echo "/usr/local/lib/" > /etc/ld.so.conf.d/postgresql-mongo-libs.conf
ldconfig -v 
service postgresql-9.5 initdb
service postgresql-9.5 start

Install Mongo FDW

. /opt/rh/git19/enable
git clone --recursive https://github.com/EnterpriseDB/mongo_fdw.git
yum install autoconf268 automake libtool gcc cyrus-sasl cyrus-sasl-devel
alias autoreconf=autoreconf268

Modified autogen.sh by commenting out line 115

elif [ "--with-master" == $1 ]; then
	# checkout_mongo_driver

if json-c gives errors. Run the patch manually, configure and install:

cd json-c
patch -p1 < ../json_compilation_error.patch
make maintainer-clean
autoreconf
./autogen.sh
./configure --with-pic
make
make install

The same for libbson:

cd mongo-c-driver/src/libbson
./autogen.sh

and mongo c driver:

cd mongo-c-driver
./autogen.sh
./configure --with-libbson=auto --enable-sasl=yes
make
make install

Then try again:

./autogen.sh --with-master
make
export PKG_CONFIG_PATH=/usr/local/lib/pkgconfig:$PKG_CONFIG_PATH
export PATH=/usr/pgsql-9.5/bin/:$PATH
make install

Test

su - postgres -c psql

CREATE SCHEMA mongo;
SET SCHEMA 'mongo';
CREATE EXTENSION mongo_fdw;

Most of the above information was source from Compiling write-able mongo_fdw extension on binary format of PostgreSQL installation.

Extra Tools

Enable The Software Collections ( SCL ) Repository:

yum install centos-release-scl
yum install git19 vim tmux

Note the following warning:

warning: rpmts_HdrFromFdno: Header V4 RSA/SHA1 Signature, key ID f2ee9d55: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-SIG-SCLo
Importing GPG key 0xF2EE9D55:
 Userid : CentOS SoftwareCollections SIG (https://wiki.centos.org/SpecialInterestGroup/SCLo) <security@centos.org>
 Package: centos-release-scl-rh-2-2.el6.centos.noarch (@extras)
 From   : /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-SIG-SCLo