You are here

Installing focmm

Table of Contents

Download FromDual Ops Center for MariaDB and MySQL

If you want to install FromDual Ops Center for MariaDB and MySQL manually you can download it from our download site and store it under /tmp.

Installation of FromDual Ops Center for MariaDB and MySQL

Ubuntu 18.04 repository

ubuntu.png

Add the FromDual APT repository as described here.

Then install focmm with the following command:

apt-get install focmm

Ubuntu 18.04 tarball

ubuntu.png

apt-get update
apt-get install apache2 php php-mysqli mysql-server php-posix libapache2-mod-gnutls

VERSION=0.9.1
tar -C /var/www/html -xf /tmp/focmm-${VERSION}.tar.gz
cd /var/www/html
chown -R www-data: /var/www/html/focmm-${VERSION}
ln -s focmm-${VERSION} focmm
chown -h www-data: focmm
mkdir /etc/focmm
chown www-data: /etc/focmm

If you want to make sure all http traffic is forced to use https copy the tpl/htaccess.template file to /var/www/html/focmm:

cp /var/www/html/focmm/tpl/htaccess.template /var/www/html/focmm/.htaccess
chown www-data: /var/www/html/focmm/.htaccess

a2enmod rewrite

mkdir /etc/apache2/ssl
openssl req -x509 -newkey rsa:4096 -keyout /etc/apache2/ssl/focmm.key -out /etc/apache2/ssl/focmm.crt -days 3650 -nodes

a2ensite default-ssl

and change your Apache configuration file as follows:

# /etc/apache2/sites-available/default-ssl.conf

SSLEngine on
SSLCertificateFile    /etc/apache2/ssl/focmm.crt
SSLCertificateKeyFile /etc/apache2/ssl/focmm.key

and

# /etc/apache2/conf-available/focmm.conf

<Directory /var/www/html/focmm>
  AllowOverride All
</Directory>

Do not forget to restart Apache afterwards with:

a2enconf focmm
systemctl restart apache2

Ubuntu 18.04 DEB

ubuntu.png

VERSION="0.9.1"
dpkg -i focmm_${VERSION}-1_all.deb
apt-get install -f

or

apt install ./focmm_${VERSION}-1_all.deb

CentOS 7 / Redhat 7 repository

centos.pngredhat.png

Add the FromDual RPM repository as described here.

Then install focmm with the following command:

yum install focmm

CentOS 7 / Redhat 7 tarball

centos.pngredhat.png

yum install httpd php php-mysqli mariadb-server php-posix php-mysqli redhat-lsb-core mod_ssl openssl
systemctl enable mariadb
systemctl start mariadb
systemctl enable httpd
systemctl start httpd

firewall-cmd --permanent --add-port=80/tcp
firewall-cmd --permanent --add-port=443/tcp
firewall-cmd --reload

VERSION=0.9.1
tar -C /var/www/html -xf /tmp/focmm-${VERSION}.tar.gz
cd /var/www/html
chown -R apache: /var/www/html/focmm-${VERSION}
ln -s focmm-${VERSION} focmm
chown -h apache: focmm
mkdir /etc/focmm
chown apache: /etc/focmm

If you want to make sure all http traffic is forced to use https copy the tpl/htaccess.template file to /var/www/html/focmm:

cp /var/www/html/focmm/tpl/htaccess.template /var/www/html/focmm/.htaccess
chown apache: /var/www/html/focmm/.htaccess

and change your Apache configuration file as follows:

#
# /etc/httpd/conf.d/focmm.conf
#

<Directory /var/www/html/focmm>
  AllowOverride All
</Directory>

Do not forget to restart Apache afterwards with:

systemctl restart httpd

If later in your web browser you should get an error code 3002 or 3004 and/or the following error in your Apache error log, then it is most probably SElinux which causes troubles:

PHP Warning:  error_log(/var/www/html/focmm-rev402/log/error.log): failed to open stream: Permission denied in /var/www/html/focmm-rev402/lib/Log.inc on line 109

sestatus 
SELinux status:                 enabled
SELinuxfs mount:                /sys/fs/selinux
SELinux root directory:         /etc/selinux
Loaded policy name:             targeted
Current mode:                   enforcing
Mode from config file:          enforcing
Policy MLS status:              enabled
Policy deny_unknown status:     allowed
Max kernel policy version:      31

setenforce Permissive

CentOS 7 / Redhat 7 RPM

centos.pngredhat.png

VERSION="0.9.1"
yum localinstall focmm-${VERSION}-1.el7.noarch.rpm 
systemctl enable mariadb
systemctl start mariadb
systemctl enable httpd
systemctl start httpd

# https is missing here

iptables -L
firewall-cmd --permanent --add-port=80/tcp
firewall-cmd --permanent --add-port=443/tcp
firewall-cmd --reload

sestatus
semodule -i /var/www/html/focmm-${VERSION}/tpl/focmm.pp
semodule --list | grep focmm

If we did not catch all SElinux policies, please set SElinux to permissive:

setenforce 0
sed -i 's/^SELINUX=enforcing/SELINUX=permissive/' /etc/selinux/config

Preparing repository database

Create the Ops Center Schema in the repository database as follows:

mysql --user=root

CREATE SCHEMA focmm;
CREATE USER 'focmm_owner'@'127.0.0.1' IDENTIFIED BY 'secret';
GRANT ALL ON focmm.* to 'focmm_owner'@'127.0.0.1';

Creating Ops Center Repository

Now you have to connect with your browser to the FromDual Ops Center for MariaDB and MySQL. The URL looks like this: https://192.168.56.101/focmm/. As soon as you do this the first time. Ops Center tries to do some checks and lets you know about the diagnosis:

Ops Center diagnosis

At the end you have to enter the connect information for your Ops Center Repository Database you have created above. The Ops Center will start installing the Repository.

Ops Center installing repository

If everything completed successful you can login. The defaul user/password is admin/admin.

Ops Center Login

After the login you reach the Ops Center dashboard. Currently it will be empty and thus shows a nice architecture overview.

Ops Center Dashboard

If you reached this step Ops Center is installed and needs to be configured now...