{"id":228,"date":"2009-05-17T22:07:27","date_gmt":"2009-05-17T20:07:27","guid":{"rendered":"http:\/\/www.netexpertise.eu\/fr\/?p=228"},"modified":"2021-10-06T21:49:34","modified_gmt":"2021-10-06T20:49:34","slug":"graphe-mrtg-nombre-sessions-radius","status":"publish","type":"post","link":"http:\/\/www.netexpertise.eu\/fr\/reseau\/freeradius\/graphe-mrtg-nombre-sessions-radius.html","title":{"rendered":"Graphe MRTG du nombre de sessions Radius"},"content":{"rendered":"\n<p>Il est possible d&rsquo;obtenir un graphe du nombre de sessions actives <a href=\"\/fr\/category\/reseau\/freeradius\">Freeradius<\/a> avec un simple script shell si les donn\u00e9es d&rsquo;accounting sont stock\u00e9es dans une base SQL.<br><br>Voici un exemple pour Mysql qui peut s&rsquo;adapter tr\u00e8s facilement \u00e0 d&rsquo;autres bases comme Oracle ou PostgreSQL. Consultez la liste compl\u00e8te des <a href=\"https:\/\/wiki.freeradius.org\/features\/Databases\">bases de donn\u00e9es support\u00e9es par Freeradius<\/a>.<br>&nbsp;<br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">#!\/bin\/bash\n\nSQL_USERNAME=utilisateur_radius\nSQL_DATABASE=radius\nSQL_PASSWORD=mot_de_passe\nSQL_SERVER=127.0.0.1\nSQL_ACCOUNTING_TABLE=radacct\nBACK_DAYS=5\n\nSESSIONS=`mysql -BN \\\n         -u$SQL_USERNAME \\\n         -p$SQL_PASSWORD \\\n         -h $SQL_SERVER $SQL_DATABASE \\\n         -e \\\n  \"SELECT COUNT(*) FROM $SQL_ACCOUNTING_TABLE \\\n  WHERE acctstoptime IS NULL \\\n  AND Acctstarttime &gt; NOW() - INTERVAL $BACK_DAYS DAY;\"`\n\necho $SESSIONS<\/code><\/pre>\n\n\n\n<p><br>Il reste toujours un certain nombre de sessions non termin\u00e9es en base \u00e0 cause de pertes ou de d\u00e9connexions r\u00e9seau entre le NAS et le serveur Radius. C&rsquo;est pourquoi les sessions datant de plus de $BACK_DAYS sont ignor\u00e9es pour retourner la valeur la plus pr\u00e9cise possible.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"\/images\/Freeradius_active_sessions.png\"><img src=\"\/images\/Freeradius_active_sessions.png\" alt=\"Graphique MRTG du nombre de sessions Freeradius\"\/><\/a><\/figure>\n\n\n\n<p><br>Ce script retourne le nombre de sessions actives. Il est ensuite possible de <a href=\"\/fr\/supervision\/mrtg-grapher-seulement-une-valeur.html\">cr\u00e9er un graphe<\/a> de cette valeur unique avec <a href=\"http:\/\/oss.oetiker.ch\/mrtg\/\">MRTG<\/a> qui en demande normalement deux.<br><br>Proposez \u00e9galement \u00e0 tous vos utilisateurs des <a href=\"\/fr\/reseau\/freeradius\/generateur-graphiques-trafic.html\">graphiques d&rsquo;upload\/download<\/a> de leur consommation r\u00e9seau Internet.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Il est possible d&rsquo;obtenir un graphe du nombre de sessions actives Freeradius avec un simple script shell si les donn\u00e9es d&rsquo;accounting sont stock\u00e9es dans une base SQL. Voici un exemple pour Mysql qui peut s&rsquo;adapter tr\u00e8s facilement \u00e0 d&rsquo;autres bases comme Oracle ou PostgreSQL. Consultez la liste compl\u00e8te des bases de donn\u00e9es support\u00e9es par Freeradius.&nbsp; [&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":[3,215],"tags":[403,455,219,434],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.13 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Netexpertise - Graphe MRTG du nombre de sessions Radius<\/title>\n<meta name=\"description\" content=\"Visualisez le nombre de sessions actives de votre serveur Freeradius sous forme de graphique avec MRTG\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.netexpertise.eu\/fr\/reseau\/freeradius\/graphe-mrtg-nombre-sessions-radius.html\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Netexpertise - Graphe MRTG du nombre de sessions Radius\" \/>\n<meta property=\"og:description\" content=\"Visualisez le nombre de sessions actives de votre serveur Freeradius sous forme de graphique avec MRTG\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.netexpertise.eu\/fr\/reseau\/freeradius\/graphe-mrtg-nombre-sessions-radius.html\" \/>\n<meta property=\"og:site_name\" content=\"Netexpertise\" \/>\n<meta property=\"article:published_time\" content=\"2009-05-17T20:07:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-06T20:49:34+00:00\" \/>\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\":\"https:\/\/www.netexpertise.eu\/fr\/reseau\/freeradius\/graphe-mrtg-nombre-sessions-radius.html\",\"url\":\"https:\/\/www.netexpertise.eu\/fr\/reseau\/freeradius\/graphe-mrtg-nombre-sessions-radius.html\",\"name\":\"Netexpertise - Graphe MRTG du nombre de sessions Radius\",\"isPartOf\":{\"@id\":\"https:\/\/www.netexpertise.eu\/fr\/#website\"},\"datePublished\":\"2009-05-17T20:07:27+00:00\",\"dateModified\":\"2021-10-06T20:49:34+00:00\",\"author\":{\"@id\":\"https:\/\/www.netexpertise.eu\/fr\/#\/schema\/person\/e398f0307e2b167f6b884c4953be2632\"},\"description\":\"Visualisez le nombre de sessions actives de votre serveur Freeradius sous forme de graphique avec MRTG\",\"breadcrumb\":{\"@id\":\"https:\/\/www.netexpertise.eu\/fr\/reseau\/freeradius\/graphe-mrtg-nombre-sessions-radius.html#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.netexpertise.eu\/fr\/reseau\/freeradius\/graphe-mrtg-nombre-sessions-radius.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.netexpertise.eu\/fr\/reseau\/freeradius\/graphe-mrtg-nombre-sessions-radius.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.netexpertise.eu\/fr\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Graphe MRTG du nombre de sessions Radius\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.netexpertise.eu\/fr\/#website\",\"url\":\"https:\/\/www.netexpertise.eu\/fr\/\",\"name\":\"Netexpertise\",\"description\":\"Syst\u00e8mes \/ R\u00e9seaux \/ DevOps\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.netexpertise.eu\/fr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.netexpertise.eu\/fr\/#\/schema\/person\/e398f0307e2b167f6b884c4953be2632\",\"name\":\"dave\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/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 - Graphe MRTG du nombre de sessions Radius","description":"Visualisez le nombre de sessions actives de votre serveur Freeradius sous forme de graphique avec MRTG","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":"https:\/\/www.netexpertise.eu\/fr\/reseau\/freeradius\/graphe-mrtg-nombre-sessions-radius.html","og_locale":"fr_FR","og_type":"article","og_title":"Netexpertise - Graphe MRTG du nombre de sessions Radius","og_description":"Visualisez le nombre de sessions actives de votre serveur Freeradius sous forme de graphique avec MRTG","og_url":"https:\/\/www.netexpertise.eu\/fr\/reseau\/freeradius\/graphe-mrtg-nombre-sessions-radius.html","og_site_name":"Netexpertise","article_published_time":"2009-05-17T20:07:27+00:00","article_modified_time":"2021-10-06T20:49:34+00:00","author":"dave","twitter_card":"summary_large_image","twitter_creator":"@netexpertise","twitter_site":"@netexpertise","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.netexpertise.eu\/fr\/reseau\/freeradius\/graphe-mrtg-nombre-sessions-radius.html","url":"https:\/\/www.netexpertise.eu\/fr\/reseau\/freeradius\/graphe-mrtg-nombre-sessions-radius.html","name":"Netexpertise - Graphe MRTG du nombre de sessions Radius","isPartOf":{"@id":"https:\/\/www.netexpertise.eu\/fr\/#website"},"datePublished":"2009-05-17T20:07:27+00:00","dateModified":"2021-10-06T20:49:34+00:00","author":{"@id":"https:\/\/www.netexpertise.eu\/fr\/#\/schema\/person\/e398f0307e2b167f6b884c4953be2632"},"description":"Visualisez le nombre de sessions actives de votre serveur Freeradius sous forme de graphique avec MRTG","breadcrumb":{"@id":"https:\/\/www.netexpertise.eu\/fr\/reseau\/freeradius\/graphe-mrtg-nombre-sessions-radius.html#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.netexpertise.eu\/fr\/reseau\/freeradius\/graphe-mrtg-nombre-sessions-radius.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.netexpertise.eu\/fr\/reseau\/freeradius\/graphe-mrtg-nombre-sessions-radius.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.netexpertise.eu\/fr"},{"@type":"ListItem","position":2,"name":"Graphe MRTG du nombre de sessions Radius"}]},{"@type":"WebSite","@id":"https:\/\/www.netexpertise.eu\/fr\/#website","url":"https:\/\/www.netexpertise.eu\/fr\/","name":"Netexpertise","description":"Syst\u00e8mes \/ R\u00e9seaux \/ DevOps","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.netexpertise.eu\/fr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/www.netexpertise.eu\/fr\/#\/schema\/person\/e398f0307e2b167f6b884c4953be2632","name":"dave","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/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\/228"}],"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=228"}],"version-history":[{"count":0,"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/posts\/228\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/media?parent=228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/categories?post=228"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/tags?post=228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}