FreeTDS Development Group

[John Dejournett <johnde AT greeley.sykes.com>]

Brian,

I am attaching my FreeTDS log file.  I have edited it a little for obvious
security reasons.  I may have the user name and password transposed since
they are the same for this particular account, but this should reasonably
accurate.

Sincerely,
John DeJournett

 <<tdslog.txt>> 

                -----Original Message-----
                From:   Brian Bruns [mailto:camber AT umcc.ais.org]
                Sent:   Friday, March 10, 2000 5:33 PM
                To:     TDS Development Group
                Subject:        [freetds] Re: make test fails


                Good one.  I'm stumped.  Obviously, SQL Server doesn't like
what gets
                sent, can you set TDSDUMP and look at the login packet to
make soure your
                login/passwd appears in there correctly?

                Brian

                On Fri, 10 Mar 2000, John Dejournett wrote:

                > Brian,
                > 
                > No such luck on this.  The server uses server login in
this case.  They have
                > a completely different form from our domain logins.  I am
going out on a
                > limb here, but I am at least reasonably certain that I did
enter my login
                > information correctly in the PWD file.  I'll be sure to
confirm that anyway.
                > Any other ideas?
                > 
                > Sincerely,
                > John DeJournett
                > 
                > 
                > 
                >               -----Original Message-----
                >               From:   Brian Bruns
[mailto:camber AT umcc.ais.org]
                >               Sent:   Friday, March 10, 2000 4:26 PM
                >               To:     TDS Development Group
                >               Subject:        [freetds] Re: make test
fails
                > 
                > 
                >               Ok, so we are talking to the SQL Server, but
receiving a
                > negative
                >               acknowlegement.  One probable cause it that
the sql server
                > is using domain
                >               login and not server logins.  The other (but
not probable)
                > couase would be
                >               the login/password is wrong :-)
                > 
                >               Brian
                > 
                >               On Fri, 10 Mar 2000, John Dejournett wrote:
                > 
                >               > Brian,
                >               > 
                >               > SYBASE is set to /usr/local/freetds, and
the interfaces
                > file is present.  I
                >               > am including a copy of the tds->msg_info
data.  Hopefully
                > this will be
                >               > useful in determining the actual cause of
the failure.
                >               > 
                >               >   priv_msg_type = 1, 
                >               >   line_number = 0, 
                >               >   msg_number = 4002, 
                >               >   msg_state = 1, 
                >               >   msg_level = 14, 
                >               >   server = 0x804ac90 "Microsoft SQL
Server",
                >               >   message = 0x804ac78 " Login failed\r\n",

                >               >   proc_name = 0x0, 
                >               >   sql_state = 0x0
                >               > 
                >               > Other than the "Login failed" message, the
only thing that
                > looks like a clue
                >               > here is 4002.  Generally when I get this
error number on a
                > Windows system I
                >               > start looking into the ODBC configuration.
It was my
                > impression that
                >               > FreeTDS does not require an ODBC in order
to operate.  Is
                > this correct?
                >               > As always, help, suggestions, comments,
and a good knock
                > on the head are
                >               > very much appreciated :)
                >               > 
                >               > Sincerely,
                >               > John DeJournett
                >               > 
                >               > 
                >               >               -----Original Message-----
                >               >               From:   Brian Bruns
                > [mailto:camber AT umcc.ais.org]
                >               >               Sent:   Friday, March 10,
2000 3:07 PM
                >               >               To:     TDS Development
Group
                >               >               Subject:        [freetds]
Re: make test
                > fails
                >               > 
                >               > 
                >               >               Have you've set the SYBASE
environment
                > variable to the place
                >               > where
                >               >               you installed freetds?
                >               > 
                >               >               To turn on logging on set
the TDSDUMP env
                > variable, for
                >               > instance 'export
                >               >               TDSDUMP=/tmp/freetds.log'
                >               > 
                >               >               Brian
                >               > 
                >               >               On Fri, 10 Mar 2000, John
Dejournett wrote:
                >               > 
                >               >               > Brian,
                >               >               > 
                >               >               > I tried running the t0001
test, but the
                > only output was
                >               > "tds failed! on
                >               >               > t0001.c".
                >               >               > 
                >               >               > This inspired me to do a
little debugging
                > on the test
                >               > source.  The first
                >               >               > thing I discovered is that
in
                > freetds/src/tds/util.c, line
                >               > 245 there is a
                >               >               > test to determine if the
interfaces file
                > is present.  For
                >               > some reason
                >               >               > interf_file = \000, and
the test failed.
                > Because of this,
                >               > the interfaces
                >               >               > file was never being read.
As a temporary
                > workaround for
                >               > this I copied the
                >               >               >
/usr/local/freetds/interfaces file to
                > ~/.interfaces.  This
                >               > did work to get
                >               >               > the server IP and port
numbers.  Anyone
                > who knows how to
                >               > fix this, I would
                >               >               > greatly appreciate a
suggestion.
                >               >               > 
                >               >               > Now back to the main
issue.  After some
                > further debugging
                >               > the t0001 program
                >               >               > is connecting to the
server.  It sends
                > login information,
                >               > but apparently the
                >               >               > login fails.  It also
appears that there
                > is a log file
                >               > that tracks these
                >               >               > transactions with the
server.  If anyone
                > knows where that
                >               > file is and what
                >               >               > it is called, this may
contain some useful
                > information on
                >               > exactly what the
                >               >               > error is.
                >               >               > 
                >               >               > Finally, another note for
the
                > implementers:  not that I
                >               > don't appreciate
                >               >               > having the libraries
already  compiled
                > with the debugging
                >               > information, but
                >               >               > to make the libraries as
small as possible
                > I would suggest
                >               > having a switch
                >               >               > in the configure options
to enable or
                > disable debugging.
                >               >               > 
                >               >               > Sincerely,
                >               >               > John DeJournett
                >               >               > 
                >               >               > 
                >               >               > 
                >               >               >
-----Original Message-----
                >               >               >               From:
Brian Bruns
                >               > [mailto:camber AT umcc.ais.org]
                >               >               >               Sent:
Thursday, March 09,
                > 2000 5:22 PM
                >               >               >               To:     TDS
Development
                > Group
                >               >               >               Subject:
[freetds]
                > Re: make test
                >               > fails
                >               >               > 
                >               >               > 
                >               >               >               try running
one of the
                > example programs and
                >               > see what the
                >               >               > error is.
                >               >               > 
                >               >               >
[camber@localhost freetds]$
                > cd
                >               > src/tds/unittests
                >               >               >
[camber@localhost
                > unittests]$ make
                >               >               >
[camber@localhost
                > unittests]$ ./t0001
                >               >               > 
                >               >               >               Brian
                >               >               > 
                >               >               >               On Thu, 9
Mar 2000, John
                > Dejournett wrote:
                >               >               > 
                >               >               >               > Michael,
                >               >               >               > 
                >               >               >               > Thanks for
the suggestion.
                > It is a start,
                >               > but make test
                >               >               > still fails every
                >               >               >               > test.  The
PWD file now
                > contains entries
                >               > for my login
                >               >               > name, password, the
                >               >               >               > server
entry name from
                >               > /usr/local/freetds/interfaces, and
                >               >               > the database name.
                >               >               >               > I doubt
that it would make
                > any difference,
                >               > but I am
                >               >               > running configure with
                >               >               >               > the
-with-tdsver=4.2
                > parameter, and the
                >               > database I am
                >               >               > using in interfaces is
                >               >               >               > an MS-SQL
server.
                >               >               >               > 
                >               >               >               > I did not
notice anything
                > in the install
                >               > file or
                >               >               > documentation for editing
                >               >               >               > the PWD,
so that would be
                > a good note for
                >               > the
                >               >               > implementers/maintainers.
Any
                >               >               >               > other
ideas to get these
                > tests working
                >               > would be greatly
                >               >               > appreciated.
                >               >               >               > 
                >               >               >               > Sincerely,
                >               >               >               > John
DeJournett
                >               >               >               > 
                >               >               >               >
                > -----Original Message-----
                >               >               >               >
From:
                > Michael Suedkamp
                >               >               >
[mailto:ms AT suedkm.franken.de]
                >               >               >               >
Sent:
                > Wednesday, March 08,
                >               > 2000 6:01 PM
                >               >               >               >
To:     TDS
                > Development
                >               > Group
                >               >               >               >
Subject:
                > [freetds]
                >               > Re: make test
                >               >               > fails
                >               >               >               > 
                >               >               >               >
Have you
                > adapted the PWD
                >               > file?
                >               >               >               > 
                >               >               >               >
Michael
                >               >               >               > 
                >               >               >               >
---
                >               >               >               >
You are
                > currently subscribed
                >               > to freetds as:
                >               >               >               >
johnde AT greeley.sykes.com
                >               >               >               >
To
                > unsubscribe, forward this
                >               > message to
                >               >               >               >
                > $subst('Email.Unsub')
                >               >               >               > 
                >               >               >               > ---
                >               >               >               > You are
currently
                > subscribed to freetds
                >               > as: camber AT ais.org
                >               >               >               > To
unsubscribe, forward
                > this message to
                >               >               >
$subst('Email.Unsub')
                >               >               >               > 
                >               >               >               > 
                >               >               > 
                >               >               > 
                >               >               >               ---
                >               >               >               You are
currently subscribed
                > to freetds as:
                >               >               > johnde AT greeley.sykes.com
                >               >               >               To
unsubscribe, forward this
                > message to
                >               >               >
$subst('Email.Unsub')
                >               >               > 
                >               >               > ---
                >               >               > You are currently
subscribed to freetds
                > as: camber AT ais.org
                >               >               > To unsubscribe, forward
this message to
                >               > $subst('Email.Unsub')
                >               >               > 
                >               >               > 
                >               > 
                >               > 
                >               >               ---
                >               >               You are currently subscribed
to freetds as:
                >               > johnde AT greeley.sykes.com
                >               >               To unsubscribe, forward this
message to
                >               > $subst('Email.Unsub')
                >               > 
                >               > ---
                >               > You are currently subscribed to freetds
as: camber AT ais.org
                >               > To unsubscribe, forward this message to
                > $subst('Email.Unsub')
                >               > 
                >               > 
                > 
                > 
                >               ---
                >               You are currently subscribed to freetds as:
                > johnde AT greeley.sykes.com
                >               To unsubscribe, forward this message to
                > $subst('Email.Unsub')
                > 
                > ---
                > You are currently subscribed to freetds as: camber AT ais.org
                > To unsubscribe, forward this message to
$subst('Email.Unsub')
                > 
                > 


                ---
                You are currently subscribed to freetds as:
johnde AT greeley.sykes.com
                To unsubscribe, forward this message to
$subst('Email.Unsub')
Sending packet @ 2000-03-10 15:58:17
0000  02 00 02 00 00 00 00 00 6d 79 68 6f 73 74 00 00   |........myhost..|
0010  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0020  00 00 00 00 00 00 06 ** ** ** ** ** 00 00 00 00   |.......*****....| <- 
My Login Name
0030  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0040  00 00 00 00 00 05 ** ** ** ** ** 00 00 00 00 00   |......*****.....| <- 
My password
0050  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0060  00 00 00 00 05 33 37 38 37 36 00 00 00 00 00 00   |.....37876......|
0070  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0080  00 00 00 05 03 01 06 0a 09 01 00 00 00 00 02 00   |................|
0090  00 00 00 00 74 30 30 30 31 00 00 00 00 00 00 00   |....t0001.......|
00a0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
00b0  00 00 05 53 49 4d 53 00 00 00 00 00 00 00 00 00   |...SIMS.........| <- 
Entry from interfaces
00c0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
00d0  00 04 ** ** ** ** ** 00 00 00 00 00 00 00 00 00   |..*****.........| <- 
My Login Name again
00e0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
00f0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0100  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0110  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0120  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0130  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0140  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0150  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0160  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0170  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0180  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0190  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
01a0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
01b0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
01c0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
01d0  00 05 04 02 00 00 54 44 53 2d 4c 69 62 72 61 72   |......TDS-Librar|
01e0  0a 00 00 00 00 00 0d 11 75 73 5f 65 6e 67 6c 69   |........us_engli|
01f0  73 68 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |sh..............|


Sending packet @ 2000-03-10 15:58:17
0000  02 01 00 4c 00 00 00 00 00 00 00 00 00 00 0a 00   |...L............|
0010  00 00 00 00 00 00 00 00 00 00 00 00 00 69 73 6f   |.............iso|
0020  5f 31 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |_1..............|
0030  00 00 00 00 00 00 00 00 00 00 00 05 01 35 31 32   |.............512|
0040  00 00 00 03 00 00 00 00 00 00 00 00               |............|


2000-03-10 15:58:17 inside tds_process_login_tokens()
2000-03-10 15:58:17 inside tds_process_default_tokens() marker is aa
2000-03-10 15:58:17 inside tds_process_default_tokens() marker is fd
2000-03-10 15:58:17 leaving tds_process_login_tokens() returning 0