nieznany Posted February 2, 2021 Posted February 2, 2021 Hello,I'd like to ask for enabling remote access for the Postgres database:Database: nieznany_project_magma_dbuser: nieznany_adminhost: johnny.heliohost.orgWhich, as I hope, will help me fix this error i get when trying to connect from my laptop using python3/psycopg2psycopg2.OperationalError: could not translate host name "johnny.heliohost.org" to address: Unknown hostXwin.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 Posted February 2, 2021 Posted February 2, 2021 Our root admin Krydos will gladly enable those for you whenever he gets a chance! Escalating
Krydos Posted February 3, 2021 Posted February 3, 2021 Remote access enabled. psycopg2.OperationalError: could not translate host name "johnny.heliohost.org" to address: Unknown hostThe 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 Posted February 3, 2021 Author Posted February 3, 2021 (edited) Remote access enabled.psycopg2.OperationalError: could not translate host name "johnny.heliohost.org" to address: Unknown hostThe 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
Recommended Posts