RadSQLRelay

[Marius Pesé]

-----Original Message-----
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.

  ? raddb/sites-available/copy-acct-to-home-server

> However if we start radsqlrelay

  Uh... why?

> (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.

  Alan DeKok.


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.

Thanks again

Marius


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html