I'm able to connect to my PGSQL database from SSHv2.

But when I try to do the same thing on MicroOLAP Database Designer, I get this message:

(Note: From my college PC, I can connect. But I can't connect from home.) enter image description here

My configuration:

enter image description here enter image description here

Here's me on arka.foi.hr via SSHv2 (accessible from home):

enter image description here

  • you should show also pg_hba.conf it is most important information in connection settings. – sufleR Dec 7 '12 at 9:17
  • Any improvement on this? – dezso Dec 10 '12 at 21:52
  • Nope. I asked a colleague on college, and he can't connect either. But I will accept your answer since it's technically correct :). – Tool Dec 11 '12 at 1:26
  • My problem doesn't really exist. I posted the question in belief that it was my fault I can't connect, which is not true - the administrator disabled external connections. – Tool Dec 11 '12 at 23:20

From the error dialog it is clear that something around your connection is wrong.

First be sure that everything you included here matches: you have an error about localhost and port 3082 and you present a connection dialog with a foreign host and port 5432.

Then you have to teach PostgreSQL that it should accept connections from your home. This can be done via the pg_hba.conf file. You will need a line added like this (the header is already there) - if you don't have access to it, ask the person in charge of it to do this:

# TYPE  DATABASE        USER            ADDRESS                 METHOD
host    dnizetic        dnizetic        md5
| improve this answer | |
  • Do you mean teaching my local PGSQL or remote PGSQL? Because I can't change pg_hba.conf on the remote machine - I don't "own" the server's PGSQL. (I also looked for such file on my machine, and I can't find it - but I doubt you meant that). – Tool Dec 7 '12 at 9:25
  • The presented error matches the input images I've uploaded. I checked this twice. – Tool Dec 7 '12 at 9:27
  • @Tool Is your local machine at home arka.foi.hr? If not, then at least one of us don't understand something :) All in all, do you want to connect to your local PostgreSQL or the remote one? – dezso Dec 7 '12 at 9:40
  • The remote one. No, my local machine is localhost ( arka.foi.hr is a remote IP. – Tool Dec 7 '12 at 10:04
  • 2
    Is the SSH tunneling correctly configured? You haven't showed us the MicroOLAP tunneling configuration. – ypercubeᵀᴹ Dec 7 '12 at 10:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.