Jump to content

daskunk

Members
  • Posts

    83
  • Joined

  • Last visited

  • Days Won

    3

Everything posted by daskunk

  1. Oh and I tried with and without the Port=5432 ... same result either way. Thanks
  2. 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
  3. 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
  4. 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.
×
×
  • Create New...