iDashboards can be installed on any Operating System that supports a Java 2 Enterprise Edition (J2EE) Web Application server. Because Linux does support application servers such as Apache Tomcat, iDashboards can be installed on a Linux or Unix-like Operating System.
This document will detail the steps to install iDashboards on a Debian based platform (Ubuntu). Remember that this document is only a guide; you or your server administrator may have other preferred methods of installing applications.
A more generalized installation guide can be found in the iDashboards Administrator’s Manual under Chapter 3.4 “Manual Installation”.
- 2 GHz, Single CPU
- 4 GB RAM
- 5 GB Available Hard Disk Space
- Linux or Unix-like Operating System that supports a J2EE-compliant Application Server
- Java JDK version 1.6 or later, including a Java Virtual Machine
- Java Application Server that implements the Servlet 3.0 and JSP 2.2 or later (Apache Tomcat 7.0 or later is recommended)
- One of the following supported relational database servers for the iDashboards repository o MySQL (used in this guide) o Oracle o Microsoft SQL Server
- A JDBC driver to connect to your database server
Please note the following programs are used and will need to be installed:
Do not copy and paste these commands!
They may not work verbatim for your particular distribution due to the highly configurable nature of the Linux OS. Please note that they are included for reference purposes only.
- Update the apt-get repository
sudo apt-get update
- Install the OpenJDK Runtime Environment (note that during installs you will need to confirm the download and installation at various points by typing Y)
sudo apt-get install openjdk-8-jdk
- Create an idashboards user and group
sudo useradd –MU –s /bin/nologin –d /opt/ivizgroup idashboards
- This creates a user group idashboards and a user idashboards that will only be used to run Tomcat, user logins are disabled so no password is set
- Identify the Tomcat binary you wish to install from http://tomcat.apache.org. (replace “x” and “x.xx” with the version you wish to download. Please note the mirror location periodically changes, so you will want to confirm the URL on the Tomcat download page. Download this file to your home directory
- Create the Tomcat directory and extract the Tomcat archive
sudo mkdir /opt/tomcat sudo tar xvf apache-tomcat-*tar.gz -C /opt/tomcat --strip-components=1
- Configure permissions for the idashboards user
sudo chown –R idashboards /opt/tomcat
- Configure Tomcat to run as a service and set the ivizgroup home directory
sudo nano /etc/systemd/system/tomcat.service
- Insert the following script:
# Systemd unit file for tomcat [Unit] Description=Tomcat Server Wants=syslog.target network.target After=syslog.target network.target [Service] Type=forking Environment=JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk-amd64 Environment=CATALINA_PID=/opt/tomcat/temp/tomcat.pid Environment=CATALINA_HOME=/opt/tomcat Environment=CATALINA_BASE=/opt/tomcat Environment='CATALINA_OPTS=-Xms512M -Xmx1024M -server -XX:+UseParallelGC' Environment='JAVA_OPTS=-Divizgroup.home=/opt/ivizgroup/ -Djava.awt.headless=true -Djava.security.egd=file:/dev/./urandom' ExecStart=/opt/tomcat/bin/catalina.sh start ExecStop=/bin/kill -15 $MAINPID User=idashboards Group=idashboards UMask=0007 RestartSec=10 Restart=always [Install] WantedBy=multi-user.target
- Save and exit (Crtl-X and confirm save and filename)
- Reload the Systemd file
sudo systemctl daemon-reload
- Set Tomcat to start on boot (optional)
sudo systemctl enable tomcat.service
- Install MySQL
apt-get install mysql-server
- Set your root password
- Log in to MySQL with root (you will be prompted for a password)
mysql –u root –p
- Create the iDashboards repository database, the Excel workbooks database, and the datastore database
CREATE DATABASE idashboards CHARACTER SET latin1 COLLATE latin1_swedish_ci;
CREATE DATABASE idb_workbooks CHARACTER SET latin1 COLLATE latin1_swedish_ci;
CREATE DATABASE idb_data CHARACTER SET latin1 COLLATE latin1_swedish_ci;
- Create a user for iDashboards to connect to the repository with and assign it privileges. We are using ‘idash’ as the username and a sample password, you can rename it if you’d like
CREATE USER ‘idash’@’localhost’ identified by ‘$password’; GRANT ALL PRIVILEGES ON idashboards.* to idash@localhost;
GRANT ALL PRIVILEGES ON idb_workbooks.* to idash@localhost;
GRANT ALL PRIVILEGES ON idb_data.* to idash@localhost; FLUSH PRIVILEGES; Exit
- Change to the home directory
- Create the ivizgroup home directory and make the idashboards user owner
sudo mkdir /opt/ivizgroup
- Contact firstname.lastname@example.org to get a link to download the latest install package.
- Unzip the iDashboards software to the ivizgroup home directory.
unzip iDashboards_103c_EnterpriseSuite_CDROM.zip –d /opt/ivizgroup
- Create the logs and drivers folders and set ownership for the ivizgroup home directory
cd /opt/ivizgroup sudo mkdir logs sudo mkdir drivers
sudo chown –R idashboards /opt/ivizgroup
- Copy idashboards.war and idbdata.war to the Tomcat webapps directory
sudo cp /opt/ivizgroup/bin/*.war /opt/tomcat/webapps
6. Navigate to the drivers folder
- Download the MySQL driver.
8. unzip the driver.
9. Copy the jar file into the drivers folder.
sudo cp mysql-connector-java-8.0.21/mysql-connector-java-8.0.21.jar /opt/ivizgroup/drivers
10. Edit the ivizgroup.properties file and add the following “db.” lines to configure the repository connection (remember to specify the password you gave your MySQL idash user)
sudo nano /opt/ivizgroup/config/ivizgroup.properties
11. Save and exit (Crtl-X and confirm save and filename)
12. Run the create repository script from shell
mysql –u idash –p idashboards < /opt/ivizgroup/scripts/database/create_repository/mysql_create_repository.sql
13. Verify the script ran. You should see a number of tables with the prefix “fv_”
mysql –u idash –p Use idashboards; Show tables; Exit
14. Start the Tomcat service
- The service will deploy the .WAR files in the webapps directory. This may take a few minutes
sudo systemctl start tomcat
15. Your iDashboards server should now be fully configured. Keep in mind you may need to add firewall exceptions in order to allow communication through the port iDashboards is configured with (8080 by default)
16. Optional if you would like to use Tomcat over port 80. Unbuntu reserves all ports under 1024 so adding a redirect entry to the iptables is the best method to redirect the traffic.
iptables -A INPUT -i eth0 -p tcp --dport 80 -j ACCEPT iptables -A INPUT -i eth0 -p tcp --dport 8080 -j ACCEPT iptables -A PREROUTING -t nat -i eth0 -p tcp --dport 80 -j REDIRECT --to-port 8080
Note: Recent versions of Ubuntu set the timezone to daylight time which will cause an error in the software when trying to get to the login screen. If you receive the error screen below. Run this code with your standard time zone.
sudo timedatectl set-timezone EST
Installing Google Chrome
As of version 10 you'll need to install Google Chrome to give the software the ability to create thumbnail images. Run the commands below to download and install Chrome.
sudo dpkg -i google-chrome-stable_current_amd64.deb
This guide can be downloaded in pdf format here: