[Solved] Johnny Pgadmin Access

[lloguers]

Hi,

 

I'm trying to access my postgresql database in johnny server via pgadmin without success.

I've created a database lloguers_ad and assigned a user to it (lloguers_sa)

 

in pgadmin i've put the following info:

host; johnny.heliohost.org

service;: void

maintenanceDB: postgres

username: lloguers_sa

password (correct password)

 

The error i'm reciving is a timeout.

 

I've tried a telnet to johnny.heliohost.org to 5432 and it doesn't connect. If I try the mysql port (3306) it is responding ok

 

Is there any problem with my database configuration or is there a problem of the server itself?

 

Thanks,

 

Ismael,

[wolstech]

The postgres server is not configured for remote access. I remember Krydos having to do something on Tommy to make it work.

 

Escalating...

[Krydos]

What database are you trying to connect to? lloguers_ad?

 

Remote postgresql access should now be enabled for

username=lloguers_sa
database=lloguers_ad

[lloguers]

Thank you for the quick support,

 

I've tried to connect now, but i'm receiving the message:

could not connect to server: Conexión rehusada Is the server running on host "johnny.heliohost.org" (64.62.211.131) and accepting TCP/IP connections on port 5432?

If I try to telnet johnny on 5432 I receive:

$ telnet johnny.heliohost.org 5432
Trying 64.62.211.131...
telnet: Unable to connect to remote host: Connection refused

Am I doing something wrong?

 

Thanks,

[Krydos]

Does it work now?

[lloguers]

Hello,

 

Nearly, now the problem is the config in hba.conf

FATAL: no pg_hba.conf entry for host "85.94.178.189", user "lloguers_sa", database "postgres", SSL off

Sorry,

 

I tried to access postgres database by mistake. Accessing lloguers_ad database just works!!!

 

Thank you very much!! What a great support!