Hi everyone, We are still struggling to get our FreeRadius2 servers running on CentOS5.5 to relay accounting packages to one another. Right now I have one FR2 server with a local mySQL database and one additional machine just running mysqld. The FR2 machine writes it's own database and the textfile with the queries without problems. 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? Regards Marius
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.
-----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
Marius Pesé wrote:
Thanks Alan, acct relay works fine now using proxy.conf and copy-acct-to-home-server!
That's good to hear.
One final question: Is it possible to replicate the Users table (mysql) using FreeRadius2?
No. MySQL has replication. You should use that.
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.
RADIUS isn't a good solution for user provisioning or replication. 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.
This is more a database topic. If you configure your two databases as master resp. slave you only have to feed the master ith the data. The slave gets it by database means. Norbert Wegener
participants (3)
-
Alan DeKok -
Marius Pesé -
Wegener, Norbert