(RADIATOR) Re: Calling-Station-Id and Called-Station-Id

deden purnamahadi dedenph at hotmail.com
Wed Mar 10 03:08:18 CST 2004


Radiator puts a space for one digit day-date, it makes Postgres to represent 
it as year '0003'

do query is: 'insert into accounting (acctdelaytime,acctinputocte
ts,acctoutputoctets,acctsessionid,acctsessiontime,acctstatustype,acctterminatecause,frameipaddress
,nasport,time_stamp,username) values 
(0,30497,149342,'0500004D',1486,'Stop','Lost-Carrier','202.80
.208.51',13,to_timestamp (' 8 03 2004 16:01:42', 'DD MM YYYY 
HH24:MI:SS'),'ana_aja')':

Instead 08, Radiator puts -space-8.


Warmest regards


ddn





>From: Hugh Irvine <hugh at open.com.au>
>To: "deden purnamahadi" <dedenph at hotmail.com>
>CC: radiator at open.com.au
>Subject: Re: Calling-Station-Id and Called-Station-Id
>Date: Wed, 10 Mar 2004 17:22:33 +1100
>
>
>Hello Deden -
>
>You will need to check your database logs and your database  documentation.
>
>regards
>
>Hugh
>
>
>On 9 Mar 2004, at 21:33, deden purnamahadi wrote:
>
>>Ok. Hugh. Thx.
>>I've asked my vendor about that.
>>
>>Another problem just came up, and I don't know why.
>>Radiator worked fine when inserting the login-logout time, until we  found 
>>out that it inserted wrong date these few days
>>
>>do query is: 'insert into accounting  
>>(acctdelaytime,acctinputoctets,acctoutputoctets,acctsessionid,acctsessi 
>>ontime,acctstatustype,acctterminatecause,frameipaddress,nasport,time_st 
>>amp,username) values  (0,105808,830772,'0500006C',3391,'Stop','User- 
>>Request','202.80.208.53',9,to_timestamp (' 9 03 2004 17:18:59', 'DD MM  
>>YYYY HH24:MI:SS'),'popiesav')'
>>
>>In the database it put '0003' as the YEAR. ???
>>
>>
>>can u help me ??
>>
>>
>>-ddn-
>>
>>
>>
>>
>>
>>Warmest regards
>>
>>
>>ddn
>>
>>
>>Ok.
>>
>>
>>>From: Hugh Irvine <hugh at open.com.au>
>>>To: "deden purnamahadi" <dedenph at hotmail.com>
>>>CC: radiator at open.com.au
>>>Subject: Re: Calling-Station-Id and Called-Station-Id
>>>Date: Tue, 9 Mar 2004 09:11:43 +1100
>>>
>>>
>>>Hello Deden -
>>>
>>>Thanks for sending the configuration and the debug log.
>>>
>>>The log shows that there is no Called-Station-Id or  Calling-Station-Id  
>>>in the radius request received by Radiator,  therefore there is nothing  
>>>to put in the database. You will need to  check with your vendor to see  
>>>how to configure the NAS to send these  attributes.
>>>
>>>>
>>>>Mon Mar  8 16:01:42 2004: DEBUG: Packet dump:
>>>>*** Received from 202.80.208.4 port 1026 ....
>>>>Code:       Accounting-Request
>>>>Identifier: 32
>>>>Authentic:    
>>>><223><19><25><214>.<22><190><143><244><210><160>J<138><127><192>{
>>>>Attributes:
>>>>        Acct-Session-Id = "0500004D"
>>>>        User-Name = "ana_aja"
>>>>        NAS-IP-Address = xxx
>>>>        NAS-Port = 13
>>>>        NAS-Port-Type = Async
>>>>        Acct-Status-Type = Stop
>>>>        Acct-Session-Time = 1486
>>>>        Acct-Authentic = RADIUS
>>>>        Acct-Input-Octets = 30497
>>>>        Acct-Output-Octets = 149342
>>>>        Acct-Terminate-Cause = Lost-Carrier
>>>>        Service-Type = Framed-User
>>>>        Framed-Protocol = PPP
>>>>        Framed-IP-Address = xxx
>>>>        Acct-Delay-Time = 0
>>>
>>>
>>>regards
>>>
>>>Hugh
>>>
>>>
>>>On 8 Mar 2004, at 21:13, deden purnamahadi wrote:
>>>
>>>>I tried to configure Radiator to log caller number and dialled  number  
>>>>(based on mailing list archive). It didn't work.
>>>>Attached is the conf file and log file.
>>>>Anyone can help ?
>>>>
>>>>
>>>>_ddn__
>>>>
>>>>
>>>># topnet_radius.cfg
>>>>
>>>>Foreground
>>>>LogStdout
>>>>LogDir          /usr/local/src/Radiator-3.7/log
>>>>DbDir           .
>>>>#DbDir          /usr/local/srd/Radiator-3.7/raddb
>>>>AuthPort        1645
>>>>AcctPort        1646
>>>>Trace           4
>>>>
>>>># You will probably want to add other Clients to suit your site.
>>>><Client xxxx>
>>>>        Secret  xxxx
>>>>        AddToRequest %{Class}
>>>>        DupInterval 0
>>>>        NasType livingston
>>>></Client>
>>>>
>>>><Realm DEFAULT>
>>>>        AuthByPolicy    ContinueAlways
>>>>        RewriteUsername s/^([^@]+).*/$1/
>>>>#       AcctLogFileName %L/details
>>>>
>>>>
>>>><AuthBy SQL>
>>>>#do the accounting but not authentication
>>>>        AuthSelect
>>>>        DBSource        dbi:Pg:dbname=radiator;host=z.z.z.z.
>>>>        DBUsername      post
>>>>        DBAuth          post
>>>>        AccountingTable accounting
>>>>        AcctColumnDef   username,User-Name
>>>>        AcctColumnDef     
>>>>time_stamp,Timestamp,formatted-date,to_timestamp \
>>>>        ('%e %m %Y %H:%M:%S', 'DD MM YYYY HH24:MI:SS')
>>>>        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   nasport,NAS-Port,integer
>>>>        AcctColumnDef   frameipaddress,Framed-IP-Address
>>>>        AcctColumnDef   userrequest,User-Request
>>>>        AcctColumnDef   callingid,Calling-Station-Id
>>>>        AcctColumnDef   calledid,Called-Station-Id
>>>>        AcctFailedLogFileName %D/missedaccounting
>>>>
>>>></AuthBy>
>>>>
>>>>
>>>><AuthBy LDAP2>
>>>>#do the authentication only
>>>>                NoDefault
>>>>                Version         3
>>>>                Host            mail
>>>>                Port            389
>>>>                AuthDN          cn=root,o=isp,c=ID
>>>>                AuthPassword    secret
>>>>                BaseDN          o=isp,c=ID
>>>>                UsernameAttr    uid
>>>>                PasswordAttr    userPassword
>>>>                #AuthAttrDef    servicetype,Service-Type,check
>>>>                #AuthAttrDef    address,Frame-IP-Address,reply
>>>>                AddToReply      Framed-Protocol = PPP,\
>>>>                      Framed-IP-Netmask = 255.255.255.255,\
>>>>                      Framed-Routing = None,\
>>>>                      Framed-MTU = 1500,\
>>>>                      Framed-Compression = Van-Jacobson-TCP-IP
>>>>                AddToReply Class = "Calling-Station-Id =   
>>>>%{Calling-Station-Id},\
>>>>                                        Called-Station-Id =   
>>>>%{Called-Station-Id}"
>>>>
>>>></AuthBy>
>>>>
>>>>
>>>></Realm>
>>>>
>>>>Logfile
>>>>
>>>>Mon Mar  8 16:01:42 2004: DEBUG: Packet dump:
>>>>*** Received from 202.80.208.4 port 1026 ....
>>>>Code:       Accounting-Request
>>>>Identifier: 32
>>>>Authentic:    
>>>><223><19><25><214>.<22><190><143><244><210><160>J<138><127><192>{
>>>>Attributes:
>>>>        Acct-Session-Id = "0500004D"
>>>>        User-Name = "ana_aja"
>>>>        NAS-IP-Address = xxx
>>>>        NAS-Port = 13
>>>>        NAS-Port-Type = Async
>>>>        Acct-Status-Type = Stop
>>>>        Acct-Session-Time = 1486
>>>>        Acct-Authentic = RADIUS
>>>>        Acct-Input-Octets = 30497
>>>>        Acct-Output-Octets = 149342
>>>>        Acct-Terminate-Cause = Lost-Carrier
>>>>        Service-Type = Framed-User
>>>>        Framed-Protocol = PPP
>>>>        Framed-IP-Address = xxx
>>>>        Acct-Delay-Time = 0
>>>>
>>>>Mon Mar  8 16:01:42 2004: DEBUG: Handling request with Handler   
>>>>'Realm=DEFAULT'
>>>>Mon Mar  8 16:01:42 2004: DEBUG: Rewrote user name to ana_aja
>>>>Mon Mar  8 16:01:42 2004: DEBUG:  Deleting session for ana_aja, xxx,  13
>>>>Mon Mar  8 16:01:42 2004: DEBUG: Handling with Radius::AuthSQL
>>>>Mon Mar  8 16:01:42 2004: DEBUG: Handling accounting with   
>>>>Radius::AuthSQL
>>>>Mon Mar  8 16:01:42 2004: DEBUG: do query is: 'insert into  accounting  
>>>>(acctdelaytime,acctinputoctets,acctoutputoctets,acctsess
>>>>ionid,acctsessiontime,acctstatustype,acctterminatecause,frameipaddres s, 
>>>>nasport,time_stamp,username) values (0,30497,149342,'05
>>>>00004D',1486,'Stop','Lost-Carrier','xxx',13,to_timestamp (' 8 03  2004  
>>>>16:01:42', 'DD MM YYYY HH24:MI:SS'),'ana_aja')
>>>>':
>>>>
>>>>Mon Mar  8 16:01:42 2004: DEBUG: Handling with Radius::AuthLDAP2:
>>>>Mon Mar  8 16:01:42 2004: DEBUG: Accounting accepted
>>>>Mon Mar  8 16:01:42 2004: DEBUG: Packet dump:
>>>>*** Sending to 202.80.208.4 port 1026 ....
>>>>Code:       Accounting-Response
>>>>Identifier: 32
>>>>Authentic:    
>>>><223><19><25><214>.<22><190><143><244><210><160>J<138><127><192>{
>>>>Attributes:
>>>>
>>>>Code:       Access-Request
>>>>Identifier: 33
>>>>Authentic:  <131><220>y<234><18>a<132><5><19>H<207>GS#^<8>
>>>>Attributes:
>>>>        User-Name = "ana_aja"
>>>>        User-Password =  "<203><153><237>e<218><1><243><192>^p<28><179>  
>>>>w?<211>"
>>>>        NAS-IP-Address = xxxx
>>>>        NAS-Port = 18
>>>>        NAS-Port-Type = Async
>>>>        Service-Type = Framed-User
>>>>        Framed-Protocol = PPP
>>>>
>>>>Mon Mar  8 16:11:12 2004: DEBUG: Handling request with Handler   
>>>>'Realm=DEFAULT'
>>>>Mon Mar  8 16:11:12 2004: DEBUG: Rewrote user name to ana_aja
>>>>Mon Mar  8 16:11:12 2004: DEBUG:  Deleting session for ana_aja, xxx,  18
>>>>Mon Mar  8 16:11:12 2004: DEBUG: Handling with Radius::AuthSQL
>>>>Mon Mar  8 16:11:12 2004: DEBUG: Handling with Radius::AuthLDAP2:
>>>>Mon Mar  8 16:11:12 2004: INFO: Connecting to mail, port 389
>>>>Mon Mar  8 16:11:12 2004: INFO: Attempting to bind to LDAP server   
>>>>mail:389)
>>>>Mon Mar  8 16:11:12 2004: DEBUG: LDAP got result for   
>>>>uid=ana_aja,ou=isp,o=xxx,c=ID
>>>>Mon Mar  8 16:11:12 2004: DEBUG: LDAP got userPassword:   
>>>>{MD5}QcI2qxZUi8WZFRn+OliKWg==
>>>>Mon Mar  8 16:11:12 2004: DEBUG: Radius::AuthLDAP2 looks for match   
>>>>with ana_aja
>>>>Mon Mar  8 16:11:12 2004: DEBUG: Radius::AuthLDAP2 ACCEPT:
>>>>Mon Mar  8 16:11:12 2004: ERR: Bad attribute=value pair:   
>>>>Framed-Protocol = PPP,Framed-IP-Netmask =  255.255.255.255,Framed-Rout
>>>>ing = None,Framed-MTU = 1500,Framed-Compression = Van-Jacobson-TCP-IP
>>>>Mon Mar  8 16:11:12 2004: DEBUG: Access accepted for ana_aja
>>>>Mon Mar  8 16:11:12 2004: DEBUG: Packet dump:
>>>>*** Sending to 202.80.208.4 port 1026 ....
>>>>Code:       Access-Accept
>>>>Identifier: 33
>>>>Authentic:  <131><220>y<234><18>a<132><5><19>H<207>GS#^<8>
>>>>Attributes:
>>>>
>>>>_________________________________________________________________
>>>>Help STOP SPAM with the new MSN 8 and get 2 months FREE*    
>>>>http://join.msn.com/?page=features/junkmail
>>>>
>>>>
>>>
>>>NB: have you included a copy of your configuration file (no secrets),
>>>together with a trace 4 debug showing what is happening?
>>>
>>>--
>>>Radiator: the most portable, flexible and configurable RADIUS server
>>>anywhere. Available on *NIX, *BSD, Windows, MacOS X.
>>>-
>>>Nets: internetwork inventory and management - graphical, extensible,
>>>flexible with hardware, software, platform and database independence.
>>>-
>>>CATool: Private Certificate Authority for Unix and Unix-like systems.
>>>
>>
>>_________________________________________________________________
>>Add photos to your e-mail with MSN 8. Get 2 months FREE*.  
>>http://join.msn.com/?page=features/featuredemail
>>
>>
>
>NB: have you included a copy of your configuration file (no secrets),
>together with a trace 4 debug showing what is happening?
>
>--
>Radiator: the most portable, flexible and configurable RADIUS server
>anywhere. Available on *NIX, *BSD, Windows, MacOS X.
>-
>Nets: internetwork inventory and management - graphical, extensible,
>flexible with hardware, software, platform and database independence.
>-
>CATool: Private Certificate Authority for Unix and Unix-like systems.
>

_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE* 
http://join.msn.com/?page=features/junkmail

--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.


More information about the radiator mailing list