(RADIATOR) Logging multiple Framed-Route's

[Hugh Irvine]

Hello Jim -

I suggest not using the AcctLogFileFormat specifiaction so you get  
the entire accounting record in the accounting file. You can then  
parse it however you need to to insert it into the database.

Otherwise you can use a hook to manipulate the accounting attributes.  
There are a number of example hooks in "goodies/hooks.txt".

regards

Hugh


On 12 Jun 2008, at 22:27, Jim Tyrrell wrote:

> Hi,
>
> We have Radiator logging all accounting records to a text file in  
> CSV format which is then inserted into a MySQL database by a  
> separate script.  We are changing a few things which means users  
> can have multiple Framed-Route’s, and our LNS will also become an  
> LTS which means multiple Tunnel-Server-Endpoint & Tunnel-Client- 
> Endpoint.
>
> The authentication works fine, however, when it comes to accounting  
> log we only get the 1st instance of this attribute in the text file  
> and so into our MySQL database.  How do we handle this so we can  
> log additional occurances of these attributes?
>
> ====   Example log format  ====
> AcctLogFileFormat "%{User-Name}",%{Timestamp},"%{Acct-Session- 
> Id}","%{Framed-IP-Address}",\
> "%{Framed-IP-Netmask}","%{Framed-Route}","%{Tunnel-Client- 
> Endpoint}","%{Tunnel-Server-Endpoint}"
>
>
> ====  The Radius accounding debug shows something such as  ====
> Code:       Accounting-Request
> Attributes:
>         User-Name = "user_a"
>         Acct-Status-Type = Start
>         Acct-Session-Id = "FF10FFFF583B572A-4850EE4C"
>         Framed-Route = "192.168.0.0/30 10.0.0.1"
>         Framed-Route = "192.168.1.0/29 10.0.0.1"
>         Framed-IP-Address = 10.0.0.1
>         Framed-IP-Netmask = 255.255.255.255
>
>
> Code:       Accounting-Request
> Attributes:
>         User-Name = "user_b"
>         Acct-Status-Type = Start
>         Tunnel-Server-Endpoint = 1:10.10.10.10
>         Tunnel-Client-Endpoint = 1:192.168.20.1
>         Tunnel-Client-Endpoint = 2:192.168.20.2
>         Tunnel-Server-Endpoint = 2:172.16.1.1
>
>
> I need to either insert all occurrences of the attribute into the  
> same field with a separator, or additional occurrences need to be  
> logged to a separate field.  At present we will get the 1st  
> attribute logged into the field in the CSV and into MySQL and all  
> others will be ignored.
>
> Thanks.
>
> Jim.
>
> This email has been scanned for all viruses by the MessageLabs  
> SkyScan service.
>
> Please consider the environment before printing this email.
>
> The content of this email and any attachment is private and may be  
> privileged. If you are not the intended recipient, any use,  
> disclosure, copying or forwarding of this email and/or its  
> attachments is unauthorised. If you have received this email in  
> error please notify the sender by email and delete this message and  
> any attachments immediately. Nothing in this email shall bind the  
> Company or any of its subsidiaries or businesses in any contract or  
> obligation, unless we have specifically agreed to be bound.
>
> KCOM Group PLC is a public limited company incorporated in England  
> and Wales, company number 02150618 and whose registered office is  
> at 37 Carr Lane, Hull, HU1 3RE.
>
> 118288 - KCOM UK Directory Enquiries. Calls cost 49p connection +  
> 14p per minute including VAT from a KC or BT landline. Call charges  
> from mobiles and other networks may vary. If you are calling from a  
> mobile you will now receive your requested number via text message.  
> You will not be charged for the text message.
>
>



NB:

Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive (www.open.com.au/archives/ 
radiator)?
Have you had a quick look on Google (www.google.com)?
Have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?
Have you checked the RadiusExpert wiki:
http://www.open.com.au/wiki/index.php/Main_Page

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
Includes support for reliable RADIUS transport (RadSec),
and DIAMETER translation agent.
-
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.