From: David C. Brown <dbrown@centennialwines.com>
To: Devi Munandar <devi@informatika.lipi.go.id>
Cc: pgsql-php@postgresql.org
Subject: Re: function not valid
Date: Mon, 31 Mar 2003 11:00:04 -0600
Message-ID: <3E887414.1030105@centennialwines.com> (raw)
In-Reply-To: <00ad01c2f771$c4540140$a6f0cda7@informatika.lipi.go.id>
References: <00ad01c2f771$c4540140$a6f0cda7@informatika.lipi.go.id>
It seems you do not have PostgreSQL configured correctly.
This is the key.
Warning: pg_connect() unable to connect to PostgreSQL server: FATAL 1: No
pg_hba.conf entry for host 127.1.1.0, user postgres, database pegawai in
/var/www/html/pgclass/database.inc.php on line 94
It seems you need to edit your pg_hba.conf to allow 127.1.1.0 permission to connect. Once you have it corrected you should restart PostgreSQL, then try again. As for the other warnings, you will get them once php fails to connect because the failure caused the link resource (connection to the database) to be invalid.
Dave
Devi Munandar wrote:
>hi..all
>
>I've install postgresql 7.2.2 on redhat linux 8.0, i've tried connect
>postgres pass through from client with php, but i got some problem with
>argument ar function like this;
>
>************************************
>Warning: pg_connect() unable to connect to PostgreSQL server: FATAL 1: No
>pg_hba.conf entry for host 127.1.1.0, user postgres, database pegawai in
>/var/www/html/pgclass/database.inc.php on line 94
>
>Warning: pg_exec(): supplied argument is not a valid PostgreSQL link
>resource in /var/www/html/pgclass/database.inc.php on line 155
>
>Warning: pg_numfields(): supplied argument is not a valid PostgreSQL result
>resource in /var/www/html/pgclass/database.inc.php on line 384
>
>Warning: pg_fetch_row(): supplied argument is not a valid PostgreSQL result
>resource in /var/www/html/pgclass/database.inc.php on line 256
>*****************************************
>
>and I think I need some postgresql function, so what can I do..?, if I need
>to install this argument...how the way...?
>
>
>Best Regards,
>
>--devi munandar
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: dbrown@centennialwines.com, devi@informatika.lipi.go.id
Subject: Re: function not valid
In-Reply-To: <3E887414.1030105@centennialwines.com>
References: <00ad01c2f771$c4540140$a6f0cda7@informatika.lipi.go.id> <3E887414.1030105@centennialwines.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox