Hi Hugh, Sorry for previous mail in HTML format. I have attached this in text file. pls read and help me. to connect solaris to MSSQL server. thanks lakmin At 10:01 AM 12/7/99 +1100, you wrote: > >Hello Lakmin - > >Could you please just send your email in text form? HTML is really not good as >you can see from below. > >You mention freetds - are we talking about the same thing? > > ftp://freetds.internetcds.com/pub/freetds_dbd/freetds_dbd.snapshot.tgz > >Note that in the directory called "t" there is a module called "TestCommon.pm" >that must be edited to refer to your local database for the tests to succeed. > >Also note that you must install the DBI module first (this is the most recent >on CPAN): > > http://www.perl.com/CPAN-local/modules/by-module/DBI/DBI-1.13.tar.gz > >hth > >Hugh > >On Tue, 07 Dec 1999, S.K.D. Lakmin Premnath wrote: >> <html><div>hi hugh</div> >> <br> >> <div>I use to connect freeTDS later snapshot version to connect MSSQL 7.0 >> database from a UNIX BSDI 4.01 box. it shows following error. I use >> ./configure --with-tdsver=4.2 to install freeTDS. I use tcpdump no tcp >> ppackets going from UNIX server to SQL server running machine.</div> >> <br> >> <div>can someone help me to overcome this type of >> situation.....??????</div> >> <br> >> <div>Thankx all for helping earlier situations.</div> >> <div>lakmin</div> >> <br> >> <br>
Hi Hugh, Sorry for the previous amil cames to U in HTML format. I use to connect freeTDS later snapshot version to connect MSSQL 7.0 database from a UNIX solaris 2.6 box. it shows following error. I use ./configure --with-tdsver=4.2 to install freeTDS. I use tcpdump no tcp packets going from UNIX server to SQL server running machine. I got that FreeTDS from ftp://freetds.internetcds.com/pub/freetds_dbd/freetds_dbd.snapshot.tgz but it gives following errors can someone help me to overcome this type of situation.....?????? Thankx all for helping earlier situations. lakmin <password, user name, host names are not actual ones for security reason > Error shown in log file:- Tue Dec 7 13:17:44 1999: ERR: Could not connect to SQL database with DBI->conne ct dbi:FreeTDS:database=menik2AA;host=kumudu.lanka.net;port=1433, menik12, menik12 : Tue Dec 7 13:17:44 1999: ERR: Could not connect to any SQL database. Request is ignored. Backing off for 600 seconds from mylog file:- Tue Dec 7 11:57:09 1999: NOTICE: SIGHUP received: restarting Tue Dec 7 11:57:09 1999: INFO: Server started Tue Dec 7 12:23:59 1999: NOTICE: SIGHUP received: restarting Tue Dec 7 12:23:59 1999: INFO: Server started Tue Dec 7 12:25:27 1999: NOTICE: SIGTERM received: stopping >From sql.cfg file # common-sql.cfg Foreground LogStdout LogDir /var/log/radius DbDir /usr/local/etc/raddb # You will probably want to change this to suit your site. <Client radiator.lanka.net> Secret xxxxxx IgnoreAcctSignature </Client> <Client DEFAULT> Secret mysecret DupInterval 0 </Client> # You can put client details in a database table # and get their details from there with something like this: <ClientListSQL> DBSource dbi:FreeTDS:database=menik2AA;host=kumudu.lanka.net;port=1433 DBUsername menik12 DBAuth menik12 </ClientListSQL> <Handler Realm=relsql> RejectHasReason RewriteUsername s/^([^@]+).*/$1/ <AuthBy SQL> DBSource dbi:FreeTDS:database=menik2AA;host=202.51.128.21;port=1433 DBUsername menik12 DBAuth menik12 AuthSelect select PASSWORD, CHECKATTR, REPLYATTR from SUBSCRIBERS where USERNAME='%n' # You may want to tailor these for your ACCOUNTING table AccountingTable ACCOUNTING AcctColumnDef USERNAME,User-Name AcctColumnDef TIME_STAMP,Timestamp,integer AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer AcctColumnDef ACCTSESSIONID,Acct-Session-Id AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause AcctColumnDef NASIDENTIFIER,NAS-Identifier AcctColumnDef NASPORT,NAS-Port,integer AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address FailureBackoffTime 30 </AuthBy> # Log accounting to the detail file in LogDir AcctLogFileName %L/detail/desql </Handler> # This will authenticate users from SUBSCRIBERS <Realm DEFAULT> <AuthBy SQL> # Adjust DBSource, DBUsername, DBAuth to suit your DB DBSource dbi:FreeTDS:database=menik2AA;host=kumudu.lanka.net;port=1433 DBUsername menik12 DBAuth menik12 # You may want to tailor these for your ACCOUNTING table AccountingTable ACCOUNTING AcctColumnDef USERNAME,User-Name AcctColumnDef TIME_STAMP,Timestamp,integer AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer AcctColumnDef ACCTSESSIONID,Acct-Session-Id AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause AcctColumnDef NASIDENTIFIER,NAS-Identifier AcctColumnDef NASPORT,NAS-Port,integer AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address </AuthBy> </Realm>
