FreeTDS Development Group

[Brian Bruns <camber AT umcc.ais.org>]

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