FreeTDS Development Group

[Bob Kline <bkline AT rksystems.com>]

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