From: | sharmad(at)softhome(dot)net |
---|---|
To: | pgsql-php(at)postgresql(dot)org |
Subject: | Re: Httpd2.0 / PHP / PostgreSQL |
Date: | 2002-12-10 07:27:20 |
Message-ID: | courier.3DF59759.000038F4@softhome.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
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(at)postgresql(dot)org
> [mailto:pgsql-php-owner(at)postgresql(dot)org]På vegne af sharmad(at)softhome(dot)net
> Sendt: 10. december 2002 06:19
> Til: pgsql-php(at)postgresql(dot)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)
From | Date | Subject | |
---|---|---|---|
Next Message | Kelvin Varst | 2002-12-10 07:45:50 | Re: Httpd2.0 / PHP / PostgreSQL |
Previous Message | Frank Bax | 2002-12-10 06:43:07 | Re: Httpd2.0 / PHP / PostgreSQL |