FreeTDS Development Group

[Alf-Ivar Holm <affi AT csc.no>]

Frediano Ziglio <freddyz77 AT tin.it> writes:

> > > Craig wrote:
> > > > Anyway, in freetds.spec from 0.61, we have:
> > > > %configure --with-tdsver=4.2 --prefix=/usr --with-unixodbc=/usr/local 
> > > > --enable-threadsafe

> When you configure prefix to /usr configurations go to /etc
> 
> $ rpm -qlp /usr/src/redhat/RPMS/i386/freetds-0.61-1.i386.rpm 
> /etc/freetds.conf
  ^^^^^^^^^^^^^^^^^

That is indeed where freetds-0.60-1.i386.rpm puts the file, but that
is not where the library looks for it (The following is an extract
from "strace isql ..."):

    uname({sys="Linux", node="classic", ...}) = 0
    open("/home/affi/.freetds.conf", O_RDONLY) = -1 ENOENT (No such file or 
directory)
    open("/etc/freetds/freetds.conf", O_RDONLY) = -1 ENOENT (No such file or 
directory)
               ^^^^^^^^

... which further down led to freetds trying to look up odbc.ini's
Servername value, BetaMSSQL, on the DNS server:

    connect(3, {sin_family=AF_INET, sin_port=htons(53), 
sin_addr=inet_addr("193.75.75.193")}}, 28) = 0
    send(3, "\325\276\1\0\0\1\0\0\0\0\0\0\tBetaMSSQL\3csc\2no\0\0\1"..., 34, 
0) = 34

... making me baffled, until now: FreeTDS tries to find a
freetds.conf, but if it doesn't find it, it will use Servername as a -
server name (How strange.), and default the port number, if not given.
That is why I got around the problem by changing Servername's value to
"beta", which is the box running the MS SQLServer here.

(I still haven't got the 0.60 RPM to work on RedHat 8's PHP-4.2.2 and
Apache 2.0.40 RPMs (From /var/log/httpd/error_log):

    [Wed Feb 05 14:17:46 2003] [notice] child pid 28394 exit signal 
Segmentation fault (11)

which doesn't say much, and which I haven't gotten any further in
debugging, but the self compiled 0.61 snapshot from last week works.)

Anyway, what I tried to say, was: There is a mismatch between the RPM
and the library with respect to the location of the configuration
files.

        Affi