(RADIATOR) Freeside SQL export table formats

[Hugh Irvine]

Hello Tim -

You would normally just configure Radiator to access the Freeside  
tables directly.

For authentication you use the "AuthSelect ...." in the AuthBy SQL,  
and for accounting you simply need to specify the required  
AcctColumnDef's.

There is an example configuration file in "goodies/freeside.cfg" in  
the Radiator 4.2 distribution. Note the special hook for accounting  
in "goodies/sqlradacct.pl".

regards

Hugh


On 29 May 2008, at 10:34, Tim McCullagh wrote:

> Hi all,
>
> I am trying to setup and evaluate freeside 1.7.3.  I looked at  
> couple of commercial billing systems last year, but found the  
> support to be wanting, which has encouraged me to look at Freeside.
>
> Has any one on the list successfully setup freeside to export to a  
> radiator radusers SQL table using freeside?
> When I look I cannot find a table definition for radusers in the  
> freeside ref manual or on the mailing list
> When going through the radiator.pm I can deduce that the table  
> should probably include
> USERNAME, PASS_WORD,STATICADDRESS,TIMELEFT, MAXLOGINS, SERVICENAME,  
> BADLOGINS, VALIDFROM, VALIDTO,  
> FRAMED_NETMASK,FRAMED_FILTER_ID,MAXIDLETIME which I see is close to  
> the radmin users format.  Does anyone know if this is correct?  My  
> understanding is that radiator uses a subscriber database table
>
> Can anyone on the list shed any light on what the SQL database  
> setup should be ?
>
> Can anyone shed any light on the SQL format for the radacct  table  
> as well?
>
> The only reference I can find to documentation on this is
> Real-time export of the <b>radusers</b> table to any SQL database in
> <a href="http://www.open.com.au/radiator/">Radiator</a>-native format.
> To setup accounting, see the RADIATOR documentation for hooks to  
> update
> a standard <b>radacct</b> table.
>
>
> Thanks and Regards
>
> Tim
>
> --
> 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?
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.