[Solved] Request: Remote Access To Postgresql

[flm]

Greetings. I would like to enable unrestricted remote access to the following database:

host: johnny.heliohost.org

port: 5432

database: flm_dds1

user: flm_postgres

 

Let me know if you need anything else for authentication or configuration purposes

[bdistler]

I would like to enable unrestricted remote access to the following database:

after you setup your database in cPanel --> [ MySQL Database Wizard ]

 

in cPanel's --> [ Remote MySQL ]

enter your ISP's IP address and you can add other IP address'

OR

If you want any IP in the world - to connect to the database then put a [ % ] there instead of any IP - this is a large security risk

[flm]

 

I would like to enable unrestricted remote access to the following database:

after you setup your database in cPanel --> [ MySQL Database Wizard ]

 

in cPanel's --> [ Remote MySQL ]

enter your ISP's IP address and you can add other IP address'

OR

If you want any IP in the world - to connect to the database then put a [ % ] there instead of any IP - this is a large security risk

 

 

Thank you very much for your prompt response.

 

Sadly, even though I added an '%' entry I'm still getting the same access error:

 

Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "::1", user "flm_postgres", database "flm_dds1"

 

Could it be that this configuration only applies to MySQL databases?

 

Nevermind, this is too much of a hassle. I'll use an Elephant postgreSQL server instead.

[wolstech]

 

 

I would like to enable unrestricted remote access to the following database:

after you setup your database in cPanel --> [ MySQL Database Wizard ]

 

in cPanel's --> [ Remote MySQL ]

enter your ISP's IP address and you can add other IP address'

OR

If you want any IP in the world - to connect to the database then put a [ % ] there instead of any IP - this is a large security risk

 

 

Thank you very much for your prompt response.

 

Sadly, even though I added an '%' entry I'm still getting the same access error:

 

Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "::1", user "flm_postgres", database "flm_dds1"

 

Could it be that this configuration only applies to MySQL databases?

 

That's exactly the issue. There's no way to do remote Postgres on your own. Krydos has to set it up for you.

 

If you want, I can escalate and have this done for you. Are you still interested? If so, what database, and what IPs should it be accessed from?

[Krydos]

The database flm_dds1 should now be accessible by the potgresql user flm_postgres from any IP. Let us know if you still can't connect.