FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

I was afraid of that.  Well, beg and plead for your admin to changed to 
'mixed mode', it won't affect the current clients.  There is code in 
FreeTDS to use NTLM hashes for login, problem is there is some out of band 
activity going on with domain registration.  If you have a working Win32 
client and are capable of packet sniffing it, I think we could make it 
work.

Brian

On Tue, 4 Dec 2001, Casey Allen Shobe wrote:

> Damn...is this a systemwide setting on the SQL server?  I don't have direct 
> access to it, and doubt that setting can be changed because the client 
> software that the entire company uses may rely upon how it's set up now.
> 
> - Casey
> 
> On 4 December 2001 22:24, Brian Bruns spaketh unto ye recipient:
> > Bingo!  I was suspecting this, but didn't want to jump to conclusions.
> > Your SQL Server is set up in 'Windows NT Authentication' sometimes called
> > 'Domain Authentication'.  This needs to be changed to 'SQL Server' or
> > 'Standard' authentication.
> >
> > From SQL Server Enterprise Manager (SQL Server 7, not sure how different
> > 2000 is), navigate to the server, right mouse click and select
> > 'Properties'.  Flip to the 'Security' tab and change the Authentication
> > field to 'SQL Server and Windows NT', apply your changes and be happy.
> >
> > Brian
> >
> > On Tue, 4 Dec 2001, Casey Allen Shobe wrote:
> > > I really appreciate your help...here's the dump:
> > >
> > > cshobe@sliver:/tmp$ cat freetds.log
> > > 2001-12-04 22:16:01 Connecting addr 192.168.24.6 port 1433
> > > 2001-12-04 22:16:01 inside tds_process_login_tokens()
> > > Received packet @ 2001-12-04 22:16:01
> > > 0000  aa dc 00 14 48 00 00 01 0e 68 00 4c 00 6f 00 67  
> > > |....H....h.L.o.g| 0010  00 69 00 6e 00 20 00 66 00 61 00 69 00 6c 00 
> > > 65 
> > >  |.i.n. .f.a.i.l.e| 0020  00 64 00 20 00 66 00 6f 00 72 00 20 00 75 00 
> > > 73
> > >   |.d. .f.o.r. .u.s| 0030  00 65 00 72 00 20 00 27 00 53 00 45 00 43 00
> > > 55   |.e.r. .'.S.E.C.U| 0040  00 52 00 45 00 57 00 4f 00 52 00 4b 00 53
> > > 00 5c   |.R.E.W.O.R.K.S.\| 0050  00 63 00 73 00 68 00 6f 00 62 00 65 00
> > > 27 00 2e   |.c.s.h.o.b.e.'..| 0060  00 20 00 52 00 65 00 61 00 73 00 6f
> > > 00 6e 00 3a   |. .R.e.a.s.o.n.:| 0070  00 20 00 4e 00 6f 00 74 00 20 00
> > > 61 00 73 00 73   |. .N.o.t. .a.s.s| 0080  00 6f 00 63 00 69 00 61 00 74
> > > 00 65 00 64 00 20   |.o.c.i.a.t.e.d. | 0090  00 77 00 69 00 74 00 68 00
> > > 20 00 61 00 20 00 74   |.w.i.t.h. .a. .t| 00a0  00 72 00 75 00 73 00 74
> > > 00 65 00 64 00 20 00 53   |.r.u.s.t.e.d. .S| 00b0  00 51 00 4c 00 20 00
> > > 53 00 65 00 72 00 76 00 65   |.Q.L. .S.e.r.v.e| 00c0  00 72 00 20 00 63
> > > 00 6f 00 6e 00 6e 00 65 00 63   |.r. .c.o.n.n.e.c| 00d0  00 74 00 69 00
> > > 6f 00 6e 00 2e 00 00 00 00 00 fd   |.t.i.o.n........| 00e0  02 00 00 00
> > > 00 00 00 00                           |........|
> > >
> > >
> > > 2001-12-04 22:16:01 inside tds_process_default_tokens() marker is aa
> > > 2001-12-04 22:16:01 Msg 18452, Level 14, State 1, Server , Line 0
> > > Login failed for user 'SECUREWORKS\cshobe'. Reason: Not associated with 
> > > a
> > > trusted SQL Server connection.
> > > 2001-12-04 22:16:01 inside tds_process_default_tokens() marker is fd
> > > 2001-12-04 22:16:01 leaving tds_process_login_tokens() returning 0
> > >
> > > On 4 December 2001 17:56, Brian Bruns spaketh unto ye recipient:
> > > > Well it got further. set the TDSDUMP variable and run:
> > > >
> > > > export TDSDUMP=/tmp/freetds.log
> > > >
> > > > and then run and post the log file (please remove your
> > > > username/password if they are important).
> > > >
> > > > Brian
> > > >
> > > > On Tue, 4 Dec 2001, Casey Allen Shobe wrote:
> > > > > Added to odbe.ini under [pivotal]:
> > > > >
> > > > > Servername    = pivotal
> > > > >
> > > > > Added to freetds.conf:
> > > > > [pivotal]
> > > > >       host = 192.168.24.6
> > > > >       port = 1433
> > > > >       tds version = 7.0
> > > > >
> > > > > Now the script generates:
> > > > >
> > > > > Warning: SQL error: tds_connect failed, SQL state 08001 in 
> > > > > SQLConnect
> > > > > in test.php...
> > > > >
> > > > > - Casey
> > > > >
> > > > > On 4 December 2001 17:08, Brian Bruns spaketh unto ye recipient:
> > > > > > You need a entry in the odbc.ini file (under the pivotal section)
> > > > > >
> > > > > > [pivotal]
> > > > > > ...
> > > > > > Servername = <yourservername>
> > > > > > ...
> > > > > >
> > > > > > Where <yourservername> is the server alias listed in your
> > > > > > freetds.conf file.  I would highly recommend grabbing sqsh
> > > > > > (www.sqsh.org) and building it to make sure your freetds install
> > > > > > and freetds.conf file are correct.
> > > > > >
> > > > > > This was discussed about a week ago on the list and a change was
> > > > > > checked in then to say 'Servername' instead of 'Database'.  i.e.
> > > > > > There's an error in the error message. :-/
> > > > > >
> > > > > > Cheers,
> > > > > >
> > > > > > Brian
> > > > > >
> > > > > > P.S. Is it just me, or has there been a whole rash of ODBC
> > > > > > questions lately?
> > > > > >
> > > > > > On Tue, 4 Dec 2001, Casey Allen Shobe wrote:
> > > > > > > I'm still in utter failure after a full day's work.
> > > > > > >
> > > > > > > I finally got the thing to seemingly install correctly (at least
> > > > > > > to the point that I could start Apache/PHP and still use DB2) by
> > > > > > > using iODBC.  I pointed iODBC at my db2 stuff and db2 queries
> > > > > > > work fine!
> > > > > > >
> > > > > > > However, the FreeTDS stuff seems to be getting nowhere...
> > > > > > >
> > > > > > > odbc.ini:
> > > > > > > [ODBC Data Sources]
> > > > > > > sw_p      = IBM DB2 Connect Driver
> > > > > > > pivotal   = FreeTDS Driver
> > > > > > >
> > > > > > > [Default]
> > > > > > > driver = /usr/lib/oplodbc.so.1
> > > > > > >
> > > > > > > [sw_p]
> > > > > > > Description       = DB2 Production Database
> > > > > > > Options           = sw_p
> > > > > > > Port              = 523
> > > > > > > Protocol  = TCP/IP
> > > > > > > Driver            = /usr/DBMdb2/V7.1/lib/libdb2.so.1
> > > > > > > Database  = sw
> > > > > > > FetchBufferSize   = 99
> > > > > > >
> > > > > > > [pivotal]
> > > > > > > Description       = Pivotal Production Database
> > > > > > > Options           = sw_enterprise_data
> > > > > > > Port              = 1433
> > > > > > > Host              = 192.168.24.6
> > > > > > > ServerType        = SQLServer 2000
> > > > > > > Protocol  = TCP/IP
> > > > > > > Driver            = /usr/lib/libtdsodbc.so
> > > > > > > Database  = sw_enterprise_data
> > > > > > > FetchBufferSize   = 99
> > > > > > > Trace             = No
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > odbcinst.ini:
> > > > > > > [ODBC Drivers]
> > > > > > > IBM DB2 Connect Driver = Installed
> > > > > > > FreeTDS Driver = Installed
> > > > > > >
> > > > > > > [IBM DB2 Connect Driver]
> > > > > > > Driver    = /usr/IBMdb2/V7.1/lib/libdb2.so.1
> > > > > > > Setup     = /usr/IBMdb2/V7.1/lib/libdb2.so.1
> > > > > > >
> > > > > > > [FreeTDS Driver]
> > > > > > > Driver    = /usr/lib/libtdsodbc.so
> > > > > > > Setup     = /usr/lib/libtdsodbc.so
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > test.php:
> > > > > > > <?php
> > > > > > >
> > > > > > > $piv_conn = odbc_connect ('pivotal', 'SECUREWORKS\cshobe',
> > > > > > > 'password'); $dbtest = odbc_exec ($piv_conn, 'select * from
> > > > > > > company');
> > > > > > >
> > > > > > > ?>
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > I get the following when I try to load it:
> > > > > > >
> > > > > > > Warning: SQL error: Could not find Database parameter, SQL state
> > > > > > > 08001 in SQLConnect in test.php on line 3.
> > > > > > > Warning: Supplied argument is not a valid ODBC-Link resource in
> > > > > > > test.php on line 4.
> > > > > > >
> > > > > > >
> > > > > > > Help please!!  I'm stuck and don't know where to go from here.
> > > > > >
> > > > > > ---
> > > > > > You are currently subscribed to freetds as: [cshobe AT softhome.net]
> > > > > > To unsubscribe, forward this message to
> > > > > > $subst('Email.Unsub')
> > > >
> > > > ---
> > > > You are currently subscribed to freetds as: [cshobe AT softhome.net]
> > > > To unsubscribe, forward this message to
> > > > $subst('Email.Unsub')
> >
> > ---
> > You are currently subscribed to freetds as: [cshobe AT softhome.net]
> > To unsubscribe, forward this message to
> > $subst('Email.Unsub')
> 
>