gabriele Posted March 21, 2018 Share Posted March 21, 2018 I have the problem that I can't connect remotely to the postgres database I've made My connection parameters aredatabase: gabriele_postgresuser: gabriele_gianninahost: johnny.heliohost.orgThen the connection responds: psql: FATAL: no pg_hba.conf entry for host "your ip", user "gabriele_giannina", database "gabriele_postgres", SSL off I need help. Thanks Link to comment Share on other sites More sharing options...
wolstech Posted March 21, 2018 Share Posted March 21, 2018 By default, we don't allow remote connections. Our admin Krydos has to manually enable it per database and user if you want that to work. What IP addresses do you want access from (or do you want it to work from any)? Link to comment Share on other sites More sharing options...
gabriele Posted March 21, 2018 Author Share Posted March 21, 2018 I would want it to work from any. Thanks Link to comment Share on other sites More sharing options...
wolstech Posted March 21, 2018 Share Posted March 21, 2018 OK. I'll move this so he sees it. Please note though that there's been a delay in getting escalated requests like these handled lately though. The admin who handles these, Krydos, has been busy with non-HelioHost stuff recently. We're all volunteers and don't get paid for what we do here, so we do have a real life and a job to tend to at times Link to comment Share on other sites More sharing options...
gabriele Posted March 21, 2018 Author Share Posted March 21, 2018 Ok thanks a lot ! Will I receive a notification when the request will be handled? Link to comment Share on other sites More sharing options...
wolstech Posted March 21, 2018 Share Posted March 21, 2018 If you follow this topic here on the forum, yes you will. Krydos will post in this topic when it has been configured for you Link to comment Share on other sites More sharing options...
Krydos Posted March 22, 2018 Share Posted March 22, 2018 Remote access enabled. Link to comment Share on other sites More sharing options...
gabriele Posted March 23, 2018 Author Share Posted March 23, 2018 Thanks!Unfortunately I still have problems connecting. I get the following error message: Unable to connect to server:could not connect to server: Connection refused (0x0000274D/10061)Is the server running on host "johnny.heliohost.org" (65.19.141.67) and accepting TCP/IP connections on port 5432? Link to comment Share on other sites More sharing options...
Krydos Posted March 23, 2018 Share Posted March 23, 2018 Please post your connection string with the password removed. Link to comment Share on other sites More sharing options...
gabriele Posted March 23, 2018 Author Share Posted March 23, 2018 $host = "host = johnny.heliohost.org"; $port = "port = 5432"; $dbname = "dbname = gabriele_postgres"; $credentials = "user = gabriele_giannina password = ******"; $db = pg_connect("$host $port $dbname $credentials"); Link to comment Share on other sites More sharing options...
Krydos Posted March 23, 2018 Share Posted March 23, 2018 Is port 5432 blocked on your computer? You can check at http://portquiz.net:5432/ Link to comment Share on other sites More sharing options...
gabriele Posted March 23, 2018 Author Share Posted March 23, 2018 This is the result:This server listens on all TCP ports, allowing you to test any outbound TCP port.You have reached this page on port 5432.Your network allows you to use this port. (Assuming that your network is not doing advanced traffic filtering.) So it seems port 5432 is open.But now that I'm testing connection from my home private network I don't get anymore the error message. Is it possible that university public network does not allow connection to johnny.heliohost or has port 5432 blocked? Link to comment Share on other sites More sharing options...
Krydos Posted March 23, 2018 Share Posted March 23, 2018 Yes, I bet they have port 5432 blocked. Link to comment Share on other sites More sharing options...
Recommended Posts