[Solved] Remote connection with PostgreSQL

[fjmduran]

Hello, I have been tryng to access PostgreSQL database, but it has been unsuccesfull.

I have read in forum about my error "Error: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "***.***.***", user "fjmduran", database "fjmduran_cestacompra", SSL off" but I do not find solution. I am sure of database name, and user name and password are right.

My connection string is "jdbc:postgresql://fjmduran.heliohost.org:5432/fjmduran_cestacompra","fjmduran","*"

I have try change fjmduran.heliohost.org by tommy.heliohost.org, but is was unsuccesfull, same error.

I have read in forum, that Krydos needs to enable remote access per database and per user.

Please, could you open access for any IP? Thanks,

 

 

[wolstech]

Correct, we don't allow it unless you explicitly request it. Since the required info is in the connection string, I'll let Krydos look at this to set it up.

[Krydos]

Remote access enabled.

[fjmduran]

Thanks a lot, it is running now