freeradius with multi mysql database and multi virtual server












0















I have tow NAS and I want to run freeradius server with tow database (one database for every NAS);
I have tow sql modules
the first one is SQL and the another one is SQL1
the SQL module configured to connect to radius database ,
SQL1 configured to connect to radius2 database .
in




/etc/freeradius/sites-enabled




folder I created new virtual server which has name student
so in that folder there are tow file (default, student);
I configured default to work with SQL module which connect to radius database,whereas I configured student to connect to SQL1 module which connect to radius2 database .
I added this unlang code in every virtual server file to get information from every database



Tmp-String-0  := "%{sql:SELECT value from radcheck WHERE attribute='CS-Total-Octets-Daily' and username='%{User-Name}'}"
Tmp-String-1 := "%{sql:SELECT sum(AcctInputOctets)+sum(AcctOutputOctets) AS
Total FROM radacct where DATE(AcctstartTime )= CURDATE() AND
radacct.username='%{User-Name}'}"


but my problem is that the student virtual server trying to get this data from radius database which is belong to SQL module even if I configured it to work with SQL1 .
why is that happen , and how can I solve it










share|improve this question



























    0















    I have tow NAS and I want to run freeradius server with tow database (one database for every NAS);
    I have tow sql modules
    the first one is SQL and the another one is SQL1
    the SQL module configured to connect to radius database ,
    SQL1 configured to connect to radius2 database .
    in




    /etc/freeradius/sites-enabled




    folder I created new virtual server which has name student
    so in that folder there are tow file (default, student);
    I configured default to work with SQL module which connect to radius database,whereas I configured student to connect to SQL1 module which connect to radius2 database .
    I added this unlang code in every virtual server file to get information from every database



    Tmp-String-0  := "%{sql:SELECT value from radcheck WHERE attribute='CS-Total-Octets-Daily' and username='%{User-Name}'}"
    Tmp-String-1 := "%{sql:SELECT sum(AcctInputOctets)+sum(AcctOutputOctets) AS
    Total FROM radacct where DATE(AcctstartTime )= CURDATE() AND
    radacct.username='%{User-Name}'}"


    but my problem is that the student virtual server trying to get this data from radius database which is belong to SQL module even if I configured it to work with SQL1 .
    why is that happen , and how can I solve it










    share|improve this question

























      0












      0








      0








      I have tow NAS and I want to run freeradius server with tow database (one database for every NAS);
      I have tow sql modules
      the first one is SQL and the another one is SQL1
      the SQL module configured to connect to radius database ,
      SQL1 configured to connect to radius2 database .
      in




      /etc/freeradius/sites-enabled




      folder I created new virtual server which has name student
      so in that folder there are tow file (default, student);
      I configured default to work with SQL module which connect to radius database,whereas I configured student to connect to SQL1 module which connect to radius2 database .
      I added this unlang code in every virtual server file to get information from every database



      Tmp-String-0  := "%{sql:SELECT value from radcheck WHERE attribute='CS-Total-Octets-Daily' and username='%{User-Name}'}"
      Tmp-String-1 := "%{sql:SELECT sum(AcctInputOctets)+sum(AcctOutputOctets) AS
      Total FROM radacct where DATE(AcctstartTime )= CURDATE() AND
      radacct.username='%{User-Name}'}"


      but my problem is that the student virtual server trying to get this data from radius database which is belong to SQL module even if I configured it to work with SQL1 .
      why is that happen , and how can I solve it










      share|improve this question














      I have tow NAS and I want to run freeradius server with tow database (one database for every NAS);
      I have tow sql modules
      the first one is SQL and the another one is SQL1
      the SQL module configured to connect to radius database ,
      SQL1 configured to connect to radius2 database .
      in




      /etc/freeradius/sites-enabled




      folder I created new virtual server which has name student
      so in that folder there are tow file (default, student);
      I configured default to work with SQL module which connect to radius database,whereas I configured student to connect to SQL1 module which connect to radius2 database .
      I added this unlang code in every virtual server file to get information from every database



      Tmp-String-0  := "%{sql:SELECT value from radcheck WHERE attribute='CS-Total-Octets-Daily' and username='%{User-Name}'}"
      Tmp-String-1 := "%{sql:SELECT sum(AcctInputOctets)+sum(AcctOutputOctets) AS
      Total FROM radacct where DATE(AcctstartTime )= CURDATE() AND
      radacct.username='%{User-Name}'}"


      but my problem is that the student virtual server trying to get this data from radius database which is belong to SQL module even if I configured it to work with SQL1 .
      why is that happen , and how can I solve it







      freeradius






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 14 '18 at 5:47









      Muhammad ahmadMuhammad ahmad

      93




      93
























          0






          active

          oldest

          votes











          Your Answer






          StackExchange.ifUsing("editor", function () {
          StackExchange.using("externalEditor", function () {
          StackExchange.using("snippets", function () {
          StackExchange.snippets.init();
          });
          });
          }, "code-snippets");

          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "1"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53293884%2ffreeradius-with-multi-mysql-database-and-multi-virtual-server%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes
















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Stack Overflow!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53293884%2ffreeradius-with-multi-mysql-database-and-multi-virtual-server%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Glorious Revolution

          Xamarin.iOS Cant Deploy on Iphone

          Dulmage-Mendelsohn matrix decomposition in Python