Freeradius mysql acct copy
Hi. I need to copy acct packets to my billing server and save acct in standart freeradius radacct table in mysql. I'm saving acct in radacct table now, but can't duplicate them to other (billing) radius server. I've tried to use copy-acct-to-home-server but no success. As I understand, virtual server from copy-acct-to-home-server use a detail files to read acct information from default server. Is the way to don't use detail file and use mysql? Regards, Alexander.
On Thu, Mar 31, 2011 at 2:45 PM, Alexander Kosykh <avkosykh@gmail.com> wrote:
Hi.
I need to copy acct packets to my billing server and save acct in standart freeradius radacct table in mysql. I'm saving acct in radacct table now, but can't duplicate them to other (billing) radius server. I've tried to use copy-acct-to-home-server but no success. As I understand, virtual server from copy-acct-to-home-server use a detail files to read acct information from default server. Is the way to don't use detail file and use mysql?
See http://freeradius.1045715.n5.nabble.com/Sending-accounting-packets-to-more-t... -- Fajar
Is it right that my freeradius go down after home server was down? Regards, Alexander. 2011/3/31 Fajar A. Nugraha <list@fajar.net>
On Thu, Mar 31, 2011 at 2:45 PM, Alexander Kosykh <avkosykh@gmail.com> wrote:
Hi.
I need to copy acct packets to my billing server and save acct in
standart freeradius radacct table in mysql. I'm saving acct in radacct table now, but can't duplicate them to other (billing) radius server. I've tried to use copy-acct-to-home-server but no success. As I understand, virtual server from copy-acct-to-home-server use a detail files to read acct information from default server. Is the way to don't use detail file and use mysql?
See http://freeradius.1045715.n5.nabble.com/Sending-accounting-packets-to-more-t...
-- Fajar
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Alexander Kosykh wrote:
I need to copy acct packets to my billing server and save acct in standart freeradius radacct table in mysql. I'm saving acct in radacct table now, but can't duplicate them to other (billing) radius server. I've tried to use copy-acct-to-home-server but no success.
See the FAQ for "it doesn't work".
As I understand, virtual server from copy-acct-to-home-server use a detail files to read acct information from default server. Is the way to don't use detail file and use mysql?
No. Alan DeKok.
On Thu, Mar 31, 2011 at 4:00 PM, Alan DeKok <aland@deployingradius.com> wrote:
Alexander Kosykh wrote:
As I understand, virtual server from copy-acct-to-home-server use a detail files to read acct information from default server. Is the way to don't use detail file and use mysql?
No.
There's actually something interesting about that. I just had a chat with a colleague that managed a system with similar setup (acct to local mysql and copy to remote), the biggest difference was that he used FR 1.1.3 (this system was created many years ago, and back then the version was current). He actually used a setup like this on proxy.conf realm remoterealm { type = radius authhost = 10.11.12.1:1812 accthost = 10.11.12.1:1813 accthost = LOCAL secret = remotesecret nostrip } The biggest difference there from the standard configuration (example from https://github.com/alandekok/freeradius-server/blob/release_1_1_3/raddb/prox...), is that he used two "accthost" lines. And it worked :P Can you confirm that this is bug, that it shouldn't behave like that (since the example proxy.conf doesn't mention anything about two accthost line). Another thing, while reading http://wiki.freeradius.org/Proxy , the link for "doc/proxy" is broken (it should be doc/proxy.rst). Edit function in wiki is available for registered users only, while create account function is disabled, so I can't fix it. -- Fajar
Fajar A. Nugraha wrote:
Can you confirm that this is bug, that it shouldn't behave like that (since the example proxy.conf doesn't mention anything about two accthost line).
In 1.1.3, multiple "accthost" lines do fail-over from one to the other.
Another thing, while reading http://wiki.freeradius.org/Proxy , the link for "doc/proxy" is broken (it should be doc/proxy.rst). Edit function in wiki is available for registered users only, while create account function is disabled, so I can't fix it.
I'll take a lok. Alan DeKok.
Hi, This configuration is correctly? Nowadays, could I use this to copy acct to a remote server? Thanks. -- View this message in context: http://freeradius.1045715.n5.nabble.com/Freeradius-mysql-acct-copy-tp4272880... Sent from the FreeRadius - User mailing list archive at Nabble.com.
participants (4)
-
Alan DeKok -
Alexander Kosykh -
Fajar A. Nugraha -
tonimanel