Re: dialup admin ippool administraton

2006-04-10 Thread Olaf Schäfer
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

2006-04-07 Thread Olaf Schäfer
  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

2006-04-07 Thread Olaf Schäfer
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

2006-04-07 Thread Olaf Schäfer

 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

2006-04-06 Thread Olaf Schäfer
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???

2006-03-31 Thread Olaf Schäfer
@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

2006-03-31 Thread Olaf Schäfer
  
  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

2006-03-29 Thread Olaf Schäfer
 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