From owner-freebsd-questions@FreeBSD.ORG Sun Mar 4 17:05:20 2012 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 11CB11065670 for ; Sun, 4 Mar 2012 17:05:20 +0000 (UTC) (envelope-from peter@vereshagin.org) Received: from mx1.skyriver.ru (ns1.skyriver.ru [89.108.118.221]) by mx1.freebsd.org (Postfix) with ESMTP id BE6708FC18 for ; Sun, 4 Mar 2012 17:05:19 +0000 (UTC) Received: from localhost (politkovskaja.torservers.net [77.247.181.165]) by mx1.skyriver.ru (Postfix) with ESMTPSA id 3EB0D5B16 for ; Sun, 4 Mar 2012 21:05:10 +0400 (MSK) Date: Sun, 4 Mar 2012 21:04:43 +0400 From: Peter Vereshagin To: freebsd-questions@freebsd.org Message-ID: <20120304170443.GB15793@external.screwed.box> References: <4C0F7421AA759346AF17299922AD57EB04DE85@Mercury.universe.galaxy.lcl> MIME-Version: 1.0 Content-Type: text/plain; charset=koi8-r Content-Disposition: inline In-Reply-To: <4C0F7421AA759346AF17299922AD57EB04DE85@Mercury.universe.galaxy.lcl> Organization: ' X-Face: 8T>{1owI$Byj]]a; ^G]kRf*dkq>E-3':F>4ODP[#X4s"dr?^b&2G@'3lukno]A1wvJ_L(~u 6>I2ra/<,j1%@C[LN=>p#_}RIV+#:KTszp-X$bQOj,K Subject: Re: lighttpd + php + external mssql server X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 04 Mar 2012 17:05:20 -0000 Hello. 2012/03/03 00:32:40 +0000 Graeme Dargie => To 'freebsd-questions@freebsd.org' : GD> I am just looking for some advice or hints if anyone has a clue how to make a FreeBSD server running lighttpd + php5 connect to an instance of MS SQL 2008 R2. GD> GD> I have already installed php-extensions for mssql but when I try and run a connection from the FreeBSD server it gives a http 500 GD> The error log has this GD> 2012-03-02 18:20:09: (mod_fastcgi.c.2699) FastCGI-stderr: PHP Fatal error: Call to undefined function mssql_connect() in /usr/local/www/data/ GD> GD> Php -m shows mssql as installed. 1) Command-line php and fastcgi php are able to have a different set of extensions. Look at the phpinfo() output from your fastcgi if it has an mssql extension. 2) You may want to try an ODBTP extension for mssql connectivity which supports mssql features like 'go' clause batch runs and scroll cursors with fetching from them on the contrast to the 'traditional' dblib-based mssql php extension. -- Peter Vereshagin (http://vereshagin.org) pgp: A0E26627