RE: SQL - How to use MSSQL for Authentication and MySQL for
Greetings, * I have searched for some time but cannot seem to find an answer to this, but I am sure it can be done. * I use a MSSQL database on a separate server for Authentication and that is working well. * I want to use a MySQL database on a third server for Accounting. * Everything I have searched shows how to configure it for one or the other but not both. * I am trying to find out how to accomplish this, so if anyone has some insight, please do share. * Thanks in advance. * Jer We use two different databases as well. Our setup is on the NAS itself. Point RADIUS auth to one server IP and set RADIUS accouting to the other server. Mike P. *************************************************
Hi,
* I use a MSSQL database on a separate server for Authentication and that is working well.
* I want to use a MySQL database on a third server for Accounting.
* Everything I have searched shows how to configure it for one or the other but not both.
use different instantiation names for each of your databases eg sql sql-MSSQL { configure MSSQL here } sql sql-mysql { configure MYSQL here } now in the authentication section call 'sql-MSSQL' instead of just 'sql' now in accounting section call 'sql-mysql' instead of just 'sql' alan
Thats basically what I am trying to do and I was unable to find out how. After your answer, it led me to some more searching that revealed the answer copy sql.conf to sql1.conf copy sql.conf to sql2.conf inside sql1.conf change sql { to sql sql1 { same with sql2.conf then I can use sql1 and sql2 under authenticate and accouting. Thanks again On Mon, May 12, 2014 at 10:32 AM, Mike Poole <mpoole@pavlovmedia.com> wrote:
Greetings,
- I have searched for some time but cannot seem to find an answer to this, but I am sure it can be done.
- I use a MSSQL database on a separate server for Authentication and that is working well.
- I want to use a MySQL database on a third server for Accounting.
- Everything I have searched shows how to configure it for one or the other but not both.
- I am trying to find out how to accomplish this, so if anyone has some insight, please do share.
- Thanks in advance.
- Jer
We use two different databases as well. Our setup is on the NAS itself. Point RADIUS auth to one server IP and set RADIUS accouting to the other server.
Mike P.
*************************************************
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi,
Thats basically what I am trying to do and I was unable to find out how.
the concepts of the server are very clear...but just not easy to find if you havent read the docs
After your answer, it led me to some more searching that revealed the answer
_an_ answer. there is no such thing as _the_ answer for FreeRADIUS - its comprehensibly flexible
inside sql1.conf change sql { to sql sql1 {
yes, a named module instance - as per http://wiki.freeradius.org/modules/Rlm_sql#Instances alan
On Mon, May 12, 2014 at 12:40 PM, <A.L.M.Buxey@lboro.ac.uk> wrote:
Hi,
Thats basically what I am trying to do and I was unable to find out how.
the concepts of the server are very clear...but just not easy to find if you havent read the docs
Yes, I quite obviously missed that part when reading the docs. thank you for pointing that out.
After your answer, it led me to some more searching that revealed the answer
_an_ answer. there is no such thing as _the_ answer for FreeRADIUS - its comprehensibly flexible
Again, such incredible insight. "after your answer" "after your reply" .... I didn't see your reply Alan, I saw Mike's reply. I apologize for calling is reply an answer. He answered a question. Therefore I called it an "answer". I guess I should have used "reply"
inside sql1.conf change sql { to sql sql1 {
yes, a named module instance - as per
Thank you for the reference. That didn't turn up in the Google searches that I did because I wasn't looking for it the right way. I did figure it out though after I posted. Sometimes you have to post something to figure it out. But thank you for the help, I do see that you answered .... sorry .. REPLIED.. to the question as well which would have given me the answer i was .. sorry .. reply i was looking for.
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (3)
-
A.L.M.Buxey＠lboro.ac.uk -
Jeremiah Peterson -
Mike Poole