From owner-freebsd-database@FreeBSD.ORG Mon Jul 16 19:41:13 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 1B97E16A401 for ; Mon, 16 Jul 2007 19:41:13 +0000 (UTC) (envelope-from mays@win.net) Received: from nb-206.win.net (nb-206.win.net [216.24.27.206]) by mx1.freebsd.org (Postfix) with ESMTP id EA1E613C4B6 for ; Mon, 16 Jul 2007 19:41:12 +0000 (UTC) (envelope-from mays@win.net) Received: from engineering01 (pool177.office.win.net [216.24.33.177]) by nb-206.win.net (Postfix) with SMTP id 24B91453F5; Mon, 16 Jul 2007 15:41:12 -0400 (EDT) Message-ID: <019601c7c7e1$43713490$b12118d8@engineering01> From: "Joseph Mays" To: "Shaun Cummiskey" References: <035801c7c7cd$8e8dcfb0$b12118d8@engineering01> <20070716125538.25BB.SHAUNC@crye-leike.com> Date: Mon, 16 Jul 2007 15:41:11 -0400 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.3138 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 Cc: freebsd-database@freebsd.org Subject: Re: PHP5/MySQL problem X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 16 Jul 2007 19:41:13 -0000 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" To: "Joseph Mays" Cc: Sent: Monday, July 16, 2007 2:00 PM Subject: Re: PHP5/MySQL problem > On Mon, 16 Jul 2007 13:20:07 -0400 > "Joseph Mays" 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 >