Discussion:
[freetds] Git master doesn't resolve the host.
arielCo
2013-06-20 23:00:56 UTC
Permalink
To adapt a little fix I made for 0.91, I grabbed the tarball from
http://gitorious.org/freetds/freetds/trees/master and this is what I
get:

$ TDSDUMP=/tmp/ftds.dump ~/freetds/bin/fisql -S prueba -U ariel -P xxxxxxx
* Success: [prueba] defined in /export/home/filtro/freetds/etc/freetds.conf.
* IP address pointer is empty
FreeTDS: db-lib: exiting because client error handler returned
INT_EXIT for msgno 20013

$ cat /tmp/ftds.dump
log.c:194:Starting log file for FreeTDS 0.92.dev.20130620
on 2013-06-20 17:54:31 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" <-> "UCS-2LE" conversion
iconv.c:396:tds_iconv_open: done
util.c:315:tdserror(26b20, 2c120, 20013, 0)
dblib.c:7881:dbperror(2b9b8, 20013, 0)
dblib.c:7934:20013: "Unknown host machine name"
dblib.c:4858:dbdead(2b9b8) [dead]
dblib.c:7955:"Unknown host machine name", client returns 0 (INT_EXIT)
dblib.c:8002:FreeTDS: db-lib: exiting because client error handler
returned INT_EXIT for msgno 20013

./include/freetds/tds.h
TDSEUHST = 20013, /* Unknown host machine name. */

I added a couple of fprintf()s to be sure that server info is read
from freetds.conf - apparently the log has not even been created at
this point so many calls to tdsdump_log do nothing.
It doesn't even produce a log if I specify the hostname with -H.

I'm somewhat stumped here (also, the code is convoluted). Of course,
the 0.91 tarball connects fine.

Ariel Cornejo
+58?412?8083546
Peter Deacon
2013-06-20 23:35:41 UTC
Permalink
Post by arielCo
To adapt a little fix I made for 0.91, I grabbed the tarball from
http://gitorious.org/freetds/freetds/trees/master and this is what I
dblib.c:7881:dbperror(2b9b8, 20013, 0)
dblib.c:7934:20013: "Unknown host machine name"
dblib.c:4858:dbdead(2b9b8) [dead]
Which operating system and version is this?

regards,
Peter
arielCo
2013-06-20 23:54:37 UTC
Permalink
Solaris 5.11.
Post by Peter Deacon
Post by arielCo
To adapt a little fix I made for 0.91, I grabbed the tarball from
http://gitorious.org/freetds/freetds/trees/master and this is what I
dblib.c:7881:dbperror(2b9b8, 20013, 0)
dblib.c:7934:20013: "Unknown host machine name"
dblib.c:4858:dbdead(2b9b8) [dead]
Which operating system and version is this?
regards,
Peter
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
Peter Deacon
2013-06-21 04:48:22 UTC
Permalink
Post by arielCo
Solaris 5.11.
I don't know if this is related or will fix your problem. We had seen
problems caused by broke getaddrinfo() implementations in the past not
accepting numeric port number however not Solaris specifically.

Might do a little experiment:

In config.c tds_lookup_host change "1433" parameter to NULL and try again.

regards,
Peter
arielCo
2013-06-21 14:17:23 UTC
Permalink
Interesting (not that I understand):

cfbhbdp02 ~/users/arielCo/tmp/freetds-freetds
$ TDSDUMP=/tmp/ftds.dump ~/freetds/bin/fisql -H 10.192.139.22 -U ariel
-P password
(Long pause, like trying to resolve)
FreeTDS: db-lib: exiting because client error handler returned
INT_EXIT for msgno 20009

cfbhbdp02 ~/users/arielCo/tmp/freetds-freetds
$ TDSDUMP=/tmp/ftds.dump ~/freetds/bin/fisql -S prueba -U ariel -P password
Success: [prueba] defined in /export/home/filtro/freetds/etc/freetds.conf.
Changed database context to 'master'.
Changed language setting to us_english.
1>> select 1.0 abcde
2>> go
abcde
-----
1.0
(1 rows affected)

I attached both dumps.

Ariel Cornejo
+58?412?8083546
Post by Peter Deacon
Post by arielCo
Solaris 5.11.
I don't know if this is related or will fix your problem. We had seen
problems caused by broke getaddrinfo() implementations in the past not
accepting numeric port number however not Solaris specifically.
In config.c tds_lookup_host change "1433" parameter to NULL and try again.
regards,
Peter
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
-------------- next part --------------
A non-text attachment was scrubbed...
Name: fisql_-H.dump
Type: application/octet-stream
Size: 1301 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20130621/80fae16d/attachment-0002.obj
-------------- next part --------------
A non-text attachment was scrubbed...
Name: fisql_-S.dump
Type: application/octet-stream
Size: 12290 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20130621/80fae16d/attachment-0003.obj
Peter Deacon
2013-06-21 17:03:00 UTC
Permalink
Thanks, I'll send in a patch.

regards,
Peter
Frediano Ziglio
2013-06-25 20:27:29 UTC
Permalink
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>
Post by Peter Deacon
Thanks, I'll send in a patch.
regards,
Peter
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
arielCo
2013-06-25 22:36:06 UTC
Permalink
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
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
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>
Post by Peter Deacon
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
Frediano Ziglio
2013-06-27 18:22:43 UTC
Permalink
2013/6/25 arielCo <arielco at gmail.com>
Post by arielCo
$ 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
Post by arielCo
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
Post by arielCo
Post by arielCo
Applied the patch (and tested with Linux). Ariel, can you try updating
your
Post by arielCo
FreeTDS ??
Thanks,
Frediano
2013/6/21 Peter Deacon <peterd at iea-software.com>
Post by Peter Deacon
Thanks, I'll send in a patch.
regards,
Peter
arielCo
2013-06-27 20:52:18 UTC
Permalink
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
Post by Frediano Ziglio
2013/6/25 arielCo <arielco at gmail.com>
Post by arielCo
$ 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
Post by arielCo
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
Post by arielCo
Post by arielCo
Applied the patch (and tested with Linux). Ariel, can you try updating
your
Post by arielCo
FreeTDS ??
Thanks,
Frediano
2013/6/21 Peter Deacon <peterd at iea-software.com>
Post by Peter Deacon
Thanks, I'll send in a patch.
regards,
Peter
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
-------------- next part --------------
A non-text attachment was scrubbed...
Name: config.h
Type: text/x-chdr
Size: 18899 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20130627/c7f28309/attachment-0001.bin
Frediano Ziglio
2013-06-28 04:00:09 UTC
Permalink
2013/6/27 arielCo <arielco at gmail.com>
Post by arielCo
There's no -p option, but TDSPORT is honored. I used a fresh tree from
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
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
Post by arielCo
Post by Frediano Ziglio
2013/6/25 arielCo <arielco at gmail.com>
Post by arielCo
Same result. The only difference is that it doesn't take as long to
$ 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"
Post by Frediano Ziglio
Post by arielCo
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
Post by arielCo
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
Post by Frediano Ziglio
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)
Post by Frediano Ziglio
to get configuration dumps.
Frediano
Post by arielCo
Post by arielCo
Applied the patch (and tested with Linux). Ariel, can you try updating
your
Post by arielCo
FreeTDS ??
Thanks,
Frediano
2013/6/21 Peter Deacon <peterd at iea-software.com>
Post by Peter Deacon
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
arielCo
2013-06-28 23:44:59 UTC
Permalink
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
Post by Frediano Ziglio
2013/6/27 arielCo <arielco at gmail.com>
Post by arielCo
There's no -p option, but TDSPORT is honored. I used a fresh tree from
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
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
Post by arielCo
Post by Frediano Ziglio
2013/6/25 arielCo <arielco at gmail.com>
Post by arielCo
Same result. The only difference is that it doesn't take as long to
$ 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"
Post by Frediano Ziglio
Post by arielCo
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
Post by arielCo
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
Post by Frediano Ziglio
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)
Post by Frediano Ziglio
to get configuration dumps.
Frediano
Post by arielCo
Post by arielCo
Applied the patch (and tested with Linux). Ariel, can you try updating
your
Post by arielCo
FreeTDS ??
Thanks,
Frediano
2013/6/21 Peter Deacon <peterd at iea-software.com>
Post by Peter Deacon
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
James K. Lowden
2013-06-29 17:05:06 UTC
Permalink
On Fri, 28 Jun 2013 19:14:59 -0430
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).
"man ./doc/fisql.1" should be perfectly readable. If not, I'd want to
correct it. "man fisql" should work fine, post-installation.

The nroff command is "nroff -mdoc doc/fisql.1". The page uses the
sophisticated mdoc macro set, not the primitive man set. :-)

--jkl
James K. Lowden
2013-06-29 17:12:14 UTC
Permalink
On Fri, 28 Jun 2013 19:14:59 -0430
Post by arielCo
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.
Yes, it's been an issue for a long time. The dump file is opened
per-connection, so some of the pre-connection activity can't be
logged. Usually this isn't really a problem, because most problems
aren't in the library proper, but in the interaction with the server,
and it has the advantage of automatically truncating the log on every
connection. But it has its awkwark moments, including initialization
issues and on webservers, where a per-connection log is useless.

--jkl

Continue reading on narkive:
Search results for '[freetds] Git master doesn't resolve the host.' (Questions and Answers)
10
replies
Do you know a lot about Romeo and Juliet?
started 2007-02-06 16:22:28 UTC
homework help
Loading...