Re: Reply-Message

2010-01-17 Thread zhongwei feng
hi, configure postauth_query in dialup.conf, postauth_query=UPDATE POSTREPLY SET REPLYMESSAGE='%{reply:Reply-Message}' WHERE USERNAME='%{SQL-User-Name}' than , you can query the message from DB SERVER. BTW: if reject user, then ... # # Access-Reject packets are

Re: Reply-Message

2010-01-17 Thread zhongwei feng
Neville,您好! so, security reasons. 8-( 1,modify the sql_escape_func(char *out, size_t outlen, const char *in) in rlm_sql.c, but there is bad idea. 2, expand rlm_sql and db driver,support parameter binding , and skip convert parameter. === 2010-01-18

Re:A special user to matcheon all usernames

2010-01-16 Thread zhongwei feng
hi, pang jiacai: try this : in authorize section : redundant { sql files } in users file : DEFAULT Auth-Type := Accept Session-Timeout := 300    Hi,all: I want to kown how to configure a special user to match all

Re: Parsing IP and PHONE NUMBER from ACCOUNTING packet

2009-12-28 Thread zhongwei feng
Hi, Michael Joyner: 1, read man unlang , more and more ; 2, understand regular express .. importance ; regular express can extract what you need . 3, mysql support regular express , or , use unlang . processing maybe below: accounting { #Calling-Station-Id

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

2009-12-27 Thread zhongwei feng
hi , try to exchange sequece ?    if (Calling-Station-Id == %{sql: SELECT mac FROM `lrc_banlist` WHERE mac='%{Calling-Station-Id}'}) { update reply{ Reply-Message := Hello Hello Hello } reject } - List