Skip to Content.
Sympa Menu

freetds - Re: [freetds] SQSH2.1 compiles, but hangs & quits @ logon

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Ron Creamer" <ron AT pageworks.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] SQSH2.1 compiles, but hangs & quits @ logon
  • Date: Sat, 27 Dec 2003 21:08:54 -0500



Lowden, James K wrote:
SQSH is written to Sybase's standard, not Microsoft's. I'm a little
surprised it even links to FreeTDS with msdblib enabled.

I'm assuming from follow on posts that it should still work.

I applied a patch credited to Gentoo to the src/config.h file after my I ran configure:


This is a sqsh patch, right? I don't see how it could do any harm, although
you could probably do without it.

Actually, without this patch, it fails to compile. The patch forwarded to me by Garret Goebel a while back, credited to Gentoo is:
Gentoo has the following patch for src/config.h after you've run configure:

60c60
< /* #undef HAVE_STRERROR */
---

>> #define HAVE_STRERROR 1

62,67c62,67
< /* #undef HAVE_STRFTIME */
< /* #undef HAVE_MEMCPY */
< /* #undef HAVE_MEMMOVE */
< /* #undef HAVE_LOCALTIME */
< /* #undef HAVE_TIMELOCAL */
< /* #undef HAVE_STRCHR */
---

>> #define HAVE_STRFTIME 1
>> #define HAVE_MEMCPY 1
>> #define HAVE_MEMMOVE 1
>> #define HAVE_LOCALTIME 1
>> #define HAVE_TIMELOCAL 1
>> #define HAVE_STRCHR 1

69c69
< /* #undef HAVE_GETTIMEOFDAY */
---

>> #define HAVE_GETTIMEOFDAY 1

Try:

1. Configure without --enable-msdblib.
Exact same behavior (hangs)
2. Double check that sqsh is linking to the right FreeTDS (with ldd).
I believe it is. Here is the output of "ldd sqsh":
libct.so.2 => /usr/lib/libct.so.2 (0x0030a000)
libtds.so.3 => /usr/lib/libtds.so.3 (0x008de000)
libdl.so.2 => /lib/libdl.so.2 (0x00bcb000)
libm.so.6 => /lib/tls/libm.so.6 (0x00ba7000)
libreadline.so.4 => /usr/lib/libreadline.so.4 (0x0481c000)
libncurses.so.5 => /usr/lib/libncurses.so.5 (0x047da000)
libc.so.6 => /lib/tls/libc.so.6 (0x00a6c000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x00a54000)
libgpm.so.1 => /usr/lib/libgpm.so.1 (0x00a48000)

3. Post a log, so we can see where it's giving up.
Unfortunately, even with the log level at 99, no entries make it into the log. I feel it is a sqsh problem, it doesn't even seem to get to freetds.
4. Run sqsh under gdb, and post a backtrace if it catches a signal.
My apologies, I've never run gdb. I've tried it several times, and I'm not yet familiar enough with it. Do you have proper syntax to run gdb on a sqsh command line such as "sqsh -S sqlserver -U username -P password"?


HTH. Always happy to help a fellow sqsher.

Thanks. I appreciate it. Again, tsql works flawlessly. I didn't want to go on with apache/php until I had sqsh working first per the freetds manual.

If it helps, sqsh exits with an error of 255, which is basically just a "general" error.

-Ron





Archive powered by MHonArc 2.6.24.

Top of Page