Re: [Fwd: Problems configuring php with freetds]

On Jun 6, 2008, at 21:13, Michael Soh wrote:

>> Try to run you PHP script from the command line, rather than the  
>> web environment, and you'll probably see that the database  
>> connection is allowed there.
> I tried this but got the same result.

That's actually very helpful that you could reproduce the problem from  
the command line. It's a lot easier to experiment and debug it there  
with the web server out of the way.

> I tried enabling logging per the instructions on the web site.  For  
> some reason, logging isn't happening.

 From the command line, you could try something like this:
TDSDUMPCONFIG=stdout TDSDUMP=stdout php /your/script/here.php

Then you should see a bunch of FreeTDS debug output dumped straight to  
your terminal.
If you don't get anything, then somehow PHP is not even calling the  
FreeTDS code.

> Could it be that I compiled freetds and/or php incorrectly?  Is  
> there a way to check?

You could also check if the PHP mssql extension is linked to the  
FreeTDS libraries.

If you built the PHP mssql extension as shared:

$ php -i | grep extension_dir
extension_dir => /usr/local/lib/php/extensions/no-debug-non-zts-20020429

$ ldd /usr/local/lib/php/extensions/no-debug-non-zts-20020429/mssql.so

the output should have FreeTDS's libdb in there.

Or if you liked the PHP mssql extension in statically, check the php  
binary itself:

$ ldd $(command -V php)