(RADIATOR) Re: Calling-Station-Id and Called-Station-Id
deden purnamahadi
dedenph at hotmail.com
Wed Mar 10 03:33:21 CST 2004
This is the new AuthBy which run correctly on Postgres :
AcctColumnDef time_stamp,Timestamp,formatted-date,'%Y-%m-%e %H:%M:%S'
Warmest regards
ddn
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: (RADIATOR) 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.
>
>--
>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.
_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8.
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