How to compile SQSH with FreeTDS .60?

Jay Sauls jaysauls at hotmail.com
Mon Oct 7 13:04:42 EDT 2002



Steve,

Here's my original setup:

I've compiled FreeTDS and gotten tsql to work correctly:

[jays at jays-linux src]$ tsql -S jays.corp.digimine.com -U corp\\jays
Password:
Msg 5703, Level 0, State 1, Server JAYS, Line 0
Changed language setting to us_english.
1> exit
[jays at jays-linux src]$


However, after compiling sqsh and running it, no joy:

[jays at jays-linux src]$ ./sqsh -S jays.corp.digimine.com -U corp\\jays
sqsh-2.1 Copyright (C) 1995-2001 Scott C. Gray
This is free software with ABSOLUTELY NO WARRANTY
For more information type '\warranty'
Password:
Msg 18452, Level 14, State 1

Login failed for user 'corp'. Reason: Not associated with a trusted SQL 
Server
connection.
Login incorrect.


jkl suggested turning logging, but I'm not sure what he meant by that.  I 
have my freetds.conf configured this way:

# jay's SQLServer
[jays.corp.digimine.com]
        host = jays.corp.digimine.com
        port = 1433
        tds version = 8.0
        try domain login = yes
        try server login = no
        nt domain = corp
;       cross domain login = yes
        dump file = /home/jays/jays.tdsdump.txt
        debug level = 99

in my freetds.conf file under the section for jays.corp.digimine.com, but  
the resulting files aren't very interesting (for the failure, they just show 
the packet coming back with the failure message:

2002-10-07 11:46:06 Connecting addr 172.17.1.50 port 1433
2002-10-07 11:46:06 inside tds_process_login_tokens()
Received header @ 2002-10-07 11:46:06
0000  04 01 00 d4 00 00 01 00                           |........|


Received packet @ 2002-10-07 11:46:06
0000  aa c0 00 14 48 00 00 01 0e  5a 00 4c 00 6f 00 67   |....H.... Z.L.o.g|
0010  00 69 00 6e 00 20 00 66 00  61 00 69 00 6c 00 65   |.i.n. .f. a.i.l.e|
0020  00 64 00 20 00 66 00 6f 00  72 00 20 00 75 00 73   |.d. .f.o. r. .u.s|
0030  00 65 00 72 00 20 00 27 00  63 00 6f 00 72 00 70   |.e.r. .'. c.o.r.p|
0040  00 27 00 2e 00 20 00 52 00  65 00 61 00 73 00 6f   |.'... .R. e.a.s.o|
0050  00 6e 00 3a 00 20 00 4e 00  6f 00 74 00 20 00 61   |.n.:. .N. o.t. .a|
0060  00 73 00 73 00 6f 00 63 00  69 00 61 00 74 00 65   |.s.s.o.c. i.a.t.e|
0070  00 64 00 20 00 77 00 69 00  74 00 68 00 20 00 61   |.d. .w.i. t.h. .a|
0080  00 20 00 74 00 72 00 75 00  73 00 74 00 65 00 64   |. .t.r.u. s.t.e.d|
0090  00 20 00 53 00 51 00 4c 00  20 00 53 00 65 00 72   |. .S.Q.L.  .S.e.r|
00a0  00 76 00 65 00 72 00 20 00  63 00 6f 00 6e 00 6e   |.v.e.r. . c.o.n.n|
00b0  00 65 00 63 00 74 00 69 00  6f 00 6e 00 2e 00 00   |.e.c.t.i. o.n....|
00c0  00 00 00 fd 02 00 00 00 00  00 00 00               |......... ...|


2002-10-07 11:46:06 inside tds_process_default_tokens() marker is aa
2002-10-07 11:46:06 inside tds_process_default_tokens() marker is fd
2002-10-07 11:46:06 leaving tds_process_login_tokens() returning 0
2002-10-07 11:46:06 leaving ct_connect() returning 0
2002-10-07 11:46:06 inside ct_con_props() action = CS_GET property = 26
2002-10-07 11:46:06 inside ct_con_drop()
2002-10-07 11:46:06 inside ct_exit()


finally, my comment about the Samba username/domain name was from a large 
note I have printed out and posted beside my linux machine that says:

"A collegue of mine found the answer to my post through tial and error.

mount -t smbfs -o username=username/domain //server/share /mnt/point

Note: username/domain is backwards from the way you do it on NT"

I'm sure the original source of this note could be found googling on 
newsgroups....

>From: Steve Langasek <vorlon at netexpress.net>
>Reply-To: "TDS Development Group" <freetds at franklin.oit.unc.edu>
>To: "TDS Development Group" <freetds at franklin.oit.unc.edu>
>Subject: [freetds] Re: How to compile SQSH with FreeTDS .60?
>Date: Mon, 7 Oct 2002 13:31:00 -0500
>
>On Mon, Oct 07, 2002 at 10:57:20AM -0700, Jay Sauls wrote:
> > When I run ./configure for FreeTDS, do I need to specify either the
> > --enable-msdblib or --enable-sybase-compat flags to make this work?
>
> > Right now, the only flag I'm passing to ./configure is --with-ssl
>
> > Thanks to everyone for your help on this....
>
>This is the only flag you should need.  The other flags affect the
>FreeTDS ABI, and if you needed them you would know soon enough because
>sqsh would complain about missing symbols.
>
>Unfortunately, I still haven't seen your original message come through
>the mailing list.  Can you repost the errors you're seeing?  I can't help
>but think the solution would be really obvious if I could just see the
>sqsh output... :)
>
> > As a side note, the Samba standard for usernames is even more confusing:
> > It's actually username/domain   (not domain/username as you mentioned).
>
> > That particular idiosyncrasy has driven me nearly insane on more than
> > one instance....
>
>I'm not sure where you've encountered this usage.  I've never seen domain
>names and usernames concatenated in Samba at all, except by winbind,
>which has its own syntax.
>
>Steve Langasek
>postmodern programmer
><< attach3 >>
>---
>You are currently subscribed to freetds as: [jaysauls at hotmail.com]
>To unsubscribe, forward this message to 
>$subst('Email.Unsub')




_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com




More information about the FreeTDS mailing list