<br><div>Dear All,</div><div><br></div><div>can I ask for some pointers please. in my FreeRADIUS Version 2.1.8, for host x86_64-pc-linux-gnu (Ubuntu LTS 10.04) installation I have followed the Gigabyte instructions on the FreeRADIUS wiki's FAQ <a href="http://wiki.freeradius.org/FAQ#Why+do+Acct-Input-Octets+and+Acct-Output-Octets+wrap+at+4+GB%3F">http://wiki.freeradius.org/FAQ#Why+do+Acct-Input-Octets+and+Acct-Output-Octets+wrap+at+4+GB%3F</a>. The Usage is calculated correctly, but the check_item value is not what I expect to see (1.7 GB as opposed th 6GB set in radcheck). I understand who the system determines the counter value and it is correctly calculated, but where does the check_item vlaue of 1.7GB come from? I have no idea to be truthful. </div>
<div><br></div><div>Any pointers welcome. </div><div><br></div><div>Thanks in advance.</div><div><br></div><div><br></div><div>Here the data/logs:</div><div><br></div><div>Here the relevant debug log:</div><div><div>Sat Jun 4 23:10:21 2011 : Debug: rlm_sqlcounter: Entering module authorize code</div>
<div>Sat Jun 4 23:10:21 2011 : Debug: sqlcounter_expand: 'SELECT IFNULL(SUM(AcctInputOctets) + SUM(AcctOutputOctets),0) FROM radacct WHERE UserName='%{User-Name}''</div><div>Sat Jun 4 23:10:21 2011 : Info: [noresettotal] expand: SELECT IFNULL(SUM(AcctInputOctets) + SUM(AcctOutputOctets),0) FROM radacct WHERE UserName='%{User-Name}' -> SELECT IFNULL(SUM(AcctInputOctets) + SUM(AcctOutputOctets),0) FROM radacct WHERE UserName='lapzel14'</div>
<div>Sat Jun 4 23:10:21 2011 : Debug: sqlcounter_expand: '%{sql03:SELECT IFNULL(SUM(AcctInputOctets) + SUM(AcctOutputOctets),0) FROM radacct WHERE UserName='lapzel14'}'</div><div>Sat Jun 4 23:10:21 2011 : Info: [noresettotal] sql_xlat</div>
<div>Sat Jun 4 23:10:21 2011 : Info: [noresettotal] expand: %{User-Name} -> lapzel14</div><div>Sat Jun 4 23:10:21 2011 : Info: [noresettotal] sql_set_user escaped user --> 'lapzel14'</div><div>Sat Jun 4 23:10:21 2011 : Info: [noresettotal] expand: SELECT IFNULL(SUM(AcctInputOctets) + SUM(AcctOutputOctets),0) FROM radacct WHERE UserName='lapzel14' -> SELECT IFNULL(SUM(AcctInputOctets) + SUM(AcctOutputOctets),0) FROM radacct WHERE UserName='lapzel14'</div>
<div>Sat Jun 4 23:10:21 2011 : Info: [noresettotal] expand: /var/log/freeradius/sqltrace.sql -> /var/log/freeradius/sqltrace.sql</div><div>Sat Jun 4 23:10:21 2011 : Debug: rlm_sql (sql03): Reserving sql socket id: 3</div>
<div>Sat Jun 4 23:10:21 2011 : Debug: rlm_sql_mysql: query: SELECT IFNULL(SUM(AcctInputOctets) + SUM(AcctOutputOctets),0) FROM radacct WHERE UserName='lapzel14'</div><div>Sat Jun 4 23:10:21 2011 : Info: [noresettotal] sql_xlat finished</div>
<div>Sat Jun 4 23:10:21 2011 : Debug: rlm_sql (sql03): Released sql socket id: 3</div><div>Sat Jun 4 23:10:21 2011 : Info: [noresettotal] expand: %{sql03:SELECT IFNULL(SUM(AcctInputOctets) + SUM(AcctOutputOctets),0) FROM radacct WHERE UserName='lapzel14'} -> 2147513300</div>
<div>Sat Jun 4 23:10:21 2011 : Debug: rlm_sqlcounter: (Check item - counter) is less than zero</div><div>Sat Jun 4 23:10:21 2011 : Debug: rlm_sqlcounter: Rejected user lapzel14, check_item=1705032704, counter=2147513300</div>
<div>Sat Jun 4 23:10:21 2011 : Info: ++[noresettotal] returns reject</div></div><div><br></div><div>Definition of the noresettotal module in counter.conf:</div><div><div>sqlcounter noresettotal {</div><div> counter-name = Max-All-Total-Octets</div>
<div> check-name = Max-All-Total</div><div> reply-name = ChilliSpot-Max-Total-Octets</div><div> sqlmod-inst = sql03</div><div> key = User-Name</div><div> reset = never</div><div> query = "SELECT IFNULL(SUM(AcctInputOctets) + SUM(AcctOutputOctets),0) FROM radacct WHERE UserName='%{%k}'"</div>
<div>}</div></div><div><br></div><div>and here the radcheck values for user 'lapzel14':</div><div><table id="table_results" class="data" style="font-family: sans-serif; font-size: 13px; "><thead><tr><th colspan="3" style="font-weight: bold; color: rgb(0, 0, 0); background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: rgb(211, 220, 227); padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; background-position: initial initial; background-repeat: initial initial; ">
<a href="http://login02.chillifire.net/phpmyadmin/sql.php?db=radius&table=radcheck&sql_query=SELECT+%2A++FROM+%60radcheck%60+WHERE+%60UserName%60+LIKE+%27lapzel14%27&goto=sql.php%3Fdb%3Dradius%26amp%3Btable%3Dradcheck%26amp%3Btoken%3Ddf845dec99ab8224acc2d1d0fceddd89%26amp%3Bsql_query%3DSELECT%2B%252A%2B%2BFROM%2B%2560radcheck%2560%2BWHERE%2B%2560UserName%2560%2BLIKE%2B%2527lapzel14%2527&display_options_form=1&display_text=F&token=df845dec99ab8224acc2d1d0fceddd89" style="text-decoration: none; color: rgb(0, 0, 255); "><img class="fulltext" width="50" height="20" src="http://login02.chillifire.net/phpmyadmin/themes/original/img/s_fulltext.png" alt="Full Texts" title="Full Texts" style="vertical-align: middle; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; "></a></th>
<th style="font-weight: bold; color: rgb(0, 0, 0); background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: rgb(211, 220, 227); padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; background-position: initial initial; background-repeat: initial initial; ">
<a href="http://login02.chillifire.net/phpmyadmin/sql.php?db=radius&table=radcheck&sql_query=SELECT+%2A++FROM+%60radcheck%60+WHERE+%60UserName%60+LIKE+%27lapzel14%27+ORDER+BY+%60radcheck%60.%60id%60+ASC&token=df845dec99ab8224acc2d1d0fceddd89" title="Sort" style="text-decoration: none; color: rgb(0, 0, 255); ">id</a></th>
<th class="condition" style="font-weight: bold; color: rgb(0, 0, 0); background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: rgb(211, 220, 227); padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-color: rgb(255, 204, 153); border-right-color: rgb(255, 204, 153); border-bottom-color: rgb(255, 204, 153); border-left-color: rgb(255, 204, 153); background-position: initial initial; background-repeat: initial initial; ">
<a href="http://login02.chillifire.net/phpmyadmin/sql.php?db=radius&table=radcheck&sql_query=SELECT+%2A++FROM+%60radcheck%60+WHERE+%60UserName%60+LIKE+%27lapzel14%27+ORDER+BY+%60radcheck%60.%60UserName%60+ASC&token=df845dec99ab8224acc2d1d0fceddd89" title="Sort" style="text-decoration: none; color: rgb(0, 0, 255); ">UserName</a></th>
<th style="font-weight: bold; color: rgb(0, 0, 0); background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: rgb(211, 220, 227); padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; background-position: initial initial; background-repeat: initial initial; ">
<a href="http://login02.chillifire.net/phpmyadmin/sql.php?db=radius&table=radcheck&sql_query=SELECT+%2A++FROM+%60radcheck%60+WHERE+%60UserName%60+LIKE+%27lapzel14%27+ORDER+BY+%60radcheck%60.%60Attribute%60+ASC&token=df845dec99ab8224acc2d1d0fceddd89" title="Sort" style="text-decoration: none; color: rgb(0, 0, 255); ">Attribute</a></th>
<th style="font-weight: bold; color: rgb(0, 0, 0); background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: rgb(211, 220, 227); padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; background-position: initial initial; background-repeat: initial initial; ">
<a href="http://login02.chillifire.net/phpmyadmin/sql.php?db=radius&table=radcheck&sql_query=SELECT+%2A++FROM+%60radcheck%60+WHERE+%60UserName%60+LIKE+%27lapzel14%27+ORDER+BY+%60radcheck%60.%60op%60+ASC&token=df845dec99ab8224acc2d1d0fceddd89" title="Sort" style="text-decoration: none; color: rgb(0, 0, 255); ">op</a></th>
<th style="font-weight: bold; color: rgb(0, 0, 0); background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: rgb(211, 220, 227); padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; background-position: initial initial; background-repeat: initial initial; ">
<a href="http://login02.chillifire.net/phpmyadmin/sql.php?db=radius&table=radcheck&sql_query=SELECT+%2A++FROM+%60radcheck%60+WHERE+%60UserName%60+LIKE+%27lapzel14%27+ORDER+BY+%60radcheck%60.%60Value%60+ASC&token=df845dec99ab8224acc2d1d0fceddd89" title="Sort" style="text-decoration: none; color: rgb(0, 0, 255); ">Value</a></th>
</tr></thead><tbody><tr class="odd" style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: rgb(229, 229, 229); text-align: left; background-position: initial initial; background-repeat: initial initial; ">
<td align="center" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; "><input type="checkbox" id="id_rows_to_delete0" name="rows_to_delete[%60radcheck%60.%60id%60+%3D+572098]" value="DELETE FROM `radius`.`radcheck` WHERE `radcheck`.`id` = 572098" style="font-size: 1em; vertical-align: middle; "></td>
<td align="center" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; "><a href="http://login02.chillifire.net/phpmyadmin/tbl_change.php?db=radius&table=radcheck&where_clause=%60radcheck%60.%60id%60+%3D+572098&clause_is_unique=1&sql_query=SELECT+%2A++FROM+%60radcheck%60+WHERE+%60UserName%60+LIKE+%27lapzel14%27&goto=sql.php&token=df845dec99ab8224acc2d1d0fceddd89" style="text-decoration: none; color: rgb(0, 0, 255); "><img src="http://login02.chillifire.net/phpmyadmin/themes/original/img/b_edit.png" title="Edit" alt="Edit" class="icon" width="16" height="16" style="vertical-align: middle; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; margin-right: 0px; margin-left: 0px; margin-top: 0px; margin-bottom: 0px; "></a></td>
<td align="center" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; "><a href="http://login02.chillifire.net/phpmyadmin/sql.php?db=radius&table=radcheck&sql_query=DELETE+FROM+%60radius%60.%60radcheck%60+WHERE+%60radcheck%60.%60id%60+%3D+572098&zero_rows=The+row+has+been+deleted&goto=sql.php%3Fdb%3Dradius%26table%3Dradcheck%26sql_query%3DSELECT%2B%252A%2B%2BFROM%2B%2560radcheck%2560%2BWHERE%2B%2560UserName%2560%2BLIKE%2B%2527lapzel14%2527%26zero_rows%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dsql.php%253Fdb%253Dradius%2526amp%253Btable%253Dradcheck%2526amp%253Btoken%253Ddf845dec99ab8224acc2d1d0fceddd89%2526amp%253Bsql_query%253DSELECT%252B%25252A%252B%252BFROM%252B%252560radcheck%252560%252BWHERE%252B%252560UserName%252560%252BLIKE%252B%252527lapzel14%252527%26token%3Ddf845dec99ab8224acc2d1d0fceddd89&token=df845dec99ab8224acc2d1d0fceddd89" style="text-decoration: none; color: rgb(0, 0, 255); "><img src="http://login02.chillifire.net/phpmyadmin/themes/original/img/b_drop.png" title="Delete" alt="Delete" class="icon" width="16" height="16" style="vertical-align: middle; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; margin-right: 0px; margin-left: 0px; margin-top: 0px; margin-bottom: 0px; "></a></td>
<td align="right" class=" nowrap" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; ">
572098</td><td class=" condition" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-color: rgb(255, 204, 153); border-right-color: rgb(255, 204, 153); border-bottom-color: rgb(255, 204, 153); border-left-color: rgb(255, 204, 153); ">
lapzel14</td><td class="" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; ">
User-Password</td><td class="" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; ">
:=</td><td class="" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; ">loxdas</td>
</tr><tr class="even" style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: rgb(213, 213, 213); text-align: left; background-position: initial initial; background-repeat: initial initial; ">
<td align="center" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; "><input type="checkbox" id="id_rows_to_delete1" name="rows_to_delete[%60radcheck%60.%60id%60+%3D+572102]" value="DELETE FROM `radius`.`radcheck` WHERE `radcheck`.`id` = 572102" style="font-size: 1em; vertical-align: middle; "></td>
<td align="center" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; "><a href="http://login02.chillifire.net/phpmyadmin/tbl_change.php?db=radius&table=radcheck&where_clause=%60radcheck%60.%60id%60+%3D+572102&clause_is_unique=1&sql_query=SELECT+%2A++FROM+%60radcheck%60+WHERE+%60UserName%60+LIKE+%27lapzel14%27&goto=sql.php&token=df845dec99ab8224acc2d1d0fceddd89" style="text-decoration: none; color: rgb(0, 0, 255); "><img src="http://login02.chillifire.net/phpmyadmin/themes/original/img/b_edit.png" title="Edit" alt="Edit" class="icon" width="16" height="16" style="vertical-align: middle; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; margin-right: 0px; margin-left: 0px; margin-top: 0px; margin-bottom: 0px; "></a></td>
<td align="center" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; "><a href="http://login02.chillifire.net/phpmyadmin/sql.php?db=radius&table=radcheck&sql_query=DELETE+FROM+%60radius%60.%60radcheck%60+WHERE+%60radcheck%60.%60id%60+%3D+572102&zero_rows=The+row+has+been+deleted&goto=sql.php%3Fdb%3Dradius%26table%3Dradcheck%26sql_query%3DSELECT%2B%252A%2B%2BFROM%2B%2560radcheck%2560%2BWHERE%2B%2560UserName%2560%2BLIKE%2B%2527lapzel14%2527%26zero_rows%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dsql.php%253Fdb%253Dradius%2526amp%253Btable%253Dradcheck%2526amp%253Btoken%253Ddf845dec99ab8224acc2d1d0fceddd89%2526amp%253Bsql_query%253DSELECT%252B%25252A%252B%252BFROM%252B%252560radcheck%252560%252BWHERE%252B%252560UserName%252560%252BLIKE%252B%252527lapzel14%252527%26token%3Ddf845dec99ab8224acc2d1d0fceddd89&token=df845dec99ab8224acc2d1d0fceddd89" style="text-decoration: none; color: rgb(0, 0, 255); "><img src="http://login02.chillifire.net/phpmyadmin/themes/original/img/b_drop.png" title="Delete" alt="Delete" class="icon" width="16" height="16" style="vertical-align: middle; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; margin-right: 0px; margin-left: 0px; margin-top: 0px; margin-bottom: 0px; "></a></td>
<td align="right" class=" nowrap" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; ">
572102</td><td class=" condition" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-color: rgb(255, 204, 153); border-right-color: rgb(255, 204, 153); border-bottom-color: rgb(255, 204, 153); border-left-color: rgb(255, 204, 153); ">
lapzel14</td><td class="" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; ">
Expiration</td><td class="" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; ">
:=</td><td class="" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; ">1311932528</td>
</tr><tr class="odd" style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: rgb(229, 229, 229); text-align: left; background-position: initial initial; background-repeat: initial initial; ">
<td align="center" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; "><input type="checkbox" id="id_rows_to_delete2" name="rows_to_delete[%60radcheck%60.%60id%60+%3D+572106]" value="DELETE FROM `radius`.`radcheck` WHERE `radcheck`.`id` = 572106" style="font-size: 1em; vertical-align: middle; "></td>
<td align="center" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; "><a href="http://login02.chillifire.net/phpmyadmin/tbl_change.php?db=radius&table=radcheck&where_clause=%60radcheck%60.%60id%60+%3D+572106&clause_is_unique=1&sql_query=SELECT+%2A++FROM+%60radcheck%60+WHERE+%60UserName%60+LIKE+%27lapzel14%27&goto=sql.php&token=df845dec99ab8224acc2d1d0fceddd89" style="text-decoration: none; color: rgb(0, 0, 255); "><img src="http://login02.chillifire.net/phpmyadmin/themes/original/img/b_edit.png" title="Edit" alt="Edit" class="icon" width="16" height="16" style="vertical-align: middle; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; margin-right: 0px; margin-left: 0px; margin-top: 0px; margin-bottom: 0px; "></a></td>
<td align="center" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; "><a href="http://login02.chillifire.net/phpmyadmin/sql.php?db=radius&table=radcheck&sql_query=DELETE+FROM+%60radius%60.%60radcheck%60+WHERE+%60radcheck%60.%60id%60+%3D+572106&zero_rows=The+row+has+been+deleted&goto=sql.php%3Fdb%3Dradius%26table%3Dradcheck%26sql_query%3DSELECT%2B%252A%2B%2BFROM%2B%2560radcheck%2560%2BWHERE%2B%2560UserName%2560%2BLIKE%2B%2527lapzel14%2527%26zero_rows%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dsql.php%253Fdb%253Dradius%2526amp%253Btable%253Dradcheck%2526amp%253Btoken%253Ddf845dec99ab8224acc2d1d0fceddd89%2526amp%253Bsql_query%253DSELECT%252B%25252A%252B%252BFROM%252B%252560radcheck%252560%252BWHERE%252B%252560UserName%252560%252BLIKE%252B%252527lapzel14%252527%26token%3Ddf845dec99ab8224acc2d1d0fceddd89&token=df845dec99ab8224acc2d1d0fceddd89" style="text-decoration: none; color: rgb(0, 0, 255); "><img src="http://login02.chillifire.net/phpmyadmin/themes/original/img/b_drop.png" title="Delete" alt="Delete" class="icon" width="16" height="16" style="vertical-align: middle; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; margin-right: 0px; margin-left: 0px; margin-top: 0px; margin-bottom: 0px; "></a></td>
<td align="right" class=" nowrap" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; ">
572106</td><td class=" condition" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-color: rgb(255, 204, 153); border-right-color: rgb(255, 204, 153); border-bottom-color: rgb(255, 204, 153); border-left-color: rgb(255, 204, 153); ">
lapzel14</td><td class="" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; ">
Simultaneous-Use</td><td class="" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; ">
:=</td><td class="" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; ">1</td>
</tr><tr class="even" style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: rgb(213, 213, 213); text-align: left; background-position: initial initial; background-repeat: initial initial; ">
<td align="center" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; "><input type="checkbox" id="id_rows_to_delete3" name="rows_to_delete[%60radcheck%60.%60id%60+%3D+572110]" value="DELETE FROM `radius`.`radcheck` WHERE `radcheck`.`id` = 572110" style="font-size: 1em; vertical-align: middle; "></td>
<td align="center" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; "><a href="http://login02.chillifire.net/phpmyadmin/tbl_change.php?db=radius&table=radcheck&where_clause=%60radcheck%60.%60id%60+%3D+572110&clause_is_unique=1&sql_query=SELECT+%2A++FROM+%60radcheck%60+WHERE+%60UserName%60+LIKE+%27lapzel14%27&goto=sql.php&token=df845dec99ab8224acc2d1d0fceddd89" style="text-decoration: none; color: rgb(0, 0, 255); "><img src="http://login02.chillifire.net/phpmyadmin/themes/original/img/b_edit.png" title="Edit" alt="Edit" class="icon" width="16" height="16" style="vertical-align: middle; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; margin-right: 0px; margin-left: 0px; margin-top: 0px; margin-bottom: 0px; "></a></td>
<td align="center" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; "><a href="http://login02.chillifire.net/phpmyadmin/sql.php?db=radius&table=radcheck&sql_query=DELETE+FROM+%60radius%60.%60radcheck%60+WHERE+%60radcheck%60.%60id%60+%3D+572110&zero_rows=The+row+has+been+deleted&goto=sql.php%3Fdb%3Dradius%26table%3Dradcheck%26sql_query%3DSELECT%2B%252A%2B%2BFROM%2B%2560radcheck%2560%2BWHERE%2B%2560UserName%2560%2BLIKE%2B%2527lapzel14%2527%26zero_rows%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dsql.php%253Fdb%253Dradius%2526amp%253Btable%253Dradcheck%2526amp%253Btoken%253Ddf845dec99ab8224acc2d1d0fceddd89%2526amp%253Bsql_query%253DSELECT%252B%25252A%252B%252BFROM%252B%252560radcheck%252560%252BWHERE%252B%252560UserName%252560%252BLIKE%252B%252527lapzel14%252527%26token%3Ddf845dec99ab8224acc2d1d0fceddd89&token=df845dec99ab8224acc2d1d0fceddd89" style="text-decoration: none; color: rgb(0, 0, 255); "><img src="http://login02.chillifire.net/phpmyadmin/themes/original/img/b_drop.png" title="Delete" alt="Delete" class="icon" width="16" height="16" style="vertical-align: middle; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; margin-right: 0px; margin-left: 0px; margin-top: 0px; margin-bottom: 0px; "></a></td>
<td align="right" class=" nowrap" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; ">
572110</td><td class=" condition" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-color: rgb(255, 204, 153); border-right-color: rgb(255, 204, 153); border-bottom-color: rgb(255, 204, 153); border-left-color: rgb(255, 204, 153); ">
lapzel14</td><td class="" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; ">
Max-All-Total</td><td class="" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; ">
:=</td><td class="" style="padding-top: 0.1em; padding-right: 0.5em; padding-bottom: 0.1em; padding-left: 0.5em; margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; ">6000000000<br>
<br></td></tr></tbody></table></div>