pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: re ert <matlab21@yahoo.es>
To: pgsql-php@postgresql.org
Subject: Function pg_pconnect do not work in FreeBSD
Date: Thu, 13 Dec 2001 18:43:44 +0100 (CET)
Message-ID: <20011213174344.48389.qmail@web12607.mail.yahoo.com> (raw)

From:             matlab21@yahoo.es
Operating system: FreeBSD
PHP version:      4.0.6 (and 4.1)
Bug description:  function pg_pconnect do not work in 
FreeBSD
Operative System: FreeBSD

Hello everybody.

I am using FreeBSD+Apache+PHP+Postgres.
By now, I'm using the newest versions:

- FreeBSD 4.4
- Apache_1.3.22
- PHP-4.0.6 ( now, I have proved 4.1 and I have the
same problem)
- Postgresql-7.1.3

I use the same three last components in Linux ans
SunOS and I have not any problems. I always try to
compile from source, I always make the same
instructions and in FreeBSD, PHP can not connect with
PostgreSQL.

I install everything with:

tar xvzf postgresql-7.1.3.tar.ga
cd postgresql-7.1.3
./configure && make && make install
initdb -D /usr/local/pgsql/data
postmaster -F -i -D /usr/local/pgsql/data &

Now postgres is running.

tar xvzf apache_1.3.22.tar.gz
cd apache_1.3.22
./configure 
cd ..
tar xvzf php-4.0.6.tar.gz
cd php-4.0.6
./configure --with-pgsql=/usr/local/pgsql/
--without-mysql
--with-apache=../apache_1.3.22 --enable-track-vars
make 
make install

cd ../apache_1.3.22
./configure --enable-module=src/modules/php4/libphp4.a
make 
make install

Edit /usr/local/apache/conf/httpd.conf to make use of
PHP

Start apache
/usr/local/apache/bin/apachectl start

In this moment I have apache listening in port 80 and
postgres in 5432 ( I know this using ps -e  and nmap
localhost).

In this moment apache works, PHP works. I can see the
simple script <?php phpinfo(); ?> with no problems.
But I can not connect to PostgreSQL database ( tried
connect and pg_pconnect functions). After a while
apperas this message:


Warning: Unable to connect to PostgreSQL server:
connectDBStart() --
connect() failed: No route to host Is the postmaster
running (with -i) 
at
'localhost' and accepting connections on TCP/IP port
5432? in /usr/home/pfc/phplib/php/db_pgsql.inc on line
47 
Database error: Link-ID == false, pconnect failed
PostgreSQL Error: 0 ()
Session halted.

I can sure you that postgres is running and I iniciate
postmaster with the '-i' flag. In the file
/usr/local/pgsql/data/pg_dba.conf I have the
following:

local  all           trust
host all 127.0.0.1 255.255.255.0 trust
host all 192.168.99.1 255.255.255.0 trust

NOTE: 192.168.99.1 is the server's IP.

I can sure I have installed apache-php-postgres in
linux and SunOS with the same method and here work
well. I do not know why PHP can not comunicate
with PostgreSQL using FreeBSD.

I also try to install from ports, but I have the same
problem.

Thanks a lot for.

I am pleased if anyone could solvent this problem.
If there is anyone who want contact me (for telling
more details, ... ) 
No doubt write to: matlab21@yahoo.es

Xevi Serrats.

NOTE: excuse me, english isn't my native language.



_______________________________________________________________
Do You Yahoo!?
Yahoo! Messenger
Comunicación instantánea gratis con tu gente.
http://messenger.yahoo.es



view thread (2+ messages)  latest in thread

Message-ID: <20011213174344.48389.qmail@web12607.mail.yahoo.com>
Permalink:  ../20011213174344.48389.qmail@web12607.mail.yahoo.com/
Also on:    postgresql.org/message-id/20011213174344.48389.qmail@web12607.mail.yahoo.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: matlab21@yahoo.es
  Subject: Re: Function pg_pconnect do not work in FreeBSD
  In-Reply-To: <20011213174344.48389.qmail@web12607.mail.yahoo.com>
  References: <20011213174344.48389.qmail@web12607.mail.yahoo.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