sqlippool - duplicated ip address after freeradius restart

2012-10-23 Thread Antonio Modesto
Hi, I use radius sqlippool to assign IP address to my users, yesterday, after a restart on radius service, it started to assign IP address that were already in use to the users. I'm almost crazy here, I don't know what can be causing this, we have been using this scheme for at least three months

Re: sqlippool - duplicated ip address after freeradius restart

2012-10-23 Thread Antonio Modesto
2012/10/23 Phil Mayers p.may...@imperial.ac.uk On 23/10/12 11:52, Antonio Modesto wrote: Hi, I use radius sqlippool to assign IP address to my users, yesterday, after a restart on radius service, it started to assign IP address that were already in use to the users. I'm almost crazy here

Re: sqlippool - duplicated ip address after freeradius restart

2012-10-23 Thread Antonio Modesto
| | +---++--+--+--+---+-+--++--++-+ 6 rows in set (0.00 sec) 2012/10/23 Alan DeKok al...@deployingradius.com Antonio Modesto wrote: I noticed that there where 98 clients

Time based bandwidth control

2012-09-21 Thread Antonio Modesto
Hi, Is there any attribute on radius that I can use to provided time based bandwidth control? My boss asked me to implement a solution to double the client's rate limit during the night, we use mikrotik here. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Log rotation

2012-08-31 Thread Antonio Modesto
2012/8/29 Fajar A. Nugraha l...@fajar.net On Wed, Aug 29, 2012 at 9:10 PM, Antonio Modesto mode...@isimples.com.br wrote: Hi, Today I'm rotating my log files with a script that runs every night, the problem is that it must stop the radiusd process, rename the file, create a new one

Log rotation

2012-08-29 Thread Antonio Modesto
Hi, Today I'm rotating my log files with a script that runs every night, the problem is that it must stop the radiusd process, rename the file, create a new one then start radiusd again. Is there a way to do that transparently? Via syslog or something else? Regards. - List

Little problem with sqlippool

2012-08-21 Thread Antonio Modesto
Hi, I'm testing sqlippool, so far it's working well, but I'm with a exception that I haven't thought about it before. We use radius to authenticate the clients on wireless access points and with PPPoE, and now I started using sqlippool to dynamically distribute the IP's and BGP to announce the

Re: Little problem with sqlippool

2012-08-21 Thread Antonio Modesto
2012/8/21 Phil Mayers p.may...@imperial.ac.uk On 21/08/12 16:20, Antonio Modesto wrote: Hi, I'm testing sqlippool, so far it's working well, but I'm with a exception that I haven't thought about it before. We use radius to authenticate the clients on wireless access points

Re: Little problem with sqlippool

2012-08-21 Thread Antonio Modesto
I've configured it this way: if (Framed-Protocol == PPP) { sqlippool } It's working so far, I'll do some more tests. Thanks a lot. 2012/8/21 Antonio Modesto mode...@isimples.com.br 2012/8/21 Phil Mayers p.may...@imperial.ac.uk On 21/08/12 16:20, Antonio

rlm_sql Error

2012-08-13 Thread Antonio Modesto
Hi, Here in the ISP which I work we have a Freeradius 1.X in production, and a 2.X that we're testing to replace the old one. On both Radius we get the following error sometimes, What can be causing this? The SQL Database is in the same server of freeradius 1.X, but the load is low, we have

Re: rlm_sql Error

2012-08-13 Thread Antonio Modesto
2012/8/13 alan buxey a.l.m.bu...@lboro.ac.uk Hi, Here in the ISP which I work we have a Freeradius 1.X in production, and a 2.X that we're testing to replace the old one. On both Radius we get the following error sometimes, What can be causing this? The SQL

Re: rlm_sql Error

2012-08-13 Thread Antonio Modesto
2012/8/13 Alan DeKok al...@deployingradius.com Antonio Modesto wrote: My tables is using MyISAM engine, as this server is running freeradius 1.X, it's quite old. The problem is that I've dumped my database to another server to do some tests, and tried to alter the engine to see how long

[OFF] InnoDB x MyISAM

2012-08-08 Thread Antonio Modesto
Hi, I'm thinking about changing the engine of the radacct and radippool tables from MyISAM to InnoDB, as these tables suffers with a lot of updates and, in my head, row locking in this case could be better than table locking. Is that right? Thanks in advance. - List info/subscribe/unsubscribe?

Re: [OFF] InnoDB x MyISAM

2012-08-08 Thread Antonio Modesto
Good, thanks guys! 2012/8/8 Fajar A. Nugraha l...@fajar.net On Wed, Aug 8, 2012 at 7:38 PM, Antonio Modesto mode...@isimples.com.br wrote: Hi, I'm thinking about changing the engine of the radacct and radippool tables from MyISAM to InnoDB, as these tables suffers with a lot

Radius Timeout instead of Access-Reject

2012-08-07 Thread Antonio Modesto
Hi, I work at an ISP in Brazil, our main radius server is running freeradius 1.X. I'm configuring a new server with freeradius 2.X and doing some tests to see if I find any problem before putting it on production. So far I've found a little problem that doesn't disable me to put it in production,

Re: Radius Timeout instead of Access-Reject

2012-08-07 Thread Antonio Modesto
freeradius 2.x to take longer to reply the requests 2012/8/7 Alan DeKok al...@deployingradius.com Antonio Modesto wrote: Hi, I work at an ISP in Brazil, our main radius server is running freeradius 1.X. I'm configuring a new server with freeradius 2.X and doing some tests to see if I

Cleartext-Password x User-Password

2012-04-24 Thread Antonio Modesto
Hi, I am migrating my freeradius to freeradius 2.x, so time ago Alan told me to change the User-Password to Cleartext-Password. Is there anything more that I need to change in my schema to migrate to 2.x version? Thanks. - List info/subscribe/unsubscribe? See

[OFF-TOPIC] Freeradius and MySQL Cluster

2012-02-27 Thread Antonio Modesto
Good Morning, I am doing some tests with MySQL Cluster, and I want to migrate my backend to it. But I am having some troubles/doubts with it. When I use a empty radius database, it works ok. But when I try to import my current database to MySQL with the NDBCLUSTER engine, I got this error: ERROR

Re: [OFF-TOPIC] Freeradius and MySQL Cluster

2012-02-27 Thread Antonio Modesto
On Mon, 2012-02-27 at 20:20 +0700, Fajar A. Nugraha wrote: 2012/2/27 Antonio Modesto mode...@isimples.com.br: Good Morning, I am doing some tests with MySQL Cluster, and I want to migrate my backend to it. But I am having some troubles/doubts with it. When I use a empty radius database

Re: [OFF-TOPIC] Freeradius and MySQL Cluster

2012-02-27 Thread Antonio Modesto
On Mon, 2012-02-27 at 22:09 +0700, Fajar A. Nugraha wrote: On Mon, Feb 27, 2012 at 9:48 PM, Antonio Modesto mode...@isimples.com.br wrote: I didn't know about the memory limit. So if I have a 10GB database, Must I have, at least, 10GB configured for each cluster node? David posted a link

Re: Newbie and Sqlippool

2012-02-01 Thread Antonio Modesto
On Tue, 2012-01-31 at 21:00 +0100, Alan DeKok wrote: Antonio Modesto wrote: I am trying to test sqlippool on freeradius, but i've found that the documentation explains very well how to implement it, but it doesn't explain very well how I can set a user or a group to use this pool

Re: Newbie and Sqlippool

2012-02-01 Thread Antonio Modesto
On Wed, 2012-02-01 at 09:19 -0200, Antonio Modesto wrote: On Tue, 2012-01-31 at 21:00 +0100, Alan DeKok wrote: Antonio Modesto wrote: I am trying to test sqlippool on freeradius, but i've found that the documentation explains very well how to implement it, but it doesn't

Re: Newbie and Sqlippool

2012-02-01 Thread Antonio Modesto
On Wed, 2012-02-01 at 13:31 +0100, Alan DeKok wrote: Antonio Modesto wrote: That's wrong. Use Cleartext-Password := instead of User-Password == The problem is that my production server is running Freeradius 1.8, and it uses the Attribute User-Password No. The change

Re: Newbie and Sqlippool

2012-02-01 Thread Antonio Modesto
On Wed, 2012-02-01 at 19:53 +0700, Fajar A. Nugraha wrote: 2012/2/1 Antonio Modesto mode...@isimples.com.br: On Wed, 2012-02-01 at 09:19 -0200, Antonio Modesto wrote: On Tue, 2012-01-31 at 21:00 +0100, Alan DeKok wrote: Antonio Modesto wrote: I am trying to test sqlippool

Re: Newbie and Sqlippool

2012-02-01 Thread Antonio Modesto
On Wed, 2012-02-01 at 14:24 +0100, Alan DeKok wrote: Antonio Modesto wrote: Sorry for the ignorance, but where must I put this section? Can I just put it anywhere in radiusd.conf or it must be inside another section? You don't. I had assumed you were running version 2. Not in my

Re: Newbie and Sqlippool

2012-02-01 Thread Antonio Modesto
On Wed, 2012-02-01 at 20:59 +0700, Fajar A. Nugraha wrote: 2012/2/1 Antonio Modesto mode...@isimples.com.br: But I don't want to use per-user pools, if it is possible, the better solution for me would be setting the pool based on some information of the NAS, because my routing topology

Newbie and Sqlippool

2012-01-31 Thread Antonio Modesto
Hi, I am trying to test sqlippool on freeradius, but i've found that the documentation explains very well how to implement it, but it doesn't explain very well how I can set a user or a group to use this pool. Can someone explain me how can I do this? i've set up a pool called 'main_pool' in