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: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4C0F7421AA759346AF17299922AD57EB05585B>