Skip to Content.
Sympa Menu

freetds - Re: Odd program behavior

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Bob Kline <bkline AT rksystems.com>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Odd program behavior
  • Date: Wed, 26 Jan 2000 20:57:10 -0500 (EST)


On Wed, 26 Jan 2000, Brian Bruns wrote:

>
>
> On Wed, 26 Jan 2000, Ian Charnas wrote:
>
> > Hello, I'm a college programmer writing some apache authentication
> > modules,
> > and I'm currently working on mod_auth_tds which will authenticate users
> > via
> > a Sybase or MS SQL database server. I'm currently planning on using
> > freetds as my C interface into the database servers.
> >
> > I wish I could have figured this out myself, but I can't. I read the FAQ
> > over and over, I read all the archived messages from the mailing list,
> > and
> > I looked through all the pertinant source code, but I still can't figure
> > out how to fix this problem:
> >
> > I compiled the code found at the bottom of the message, which is simply a
> > test to see if the program can login correctly to the SQL server, and it
> > connects to myserver1 correctly. myserver1 is a development server
> > running
> > NT 4.0 server and SQL 7.0.
> >
> > The problem is when I try to connect to the production server (myserver2
> > let's call it) running the same operating system and the same SQL Server
> > (same versions of course). That continually fails on login. I'm sure
> > the
> > username/password is correct, I'm fairly sure the interfaces file is
> > correct in syntax, and I configured FreeTDS --with-tdsver=4.2 as I should
> > have.
> >
> > The odd thing is I can however, connect to both myserver1 and myserver2
> > if
> > I write the code in perl and use DBD::Sybase and the DBI scheme, which
> > lets
> > me know it's not a network problem, my username/password is correct, and
> > so
> > on.
> >
> Interesting one, I was about to suggest it might be that you had only
> domain logins to the second server, but this blows that theory out of the
> water. Are you using the same service pack on both servers?
>
> > So, I set the TDSDUMP environment variable and the following is a partial
> > printout of the error according to the log file...(I neglected to include
> > the printout of what packets were sent, because they contain my
> > username/password)
> > /****************************/
> > 2000-01-26 01:13:10 inside tds_process_login_tokens()
> > 2000-01-26 01:13:11 inside tds_process_default_tokens() marker is aa
> > 2000-01-26 01:13:11 inside tds_process_default_tokens() marker is fd
> > 2000-01-26 01:13:11 leaving tds_process_login_tokens() returning 0
> > /****************************/
> >
> > Anyone have any idea as to what I can try to get this to work?
> >
> This shows that you are getting a valid return from the SQL Server, but
> alas not a login acknowledgement.
>
> I tried your script and was able to connect against Sybase...have not been
> able to try MS SQL yet. (hopefully tommorow).
>
> So, here is what to do...see that marker is aa message up there? that's
> your error that the database is returning. you need to print the text of
> that out. Way number one, install a message handler...you can look in
> dblib or ctlib for specifics...(I should create a sample showing how to do
> this someday)...Way number two (the easy way) run this through the
> debugger, set a breakpoint in tds_process_msg() and print the relevent
> variables.
>
> Hope this helps, and send me a link to your program when its done!
>

Are the two SQL Servers set up with the same security methods?

--
Bob Kline
mailto:bkline AT rksystems.com
http://www.rksystems.com





Archive powered by MHonArc 2.6.24.

Top of Page