[Solved] Remote Postgres access

[nieznany]

Hello,

I'd like to ask for enabling remote access for the Postgres database:

Database: nieznany_project_magma_db
user: nieznany_admin
host: johnny.heliohost.org

Which, as I hope, will help me fix this error i get when trying to connect from my laptop using python3/psycopg2

psycopg2.OperationalError: could not translate host name "johnny.heliohost.org" to address: Unknown host


Xwin.tk (on Heliohost discord server) suggested it may be because of Johnny being restarted, but the situation maintains during a period of many hours while, as I believe, the remote access wasn't enabled.

 

Thank you in advance.

[Luigi123]

Our root admin Krydos will gladly enable those for you whenever he gets a chance!

 

Escalating

[Krydos]

Remote access enabled.

psycopg2.OperationalError: could not translate host name "johnny.heliohost.org" to address: Unknown host

The dns on the system this is running on is probably broken. Perhaps port 53 is blocked in the firewall? You can probably fix it by using 65.19.141.67 as the host instead of johnny.heliohost.org though.

[nieznany]

Remote access enabled.

psycopg2.OperationalError: could not translate host name "johnny.heliohost.org" to address: Unknown host

The dns on the system this is running on is probably broken. Perhaps port 53 is blocked in the firewall? You can probably fix it by using 65.19.141.67 as the host instead of johnny.heliohost.org though.

 

Apparenty, the issue was related with the way i used to get the credentials for the database (to read it from a file) - the Windows new line encoding ("\r\n") was passed along the credentials to psycopg2 and libpg and raised the error. So it actually makes no difference if i use the URL or IP. Thanks for the suggestion though!

Edited February 3, 2021 by nieznany