(RADIATOR) RE: Passing Acct info to external script

[James Nelson]

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.