Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 6 Mar 2012 19:42:10 +0000
From:      Graeme Dargie <>
To:        "" <>
Subject:   RE: lighttpd + php + external mssql server
Message-ID:  <4C0F7421AA759346AF17299922AD57EB05585B@Mercury.universe.galaxy.lcl>
In-Reply-To: <>
References:  <4C0F7421AA759346AF17299922AD57EB04DE85@Mercury.universe.galaxy.lcl> <>

Next in thread | Previous in thread | Raw E-Mail | Index | Archive | Help

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


2012/03/03 00:32:40 +0000 Graeme Dargie <> =3D> To=
 '' :
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=20
GD> run a connection from the FreeBSD server it gives a http 500 The=20
GD> error log has this
GD> 2012-03-02 18:20:09: (mod_fastcgi.c.2699) FastCGI-stderr: PHP Fatal=20
GD> error:  Call to undefined function mssql_connect() in=20
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 ext=
ensions. Look at the phpinfo() output from your fastcgi if it has an mssql =

2) You may want to try an ODBTP extension for mssql connectivity which supp=
orts mssql features like 'go' clause batch runs and scroll cursors with fet=
ching from them on the contrast to the 'traditional' dblib-based mssql php =

Peter Vereshagin <> ( pgp: A0E266=
27 _______________________________________________ mailing list
To unsubscribe, send any mail to "

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 enabl=
e 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 lo=
oked at elsewhere so portability is a major concern.


Want to link to this message? Use this URL: <>