2 Replies Latest reply on Nov 1, 2013 11:52 AM by Kyle Pipkins

    PostgreSQL DB isn't connecting in Web browser

    Kyle Pipkins

      All,

       

      I've been using Tableau desktop for a while, new to server. I installed server and uploaded a workbook that uses a live PostgreSQL pull. I made sure to install the driver on the Microsoft server as well. On my Mac or PC when I go to through the browser to open Tableau Server and click on the workbook I'm prompted for the password to the database housing the sql. It just loops through entering the password indefinitely. But, if I open Tableau Desktop and log on to the server from there everything works.

       

      I don't understand, can someone point me in the right direction please?

       

      Thanks!

        • 1. Re: PostgreSQL DB isn't connecting in Web browser
          James Golden

          Are you looking to report on usage stats?  I believe you'll need to add the ip address from your desktop machine, or whoever is looking to hit the postgresql DB, to the pg_hba.conf.templ file.  Something like this:

           

           

          # TYPE DATABASE USER CIDR-ADDRESS METHOD

           

          # IPv4      local      connections:

           

          host           all           all           127.0.0.1/32      trust

           

          host           all           all           10.0.0.0/8      trust

           

           


          • 2. Re: PostgreSQL DB isn't connecting in Web browser
            Kyle Pipkins

            I wasn't looking to report on usage stats but you are right about the IP address trust. The PostgreSQL database only allowed internal access so through a web browser it kicked it back out whereas through desktop it was fine. Thanks for the idea.

             

            Cheers!