(RADIATOR) MSSQL Auth problem but accounting okay

[S.K.D. Lakmin Premnath]

Hi Hugh,

Sorry for previous mail in HTML format because of my eudora mail client. I
have attached this in text file. 
pls read and help me. to connect solaris to MSSQL server.
thanks

lakmin





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 got that FreeTDS from     
ftp://freetds.internetcds.com/pub/freetds_dbd/freetds_dbd.snapshot.tgz
thankx for it 

but it gives following errors
can someone help me to overcome this type of situation.....?????? 

Thankx all for helping earlier situations.
lakmin

all usernames and passwords are arbitary for secrity resons


relay.lanka.net# radpwtst -user noc1@relsql -password noc1
sending Access-Request...
Rejected
sending Accounting-Request Start...
OK
sending Accounting-Request Stop...
OK
relay.lanka.net#         



sample cfg file


Foreground 
LogStdout 
LogDir /var/log/radius 
DbDir /usr/local/etc/raddb 
Trace 4
# You will probably want to change this to suit your site. 
<Client radiator.lanka.net> 
Secret annex 
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: 
<Handler Realm=relsql> 
RejectHasReason 
RewriteUsername s/^([^@]+).*/$1/ 
<AuthBy SQL> 
DBSource dbi:FreeTDS:database=icarddb;host=matri.lanka.net;port=1433 
DBUsername menik21 
DBAuth menik21 
# auth start from here 
AuthSelect select PASSWORD from SUBSCRIBERS where USERNAME='%n' 
# 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/relsql 
</Handler> 
# This will authenticate users from SUBSCRIBERS 
<Realm DEFAULT> 
<AuthBy SQL> 
# Adjust DBSource, DBUsername, DBAuth to suit your DB 
# DBSource dbi:mysql:radius 
DBSource dbi:FreeTDS:database=icarddb;host=matri.lanka.net;port=1433 
DBUsername menik21 
DBAuth menik21 
AuthSelect select PASSWORD from SUBSCRIBERS where USERNAME='%n' 
# 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 
</AuthBy> 
<AuthBy FILE> 
# Filename %D/users 
</AuthBy> 
# Log accounting to the detail file in LogDir 
AcctLogFileName %L/detail-%m 
</Realm>
<Log FILE> 
# You can use special formatting characters 
Filename %L/mylog 
# Trace level to use (allows same values as the global Trace level) 
Trace 4 
</Log> 





logfile output
--------------------------------------------

Tue Dec 14 17:40:19 1999: NOTICE: SIGHUP received: restarting
Tue Dec 14 17:40:19 1999: DEBUG: Reading users file /usr/local/etc/raddb/users
Tue Dec 14 17:40:19 1999: INFO: Server started



Tue Dec 14 17:41:26 1999: DEBUG: Packet dump:
*** Received from 127.0.0.1 port 34262 ....
Code:       Access-Request
Identifier: 161
Authentic:  1234567890123456
Attributes:
        User-Name = "noc1@relsql"
        Service-Type = Framed-User
        NAS-IP-Address = 203.63.154.1
        NAS-Port = 1234
        NAS-Port-Type = Async
        User-Password = "<151><228><<156><175>\<4><246><188>8<9><160><216>}x<153
>"

Tue Dec 14 17:41:26 1999: DEBUG: Handling request with Handler 'Realm=DEFAULT'
Tue Dec 14 17:41:26 1999: DEBUG: Deleting session for noc1@relsql, 203.63.154.1,
 1234
Tue Dec 14 17:41:26 1999: DEBUG: Handling with Radius::AuthSQL
Tue Dec 14 17:41:26 1999: ERR: Could not connect to SQL database with DBI->conne
ct dbi:FreeTDS:database=icarddb;host=matrix.lanka.net;port=1433, menik2, menik2:

Tue Dec 14 17:41:26 1999: ERR: Could not connect to any SQL database. Request is
 ignored. Backing off for 600 seconds
Tue Dec 14 17:41:26 1999: DEBUG: Handling with Radius::AuthFILE
Tue Dec 14 17:41:26 1999: DEBUG: Radius::AuthFILE looks for match with noc1@rels
ql
Tue Dec 14 17:41:26 1999: INFO: Access rejected for noc1@relsql: No such user
Tue Dec 14 17:41:26 1999: DEBUG: Packet dump:
*** Sending to 127.0.0.1 port 34262 ....         
Code:       Access-Reject
Identifier: 161
Authentic:  1234567890123456
Attributes:
        Reply-Message = "Request Denied"

Tue Dec 14 17:41:27 1999: DEBUG: Packet dump:
*** Received from 127.0.0.1 port 34262 ....
Code:       Accounting-Request
Identifier: 162
Authentic:  <208>&<238><149>uO<3><189><134><240>wA<128>^L<213>
Attributes:
        User-Name = "noc1@relsql"
        Service-Type = Framed-User
        NAS-IP-Address = 203.63.154.1
        NAS-Port = 1234
        NAS-Port-Type = Async
        Acct-Session-Id = "00001234"
        Acct-Status-Type = Start

Tue Dec 14 17:41:27 1999: DEBUG: Handling request with Handler 'Realm=DEFAULT'
Tue Dec 14 17:41:27 1999: DEBUG: Adding session for noc1@relsql, 203.63.154.1, 1
234
Tue Dec 14 17:41:27 1999: DEBUG: Handling with Radius::AuthSQL
Tue Dec 14 17:41:27 1999: DEBUG: Handling with Radius::AuthFILE
Tue Dec 14 17:41:27 1999: DEBUG: Accounting accepted
Tue Dec 14 17:41:27 1999: DEBUG: Packet dump:
*** Sending to 127.0.0.1 port 34262 ....
Code:       Accounting-Response
Identifier: 162
Authentic:  <208>&<238><149>uO<3><189><134><240>wA<128>^L<213>
Attributes:                                          
Tue Dec 14 17:41:27 1999: DEBUG: Packet dump:
*** Received from 127.0.0.1 port 34262 ....
Code:       Accounting-Request
Identifier: 163
Authentic:  <240><27><3><233>u<251><220>|<203>^Bt<251>#<134>
Attributes:
        User-Name = "noc1@relsql"
        Service-Type = Framed-User
        NAS-IP-Address = 203.63.154.1
        NAS-Port = 1234
        NAS-Port-Type = Async
        Acct-Session-Id = "00001234"
        Acct-Status-Type = Stop
        Acct-Delay-Time = 0
        Acct-Session-Time = 1000
        Acct-Input-Octets = 20000
        Acct-Output-Octets = 30000

Tue Dec 14 17:41:27 1999: DEBUG: Handling request with Handler 'Realm=DEFAULT'
Tue Dec 14 17:41:27 1999: DEBUG: Deleting session for noc1@relsql, 203.63.154.1,
 1234
Tue Dec 14 17:41:27 1999: DEBUG: Handling with Radius::AuthSQL
Tue Dec 14 17:41:27 1999: DEBUG: Handling with Radius::AuthFILE
Tue Dec 14 17:41:27 1999: DEBUG: Accounting accepted
Tue Dec 14 17:41:27 1999: DEBUG: Packet dump:
*** Sending to 127.0.0.1 port 34262 ....
Code:       Accounting-Response
Identifier: 163
Authentic:  <240><27><3><233>u<251><220>|<203>^Bt<251>#<134>
Attributes:
                                            

================================================
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]

=================================================

• Previous message
• View by thread
• View by date
• Next message

• (RADIATOR) Re: MSSQL Auth problem but accounting ok... S.K.D. Lakmin Premnath
• • (RADIATOR) Re: MSSQL Auth problem but accounti... Hugh Irvine

Reply via email to