(RADIATOR) RE: Passing Acct info to external script

[Hugh Irvine]

Hello James -

Frank is referring to the SessionDatabase SQL clause which you can  
add to your Radiator configuration file.

Radiator automatically adds and removes existing sessions to/from the  
session database in response to accounting starts and accounting stops.

You could then just run a cron job or similar to update the mail  
server list from the session database.

See section 6.8 in the Radiator 3.13 reference manual ("doc/ref.html").

You could also use a hook to write the accounting packets wherever  
you wish.

See the example hooks in "goodies/hooks.txt" in the Radiator 3.13  
distribution.

regards

Hugh


On 8 Oct 2005, at 02:12, James Nelson wrote:


> Here's the details on what I'm needing to do.  Do to circumstances  
> beyond my immediate control, I am going to have several roaming  
> dial-up users that will need to be relayed through our mail server  
> (not using any form on SMTP Auth).  Since I want to restrict email  
> relaying as much as possible, I wanted to output only a list of  
> framed-ip-addresses (and maybe whether the request is start/stop)  
> assigned so I can send that to our mail server to update its allow  
> list.  So ideally, there should only be a minute or more between  
> when the user dials up and when the mail server gets an updated  
> list.  The mail server cannot directly access the database to  
> create this list, so I was going to have Radiator hand the relevant  
> info to a custom script that will update the list as the RadAcct  
> packets come in.
>
> I have not heard of SessSQL.  A few searches on that product only  
> seem to come up with SessSQL errors on web pages and archives of  
> this list.
>
> ::James Nelson
>
>
> ---------- Original Message ----------------------------------
> From: Frank Danielson <fdanielson at csky.com>
> Date:  Fri, 7 Oct 2005 18:30:08 -0400
>
>
>
>> Perhaps I misunderstood what you were trying to do.
>>
>> Have you looked at SessSQL? It tracks your current sessions in a  
>> database
>> and there is a cgi script in the goodies directory that can be  
>> used to
>> display the current session information in a web page. So anytime  
>> you want
>> you could get a real time snapshot of the current sessions  
>> including the
>> assigned IP addresses.
>>
>> We use it here and it's quite handy.
>>
>> Frank Danielson
>> Infrastructure Architect
>>
>> ClearSky Mobile Media
>> 56 E. Pine St.
>> Orlando, FL 32801
>> USA
>>
>> fdanielson at csky.com
>>
>> -----Original Message-----
>> From: James Nelson [mailto:radiator at isleofatlantis.net]
>> Sent: Friday, October 07, 2005 6:26 PM
>> To: radiator at open.com.au; Frank Danielson
>> Subject: RE: Passing Acct info to external script
>>
>>
>> I am currently using AuthBy SQL for authentication, and  
>> AcctInsertQuery to
>> add all the relevant data to a database.  However, I was hoping to  
>> get
>> Radiator to update another list to make sure it is updated on a  
>> real-time
>> basis without having to crawl the data on a recurring basis just  
>> to come up
>> with any changes since its last run.  It would probably work, but  
>> would be
>> rather inefficient.
>>
>> ::James Nelson
>>
>> ---------- Original Message ----------------------------------
>> From: Frank Danielson <fdanielson at csky.com>
>> Date:  Fri, 7 Oct 2005 15:15:48 -0400
>>
>>
>>
>>> How about using an AuthBy SQL to log the accounting data to a  
>>> database and
>>> then you can run any kind of queries you want on the data?
>>>
>>> -----Original Message-----
>>> From: James Nelson [mailto:radiator at isleofatlantis.net]
>>> Sent: Friday, October 07, 2005 2:50 PM
>>> To: radiator at open.com.au
>>> Subject: (RADIATOR) Passing Acct info to external script
>>>
>>>
>>> I am needing a way temporarily to be able to tell, in real-time,  
>>> all the
>>>
>>>
>> IPs
>>
>>
>>> that our dial up customers are receiving.  Since we are not in  
>>> direct
>>> control of the NASs I figured the best way to do this was to get  
>>> our Radius
>>> server to dump the Framed-IP-Address (and possibly whether it is a
>>> start/stop packet) in the RadAcct packet to an external program that
>>>
>>>
>> handles
>>
>>
>>> building the list.  From what I've researched, I should be able  
>>> to use one
>>> of the hooks and write a perl script to call my external prog  
>>> with the
>>> system() function.  However, I'm not sure which hook I should  
>>> use, or how
>>>
>>>
>> to
>>
>>
>>> pass it the framed-ip-address attribute.  Any suggestions?
>>>
>>> Thanks,
>>> ::James Nelson
>>>
>>>
>>>
>>>
>>> ________________________________________________________________
>>> Sent via the WebMail system at isleofatlantis.net
>>>
>>>
>>>
>>>
>>>
>>> --
>>> 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.
>>>
>>> --
>>> 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.
>>>
>>>
>>>
>>
>>
>>
>>
>>
>> ________________________________________________________________
>> Sent via the WebMail system at isleofatlantis.net
>>
>>
>>
>>
>>
>>
>>
>
>
>
>
>
> ________________________________________________________________
> Sent via the WebMail system at isleofatlantis.net
>
>
>
>
>
> --
> 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.
>
>


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?

-- 
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.