FreeTDS Development Group

["Jay Sauls" <jaysauls AT hotmail.com>]

Steve,

Here's my original setup:

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

[jays@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@jays-linux src]$


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

[jays@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