From owner-freebsd-questions@FreeBSD.ORG  Wed Jul 21 18:53:56 2004
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id EEB1A16A4CE
	for <questions@freebsd.org>; Wed, 21 Jul 2004 18:53:56 +0000 (GMT)
Received: from pcp243550pcs.howard01.md.comcast.net
	(pcp243550pcs.howard01.md.comcast.net [68.55.84.46])
	by mx1.FreeBSD.org (Postfix) with ESMTP id A141843D58
	for <questions@freebsd.org>; Wed, 21 Jul 2004 18:53:56 +0000 (GMT)
	(envelope-from munn@pcp243550pcs.howard01.md.comcast.net)
Received: from pcp243550pcs.howard01.md.comcast.net (localhost [127.0.0.1])
	id i6LIrtuj013205
	for <questions@freebsd.org>; Wed, 21 Jul 2004 14:53:55 -0400 (EDT)
	(envelope-from munn@pcp243550pcs.howard01.md.comcast.net)
Received: (from munn@localhost)i6LIrtcn013204
	for questions@freebsd.org; Wed, 21 Jul 2004 14:53:55 -0400 (EDT)
	(envelope-from munn)
Date: Wed, 21 Jul 2004 14:53:55 -0400
From: Robert Munn <munn@pcp243550pcs.howard01.md.comcast.net>
To: questions@freebsd.org
Message-ID: <20040721185355.GA13196@pcp243550pcs.howard01.md.comcast.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.4.2.1i
Subject: Apache/mod_php4/mysql issue
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 21 Jul 2004 18:53:57 -0000

I recently upgraded apache2 and mod_php4 using portupgrade.  Now all my scripts that
reference mysql fail with the error message:

PHP Fatal error:  Call to undefined function:  mysql_connect() in /usr/users/munn/public_html/Testing/MySQL.php

I re-built Apache and mod_php4

with the following commands

cd /usr/ports/www/apache2
make install
cd ../mod_php4
make install WITH_APACHE2=1

and the script <?php phpinfo(); ?>
runs correctly.  Scripts referencing mysql access fail with undefined function messages.

When I built the files before I vaguely remember being presented with a dialog box that offered various
options one of which involved mysql. I no longer get any options choice.

Here is the information returned by mysql -V and httpd -v.

Any help would be appreciated.


mysql  Ver 12.22 Distrib 4.0.20, for portbld-freebsd4.9 (i386)

Server version: Apache/2.0.50
Server built:   Jul 21 2004 10:26:41
Server's Module Magic Number: 20020903:8
Architecture:   32-bit
Server compiled with....
-D APACHE_MPM_DIR="server/mpm/prefork"
-D APR_HAS_SENDFILE
-D APR_HAS_MMAP
-D APR_HAVE_IPV6 (IPv4-mapped addresses enabled)
-D APR_USE_FLOCK_SERIALIZE
-D SINGLE_LISTEN_UNSERIALIZED_ACCEPT
-D APR_HAS_OTHER_CHILD
-D AP_HAVE_RELIABLE_PIPED_LOGS
-D HTTPD_ROOT="/usr/local"
-D SUEXEC_BIN="/usr/local/bin/suexec"
-D DEFAULT_PIDLOG="/var/run/httpd.pid"
-D DEFAULT_SCOREBOARD="/var/run/apache_runtime_status"
-D DEFAULT_LOCKFILE="/var/run/accept.lock"
-D DEFAULT_ERRORLOG="/var/log/httpd-error.log"
-D AP_TYPES_CONFIG_FILE="etc/apache2/mime.types"
-D SERVER_CONFIG_FILE="etc/apache2/httpd.conf"