From owner-freebsd-questions@FreeBSD.ORG  Thu Feb 26 22:09:53 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 91B7616A4CE
	for <freebsd-questions@freebsd.org>;
	Thu, 26 Feb 2004 22:09:53 -0800 (PST)
Received: from mail.relia.net (mail.relia.net [207.173.156.3])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 7A2D743D2F
	for <freebsd-questions@freebsd.org>;
	Thu, 26 Feb 2004 22:09:53 -0800 (PST)
	(envelope-from joe@joe-lewis.com)
Received: from ut112-157.dsl.relia.net ([207.173.157.112] helo=joe-lewis.com)
	by mail.relia.net (Exim 4.24 #1 (FreeBSD 4.7))
	protocol: esmtp
	id 1AwbC4-0009VQ-Ty
	for <freebsd-questions@freebsd.org>
	; Thu, 26 Feb 2004 23:09:53 -0700
Message-ID: <403EDEAE.5020807@joe-lewis.com>
Date: Thu, 26 Feb 2004 23:07:42 -0700
From: Joe Lewis <joe@joe-lewis.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.4) Gecko/20030624
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: freebsd-questions@freebsd.org
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Subject: MySQL Port... [not]missing functions?
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: Fri, 27 Feb 2004 06:09:53 -0000

Hey, all.  I have written an apache module, and it worked fine with 
MySQL 3.23 compiled from source but not in the 4.x ports (tried 4.1 and 
4.0).  I have found the problem when I shifted it to a new box.  The old 
one ran 5.1, and this new one runs 5.2.  I doubt the OS is the concern, 
but one can't be too careful.

The installed packages are :

mysql-client-4.0.16 Multithreaded SQL database (client)
mysql-server-4.0.16 Multithreaded SQL database (server)
apache-2.0.48_1     Version 2 of the extremely popular Apache http server
mod_php4-4.3.4_2,1  PHP Apache Module

Now, since I've used the port, all I get when trying to start apache 
with the recompiled module is :

Cannot load /usr/local/libexec/apache2/mod_vmysql.so into server: 
/usr/local/libexec/apache2/mod_vmysql.so: Undefined symbol 
"mysql_real_escape_string"

Can someone tell me what I am doing wrong?  I KNOW that function is 
supposed to be in the MySQL library, but it just isn't being found.  Is 
there some trick that was used in the port that is not part of the 
standard install for MySQL?

Joe