Re: Rejecting User By their Calling-Station-Id (Mac Address)

2009-12-25 Thread Alex M 
o no wonder all my trys didnt work =)
Thanks a lot!

On Fri, Dec 25, 2009 at 7:10 PM,  wrote:

> > I need to ask again for help.
> > So I added this code to Autorize section of Default config file it
> > blocks banned users well! But I need to tell them why they got banned so
> I
> > tried diferent ways to add Reply-Message in the logic
> > Nothing helped me so far...
> >
> > So maybe some one can tell me how to add reply-message to this logic?
> >
> > Thank you a lot and Marry Xmas
> >
> >
> >
> > if (Calling-Station-Id == "%{sql: SELECT mac FROM `banlist` WHERE
> > mac='%{Calling-Station-Id}'}") {
> >   reject
>
> update reply {
> Reply-Message = "Your account has been disabled."
> }
>
> >   #reply := "Your account has been disabled."
> >
> > }
>
>
> Ivan Kalik
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Rejecting User By their Calling-Station-Id (Mac Address)

2009-12-25 Thread tnt 
> I need to ask again for help.
> So I added this code to Autorize section of Default config file it
> blocks banned users well! But I need to tell them why they got banned so I
> tried diferent ways to add Reply-Message in the logic
> Nothing helped me so far...
>
> So maybe some one can tell me how to add reply-message to this logic?
>
> Thank you a lot and Marry Xmas
>
>
>
> if (Calling-Station-Id == "%{sql: SELECT mac FROM `banlist` WHERE
> mac='%{Calling-Station-Id}'}") {
>   reject

update reply {
 Reply-Message = "Your account has been disabled."
}

>   #reply := "Your account has been disabled."
>
> }


Ivan Kalik

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

Re: How freeradius mapping the attributes when save records into radacct table?

2009-12-25 Thread tnt 
> as you see, many attributes not saved to the table radacct, there are
> lost. My question is how freeradius know the mapping between them(the
> attributes)?

Queries in raddb/sql/mysql/dialup.conf. You can edit the queries.

Ivan Kalik

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

Re: Rejecting User By their Calling-Station-Id (Mac Address)

2009-12-25 Thread Alex M 
I need to ask again for help.
So I added this code to Autorize section of Default config file it
blocks banned users well! But I need to tell them why they got banned so I
tried diferent ways to add Reply-Message in the logic
Nothing helped me so far...

So maybe some one can tell me how to add reply-message to this logic?

Thank you a lot and Marry Xmas



if (Calling-Station-Id == "%{sql: SELECT mac FROM `banlist` WHERE
mac='%{Calling-Station-Id}'}") {
  reject
  #reply := "Your account has been disabled."

}











On Wed, Dec 16, 2009 at 4:07 PM, Alex M wrote:

> ok fair enough =) will go dig config file...
> How can I send the reason for rejection? Just add reply command somewhere
> along the lines? Can I link reply message to the reply message associated
> with reply in groups?
> Tnx again!
>
>
>
> On Wed, Dec 16, 2009 at 3:25 AM, Alan DeKok wrote:
>
>> Alex M wrote:
>> > Well i guess i'm back to my problem :(
>> > I tried group thing and i'm  getting som strange un-constant results :(
>> >
>> > Can some one tell me how the logic works for groupcheck?
>>
>>   Why?  You were given a simple solution.  I suggest trying that.
>> Trying to figure out how to get groups to do what you want is a waste of
>> time when you *already* have a solution.
>>
>>  Alan DeKok.
>> -
>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>>
>
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

How freeradius mapping the attributes when save records into radacct table?

2009-12-25 Thread Zhang Shukun 
hi, all
   Merry Christmas！
   i want to how freeradius map the attributes between vendor specific
attributes and radius usuall attributes. for example.

i have attributes from asterisk send to radius, attributes and data as follows:

Acct-Status-Type = Stop
Asterisk-Src = "5678"
Asterisk-Dst = "4321"
Asterisk-Dst-Ctx = "tutorial"
Asterisk-Clid = "\"Jane Smith\" <5678>"
Asterisk-Chan = "SIP/ivan-0004"
Asterisk-Dst-Chan = "SIP/test-0005"
Asterisk-Last-App = "Dial"
Asterisk-Last-Data = "SIP/test"
Asterisk-Start-Time = "2009-12-23 16:00:48 +"
Asterisk-Answer-Time = "2009-12-23 16:00:53 +"
Asterisk-End-Time = "2009-12-23 16:02:49 +"
Asterisk-Duration = 121
Asterisk-Bill-Sec = 116
Asterisk-Disposition = "ANSWERED"
Asterisk-AMA-Flags = "DOCUMENTATION"
Asterisk-Unique-ID = "1261584048.4"
User-Name = "SIP/ivan-0004"
Acct-Session-Id = "1261584048.4"
NAS-Port = 0
Acct-Delay-Time = 0
NAS-IP-Address = 127.0.0.1

but when sended to freeradius and saved to mysql table radacct, record
shows as follow,

|15 | 1261584048.4  | acb68819c2f8e979 | SIP/ivan-0004 |
|   | 127.0.0.1 | 0 | | 2009-12-24
00:02:49 | 2009-12-24 00:02:49 |   0 |   |
  | |   0 |0 |
| || |
   | |  0 | 0 | NULL |

as you see, many attributes not saved to the table radacct, there are
lost. My question is how freeradius know the mapping between them(the
attributes)?

if i want to change the attributes(add or remove ) for the mapping?
what should i do? modify the src codes of freeradius ? or do others
-- 
Thanks,
Sucan

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