This requires being connected to your server.
iDashboards can be installed on any Operating System that supports a Java 2 Enterprise Edition (J2EE) Web Application Server. Since Linux supports application servers (i.e. Apache Tomcat), iDashboards can be installed on a Linux or Unix-like Operating System. There are numerous methods of installing applications on Linux, and exact steps may differ based on your type of Linux server. This will assist in installing iDashboards on a Debian based platform (Ubuntu). Remember you or your server administrator may have other preferred methods of installing these applications.
System Requirements
- Hardware
- 2 GHz, Single CPU
- 4 GB RAM
- 5 GB Available Hard Disk Space
- Software
- Linux or Unix-like Operating System that supports a J2EE-compliant Application Server.
- Ubuntu Linux
- Java JDK version 1.8 or later, including a Java Virtual Machine.
- OpenJDK Java 1.8.0
- Java Application Server that implements Servlet 3.0 and JSP 2.2 or later (Apache Tomcat 8.5.48 or later).
- Apache Tomcat 8.5.48
- A supported relational database servers for the iDashboards repository as well as a corresponding JDBC driver to connect to your database server: MySQL Server, Oracle Database and Microsoft SQL Server.
- MySQL 8.0.21
- Google Chrome for Debian Based Linux (Ubuntu)
- Linux or Unix-like Operating System that supports a J2EE-compliant Application Server.
- Linux Tool Collections (will need to be installed)
- APT-GET
- Wget
- Unzip
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 they are included for reference only.
OpenJDK Java 1.8.0
- Update the apt-get Repository
- sudo apt-get update
- Install the OpenJDK Runtime Environment (you will need to confirm the download and installation at various points by typing Y)
- sudo apt-get install openjdk-8-jdk
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 they are included for reference only.
Apache Tomcat 8.5.48
- Create an idashboards user and group
- sudo useradd –MU –s /sbin/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, replace x and x.xx with the version you wish to download. Download this to your Home Directory
- wget http://mirrors.advancedhosters.com/apache/tomcat/tomcatx/vx.xx/bin/apache-tomcat-x.x.xx.tar.gz
- Create the Tomcat Directory
- sudo mkdir /opt/tomcat
- Extract the Tomcat Archive
- 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
- sudo nano /etc/systemd/system/tomcat.service
- Set the ivizgroup Home Directory by inserting 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 when Server Turns On (optional)
- sudo systemctl enable tomcat.service
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 they are included for reference only.
MySQL 8.0.21
- Install MySQL
- sudo apt-get install mysql-server
- Set your root password
sudo passwd root
- Log in to MySQL with Root you will be prompted for a password
- mysql –u root –p
- Create the iDashboards Repository, the Excel Workbooks, and the Datastore Databases
- 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 MySQL user for iDashboards to Connect to the Repository:
- username: idash password: $password
- CREATE USER ‘idash’@’localhost’ identified by ‘$password’;
- Assign the MySQL user privileges with:
- 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
su - username
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 they are included for reference only.
iDashboards 11.1e
- Create the ivizgroup Home Directory
- sudo mkdir /opt/ivizgroup
- Make the idashboards user owner of the ivizgroup home directory
- sudo chown -R idashboards /opt/ivizgroup
- Go to the Support Download Site to obtain the link to download the latest install package, you will need your user name and password supplied by iDashboards often similar to:
- username: yourcompany password: m!n#o@p$q&r (SAVE these, you will need for upgrades)
- wget --user=yourcompany --password='m!n#o@p$q&r' https://support.idashboards.com/downloads/software/release/iDashboards_111e_EnterpriseSuite_CDROM.zip
- Unzip the iDashboards Software to the ivizgroup Home Directory.
- sudo unzip iDashboards_11.xx_EnterpriseSuite_CDROM.zip –d /opt/ivizgroup
- Create the logs Folder
- cd /opt/ivizgroup
- sudo mkdir logs
- Create the drivers folder
- sudo mkdir drivers
- Set ownership for the ivizgroup Home Directory
- sudo chown –R idashboards /opt/ivizgroup
- Copy idashboards.war and idbdata.war to the webapps Directory
- sudo cp /opt/ivizgroup/bin/*.war /opt/tomcat/webapps
- Navigate to the drivers folder
- cd opt/ivizgroup/drivers
- Download the MySQL Driver
- sudo wget https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-8.0.21.zip
- Unzip the Driver
- sudo unzip mysql-connector-java-8.0.21.zip
- 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
- Edit the ivizgroup.properties File
- Specify the password you gave your MySQL idash user
- sudo nano /opt/ivizgroup/config/ivizgroup.properties
- Add the Following to Configure the Repository
-
db.driverClass=com.mysql.jdbc.Driver
db.url=jdbc:mysql://localhost:3306/idashboards
db.user=idash
db.password=$password
db.password.encrypted=false
db.maxConnections=10
-
- Save and Exit
- Crtl-X and Confirm Save and Filename
- Run the Create Repository Script from Shell
- mysql –u idash –p idashboards </opt/ivizgroup/scripts/database/create_repository/mysql_create_repository.sql
- Verify the Script Ran
- You should see tables with the prefix fv_
- mysql –u idash –p Use idashboards; Show tables; Exit
- Start the Tomcat Service (iDashboardsSRV)
- The service will deploy the .WAR files in the webapps directory. This may take a few minutes.
- sudo systemctl start tomcat
- Your iDashboards server should now be fully configured. You may need to add firewall exceptions to allow communication through the port 8080 in which iDashboards is configured.
- User Application: http://yourserver:8080/idashboards
- Data Hub: http://yourserver:8080/idbdata
- Login Credentials: Username: admin Password: change_me
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
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 they are included for reference only.
Installing Google Chrome
As of 05/30/2019 with the release of v10 you will need to install Google Chrome to give the software the ability to create thumbnail and reports images.
- Download the Google Chrome Package
- wget https://dl.google.com/linux/direct/google-chrome-stable_current_amd64.deb
- Install the Google Chrome Package
- sudo dpkg -i google-chrome-stable_current_amd64.deb
For More Information:
- iDashboards Admin Manual 3.4 Manual Installation
- Ubuntu Installation Guide
- PostgreSQL on Ubuntu Linux
- MS SQL Server on Ubuntu Linux
Disclaimer: iDashboards Technical Support Engineers are not Linux Server Administrators who know in depth knowledge of them and their quirks. We often learn these skills on the job and have limited knowledge. We do our best to help you with your software in determining if: you are not leveraging the software in the best way for your data or you found a bug in the software, because we want to assist you in your success.
If the above is unable to resolve the issue, then please contact iDashboards Support for further assistance.
Comments
0 comments
Please sign in to leave a comment.