From owner-freebsd-questions@FreeBSD.ORG Tue Mar 6 19:42:27 2012 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id A9CCB106566B for ; Tue, 6 Mar 2012 19:42:27 +0000 (UTC) (envelope-from arab@tangerine-army.co.uk) Received: from mtaout03-winn.ispmail.ntl.com (mtaout03-winn.ispmail.ntl.com [81.103.221.49]) by mx1.freebsd.org (Postfix) with ESMTP id 213D08FC12 for ; Tue, 6 Mar 2012 19:42:26 +0000 (UTC) Received: from know-smtpout-4.server.virginmedia.net ([62.254.123.4]) by mtaout03-winn.ispmail.ntl.com (InterMail vM.7.08.04.00 201-2186-134-20080326) with ESMTP id <20120306194219.FSRD14668.mtaout03-winn.ispmail.ntl.com@know-smtpout-4.server.virginmedia.net> for ; Tue, 6 Mar 2012 19:42:19 +0000 Received: from [94.168.171.147] (helo=Mercury.universe.galaxy.lcl) by know-smtpout-4.server.virginmedia.net with esmtp (Exim 4.63) (envelope-from ) id 1S50H5-0001Wz-NQ for freebsd-questions@freebsd.org; Tue, 06 Mar 2012 19:42:19 +0000 Received: from Mercury.universe.galaxy.lcl ([fe80::b0b0:8497:b56e:9ced]) by Mercury.universe.galaxy.lcl ([fe80::b0b0:8497:b56e:9ced%11]) with mapi; Tue, 6 Mar 2012 19:42:12 +0000 From: Graeme Dargie To: "freebsd-questions@freebsd.org" Thread-Topic: lighttpd + php + external mssql server Thread-Index: Acz4oW8G07kUWjh8Qcuy+0yWQwL1IgBh3W2AAGnxqEA= Date: Tue, 6 Mar 2012 19:42:10 +0000 Message-ID: <4C0F7421AA759346AF17299922AD57EB05585B@Mercury.universe.galaxy.lcl> References: <4C0F7421AA759346AF17299922AD57EB04DE85@Mercury.universe.galaxy.lcl> <20120304170443.GB15793@external.screwed.box> In-Reply-To: <20120304170443.GB15793@external.screwed.box> Accept-Language: en-GB, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Cloudmark-Analysis: v=1.1 cv=JvdXmxIgLJv2/GthKqHpGJEEHukvLcvELVXUanXFreg= c=1 sm=0 a=pqlA-0YcRngA:10 a=OMdUhd4NiskA:10 a=kj9zAlcOel0A:10 a=xqWC_Br6kY4A:10 a=6I5d2MoRAAAA:8 a=6dG_nmYyAAAA:8 a=6Sm500ByAAAA:8 a=eBmKW84A2wWymYrbLKoA:9 a=-U4jLvU2SV8uT30FJ3gA:7 a=CjuIK1q_8ugA:10 a=SV7veod9ZcQA:10 a=fR-Bwqda8R4A:10 a=0qf3x1870akA:10 a=HCOsw55j08PfpBw_:21 a=ryXTiabRtpPE_O26:21 a=HpAAvcLHHh0Zw7uRqdWCyQ==:117 Subject: RE: lighttpd + php + external mssql server X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 06 Mar 2012 19:42:27 -0000 -----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 =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 (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