make test fails

Brian Bruns camber at umcc.ais.org
Fri Mar 10 18:25:37 EST 2000



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




More information about the FreeTDS mailing list