HelioHost Posted March 29, 2020 Posted March 29, 2020 Username: chrisvan, Server: Tommy, Main domain: bloxtech.heliohost.org Dear HelioHost, I'm really satisfied with your service, thank you a lot! Could my database's remote access be enabled for PostgreSQL? Database name: chrisvan_gkxDatabase user: chrisvan_db Thank you in advance and I look forward to hearing from you soon! Best regards,Chris van Chip
Krydos Posted March 30, 2020 Posted March 30, 2020 You already requested and received remote access for that database and user at https://www.helionet.org/index/topic/38998-hh654097-postgresql-not-adding-account/?p=172225
HelioHost Posted March 30, 2020 Author Posted March 30, 2020 Thank you, I'd apologize for the duplicate request. I've set tommy.heliohost.org:5432 as host, and I got this error: pq: no pg_hba.conf entry for host "54.74.97.86", user "chrisvan_db",database "chrisvan_gkx", SSL off How can I resolve this issue? Thank you in advance, Chris Op ma 30 mrt. 2020 03:08 schreef Heliohost Support : > You already requested and received remote access for that database and> user at> https://www.helionet.org/index/topic/38998-hh654097-postgresql-not-adding-account/?p2225>>> You may view the status of your ticket by visiting:>> https://www.helionet.org/index/index.php?showtopic9042>> Thank you,> Heliohost support> https://www.heliohost.org/> https://www.helionet.org/>>
HelioHost Posted March 30, 2020 Author Posted March 30, 2020 Wait, my apologies. I filled the username at the place of the database andvice versa. Op ma 30 mrt. 2020 07:41 schreef Heliohost Support : > Thank you, I'd apologize for the duplicate request.> I've set tommy.heliohost.org:5432 as host, and I got this error:> pq: no pg_hba.conf entry for host "54.74.97.86", user "chrisvan_db",> database "chrisvan_gkx", SSL off> How can I resolve this issue?> Thank you in advance,> Chris> Op ma 30 mrt. 2020 03:08 schreef Heliohost Support :> > You already requested and received remote access for that database and> > user at> >> https://www.helionet.org/index/topic/38998-hh654097-postgresql-not-adding-account/?p2225> >> >> > You may view the status of your ticket by visiting:> >> > https://www.helionet.org/index/index.php?showtopic9042> >> > Thank you,> > Heliohost support> > https://www.heliohost.org/> > https://www.helionet.org/> >> >>> You may view the status of your ticket by visiting:>> https://www.helionet.org/index/index.php?showtopic9042>> Thank you,> Heliohost support> https://www.heliohost.org/> https://www.helionet.org/>>
HelioHost Posted March 30, 2020 Author Posted March 30, 2020 Unfortunately, it seems not working still. What is the PostgreSQL host? Op ma 30 mrt. 2020 07:51 schreef Heliohost Support : > Wait, my apologies. I filled the username at the place of the database and> vice versa.> Op ma 30 mrt. 2020 07:41 schreef Heliohost Support :> > Thank you, I'd apologize for the duplicate request.> > I've set tommy.heliohost.org:5432 as host, and I got this error:> > pq: no pg_hba.conf entry for host "54.74.97.86", user "chrisvan_db",> > database "chrisvan_gkx", SSL off> > How can I resolve this issue?> > Thank you in advance,> > Chris> > Op ma 30 mrt. 2020 03:08 schreef Heliohost Support :> > > You already requested and received remote access for that database and> > > user at> > >> >> https://www.helionet.org/index/topic/38998-hh654097-postgresql-not-adding-account/?p2225> > >> > >> > > You may view the status of your ticket by visiting:> > >> > > https://www.helionet.org/index/index.php?showtopic9042> > >> > > Thank you,> > > Heliohost support> > > https://www.heliohost.org/> > > https://www.helionet.org/> > >> > >> >> > You may view the status of your ticket by visiting:> >> > https://www.helionet.org/index/index.php?showtopic9042> >> > Thank you,> > Heliohost support> > https://www.heliohost.org/> > https://www.helionet.org/> >> >>> You may view the status of your ticket by visiting:>> https://www.helionet.org/index/index.php?showtopic9042>> Thank you,> Heliohost support> https://www.heliohost.org/> https://www.helionet.org/>>
HelioHost Posted March 30, 2020 Author Posted March 30, 2020 Thank you! This is now my connection string:jdbc:postgres://chrisvan_gkx:password@tommy.heliohost.org:5432/chrisvan_db?sslmode=dsable I got this error: dial tcp 127.0.0.1:5432: connect: connection refused Is there any way to resolve this? Op ma 30 mrt. 2020 08:30 schreef Heliohost Support : > The host should be tommy.heliohost.org:5432>>> You may view the status of your ticket by visiting:>> https://www.helionet.org/index/index.php?showtopic9042>> Thank you,> Heliohost support> https://www.heliohost.org/> https://www.helionet.org/>>
Krydos Posted March 31, 2020 Posted March 31, 2020 Try this jdbc:postgres://chrisvan_gkx:password@65.19.143.6:5432/chrisvan_db?sslmode=disable
Recommended Posts