From owner-freebsd-questions@FreeBSD.ORG  Wed Jul 21 19:08:07 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 21A1E16A4CE
	for <questions@freebsd.org>; Wed, 21 Jul 2004 19:08:07 +0000 (GMT)
Received: from ns1.tiadon.com (SMTP.tiadon.com [69.27.132.161])
	by mx1.FreeBSD.org (Postfix) with ESMTP id E1F7443D39
	for <questions@freebsd.org>; Wed, 21 Jul 2004 19:08:06 +0000 (GMT)
	(envelope-from kdk@daleco.biz)
Received: from [69.27.131.0] ([69.27.131.0]) by ns1.tiadon.com with Microsoft
	SMTPSVC(6.0.3790.0);	 Wed, 21 Jul 2004 14:09:49 -0500
Message-ID: <40FEBF14.1000500@daleco.biz>
Date: Wed, 21 Jul 2004 14:08:04 -0500
From: "Kevin D. Kinsey, DaleCo, S.P." <kdk@daleco.biz>
User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.7) Gecko/20040712
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Robert Munn <munn@pcp243550pcs.howard01.md.comcast.net>
References: <20040721185355.GA13196@pcp243550pcs.howard01.md.comcast.net>
In-Reply-To: <20040721185355.GA13196@pcp243550pcs.howard01.md.comcast.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-OriginalArrivalTime: 21 Jul 2004 19:09:50.0109 (UTC)
	FILETIME=[4BB2B4D0:01C46F56]
cc: questions@freebsd.org
Subject: Re: 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 19:08:07 -0000

Robert Munn wrote:

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

What does it say about SQL?  <see below>

>Scripts referencing mysql access fail with undefined function messages.
>
>  
>
You mentioned that already ;-)

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

Possibly your config was cached and used again; OTOH,
as you were using portupgrade, and the dialog box would
require TTY input, it seems more probably that you simply
got a default PHP install.

IIRC, there was/is an issue floating around with changes
in the MySQL libraries ... or else in PHP's interface with
them.  One fix was to recompile PHP "--with-mysql=/path/to/mysql"
instead of relying on native PHP support, IIRC.  Please
triple check this if this is a mission critical box.

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

What I think we might need is the PHP config string
instead.

Good luck and good hunting...

Kevin Kinsey
DaleCo, S.P.