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