lighttpd + php + external mssql server

Graeme Dargie arab at
Tue Mar 6 19:42:27 UTC 2012

-----Original Message-----
From: owner-freebsd-questions at [mailto:owner-freebsd-questions at] On Behalf Of Peter Vereshagin
Sent: 04 March 2012 17:05
To: freebsd-questions at
Subject: Re: lighttpd + php + external mssql server


2012/03/03 00:32:40 +0000 Graeme Dargie <arab at> => To 'freebsd-questions at' :
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> I have already installed php-extensions for mssql but when I try and 
GD> run a connection from the FreeBSD server it gives a http 500 The 
GD> error log has this
GD> 2012-03-02 18:20:09: (mod_fastcgi.c.2699) FastCGI-stderr: PHP Fatal 
GD> error:  Call to undefined function mssql_connect() in 
GD> /usr/local/www/data/
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 <peter at> ( pgp: A0E26627 _______________________________________________
freebsd-questions at mailing list
To unsubscribe, send any mail to "freebsd-questions-unsubscribe at"

You are spot on Peter, phpinfo() shows no mssql extension, so I am guessing the next question is does it have such an extension and if so how to enable it, there are no make config options for the fastcgi I can see in ports. I am doing this so I can do some work at home for a project that will be looked at elsewhere so portability is a major concern.


More information about the freebsd-questions mailing list