Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id BB8064760F5 for ; Tue, 10 Dec 2002 02:27:22 -0500 (EST) Received: from jive.SoftHome.net (jive.SoftHome.net [66.54.152.27]) by postgresql.org (Postfix) with SMTP id 1D3C147607D for ; Tue, 10 Dec 2002 02:27:22 -0500 (EST) Received: (qmail 24318 invoked by uid 417); 10 Dec 2002 07:27:22 -0000 Received: from slide-.softhome.net (HELO softhome.net) (172.16.2.21) by shunt-smtp-out-0 with SMTP; 10 Dec 2002 07:27:22 -0000 Received: from localhost (localhost [127.0.0.1]) (uid 417) by softhome.net with local; Tue, 10 Dec 2002 00:27:21 -0700 References: In-Reply-To: From: sharmad@softhome.net To: pgsql-php@postgresql.org Reply-To: sharmad@softhome.net Subject: Re: Httpd2.0 / PHP / PostgreSQL Date: Tue, 10 Dec 2002 00:27:20 -0700 Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Sender: sharmad@softhome.net X-Originating-IP: [61.1.73.85] Message-ID: X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/17 X-Sequence-Number: 1692 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@postgresql.org > [mailto:pgsql-php-owner@postgresql.org]På vegne af sharmad@softhome.net > Sendt: 10. december 2002 06:19 > Til: pgsql-php@postgresql.org > Emne: [PHP] Httpd2.0 / PHP / PostgreSQL > > > > Hi all, > I have installed redhat8.0 on my system. When i made phpinfo.php file > containing 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)