KNOWLEDGE BASE

All Users Unable to Login and Tableau Server Repository in Error State and Backgrounder Status Unavailable


Published: 24 Jan 2019
Last Modified Date: 20 Sep 2019

Issue

Tableau Server is degraded and no users are able to login. Repository shows in Error state. Backgrounder shows status unavailable from the output of the "tsm status -v" command and shows in Error state in the TSM UI.

Additionally, the following is present in the pgsql spawn.log:
 

FATAL:  data directory "/var/opt/tableau/tableau_server/data/tabsvc/pgsql/data" has group or world access
DETAIL:  Permissions should be u=rwx (0700).

Environment

  • Tableau Server 2018.2.1
  • Linux

Resolution

Run:
 
tsm configuration get -k data.dir

Take the output of this command, and then append the directories "/data/tabsvc/pgsql/data" to it. Then run the following command on that directory to change the permissions to those required to start the postgreSQL Repository successfully.
 
sudo chmod +R 700 <directory>

As an example, for the default data directory location, you would run:
 
sudo chmod +R 700 /var/opt/tableau/tableau_server/data/tabsvc/pgsql/data

Cause

The permissions on the data directory for the internal postgreSQL database used for the Tableau Server repository are not the ones required for postgreSQL to successfully start.

Additional Information

 
To check the permissions on the directory, run
 
tsm configuration get -k data.dir

Take the output of this command, and then append the directories "/data/tabsvc/pgsql/data" to it. Then run the following command on that directory to check the permissions.
 
sudo ls -al <directory>

You should see the following in the output:

drwx------. 19 tableau tableau 4096 Jan 24 16:38 data

If the permissions string to the left is not "drwx------", then the permissions are not correct.




Discuss this article... Feedback Forum
Did this article resolve the issue?