freeradius with multi mysql database and multi virtual server
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
asked Nov 14 '18 at 5:47
Muhammad ahmadMuhammad ahmad
93
add a comment |
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
asked Nov 14 '18 at 5:47
Muhammad ahmadMuhammad ahmad
93
add a comment |
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
asked Nov 14 '18 at 5:47
Muhammad ahmadMuhammad ahmad
93
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
freeradius
asked Nov 14 '18 at 5:47
Muhammad ahmadMuhammad ahmad
93
asked Nov 14 '18 at 5:47
Muhammad ahmadMuhammad ahmad
93
asked Nov 14 '18 at 5:47
Muhammad ahmadMuhammad ahmad
93
asked Nov 14 '18 at 5:47
Muhammad ahmadMuhammad ahmad
93
asked Nov 14 '18 at 5:47
Muhammad ahmadMuhammad ahmad
93
93
add a comment |
add a comment |
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
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
