lighttpd + php + external mssql server

[Graeme Dargie]

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

Hello.

2012/03/03 00:32:40 +0000 Graeme Dargie <arab at tangerine-army.co.uk> => To 'freebsd-questions at 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 
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> 
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 vereshagin.org> (http://vereshagin.org) pgp: A0E26627 _______________________________________________
freebsd-questions at freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions-unsubscribe at freebsd.org"

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.

Regards
Graeme