Marius at mindspring.co.za
Thu Jul 8 12:27:19 CEST 2010
From: Of Alan DeKok
Sent: Wednesday, July 07, 2010 4:10 PM
To: FreeRadius users mailing list
Subject: Re: RadSQLRelay
Marius Pesé wrote:
> We are still struggling to get our FreeRadius2 servers running on
> CentOS5.5 to relay accounting packages to one another.
> However if we start radsqlrelay
> (radsqlrelay -d mysql -b freeradius -h
> 196.25.xxx.xxx -u root -p xxxx /var/log/radius/radacct/relay/sql-relay)
> it opens quite a few connections to the secondary database, but does not
> seem to use the text file with the queries, also it does not give any
> debug output, regardless of the –x option. Tried both path and path+file
> for the filename, hostname and IP for the the secondary database system.
> Without debugging output fairly hard to figure out. Anybody else know
> this problem?
I haven't used radsqlrelay for a long, long, time. The detail file
reader/write works fine.
Thanks Alan, acct relay works fine now using proxy.conf and copy-acct-to-home-server!
One final question: Is it possible to replicate the Users table (mysql) using FreeRadius2?
The idea is never having to worry if a new user was properly created on both servers (or deleted on both servers). Easiest way seems to be updating the php script to talk to two databases, but if FreeRadius can compare and update its user tables itself it might be even more reliable.
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
More information about the Freeradius-Users