pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: sharmad@softhome.net
To: pgsql-php@postgresql.org
Subject: Re: Httpd2.0 / PHP / PostgreSQL
Date: Tue, 10 Dec 2002 00:27:20 -0700
Message-ID: <courier.3DF59759.000038F4@softhome.net> (raw)
In-Reply-To: <NDBBJEKICKIBAAGMLICDAEMDCKAA.kelvin@varst.dk>
References: <NDBBJEKICKIBAAGMLICDAEMDCKAA.kelvin@varst.dk>

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 <? 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) 




view thread (4+ messages)  latest in thread

Message-ID: <courier.3DF59759.000038F4@softhome.net>
Permalink:  ../courier.3DF59759.000038F4@softhome.net/
Also on:    postgresql.org/message-id/courier.3DF59759.000038F4@softhome.net

 · 

reply

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: sharmad@softhome.net
  Subject: Re: Httpd2.0 / PHP / PostgreSQL
  In-Reply-To: <courier.3DF59759.000038F4@softhome.net>
  References: <NDBBJEKICKIBAAGMLICDAEMDCKAA.kelvin@varst.dk> <courier.3DF59759.000038F4@softhome.net>

* 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