Re: Mikrotik-Rate-Limit issue

2011-05-02 Thread speedlnx
The value for my test user is the follow: 512k/2048k 512k/2048k 192k/960k 8/8
1 128k/128k 


The mikrotik documentation say:

Mikrotik-Rate-Limit - Datarate limitation for clients. Format is:
rx-rate[/tx-rate] [rx-burst-rate[/tx-burst-rate]
[rx-burst-threshold[/tx-burst-threshold] [rx-burst-time[/tx-burst-time]
[priority] [rx-rate-min[/tx-rate-min from the point of view of the
router (so rx is client upload, and tx is client download). All rates
should be numbers with optional 'k' (1,000s) or 'M' (1,000,000s). If tx-rate
is not specified, rx-rate is as tx-rate too. Same goes for tx-burst-rate and
tx-burst-threshold and tx-burst-time. If both rx-burst-threshold and
tx-burst-threshold are not specified (but burst-rate is specified), rx-rate
and tx-rate is used as burst thresholds. If both rx-burst-time and
tx-burst-time are not specified, 1s is used as default. Priority takes
values 1..8, where 1 implies the highest priority, but 8 - the lowest. If
rx-rate-min and tx-rate-min are not specified rx-rate and tx-rate values are
used. The rx-rate-min and tx-rate-min values can not exceed rx-rate and
tx-rate values.

--
View this message in context: 
http://freeradius.1045715.n5.nabble.com/Mikrotik-Rate-Limit-issue-tp4363178p4364161.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Mikrotik-Rate-Limit issue

2011-05-02 Thread Alan DeKok
speedlnx wrote:
 Hello, i'm migrating from freeradius 1.x to freeradius 2.1.10 on debian.
 I've replicated all the configuration i have on the old radius to the new
 and I import a dump of the mysql database on the new mysql server but i've
 an issue when i try to authenticate my users:

  Edit /usr/local/share/freeradius/dictionary

  Add a line $INCLUDE dictionary.mikrotik

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


Re: Mikrotik-Rate-Limit issue

2011-05-02 Thread speedlnx
Thank you. It works now! 

--
View this message in context: 
http://freeradius.1045715.n5.nabble.com/Mikrotik-Rate-Limit-issue-tp4363178p4365873.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Mikrotik-Rate-Limit issue

2011-05-01 Thread speedlnx
Hello, i'm migrating from freeradius 1.x to freeradius 2.1.10 on debian.
I've replicated all the configuration i have on the old radius to the new
and I import a dump of the mysql database on the new mysql server but i've
an issue when i try to authenticate my users:

radtest xxx.xx xx localhost 1812 mysupersecretpwd

Sending Access-Request of id 18 to 127.0.0.1 port 1812
User-Name = xxx.xx
User-Password = xx
NAS-IP-Address = 127.0.1.1
NAS-Port = 1812
rad_recv: Access-Reject packet from host 127.0.0.1 port 1812, id=18,
length=20


The freeradius debug give me this:

Sun May  1 13:24:02 2011 : Info: Ready to process requests.
rad_recv: Access-Request packet from host 127.0.0.1 port 36449, id=18,
length=64
User-Name = xxx.xx
User-Password = xx
NAS-IP-Address = 127.0.1.1
NAS-Port = 1812
Sun May  1 13:24:29 2011 : Info: # Executing section authorize from file
/etc/freeradius/radiusd.conf
Sun May  1 13:24:29 2011 : Info: +- entering group authorize {...}
Sun May  1 13:24:29 2011 : Info: ++[preprocess] returns ok
Sun May  1 13:24:29 2011 : Info: ++[chap] returns noop
Sun May  1 13:24:29 2011 : Info: ++[mschap] returns noop
Sun May  1 13:24:29 2011 : Info: [suffix] No '@' in User-Name =
xxx.xx, looking up realm NULL
Sun May  1 13:24:29 2011 : Info: [suffix] No such realm NULL
Sun May  1 13:24:29 2011 : Info: ++[suffix] returns noop
Sun May  1 13:24:29 2011 : Info: [sql]  expand: %{User-Name} -
xxx.xx
Sun May  1 13:24:29 2011 : Info: [sql] sql_set_user escaped user --
'xxx.xx'
Sun May  1 13:24:29 2011 : Debug: rlm_sql (sql): Reserving sql socket id: 4
Sun May  1 13:24:29 2011 : Info: [sql]  expand: SELECT
id,UserName,Attribute,Value,op FROM radcheck WHERE Username =
'%{SQL-User-Name}' and attivato=1 ORDER BY id - SELECT
id,UserName,Attribute,Value,op FROM radcheck WHERE Username =
'xxx.xx' and attivato=1 ORDER BY id
Sun May  1 13:24:29 2011 : Debug: WARNING: Found User-Password == 
Sun May  1 13:24:29 2011 : Debug: WARNING: Are you sure you don't mean
Cleartext-Password?
Sun May  1 13:24:29 2011 : Debug: WARNING: See man rlm_pap for more
information.
Sun May  1 13:24:29 2011 : Info: [sql] User found in radcheck table
Sun May  1 13:24:29 2011 : Info: [sql]  expand: SELECT
id,UserName,Attribute,Value,op FROM radreply WHERE Username =
'%{SQL-User-Name}' ORDER BY id - SELECT id,UserName,Attribute,Value,op FROM
radreply WHERE Username = 'xxx.xx' ORDER BY id
Sun May  1 13:24:29 2011 : Error: rlm_sql: Failed to create the pair:
Invalid octet string 512k/2048k 512k/2048k 192k/960k 8/8 1 128k/128k for
attribute name Mikrotik-Rate-Limit
Sun May  1 13:24:29 2011 : Error: rlm_sql (sql): Error getting data from
database
Sun May  1 13:24:29 2011 : Error: [sql] SQL query error; rejecting user
Sun May  1 13:24:29 2011 : Debug: rlm_sql (sql): Released sql socket id: 4
Sun May  1 13:24:29 2011 : Info: ++[sql] returns fail
Sun May  1 13:24:29 2011 : Info: Delaying reject of request 0 for 1 seconds
Sun May  1 13:24:29 2011 : Debug: Going to the next request
Sun May  1 13:24:29 2011 : Debug: Waking up in 0.9 seconds.
Sun May  1 13:24:30 2011 : Info: Sending delayed reject for request 0
Sending Access-Reject of id 18 to 127.0.0.1 port 36449
Sun May  1 13:24:30 2011 : Debug: Waking up in 4.9 seconds.
Sun May  1 13:24:35 2011 : Info: Cleaning up request 0 ID 18 with timestamp
+27
Sun May  1 13:24:35 2011 : Info: Ready to process requests.

I've of course the mikrotik dictionary with the correct attribute and
there's a record in the database with the rate limit for the user in
radreply table.

Any idea?

--
View this message in context: 
http://freeradius.1045715.n5.nabble.com/Mikrotik-Rate-Limit-issue-tp4363178p4363178.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Mikrotik-Rate-Limit issue

2011-05-01 Thread Gideon le Grange

On 01 May 2011, at 7:47 PM, speedlnx wrote:
 
 
 I've of course the mikrotik dictionary with the correct attribute and
 there's a record in the database with the rate limit for the user in
 radreply table.
 
 Any idea?
 

Exactly what does this record look like?

What works for me on Freeradius 2.1.8 is using the rate limits expressed as 
bits per second, something like this:

 Mikrotik-Rate-Limit+=  1024/1024  

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

Re: Mikrotik-Rate-Limit issue

2011-05-01 Thread Tanjil Ahmed
SAME QUESTION IS is from me also ... its look like 16962/16962


how to fix it?


On Mon, May 2, 2011 at 1:28 AM, Gideon le Grange donkam...@gmail.comwrote:


 On 01 May 2011, at 7:47 PM, speedlnx wrote:



 I've of course the mikrotik dictionary with the correct attribute and
 there's a record in the database with the rate limit for the user in
 radreply table.

 Any idea?


 Exactly what does this record look like?

 What works for me on Freeradius 2.1.8 is using the rate limits expressed as
 bits per second, something like this:

  Mikrotik-Rate-Limit+=  1024/1024

 HTH
 Gideon

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




-- 
--

























Syed Tanjil Ahmed
Chairman
Netgate Online Ltd
Oval Communication Ltd.
SNS CNG  Convertion Ltd
Network Solution Ltd.
ARSHI (Non Government Organizations)
20,Siddeswari Lane,1st Floor,Dhaka
483/a,DIT Road,Dhaka-1217
Ph:815,9352029,9350458
Ph:9361083,9346890,9342514
Email:i...@tanjil.net,tan...@email.com
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html