daskunk

THANK YOU SO MUCH! When I initially created the daskunk_php userid (weeks ago now) it was my first time working with the Postgresql admin tools and I could've sworn I not only created the user id but added it to the database. I went through and tried adding it again just now, and it says it was submitted successfully. So now when I run the php script I'm past the pg_connect error and on my way with actual queries!! I can't tell you how much I appreciate your help. Thank you again.

Thank you for trying it out. This is what I'm calling from my browser https://daskunk.heliohost.org/pbc/psql.php

Oh and I tried with and without the Port=5432 ... same result either way. Thanks

Reverted back to the first one and tried again. $dbconn=pg_connect("host=localhost port=5432 dbname=daskunk_DaSkunkWorksPBC user=daskunk_php password=*****") Still getting this error Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "::1", user "daskunk_php", database "daskunk_DaSkunkWorksPBC", SSL off in /home/daskunk/public_html/pbc/psql.php on line 12

I tried both $connessione=pg_connect("host=localhost dbname=daskunk_DaSkunkWorksPBC user=daskunk_php password=<removed>") or die("Database non disponibile"); which resulted in Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "::1", user "daskunk_php", database "daskunk_DaSkunkWorksPBC", SSL off in /home/daskunk/public_html/pbc/psql.php on line 12 and $connessione=pg_connect("host=localhost.heliohost.org dbname=daskunk_DaSkunkWorksPBC user=daskunk_php password=<removed>") or die("Database non disponibile"); which resulted in Warning: pg_connect(): Unable to connect to PostgreSQL server: could not translate host name "localhost.heliohost.org" to address: Name or service not known in /home/daskunk/public_html/pbc/psql.php on line 12 So if neither is correct syntax, can someone please help with the correct syntax. Otherwise is one of them is correct usage of localhost, then that is not working either. I would really like to get my postgresql db working from my web site. Thank you

I was trying to figure this out on my own by reading various posts and I'm not sure if the problem is on my side or not. I recently created a Postgresql database and now I'd like to access it through a PHP script from my heliohost web site. The pg_connect call in my PHP script looks like $result=pg_connect("host=ricky.heliohost.org port=5432 dbname=daskunk_DaSkunkWorksPBC user=daskunk_php password=*****"); I'm getting this response Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "64.62.211.134", user "daskunk_php", database "daskunk_DaSkunkWorksPBC", SSL off in /home/daskunk/public_html/pbc/ psql.php on line 11 I've seen some posts indicating remote access is disabled by default and we have to ask your support team to enable it. My info Database: daskunk_DaSkunkWorksPBC User: daskunk_php Domain: daskunk.heliohost.org Server: ricky Any help in resolving this is greatly appreciated. Thank you in advance.