PHP5/MySQL problem

[Joseph Mays]

Okay, I did a "make deinstall; make clean; make rmconfig" in both the php5 
and php5-extensions directories.

I edited the following in the php5 Makefile --

From:

CONFIGURE_ARGS= --enable-versioning \
                --with-layout=GNU \
                --with-config-file-scan-dir=${PREFIX}/etc/php \
                --disable-all \
                --enable-libxml \
                --with-libxml-dir=${LOCALBASE} \
                --enable-reflection \
                --program-prefix=""

To:

CONFIGURE_ARGS= --enable-versioning \
                --with-layout=GNU \
                --with-mysql \
                --with-mysqli \
                --with-config-file-scan-dir=${PREFIX}/etc/php \
                --disable-all \
                --enable-libxml \
                --with-libxml-dir=${LOCALBASE} \
                --enable-reflection \
                --program-prefix=""


MySQL still shows up as external in phpinfo. However, it looks like I am 
getting a successful connection, now but I am getting the following error 
from gallery2 --

[Mon Jul 16 20:24:59 2007] [error] [client 216.24.33.177] PHP Fatal error: 
Call to undefined function preg_match() in 
/usr/local/www/apache22/data/dpmeetup/index.php on line 35
[Mon Jul 16 20:25:00 2007] [error] [client 216.24.33.177] PHP Fatal error: 
Call to undefined function preg_match() in 
/usr/local/www/apache22/data/dpmeetup/index.php on line 35


Thanks for your help.



----- Original Message ----- 
From: "Shaun Cummiskey" <shaunc at crye-leike.com>
To: "Joseph Mays" <mays at win.net>
Cc: <freebsd-database at freebsd.org>
Sent: Monday, July 16, 2007 2:00 PM
Subject: Re: PHP5/MySQL problem


> On Mon, 16 Jul 2007 13:20:07 -0400
> "Joseph Mays" <mays at win.net> wrote:
>
>> You can examine the php setup at 
>> http://geekfleet.tai-gear.com/phpinfo.php
>
> It doesn't appear that your installation of PHP was compiled with MySQL
> support. If you go down to the MySQL section of the phpinfo output, the
> value for MYSQL_MODULE_TYPE should be either "builtin" or "external."
> IIRC, PHP will build with its own native MySQL support by default;
> specifying --disable-all at config time overrode that option.
>
> I would suggest appending --with-mysql --with-mysqli to PHP's configure
> command, and recompiling.
>
> hth
>