lunchbox Posted October 10, 2019 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
Flaze Posted October 10, 2019 Posted October 10, 2019 This support request is being escalated to our root admin.
lunchbox Posted October 11, 2019 Author 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
Krydos Posted October 11, 2019 Posted October 11, 2019 I don't think lunchbox_instaquiz.default is going to work.
lunchbox Posted October 11, 2019 Author Posted October 11, 2019 Well thanks for your help anyways. I don't think there is any way around it on my end.
Luigi123 Posted October 11, 2019 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
Krydos Posted October 11, 2019 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?
Recommended Posts