Re: How do I find out the query error?

2012-05-22 Thread Alan DeKok
Coizado wrote: Mon May 21 14:07:18 2012 : Debug: rlm_sql_mysql: query: SELECT id, username, attribute, value, op FROM login_radius WHERE username = 'coizado' ORDER BY id That's the query. Mon May 21 14:07:18 2012 : Debug: rlm_sql_mysql: MYSQL check_error:

Re: Escaped backslash in User-Name when sending Access-Accept

2012-05-22 Thread Alan DeKok
Roberto Franceschetti wrote: I'm having some issues authenticating iOS clients (with FreeRADIUS v2.1.10 installed on a Ubuntu server) with EAP-TLS when the username contains a domain name in the form of Domain\Username (the account is in Active Directory). I think the issue is caused by

Re: PAP followed by smsotp authentication [WAS: Re: MSCHAPv2 followed by a smsotp authentication]

2012-05-22 Thread Thomas Glanzmann
Hello everyone, find a video which describes the setup of a freeradius server here: http://thomas.glanzmann.de/smsotp.pdf http://thomas.glanzmann.de/smsotp.swf Cheers, Thomas - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

How to proxy according to attribute value?

2012-05-22 Thread mimir
Hello, I want to proxy accounting packets according to Calling-Station-Id attribute. I first think that I must use keyed-balance method for this. I set realm as below: home_server_pool vas1 { type = keyed-balance home_server = vas1 --- I want to send acct pkgs with calling-st-id

Re: How to proxy according to attribute value?

2012-05-22 Thread mimir
realm VAS1 { acct_pool = vas1 } I added realm definition. -- View this message in context: http://freeradius.1045715.n5.nabble.com/How-to-proxy-according-to-attribute-value-tp5713307p5713308.html Sent from the FreeRadius - User mailing list archive at Nabble.com. - List

Re: How to proxy according to attribute value?

2012-05-22 Thread Alan DeKok
mimir wrote: Hello, I want to proxy accounting packets according to Calling-Station-Id attribute. I first think that I must use keyed-balance method for this. No. You need to set Proxy-To-Realm. That tells the server to proxy. The keyed-balance configuration is a method of proxying.

Re: How to proxy according to attribute value?

2012-05-22 Thread mimir
Thanks Alan for reply. Is there any other way to run my scenario? like attribute filtering sth else? I also created multiple realms with one home_servers and tried to Proxy to them according to Calling-Station-Id value by adding if else structrues to the update control section in preacct. But I

Re: How to proxy according to attribute value?

2012-05-22 Thread Alan DeKok
mimir wrote: Thanks Alan for reply. Is there any other way to run my scenario? like attribute filtering sth else? I explained the solution which works. Attribute filtering has nothing to do with proxying. I also created multiple realms with one home_servers and tried to Proxy to them

Re: User management hints

2012-05-22 Thread Alan DeKok
Germano Paciocco wrote: I'm new to Freeradius, and I would like to write a very simple user management php/mysql script, that should allow me to do some simple things: 1) create a user; 2) set expire date for a user; 3) disable user, automatically at expire date or manually if needed.