make test fails

John Dejournett johnde at greeley.sykes.com
Mon Mar 13 08:57:27 EST 2000


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 at localhost freetds]$
		> cd
		> 		> src/tds/unittests
		> 		> 		>
[camber at localhost
		> unittests]$ make
		> 		> 		>
[camber at 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')
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: tdslog.txt
Url: http://lists.ibiblio.org/pipermail/freetds/attachments/20000313/267fd668/attachment.txt 


More information about the FreeTDS mailing list