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