pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Hui Chen <gray.chenhui@gmail.com>
To: javier wilson <javier.wilson@gmail.com>
Cc: pgsql-php@postgresql.org
Subject: Re: Problem about connecting PostgreSQL through TCP/IP
Date: Wed, 17 Aug 2005 12:46:16 -0500
Message-ID: <923c3c140508171046280fe820@mail.gmail.com> (raw)
In-Reply-To: <da884c2005081708555811194f@mail.gmail.com>
References: <923c3c1405081410326a1c2880@mail.gmail.com>
	<da884c2005081708555811194f@mail.gmail.com>

Hello, Javier,

Thanks. I tried accordingly. I change the line in /boot/grub/grob.conf from 
kernel /vmlinuz-2.6.12-1.1398_FC4smp ro root=LABEL=/ rhgb quiet
to
kernel /vmlinuz-2.6.12-1.1398_FC4smp ro root=LABEL=/ rhgb quiet selinux=0
. I then reboot the linux. I would assume it will disable SElinux
altogehter. The problem remains. I seems like it is not about SElinux.

Thanks!

Gray


On 8/17/05, javier wilson <javier.wilson@gmail.com> wrote:
> could this have something to do with SELinux? can you disable it alltogether
> and try?

> javier
> On 8/14/05, Hui Chen <gray.chenhui@gmail.com> 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,
> > <?php
> >   $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 "<html><body>";
> >    print $fetch[0];
> >    print "<body></html>";
> >
> >    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.,
> > <html><body>foo<body></html>
> >
> > 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() [<a
> > href='function.pg-connect'>function.pg-connect</a>]: Unable to connect
> > to PostgreSQL server: could not connect to server: Permission
> > denied\n\tIs the server running on host &quot;localhost&quot; 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
> 
> could this have something to do with SELinux? can you disable it alltogether
> and try?
> 
> javier
>



view thread (14+ messages)  latest in thread

Message-ID: <923c3c140508171046280fe820@mail.gmail.com>
Permalink:  ../923c3c140508171046280fe820@mail.gmail.com/
Also on:    postgresql.org/message-id/923c3c140508171046280fe820@mail.gmail.com

 · 

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: gray.chenhui@gmail.com, javier.wilson@gmail.com
  Subject: Re: Problem about connecting PostgreSQL through TCP/IP
  In-Reply-To: <923c3c140508171046280fe820@mail.gmail.com>
  References: <923c3c1405081410326a1c2880@mail.gmail.com> <da884c2005081708555811194f@mail.gmail.com> <923c3c140508171046280fe820@mail.gmail.com>

* 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