SQL - How to use MSSQL for Authentication and MySQL for

Jeremiah Peterson gamerj at gmail.com
Mon May 12 19:27:35 CEST 2014


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 at 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20140512/0a5bbd52/attachment.html>


More information about the Freeradius-Users mailing list