<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>
Hi Alan,<BR>
<BR>
How do I create conditional statement to uniquely identify differenent NAS vendors to use its sql.conf ? Is it something like<BR>
<BR>
if ( NAS-IP-Address = "cisco's IP address" )<BR>
<BR>
$INCLUDE ${confdir}/sql1.conf<BR>
<BR>
<BR>
else ( NAS-IP-Address = "Asterisk's IP address" )<BR>
<BR>
$INCLUDE ${confdire}/sql2.conf <BR>
<BR>
in the "radiusd.conf" file ?<BR>
<BR>
thanks,<BR>
<BR><BR>> Date: Sat, 9 Aug 2008 10:45:10 +0200<BR>> From: aland@deployingradius.com<BR>> To: freeradius-users@lists.freeradius.org<BR>> Subject: Re: Multiple NAS<BR>> <BR>> Rana Dhekial wrote:<BR>> > So the idea is to create multiple tables in the database where<BR>> > Freeradius is writing and store Cisco's accounting info to say<BR>> > radacct_1, Asterisk's to radacct_2, OpenSER's to radacct_3 tables.<BR>> <BR>> You can update the table name on the fly. In 2.0.5, set<BR>> SQL-Table-Name, and then edit the SQL queries to replace the references<BR>> to ${acct_table} with %{%{SQL-Table-Name}:-${acct_table}}<BR>> <BR>> Alan DeKok.<BR>> -<BR>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html<BR><BR><br /><hr />Got Game? Win Prizes in the Windows Live Hotmail Mobile Summer Games Trivia Contest <a href='http://www.gowindowslive.com/summergames?ocid=TXT_TAGHM' target='_new'>Find out how.</a></body>
</html>