Loading

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

Udgivelsesdato: Apr 13, 2024
Beskrivelse

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).

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.
Løsning
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
Yderligere ressourcer
 
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.



Vidensartikelnummer

001471332

 
Indlæser
Salesforce Help | Article