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@freebsd.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> => 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 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@vereshagin.org> (http://vereshagin.org) pgp: A0E26627 _______________________________________________ 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 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4C0F7421AA759346AF17299922AD57EB05585B>