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
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