<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Hello all,<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I encountered a strange problem while editing “users”
file.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I have Freeradius 2.0.5 and MS SQL working together. When a
request coming in, Freeradius forwards it to MS SQL for authentication of
username and password, and Freeradius reads Group Name attribute saved in MS
SQL. My goal is to have each username associated to a Group Name. Then based on
Group Name, Freeradius decides what IP pool to use, and choose the proper
Pool-Name attribute. <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>So in “users” file, I created the following: <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>DEFAULT Group := "doctor", Pool-Name :=
"julienne"-----------------line133<o:p></o:p></p>
<p class=MsoNormal> Group := "dentist",
Pool-Name := "netplus"-----------------line134<o:p></o:p></p>
<p class=MsoNormal> Group := "staff", Pool-Name
:= "staffnet"-------------------line135<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>When I execute Freeradius, I got the following error:<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>/usr/local/etc/raddb/users[135]: Syntax error: Previous line
is missing a trailing comma for entry DEFAULT<o:p></o:p></p>
<p class=MsoNormal>root@Server1:/usr/local/etc/raddb# Errors reading
/usr/local/etc/raddb/users<o:p></o:p></p>
<p class=MsoNormal>/usr/local/etc/raddb/radiusd.conf[1085]: Instantiation
failed for module "files"<o:p></o:p></p>
<p class=MsoNormal>/usr/local/etc/raddb/sites-enabled/inner-tunnel[111]: Failed
to find module "files".<o:p></o:p></p>
<p class=MsoNormal>/usr/local/etc/raddb/sites-enabled/inner-tunnel[34]: Errors
parsing authorize section.<o:p></o:p></p>
<p class=MsoNormal> }<o:p></o:p></p>
<p class=MsoNormal>}<o:p></o:p></p>
<p class=MsoNormal>Errors initializing modules<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>It seems we need a comma at the end of the line which is not
right for check items. So instead of doing that, I changed the sentenses to the
following, in “users” file:<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>DEFAULT Group := "doctor", Pool-Name :=
"julienne"<o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal>DEFAULT Group := "dentist", Pool-Name :=
"netplus"<o:p></o:p></p>
<p class=MsoNormal> Group := "staff", Pool-Name
:= "staffnet"<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>This time everything works just fine. I successfully execute
Freeradius, and for every user in either of the three groups, Freeradius uses
proper Pool-Name to fine IP pool, and user gets a proper IP address falling into
that pool.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>So can anyone shed some lights on this? Why it returns two
results after I do that change? Seems DEFAULT can only have two lines?<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Thanks in advance<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>XJ<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</body>
</html>