CalemEAM R2_1e on CentOS 7.2 Full Tutorial

1,005 views
Skip to first unread message

Danny Russ

unread,
Dec 2, 2017, 9:18:04 PM12/2/17
to Calem Support Forum

CalemEAM CentOS 7.2 Full Working instructions

 

If you follow this guide to the letter, you will have a working installation of CalemEAM Community Edition R2_1e.  I wrote this document while installing this within a VM environment and documented every step throughout the install process.  Be careful to read everything and follow all steps.


Install CentOS 7.2-1708


 Configure the Server

 

A clean installation of CentOS 7.2 Server version 1708 should be installed with the following choices at installation (I did not perform any updates via yum update after the installation, so just leave it at default until you are comfortable with your install):

 

These disk requirements are just a suggestion and what I laid out.  You can do whatever you want with your configuration.

 

LVM File System with the following layout:

·      /boot – 1024MB (Standard)

·      /boot/efi – 200MB (Standard)

·      /home 20GB (LVM)

·      swap 4096MB (LVM)

·      / (root) - Remainder of drive (LVM)

 

Software Selection:

 

·      Server with GUI

·      JAVA Platform

·      Development Tools

 

Disable KDump, configure root password and any other settings within setup that are relevant.

Reboot the system and disable SELINUX by editing the /etc/selinux/config file to change the entry from “enforcing” to “disabled”, then reboot again.

 

 

Configure XRDP for remote access (optional)

 

For ease of administration purposes, it is optional to install the XRDP server for CentOS so that the server can easily be administered via any Microsoft RDP client or open source alternative.  Follow these steps to install and enable XRDP:

 

1.)   Install the EPEL 7 repository:

 

 

2.)   Add the nux repository:

 

 

3.)   Install XRDP:

 

yum -y install xrdp tigervnc-server

 

4.)   Start and then permanently enable the service:

 

systemctl start xrdp.service
systemctl enable xrdp.service

 

5.)   Open the firewall ports to allow remote access on port 3389:

 

firewall-cmd --permanent --zone=public --add-port=3389/tcp
firewall-cmd –reload

 

Download the needed software packages

 

1.)   Download CalemEAM R2.1e:

 

https://sourceforge.net/projects/calemeam/files/CalemEAM Community Edition/Calem Community Edition R2.1e/CalemEAM_R2.1e.tar.gz/download

 

2.)   Download the XAMPP LAMP stack:

 

https://www.apachefriends.org/xampp-files/5.6.32/xampp-linux-x64-5.6.32-0-installer.run

 

 

 

3.)   Download amCharts Flash version 1.6:

 

https://www.amcharts.com/dl/amcharts-flash/

 

 

Install and Configure the XAMPP Suite

 

Install the XAMPP LAMP suite

 

CalemEAM is a PHP application that runs on a LAMP stack which is comprised of a suite of open source software.  LAMP = (Linux, Apache, MySQL, and PHP).  This is the environment in which CalemEAM is installed.  It is possible to build your own LAMP stack and you can install this application there if you like, but this document intends that you use this particular configuration. 

 

XAMPP:  The XAMPP environment is completely self-contained within its installation directory at /opt/lampp.  All configuration files, databases and web services are located in this directory.  So, when you go forward, just know that this is where everything happens for CalemEAM.  Your local system installations of MySQL, Apache, and PHP don’t have any bearing on the outcome of your configuration, unless you choose to do so within your own custom LAMP stack.  I would even suggest that you don’t even install these packages as not to confuse them with your CalemEAM installation.

 

Installation steps for XAMPP: (Install XAMPP in the GUI or through an SSH session with X forwarding)

 

1.)   Navigate to the directory in which you downloaded the XAMPP package then make the file executable:

 

chmod +x xampp-linux-x64-5.6.32-0-installer.run

 

2.)   Run the installer:

 

./xampp-linux-x64-5.6.32-0-installer.run

 

You should now be presented with a welcome to setup screen.  Select Next to continue the installation and then take the defaults on the Select Components screen:

 

 

Press next a bunch more times until you get to the installation…

 

 

 

 

When the installation is complete, you will be presented with a GUI with the ability to stop and start services and view application logs.  This guide uses command line, so it is safe to close this window once you have looked around.  XAMPP is now installed and we can move on to the next steps.

 

Unpack CalemEAM and set permissions

 

CalemEAM is a self-contained application that is nested inside the LAMP stack at /opt/lampp/htdocs.  The CalemEAM package that was downloaded earlier needs to be extracted to this directory and then the proper permissions set for Linux.  The following steps will move CalemEAM into place and set the configuration requirements.

 

1.)   Navigate to /opt/lampp/htdocs and extract the CalemEAM gzip file:

 

cd /opt/lampp/htdocs

tar xzvf /root/Downloads/CalemEAM_R2.1e.tar.gz

 

2.)   Now the proper permissions have to be set on the directory in order for things to operate the way we expect.  We also need to copy the CalemEAM Apache httpd configuration file into the proper location.  But first, you need to determine what user and group you want to use to run Apache.  The default is user daemon and group daemon.  For the purposes of this guide, I am taking the defaults and just using those.  If you want to change the user and groups within Apache you can do so. 

 

Perform the following to set the permissions and copy the httpd file from within the /opt/lampp/htdocs directory.

 

cd /opt/lampp/htdocs

chown –R daemon:daemon CalemEAM/

chown 766 CalemEAM

cd CalemEAM

chmod –R 777 *

 

 

 

 

 

 

Now copy the CalemEAM httpd configuration file into place:

 

cp CalemEAM/etc/httpd-calemeam.conf /opt/lampp/etc/extra

vim /opt/lampp/etc/httpd.conf

Append the following to the end of the file:

 

# CalemEAM

Include etc/extra/httpd-calemeam.conf

 

Install Adobe Flash Player and amCharts Flash

 

First, we will install Adobe Flash Player and then we will create some directories and copy some flash files needed by CalemEAM into the proper locations.  Follow the steps below to install Flash Player and enable the amCharts Flash plugins:

 

1.)   Enable the Yum repository for Adobe:

rpm -ivh http://linuxdownload.adobe.com/adobe-release/adobe-release-x86_64-1.0-1.noarch.rpm 
rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY-adobe-linux
 

2.)   Install the Flash Player:

yum install flash-plugin alsa-plugins-pulseaudio libcurl

Now that Flash Player is installed, we need to install the Flash plugins needed for CalemEAM to properly display data on the web dashboard.  Perform the following to create the needed directories and copy the files into place:

 

1.)   Navigate to the directory that you downloaded the amCharts 1.6 zip file to and perform the following commands:

 

cd /root/Downloads/  (This is my download directory)

unzip amcharts_flash_1.6.zip

cd amcharts/flash

mkdir /opt/lampp/include/charts

mkdir /opt/lampp/include/charts/ampie /opt/lampp/include/charts/amline /opt/lampp/include/charts/amcolumn

cp amcolumn.swf /opt/lampp/include/charts/amcolumn

cp ampie.swf /opt/lampp/include/charts/ampie

cp amline.swf /opt/lampp/include/charts/amline

 

 Configure the MySQL database and user accounts


We need to set the root password, create an admin account and create a database in MySQL for all of the CalemEAM data to reside.  Perform the following to create the database and user accounts:

 

1.)   Create the root password:

 

/opt/lampp/bin/mysqladmin –u root password NEWPASSWORD

 

2.)   Logon to MariaDB (MySQL) and create a new admin user and database:

 

/opt/lampp/bin/mysql –u root –p

 

MariaDB [(none)]> create user 'youruser'@'localhost' identified by ‘PASSWORD’

MariaDB [(none)]> create database calemeam;

 

MariaDB [(none)]> grant all privileges on *.* to 'root'@'localhost';

Query OK, 0 rows affected (0.00 sec)

 

MariaDB [(none)]> grant all privileges on *.* to 'youruser'@'localhost';

Query OK, 0 rows affected (0.00 sec)

 

MariaDB [(none)]> flush privileges;

MariaDB [(none)]> exit

 

Configure the php.ini file for error reporting

 

This is a very important step and if it is skipped can cause all kinds of errors when you try to log on to the new system.  Perform the following to edit the php.ini file:

 

1.)   Edit the /opt/lampp/etc/php.ini file

 

vim /opt/lampp/etc/php.ini

 

Locate and edit the following line from this:

error_reporting=E_ALL & ~E_DEPRECATED & ~E_STRICT

To this:

error_reporting=E_ALL &

~E_NOTICE & ~E_STRICT & ~E_DEPRECATED

 

 

Now we need to restart all of the LAMP services:

 

/opt/lampp/lampp stop

/opt/lampp/lampp start

 

Install CalemEAM

 

1.)   CalemEAM is a web based installer.  To start the installer, open a browser on the local system and navigate to http://localhost/CalemEAM/installation.  You should be greeted with an installer like the following:

 

 

 

2.)   Select Next and then accept the license agreement.  On the minimum system requirements page, I always received an error about amCharts and warnings on MySQL and File access.  Just ignore this and move on.  It should not affect your installation.

 

 

 

 

 

 

 

 

 

 

On the database screen select Custom Setup:

 

 

3.)   On the Get Database Information screen, fill the host as localhost and enter the root user and password you created earlier.  Fill in the name of the database as well.  I called mine calemeam.

 

 

4.)   Select next and decide whether or not you want sample data added to your database.  I chose not to have to clean that stuff up, but if you just want a demo, go for it.  Select Next and allow the database creation and installation to complete.

5.)   When the installer completes, you will be provided with a link to access the user interface.  If you followed this guide to the letter then you should be able to open your local browser and navigate to http://localhost/CalemEAM/index.php However, you MUST remove the installation folder from the /opt/lampp/htdocs/CalemEAM

folder or you will receive an error message.  So, go do this before you get too excited about your new server. I elected to move the file until I know that everything is working okay, just in case I had to move it back:

 

mv /opt/lampp/htdocs/CalemEAM/installation /tmp

/opt/lampp/lampp stop

/opt/lampp/lampp start

To clean up, you may want to go and disable any of the EPEL repositories or anything else that you don’t want to get future updates from for patch maintenance.

 

Now go here and logon:  http://localhost/CalemEAM/index.php

 

The default user and passwords are:

 

User = admin

Password = admin_password

 

You will need to open up the ports on your firewall using the firewall-cmd commands to open port 80 or 443 for access to users outside your local system.

 

 

Danny Russ

unread,
Dec 2, 2017, 9:23:19 PM12/2/17
to Calem Support Forum
Attached is a word document of the tutorial since this forum doesn't support the screenshots I included.  I would use that if you want pictures.
CalemEAM CentOS 7 Community.docx

Steven C from NY

unread,
Jan 4, 2018, 6:08:05 PM1/4/18
to Calem Support Forum
Thank you for this tutorial. I was successful in getting the Community edition installed on Ubuntu 16.x. I used the Word document as a the guide.

The only sticking point was the Adobe Flash install which I succeeded to do via the Adobe website. The RPM links would not work for me.

Steve

Yousaf Alvi

unread,
Aug 7, 2018, 1:35:21 AM8/7/18
to Calem Support Forum
hello dear

i understand it all except the database (mysql) settings the command is not accepted by centos and i am having trouble do i need to install mysql server or what are the step by step commands to setup database and create user please guide me i am a newbie 

Thanks
Reply all
Reply to author
Forward
0 new messages