FreeTDS Development Group

["James McGowan" <jmcgowan AT luxurylink.com>]

> From: Lowden, James K [mailto:LowdenJK AT bernstein.com]
> Sent: Tuesday, December 02, 2003 11:35 AM
> To: 'FreeTDS Development Group'
> Subject: RE: [freetds] mssql_connect fails with PHP 4.3.4 on 
> RH Linux 9
> 
> 
> > From: James McGowan [mailto:jmcgowan AT luxurylink.com]
> > Sent: December 2, 2003 2:00 PM
> > > 
> > > I issued:
> > > 
> > >   export TDSDUMP=/var/log/tdsdump
> > > 
> > > and the environment variable is present, however nothing is 
> > > being logged. (I even did a reboot to load a new kernel.) 
> > > Another quick question on logging... I've had:
> > > 
> > >   dump file append = /var/log/freetds
> > > 
> > > in freetds.conf for a while now, and again, no logging. 
> 
> One of two things.  
> 
> A) "dump file append" is a yes/no variable; the name of the 
> log file is
> determined by "dump file" or TDSDUMP.   That variable 
> defaults to "no" and
> would stay that way until a proper "yes" appears.  It may be 
> your log file
> is being overwritten.  Is there no file, or a zero-length file?  
> 
> (Hmm.  You're the second fellow today (and maybe the third 
> all year) bitten
> by an erroneous freetds.conf entry.)  

OK, I've eliminated that line from freetds.conf now. Anything to help clear 
the air!

> B) If there's no log file, and 
>       1. "dump file = /var/log/freetds", and
>       2. "/var/log/freetds" is a filename, and 
>       3.  the process has permission to write to "/var/log", 

1. is correct
2. is correct
3. Apache or PHP? Apache writes its own access_log to /var/log, and I have a 
mod_php_error log that writes there as well. Neither log file reveals 
anything of interest.

> 
> then I'd check your PHP (or apache?) executable with ldd(1) 
> to make sure
> FreeTDS is being linked in.  The log file is opened as soon as FreeTDS
> begins searching for its configuration files.  

ldd reports:
libsybdb.so.3 => /usr/local/freetds/lib/libsybdb.so.3 (0x4004a000)

I'm not into this stuff enough to understand why there are so many references 
to sybase and sybdb libraries in freetds. I understand Sybase corp's 
relationship to MS SQL Server and that they produced free drivers for *nix 
early on, but now I'm confused about what config options I should be using. 
Some notes say to build freetds with "--with-sybase=/usr/local/freetds"  I 
thought that by using "--with-mssql=/usr/local/freetds" that I would be 
eliminating all references to sybase ct-libs. But alas...