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

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


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

Hello.

2012/03/03 00:32:40 +0000 Graeme Dargie <arab@tangerine-army.co.uk> =3D> 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>=20
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>=20
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 =
extension.

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 =
extension.

--
Peter Vereshagin <peter@vereshagin.org> (http://vereshagin.org) pgp: A0E266=
27 _______________________________________________
freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman=
/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions-unsubscribe@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 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.

Regards
Graeme



Want to link to this message? Use this URL: <http://docs.FreeBSD.org/cgi/mid.cgi?4C0F7421AA759346AF17299922AD57EB05585B>