Difference between revisions of "Dashboard Users Guide"

From Lingoport Wiki
Jump to: navigation, search
(MySQL Packet Error)
(MySQL Packet Error)
Line 81: Line 81:
 
<pre>
 
<pre>
 
[mysqld]
 
[mysqld]
max_allowed_packet=16M
+
max_allowed_packet = 16M
 
</pre>
 
</pre>
   
 
Stop the service, typically with:
 
Stop the service, typically with:
sudo service mysqld stop
+
<pre> >sudo service mysqld stop </pre>
   
 
verify it's stopped and restart it:
 
verify it's stopped and restart it:
  +
<pre>
 
sudo service mysqld status
 
sudo service mysqld status
 
sudo service mysqld start
 
sudo service mysqld start
  +
</pre>
   
to verify the packet size allowed has been modified, in mysql do :
+
To verify the packet size allowed has been modified, in mySQL do :
  +
<pre>
show variables like 'max_allowed_packet';
 
  +
mysql> show variables like 'max_allowed_packet';
  +
</pre>
   
 
https://dev.mysql.com/doc/refman/5.7/en/packet-too-large.html
 
https://dev.mysql.com/doc/refman/5.7/en/packet-too-large.html

Revision as of 17:07, 18 May 2018

Introduction

About Lingoport Dashboard

The Lingoport Dashboard, built on the SonarQube platform, helps you track and share the progress of your internationalization and localization efforts company-wide, by displaying both high-level and detailed views of your Globalyzer Project Scan data and your Lingoport Resource Manager status information.

For more details about Globalyzer and Lingoport Resource Manager please visit: Lingoport Suite.

LingoportDashboard.jpg

When to Update the Dashboard Server

You will need to re-run the Lingoport Dashboard Server Installer whenever you upgrade to a later version of the Dashboard. Be sure to retain your current Dashboard database by unchecking the Install LINGODASH Database Data checkbox.

For more details, see Updating Your Existing Installation.

When to Update the Dashboard Client

You will need to re-run the Lingoport Dashboard Client Installer whenever you:

  • Set up a new or updated version of Globalyzer
  • Set up a new or updated version of Lingoport Resource Manager (LRM)
  • Upgrade to a later version of the Lingoport Dashboard Client

Starting the Dashboard Server

Simple Startup

  1. On the system where the Lingoport Dashboard Server was installed, go to the directory <server install directory>/bin.
  2. > cd /var/lib/jenkins/lingoport/dashboard-server-x.y.z/bin/
    
  3. Choose your platform directory and then run sonar.sh start. To make sure that it started, check the status sonar.sh status.
  4. > cd linux-x86-64
    > ./sonar.sh start
    > ./sonar.sh status
    
  5. Give it a few minutes and then open a browser and enter http://localhost:9000 to see the Dashboard. If you installed with a port other than 9000, use that port instead.
  6. If the browser comes up in maintenance mode, the database may need to be upgraded. Enter http://localhost:9000/setup and follow the directions on the page.

Starting as a Service

To run the Sonar process as a service, follow the instructions at SonarQube.

Viewing the Lingoport Dashboard

  1. On your local system, open a browser and enter the host name and port number of the Lingoport Dashboard Server. For example: http://company.net:9000/
  2. Click the Help on Lingoport Dashboard link at the bottom of the page to learn more about the Lingoport Dashboard features.
  3. Read the SonarQube introduction to learn about the capabilities of the SonarQube framework.
  4. For administration features, click LOG IN in the menu bar and enter:
    Login: admin
    Password: admin
    Be sure to change the password. As the Administrator, you will be able to adjust the dashboard configuration, as well as add Users and Groups to fine tune access to your Lingoport Dashboard Projects.

Uploading Project Data to the Lingoport Dashboard

Generate Globalyzer Scan Report

Generate LRM Status Report

Upload Globalyzer and LRM Data to Dashboard

Removing an Uploaded Lingoport Dashboard Project

Changing Project Configuration

sonar-project.properties

MySQL Packet Error

A communication packet is a single SQL statement sent to the MySQL server, a single row that is sent to the client, or a binary log event sent from a master replication server to a slave.

The largest possible packet that can be transmitted to or from a MySQL 5.7 server or client is 1GB.

When a MySQL client or the mysqld server receives a packet bigger than max_allowed_packet bytes, it issues an ER_NET_PACKET_TOO_LARGE error and closes the connection. With some clients, you may also get a Lost connection to MySQL server during query error if the communication packet is too large.

Both the client and the server have their own max_allowed_packet variable, so if you want to handle big packets, you must increase this variable both in the client and in the server.

To resolve this issue, please see the steps below:

Set max_allowed_packet in the /etc/my.cnf file. For example, to set the size for the server to 16MB, add the following lines in an option file:

[mysqld]
max_allowed_packet = 16M

Stop the service, typically with:

 >sudo service mysqld stop 

verify it's stopped and restart it:

sudo service mysqld status
sudo service mysqld start

To verify the packet size allowed has been modified, in mySQL do :

mysql> show variables like 'max_allowed_packet';

https://dev.mysql.com/doc/refman/5.7/en/packet-too-large.html