lunchbox Posted October 10, 2019 Share Posted October 10, 2019 (edited) I'm getting the following error: no pg_hba.conf entry for host "XXX.XXX.XXIP", user "lunchbox_instaDBer", database "lunchbox_instaquiz.default", SSL off My app insists that I use the database+schema string to connect. is there any way to sort this on the server side? I'm on johnny.heliohost.org PS. I can already connect with "psql -h johnny.heliohost.org -U lunchbox_instaDBer -W lunchbox_instaquiz" without difficulty Edited October 10, 2019 by lunchbox Link to comment Share on other sites More sharing options...
flazepe Posted October 10, 2019 Share Posted October 10, 2019 This support request is being escalated to our root admin. Link to comment Share on other sites More sharing options...
Krydos Posted October 10, 2019 Share Posted October 10, 2019 Does it work now? Link to comment Share on other sites More sharing options...
lunchbox Posted October 11, 2019 Author Share Posted October 11, 2019 no, same error: psql: FATAL: no pg_hba.conf entry for host "xxx.xxx.xxx.xx", user "lunchbox_instaDBer", database "lunchbox_instaquiz.default", SSL off Link to comment Share on other sites More sharing options...
Krydos Posted October 11, 2019 Share Posted October 11, 2019 I don't think lunchbox_instaquiz.default is going to work. Link to comment Share on other sites More sharing options...
lunchbox Posted October 11, 2019 Author Share Posted October 11, 2019 Well thanks for your help anyways. I don't think there is any way around it on my end. Link to comment Share on other sites More sharing options...
Luigi123 Posted October 11, 2019 Share Posted October 11, 2019 (edited) You could always try our VPS server. You get to have the full root admin access and you can do anything you want! Visit https://www.heliohost.org/vps/ for more info. Edited October 11, 2019 by flazepe Fixed link Link to comment Share on other sites More sharing options...
Krydos Posted October 11, 2019 Share Posted October 11, 2019 I'm not sure what exactly you're trying to do, but rather than using remote postgresql, why don't you set up an api using php or another scripting language on the server? Link to comment Share on other sites More sharing options...
Recommended Posts