Analyzing Tableau Log Files with Logshark

What is Logshark ?

Logshark is a command-line utility that you can run against Tableau logs to generate a set of workbooks that provide insights into system performance, content usage, and error investigation. You can use Logshark to visualize, investigate, and solve issues with Tableau at your convenience.

Prerequisites :

  1. Configuring PostgreSQL for Logshark :

  • Download PostgreSQL Database from http://www.enterprisedb.com/products-services-training/pgdownload#bwindows and install it on your computer.
  • For creating a Login Role for Logshark, Open pgAdmin, the PostgreSQL administration tool.
  • Connect to the PostgreSQL server using the superuser login account.
  • Right click on Login Roles and choose New Login Role…
  • In the New Login Role dialog box, enter the following values:

Role name: logshark

Password: logshark

Role privileges: Select the Can create databases and Can login options.

2. Snapshot of Tableau Server Logs :

  • Generate a Tableau Server snapshot and store it in C:\logs

Install Logshark :

  • From the directory where you downloaded Logshark, run the Logshark Setup program, double-click the file Setup Logshark v1.0.exe.
  • Click Install to use the default configuration. This adds Logshark to the PATH environment variable.
  • Click Options if you need to change the default installation directory (from C:\Program Files\Logshark).

Configure Logshark :

  • In a text editor, open the configuration file: <install_directory>\Config\Logshark.config file. In the Logshark.config file, change the <PostgresConnection> settings to match your PostgreSQL setup.
  • Set the Server address attribute to the name of the computer that is running PostgreSQL. For example, if you have installed PostgreSQL on your local computer, use localhost as the Server address.
  • Set the port attribute to the port your server uses if it is different from the default. The default port is 5432.
  • For the user, set both the username and password to logshark to match the role/user and password you added when you Configured the PostgreSQL for Logshark.
  • The Server address attribute should just contain the hostname or IP address of the computer (for example, mytableauserver.tableau.com), and should not be prefixed with the protocol (http or https).
  • When using a non-standard port for your Tableau Server, ensure the port attribute is set correctly (for example, ‘http’ has port=80, and ‘https’ has port=443).
  • The site attribute cannot be blank. If you are using the default site (for example, URL: http://localhost/#), specify Default as the name (site=Default).
  • To publish workbooks, the user account you specify must exist on the Tableau Server (and the site) with Publisher permissions and the permissions to create projects. (Site Administrator role will be the easiest option).

 

1

 

Run Logshark :

  • Open a Command Prompt window as administrator and move inside the Logshark directory.
  • Run ‘Logshark.exe’ and specify the path to the Tableau archive and any other option you wish to set. Logshark uses the following syntax :

          logshark [target] [options]

  • To see all the Logshark command options and syntax, use the –help option :

          logshark –help

  • Now to analyze the logs and generate Tableau workbooks use the following command :

          logshark C:\Logs\logs.zip –startlocalmongo

 

2

  • To see the Tableau workbooks generated go inside the Logshark directory and open the output folder.

 

3

Leave A Reply

Your email address will not be published. Required fields are marked *