28526 2003-09-12 08:02 0000 sqsh not using freetds 2003-09-22 05:03:04 0000 1 1 1 Unclassified Gentoo Linux Development 1.4 x86 Linux RESOLVED FIXED P2 normal --- 1 cstrom@speakeasy.net bug-wranglers@gentoo.org cstrom@speakeasy.net 2003-09-12 08:02:41 0000 I am unable to install a working version of sqsh on my system that can connect with a Sybase DB. The emerge process completetes successfully, but the resulting executable does not connect. I have tried with both versions of freetds that are currently in portage. I *am* able to connect to the database using tsql (from freetds). To connect to my DB, I do the following: $ export DSQUERY=SYBASE The [SYBASE] entry in /etc/freetds.conf is as follows: [SYBASE] host = sybase.foo.com port = 4100 tds version = 5.0 When I try to sqsh, I get the following: $ sqsh semicolon_hack: Invalid boolean value exit_failcount: Invalid boolean value history_shorthand: Invalid boolean value sqsh-2.1 Copyright (C) 1995-2001 Scott C. Gray This is free software with ABSOLUTELY NO WARRANTY For more information type '\warranty' And it just hangs there. I've used strace to see that sqsh is trying to resolve SYBASE.foo.com so it seems like sqsh is not interacting properly with freetds. And yet freetds is installed correctly, because I am able to connect to the DB with: $ tsql -S SYBASE -U cstrom Some other interesting notes: * I've tried compiling directly from source & with the latest Debian patches, but without success. Could this be an issue with ~x86 (where I'm running)? gcc 3.3.1? * I have copied a debian executable onto the system that *does* work correctly. I tried to reproduce the executable with the debian patches, but could not, which seems to indicate a compiler or glibc issue. cstrom@speakeasy.net 2003-09-12 10:57:09 0000 Created an attachment (id=17581) Replacement for the current config.patch in the sqsh ebuild Compiler warnings are our friends. Compiler warnings are our friends. We will not ignore our friends. FINALLY noticed a `tolower' warning when compiling sqsh. The configure script does not detect several functions properly. The current patch included in portage attempts to correct this, but does not include the HAVE_STRCASECMP definition. The attachment is a replacement for the current config.patch which corrects this ommision. After applying the patch to my system, sqsh compiled correctly and, more importantly, it WORKS! seemant@gentoo.org 2003-09-22 05:03:04 0000 nice work chris 17581 2003-09-12 10:57 0000 Replacement for the current config.patch in the sqsh ebuild config.patch text/plain NTksNjBjNTksNjAKPCAvKiAjdW5kZWYgSEFWRV9TVFJDQVNFQ01QICovCjwgLyogI3VuZGVmIEhB VkVfU1RSRVJST1IgKi8KLS0tCj4gI2RlZmluZSBIQVZFX1NUUkNBU0VDTVAgMQo+ICNkZWZpbmUg SEFWRV9TVFJFUlJPUiAxCjYyLDY3YzYyLDY3CjwgLyogI3VuZGVmIEhBVkVfU1RSRlRJTUUgKi8K PCAvKiAjdW5kZWYgSEFWRV9NRU1DUFkgKi8KPCAvKiAjdW5kZWYgSEFWRV9NRU1NT1ZFICovCjwg LyogI3VuZGVmIEhBVkVfTE9DQUxUSU1FICovCjwgLyogI3VuZGVmIEhBVkVfVElNRUxPQ0FMICov CjwgLyogI3VuZGVmIEhBVkVfU1RSQ0hSICovCi0tLQo+ICNkZWZpbmUgSEFWRV9TVFJGVElNRSAx Cj4gI2RlZmluZSBIQVZFX01FTUNQWSAxCj4gI2RlZmluZSBIQVZFX01FTU1PVkUgMQo+ICNkZWZp bmUgSEFWRV9MT0NBTFRJTUUgMQo+ICNkZWZpbmUgSEFWRV9USU1FTE9DQUwgMQo+ICNkZWZpbmUg SEFWRV9TVFJDSFIgMQo2OWM2OQo8IC8qICN1bmRlZiBIQVZFX0dFVFRJTUVPRkRBWSAqLwotLS0K PiAjZGVmaW5lIEhBVkVfR0VUVElNRU9GREFZIDEK