From owner-freebsd-ports@FreeBSD.ORG  Wed Feb  2 16:54:34 2005
Return-Path: <owner-freebsd-ports@FreeBSD.ORG>
Delivered-To: freebsd-ports@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 3E9BA16A4CE
	for <ports@freebsd.org>; Wed,  2 Feb 2005 16:54:34 +0000 (GMT)
Received: from smtp-gw-cl-c.dmv.com (smtp-gw-cl-c.dmv.com [216.240.97.41])
	by mx1.FreeBSD.org (Postfix) with ESMTP id B5BC943D1D
	for <ports@freebsd.org>; Wed,  2 Feb 2005 16:54:33 +0000 (GMT)
	(envelope-from sven@dmv.com)
Received: from lanshark.dmv.com (lanshark.dmv.com [216.240.97.46])
	j12H8LEo015070;	Wed, 2 Feb 2005 12:08:21 -0500 (EST)
	(envelope-from sven@dmv.com)
From: Sven Willenberger <sven@dmv.com>
To: ports@freebsd.org
Content-Type: text/plain
Date: Wed, 02 Feb 2005 11:55:26 -0500
Message-Id: <1107363326.16500.23.camel@lanshark.dmv.com>
Mime-Version: 1.0
X-Mailer: Evolution 2.0.2 
Content-Transfer-Encoding: 7bit
X-Scanned-By: MIMEDefang 2.39
cc: php-db@lists.php.net
Subject: php cannot find mysql libs and includes after portupgrade
X-BeenThere: freebsd-ports@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Porting software to FreeBSD <freebsd-ports.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
	<mailto:freebsd-ports-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-ports>
List-Post: <mailto:freebsd-ports@freebsd.org>
List-Help: <mailto:freebsd-ports-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
	<mailto:freebsd-ports-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 02 Feb 2005 16:54:34 -0000

FreeBSD 5.2.1 and portupgraded mysql-client and server to 4.0.23a. Then
portupgrade -f lang/php4 and databases/php4-mysql. After this phpinfo()
and any php application using mysql no longer finds the include and lib
dirs and do not work.

>From phpinfo():
<snip>
extension_dir => /usr/local/lib/php/20020429
=> /usr/local/lib/php/20020429

<snip>

mysql

MySQL Support => enabled
Active Persistent Links => 0
Active Links => 0
Client API version => 4.0.23a
MYSQL_MODULE_TYPE => none
MYSQL_SOCKET => /tmp/mysql.sock
MYSQL_INCLUDE =>
MYSQL_LIBS =>


but:

# ldd /usr/local/lib/php/20020429/mysql.so
/usr/local/lib/php/20020429/mysql.so:
        libmysqlclient.so.12
=> /usr/local/lib/mysql/libmysqlclient.so.12 (0x2815b000)
        libz.so.2 => /lib/libz.so.2 (0x2817e000)
        libcrypt.so.2 => /lib/libcrypt.so.2 (0x2818c000)
        libm.so.2 => /lib/libm.so.2 (0x281a5000)

mysql client itself connects without any problem, just php applications
cannot. Any ideas? Has anyone else come across this?

Sven