FreeTDS Development Group

[arielCo <arielco AT gmail.com>]

Huzzah!

$ TDSVER=7.0 TDSPORT=1433 TDSDUMP=/tmp/ftds.dump ~/freetds/bin/fisql
-S 10.192.139.22 -U ariel -P password
Changed database context to 'master'.
Changed language setting to us_english.
1>> select 1.0 abc
2>> go
abc
---
1.0
(1 rows affected)
1>>

I expected consistency between the two utilities - silly me. BTW, I'm
getting a bad fisql manual when building from Git (that is,
doc/fisql.1 has all the text but nroff -man doc/fisql.1 produces
something not quite readable).

Yes, the default TDSVER is 5.0 (which causes an unexpected EOF from
the server), and the default TDSPORT is 4000. But I'm still at a loss
regarding where does that weird 192.138.151.209 come from; it's not
evident anywhere in the source tarball, nothing in the environment
mentions it and the dump doesn't say why it set it so.

Speaking of the dump, as I said in my first mail, the dump hasn't been
opened by the time some calls to tdsdump_log are made so the messages
are lost quietly. Maybe we should address that later.

Ariel Cornejo
+58·412·8083546


On Thu, Jun 27, 2013 at 11:30 PM, Frediano Ziglio <freddy77 AT gmail.com> wrote:
> 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
>>
>>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds