Load-Balance-Key usage

2012-09-27 Thread lscrlstld
Hi, Can I use the Load-Balance-Key to choose a specific home_server? For sample: home_server_pool pool { type = keyed-balance home_server = server1 home_server = server2 } realm test { auth_pool = pool acct_pool = pool } authorize { ... if ( ... ) { update control {

proxied server and right flamed IP to ppp clients

2012-09-18 Thread lscrlstld
Is there any way to ensure (or check) that the proxied server assigned a right framed IP within a specific range of IPs? unlang perhaps? Main Server proxy to +- freeradius Server 1 | (must be use ip pool 10.0.0.0/24) +--+ | |

RES: proxied server and right flamed IP to ppp clients

2012-09-18 Thread lscrlstld
Main server check if the framed IP is within the correct pool, if not reject. IMHO a cleaner solution would be for you to assign the IP addresses yourself. Yeap, I think so too. But how to do this if the authentication is done on a remote server? - List info/subscribe/unsubscribe? See

RES: FR 3 Event-Timestamp wrong format and Mysql FROM_UNIXTIME error

2012-08-06 Thread lscrlstld
lscrlstld wrote: I´m making initial tests with FR 3 (from git) using default configs with mysql db, but have mysql error. Debug info: rlm_sql_mysql: MySQL error 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax

RES: FR 3 Event-Timestamp wrong format and Mysql FROM_UNIXTIME error

2012-08-06 Thread lscrlstld
The %{Event-Timestamp} used in query have a wrong date/time format, it is not the timestamp. Yes. That's why the master branch uses %{integer:Event-Timestamp}, which causes the timestamp to be printed as a Unix 32-bit number. Is it a dependency of OS setup? How this variable

FR 3 Event-Timestamp wrong format and Mysql FROM_UNIXTIME error

2012-08-05 Thread lscrlstld
Hi, I´m making initial tests with FR 3 (from git) using default configs with mysql db, but have mysql error. Debug info: rlm_sql_mysql: MySQL error 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '5 2012

RES: Basic freeradius set up problem

2012-07-11 Thread lscrlstld
2) Inserted a user: INSERT INTO radcheck (UserName, Attribute, Value) VALUES ('testuser', 'Password', 'passsecret'); Use 'Cleartext-Password' instead of 'Password' and try again. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

RES: Stuck with exec script from radgroupreply sql table

2012-07-05 Thread lscrlstld
I want to set a dynamic Session-Timeout for certain groups. For testing purposes I created a TESTGROUP in the database table radgroupreply with an entry like this: id GroupName Attribute Value op 263TESTGROUP Session-Timeout `%{exec:/var/skripte/test.sh}`

Update control with redundant sql query

2012-06-28 Thread lscrlstld
Hi, I use the policy configs to provide redundant and load-balance to update the pool-name. It´s work fine! But I have same questions... - Is it the correct way to do it? Is it the better way, considering a performance in high usage? - Why the virtual module created in the policy and control