make test fails

John Dejournett johnde at greeley.sykes.com
Fri Mar 10 18:55:09 EST 2000


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')



More information about the FreeTDS mailing list