Skip to Content.
Sympa Menu

freetds - Re: make test fails

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT umcc.ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: make test fails
  • Date: Fri, 10 Mar 2000 19:33:18 -0500 (EST)



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





Archive powered by MHonArc 2.6.24.

Top of Page