X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E04C452942 for ; Mon, 15 Aug 2005 23:19:02 -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 09158-09 for ; Tue, 16 Aug 2005 02:18:59 +0000 (GMT) Received: from web33304.mail.mud.yahoo.com (web33304.mail.mud.yahoo.com [68.142.206.119]) by svr1.postgresql.org (Postfix) with SMTP id 87521528FF for ; Mon, 15 Aug 2005 23:18:58 -0300 (ADT) Received: (qmail 73905 invoked by uid 60001); 16 Aug 2005 02:19:02 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=5JB4rCKAEEGd5WVP9YBgBGCIS9WcTg4FW5/sjBWfLGwZn57nJ02QMZ9LOp8G2NfmYT8d78AHMHjaZ98XmHm0i2rdy2mzYMEeAeWE7WakA40VP68oqfjBkrWRdo7I3yMXU7ART3JJyv3Vw6WmpWXtiEFt0Bpjvc66TtN7NWQb8yA= ; Message-ID: <20050816021902.73901.qmail@web33304.mail.mud.yahoo.com> Received: from [70.56.83.222] by web33304.mail.mud.yahoo.com via HTTP; Mon, 15 Aug 2005 19:19:02 PDT Date: Mon, 15 Aug 2005 19:19:02 -0700 (PDT) From: Subject: Re: Problem about connecting PostgreSQL through TCP/IP To: Hui Chen , pgsql-php@postgresql.org In-Reply-To: <923c3c1405081410326a1c2880@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.552 required=5 tests=[DNS_FROM_RFC_ABUSE=0.374, NO_REAL_NAME=0.178] X-Spam-Level: X-Archive-Number: 200508/2 X-Sequence-Number: 3214 did you enable the "i" flag when you started the postmaster? if you didn't do that, tcp/ip will not connect! http://www.postgresql.org/docs/7.4/interactive/app-postmaster.html good luck. --- Hui Chen wrote: > Hello, everyone, > > 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 > hints. Thanks a million. > > 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 > > In postgresql.conf, these three lines were inserted, > > listen_addresses = '*' > port = 5432 > max_connections = 100 > > The following lines were inserted to pg_hba.conf: > local all all > password > host all all 127.0.0.1/32 > password > host all all 192.168.0.0/1 > password > > restart posgresql by > /sbin/service postgresql restart > The server was restarted OK. > > The PHP script used to connect database is as > follows, > $conn = pg_connect("host=localhost port=5432 > dbname=foodb user=foo > password=foo") or die ("Can not connect to > postgres"); > $result=pg_exec("SELECT * FROM footbl"); > $fetch = pg_fetch_row($result); > print ""; > print $fetch[0]; > print ""; > > pg_close($conn); // Close this connection > ?> > > 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 > > On commandline again, I used the following to > connect database, > psql -d foodb -h localhost -p 5432 -U foo > Password: ************ > Welcome to psql 8.0.3, the PostgreSQL interactive > terminal. > > Type: \copyright for distribution terms > \h for help with SQL commands > \? for help with psql commands > \g or terminate with semicolon to execute > query > \q to quit > > foodb=> > > It is OK. Then I disabled "iptables" temporarily for > testing purpose by > /sbin/service iptables stop > Flushing firewall rules: > [ OK ] > Setting chains to policy ACCEPT: filter > [ OK ] > Unloading iptables modules: > [ OK ] > > 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" > which means postgresql server indeed saw the telnet > connection. > > I tried this on any of my other machines in the LAN, > I observed the same thing. > > In summary, it seemed the postgresql allowed TCP/IP > connection, and > 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='function.pg-connect'>function.pg-connect]: > Unable to connect > to PostgreSQL server: could not connect to server: > Permission > denied\n\tIs the server running on host > "localhost" and > accepting\n\tTCP/IP connections on port 5432? in > /foo/connectdb.php on > line 2 > > Interestingly, when I checked the log file for > postgresql again, it > did not have anything for this connection failure. > It seemed the > 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 > > What could go wrong? > > Thanks a lot for your reading this lengthy email. > Waiting for your help! > > Gray > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com