<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><head><title></title>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-15">
<meta http-equiv="Content-Style-Type" content="text/css">
<style type="text/css"><!--
body {
margin: 5px 5px 5px 5px;
background-color: #ffffff;
}
/* ========== Text Styles ========== */
hr { color: #000000}
body, table /* Normal text */
{
font-size: 11pt;
font-family: 'Arial';
font-style: normal;
font-weight: normal;
color: #000000;
text-decoration: none;
}
span.rvts1 /* Heading */
{
font-size: 10pt;
font-weight: bold;
color: #0000ff;
}
span.rvts2 /* Subheading */
{
font-size: 10pt;
font-weight: bold;
color: #000080;
}
span.rvts3 /* Keywords */
{
font-size: 10pt;
font-style: italic;
color: #800000;
}
a.rvts4, span.rvts4 /* Jump 1 */
{
font-size: 10pt;
color: #008000;
text-decoration: underline;
}
a.rvts5, span.rvts5 /* Jump 2 */
{
font-size: 10pt;
color: #008000;
text-decoration: underline;
}
span.rvts6
{
font-size: 8pt;
font-style: italic;
color: #c0c0c0;
}
a.rvts7, span.rvts7
{
font-size: 8pt;
color: #0000ff;
text-decoration: underline;
}
a.rvts8, span.rvts8
{
color: #0000ff;
text-decoration: underline;
}
span.rvts9
{
font-size: 13pt;
font-family: 'courier new';
}
a.rvts10, span.rvts10
{
font-size: 13pt;
font-family: 'courier new';
color: #0000ff;
text-decoration: underline;
}
/* ========== Para Styles ========== */
p,ul,ol /* Paragraph Style */
{
text-align: left;
text-indent: 0px;
padding: 0px 0px 0px 0px;
margin: 0px 0px 0px 0px;
}
.rvps1 /* Centered */
{
text-align: center;
}
--></style>
</head>
<body>
<p>Hi,</p>
<p><br></p>
<p>I am planning to develop a patch for dialupadmin so i can use radippool tablo for Rlm_sqlippool. I just wanted to be sure what to add to the GUI - dialupadmin-</p>
<p><br></p>
<p>1) There must a a new tab to add IP addresses to the radippool table. At <a class=rvts8 href="http://wiki.freeradius.org/Rlm_sqlippool">http://wiki.freeradius.org/Rlm_sqlippool</a> IP addresses are added like:</p>
<p><br></p>
<p><br></p>
<p><span class=rvts9>INSERT INTO radippool (pool_name, framedipaddress) VALUES ('main_pool', '192.168.0.1');
INSERT INTO radippool (pool_name, framedipaddress) VALUES ('main_pool', '192.168.0.2');
INSERT INTO radippool (pool_name, framedipaddress) VALUES ('main_pool', '192.168.0.3');
INSERT INTO radippool (pool_name, framedipaddress) VALUES ('main_pool', '192.168.0.4</span></p>
<p><span class=rvts9><br></span></p>
<p><span class=rvts9><br></span></p>
<p><span class=rvts9>2) The code must edit radgroupcheck table (Not radgroupreply since it is a control attribute not a reply attribute) to add the group to the related pool (for example main_pool) just like in</span></p>
<p><span class=rvts9><br></span></p>
<p><span class=rvts9><br></span></p>
<p><a class=rvts10 href="http://lists.cistron.nl/pipermail/freeradius-users/2006-October/057508.html">http://lists.cistron.nl/pipermail/freeradius-users/2006-October/057508.html</a></p>
<p><span class=rvts9><br></span></p>
<p><span class=rvts9>Is there any additional steps that needs to be implemented? </span></p>
<p><span class=rvts9><br></span></p>
<p><span class=rvts9><br></span></p>
<p><span class=rvts9>BTW am I right about radgroupcheck is used for Control Attributes but radgroupreply is used for reply attributes?</span></p>
<p><span class=rvts9><br></span></p>
<p><span class=rvts9></span>
<br><span class=rvts9>Best Regards.</span></p>
<p><br></p>
<p><br></p>
<p><br></p>
<p> </p>
<p><br></p>
<p><span class=rvts6>-- </span></p>
<p><span class=rvts6>Best regards,</span></p>
<p><span class=rvts6> Omer </span><a class=rvts7 href="mailto:omer@faruk.net">mailto:omer@faruk.net</a></p>
</body></html>