Re: PHP 5.2.6 + pdo_dblib + FreeTDS 0.64 -- tds_open_socket:Unknown error: 0

On Thu, Jul 24, 2008 at 3:21 PM, Thomas, Christopher (LLU)
<[email protected]> wrote:
>
>
>> -----Original Message-----
>> From: [email protected] [mailto:freetds-
>> [email protected]] On Behalf Of Kian Mohageri
>> Sent: Wednesday, July 23, 2008 4:27 PM
>> To: [email protected]
>> Subject: [freetds] PHP 5.2.6 + pdo_dblib + FreeTDS 0.64 --
>> tds_open_socket:Unknown error: 0
>>
>> This began after an upgrade to FreeBSD 7.0.  I've been trying to track
>> it down for a while now.
>>
>> The strange thing is that the same exact script works fine via the
>> Apache module, just not the command line.  There are no special
>> environment variables set in Apache.
>>
>
>
> One time I had to re-compile PHP from an srpm package on RHEL. I was
> wondering why it took 45 min to compile when PHP is so small. After
> poking around, I found out 3 versions were compiled: mod_php, fast-cgi,
> and cli. That's why it took so long.
>
> You might have different versions on your box too. I would run a script
> with php_info() both on apache and on the command line and compare the
> output. You might see that a module isn't loaded or something.
>

Just a followup, I finally figured this out.  It wasn't a bug in
FreeBSD, but rather there is a problem with the php5-pdo_oci and
php5-oci ports.  A patch in the port modifies the linker path, and for
some reason having either of those loaded breaks php5-pdo_dblib's
connect().

I'm going to let the maintainer(s) know.

Thanks for all of your help,

-Kian