Re: dialup admin ippool administraton
Am Donnerstag, den 06.04.2006, 16:58 +0300 schrieb Peter Nixon: We have developed a new sqlippool module which exclusively uses SQL (Tested with Postgresql) and doesn't require configuration in radiusd.conf (at least no more than the existing sql module) Great Peter. It must have been telepathy :) We are currently load testing this for stability and will be rolling it into production tomorrow if all goes well. At that point we will also commit it to FR cvs. That sounds good. I've just had a look into the snapshot from 9th of april - it's not there. I'm anxious to see it running on my machine. I suggest you wait a few days before you do too much more coding :-) Ok, good idea :) - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: mysql replication vs. radrelay
Besides the man page for radrelay says The functions of radrelay have been added to radiusd. I couldn't find any documentation about It shouldn't say that in the 1.1.1 release. radrelay should still be there. I know it's there and it's working great :) I'm only curious about this feature. Olaf -- Olaf Schäfer [EMAIL PROTECTED] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: mysql replication vs. radrelay
Am Donnerstag, den 06.04.2006, 15:48 -0600 schrieb Guy Fraser: Some prefer SQL replication, others suggest it is better to build it into the management system. If you have lots of people managing the accounts and you may need a different method, than someone No, fortunately I don't. Can you give us an idea, about how many people will be changing user info and at what rate you would be expecting additions, modifications and removals? This issue has to parts. The first is to change user info manually. There won't be more than 3 people. The second part is automated user info adding changing for prepaid user. The idea is that users can send a premium GSM short message, get there password via sms and are allowed to use our wlan hotspots for one hour. The rate of manual user-info change won't be very high (=5 per day). I expect the higher rate for the automated hotspot system. PS Have you had a chance to try my PHP radiusd.conf configuration parser ? Not yet! That's what I'm looking for. I've already started to do something in this direction regarding ip-pools. Where can I find your parser? regards, Olaf -- Olaf Schäfer [EMAIL PROTECTED] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: mysql replication vs. radrelay
My last experience with MySQL master-master replication and FreeRADIUS was that mysql corrupted my radacct table within 24 hours. This was 4-5 years That was exactly my concern. radrelay on the other hand is easy and works perfectly! That's right :) So I think I'm gonna use radrelay. regards, Olaf -- Olaf Schäfer [EMAIL PROTECTED] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
mysql replication vs. radrelay
hello, I have a redundant radius server setup with two radius servers. On each of the servers freeradius 1.1.1 and mysql is running. If the primary server goes down the AC falls back to the secondary server. To keep the databases (except the radacct table) synchronised I use MySQL replication. But I'm not sure which is the best way to replicate the accounting information: using radrelay or mysql-replication, too? Besides the man page for radrelay says The functions of radrelay have been added to radiusd. I couldn't find any documentation about this feature. Any hints? regards, olaf -- Olaf Schäfer [EMAIL PROTECTED] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
frontend for freeradius???
@Guy Fraser Hi, I read that you've been working 'on some PHP functions to manage FreeRadius'. I'm goning to do some efforts in the same direction: extending dialup admin with managing abilities for ip-pools, simultaneous-use, rlm_counter etc. Especially I'm interested in your functions to acquire information from configuration files. best regards, Olaf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup admin ippool administraton
But the configuration information like range-start etc. is still stored in the radiusd.conf. My idea was to put these configuration information for each ippool into the mysql-db. That may be harder to do. But if you can create a patch, it will be welcome. I'm afraid this exceeds my abilities :( Thus I resigned to the fact and have started to parse the radiusd.conf via PHP. Olaf Schaefer - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup admin ippool administraton
the sqlippool module in cvs does this.. This module sounds interesting - something I haven't take into my considerations keeping the dynamic ippool data in the sql-db, too. And it's obvious to do it this way using a primary and a backup server. But the configuration information like range-start etc. is still stored in the radiusd.conf. My idea was to put these configuration information for each ippool into the mysql-db. Some background information for better understanding :) My task is to migrate from MS-IAS to freeradius. Thus people are used to do administration tasks with a GUI. :) At least normal production administration tasks should be integrated within a GUI. Putting configuration information into a db would save the parsing and editing the radius.conf by dialup-admin scripts. best regards, Olaf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html