Hi ,
Thanks firstly for all the replies i got for the mail :
I have changed the pg_hba.conf file in the following manner :
------------------------------------------------------------
local all ident sameuser
host all 127.0.0.1 255.255.255.255 trust
host lms 192.168.100.0 255.255.255.0 trust
------------------------------------------------------------
where lms is the database
and also changed tcpip_socket to true
the phpinfo() also shows me support for PostgreSQL as :
--with-pgsql=shared
I have touched and edited/made user for apache in postgres as stated in
httpd/conf.d/auth_pgsql.conf file
I still get the following error
------------------------------------------------------------
Warning: pg_pconnect() unable to connect to PostgreSQL server: FATAL 1:
IDENT authentication failed for user "dbname=lms" in
/home/pro/public_html/common.php on line 9
Warning: pg_exec(): supplied argument is not a valid PostgreSQL link
resource in /home/pro/public_html/common.php on line 11
Warning: pg_errormessage(): supplied argument is not a valid PostgreSQL link
resource in /home/pro/public_html/common.php on line 32
NO CONNECTION -
------------------------------------------------------------
Thanks and Rgrds
Sharmad Naik
Kelvin Varst writes:
Hi,
Have you changed the pg_hba file? The only connection allowed by default is
from 127.0.0.1. You should also change tcpip_socket to TRUE in the
postgresql.conf, otherwise the database do not accept connections from the
network.
Kelvin :-)
-----Oprindelig meddelelse-----
Fra: pgsql-php-owner@xxxxxxxxxxxxxx
[mailto:pgsql-php-owner@xxxxxxxxxxxxxx]På; vegne af sharmad@xxxxxxxxxxxx
Sendt: 10. december 2002 06:19
Til: pgsql-php@xxxxxxxxxxxxxx
Emne: [PHP] Httpd2.0 / PHP / PostgreSQL
Hi all,
I have installed redhat8.0 on my system. When i made phpinfo.php file
containing <? phpinfo(); ?> and ran the script it just doen't connect to the
pgsql database although all servers are started (httpd and postgresql) and
the php-pgsql rpm too is there.
I can query the database at the command prompt but not from the brower.
Can anyone tell me whats wrong
This problem doesn't exist in redhat 7.1 or so
Regards and thx
Sharmad
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Feel free to contact me (flames about my english and the useless of this
driver will be redirected to /dev/null, oh no, it's full...). (Michael
Beck, describing the PC-speaker sound device)
