{"id":3,"date":"2013-05-11T07:40:00","date_gmt":"2013-05-11T05:40:00","guid":{"rendered":"http:\/\/netexpertise\/en\/?p=3"},"modified":"2021-10-10T17:19:18","modified_gmt":"2021-10-10T15:19:18","slug":"usage-graphs","status":"publish","type":"post","link":"http:\/\/www.netexpertise.eu\/en\/networking\/freeradius\/usage-graphs.html","title":{"rendered":"Freeradius Usage Graphs"},"content":{"rendered":"\n<p><script type=\"text\/javascript\" src=\"\/count\/display.php\"><br \/>\n<!--\n\/\/--><br \/>\n<\/script><br><a href=\"\/cgi-bin\/mytraffic.pl\"><img decoding=\"async\" alt=\"Freeradius traffic usage graph\" style=\"border: 1px solid #000000; float: left; margin-right: 15px;\" src=\"\/images\/reducedgraph.png\"><\/a><\/p>\n\n\n\n<p>Radius servers generate a lot of accounting records. Is it worth keeping them? Of course! Beside the fact they could be used to check if a customer was connected at a given date, or find out who got IP address X.X.X.X that same day, the most interesting is to generate Freeradius traffic usage graphs and show customers their daily download and upload. This is particularly useful for Internet providers. Many other features can then be implemented on top of that:<br>&#8211; Bill customers based on traffic, with your own or a professional billing software<br>&#8211; Charge customers for each extra MB passed the quota<br>&#8211; Suspend or restrict download speed for abusing customers<br>&#8211; Or simply detect abusing customers<br>Those are only a few examples but there are many other applications that could be built from there.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><br>Usage Graphs Features<\/h2>\n\n\n\n<p>These scripts are already used by Internet service providers but could be used by anyone really using <a href=\"\/en\/category\/networking\/freeradius\">Freeradius<\/a>. <br><br>They provide:<br>&#8211; Customer&#8217;s IP detection. User doesn&#8217;t need to enter his username or IP address.<br>&#8211; Customizable header and footer<br>&#8211; Easy setup. Just uncompress the archive and set your system parameters, that&#8217;s it<br>&#8211; Admin section to monitor any customer<br>&#8211; Displays days with no data or zero traffic<br><br>To get best results, have a look <a href=\".\/daily-accounting.html\">here<\/a> on how to update your Radius usage at regular intervals. If not, you will get many days with no traffic due to the Radius protocol sending accounting at the start and the end of a session. You will also need to setup Freeradius and send accounting to a <a href=\"http:\/\/www.mysql.com\" target=\"_blank\" rel=\"noreferrer noopener\">Mysql<\/a>, <a href=\"http:\/\/www.postgresql.org\" target=\"_blank\" rel=\"noreferrer noopener\">Postgresql<\/a> or <a href=\"http:\/\/www.oracle.com\" target=\"_blank\" rel=\"noreferrer noopener\">Oracle<\/a> database. Perl and its DBI and GD modules are also required. Visit <a href=\"http:\/\/www.perl.com\" target=\"_blank\" rel=\"noreferrer noopener\">www.perl.com<\/a>.<\/p>\n\n\n\n<p>It is recommended to create indexes on UserName on tables radacct and radcheck to speed up the script.<br>Freeradius usage graph is compatible with all Freeradius up to last version 3.x<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><br>Freeradius Usage Graphs Download<\/h2>\n\n\n\n<p><a href=\"\/count\/click.php?id=1\"><img decoding=\"async\" style=\"border: 0;\" src=\"\/images\/compressed.gif\" alt=\"download\"><\/a> Want to give it a try? Get this Radius traffic reporting script for free from the download section right now!<br><a style=\"color: #000000;\" href=\"\/count\/click.php?id=1\">Download<\/a> (<em style=\"color: #ff0000;\"><script language=\"javascript\">ccount_display('1')<\/script><\/em> hits)<br><br>Note: This version only supports Mysql. Check below for Postgresql and Oracle.<br>In order to improve those scripts, don&#8217;t hesitate to contact us at <a href=\"mailto:david@netexpertise.eu\">contact@netexpertise.eu<\/a> to share your ideas.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><br>Advanced Script<\/h2>\n\n\n\n<p>Benefit from new features added to the previous script<br>&#8211; Display per day or per month<br>&#8211; Display traffic or number of disconnections<br>&#8211; Define start and stop dates<br>&#8211; Interactivity through a form<br>&#8211; Pick up dates from calendar<br>&#8211; Customizable graph colors to match your site<br>&#8211; Postgresql and Oracle support<br><br>Check this <a href=\"\/cgi-bin\/mytraffic.pl\"><em style=\"color: #ff0000;\">DEMO<\/em><\/a> out and get the advanced version for \u20ac20 only!<img decoding=\"async\" loading=\"lazy\" width=\"1\" height=\"1\" border=\"0\" src=\"https:\/\/www.paypalobjects.com\/en_US\/i\/scr\/pixel.gif\" alt=\"\"><br><br><\/p>\n\n\n\n<form action=\"https:\/\/www.paypal.com\/cgi-bin\/webscr\" method=\"post\" target=\"_top\">\n<input type=\"hidden\" name=\"cmd\" value=\"_s-xclick\">\n<input type=\"hidden\" name=\"hosted_button_id\" value=\"GWJGQZCKREYEW\">\n<input type=\"image\" src=\"https:\/\/www.paypalobjects.com\/en_US\/i\/btn\/btn_buynow_LG.gif\" border=\"0\" name=\"submit\" alt=\"PayPal - The safer, easier way to pay online!\">\n<img decoding=\"async\" loading=\"lazy\" alt=\"\" border=\"0\" src=\"https:\/\/www.paypalobjects.com\/en_US\/i\/scr\/pixel.gif\" width=\"1\" height=\"1\">\n<\/form>\n","protected":false},"excerpt":{"rendered":"<p>Radius servers generate a lot of accounting records. Is it worth keeping them? Of course! Beside the fact they could be used to check if a customer was connected at a given date, or find out who got IP address X.X.X.X that same day, the most interesting is to generate Freeradius traffic usage graphs and [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[3],"tags":[384,17,386,385,387,15,10,19],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.8.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Netexpertise - Freeradius Usage Graphs<\/title>\n<meta name=\"description\" content=\"Freeradius usage graphs let clients (or yourself) see their own traffic usage (download\/upload) from accounting records stored in database.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.netexpertise.eu\/en\/networking\/freeradius\/usage-graphs.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Netexpertise - Freeradius Usage Graphs\" \/>\n<meta property=\"og:description\" content=\"Freeradius usage graphs let clients (or yourself) see their own traffic usage (download\/upload) from accounting records stored in database.\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.netexpertise.eu\/en\/networking\/freeradius\/usage-graphs.html\" \/>\n<meta property=\"og:site_name\" content=\"Netexpertise\" \/>\n<meta property=\"article:published_time\" content=\"2013-05-11T05:40:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-10T15:19:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.paypalobjects.com\/en_US\/i\/scr\/pixel.gif\" \/>\n<meta name=\"author\" content=\"dave\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@netexpertise\" \/>\n<meta name=\"twitter:site\" content=\"@netexpertise\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/www.netexpertise.eu\/en\/networking\/freeradius\/usage-graphs.html\",\"url\":\"http:\/\/www.netexpertise.eu\/en\/networking\/freeradius\/usage-graphs.html\",\"name\":\"Netexpertise - Freeradius Usage Graphs\",\"isPartOf\":{\"@id\":\"https:\/\/www.netexpertise.eu\/en\/#website\"},\"datePublished\":\"2013-05-11T05:40:00+00:00\",\"dateModified\":\"2021-10-10T15:19:18+00:00\",\"author\":{\"@id\":\"https:\/\/www.netexpertise.eu\/en\/#\/schema\/person\/cb4cd666549d22e9070ec1cfc1a496fa\"},\"description\":\"Freeradius usage graphs let clients (or yourself) see their own traffic usage (download\/upload) from accounting records stored in database.\",\"breadcrumb\":{\"@id\":\"http:\/\/www.netexpertise.eu\/en\/networking\/freeradius\/usage-graphs.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/www.netexpertise.eu\/en\/networking\/freeradius\/usage-graphs.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/www.netexpertise.eu\/en\/networking\/freeradius\/usage-graphs.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.netexpertise.eu\/en\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Freeradius Usage Graphs\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.netexpertise.eu\/en\/#website\",\"url\":\"https:\/\/www.netexpertise.eu\/en\/\",\"name\":\"Netexpertise\",\"description\":\"Systems \/ Networks \/ DevOps\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.netexpertise.eu\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.netexpertise.eu\/en\/#\/schema\/person\/cb4cd666549d22e9070ec1cfc1a496fa\",\"name\":\"dave\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.netexpertise.eu\/en\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/1.gravatar.com\/avatar\/1129916e1f4955bd632f27f836f64e55?s=96&d=mm&r=g\",\"contentUrl\":\"http:\/\/1.gravatar.com\/avatar\/1129916e1f4955bd632f27f836f64e55?s=96&d=mm&r=g\",\"caption\":\"dave\"},\"sameAs\":[\"http:\/\/www.netexpertise.eu\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Netexpertise - Freeradius Usage Graphs","description":"Freeradius usage graphs let clients (or yourself) see their own traffic usage (download\/upload) from accounting records stored in database.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/www.netexpertise.eu\/en\/networking\/freeradius\/usage-graphs.html","og_locale":"en_US","og_type":"article","og_title":"Netexpertise - Freeradius Usage Graphs","og_description":"Freeradius usage graphs let clients (or yourself) see their own traffic usage (download\/upload) from accounting records stored in database.","og_url":"http:\/\/www.netexpertise.eu\/en\/networking\/freeradius\/usage-graphs.html","og_site_name":"Netexpertise","article_published_time":"2013-05-11T05:40:00+00:00","article_modified_time":"2021-10-10T15:19:18+00:00","og_image":[{"url":"https:\/\/www.paypalobjects.com\/en_US\/i\/scr\/pixel.gif"}],"author":"dave","twitter_card":"summary_large_image","twitter_creator":"@netexpertise","twitter_site":"@netexpertise","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/www.netexpertise.eu\/en\/networking\/freeradius\/usage-graphs.html","url":"http:\/\/www.netexpertise.eu\/en\/networking\/freeradius\/usage-graphs.html","name":"Netexpertise - Freeradius Usage Graphs","isPartOf":{"@id":"https:\/\/www.netexpertise.eu\/en\/#website"},"datePublished":"2013-05-11T05:40:00+00:00","dateModified":"2021-10-10T15:19:18+00:00","author":{"@id":"https:\/\/www.netexpertise.eu\/en\/#\/schema\/person\/cb4cd666549d22e9070ec1cfc1a496fa"},"description":"Freeradius usage graphs let clients (or yourself) see their own traffic usage (download\/upload) from accounting records stored in database.","breadcrumb":{"@id":"http:\/\/www.netexpertise.eu\/en\/networking\/freeradius\/usage-graphs.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.netexpertise.eu\/en\/networking\/freeradius\/usage-graphs.html"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/www.netexpertise.eu\/en\/networking\/freeradius\/usage-graphs.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.netexpertise.eu\/en"},{"@type":"ListItem","position":2,"name":"Freeradius Usage Graphs"}]},{"@type":"WebSite","@id":"https:\/\/www.netexpertise.eu\/en\/#website","url":"https:\/\/www.netexpertise.eu\/en\/","name":"Netexpertise","description":"Systems \/ Networks \/ DevOps","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.netexpertise.eu\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.netexpertise.eu\/en\/#\/schema\/person\/cb4cd666549d22e9070ec1cfc1a496fa","name":"dave","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.netexpertise.eu\/en\/#\/schema\/person\/image\/","url":"http:\/\/1.gravatar.com\/avatar\/1129916e1f4955bd632f27f836f64e55?s=96&d=mm&r=g","contentUrl":"http:\/\/1.gravatar.com\/avatar\/1129916e1f4955bd632f27f836f64e55?s=96&d=mm&r=g","caption":"dave"},"sameAs":["http:\/\/www.netexpertise.eu"]}]}},"_links":{"self":[{"href":"http:\/\/www.netexpertise.eu\/en\/wp-json\/wp\/v2\/posts\/3"}],"collection":[{"href":"http:\/\/www.netexpertise.eu\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.netexpertise.eu\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.netexpertise.eu\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.netexpertise.eu\/en\/wp-json\/wp\/v2\/comments?post=3"}],"version-history":[{"count":0,"href":"http:\/\/www.netexpertise.eu\/en\/wp-json\/wp\/v2\/posts\/3\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.netexpertise.eu\/en\/wp-json\/wp\/v2\/media?parent=3"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.netexpertise.eu\/en\/wp-json\/wp\/v2\/categories?post=3"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.netexpertise.eu\/en\/wp-json\/wp\/v2\/tags?post=3"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}