{"id":1405,"date":"2019-01-25T18:09:27","date_gmt":"2019-01-25T18:09:27","guid":{"rendered":"https:\/\/draculaservers.com\/tutorials\/?p=1405"},"modified":"2021-11-14T20:36:41","modified_gmt":"2021-11-14T20:36:41","slug":"radius-bandwidth-sqlcounter-profiles","status":"publish","type":"post","link":"https:\/\/draculaservers.com\/tutorials\/radius-bandwidth-sqlcounter-profiles\/","title":{"rendered":"Creating Radius Profiles with Bandwidth Limits"},"content":{"rendered":"<p><strong>FreeRadius<\/strong> allows predefining sets of rules and assigning them to current or future users. Using the\u00a0<strong>Attribute-Value<\/strong> pair, we can customize the rules of the authentication, authorization, and accounting.<\/p>\n<p>In this guide, we&#8217;re going to create from <strong>daloRadius<\/strong> a <strong>Profile<\/strong> containing radius attributes that limit the users to 1 simultaneous session, requests accounting\u00a0updates every 10 minutes and refuses connection\u00a0if for users with more than 12GB used in the past 30 days.<\/p>\n<p><strong>Profiles<\/strong> are a great way of creating categories of users that have different limits and restrictions.<\/p>\n\n<h2 id=\"prerequisites\"><span id=\"Prerequisites\" class=\"ez-toc-section\">Prerequisites<\/span><\/h2>\n<p>Before we start, make sure that you already have a server with <a href=\"https:\/\/draculaservers.com\/tutorials\/freeradius-ubuntu-18-04-mysql\/\">Freeradius<\/a> + <a href=\"https:\/\/draculaservers.com\/tutorials\/freeradius-panel-daloradius-tutorial\/\">daloRadius<\/a> installed.\u00a0 If you don\u2019t, <a href=\"https:\/\/draculaservers.com\/freeradius.php\" target=\"_blank\" rel=\"noopener\">you can order a VPS with both installed<\/a> and have it delivered in minutes.<\/p>\n<div class=\"container custom-content-block\" style=\"background-color: #282a36; border-radius: 3px; padding: 20px 25px 35px 25px !important; margin-top: 60px; margin-bottom: 60px;\">\r\n<div class=\"row\">\r\n<div class=\"col-lg-12\">\r\n<p style=\"color: #72f672; font-weight: bold !important; font-family: Droid Sans Mono,'DroidSansMonoRegular','Courier New',monospace !important;\">Pre-Installed FreeRADIUS Servers<\/p>\r\n<p style=\"color: #72f672; font-weight: bold !important; font-family: Droid Sans Mono,'DroidSansMonoRegular','Courier New',monospace !important;\"><span style=\"color: #ffffff; font-weight: 300;\">Automatic FreeRADIUS 3 + daloRADIUS Set Up<\/span><\/p>\r\n\r\n<\/div>\r\n<div class=\"col-lg-12\">\r\n<p style=\"color: #60709f; font-size: 1em; font-family: Droid Sans Mono,'DroidSansMonoRegular','Courier New',monospace !important;\">Instantly deploy machines with FreeRADIUS + MySQL + daloRADIUS GUI Panel already set up, receive the credentials and take over from there! You also get our custom WHMCS Module to help you manage it from our dashboard.<\/p>\r\n\r\n<\/div>\r\n<div class=\"col-lg-12\">\r\n<p style=\"color: #ffffff; font-weight: bold !important; font-family: Droid Sans Mono,'DroidSansMonoRegular','Courier New',monospace !important;\">Pick one of our FreeRADIUS KVM plans<\/p>\r\n\r\n<\/div>\r\n<div class=\"col-lg-12\"><a role=\"button\" aria-pressed=\"true\" class=\"btn btn-primary btn-lg\" style=\"background-color: #58689e; color: #ffffff; box-shadow: 0 2px 2px 0 #3F51B5, 0 3px 1px -2px #3F51B5, 0 1px 5px 0 #3F51B5; font-family: Droid Sans Mono,'DroidSansMonoRegular','Courier New',monospace !important; font-weight: bold !important;\" href=\"https:\/\/draculaservers.com\/freeradius.php#choose-plan\" target=\"_blank\" rel=\"noopener\">Get started now<\/a><\/div>\r\n<\/div>\r\n\r\n<br \/>\r\n<p style=\"color: #ff5555; font-size: 0.9em; font-family: Droid Sans Mono,'DroidSansMonoRegular','Courier New',monospace !important;\">P.S. We're available for hire, if you need help. <a href=\"https:\/\/draculaservers.com\/members\/submitticket.php\">Click here to contact us<\/a>.<\/p>\r\n<\/div>\n<h2 id=\"step-1-log-in-daloradius\">Step 1 \u2013 Log in DaloRadius<\/h2>\n<p>Open a browser and go to your DaloRadius panel.<\/p>\n<p>On our servers, you can find at <code>http:\/\/server_IP_or_domain\/radpanel<\/code>. The login details are displayed the first time you log into your server via SSH. It should look like this:<\/p>\n<pre class=\"lang:default decode:true\">Radius Panel:\nhttp:\/\/server_IP_or_domain\/radpanel\nUser: administrator\nPass: MTUzYzllMTljMjk5OWU5ZDYyMmViZTkw\n<\/pre>\n<h2 id=\"step-2-open-the-profiles-page\">Step 2 \u2013 Open the Profiles page<\/h2>\n<p>Navigate to the Profiles page and click on the\u00a0<strong>New Profile\u00a0<\/strong>option. We&#8217;re going to create a profile that allows only 1 connection, so I&#8217;ve named it &#8220;<em>OneDevice&#8221;<\/em>. You can name it whatever you want.<\/p>\n<p><strong><a href=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/add_profile_1-e1548350569586.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1406 size-full\" src=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/add_profile_1-e1548350569586.jpg\" alt=\"\" width=\"700\" height=\"202\" srcset=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/add_profile_1-e1548350569586.jpg 700w, https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/add_profile_1-e1548350569586-300x87.jpg 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/strong><\/p>\n<h2 id=\"step-3-limit-simultaneous-sessions\">Step 3 \u2013 Limit simultaneous sessions<\/h2>\n<p>One of the most important features of FreeRadius is the attribute. We can use attributes to define what a user can or cannot do, create dynamic rules to decide if a user can be authenticated.<\/p>\n<p>In our example, we&#8217;re going to set the maximum simultaneous sessions to 1 for the users assigned to our new profile.<\/p>\n<p>Click on the <strong>Quickly Locate attribute with autocomplete checkbox\u00a0<\/strong>and type <strong>Simultaneous-Use<\/strong><a href=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/add_atttribute_simoultaneous-1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1409\" src=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/add_atttribute_simoultaneous-1.jpg\" alt=\"\" width=\"615\" height=\"279\" srcset=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/add_atttribute_simoultaneous-1.jpg 615w, https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/add_atttribute_simoultaneous-1-300x136.jpg 300w\" sizes=\"auto, (max-width: 615px) 100vw, 615px\" \/><\/a><\/p>\n<p>The autocomplete will suggest the\u00a0<strong>Simultaneous-Use<\/strong>\u00a0attribute. Select it and click\u00a0\u00a0<strong>Add Attribute.<\/strong><\/p>\n<p>Set the value to the maximum number of sessions. I&#8217;m going to set it to 1. Make sure that the operator is set to &#8220;<strong>:=<\/strong>&#8221; and the attribute target is &#8220;<strong>check<\/strong>&#8221;<\/p>\n<p><a href=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/attribute_ad.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1410\" src=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/attribute_ad.jpg\" alt=\"\" width=\"590\" height=\"102\" srcset=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/attribute_ad.jpg 590w, https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/attribute_ad-300x52.jpg 300w\" sizes=\"auto, (max-width: 590px) 100vw, 590px\" \/><\/a><\/p>\n<h2 id=\"step-4-set-accounting-intervals\">Step 4 \u2013 Set accounting intervals<\/h2>\n<p>Repeat the instructions from step 3 in order to add another attribute.\u00a0 This time, we&#8217;re going to add to the profile the &#8220;<strong>Acct-Interim-Interval<\/strong>&#8220;.<\/p>\n<p>Unlike the Simultaneous attribute, this one&#8217;s target must be set to <strong>reply.\u00a0<\/strong>It sets the interval for accounting updates. A value of 600 means that the client app will send to the radius server accounting updates about the user every 600 seconds.<\/p>\n<p><a href=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/reply_attributes.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1412\" src=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/reply_attributes.jpg\" alt=\"\" width=\"583\" height=\"229\" srcset=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/reply_attributes.jpg 583w, https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/reply_attributes-300x118.jpg 300w\" sizes=\"auto, (max-width: 583px) 100vw, 583px\" \/><\/a><\/p>\n<h2 id=\"step-5-limit-the-monthly-bandwidth\">Step 5 \u2013 Limit the monthly bandwidth<\/h2>\n<p>For the first two rules, we have used the default Freeradius attributes. In order to set a\u00a0bandwidth monthly quota, we need to create a custom attribute. This process can be used to create any custom accounting condition, using sqlcounter.<\/p>\n<p>Open an SSH session to your radius server and follow the steps below.<\/p>\n<pre class=\"lang:default decode:true\">cd \/etc\/freeradius\/3.0\/mods-enabled\nln -s ..\/mods-available\/sqlcounter sqlcounter<\/pre>\n<p>Edit the sqlcounter. The settings below create a new custom attribute that checks the bandwidth for the last 30 days.<\/p>\n<pre class=\"lang:default decode:true\">#define a new sqlcounter\nsqlcounter monthly_limit{ \n counter_name = 'Max-Total-Bandwidth'\n \n#define an attribute name. we will add this in daloRadius Profile\n check_name = 'Monthly-Bandwidth'\n \n sql_module_instance = sql\n key = 'User-Name'\n dialect = mysql\n reset = 30\n \n query = \"SELECT SUM(acctinputoctets) + SUM(acctoutputoctets) FROM \n          radacct WHERE UserName='%{${key}}'\"\n}<\/pre>\n<p>The sqlcounter is now defined! In the next step, we will add it to our Freeradius config file, under\u00a0<strong>authorize.<\/strong><\/p>\n<pre class=\"lang:default decode:true\">vim \/etc\/freeradius\/3.0\/sites-available\/default<\/pre>\n<pre class=\"lang:default decode:true\">authorize {\n..\nmonthly_limit\n..\n}<\/pre>\n<pre class=\"lang:default decode:true \">service freeradius reload<\/pre>\n<p>The custom attribute is now ready to be added to our profile from Daloradius like we did the previous steps. In the example below, the limit is set around <strong>12GB<\/strong>.<\/p>\n<p><a href=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/monthlylimit.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1414\" src=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/monthlylimit.jpg\" alt=\"\" width=\"600\" height=\"416\" srcset=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/monthlylimit.jpg 600w, https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/monthlylimit-300x208.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<h2 id=\"step-6-create-a-user-with-the-profile\">Step 6 \u2013 Create a user with the profile<\/h2>\n<p>When creating a new user, the profile can be selected from the\u00a0<strong>Group\u00a0<\/strong>dropdown. Now, all the attributes defined in the profile will apply to the user. Any changes done to the profile attributes will instantly apply to the member users of that group.<\/p>\n<p><a href=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/add_user.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1416\" src=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/add_user.jpg\" alt=\"\" width=\"733\" height=\"411\" srcset=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/add_user.jpg 733w, https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/add_user-300x168.jpg 300w\" sizes=\"auto, (max-width: 733px) 100vw, 733px\" \/><\/a><\/p>\n<h2 id=\"troubleshooting-sqlcounter\">Troubleshooting sqlcounter<\/h2>\n<p>Adding a new attribute and editing the Freeradius config files might generate some errors if we&#8217;re not careful. Here are some of the more common ones:<\/p>\n<h3 id=\"error-failed-to-create-the-pair-unknown-name\">Error: \u201c<strong>Failed to create the pair: Unknown name<\/strong>\u201d<\/h3>\n<p><span style=\"font-family: Roboto, Helvetica, Arial, sans-serif;\">Fix: Make sure you&#8217;ve added the newly created <\/span>sqlcounter<span style=\"font-family: Roboto, Helvetica, Arial, sans-serif;\"> name in the\u00a0<\/span><strong style=\"font-family: Roboto, Helvetica, Arial, sans-serif;\"><em>default\u00a0<\/em><\/strong><em style=\"font-family: Roboto, Helvetica, Arial, sans-serif;\">configuration file.\u00a0<\/em><\/p>\n<h3 id=\"error-reference-modules-sql-dialect-not-found\">Error: <strong>\u201cReference \u201c${modules.sql.dialect}\u201d not found<\/strong>\u201d<\/h3>\n<p>Fix: This one is caused by a Freeradius bug. In order to make it go away, you must specify the dialect of the database in the sqlcouter, as we did in <strong>Step 5.<\/strong><\/p>\n<h3 id=\"no-error-but-it-doesnt-work\">No error, but it doesn&#8217;t work<\/h3>\n<p>If there are no error messages but the custom sqlcounter attribute does not restrict user access, make sure that the attribute operator is set to &#8220;<strong>:=<\/strong>&#8221; and the target is set to &#8220;<strong>Reply&#8221;.<\/strong><\/p>\n<p>Please leave a comment on this post and notify us of the issues you experienced while following this tutorial and the solution if you managed to fix them. This will help other users that might also be facing the same problems as yourself.<\/p>\n<div class=\"container custom-content-block\" style=\"background-color: #282a36; border-radius: 3px; padding: 20px 25px 35px 25px !important; margin-top: 60px; margin-bottom: 60px;\">\r\n<div class=\"row\">\r\n<div class=\"col-lg-12\">\r\n<p style=\"color: #72f672; font-weight: bold !important; font-family: Droid Sans Mono,'DroidSansMonoRegular','Courier New',monospace !important;\">Pre-Installed FreeRADIUS Servers<\/p>\r\n<p style=\"color: #72f672; font-weight: bold !important; font-family: Droid Sans Mono,'DroidSansMonoRegular','Courier New',monospace !important;\"><span style=\"color: #ffffff; font-weight: 300;\">Automatic FreeRADIUS 3 + daloRADIUS Set Up<\/span><\/p>\r\n\r\n<\/div>\r\n<div class=\"col-lg-12\">\r\n<p style=\"color: #60709f; font-size: 1em; font-family: Droid Sans Mono,'DroidSansMonoRegular','Courier New',monospace !important;\">Instantly deploy machines with FreeRADIUS + MySQL + daloRADIUS GUI Panel already set up, receive the credentials and take over from there! You also get our custom WHMCS Module to help you manage it from our dashboard.<\/p>\r\n\r\n<\/div>\r\n<div class=\"col-lg-12\">\r\n<p style=\"color: #ffffff; font-weight: bold !important; font-family: Droid Sans Mono,'DroidSansMonoRegular','Courier New',monospace !important;\">Pick one of our FreeRADIUS KVM plans<\/p>\r\n\r\n<\/div>\r\n<div class=\"col-lg-12\"><a role=\"button\" aria-pressed=\"true\" class=\"btn btn-primary btn-lg\" style=\"background-color: #58689e; color: #ffffff; box-shadow: 0 2px 2px 0 #3F51B5, 0 3px 1px -2px #3F51B5, 0 1px 5px 0 #3F51B5; font-family: Droid Sans Mono,'DroidSansMonoRegular','Courier New',monospace !important; font-weight: bold !important;\" href=\"https:\/\/draculaservers.com\/freeradius.php#choose-plan\" target=\"_blank\" rel=\"noopener\">Get started now<\/a><\/div>\r\n<\/div>\r\n\r\n<br \/>\r\n<p style=\"color: #ff5555; font-size: 0.9em; font-family: Droid Sans Mono,'DroidSansMonoRegular','Courier New',monospace !important;\">P.S. We're available for hire, if you need help. <a href=\"https:\/\/draculaservers.com\/members\/submitticket.php\">Click here to contact us<\/a>.<\/p>\r\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>FreeRadius allows predefining sets of rules and assigning them to current or future users. Using the\u00a0Attribute-Value pair, we can customize the rules of the authentication, authorization, and accounting. In this guide, we&#8217;re going to create from daloRadius a Profile containing radius attributes that limit the users to 1 simultaneous session, requests accounting\u00a0updates every 10 minutes [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":1430,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,87],"tags":[54,53,89,55,88],"class_list":["post-1405","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-getting-started","category-radius","tag-daloradius","tag-freeradius","tag-profiles","tag-radius","tag-sqlcounter"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":6}},"featured_image_urls_v2":{"full":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/Creating-Radius-Profiles-with-Bandwidth-Limits.png",1024,512,false],"thumbnail":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/Creating-Radius-Profiles-with-Bandwidth-Limits-150x150.png",150,150,true],"medium":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/Creating-Radius-Profiles-with-Bandwidth-Limits-300x150.png",300,150,true],"medium_large":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/Creating-Radius-Profiles-with-Bandwidth-Limits-768x384.png",768,384,true],"large":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/Creating-Radius-Profiles-with-Bandwidth-Limits.png",1024,512,false],"1536x1536":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/Creating-Radius-Profiles-with-Bandwidth-Limits.png",1024,512,false],"2048x2048":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/Creating-Radius-Profiles-with-Bandwidth-Limits.png",1024,512,false],"pk-small":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/Creating-Radius-Profiles-with-Bandwidth-Limits-80x80.png",80,80,true],"pk-thumbnail":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/Creating-Radius-Profiles-with-Bandwidth-Limits-300x225.png",300,225,true]},"post_excerpt_stackable_v2":"<p>FreeRadius allows predefining sets of rules and assigning them to current or future users. Using the\u00a0Attribute-Value pair, we can customize the rules of the authentication, authorization, and accounting. In this guide, we&#8217;re going to create from daloRadius a Profile containing radius attributes that limit the users to 1 simultaneous session, requests accounting\u00a0updates every 10 minutes and refuses connection\u00a0if for users with more than 12GB used in the past 30 days. Profiles are a great way of creating categories of users that have different limits and restrictions. Prerequisites Before we start, make sure that you already have a server with Freeradius&hellip;<\/p>\n","category_list_v2":"<a href=\"https:\/\/draculaservers.com\/tutorials\/category\/getting-started\/\" rel=\"category tag\">Getting Started<\/a>, <a href=\"https:\/\/draculaservers.com\/tutorials\/category\/radius\/\" rel=\"category tag\">Radius<\/a>","author_info_v2":{"name":"Renfield","url":"https:\/\/draculaservers.com\/tutorials\/author\/george\/"},"comments_num_v2":"5 comments","yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Creating Radius Profiles with Bandwidth Limits - Dracula Servers Tutorials<\/title>\n<meta name=\"description\" content=\"An easy to follow guide on using sqlcounter to set bandwidth limits, simultaneous sessions attributes and creating profiles from daloradius.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/draculaservers.com\/tutorials\/radius-bandwidth-sqlcounter-profiles\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating Radius Profiles with Bandwidth Limits - Dracula Servers Tutorials\" \/>\n<meta property=\"og:description\" content=\"An easy to follow guide on using sqlcounter to set bandwidth limits, simultaneous sessions attributes and creating profiles from daloradius.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/draculaservers.com\/tutorials\/radius-bandwidth-sqlcounter-profiles\/\" \/>\n<meta property=\"og:site_name\" content=\"Dracula Servers Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-01-25T18:09:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-14T20:36:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/Creating-Radius-Profiles-with-Bandwidth-Limits.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Renfield\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Renfield\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/radius-bandwidth-sqlcounter-profiles\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/radius-bandwidth-sqlcounter-profiles\\\/\"},\"author\":{\"name\":\"Renfield\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#\\\/schema\\\/person\\\/1adeecc73fa440d944fcca7d16f1d1ea\"},\"headline\":\"Creating Radius Profiles with Bandwidth Limits\",\"datePublished\":\"2019-01-25T18:09:27+00:00\",\"dateModified\":\"2021-11-14T20:36:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/radius-bandwidth-sqlcounter-profiles\\\/\"},\"wordCount\":754,\"commentCount\":5,\"publisher\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/radius-bandwidth-sqlcounter-profiles\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/Creating-Radius-Profiles-with-Bandwidth-Limits.png\",\"keywords\":[\"daloradius\",\"freeradius\",\"profiles\",\"radius\",\"sqlcounter\"],\"articleSection\":[\"Getting Started\",\"Radius\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/radius-bandwidth-sqlcounter-profiles\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/radius-bandwidth-sqlcounter-profiles\\\/\",\"url\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/radius-bandwidth-sqlcounter-profiles\\\/\",\"name\":\"Creating Radius Profiles with Bandwidth Limits - Dracula Servers Tutorials\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/radius-bandwidth-sqlcounter-profiles\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/radius-bandwidth-sqlcounter-profiles\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/Creating-Radius-Profiles-with-Bandwidth-Limits.png\",\"datePublished\":\"2019-01-25T18:09:27+00:00\",\"dateModified\":\"2021-11-14T20:36:41+00:00\",\"description\":\"An easy to follow guide on using sqlcounter to set bandwidth limits, simultaneous sessions attributes and creating profiles from daloradius.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/radius-bandwidth-sqlcounter-profiles\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/radius-bandwidth-sqlcounter-profiles\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/radius-bandwidth-sqlcounter-profiles\\\/#primaryimage\",\"url\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/Creating-Radius-Profiles-with-Bandwidth-Limits.png\",\"contentUrl\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/Creating-Radius-Profiles-with-Bandwidth-Limits.png\",\"width\":1024,\"height\":512,\"caption\":\"radius_profiles_bandwidth_limit\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/radius-bandwidth-sqlcounter-profiles\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating Radius Profiles with Bandwidth Limits\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#website\",\"url\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/\",\"name\":\"Dracula Servers Tutorials\",\"description\":\"Dedicated Servers\",\"publisher\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#organization\",\"name\":\"Dracula Servers\",\"url\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/wp-content\\\/uploads\\\/2016\\\/06\\\/dracula_full_logo_smaller.png\",\"contentUrl\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/wp-content\\\/uploads\\\/2016\\\/06\\\/dracula_full_logo_smaller.png\",\"width\":1625,\"height\":200,\"caption\":\"Dracula Servers\"},\"image\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#\\\/schema\\\/person\\\/1adeecc73fa440d944fcca7d16f1d1ea\",\"name\":\"Renfield\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/54bc5a05d7622717ac87819cf2eb6394a561e2ce1fcecf3c5117a449cfea6c9f?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/54bc5a05d7622717ac87819cf2eb6394a561e2ce1fcecf3c5117a449cfea6c9f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/54bc5a05d7622717ac87819cf2eb6394a561e2ce1fcecf3c5117a449cfea6c9f?s=96&d=mm&r=g\",\"caption\":\"Renfield\"},\"sameAs\":[\"https:\\\/\\\/draculaservers.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating Radius Profiles with Bandwidth Limits - Dracula Servers Tutorials","description":"An easy to follow guide on using sqlcounter to set bandwidth limits, simultaneous sessions attributes and creating profiles from daloradius.","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:\/\/draculaservers.com\/tutorials\/radius-bandwidth-sqlcounter-profiles\/","og_locale":"en_US","og_type":"article","og_title":"Creating Radius Profiles with Bandwidth Limits - Dracula Servers Tutorials","og_description":"An easy to follow guide on using sqlcounter to set bandwidth limits, simultaneous sessions attributes and creating profiles from daloradius.","og_url":"https:\/\/draculaservers.com\/tutorials\/radius-bandwidth-sqlcounter-profiles\/","og_site_name":"Dracula Servers Tutorials","article_published_time":"2019-01-25T18:09:27+00:00","article_modified_time":"2021-11-14T20:36:41+00:00","og_image":[{"width":1024,"height":512,"url":"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/Creating-Radius-Profiles-with-Bandwidth-Limits.png","type":"image\/png"}],"author":"Renfield","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Renfield","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/draculaservers.com\/tutorials\/radius-bandwidth-sqlcounter-profiles\/#article","isPartOf":{"@id":"https:\/\/draculaservers.com\/tutorials\/radius-bandwidth-sqlcounter-profiles\/"},"author":{"name":"Renfield","@id":"https:\/\/draculaservers.com\/tutorials\/#\/schema\/person\/1adeecc73fa440d944fcca7d16f1d1ea"},"headline":"Creating Radius Profiles with Bandwidth Limits","datePublished":"2019-01-25T18:09:27+00:00","dateModified":"2021-11-14T20:36:41+00:00","mainEntityOfPage":{"@id":"https:\/\/draculaservers.com\/tutorials\/radius-bandwidth-sqlcounter-profiles\/"},"wordCount":754,"commentCount":5,"publisher":{"@id":"https:\/\/draculaservers.com\/tutorials\/#organization"},"image":{"@id":"https:\/\/draculaservers.com\/tutorials\/radius-bandwidth-sqlcounter-profiles\/#primaryimage"},"thumbnailUrl":"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/Creating-Radius-Profiles-with-Bandwidth-Limits.png","keywords":["daloradius","freeradius","profiles","radius","sqlcounter"],"articleSection":["Getting Started","Radius"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/draculaservers.com\/tutorials\/radius-bandwidth-sqlcounter-profiles\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/draculaservers.com\/tutorials\/radius-bandwidth-sqlcounter-profiles\/","url":"https:\/\/draculaservers.com\/tutorials\/radius-bandwidth-sqlcounter-profiles\/","name":"Creating Radius Profiles with Bandwidth Limits - Dracula Servers Tutorials","isPartOf":{"@id":"https:\/\/draculaservers.com\/tutorials\/#website"},"primaryImageOfPage":{"@id":"https:\/\/draculaservers.com\/tutorials\/radius-bandwidth-sqlcounter-profiles\/#primaryimage"},"image":{"@id":"https:\/\/draculaservers.com\/tutorials\/radius-bandwidth-sqlcounter-profiles\/#primaryimage"},"thumbnailUrl":"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/Creating-Radius-Profiles-with-Bandwidth-Limits.png","datePublished":"2019-01-25T18:09:27+00:00","dateModified":"2021-11-14T20:36:41+00:00","description":"An easy to follow guide on using sqlcounter to set bandwidth limits, simultaneous sessions attributes and creating profiles from daloradius.","breadcrumb":{"@id":"https:\/\/draculaservers.com\/tutorials\/radius-bandwidth-sqlcounter-profiles\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/draculaservers.com\/tutorials\/radius-bandwidth-sqlcounter-profiles\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/draculaservers.com\/tutorials\/radius-bandwidth-sqlcounter-profiles\/#primaryimage","url":"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/Creating-Radius-Profiles-with-Bandwidth-Limits.png","contentUrl":"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/01\/Creating-Radius-Profiles-with-Bandwidth-Limits.png","width":1024,"height":512,"caption":"radius_profiles_bandwidth_limit"},{"@type":"BreadcrumbList","@id":"https:\/\/draculaservers.com\/tutorials\/radius-bandwidth-sqlcounter-profiles\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/draculaservers.com\/tutorials\/"},{"@type":"ListItem","position":2,"name":"Creating Radius Profiles with Bandwidth Limits"}]},{"@type":"WebSite","@id":"https:\/\/draculaservers.com\/tutorials\/#website","url":"https:\/\/draculaservers.com\/tutorials\/","name":"Dracula Servers Tutorials","description":"Dedicated Servers","publisher":{"@id":"https:\/\/draculaservers.com\/tutorials\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/draculaservers.com\/tutorials\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/draculaservers.com\/tutorials\/#organization","name":"Dracula Servers","url":"https:\/\/draculaservers.com\/tutorials\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/draculaservers.com\/tutorials\/#\/schema\/logo\/image\/","url":"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2016\/06\/dracula_full_logo_smaller.png","contentUrl":"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2016\/06\/dracula_full_logo_smaller.png","width":1625,"height":200,"caption":"Dracula Servers"},"image":{"@id":"https:\/\/draculaservers.com\/tutorials\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/draculaservers.com\/tutorials\/#\/schema\/person\/1adeecc73fa440d944fcca7d16f1d1ea","name":"Renfield","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/54bc5a05d7622717ac87819cf2eb6394a561e2ce1fcecf3c5117a449cfea6c9f?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/54bc5a05d7622717ac87819cf2eb6394a561e2ce1fcecf3c5117a449cfea6c9f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/54bc5a05d7622717ac87819cf2eb6394a561e2ce1fcecf3c5117a449cfea6c9f?s=96&d=mm&r=g","caption":"Renfield"},"sameAs":["https:\/\/draculaservers.com"]}]}},"_links":{"self":[{"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/posts\/1405","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/comments?post=1405"}],"version-history":[{"count":2,"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/posts\/1405\/revisions"}],"predecessor-version":[{"id":2155,"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/posts\/1405\/revisions\/2155"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/media\/1430"}],"wp:attachment":[{"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/media?parent=1405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/categories?post=1405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/tags?post=1405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}