[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