Skip to Content.
Sympa Menu

freetds - Re: [freetds] Using PHP with FreeTDS

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Paquin <brian.paquin AT yale.edu>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Using PHP with FreeTDS
  • Date: Fri, 01 Jun 2007 17:25:24 -0400


I attached the file again (this time compressed into a zip).

I was trying to "modify" php in a upgrade-friendly way, but
you are probably right... I should compile PHP 5.x and then
deal with issues related to OS updates as needed.

I will look into TDSDUMP on the old server this weekend!

Again, thank you!!!

Brian :)

On Jun 1, 2007, at 3:25 PM, Daniel Fazekas wrote:

On Jun 1, 2007, at 17:06, Brian Paquin wrote:

TDSDUMP generates a LOT of output!!
( I redirected the output to a file. When the file reached 2GB, I
killed the job and reviewed file.)

Definitely shouldn't be getting that big, sounds like it's stuck in
some infinite loop.

Connects to the database and receives the first packet of database
results. After those lines, it seems like a lot of repetition (see
attached file "log.txt"). Is this output normal?

Clearly not normal, but you forgot to attach it, or it was lost
somewhere along the way, perhaps due to the size of it.
Try sending it up to the first 2-3 repetitions max. Also note that
sensitive login information may be in the log, you might want to edit
that out first.

I used "php -i" to retrieve the config used by Apple, downloaded
PHP 4.4.4 from php.net, and then rebuilt it (adding in the sybase
directive).

So you didn't apply Apple's custom patches to it, whatever those may
do -- unlikely to make a difference with the sybase part.
Still, I just don't see the logic of reinstalling PHP this way.
If you're overwriting Apple's version with your own custom-built
copy, you might as well have went with the current versions of PHP,
4.4.7 or even 5.2.3. And because you installed it into the same place
Apple's version used to be, Apple's system updates will likely just
go ahead and blindly overwrite your copy in the future, killing the
sybase support.

But again this is mostly just an aside; probably not the cause of
your problem here.

otool confirms that FreeTDS is present...
/usr/local/lib/libsybdb.5.dylib (compatibility version
6.0.0, current version 6.0.0)

Good, so we have confirmed that you have:
- only one copy of PHP on your system
- it is linked to FreeTDS's db-lib and actually using it

I'm still not convinced that the problem lies in FreeTDS necessarily,
the endless repetition could be simply following the orders of those
calling it, the php script or the code of php's sybase extension.

Now we would need to take a look at that TDSDUMP log or your php
script to find out more.
By the way, since you mentioned having a properly working set-up on
another computer, it might also be a good idea to compare the TDSDUMP
output of that system with the new one.

--
fds
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


_________________________________________
Brian T. Paquin, ACSA, ACHDS, ACTC, ACDT, ACPT
Yale University
Department of Pathology
brian.paquin AT yale.edu
(203) 785-3691






Archive powered by MHonArc 2.6.24.

Top of Page