Accounting on different mysql on different host
Hi we have 2 freeradius ver 1.1.0 server that on different locations. They use mysql servers(one master and one replica(read only) configuration) to download users' attributes. Every radius server point to own local mysql server. I have a probem with radius that point to mysql replica: it can't write accounting info on mysql. Is it possible to configure two different mysql servers on radius so it reads info from one and write accounting info on other? Any idea? Thank you Cheers Mau
Is it possible to configure two different mysql servers on radius so it reads info from one and write accounting info on other? Any idea? Thank you Cheers Mau
Sure simply define 2 instances of sql module( see sql.conf): Sql mysql-auth { ...} Sql mysql-acct { ...} And then declare the correct module in your authorize and accounting section Authorize { ... mysql-auth ... } Accoutning { ... mysql-acct ... } HTH, Thibault
participants (2)
-
Amendola Maurizio -
Thibault Le Meur