-<html>\r
-<head>\r
-<title>Framed-Id Help Page</title>\r
-<link rel="stylesheet" href="../style.css">\r
-</head>\r
-<body bgcolor="#80a040" background="../images/greenlines1.gif" link="black" alink="black">\r
-<center>\r
-<table border=0 width=540 cellpadding=1 cellspacing=1>\r
-<tr valign=top>\r
-<td width=340></td>\r
-<td bgcolor="black" width=400>\r
- <table border=0 width=100% cellpadding=2 cellspacing=0>\r
- <tr bgcolor="#907030" align=right valign=top><th><font color="white">Filter-Id Help Page</font> </th></tr>\r
- </table>\r
-</td></tr>\r
-<tr bgcolor="black" valign=top><td colspan=2>\r
- <table border=0 width=100% cellpadding=12 cellspacing=0 bgcolor="#ffffd0" valign=top>\r
- <tr><td>\r
-<br>\r
-<center>\r
-<pre>\r
- This Attribute indicates the name of the filter list for this\r
- user. Zero or more Filter-Id attributes MAY be sent in an\r
- Access-Accept packet.\r
-\r
- Identifying a filter list by name allows the filter to be used on\r
- different NASes without regard to filter-list implementation\r
- details. \r
-</td></tr>\r
-<tr><td align=center>\r
-<a href="javascript:window.close();"><b>Close Window</b></a>\r
-</td></tr>\r
-</center>\r
-</table>\r
-</tr>\r
-</table>\r
-</body>\r
-</html>\r
+<html>
+<head>
+<title>Framed-Id Help Page</title>
+<link rel="stylesheet" href="../style.css">
+</head>
+<body bgcolor="#80a040" background="../images/greenlines1.gif" link="black" alink="black">
+<center>
+<table border=0 width=540 cellpadding=1 cellspacing=1>
+<tr valign=top>
+<td width=340></td>
+<td bgcolor="black" width=400>
+ <table border=0 width=100% cellpadding=2 cellspacing=0>
+ <tr bgcolor="#907030" align=right valign=top><th><font color="white">Filter-Id Help Page</font> </th></tr>
+ </table>
+</td></tr>
+<tr bgcolor="black" valign=top><td colspan=2>
+ <table border=0 width=100% cellpadding=12 cellspacing=0 bgcolor="#ffffd0" valign=top>
+ <tr><td>
+<br>
+<center>
+<pre>
+ This Attribute indicates the name of the filter list for this
+ user. Zero or more Filter-Id attributes MAY be sent in an
+ Access-Accept packet.
+
+ Identifying a filter list by name allows the filter to be used on
+ different NASes without regard to filter-list implementation
+ details.
+</td></tr>
+<tr><td align=center>
+<a href="javascript:window.close();"><b>Close Window</b></a>
+</td></tr>
+</center>
+</table>
+</tr>
+</table>
+</body>
+</html>
-<html>\r
-<head>\r
-<title>Framed Protocol Help Page</title>\r
-<link rel="stylesheet" href="../style.css">\r
-</head>\r
-<body bgcolor="#80a040" background="../images/greenlines1.gif" link="black" alink="black">\r
-<center>\r
-<table border=0 width=540 cellpadding=1 cellspacing=1>\r
-<tr valign=top>\r
-<td width=340></td>\r
-<td bgcolor="black" width=400>\r
- <table border=0 width=100% cellpadding=2 cellspacing=0>\r
- <tr bgcolor="#907030" align=right valign=top><th><font color="white">Framed Protocol Help Page</font> </th></tr>\r
- </table>\r
-</td></tr>\r
-<tr bgcolor="black" valign=top><td colspan=2>\r
- <table border=0 width=100% cellpadding=12 cellspacing=0 bgcolor="#ffffd0" valign=top>\r
- <tr><td>\r
-<br>\r
-<center>\r
-<pre>\r
- This Attribute indicates the framing to be used for framed access.\r
- It MAY be used in both Access-Request and Access-Accept packets.\r
-\r
- Possible values are:\r
-</pre>\r
- <i>1 PPP</i><br>\r
- <i>2 SLIP</i><br>\r
- <i>3 AppleTalk Remote Access Protocol (ARAP)</i><br>\r
- <i>4 Gandalf proprietary SingleLink/Multilink protocol</i><br>\r
- <i>5 Xylogics proprietary IPX/SLIP</i><br>\r
- <i>6 X.75 Synchronous</i><br>\r
-</td></tr>\r
-<tr><td align=center>\r
-<a href="javascript:window.close();"><b>Close Window</b></a>\r
-</td></tr>\r
-</center>\r
-</table>\r
-</tr>\r
-</table>\r
-</body>\r
-</html>\r
+<html>
+<head>
+<title>Framed Protocol Help Page</title>
+<link rel="stylesheet" href="../style.css">
+</head>
+<body bgcolor="#80a040" background="../images/greenlines1.gif" link="black" alink="black">
+<center>
+<table border=0 width=540 cellpadding=1 cellspacing=1>
+<tr valign=top>
+<td width=340></td>
+<td bgcolor="black" width=400>
+ <table border=0 width=100% cellpadding=2 cellspacing=0>
+ <tr bgcolor="#907030" align=right valign=top><th><font color="white">Framed Protocol Help Page</font> </th></tr>
+ </table>
+</td></tr>
+<tr bgcolor="black" valign=top><td colspan=2>
+ <table border=0 width=100% cellpadding=12 cellspacing=0 bgcolor="#ffffd0" valign=top>
+ <tr><td>
+<br>
+<center>
+<pre>
+ This Attribute indicates the framing to be used for framed access.
+ It MAY be used in both Access-Request and Access-Accept packets.
+
+ Possible values are:
+</pre>
+ <i>1 PPP</i><br>
+ <i>2 SLIP</i><br>
+ <i>3 AppleTalk Remote Access Protocol (ARAP)</i><br>
+ <i>4 Gandalf proprietary SingleLink/Multilink protocol</i><br>
+ <i>5 Xylogics proprietary IPX/SLIP</i><br>
+ <i>6 X.75 Synchronous</i><br>
+</td></tr>
+<tr><td align=center>
+<a href="javascript:window.close();"><b>Close Window</b></a>
+</td></tr>
+</center>
+</table>
+</tr>
+</table>
+</body>
+</html>
-<html>\r
-<head>\r
-<title>Service-Type Help Page</title>\r
-<link rel="stylesheet" href="../style.css">\r
-</head>\r
-<body bgcolor="#80a040" background="../images/greenlines1.gif" link="black" alink="black">\r
-<center>\r
-<table border=0 width=540 cellpadding=1 cellspacing=1>\r
-<tr valign=top>\r
-<td width=340></td>\r
-<td bgcolor="black" width=400>\r
- <table border=0 width=100% cellpadding=2 cellspacing=0>\r
- <tr bgcolor="#907030" align=right valign=top><th><font color="white">Service-Type Help Page</font> </th></tr>\r
- </table>\r
-</td></tr>\r
-<tr bgcolor="black" valign=top><td colspan=2>\r
- <table border=0 width=100% cellpadding=12 cellspacing=0 bgcolor="#ffffd0" valign=top>\r
- <tr><td>\r
-<br>\r
-<center>\r
-<pre>\r
- This Attribute indicates the type of service the user has\r
- requested, or the type of service to be provided. It MAY be used\r
- in both Access-Request and Access-Accept packets. A NAS is not\r
- required to implement all of these service types, and MUST treat\r
- unknown or unsupported Service-Types as though an Access-Reject\r
- had been received instead.\r
-\r
- Possible values are.\r
-</pre>\r
-<i>1 Login</i><br>\r
-<i>2 Framed</i><br>\r
-<i>3 Callback Login</i><br>\r
-<i>4 Callback Framed</i><br>\r
-<i>5 Outbound</i><br>\r
-<i>6 Administrative</i><br>\r
-<i>7 NAS Prompt</i><br>\r
-<i>8 Authenticate Only</i><br>\r
-<i>9 Callback NAS Prompt</i><br>\r
-<pre>\r
- The service types are defined as follows when used in an Access-\r
- Accept. When used in an Access-Request, they should be considered\r
- to be a hint to the RADIUS server that the NAS has reason to\r
- believe the user would prefer the kind of service indicated, but\r
- the server is not required to honor the hint.\r
-\r
- Login The user should be connected to a host.\r
- Framed A Framed Protocol should be started for the\r
- User, such as PPP or SLIP.\r
- Callback Login The user should be disconnected and called\r
- back, then connected to a host.\r
- Callback Framed The user should be disconnected and called\r
- back, then a Framed Protocol should be started\r
- for the User, such as PPP or SLIP.\r
- Outbound The user should be granted access to outgoing\r
- devices.\r
- Administrative The user should be granted access to the\r
- administrative interface to the NAS from which\r
- privileged commands can be executed.\r
- NAS Prompt The user should be provided a command prompt\r
- on the NAS from which non-privileged commands\r
- can be executed.\r
- Authenticate Only Only Authentication is requested, and no\r
- authorization information needs to be returned\r
- in the Access-Accept (typically used by proxy\r
- servers rather than the NAS itself).\r
- Callback NAS Prompt The user should be disconnected and called\r
- back, then provided a command prompt on the\r
- NAS from which non-privileged commands can be\r
- executed.\r
-</pre>\r
-</td></tr>\r
-<tr><td align=center>\r
-<a href="javascript:window.close();"><b>Close Window</b></a>\r
-</td></tr>\r
-</center>\r
-</table>\r
-</tr>\r
-</table>\r
-</body>\r
-</html>\r
+<html>
+<head>
+<title>Service-Type Help Page</title>
+<link rel="stylesheet" href="../style.css">
+</head>
+<body bgcolor="#80a040" background="../images/greenlines1.gif" link="black" alink="black">
+<center>
+<table border=0 width=540 cellpadding=1 cellspacing=1>
+<tr valign=top>
+<td width=340></td>
+<td bgcolor="black" width=400>
+ <table border=0 width=100% cellpadding=2 cellspacing=0>
+ <tr bgcolor="#907030" align=right valign=top><th><font color="white">Service-Type Help Page</font> </th></tr>
+ </table>
+</td></tr>
+<tr bgcolor="black" valign=top><td colspan=2>
+ <table border=0 width=100% cellpadding=12 cellspacing=0 bgcolor="#ffffd0" valign=top>
+ <tr><td>
+<br>
+<center>
+<pre>
+ This Attribute indicates the type of service the user has
+ requested, or the type of service to be provided. It MAY be used
+ in both Access-Request and Access-Accept packets. A NAS is not
+ required to implement all of these service types, and MUST treat
+ unknown or unsupported Service-Types as though an Access-Reject
+ had been received instead.
+
+ Possible values are.
+</pre>
+<i>1 Login</i><br>
+<i>2 Framed</i><br>
+<i>3 Callback Login</i><br>
+<i>4 Callback Framed</i><br>
+<i>5 Outbound</i><br>
+<i>6 Administrative</i><br>
+<i>7 NAS Prompt</i><br>
+<i>8 Authenticate Only</i><br>
+<i>9 Callback NAS Prompt</i><br>
+<pre>
+ The service types are defined as follows when used in an Access-
+ Accept. When used in an Access-Request, they should be considered
+ to be a hint to the RADIUS server that the NAS has reason to
+ believe the user would prefer the kind of service indicated, but
+ the server is not required to honor the hint.
+
+ Login The user should be connected to a host.
+ Framed A Framed Protocol should be started for the
+ User, such as PPP or SLIP.
+ Callback Login The user should be disconnected and called
+ back, then connected to a host.
+ Callback Framed The user should be disconnected and called
+ back, then a Framed Protocol should be started
+ for the User, such as PPP or SLIP.
+ Outbound The user should be granted access to outgoing
+ devices.
+ Administrative The user should be granted access to the
+ administrative interface to the NAS from which
+ privileged commands can be executed.
+ NAS Prompt The user should be provided a command prompt
+ on the NAS from which non-privileged commands
+ can be executed.
+ Authenticate Only Only Authentication is requested, and no
+ authorization information needs to be returned
+ in the Access-Accept (typically used by proxy
+ servers rather than the NAS itself).
+ Callback NAS Prompt The user should be disconnected and called
+ back, then provided a command prompt on the
+ NAS from which non-privileged commands can be
+ executed.
+</pre>
+</td></tr>
+<tr><td align=center>
+<a href="javascript:window.close();"><b>Close Window</b></a>
+</td></tr>
+</center>
+</table>
+</tr>
+</table>
+</body>
+</html>
-CREATE OR REPLACE FUNCTION msqlippool(user varchar2, pool varchar2)\r
-RETURN varchar2 IS\r
-\r
- PRAGMA AUTONOMOUS_TRANSACTION;\r
- ip_temp varchar2(20);\r
-BEGIN\r
-\r
- -- If the user's pool is dynamic, get an ipaddress (oldest one) from the corresponding pool\r
-\r
- if pool = 'Dynamic' then\r
- select framedipaddress into ip_temp from (select framedipaddress from radippool where expiry_time < current_timestamp and pool_name = pool ORDER BY expiry_time) where rownum = 1;\r
- return (ip_temp);\r
-\r
- -- Else, then get the static ipaddress for that user from the corresponding pool\r
-\r
- else\r
- select framedipaddress into ip_temp from radippool where username = user and pool_name = pool;\r
- return (ip_temp);\r
- end if;\r
-\r
-exception\r
-\r
- -- This block is executed if there's no free ipaddresses or no static ip assigned to the user\r
-\r
- when NO_DATA_FOUND then\r
- if pool = 'Dynamic' then\r
- return(''); -- so sqlippool can log it on radius.log\r
- end if;\r
-\r
- -- Else, grabs a free IP from the static pool and saves it in radippool so the user will always get the same IP the next time\r
-\r
- select framedipaddress into ip_temp from (select framedipaddress from radippool where expiry_time < current_timestamp and username is null and pool_name = pool) where rownum = 1;\r
- UPDATE radippool SET username = user where framedipaddress = ip_temp;\r
- commit;\r
- return (ip_temp);\r
-\r
- when others\r
- then return('Oracle Exception');\r
-\r
-END;\r
-/\r
+CREATE OR REPLACE FUNCTION msqlippool(user varchar2, pool varchar2)
+RETURN varchar2 IS
+
+ PRAGMA AUTONOMOUS_TRANSACTION;
+ ip_temp varchar2(20);
+BEGIN
+
+ -- If the user's pool is dynamic, get an ipaddress (oldest one) from the corresponding pool
+
+ if pool = 'Dynamic' then
+ select framedipaddress into ip_temp from (select framedipaddress from radippool where expiry_time < current_timestamp and pool_name = pool ORDER BY expiry_time) where rownum = 1;
+ return (ip_temp);
+
+ -- Else, then get the static ipaddress for that user from the corresponding pool
+
+ else
+ select framedipaddress into ip_temp from radippool where username = user and pool_name = pool;
+ return (ip_temp);
+ end if;
+
+exception
+
+ -- This block is executed if there's no free ipaddresses or no static ip assigned to the user
+
+ when NO_DATA_FOUND then
+ if pool = 'Dynamic' then
+ return(''); -- so sqlippool can log it on radius.log
+ end if;
+
+ -- Else, grabs a free IP from the static pool and saves it in radippool so the user will always get the same IP the next time
+
+ select framedipaddress into ip_temp from (select framedipaddress from radippool where expiry_time < current_timestamp and username is null and pool_name = pool) where rownum = 1;
+ UPDATE radippool SET username = user where framedipaddress = ip_temp;
+ commit;
+ return (ip_temp);
+
+ when others
+ then return('Oracle Exception');
+
+END;
+/
projects / freeradius.git / commitdiff