X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A9C965295C for ; Thu, 18 Aug 2005 17:39:50 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 43586-05 for ; Thu, 18 Aug 2005 20:39:45 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.194]) by svr1.postgresql.org (Postfix) with ESMTP id D51FE528D4 for ; Thu, 18 Aug 2005 17:39:44 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id i22so407193wra for ; Thu, 18 Aug 2005 13:39:46 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=S4pmP7RJDph5J6EuhJuMBWD8KYQKtJzSysJhiYHCF9HADUwpkgvvviAHvcsC6+JG0XDA5Lt/rakkbkA+4aAzgyyiWfUYbY8cKT5RLKgg5bjZ1+QRe5QB6NrZ/B33YN29mgilK/ic3zt3Gt9uvFl6rm+OZxTfGv+o0j5sIElHicQ= Received: by 10.54.22.39 with SMTP id 39mr1414512wrv; Thu, 18 Aug 2005 13:39:46 -0700 (PDT) Received: by 10.54.98.9 with HTTP; Thu, 18 Aug 2005 13:39:45 -0700 (PDT) Message-ID: <923c3c14050818133930da1cf0@mail.gmail.com> Date: Thu, 18 Aug 2005 15:39:46 -0500 From: Hui Chen To: Gnanavel S Subject: Re: Problem about connecting PostgreSQL through TCP/IP Cc: pgsql-php@postgresql.org In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <923c3c1405081410326a1c2880@mail.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.058 required=5 tests=[AWL=0.034, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200508/22 X-Sequence-Number: 3234 Thanks a lot! If I typed the password wrong, I should be able to see a corresponding entry in the log file. The entry should look like "FATAL: password authentication failed for user foo". However, I did not see any entry corresponding to the failed connection at all. Therefore, I ruled out the possibility that the wrong password was the reason. Gray On 8/17/05, Gnanavel S wrote: >=20 >=20 >=20 > On 8/14/05, Hui Chen wrote: > > Hello, everyone, > >=20 > > Can anyone help me? I am quite frustrating now. I have been trying to > > connect PostgreSQL server through TCP/IP connection using PHP. I was > > not successful. Could please read the following and give me some=20 > > hints. Thanks a million. > >=20 > > OS: Fedora Core 4 ("uname -s -r" yields "Linux 2.6.12-1.1398_FC4smp") > > PostgreSQL: version 8.0.3 > > PHP: version 5.0.4 > >=20 > > In postgresql.conf, these three lines were inserted,=20 > > listen_addresses =3D '*' > > port =3D 5432 > > max_connections =3D 100 > >=20 > > The following lines were inserted to pg_hba.conf: > > local all all =20 > password > > host all all 127.0.0.1/32 password > > host all all 192.168.0.0/1 password > >=20 > > restart posgresql by > > /sbin/service postgresql restart > > The server was restarted OK. > >=20 > > The PHP script used to connect database is as follows,=20 > > > $conn =3D pg_connect("host=3Dlocalhost port=3D5432 dbname=3Dfoodb use= r=3Dfoo > > password=3Dfoo") or die ("Can not connect to postgres"); > > $result=3Dpg_exec("SELECT * FROM footbl"); > > $fetch =3D pg_fetch_row($result); > > print ""; > > print $fetch[0]; > > print ""; > >=20 > > pg_close($conn); // Close this connection > > ?> > >=20 > > Assume this PHP script is named as "connectdb.php", then on > > commandline, when I run the following, > > php connectedb.php > > I see correct results, e.g., > > foo > >=20 > > On commandline again, I used the following to connect database, > > psql -d foodb -h localhost -p 5432 -U foo > > Password: ************ > Whether the password you typed here is "foo"? > =20 > >=20 > > Welcome to psql 8.0.3, the PostgreSQL interactive terminal. > >=20 > > Type: \copyright for distribution terms=20 > > \h for help with SQL commands > > \? for help with psql commands > > \g or terminate with semicolon to execute query > > \q to quit > >=20 > > foodb=3D> > >=20 > > It is OK. Then I disabled "iptables" temporarily for testing purpose by= =20 > > /sbin/service iptables stop > > Flushing firewall rules: =20 > [ OK ] > > Setting chains to policy ACCEPT: filter [ > OK ] > > Unloading iptables modules: =20 > [ OK ] > >=20 > > On localhost, I tried this command, > > telnet localhost 5432 > > after hit "enters", telnet exited. I checked postgresql_%S.log and see > > "LOG: invalid length of startup packet"=20 > > which means postgresql server indeed saw the telnet connection. > >=20 > > I tried this on any of my other machines in the LAN, I observed the sam= e > thing. > >=20 > > In summary, it seemed the postgresql allowed TCP/IP connection, and=20 > > worked well. However, when I ran the PHP script through web browser, I > > did not get connection. Instead, in Apache web server's error_log, I > > see > > [client 192.168.1.10] PHP Warning: pg_connect() [ > href=3D'function.pg-connect'>function.pg-connect]: Unable to connec= t > > to PostgreSQL server: could not connect to server: Permission > > denied\n\tIs the server running on host "localhost" and=20 > > accepting\n\tTCP/IP connections on port 5432? in /foo/connectdb.php on > > line 2 > >=20 > > Interestingly, when I checked the log file for postgresql again, it > > did not have anything for this connection failure. It seemed the=20 > > connection did not send to the database server at all. However, > > 1) I disabled firewall > > 2) I can telnet the ports > > 3) I can run the script from commandline > >=20 > > What could go wrong? > >=20 > > Thanks a lot for your reading this lengthy email. Waiting for your help= !=20 > >=20 > > Gray > >=20 > > ---------------------------(end of > broadcast)--------------------------- > > TIP 4: Have you searched our list archives? > >=20 > > http://archives.postgresql.org=20 > >=20 >=20 >=20 >=20 > --=20 > with regards, > S.Gnanavel > Satyam Computer Services Ltd.