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>
> <div>Error shown in log file:-</div>
> <br>
> <div>Mon Dec 6 16:54:16 1999: ERR: Could not connect to SQL
> database with DBI->conne</div>
> <div>ct dbi:FreeTDS:database=menik2AA;host=202.51.128.21;port=1433,
> menik12, menik12:</div>
> <div>Mon Dec 6 16:54:16 1999: ERR: Could not connect to any SQL
> database. Request is</div>
> <div> ignored. Backing off for 600 seconds </div>
> <br>
> <div>Abstract from cfg file:-</div>
> <br>
> <div><Handler Realm=chksql></div>
> <div>
> RejectHasReason </div>
> <div> <AuthBy SQL></div>
> <div> # Adjust DBSource,
> DBUsername, DBAuth to suit your DB</div>
> <div>
> DBSource
> dbi:FreeTDS:database=menik2AA;host=kumudu.lanka.net;port=1433</div>
> <div>
> DBUsername menik12</div>
> <div>
> DBAuth
> menik12</div>
> <div> AuthSelect select
> PASSWORD, CHECKATTR, REPLYATTR from SUBSCRIBERS where</div>
> <div> USERNAME='%n'</div>
> <div> # You may want to tailor
> these for your ACCOUNTING table</div>
> <div> AccountingTable
> ACCOUNTING</div>
> <div> AcctColumnDef
> USERNAME,User-Name</div>
> <div> AcctColumnDef
> TIME_STAMP,Timestamp,integer</div>
> <div> AcctColumnDef
> ACCTSTATUSTYPE,Acct-Status-Type</div>
> <div> AcctColumnDef
> ACCTDELAYTIME,Acct-Delay-Time,integer</div>
> <div> AcctColumnDef
> ACCTINPUTOCTETS,Acct-Input-Octets,integer </div>
> <div> AcctColumnDef
> ACCTOUTPUTOCTETS,Acct-Output-Octets,integer</div>
> <div> AcctColumnDef
> ACCTSESSIONID,Acct-Session-Id</div>
> <div> AcctColumnDef
> ACCTSESSIONTIME,Acct-Session-Time,integer</div>
> <div> AcctColumnDef
> ACCTTERMINATECAUSE,Acct-Terminate-Cause</div>
> <div> AcctColumnDef
> NASIDENTIFIER,NAS-Identifier</div>
> <div> AcctColumnDef
> NASPORT,NAS-Port,integer</div>
> <div> AcctColumnDef
> FRAMEDIPADDRESS,Framed-IP-Address</div>
> <div> FailureBackoffTime
> 30</div>
> <div> </AuthBy></div>
> <div> # Log accounting to the
> detail file in LogDir</div>
> <div> AcctLogFileName
> %L/detail/detail-%m-%Y-meniksql</div>
>
><div></Handler>
> </div>
> <br>
> <div>from mylog file:-</div>
> <div>Mon Dec 6 18:04:40 1999: DEBUG: Handling request with Handler
> ''</div>
> <div>Mon Dec 6 18:04:40 1999: DEBUG: Rewrote user name to
> ibox1726</div>
> <div>Mon Dec 6 18:04:40 1999: DEBUG: Adding session for
> ibox1726, 202.51.128.52, 43</div>
> <div>Mon Dec 6 18:04:40 1999: DEBUG: Handling with
> Radius::AuthFILE</div>
> <div>Mon Dec 6 18:04:40 1999: DEBUG: Accounting accepted</div>
> <div>Mon Dec 6 18:04:42 1999: DEBUG: Check if Handler Realm=chksql
> should be used to</div>
> <div> handle this request</div>
> <div>Mon Dec 6 18:04:42 1999: DEBUG: Check if Handler
> User-Name=/^ic[a-z]\d{5}/ shou</div>
> <div>ld be used to handle this request</div>
> <div>Mon Dec 6 18:04:42 1999: DEBUG: Check if Handler should
> be used to handle this</div>
> <div> request</div>
> <div>Mon Dec 6 18:04:42 1999: DEBUG: Handling request with Handler
> ''</div>
> <div>Mon Dec 6 18:04:42 1999: DEBUG: Rewrote user name to
> ibox1956</div>
> <div>Mon Dec 6 18:04:42 1999: DEBUG: Deleting session for
> ibox1956, 202.51.128.54,</div>
> <div>40</div>
> <div>Mon Dec 6 18:04:42 1999: DEBUG: Handling with
> Radius::AuthFILE</div>
> <div>Mon Dec 6 18:04:42 1999: DEBUG: Radius::AuthFILE looks for
> match with ibox1956</div>
> <div>Mon Dec 6 18:04:42 1999: DEBUG: Radius::AuthFILE looks for
> match with DEFAULT </div>
> <BR>
>
> <div align="center">
> ================================================<br>
> S.K.D. Lakmin Premnath.<br>
> (Systems Engineer)<br>
> Lanka Internet Services Limited.<br>
> (
> <a href="http://www.lanka.net/" eudora="autourl">http://www.lanka.net</a>
> )<br>
> Network Operating Center<br>
> No, 156 1/1 Walukarama Road,<br>
> Colombo 3,<br>
> Sri Lanka.<br>
> Tel : +94 1 565071<br>
> Fax : +94 75 335637<br>
> Email : [EMAIL PROTECTED]<br>
> <br>
> =================================================<br>
> </html>
>
>
> ===
> Archive at http://www.thesite.com.au/~radiator/
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
