slimsim Posted December 1, 2020 Share Posted December 1, 2020 Hi, Please can you assist me with enabling remote access on my PostgreSql database? I've tried to connect with pgAdmin4, and enters the following information:Name: slimsim_ava_db_dev_1Host name / address: johnny.heliohost.orgPort: 5432Maintenance database: postgresqlUsername: slimsim_db_user This is error i get when trying to connect: Unable to connect to server: FATAL: no pg_hba.conf entry for host "92.34.255.150", user "slimsim_db_user", database "postgresql", SSL offThanks! Link to comment Share on other sites More sharing options...
flazepe Posted December 1, 2020 Share Posted December 1, 2020 This support request is being escalated to our root admins. Link to comment Share on other sites More sharing options...
Krydos Posted December 2, 2020 Share Posted December 2, 2020 user "slimsim_db_user", database "postgresql"You need to specify your database name, not the postgresql database. Link to comment Share on other sites More sharing options...
slimsim Posted December 3, 2020 Author Share Posted December 3, 2020 Thanks for the help! When I try with the following information in pgAdmin4:Name: slimsim_ava_db_dev_1Host name / address: johnny.heliohost.orgPort: 5432Maintenance database: slimsim_ava_db_dev_1Username: slimsim_db_user I get Unable to connect to server: FATAL: no pg_hba.conf entry for host "92.34.255.150", user "slimsim_db_user", database "slimsim_ava_db_dev_1", SSL off If I try the same information but use port 3306 i get: Unable to connect to server: received invalid response to SSL negotiation: JDo you know what the problem is?What port should I use? Thanks so much for the help! Link to comment Share on other sites More sharing options...
Krydos Posted December 5, 2020 Share Posted December 5, 2020 Remote access enabled. Port 5432 is postgresql. Port 3306 is mysql. Link to comment Share on other sites More sharing options...
Recommended Posts