[freetds] Re: Connection issue

Daniel Fazekas fdsubs at t-online.hu
Tue Jun 14 10:21:26 EDT 2005


On Jun 14, 2005, at 15:41, Chris parent wrote:

> TDSDUMPCONFIG=stdout php test.php
> 05:36:15.991648 Failed in reading conf file.  Trying
> interface files.

As we expected, it cannot read your freetds.conf file.
Where did you put it?

Plus you ldd test shows us that:

> ldd /usr/local/bin/php
>         libsybdb.so.5 => /usr/local/lib/libsybdb.so.5

That libsybdb.so is the FreeTDS library.

This one tells us that PHP is linked to a copy of FreeTDS installed  
in /usr/local/, as opposed to the /usr/local/freetds/ path you said  
you installed it to according to your previous email.

So your primary concern should be figuring out how did you end up  
with two different copies of FreeTDS on your system, getting rid of  
one copy, then rebuilding PHP so that it picks up the correct copy.

Perhaps you installed some kind of a Debian provided package of  
FreeTDS alongside the one you compiled yourself?

> It showed it doesnt have
> $FREETDSCONF set (also $FREETDS).  I thought I
> installed with the instructions going line by line.
> Maybe I missed setting these vars?

You should not need to set them. When you build FreeTDS, the default  
location is compiled into the freetds libraries and these environment  
variables are only for the very rare occasion when you'd want to  
override the compiled-in defaults.

> ls
> /usr/local/lib/php/extensions/no-debug-non-zts-20020429/
> gd.so  mysql.so
> no mssql.so file.  Cant even "find" that file on my
> system.

This one is also normal, it only tells us that you did not compile  
the PHP mssql extension as a dynamically loadable shared module. It's  
built into the php binary so that it gets loaded unconditionally.
That is, you configured php with --with-mssql=dir instead of --with- 
mssql=shared,dir
If you can't think of a reason of running a copy of php without the  
mssql extension loaded, it's probably fine this way.

--
fds




More information about the FreeTDS mailing list