I haven't tried this but I would think this is highly unsupported. Even if it did work, it will be reset upon upgrading Tableau Server (if upgrade doesn't fail as a result of this).
Is this a company security requirement?
Thank you for your response. Yes, this is a security requirement.
For my remote connections to the PostGresSQl I have the pg_hba.conf configured with md5 however I'm not using the tabwgadmin id.
# remote connections
host all tableau 0.0.0.0/0 md5
host all tableau ::0/0 md5
To get my connection to the PostGreSQL database I also added a file pgpass.conf in the following directory
Here is some documentation on setting up this file. PostgreSQL: Documentation: 9.1: The Password File
Hope this helps.
We had a customization to the postgres security that restricted database access to specific hosts that we enabled by editing [Install Root]\[Version]\templates\pg_hba.conf.templ. Any time you reconfigured the server, your settings would be preserved because the pg_hba.conf file would be derived from the template. Note that, Vien Hua mentioned, hacking things up this way isn't supported, and template changes DO get wiped out each time you upgrade. Additionally, these template changes would best be made to each host in the Tableau Server, in case you decided to move the Repository process(es) from one host to another (if you have a multi-node cluster).
For fun, I played around with the pg_hba.conf file and tried to do an upgrade. It failed during the uninstallation (when Tableau Server attempts to take a backup automatically). So yeah... be careful...
Earlier I was able to connect without password to tblwgadmin user.
Now I edited pg_hba.conf from Trust to md5 and also included an entry in pgpass and config default.
Now it doesnt allow to login without password, but I get "Connection Failed" error.
Is there any other file or place where we have to type in our password?
Dear all, Please help me in this
Thanks to all who have responded to this discussion. I have finally resolved this issue and have set password successfully for tableau default admin user "tblwgadmin" in both standalone and cluster environments. Please email me (email@example.com) in person if you need to know the steps for this implementation.