solooo7 Posted February 5, 2018 Share Posted February 5, 2018 I cannot remotely connect to postgres database database: api-masterusername: api-master-userhost: johnny.heliohost.org response I get : psql.bin: FATAL: no pg_hba.conf entry for host "137.97.155.**", user "api-master-user", database "api-master", SSL onFATAL: no pg_hba.conf entry for host "137.97.155.**", user "api-master-user", database "api-master", SSL off Link to comment Share on other sites More sharing options...
wolstech Posted February 5, 2018 Share Posted February 5, 2018 Krydos needs to enable remote access per database and per user. We don't have it turned on by default for security reasons. What IP addresses need access, or do you want it from any IP? Link to comment Share on other sites More sharing options...
solooo7 Posted February 5, 2018 Author Share Posted February 5, 2018 From any IP Link to comment Share on other sites More sharing options...
wolstech Posted February 5, 2018 Share Posted February 5, 2018 Moving so Krydos can enable this for you. 1 Link to comment Share on other sites More sharing options...
solooo7 Posted February 5, 2018 Author Share Posted February 5, 2018 I still get that error. Link to comment Share on other sites More sharing options...
wolstech Posted February 5, 2018 Share Posted February 5, 2018 Krydos hasn't turned it on yet. He'll post here when he does. It can take several hours. Link to comment Share on other sites More sharing options...
solooo7 Posted February 5, 2018 Author Share Posted February 5, 2018 Thank you for the update. Link to comment Share on other sites More sharing options...
Krydos Posted February 5, 2018 Share Posted February 5, 2018 Remote access enabled. 1 Link to comment Share on other sites More sharing options...
solooo7 Posted February 6, 2018 Author Share Posted February 6, 2018 (edited) I'm still not able to connect.I get that same error. Server [localhost]: johnny.heliohost.orgDatabase [postgres]: api-masterPort [6969]: 5432Username [postgres]: api-master-userpsql.bin: FATAL: no pg_hba.conf entry for host "137.97.151.241", user "api-master-user", database "api-master", SSL onFATAL: no pg_hba.conf entry for host "137.97.151.241", user "api-master-user", database "api-master", SSL off Edit: It works now.I didn't know I had to add my username in front of database name and database_username. Edited February 6, 2018 by solooo7 Link to comment Share on other sites More sharing options...
Recommended Posts