From owner-freebsd-questions Wed Aug 23 14:41: 4 2000 Delivered-To: freebsd-questions@freebsd.org Received: from buffnet4.buffnet.net (buffnet4.buffnet.net [205.246.19.13]) by hub.freebsd.org (Postfix) with ESMTP id 5A74D37B424 for ; Wed, 23 Aug 2000 14:40:54 -0700 (PDT) Received: from buffnet5.buffnet.net (buffnet5.buffnet.net [205.246.19.14]) by buffnet4.buffnet.net (8.9.3/8.8.7) with ESMTP id RAA30391 for ; Wed, 23 Aug 2000 17:40:58 -0400 (EDT) (envelope-from mtech@buffnet.net) Date: Wed, 23 Aug 2000 17:40:44 -0400 (EDT) From: Mohsin Rahman To: FreeBSD Questions Subject: apache + php (w/ mysql+postgres) Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG I have followed the steps as listed in http://www.php.net/distributions/bigmanual.html for building PHP with mysql and postgres support. I am doing this on a box running RELEASE-3.2. This box already runs apache + php (w/ postgres enabled). Since I want to now add php with postgrs+mysql, I did these steps: mkdir /usr/test ftp'd the folowing: apache_1.3.12 php-3.0.16 then I did: bash-2.02# cd apache_1.3.12 bash-2.02# ./configure --prefix=/wwwtest bash-2.02# cd ../php-3.0.16 bash-2.02# ./configure --with-mysql --with-pgsql --with-apache=../apache_1.3.12 --enable-track-vars bash-2.02# make gcc -g -O2 -O2 -I. -I. -I../apache_1.3.12/src/include -I../apache_1.3.12/src /os/unix -I/usr/local/include/mysql -I/usr/local/include -c language-parser.tab.c -o language-parser.tab.o gcc -g -O2 -O2 -I. -I. -I../apache_1.3.12/src/include -I../apache_1.3.12/src /os/unix -I/usr/local/include/mysql -I/usr/local/include -w -DYY_USE_CONST -c language-scanner.c gcc -g -O2 -O2 -I. -I. -I../apache_1.3.12/src/include -I../apache_1.3.12/src /os/unix -I/usr/local/include/mysql -I/usr/local/include -c main.c -o main.o gcc -g -O2 -O2 -I. -I. -I../apache_1.3.12/src/include -I../apache_1.3.12/src /os/unix -I/usr/local/include/mysql -I/usr/local/include -c php3_hash.c -o php3_hash.o gcc -g -O2 -O2 -I. -I. -I../apache_1.3.12/src/include -I../apache_1.3.12/src /os/unix -I/usr/local/include/mysql -I/usr/local/include -c operators.c -o operators.o gcc -g -O2 -O2 -I. -I. -I../apache_1.3.12/src/include -I../apache_1.3.12/src /os/unix -I/usr/local/include/mysql -I/usr/local/include -c variables.c -o variables.o gcc -g -O2 -O2 -I. -I. -I../apache_1.3.12/src/include -I../apache_1.3.12/src /os/unix -I/usr/local/include/mysql -I/usr/local/include -c token_cache.c -o token_cache.o gcc -g -O2 -O2 -I. -I. -I../apache_1.3.12/src/include -I../apache_1.3.12/src /os/unix -I/usr/local/include/mysql -I/usr/local/include -c stack.c -o stack.o gcc -g -O2 -O2 -I. -I. -I../apache_1.3.12/src/include -I../apache_1.3.12/src /os/unix -I/usr/local/include/mysql -I/usr/local/include -c internal_functions.c -o internal_functions.o In file included from internal_functions.c:59: functions/php3_pgsql.h:46: libpq-fe.h: No such file or directory functions/php3_pgsql.h:47: libpq/libpq-fs.h: No such file or directory *** Error code 1 Stop. I want the httpd binary (w/ php+postgres+mysql) on webserver to access a dbserver running ONLY postgres+mysql. The dbserver is running FreeBSD-4.0. Another question is, does mysql and postgres BOTH need to be installed on the webserver and then php built from scratch with this support? If YES, then what happens if the httpd binary is copied to another box that DO NOT have a local copy of postgres+mysql and the php code connects to the dbserver? Am I making sense? If I can provide any additional info, please do let me know. If you can guide me in the right direction, please do so. At this point, I do not want to update anything to php4 nor want to run FreeBSD Release-4x on any box other than the dbserver. Thanks in advance. Mohsin AbdulRahman MTech@BuffNET.Net To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message