{"id":33,"date":"2007-08-01T00:00:00","date_gmt":"2007-08-01T00:00:00","guid":{"rendered":"http:\/\/netexpertise\/fr\/?p=33"},"modified":"2021-10-11T21:11:51","modified_gmt":"2021-10-11T20:11:51","slug":"gigawords-freeradius","status":"publish","type":"post","link":"http:\/\/www.netexpertise.eu\/fr\/reseau\/freeradius\/gigawords-freeradius.html","title":{"rendered":"Gigawords sous Freeradius"},"content":{"rendered":"<div style=\"float:left; margin-right:15px; margin-top:0px;\">\n<script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<!-- 200x200, Netexpertise --><br \/>\n<ins class=\"adsbygoogle\" style=\"display:inline-block;width:200px;height:200px\" data-ad-client=\"ca-pub-6495750100906580\" data-ad-slot=\"1946825373\"><\/ins><br \/>\n<script><br \/>\n(adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/div>\n<p>Les compteurs pour l&rsquo;accounting Radius ont des limites bien d\u00e9finies comme toute norme qui se respecte. Les valeurs d\u00e9finies par le protocole sont enregistr\u00e9es dans des champs de 32 bits, c&rsquo;est-\u00e0-dire que la valeur maximum est de 4294967296 bits, soit un peu plus de 4GB. Si une session ne d\u00e9connecte pas pendant des jours, il y a de bonnes chances pour que le compteur revienne \u00e0 0 et du trafic ne sera pas pris en compte. Des extensions ont \u00e9t\u00e9 ajout\u00e9es au protocole pour supporter des plus grosses valeurs de trafic. Depuis <a href=\"http:\/\/www.freeradius.org\">Freeradius<\/a> 1.1.7, les Gigawords sont support\u00e9s par d\u00e9faut avec Mysql. Il est fortement recommend\u00e9 d&rsquo;installer cette derni\u00e8re version. Lors de la mise-\u00e0-jour, n&rsquo;oubliez pas d&rsquo;obtenir le nouveau sch\u00e9ma de la base dans <a href=\"\/common\/mysql.sql\">mysql.sql<\/a>. Changez AcctInputOctets et AcctOutputOctets de 32 \u00e0 64 bits. Cet article traite des versions de Freeradius inf\u00e9rieures \u00e0 1.1.7.<\/p>\n<p>&nbsp;<\/p>\n<h3>Avant de commencer<\/h3>\n<p>Nous assumons que Freeradius est install\u00e9 avec <a href=\"http:\/\/www.mysql.com\">Mysql<\/a> pour stocker les donn\u00e9es. Nous assumons aussi que le Network Access Server (NAS) supporte les gigawords, d\u00e9finis dans la <a href=\"http:\/\/www.ietf.org\/rfc\/rfc2869.txt\">RFC2869<\/a>. C&rsquo;est g\u00e9n\u00e9ralement le cas pour les routeurs Cisco. V\u00e9rifiez le manuel de votre NAS pour savoir comment l&rsquo;activer sur d&rsquo;autres types de mat\u00e9riels.<\/p>\n<p>&nbsp;<\/p>\n<h3>Activation de Gigawords sur le NAS<\/h3>\n<p>Une fois de plus, cette section traite de <a href=\"http:\/\/www.cisco.com\">Cisco<\/a> mais un jeu de commandes similaires est disponible sur la plupart des \u00e9quipements. L&rsquo;option Gigawords est activ\u00e9e par d\u00e9faut sur Cisco, c&rsquo;est pourquoi elle n&rsquo;appara\u00eet pas dans la configuration. Si c&rsquo;est le cas, ex\u00e9cutez la commande suivante pour l&rsquo;activer:<\/p>\n<pre>aaa accounting gigawords<\/pre>\n<p>On vous demandera de red\u00e9marrer le routeur pour que les nouveaux param\u00e8tres soient pris en compte. Ceci activeras les attributs Acct-Input-Gigawords et Acct-Output-Gigawords qui enregistrent combien de fois les compteurs sont revenus \u00e0 z\u00e9ro. Sachant cela, nous pouvons calculer les valeurs r\u00e9elles. La prochaine \u00e9tape est de cr\u00e9er une nouvelle colonne dans la base de donn\u00e9es.<\/p>\n<p>&nbsp;<\/p>\n<h3>Modification de la table Mysql<\/h3>\n<p>Les champs AcctInputOctets et AcctOutputOctets doivent \u00eatre convertis de 32 \u00e0 64 bits. Vous pouvez modifier ces chanmps avec un client Mysql quelconque ou <a href=\"http:\/\/www.phpmyadmin.net\">PhpMyAdmin<\/a><\/p>\n<pre>ALTER TABLE radacct ADD AcctInputGigawords TINYINT UNSIGNED DEFAULT 0;\nALTER TABLE radacct ADD AcctOutputGigawords TINYINT UNSIGNED DEFAULT 0;\n<\/pre>\n<p>&nbsp;<\/p>\n<h3>Modifications sur Freeradius<\/h3>\n<p>Le code SQL dans <i>sql.conf<\/i> doit \u00eatre modifi\u00e9 pour les requ\u00eates stop et update pour enregistrer les nouvelles valeurs dans la base de donn\u00e9es. Voici \u00e0 quoi elles ressemblent apr\u00e8s modification:<\/p>\n<pre>accounting_update_query = \"\n  UPDATE ${acct_table1}\n  SET AcctInputOctets = '%{Acct-Input-Gigawords:-0}' &lt;&lt; 32 | '%{Acct-Input-Octets:-0}',\n    AcctOutputOctets = '%{Acct-Output-Gigawords:-0}' &lt;&lt; 32 | '%{Acct-Output-Octets:-0}',\n    FramedIPAddress = '%{Framed-IP-Address}'\n  WHERE AcctSessionId = '%{Acct-Session-Id}'\n    AND UserName = '%{SQL-User-Name}'\n    AND NASIPAddress= '%{NAS-IP-Address}'\n    AND NASIPAddress= '%{NAS-IP-Address}'\n    AND AcctStopTime = 0\"\n\naccounting_stop_query =\"\n  UPDATE ${acct_table2}\n  SET AcctStopTime = '%S',\n    AcctSessionTime = '%{Acct-Session-Time}',\n    AcctInputOctets = '%{Acct-Input-Gigawords:-0}' &lt;&lt; 32 | '%{Acct-Input-Octets:-0}',\n    AcctOutputOctets = '%{Acct-Output-Gigawords:-0}' &lt;&lt; 32 | '%{Acct-Output-Octets:-0}',\n    AcctTerminateCause = '%{Acct-Terminate-Cause}',\n    AcctStopDelay = '%{Acct-Delay-Time}',\n    ConnectInfo_stop = '%{Connect-Info}'\n  WHERE AcctSessionId = '%{Acct-Session-Id}'\n    AND UserName = '%{SQL-User-Name}'\n    AND NASIPAddress = '%{NAS-IP-Address}'\n    AND AcctStopTime =0\"\n<\/pre>\n<div id=\"imgright\">\n<a href=\"http:\/\/www.amazon.fr\/gp\/product\/2212120079?ie=UTF8&amp;tag=netexpertis06-21&amp;linkCode=as2&amp;camp=1642&amp;creative=6746&amp;creativeASIN=2212120079\"><img border=\"0\" src=\"\/images\/41MTSQHEZVL._SL110_.jpg\"><\/a><img loading=\"lazy\" src=\"http:\/\/www.assoc-amazon.fr\/e\/ir?t=netexpertis06-21&amp;l=as2&amp;o=8&amp;a=2212120079\" width=\"1\" height=\"1\" border=\"0\" alt=\"\" style=\"border:none !important; margin:0px !important;\"><\/div>\n<p>Red\u00e9marrez le service Radius, et le tour est jou\u00e9!<\/p>\n<p>Ceci concat\u00e8ne les valeurs Gigawords et Octets en ajoutant 32 bits nuls \u00e0 la premi\u00e8re et en faisant un OU logique avec la deuxi\u00e8me.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Les compteurs pour l&rsquo;accounting Radius ont des limites bien d\u00e9finies comme toute norme qui se respecte. Les valeurs d\u00e9finies par le protocole sont enregistr\u00e9es dans des champs de 32 bits, c&rsquo;est-\u00e0-dire que la valeur maximum est de 4294967296 bits, soit un peu plus de 4GB. Si une session ne d\u00e9connecte pas pendant des jours, il [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[20,3],"tags":[16,408,403,407,404,9,7],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.13 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Netexpertise - Gigawords sous Freeradius<\/title>\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\/fr\/reseau\/freeradius\/gigawords-freeradius.html\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Netexpertise - Gigawords sous Freeradius\" \/>\n<meta property=\"og:description\" content=\"Les compteurs pour l&rsquo;accounting Radius ont des limites bien d\u00e9finies comme toute norme qui se respecte. Les valeurs d\u00e9finies par le protocole sont enregistr\u00e9es dans des champs de 32 bits, c&rsquo;est-\u00e0-dire que la valeur maximum est de 4294967296 bits, soit un peu plus de 4GB. Si une session ne d\u00e9connecte pas pendant des jours, il [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.netexpertise.eu\/fr\/reseau\/freeradius\/gigawords-freeradius.html\" \/>\n<meta property=\"og:site_name\" content=\"Netexpertise\" \/>\n<meta property=\"article:published_time\" content=\"2007-08-01T00:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-11T20:11:51+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.assoc-amazon.fr\/e\/ir?t=netexpertis06-21&amp;l=as2&amp;o=8&amp;a=2212120079\" \/>\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\/fr\/reseau\/freeradius\/gigawords-freeradius.html\",\"url\":\"http:\/\/www.netexpertise.eu\/fr\/reseau\/freeradius\/gigawords-freeradius.html\",\"name\":\"Netexpertise - Gigawords sous Freeradius\",\"isPartOf\":{\"@id\":\"http:\/\/www.netexpertise.eu\/fr\/#website\"},\"datePublished\":\"2007-08-01T00:00:00+00:00\",\"dateModified\":\"2021-10-11T20:11:51+00:00\",\"author\":{\"@id\":\"http:\/\/www.netexpertise.eu\/fr\/#\/schema\/person\/e398f0307e2b167f6b884c4953be2632\"},\"breadcrumb\":{\"@id\":\"http:\/\/www.netexpertise.eu\/fr\/reseau\/freeradius\/gigawords-freeradius.html#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/www.netexpertise.eu\/fr\/reseau\/freeradius\/gigawords-freeradius.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/www.netexpertise.eu\/fr\/reseau\/freeradius\/gigawords-freeradius.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"http:\/\/www.netexpertise.eu\/fr\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Gigawords sous Freeradius\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/www.netexpertise.eu\/fr\/#website\",\"url\":\"http:\/\/www.netexpertise.eu\/fr\/\",\"name\":\"Netexpertise\",\"description\":\"Syst\u00e8mes \/ R\u00e9seaux \/ DevOps\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/www.netexpertise.eu\/fr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"http:\/\/www.netexpertise.eu\/fr\/#\/schema\/person\/e398f0307e2b167f6b884c4953be2632\",\"name\":\"dave\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"http:\/\/www.netexpertise.eu\/fr\/#\/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 - Gigawords sous Freeradius","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\/fr\/reseau\/freeradius\/gigawords-freeradius.html","og_locale":"fr_FR","og_type":"article","og_title":"Netexpertise - Gigawords sous Freeradius","og_description":"Les compteurs pour l&rsquo;accounting Radius ont des limites bien d\u00e9finies comme toute norme qui se respecte. Les valeurs d\u00e9finies par le protocole sont enregistr\u00e9es dans des champs de 32 bits, c&rsquo;est-\u00e0-dire que la valeur maximum est de 4294967296 bits, soit un peu plus de 4GB. Si une session ne d\u00e9connecte pas pendant des jours, il [&hellip;]","og_url":"http:\/\/www.netexpertise.eu\/fr\/reseau\/freeradius\/gigawords-freeradius.html","og_site_name":"Netexpertise","article_published_time":"2007-08-01T00:00:00+00:00","article_modified_time":"2021-10-11T20:11:51+00:00","og_image":[{"url":"http:\/\/www.assoc-amazon.fr\/e\/ir?t=netexpertis06-21&amp;l=as2&amp;o=8&amp;a=2212120079"}],"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\/fr\/reseau\/freeradius\/gigawords-freeradius.html","url":"http:\/\/www.netexpertise.eu\/fr\/reseau\/freeradius\/gigawords-freeradius.html","name":"Netexpertise - Gigawords sous Freeradius","isPartOf":{"@id":"http:\/\/www.netexpertise.eu\/fr\/#website"},"datePublished":"2007-08-01T00:00:00+00:00","dateModified":"2021-10-11T20:11:51+00:00","author":{"@id":"http:\/\/www.netexpertise.eu\/fr\/#\/schema\/person\/e398f0307e2b167f6b884c4953be2632"},"breadcrumb":{"@id":"http:\/\/www.netexpertise.eu\/fr\/reseau\/freeradius\/gigawords-freeradius.html#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.netexpertise.eu\/fr\/reseau\/freeradius\/gigawords-freeradius.html"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/www.netexpertise.eu\/fr\/reseau\/freeradius\/gigawords-freeradius.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"http:\/\/www.netexpertise.eu\/fr"},{"@type":"ListItem","position":2,"name":"Gigawords sous Freeradius"}]},{"@type":"WebSite","@id":"http:\/\/www.netexpertise.eu\/fr\/#website","url":"http:\/\/www.netexpertise.eu\/fr\/","name":"Netexpertise","description":"Syst\u00e8mes \/ R\u00e9seaux \/ DevOps","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/www.netexpertise.eu\/fr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"http:\/\/www.netexpertise.eu\/fr\/#\/schema\/person\/e398f0307e2b167f6b884c4953be2632","name":"dave","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"http:\/\/www.netexpertise.eu\/fr\/#\/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\/fr\/wp-json\/wp\/v2\/posts\/33"}],"collection":[{"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/comments?post=33"}],"version-history":[{"count":0,"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/posts\/33\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/media?parent=33"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/categories?post=33"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/tags?post=33"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}