Hey Daniel. Have you already run through these steps to open access up to the Tableau Server repository? Collect Data with the Tableau Server Repository - Tableau. That's the second step listed in the install guide for the Tableau Server steps, so if you haven't done that yet, it would explain the issue.
Thank you for the response. I did go through that step and I just redoubled the effort and re-enabled the readonly user with a new password, configured, and restarted the server. Still no luck connecting to port 8060 or 8062. As I mentioned earlier, I am rather new to being a server admin, is there a way to check what port is opened up for pgsql.port currently? I see from multiple sources including here that 8060 is the default port of pgsql.port but I had to do some work with Tableau support to resolve an earlier issue that displayed port exhaustion so we had to extend the range of usable ports. I am not sure if that changed my defaults.
FYI, if it matters I am on Server 2018.1 on an Azure cloud instance.
You're right, the port should be 8060. I doubt changing the port ranges would have affected that. But to check using the TSM command, it's:
tsm configuration get --key pgsql.port
The most probable thing might be that your requests aren't making it to the server, though. Can you ensure that you can directly ping the machine hosting PostgreSQL? Not the main URL you'd use to access Tableau Server from a browser, but the actual host name, so you're not going through a load balancer.
Another thing you can check is the log file for the PostgreSQL database, at [install folder]\data\tabsvc\logs\pgsql. If your request made it to the PostgreSQL server, and it rejected it, it will appear there.
Finally, if you've enabled SSL on the internal PostgreSQL database, you'll need to check the SSL box on your Desktop connection.
Hopefully some of that helps...
Thank you for clarifying quite a bit!
I confirmed that 8060 is still the default port for pgsql.port which is nice. I also confirmed that I require the use Secure Socket Layers. Two down.
I checked the log file for PostgreSQL and there was only four files I could find that conformed to the time of my most recent login attempt. It is located in the pg_stat_tmp folder and they are all STAT files. I could not immediately read any of them and after consulting docs I did not gain much new insight. It seems like having a new file created whenever there is a failed login attempt is enough to say that the server is reachable.
Finally, I am a little embarrassed to ask, how do I determine the actual host name of the machine hosting PostgreSQL rather than just the URL? As I mentioned, it is a cloud instance so it probably is going through a load balancer.
Thank you for all of your help so far!
I am not sure if that is going to be helpful. Host name is just TableauServer. I tried using just TableauServer, TableauServer.DOMAIN NAME, DOMAIN NAME/TableauServer, all with no success. In fact, when I use the DOMAIN NAME, it is the only entry that is actually queried for 10-20 seconds. Everything else immediately throws an error.
I am able to ping TableauServer but not for purposes of PostgreSQL apparently.
Unfortunately, that did not work either.
Firewall stuff? Maybe you've got Windows firewall on the server that's blocking traffic to 8060? That's the only other thing I can really think of.
Nope, I checked all the firewall settings and everything Tableau is allowed through Windows Firewall.
I checked the PostgreSQL log file again and it created another file for my most recent login attempt. So I would assume that means my DOMAN NAME is correct, but there is something blocking the connection from being accepted.
Would tableau support be of any help on this or are they subsidiary to you Matt?
Yes! You can definitely get their help connecting to postgreSQL, as that is supported product functionality. I would not mention VizAlerts, simply because they've been told to send those requests to this forum--it'll help avoid confusion.
Matt Coles, after a lengthy back and forth process between Tableau Tier 2 server support, myself, and my network admin it was finally discovered that Windows firewall was blocking my IP address on the cloud server machine. Once that was resolved, I can now connect to the PostgreSQL server.
Following VizAlerts/install_guide.md at master · tableau/VizAlerts · GitHub , I have reached "Open VizAlertsConfig" workbook #8.
As you can see, I have the workbook and connected to PostgreSQL server:
But Sheet 1 does not include anything as it does in the installation guide:
Did I miss something along the way?
Running on Tableau Desktop 2018.1 and Tableau Server 2018.1.
Daniel, great to hear that you were able to work through the firewall issue!
That sheet should be blank until you have created the VizAlerts schedules, and until you have actually subscribed a viz to one of those schedules. The sheet tells VizAlerts what alerts need to be run, and when. So if you have none set up, you should expect to see none on the sheet.
If you have already set up your schedules, and subscribed something, then something should show. If it isn't, it could be that the schedule_name_filter parameter needs to be adjusted to match what you named your schedules as.
Let me know if that helps.