FreeTDS Development Group

[Frediano Ziglio <freddy77 AT gmail.com>]

2013/6/27 arielCo <arielco AT gmail.com>

> There's no -p option, but TDSPORT is honored. I used a fresh tree from
> Git but it insists on connecting to the weird local address:
> net.c:228:Connecting to 192.138.151.209 port 1433 (TDS version 5.0)
>
> I can't find any "192.*" or "[cC]0" string in *.[ch]; the closest is
> the default interfaces file, but it's not quite the same:
> JDBC
>         query tcp 5.0 192.138.151.39 4444
>         master tcp 5.0 192.138.151.39 4444
> JDBC_42
>         query tcp 4.2 192.138.151.39 4444
>         master tcp 4.2 192.138.151.39 4444
>
> I'm attaching include/config.h anyway. I'm all ears!
>
> Ariel Cornejo
> +58·412·8083546
>
>
I think we were all confused by tsql!
man fisql is your friend, -H option to fisql tell you the local host name
passed to the server, not the server host name. If you don't pass -S NULL
is passed which lead to some dblib default ("SYBASE" or a server specified
with environment).

Frediano


>
> On Thu, Jun 27, 2013 at 1:52 PM, Frediano Ziglio <freddy77 AT gmail.com>
> wrote:
> > 2013/6/25 arielCo <arielco AT gmail.com>
> >
> >> Same result. The only difference is that it doesn't take as long to
> fail:
> >>
> >> $ TDSDUMP=/tmp/ftds.dump ~/freetds/bin/fisql -H 10.192.139.22 -U ariel
> >> -P password
> >> FreeTDS: db-lib: exiting because client error handler returned
> >> INT_EXIT for msgno 20009
> >>
> >> $ cat /tmp/ftds.dump
> >> log.c:194:Starting log file for FreeTDS 0.92.dev.20130625
> >>         on 2013-06-25 17:39:20 with debug flags 0x4fff.
> >> config.c:721:Setting 'dump_file' to '/tmp/ftds.dump' from $TDSDUMP.
> >> iconv.c:332:tds_iconv_open(2c120, ISO8859-1)
> >> iconv.c:189:local name for ISO-8859-1 is ISO-8859-1
> >> iconv.c:189:local name for UTF-8 is UTF-8
> >> iconv.c:189:local name for UCS-2LE is UCS-2LE
> >> iconv.c:189:local name for UCS-2BE is UCS-2BE
> >> iconv.c:351:setting up conversions for client charset "ISO8859-1"
> >> iconv.c:353:preparing iconv for "ISO8859-1" <-> "UCS-2LE" conversion
> >> iconv.c:393:preparing iconv for "ISO-8859-1" <-> "ISO-8859-1" conversion
> >> iconv.c:396:tds_iconv_open: done
> >> net.c:228:Connecting to 192.138.151.209 port 4000 (TDS version 5.0)
> >> net.c:300:tds_open_socket: connect(2) returned "Operation now in
> progress"
> >> net.c:335:getsockopt(2) reported: Connection refused
> >> net.c:345:tds_open_socket() failed
> >> util.c:315:tdserror(26b20, 2c120, 20009, 146)
> >> dblib.c:7881:dbperror(2b9b8, 20009, 146)
> >> dblib.c:7934:20009: "Unable to connect: Adaptive Server is unavailable
> >> or does not exist"
> >> dblib.c:4858:dbdead(2b9b8) [dead]
> >> dblib.c:7955:"Unable to connect: Adaptive Server is unavailable or
> >> does not exist", client returns 0 (INT_EXIT)
> >> dblib.c:8002:FreeTDS: db-lib: exiting because client error handler
> >> returned INT_EXIT for msgno 20009
> >>
> >> This is one thing that I don't understand:
> >> > net.c:228:Connecting to 192.138.151.209 port 4000 (TDS version 5.0)
> >> What's that addr+port? Some weird legacy fallback?
> >>
> >> Ariel Cornejo
> >> +58·412·8083546
> >>
> >>
> > For the port there should be a -p parameter to fisql, or set environment
> > variable TDSPORT to override (you can also compile FreeTDS with --tds-ver
> > to get some different default, usual for mssql).
> >
> > I'm a bit scared about the ip if this is different from the one you
> passed
> > from command line! Can you post your config.h (it's created in include
> > directory after you run configure command).
> >
> > You can also try to define TDSDUMPCONFIG to another file (use also
> TDSDUMP)
> > to get configuration dumps.
> >
> > Frediano
> >
> >
> >
> >>
> >> On Tue, Jun 25, 2013 at 3:57 PM, Frediano Ziglio <freddy77 AT gmail.com>
> >> wrote:
> >> > Applied the patch (and tested with Linux). Ariel, can you try updating
> >> your
> >> > FreeTDS ??
> >> >
> >> > Thanks,
> >> >   Frediano
> >> >
> >> >
> >> > 2013/6/21 Peter Deacon <peterd AT iea-software.com>
> >> >
> >> >>
> >> >> On Fri, 21 Jun 2013, arielCo wrote:
> >> >>
> >> >> > Interesting (not that I understand):
> >> >>
> >> >> Thanks, I'll send in a patch.
> >> >>
> >> >> regards,
> >> >> Peter
> >>
> >>
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
>