Re: Username with spaces (MySQL)

Hi I had same trouble.. in version 1.x of radius.. and had to did queries like above with regex... but for luck in the new version 2.x just have to enable the policy.conf in the authorization module.. and your problem will be solve regards. 2013/4/18 a.l.m.bu...@lboro.ac.uk Hi, You

regex in suffix

Hi to all. I have some suffix configure, to can do load balance between some sql accountings servers. and I have this check into radiusd.conf if (User-Name =~ /^(.+)@institute.domain.cu/) { monthlycounter2 } else {

Re: regex in suffix

well.. ok. sorry for that i do multiple elsif in the condition.. to parse the rest of domains 2013/3/22 Tony Peña emperor...@gmail.com Hi to all. I have some suffix configure, to can do load balance between some sql accountings servers. and I have this check into radiusd.conf

rlm_checkval and Hint attribute

Hi again... I'm starting taking some confuse idea with this... I use 3 checkvals. 1 for Calling-Station-Id 2 for Called-Station-Id and 3 for Hints and in the Hints file.. i setup my hints domains and filter to can apply for the suffix the correct acl/pool ip. also have radiusHints and

Re: rlm_checkval and Hint attribute

hi again now is fine.. the hint query was ... 1 configuration in the hints file.. left the default for users not with suffix.. and ldap.atrribmap.. miss Hint --- radiusHint again.. thanxs for all 2013/3/22 Tony Peña emperor...@gmail.com Hi again... I'm starting taking some confuse

suffix not work for me

hi again... i try to get suffix work but i guess missing something... here some debugs and confs rad_recv: Access-Request packet from host 10.10.64.67 port 16829, id=53, length=208 Framed-Protocol = PPP User-Name = *usert...@my.domain.cu* User-Password = *secret*

Re: suffix not work for me

i put the hint file more below after radiusd -X.. check again please... i miss policyfilter... i send again both. /etc/freeradius/hints DEFAULT Suffix == @my.domain.cu, Strip-User-Name = Yes Hint = userdefault, Service-Type = Framed-User, Framed-Protocol = PPP, /etc/freeradius/policy.conf

Re: suffix not work for me

I want when username is user@my.domain the suffix out @my.domain to only get: user that only need. 2012/9/27 alan buxey a.l.m.bu...@lboro.ac.uk Hi, DEFAULT Suffix == @[1]my.domain.cu, Strip-User-Name = Yes there you go. strip-user-name = yes this means that

Re: suffix not work for me

anyway... my problem is exactly at monthlycounter because i need stripped-user-name and module stripped when try to use but in the queries use username complete including realm. 2012/9/27 Tony Peña emperor...@gmail.com I want when username is user@my.domain the suffix out @my.domain to only

Re: suffix not work for me

check-name = Max-Monthly-Session reply-name = Session-Timeout sqlmod-inst = sql1 key = User-Name use the if { your patch} ??? reset = monthly 2012/9/27 Phil Mayers p.may...@imperial.ac.uk On 27/09/12 17:06, Tony Peña wrote: i put the hint file more below after radiusd -X.. check again

Re: suffix not work for me

ok.. I do some testing about new sql... and with your unlang if idea.. could be thanxs to all 2012/9/27 alan buxey a.l.m.bu...@lboro.ac.uk Hi, key = User-Name use the if { your patch} ??? either change this to Stripped-User-Name insteador if you ONLY want

Re: balancing sql servers

and the other server sql_modinst = sql2 to check monthlysession again.. is possible to do load-balance in that case too? thanxs again 2012/9/4 Tony Peña emperor...@gmail.com Hi easy easy... i know that works for years.. i use in old version.. just try to migratting.. but i mixed some lines older

Re: balancing sql servers

... ;-) 2012/9/6 Arran Cudbard-Bell a.cudba...@freeradius.org On 6 Sep 2012, at 14:44, Tony Peña emperor...@gmail.com wrote: hi again all fine with redundant-load-balance {sql1 sql2} now .. have a different issue with that... when i set sql with 2 sql server for balance

Re: balancing sql servers

in que query shlud be griseramirez too like sql_set_user escaped. cheers 2012/9/6 Tony Peña emperor...@gmail.com cool... works great... setting 2 instance monthlycounter monthlycounter1 { bla } and 2 the same rules... about it.. and in authorization session reundant-load-balance

Re: balancing sql servers

and servers is go ok. thanxs for all.. Tony 2012/9/4 Alan DeKok al...@deployingradius.com Tony Peña wrote: erm.. ok i got a solution but with not redundant I can do with load-balance { sql1 sql2 } Nonsense. The redundant code works. It's worked for years

balancing sql servers

hi, i'm trying to balance 2 sql servers into my site-available... and searching in some archives old mails, explain about module instatiate section { sql1 sql2 } but in my freeradius config ... that module not appears... version of freeradius: 2.1.10 i check into modules dir, and not see

Re: balancing sql servers

idem error... with redundant only not work what need exaclty see for check in the conf ? 2012/9/3 Alan DeKok al...@deployingradius.com Tony Peña wrote: but last lines /etc/freeradius/sites-available/infomed[428]: Failed to load module sql. Edit that line, and delete the references

Re: balancing sql servers

erm.. ok i got a solution but with not redundant I can do with load-balance { sql1 sql2 } thanxs Alan 2012/9/3 Tony Peña emperor...@gmail.com idem error... with redundant only not work what need exaclty see for check in the conf ? 2012/9/3 Alan DeKok al...@deployingradius.com

some mysql errors

Hi... i'm getting some many errors like this... Mon Aug 20 11:27:26 2012 : Error: [sql] Couldn't update SQL accounting STOP record - Lock wait timeout exceeded; try restarting transaction Mon Aug 20 11:27:26 2012 : Error: rlm_sql_mysql: Cannot store result Mon Aug 20 11:27:26 2012 : Error:

Re: some mysql errors

hi yes I have 64 to start initial each radius-server and yes have NDB engine into cluster.. .just missing the use for buffered_sql for live session.. that i have to read to implement, for example now.. not happening.. just when occurs start to doing that issues.. thanxs for the tips 2012/8/20

problem with User-Name Stripped-User-Name

hi, i'm trying to migrate freeradius 1.3.1 to 2.1.12. 1.3.1 works very fine but I need upgrades and my freeradius server auth in ldap and accounting on mysql.. and the new file configuration have a little change for me.. all fine but not work for me.. the stripped-user-name properly. if i use

Re: problem with User-Name Stripped-User-Name

2012/8/1 Alan DeKok al...@deployingradius.com Tony Peña wrote: hi, i'm trying to migrate freeradius 1.3.1 to 2.1.12. 1.3.1 works very fine but I need upgrades and my freeradius server auth in ldap and accounting on mysql.. and the new file configuration have a little change for me

Re: problem with User-Name Stripped-User-Name

file to forge it but simultaneos should be work but not for sql.. i try to keep of load to ddbb servers. suggest? thanxs again Alan 2012/8/1 Alan DeKok al...@deployingradius.com Tony Peña wrote: i use that because in that way explain in line 25 of sql/mysql/dialup.conf No. The default

Re: problem with User-Name Stripped-User-Name

ok but with original not work for me as default uncomment... i have to change sql_user_name = %{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}} for sql_user_name = %{Stripped-User-Name:-%{User-Name:-DEFAULT}} to can use it.. and i check simultaneous-use by radutmp way. 2012/8/1 alan

Re: problem with User-Name Stripped-User-Name

don't worry for radutmp... In your site-available/default, explain sql for simultaneous is more faster.. so . i change it.. and i test it with radclient again.. doing auth - acct start - (auth for check) - and acct stop to finish session test output