Re: rlm_sql_mysql UTF-8 encoding

2011-10-04 Thread Arran Cudbard-Bell
username = # 'g=C5=82up.w=C3=B3r' ORDER BY priority # rlm_sql_mysql: query: SELECT groupname FROM radusergroup # WHERE username = 'g=C5=82up.w=C3=B3r' ORDER BY priority the username is encoded as g=C5=82up.w=C3=B3r both UTF-8 encoded characters (=C5=82, =C3=B3) were

Re: query

2010-12-16 Thread John Dennis
On 12/16/2010 08:14 AM, John Dennis wrote: On 12/16/2010 04:25 AM, karnik jain wrote: Ok, I understood your point. But as per RFC 2865, what is the meaning of then UTF-8 encoded 10646 [7] characters, *the [7]?* *7 stands for what over here?* ** And one more thing as per RFC 2865, 1) As per

Re: Converting attributes from hex to ASCII

2010-03-30 Thread Aaron Paetznick
with something like this: ... IF('%{Some-Trigger-Attribute}'=TRIGGER-VALUE, UNHEX('%{Called-Station-Id}'), '%{Called-Station-Id}'), \ ... A little bit of overhead to every query, but I suspect it will be manageable on our network. Alternatively, I suppose I could do

Re: query

2010-12-16 Thread karnik jain
Ah, it occurred to me I might know where your confusion is coming from. In an earlier email you referenced the iconv encoding library and asked shouldn't FreeRADIUS be encoding/decoding text. The answer is no. The reason why is because radius implementations treat text as an octet string (e.g

FR/AD integration

2011-02-18 Thread E Rossiter
username --domain=STRING domain name --workstation=STRING workstation --challenge=STRING challenge (HEX encoded) --lm-response=STRING LM Response to the challenge

Re: FR/AD integration

2011-02-18 Thread Gary Gatten
as a stdio-based helper --username=STRINGusername --domain=STRING domain name --workstation=STRING workstation --challenge=STRING challenge (HEX encoded) --lm-response=STRING

Re: FR/AD integration

2011-02-18 Thread E Rossiter
encoded) --lm-response=STRING LM Response to the challenge (HEX encoded) --nt-response=STRING NT or NTLMv2 Response to the challenge (HEX encoded

Re: Segmentation Fault on [pap] Normalizing SSHA1-Password from base64 encoding

2013-09-07 Thread Stefan Winter
that :-) The remaining issue occurs only when the base64-encoded SSHA password starts with the two characters 0x or 0X. In that case, FreeRADIUS thinks oh, a hex number, let's decode it - while the input is not a number at all. Doesn't lead to crashes, but auths going wrong. And, IIRC, that kind of failed

Re: Active directory groups

2011-05-18 Thread Phil Mayers
On 18/05/11 17:22, Gary Gatten wrote: If one has (just for example) 1000 groups, this is a lot of overhead Sure (I did see your query the other day - I just haven't had a chance to write up a reply, but see below) - checking every group. Also, what if they belong to several groups? Well

Re: Accounting using SQL

2010-01-20 Thread James2010
, value, op FROM radcheck WHERE username = 'james' ORDER BY id rlm_sql_mysql: query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'james' ORDER BY id [sql] User found in radcheck table [sql] expand: SELECT id

Simultaneous-Use check MySQL

2005-10-13 Thread David M.
- authorize_group_check_query 3- authorize_reply_query 4- authorize_group_reply_query 5- simul_count_query **returns 1** 6- simul_verify_query 7- accounting stop query **performs a stop in the previously established session** 8- postauth_query 9- accounting_start_query 10- accounting_update_query (updates the radacct table

RE : RE : radgroupreply

2004-10-04 Thread EROS
num_sql_socks = 5 # number of seconds to dely retrying on a failed database # connection (per_socket) connect_failure_retry_delay = 60 # Safe characters list for sql queries. Everything else is replaced # with their mime-encoded equivalents

RE : RE : RE : radgroupreply

2004-10-05 Thread EROS
# number of seconds to dely retrying on a failed database # connection (per_socket) connect_failure_retry_delay = 60 # Safe characters list for sql queries. Everything else is replaced # with their mime-encoded equivalents. # The default list should

Re: Problem about Chap-Password and User-Password

2006-06-30 Thread Stefan Winter
unusual) or store the password not literal in the database, but properly encoded. the rlm_sql module will then take the user's password, encode it, and check it against the same-encoded string in the database. Of course, the problem might also be that your shared secret for this client isn't correct

Re: Freeradius-Users Digest, Vol 14, Issue 119

2006-06-30 Thread Kun Niu
the password not literal in the database, but properly encoded. the rlm_sql module will then take the user's password, encode it, and check it against the same-encoded string in the database. Of course, the problem might also be that your shared secret for this client isn't correct, as the end

rlm_sql_mysql UTF-8 encoding

2011-10-04 Thread Krzyzagorski Tomek KOMA NORD
: query: SELECT groupname FROM radusergroup # WHERE username = 'g=C5=82up.w=C3=B3r' ORDER BY priority the username is encoded as g=C5=82up.w=C3=B3r both UTF-8 encoded characters (=C5=82, =C3=B3) were treated as separate characters (=C5, =82, =C3, =B3). I found sth about

Re: Last call for 2.1.10

2010-09-23 Thread John Dennis
%{tolower: ...string ... }, which returns the lowercase +version of the string. + + Bug fixes + * Fix endless loop when there are multiple sub-options for +DHCP option 82. + * More debug output when sending / receiving DHCP packets. + * EAP-MSCHAPv2 should return the MPPE keys when used

Re: Dialupadmin port number

2005-02-09 Thread Joel Eddy
with information regarding the Online Users. general_finger_type: snmp What should be the default quering method of the nas. It can be 'snmp' (for snmpfinger) or empty to query the radacct table without first querying the nas general_snmpfinger_bin: %{general_base_dir}/bin/snmpfinger This probably does