(RADIATOR) To connect MSSQL 7.0 database from a UNIX BSDI through FreeTDS

Mon, 6 Dec 1999 04:53:14 -0800

hi hugh

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 packets going from UNIX server to SQL server running machine.

can someone help me to overcome this type of situation.....??????

Thankx all for helping earlier situations.
lakmin


Error shown in log file:-

Mon Dec  6 16:54:16 1999: ERR: Could not connect to SQL database with DBI->conne
ct dbi:FreeTDS:database=menik2AA;host=202.51.128.21;port=1433, menik12, menik12:
Mon Dec  6 16:54:16 1999: ERR: Could not connect to any SQL database. Request is
ignored. Backing off for 600 seconds  

Abstract from cfg file:-

<Handler Realm=chksql>
        RejectHasReason     
    <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
        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/detail-%m-%Y-meniksql
</Handler>                                                             

from mylog file:-
Mon Dec  6 18:04:40 1999: DEBUG: Handling request with Handler ''
Mon Dec  6 18:04:40 1999: DEBUG: Rewrote user name to ibox1726
Mon Dec  6 18:04:40 1999: DEBUG:  Adding session for ibox1726, 202.51.128.52, 43
Mon Dec  6 18:04:40 1999: DEBUG: Handling with Radius::AuthFILE
Mon Dec  6 18:04:40 1999: DEBUG: Accounting accepted
Mon Dec  6 18:04:42 1999: DEBUG: Check if Handler Realm=chksql should be used to
handle this request
Mon Dec  6 18:04:42 1999: DEBUG: Check if Handler User-Name=/^ic[a-z]\d{5}/ shou
ld be used to handle this request
Mon Dec  6 18:04:42 1999: DEBUG: Check if Handler  should be used to handle this
request
Mon Dec  6 18:04:42 1999: DEBUG: Handling request with Handler ''
Mon Dec  6 18:04:42 1999: DEBUG: Rewrote user name to ibox1956
Mon Dec  6 18:04:42 1999: DEBUG:  Deleting session for ibox1956, 202.51.128.54,
40
Mon Dec  6 18:04:42 1999: DEBUG: Handling with Radius::AuthFILE
Mon Dec  6 18:04:42 1999: DEBUG: Radius::AuthFILE looks for match with ibox1956
Mon Dec  6 18:04:42 1999: DEBUG: Radius::AuthFILE looks for match with DEFAULT

================================================
S.K.D. Lakmin Premnath.
(Systems Engineer)
Lanka Internet Services Limited.
( http://www.lanka.net )
Network Operating Center
No, 156 1/1 Walukarama Road,
Colombo 3,
Sri Lanka.
Tel : +94 1 565071
Fax : +94 75 335637
Email : [EMAIL PROTECTED]

=================================================
=== Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.

Reply via email to