Dashboard Installation 5.6.x

Installing the Dashboard Server

The Dashboard Server installation creates a MySQL database which is accessed by the Dashboard Client installations.

Pre-requisites

Before installing the Dashboard Server, check that you have met the following requirements:

1. Read the Lingoport Suite Installation, which describes how all the Lingoport applications work together and the hardware and software configuration requirements.
2. Selected a target machine that has a supported Operating System: Windows, Linux, or MacOS
3. Installed Java 7 or greater JRE on the target machine. You can check your Java version using the command line. At the command prompt enter: java -version The version of Java which you have on your system should be displayed. If you need to install Java, please refer to http://www.java.com/en/download/index.jsp or any Java download page which supplies Java 7 or above.
4. Installed MySQL 5.1 or higher on a database server. MySQL Download site. If the database server is not the same machine as the LRM server, then you will need to install the MySQL 5.x Client (only need Client) on the LRM server so that it can access the database on the separate database server.
   • You can verify that you have a sufficiently up-to-date version of MySQL using the command prompt. In the command prompt type:
   mysql -u <user> -p<password>
   • If MySQL is installed on your system, information on the version will be displayed after entering a valid username and password. If MySQL is not version 5.1 or higher, please refer to a download site, such as MySQL Download and install an up-to-date version.
   • If you are running on Windows, make sure that you have your Environment Path set to MySQL's bin directory. Select Control Panel->System->Advanced System Settings->Advanced->Environment Variables and, if necessary, add an entry similar to this to the Path variable: C:\Program Files\MySQL\MySQL Server 5.5\bin
   • You will need to enter the MySQL credentials (host, username, password and port number) during the installation.
5. Determine the port you will use for connection to the Dashboard Server; the default is 9000; on Mac the port is usually 9090. You will need to enter the connection port during the Dashboard Server installation.<?LI>
6. Download the installer jar file Lingoport_Dashboard_Server-<x.x>-Installer.jar (See support@lingoport.com if you don't have that information. It should have been sent in an email based on your license. )

   Installing for the First Time

   • Double-click on the Lingoport_Dashboard_Server-<x.x>-Installer.jar file, or
   • From the command line, cd to the directory with the installer and type:

      java –jar Lingoport_Dashboard_Server-<x.x>-Installer.jar
   

   The installation process will set up the Dashboard database as well as install the the Dashboard web server.

   Updating Your Existing Installation

   If you are upgrading your Dashboard Server to a newer version, make sure that you do not overwrite the existing database.

   • Double-click on the Lingoport_Dashboard_Server-<x.x>-Installer.jar file, or
   • From the command line, cd to the directory with the installer jar file and type:

      java –jar Lingoport_Dashboard_Server-<x.x>-Installer.jar
   

   • In Step 5 of the installation process, be sure to uncheck the checkbox labeled Install LINGODASH Database Data.

   Follow the steps in the next section to start the Dashboard Server. See the section on Upgrading the Dashboard Client for additional upgrade instructions.

   Running the Dashboard Server

   After installation, follow these steps to ensure that the server is running and can be successfully displayed:

   • From the command line, cd to the bin directory of where you installed the Dashboard Server and then cd to the appropriate directory for your specific operating system.
   • For Windows, enter:

      StartSonar
   

   • For Mac or Linux, enter:

      ./sonar.sh start
   

   • Check the sonar.log file under the logs directory to make sure there are no errors. It is possible that the connection port is being used by another process. In this case, you may either keep 9000 or 9090 for the Dashboard Server and kill the other process, or modify the Dashboard port number by adjusting the sonar.web.port property in the sonar.properties file in the conf directory.
   • To start the server, open a browser from the server system or another computer that has access to the server and enter:

      http://<hostname>:<port>
   

   For example, displaying the Dashboard on the local system with the default port 9000:

      http://localhost:9000
   

   You should see the Lingoport Dashboard web page.

   When You Want to Limit Dashboard Server Access

   By default, the Dashboard Server allows installed Dashboard Clients on other machines to push Globalyzer scan and LRM status information to the Server. If instead you want only the Dashboard Client that is installed on the Dashboard Server local machine to be able to access the Dashboard Server, follow these steps:

   • Log into MySQL on the system where you installed the Dashboard Server, as the root user.

      mysql -u root -p[password]
   

   • Execute this command to remove the wildcard host for the dashboard user:

      DROP USER 'lingodashuser'@'%';
   

   • Execute this command to make sure you now see just the lingodashuser for localhost:

      select user,host from mysql.user;
   

   You can also be more specific about which hosts you will allow to remotely run the Dashboard Client and push status to the lingodash database on the Dashboard Server. The following shows granting privileges to all hosts (i.e. undoing what we did above) – but you can change it to a specific host:

      GRANT ALL PRIVILEGES ON lingodash.* TO 'lingodashuser'@'%' IDENTIFIED BY 'lingodashpwd';