Re: php5 and SQL Scripts
In response to Martin McCormick [EMAIL PROTECTED]: About 4 years ago, we installed php from the FreeBSD ports collection on a system in order to query a MS-SQL data base on another server. It worked fine until we upgraded to FreeBSD6.2 and php5. I had moved the old binary across and also pulled several libraries in to /usr/local/lib and the old binary seemed to be happy until we actually tried to use it at which time it hung until manually killed. After installing /usr/ports/lang/php5 and even trying /usr/ports/lang/php4, our new php gives the following error: Fatal error: Call to undefined function mssql_connect() Install /usr/ports/databases/php5-mssql Don't know what you're doing with all that moving binaries around, but make sure you didn't overwrite something. If you did, you may need to completely reinstall PHP. -- Bill Moran http://www.potentialtech.com ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: php5 and SQL Scripts
On Monday 02 April 2007, Martin McCormick wrote: About 4 years ago, we installed php from the FreeBSD ports collection on a system in order to query a MS-SQL data base on another server. It worked fine until we upgraded to FreeBSD6.2 and php5. I had moved the old binary across and also pulled several libraries in to /usr/local/lib and the old binary seemed to be happy until we actually tried to use it at which time it hung until manually killed. After installing /usr/ports/lang/php5 and even trying /usr/ports/lang/php4, our new php gives the following error: Fatal error: Call to undefined function mssql_connect() Has anybody in the FreeBSD world seen this before and better yet, how do you fix it? We do a little piece of a back-end operation which gathers information from a web application and uses it to create or remove rules in a firewall. The folks who own the rest of the pieces of the operation are asking frequently if it is fixed yet. I am out of things to try. Obviously, something changed between our older system and the present because the object is either here but in a wrong directory or I didn't pick the right configuration options in setting up the port. The sql script has worked fine until now for all these years. Any ideas are much appreciated. Is /usr/ports/databases/php5-mssql installed? -- Anish Mistry pgpkNZ66b543w.pgp Description: PGP signature
Re: php5 and SQL Scripts
Bill Moran writes: Don't know what you're doing with all that moving binaries around, but make sure you didn't overwrite something. If you did, you may need to completely reinstall PHP. First of all, thanks to all who replied. I missed the php5-mssql port, thinking that php5 was all I needed. The moving binaries phase was after we moved to a new platform and I rebuilt all our directories. I had carefully used tar xfk to recover /usr/local/bin from our previous system. For the 2 or 3 libraries I brought over to make the php binary work, I checked before copying to make sure there was nothing of the same name. When I discovered it didn't work, I looked at /usr/ports and discovered the php4 and php5 ports and did, in fact, properly build php. Now, php is hanging again which makes me think there is a problem between this system and the SQL server we communicate with. Our campus had Spring Break week before last and lots of systems were upgraded and or modified. It's like trying to find that one dead Christmas tree lamp in a series string of 100 which is killing the whole string. Martin McCormick ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: php5 and SQL Scripts
Bill Moran wrote: In response to Martin McCormick [EMAIL PROTECTED]: About 4 years ago, we installed php from the FreeBSD ports collection on a system in order to query a MS-SQL data base on another server. It worked fine until we upgraded to FreeBSD6.2 and php5. I had moved the old binary across and also pulled several libraries in to /usr/local/lib and the old binary seemed to be happy until we actually tried to use it at which time it hung until manually killed. After installing /usr/ports/lang/php5 and even trying /usr/ports/lang/php4, our new php gives the following error: Fatal error: Call to undefined function mssql_connect() Install /usr/ports/databases/php5-mssql Don't know what you're doing with all that moving binaries around, but make sure you didn't overwrite something. If you did, you may need to completely reinstall PHP. Which isn't so much fun :-( Martin, did you install /usr/ports/lang/php5-extensions ? It's been quite a while (see /usr/ports/UPDATING), but a lot of functions that PHP traditionally has are part of the extensions port, so you may find yourself banging your head on a few of these sorts of issues unless you've installed that as well (for example, session support, GD support, CURL support, SOAP, XML, etc.) HTH, Kevin Kinsey -- WARNING TO ALL PERSONNEL: Firings will continue until morale improves. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]