(RADIATOR)

[Internet Telecartagena]

Hello, I wonder if you can help me a couple Radiator configuration problems.

1. It seem that Radiator is disconecting users ( dial-up), the disconection cause appears NULL. This doesn't happen to all of our users, only to some. Some of them are disconnected right away and some are disconected over and over again after short periods of time.
2. We are authenticating from 2 Ascend Max 4000 RAS. One of them is reporting fine to the data base but the other isn't reporting at all. the error that appears is BAD AUTHENTICATION IN REQUEST FROM ( our RAS's IP adress).


Our Radiator is hosted on a server running on NT, is authenticating with SQL server and our RAS are 2 Ascend Max 4000.
************************************************************************************************************************************************
THIS IS OUR CONFIGURATION FILE

<Client X.X.X.X>
 Secret xxxx

</Client>

<Client X.X.X.X>

 Secret xxxxx

 </Client>

<Realm DEFAULT>

<AuthBy SQL>
  
  DBSource dbi:ODBC:radius
  DBUsername xxxx
  DBAuth  xxxxx
 
  NoDefaultIfFound
  

  AccountingStopsOnly  

  AuthSelect select PASSWORD from SUBSCRIBERS where USERNAME='%n'

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 NASIDENTIFIERIP,NAS-IP-Address
  AcctColumnDef NASPORT,NAS-Port,integer
  AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
  AcctColumnDef CALLER_ID, Calling-Station-Id


  <SessionDatabase SQL>

 DBSource dbi:ODBC:radius
 DBUsername xxx
 DBAuth  xxxxxx

AddQuery insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT, \
 ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, NASPORTTYPE, \
 SERVICETYPE) values ('%u', '%N', 0%{NAS-Port}, '%{Acct-Session-Id}', \
 '%{Timestamp}', '%{Framed-IP-Address}', '%{NAS-Port-Type}', \
 '%{Service-Type}')

 DeleteQuery delete from RADONLINE where NASIDENTIFIER='%0' and NASPORT=0%2

 ClearNasQuery delete from RADONLINE where NASIDENTIFIER='%N'

 CountQuery select NASIDENTIFIER, NASPORT, ACCTSESSIONID from RADONLINE where  USERNAME='%u'

  </SessionDatabase SQL>

<Log SQL>
 DBSource dbi:ODBC:radius
 DBUsername xxx
 DBAuth  xxxxx

 # Trace level to use (allows same values as the global Trace level)
 Trace 4
</Log>
**************************************************************************************************************************************************************************************

OUR RADLOG

Bad authenticator in request from X.X.X.X
Handling request with Handler Realm=DEFAULT'      
 Deleting session for dovbs-RAS1                                                                                                                                                                                                      
 do query is: delete from RADONLINE where NASIDENTIFIER='%0' and NASPORT=0%2
Handling with Radius::AuthSQL                                                                                                                                                                                                                                              Handling with Radius::AuthSQL                                                                                                                                                                                                                                   Query is: select PASSWORD from SUBSCRIBERS where USERNAME='dovbs-RAS1-1'
Radius::AuthSQL looks for match with dovbs-RAS1-1                                                                                                                                                                                                               
Query is: select PASSWORD from SUBSCRIBERS where USERNAME='DEFAULT'
                                                                                                                                                                          
 Access rejected for dovbs-RAS1-1: No such user                                                                                                                                                                                                                  
1003870672  4           Handling request with Handler 'Realm=DEFAULT'                                                                                                                                                                                                                   
 Deleting session for route-RAS1-1, X.X.X.X,                                                                                                                                                                                                             
do query is: delete from RADONLINE where NASIDENTIFIER='%0' and NASPORT=0%2
                                                                                                                                                                                    
Handling with Radius::AuthSQL                                                                                                                                                                                                                                   
1003870672  4           Handling with Radius::AuthSQL                                                                                                                                                                                                                                   
1003870999  1           Bad authenticator in request from X.X.X.X
                              Accounting accepted                                                                                                                                                                                                                                             
1003870971  1           Bad authenticator in request from X.X.X.X     
**********************************************************************************************************                                                                                                                                                                                              

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20011023/c8057282/attachment.html>