- Freeradius-Users - lists.freeradius.org

Error syntax in sql accounting.
by Hocine M 04 Feb '13

04 Feb '13

Hi everybody, I always have an error in radius.log file : Mon Feb 4 16:16:52 2013 : Error: [sql_acct] Couldn't insert SQL accounting START record - Erreur de syntaxe pr?s de '' ? la ligne 1 Mon Feb 4 16:17:01 2013 : Error: [sql_acct] Couldn't insert SQL accounting START record - Erreur de syntaxe pr?s de '' ? la ligne 1 Mon Feb 4 16:17:06 2013 : Error: [sql_acct] Couldn't insert SQL accounting START record - Erreur de syntaxe pr?s de '' ? la ligne 1 Mon Feb 4 16:17:10 2013 : Error: [sql_acct] Couldn't insert SQL accounting START record - Erreur de syntaxe pr?s de '' ? la ligne 1 Mon Feb 4 16:17:15 2013 : Error: [sql_acct] Couldn't insert SQL accounting START record - Erreur de syntaxe pr?s de '' ? la ligne 1 Mon Feb 4 16:17:24 2013 : Error: [sql_acct] Couldn't insert SQL accounting START record - Erreur de syntaxe pr?s de '' ? la ligne 1 Mon Feb 4 16:17:26 2013 : Error: [sql_acct] Couldn't insert SQL accounting START record - Erreur de syntaxe pr?s de '' ? la ligne 1 Mon Feb 4 16:17:34 2013 : Error: [sql_acct] Couldn't insert SQL accounting START record - Erreur de syntaxe pr?s de '' ? la ligne 1 Mon Feb 4 16:17:47 2013 : Error: [sql_acct] Couldn't insert SQL accounting START record - Erreur de syntaxe pr?s de '' ? la ligne 1 Mon Feb 4 16:17:54 2013 : Error: [sql_acct] Couldn't insert SQL accounting START record - Erreur de syntaxe pr?s de '' ? la ligne 1 I made my radacct accounting table with the schema founf in /etc/freeradius/sql/mysql/schema.sql. I use a mysql server databse. in my sql.conf i use the standard queries for accounting. Any idea?

2 1

radiusd startup failure for EAP-AKA configuration
by Mark Sincerbox 04 Feb '13

04 Feb '13

Hi, Relatively new to freeradius. Have had success testing an EAP-MD5 and EAP-TLS configuration. I have patched freeradius-server-2.1.10 to add EAP-AKA support but am experiencing a radiusd startup failure as follows: radiusd -X FreeRADIUS Version 2.1.10, for host x86_64-unknown-linux-gnu, built on Feb 2 2013 at 14:23:04 Copyright (C) 1999-2009 The FreeRADIUS server project and contributors. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. You may redistribute copies of FreeRADIUS under the terms of the GNU General Public License v2. Starting - reading configuration files ... including configuration file /usr/local/etc/raddb/radiusd.conf including configuration file /usr/local/etc/raddb/proxy.conf including configuration file /usr/local/etc/raddb/clients.conf including files in directory /usr/local/etc/raddb/modules/ including configuration file /usr/local/etc/raddb/modules/dynamic_clients including configuration file /usr/local/etc/raddb/modules/attr_rewrite including configuration file /usr/local/etc/raddb/modules/perl including configuration file /usr/local/etc/raddb/modules/sql_log including configuration file /usr/local/etc/raddb/modules/sradutmp including configuration file /usr/local/etc/raddb/modules/passwd including configuration file /usr/local/etc/raddb/modules/realm including configuration file /usr/local/etc/raddb/modules/mac2vlan including configuration file /usr/local/etc/raddb/modules/counter including configuration file /usr/local/etc/raddb/modules/checkval including configuration file /usr/local/etc/raddb/modules/ldap including configuration file /usr/local/etc/raddb/modules/detail including configuration file /usr/local/etc/raddb/modules/expiration including configuration file /usr/local/etc/raddb/modules/sqlcounter_expire_on_login including configuration file /usr/local/etc/raddb/modules/exec including configuration file /usr/local/etc/raddb/modules/files including configuration file /usr/local/etc/raddb/modules/pap including configuration file /usr/local/etc/raddb/modules/detail.log including configuration file /usr/local/etc/raddb/modules/policy including configuration file /usr/local/etc/raddb/modules/echo including configuration file /usr/local/etc/raddb/modules/detail.example.com including configuration file /usr/local/etc/raddb/modules/krb5 including configuration file /usr/local/etc/raddb/modules/smsotp including configuration file /usr/local/etc/raddb/modules/linelog including configuration file /usr/local/etc/raddb/modules/logintime including configuration file /usr/local/etc/raddb/modules/unix including configuration file /usr/local/etc/raddb/modules/chap including configuration file /usr/local/etc/raddb/modules/opendirectory including configuration file /usr/local/etc/raddb/modules/wimax including configuration file /usr/local/etc/raddb/modules/digest including configuration file /usr/local/etc/raddb/modules/preprocess including configuration file /usr/local/etc/raddb/modules/ntlm_auth including configuration file /usr/local/etc/raddb/modules/attr_filter including configuration file /usr/local/etc/raddb/modules/cui including configuration file /usr/local/etc/raddb/modules/always including configuration file /usr/local/etc/raddb/modules/otp including configuration file /usr/local/etc/raddb/modules/expr including configuration file /usr/local/etc/raddb/modules/acct_unique including configuration file /usr/local/etc/raddb/modules/smbpasswd including configuration file /usr/local/etc/raddb/modules/inner-eap including configuration file /usr/local/etc/raddb/modules/radutmp including configuration file /usr/local/etc/raddb/modules/mac2ip including configuration file /usr/local/etc/raddb/modules/pam including configuration file /usr/local/etc/raddb/modules/ippool including configuration file /usr/local/etc/raddb/modules/etc_group including configuration file /usr/local/etc/raddb/modules/mschap including configuration file /usr/local/etc/raddb/eap.conf including configuration file /usr/local/etc/raddb/policy.conf including files in directory /usr/local/etc/raddb/sites-enabled/ including configuration file /usr/local/etc/raddb/sites-enabled/default including configuration file /usr/local/etc/raddb/sites-enabled/control-socket including configuration file /usr/local/etc/raddb/sites-enabled/inner-tunnel main { allow_core_dumps = no } including dictionary file /usr/local/etc/raddb/dictionary main { prefix = "/usr/local" localstatedir = "/usr/local/var" logdir = "/usr/local/var/log/radius" libdir = "/usr/local/lib" radacctdir = "/usr/local/var/log/radius/radacct" hostname_lookups = no max_request_time = 30 cleanup_delay = 5 max_requests = 1024 pidfile = "/usr/local/var/run/radiusd/radiusd.pid" checkrad = "/usr/local/sbin/checkrad" debug_level = 0 proxy_requests = yes log { stripped_names = no auth = no auth_badpass = no auth_goodpass = no } security { max_attributes = 200 reject_delay = 1 status_server = yes } } radiusd: #### Loading Realms and Home Servers #### proxy server { retry_delay = 5 retry_count = 3 default_fallback = no dead_time = 120 wake_all_if_all_dead = no } home_server localhost { ipaddr = 127.0.0.1 port = 1812 type = "auth" secret = "testing123" response_window = 20 max_outstanding = 65536 require_message_authenticator = yes zombie_period = 40 status_check = "status-server" ping_interval = 30 check_interval = 30 num_answers_to_alive = 3 num_pings_to_alive = 3 revive_interval = 120 status_check_timeout = 4 irt = 2 mrt = 16 mrc = 5 mrd = 30 } home_server_pool my_auth_failover { type = fail-over home_server = localhost } realm example.com { auth_pool = my_auth_failover } realm LOCAL { } radiusd: #### Loading Clients #### client localhost { ipaddr = 127.0.0.1 require_message_authenticator = no secret = "testing123" nastype = "other" } radiusd: #### Instantiating modules #### instantiate { Module: Linked to module rlm_exec Module: Instantiating module "exec" from file /usr/local/etc/raddb/modules/exec exec { wait = no input_pairs = "request" shell_escape = yes } Module: Linked to module rlm_expr Module: Instantiating module "expr" from file /usr/local/etc/raddb/modules/expr Module: Linked to module rlm_expiration Module: Instantiating module "expiration" from file /usr/local/etc/raddb/modules/expiration expiration { reply-message = "Password Has Expired " } Module: Linked to module rlm_logintime Module: Instantiating module "logintime" from file /usr/local/etc/raddb/modules/logintime logintime { reply-message = "You are calling outside your allowed timespan " minimum-timeout = 60 } } radiusd: #### Loading Virtual Servers #### server inner-tunnel { # from file /usr/local/etc/raddb/sites-enabled/inner-tunnel modules { Module: Checking authenticate {...} for more modules to load Module: Linked to module rlm_pap Module: Instantiating module "pap" from file /usr/local/etc/raddb/modules/pap pap { encryption_scheme = "auto" auto_header = no } Module: Linked to module rlm_chap Module: Instantiating module "chap" from file /usr/local/etc/raddb/modules/chap Module: Linked to module rlm_mschap Module: Instantiating module "mschap" from file /usr/local/etc/raddb/modules/mschap mschap { use_mppe = yes require_encryption = no require_strong = no with_ntdomain_hack = no } Module: Linked to module rlm_unix Module: Instantiating module "unix" from file /usr/local/etc/raddb/modules/unix unix { radwtmp = "/usr/local/var/log/radius/radwtmp" } Module: Linked to module rlm_eap Module: Instantiating module "eap" from file /usr/local/etc/raddb/eap.conf eap { default_eap_type = "aka" timer_expire = 60 ignore_unknown_eap_types = no cisco_accounting_username_bug = no max_sessions = 4096 } Module: Linked to sub-module rlm_eap_md5 Module: Instantiating eap-md5 Module: Linked to sub-module rlm_eap_aka Module: Instantiating eap-aka Module: Linked to sub-module rlm_eap_sim Module: Instantiating eap-sim Module: Linked to sub-module rlm_eap_leap Module: Instantiating eap-leap Module: Linked to sub-module rlm_eap_gtc Module: Instantiating eap-gtc gtc { challenge = "Password: " auth_type = "PAP" } Module: Linked to sub-module rlm_eap_tls Module: Instantiating eap-tls tls { rsa_key_exchange = no dh_key_exchange = yes rsa_key_length = 512 dh_key_length = 512 verify_depth = 0 CA_path = "/usr/local/etc/raddb/certs" pem_file_type = yes private_key_file = "/usr/local/etc/raddb/certs/server.pem" certificate_file = "/usr/local/etc/raddb/certs/server.pem" CA_file = "/usr/local/etc/raddb/certs/ca.pem" private_key_password = "whatever" dh_file = "/usr/local/etc/raddb/certs/dh" random_file = "/usr/local/etc/raddb/certs/random" fragment_size = 1024 include_length = yes check_crl = no cipher_list = "DEFAULT" make_cert_command = "/usr/local/etc/raddb/certs/bootstrap" cache { enable = no lifetime = 24 max_entries = 255 } verify { } } Module: Linked to sub-module rlm_eap_ttls Module: Instantiating eap-ttls ttls { default_eap_type = "md5" copy_request_to_tunnel = no use_tunneled_reply = no virtual_server = "inner-tunnel" include_length = yes } Module: Linked to sub-module rlm_eap_peap Module: Instantiating eap-peap peap { default_eap_type = "mschapv2" copy_request_to_tunnel = no use_tunneled_reply = no proxy_tunneled_request_as_eap = yes virtual_server = "inner-tunnel" } Module: Linked to sub-module rlm_eap_mschapv2 Module: Instantiating eap-mschapv2 mschapv2 { with_ntdomain_hack = no } Module: Checking authorize {...} for more modules to load Module: Linked to module rlm_realm Module: Instantiating module "suffix" from file /usr/local/etc/raddb/modules/realm realm suffix { format = "suffix" delimiter = "@" ignore_default = no ignore_null = no } Module: Linked to module rlm_files Module: Instantiating module "files" from file /usr/local/etc/raddb/modules/files files { usersfile = "/usr/local/etc/raddb/users" acctusersfile = "/usr/local/etc/raddb/acct_users" preproxy_usersfile = "/usr/local/etc/raddb/preproxy_users" compat = "no" } /usr/local/etc/raddb/users[3]: Parse error (check) for entry akauser@domain: Unknown value AKA for attribute EAP-Type Errors reading /usr/local/etc/raddb/users /usr/local/etc/raddb/modules/files[7]: Instantiation failed for module "files" /usr/local/etc/raddb/sites-enabled/inner-tunnel[124]: Failed to load module "files". /usr/local/etc/raddb/sites-enabled/inner-tunnel[47]: Errors parsing authorize section. Struggling with determining what is missing in my configuration that might be causing this issue. I see that the above error is coming from src/lib/valuepair.c but am having difficulty determining the root cause. I've read doc and man pages but so far cannot spot the problem. I've placed the raddb directory under git version control to easily track my changes. These are the changes I have made to the freeradius delivered configuration: [root@x4200 raddb]# git diff dictionary diff --git a/dictionary b/dictionary index 8de4d63..e26b7d7 100644 --- a/dictionary +++ b/dictionary @@ -30,3 +30,10 @@ $INCLUDE /usr/local/share/freeradius/dictionary #ATTRIBUTE My-Local-String 3000 string #ATTRIBUTE My-Local-IPAddr 3001 ipaddr #ATTRIBUTE My-Local-Integer 3002 integer + +ATTRIBUTE EAP-Type-AKA 3100 octets +ATTRIBUTE EAP-Sim-AUTN 3101 octets +ATTRIBUTE EAP-Aka-IK 3102 octets +ATTRIBUTE EAP-Aka-CK 3103 octets +ATTRIBUTE EAP-Sim-RES 3104 octets + [root@x4200 raddb]# [root@x4200 raddb]# git diff eap.conf diff --git a/eap.conf b/eap.conf index b34acbe..319bdbe 100644 --- a/eap.conf +++ b/eap.conf @@ -27,7 +27,8 @@ # then that EAP type takes precedence over the # default type configured here. # - default_eap_type = md5 + #default_eap_type = md5 + default_eap_type = aka # A list is maintained to correlate EAP-Response # packets with EAP-Request packets. After a @@ -74,7 +75,10 @@ # md5 { } - + aka { + } + sim { + } # Cisco LEAP # # We do not recommend using LEAP in new deployments. See: [root@x4200 raddb]# git diff users diff --git a/users b/users index 1c17b50..300ec5d 100644 --- a/users +++ b/users @@ -1,3 +1,7 @@ +testing Cleartext-Password := "password" + +akauser@domain Cleartext-Password := "ipsecsecrets", Auth-Type := EAP, EAP-Type := AKA, EAP-Sim-AUTN = 0xa0a0a0a0a0a0a0a0a0a0a0a0a0a0a0a0, EAP-Aka-IK = 0x494b494b494b494b494b494b494b494b, EAP-Aka-CK = 0x434b434b434b434b434b434b434b434b, EAP-Sim-RES = 0x52455352455352455352455352455352, EAP-Sim-RAND = 0xe0e0e0e0e0e0e0e0e0e0e0e0e0e0e0e0 + # # Please read the documentation file ../doc/processing_users_file, # or 'man 5 users' (after installing the server) for more information. @@ -83,6 +87,16 @@ # Framed-MTU = 1500, # Framed-Compression = Van-Jacobsen-TCP-IP + + +#akauser@domain Auth-Type := EAP, EAP-Type := AKA +# EAP-Sim-AUTN = 0xa0a0a0a0a0a0a0a0a0a0a0a0a0a0a0a0, +# EAP-Aka-IK = 0x494b494b494b494b494b494b494b494b, +# EAP-Aka-CK = 0x434b434b434b434b434b434b434b434b, +# EAP-Sim-RES = 0x52455352455352455352455352455352, +# EAP-Sim-RAND = 0xe0e0e0e0e0e0e0e0e0e0e0e0e0e0e0e0 + + # # This is an entry for a user with a space in their name. # Note the double quotes surrounding the name. Thanks, Mark

3 2

Help Needed !!! FreeRADIUS Integration with MS AD
by pradyumna dash 03 Feb '13

03 Feb '13

Hi Team, I need a help, am new to RADIUS and i need the below to be configured. I. FreeRADIUS integration with Microsoft AD II. Cisco switches needs to be the client II. The accounting information should also contain the commands executed in the Switch as well, Example If a used called "test" login to the switch and exexuted a command "Show config" that should be captured in the accounting information. What i have done till now is configured FreeRADIUS and created some local users and getting the switch to authenticated against the local user, Its working fine and getting the value-pair but i can see the commands which are executed in the switch console. Please help how i can do so. As i never integrated Micosoft 2008 AD with FreeRADIUS i need a how-to may be a step-by-step which can help me in integrating the same. Do i need a DB like MySQL for accounting or AD LDAP DB will help in doing so? Thanks for all your help. Regards, /Neo

5 13

Proxy based on auth type?
by Bertalan Voros 01 Feb '13

01 Feb '13

Hello All, Another lame ass question. Is it possible to proxy requests based on Auth-Type? I now have a config which terminates PEAP locally and proxies through the inner-tunnel to an NPS using MSCHAP. This was my original goal. However, when I do a radtest to check what happens to an mschap request it fails locally instead of being proxied. There is a combination of peap and mschap requests coming to the server. If I uncomment suffix in sites-enabled/default then it's reversed, mschap gets proxied but PEAP requests doesn't get sent through the inner tunnel. In proxy.conf I have the DEFAULT realm set to our NPS and have nostrip set for each entry in clients.conf. The reason for this is that in the AD we have the user's email set as UPN and there are hundreds of email domains in use, the users's AD username cannot be determined based on the email address. Output of debug mode when plain mschap fails: *Ready to process requests.* *rad_recv: Access-Request packet from host 10.205.128.7 port 54292, id=242, length=154* * User-Name = "bertalan.voros(a)onedomain.com"* * NAS-IP-Address = x.x.x.x* * NAS-Port = 0* * Message-Authenticator = 0x8402c1883262ac3e5a71b538490e1082* * MS-CHAP-Challenge = 0x9580349e1047ab7c* * MS-CHAP-Response = 0x0001000000000000000000000000000000000000000000000000ce764eb9fbdbfd3c66d06ecbfbf934845bfc12ed2a697dc4 * *# Executing section authorize from file /etc/raddb/sites-enabled/default* *+- entering group authorize {...}* *++[preprocess] returns ok* *[mschap] Found MS-CHAP attributes. Setting 'Auth-Type = mschap'* *++[mschap] returns ok* *[eap] No EAP-Message, not doing EAP* *++[eap] returns noop* *Found Auth-Type = MSCHAP* *# Executing group from file /etc/raddb/sites-enabled/default* *+- entering group MS-CHAP {...}* *[mschap] No Cleartext-Password configured. Cannot create LM-Password.* *[mschap] No Cleartext-Password configured. Cannot create NT-Password.* *[mschap] Told to do MS-CHAPv1 with NT-Password* *[mschap] FAILED: No NT/LM-Password. Cannot perform authentication.* *[mschap] MS-CHAP-Response is incorrect.* *++[mschap] returns reject* *Failed to authenticate the user.* *Login incorrect: [bertalan.voros**(a)onedomain.com**] (from client CiscoAP port 0)* *Using Post-Auth-Type Reject* *# Executing group from file /etc/raddb/sites-enabled/default* *+- entering group REJECT {...}* *[attr_filter.access_reject] expand: %{User-Name} -> bertalan.voros**@ onedomain.com* *attr_filter: Matched entry DEFAULT at line 11* *++[attr_filter.access_reject] returns updated* *Delaying reject of request 11 for 1 seconds* *Going to the next request* *Waking up in 0.9 seconds.* *Sending delayed reject for request 11* *Sending Access-Reject of id 242 to 10.205.128.7 port 54292* * MS-CHAP-Error = "\000E=691 R=1"* *Waking up in 4.9 seconds.* *Cleaning up request 11 ID 242 with timestamp +13* *Ready to process requests.* Your help will be appreciated, -- Bertalan Voros

2 2

Re: Python access to attribute lists
by Duarte Fonseca 01 Feb '13

01 Feb '13

Hi, I've modified rlm_python.c to get access to the remaining attribute lists if anyone is interested in the patch you can get it at https://dl.dropbox.com/u/797051/freeradius-python.patch The patch was done against version 2.1.12 shipped from CentOS. Any feedback would be greatly appreciated as I'm sure you can probably tell by the code I'm not a veteran C coder. Cheers, Duarte

1 0

Fw: [mschap] No Cleartext-Password configured. Cannot createLM-Password.
by Grzegorz Cimochowski 31 Jan '13

31 Jan '13

> Waking up in 3.4 seconds. > rad_recv: Access-Request packet from host 192.168.30.15 port 46844, > id=161, length=192 > Service-Type = Framed-User > Framed-Protocol = PPP > NAS-Port = 138584 > NAS-Port-Type = Ethernet > User-Name = "chmielewska_d" > Calling-Station-Id = "54:E6:FC:E7:EA:E7" > Called-Station-Id = "witosa3" > NAS-Port-Id = "ether1" > MS-CHAP-Challenge = 0x28c98da9117ed73968677b477bfe0adf > MS-CHAP2-Response = > 0x01000de14d8d5551d54ac1898b1baffc011300000000000000003372483474e6d9ef5302fdc1e3bb081e0f47a844c8258da7 > NAS-Identifier = "witosa3" > NAS-IP-Address = 192.168.30.15 > # Executing section authorize from file > /usr/local/etc/raddb/sites-enabled/default > +- entering group authorize {...} > ++[preprocess] returns ok > ++[chap] returns noop > [mschap] Found MS-CHAP attributes. Setting 'Auth-Type = mschap' > ++[mschap] returns ok > [suffix] No '@' in User-Name = "chmielewska_d", looking up realm NULL > [suffix] No such realm "NULL" > ++[suffix] returns noop > [eap] No EAP-Message, not doing EAP > ++[eap] returns noop > [sql] expand: %{User-Name} -> chmielewska_d > [sql] sql_set_user escaped user --> 'chmielewska_d' > rlm_sql (sql): Reserving sql socket id: 4 > [sql] expand: SELECT id, username, attribute, value, op FROM > radcheck WHERE username = '%{SQL-User-Name}' AND status = '1' > ORDER BY id -> SELECT id, username, attribute, value, op FROM > radcheck WHERE username = 'chmielewska_d' AND status = '1' ORDER > BY id > [sql] expand: SELECT groupname FROM radusergroup > WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT > groupname FROM radusergroup WHERE username = > 'chmielewska_d' ORDER BY priority > [sql] expand: SELECT id, groupname, attribute, Value, op FROM > radgroupcheck WHERE groupname = '%{Sql-Group}' ORDER BY id -> > SELECT id, groupname, attribute, Value, op FROM radgroupcheck > WHERE groupname = 'DaNET 1280' ORDER BY id > [sql] User found in group DaNET 1280 > [sql] expand: SELECT id, groupname, attribute, value, op FROM > radgroupreply WHERE groupname = '%{Sql-Group}' ORDER BY id -> > SELECT id, groupname, attribute, value, op FROM radgroupreply > WHERE groupname = 'DaNET 1280' ORDER BY id > rlm_sql (sql): Released sql socket id: 4 > ++[sql] returns ok > [pap] WARNING! No "known good" password found for the user. > Authentication may fail because of this. > ++[pap] returns noop > Found Auth-Type = MSCHAP > # Executing group from file /usr/local/etc/raddb/sites-enabled/default > +- entering group MS-CHAP {...} > [mschap] No Cleartext-Password configured. Cannot create LM-Password. > [mschap] No Cleartext-Password configured. Cannot create NT-Password. > [mschap] Creating challenge hash with username: chmielewska_d > [mschap] Client is using MS-CHAPv2 for chmielewska_d, we need NT-Password > [mschap] FAILED: No NT/LM-Password. Cannot perform authentication. > [mschap] FAILED: MS-CHAP2-Response is incorrect > ++[mschap] returns reject > Failed to authenticate the user. > Using Post-Auth-Type REJECT > # Executing group from file /usr/local/etc/raddb/sites-enabled/default > +- entering group REJECT {...} > [sql] expand: %{User-Name} -> chmielewska_d > [sql] sql_set_user escaped user --> 'chmielewska_d' > [sql] expand: %{User-Password} -> > [sql] ... expanding second conditional > [sql] expand: %{Chap-Password} -> > [sql] expand: INSERT INTO radpostauth > (username, pass, reply, authdate) VALUES > ( '%{User-Name}', > '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S') -> > INSERT INTO radpostauth (username, pass, reply, authdate) > VALUES ( 'chmielewska_d', > '', 'Access-Reject', '2013-01-31 14:34:55') > rlm_sql (sql) in sql_postauth: query is INSERT INTO radpostauth (username, > pass, reply, authdate) VALUES > ( 'chmielewska_d', '', > 'Access-Reject', '2013-01-31 14:34:55') > rlm_sql (sql): Reserving sql socket id: 3 > rlm_sql (sql): Released > > > this log interesed me > chmielewska_d is in database add > why: > +- entering group MS-CHAP {...} > [mschap] No Cleartext-Password configured. Cannot create LM-Password. > [mschap] No Cleartext-Password configured. Cannot create NT-Password. > [mschap] Creating challenge hash with username: chmielewska_d > [mschap] Client is using MS-CHAPv2 for chmielewska_d, we need NT-Password > [mschap] FAILED: No NT/LM-Password. Cannot perform authentication. > [mschap] FAILED: MS-CHAP2-Response is incorrect > ++[mschap] returns reject > ?

1 0

problem with username renamed in radacct table
by Hocine M 31 Jan '13

31 Jan '13

3 4

can't seem to authenticate only from windows 7 laptops
by 김동욱 31 Jan '13

31 Jan '13

Hi, I’m new to the list and freeRADIUS. I’ve encountered a problem while I’m trying to build a wireless network environment using freeRADIUS. I’ve setup a custom wireless router using Openwrt and freeRADIUS with Mysql. I have a couple of wireless clients - smartphones, laptops (win7, win8, mac) >From windows 8 station, mac and smartphones I can access to wireless router successfully authenticating through freeradius, while I can’t seem to authenticate from windows 7 clients. I’ve checked the error logs from radius server and windows 7 client is sending their computer-name as an username instead of the one I entered. I don’t have any domain controller nor am I using certificate right now. Any suggestion? Thanks, D Kim

2 2

Question : EAP-SIM without RANDs, SRESs, KCs ?
by bino＠indoakses-online.com 31 Jan '13

31 Jan '13

Dear All I found same problem of old topic posted back in Feb-2012 For ref : http://lists.freeradius.org/pipermail/freeradius-users/2012-February/058868… I think the faulty lines (from debug) is : ---------START--------- Found Auth-Type = EAP # Executing group from file /usr/local/etc/raddb/sites-enabled/default +- entering group authenticate {...} [eap] EAP Identity [eap] processing type sim can not initiate sim, no RAND1 attribute [eap] Default EAP type sim failed in initiate [eap] Failed in EAP select ---------STOP---------- Look like The device didn\'t send : RAND1, RAND2, RAND3 SRES1, SRES2, SRES3 KC1, KC2, KC3 Expected by FreeRadius EAP-SIM Am I right ? If so, How to fix it ? Sincerely -bino-

2 7

Best way to apply default profile
by Chris Taylor 31 Jan '13

31 Jan '13

This is the scenario that I have freeradius with LDAP for authentication and authorization and SQL for accounting. I want to try and force every user to have a default profile that will allow them to only use our local SMTP server. I also have some businesses that I will need to exclude from this profile and allow to them send SMTP traffic anywhere. What is the best way to go about this? Should I put the options in the users file and then create an entry for the select users in SQL and have it pull the separate profile from there? These are the options and profiles that I would like to apply; ### Allow local SMTP only ### acl_permit_local_smtp Cisco-AVPair += ip:inacl#100=permit tcp any 24.222.0.16 0.0.0.15 eq 25 acl_permit_local_smtp Cisco-AVPair += ip:inacl#200=deny tcp any any eq 25 acl_permit_lcoal_smtp Cisco-AVPair += ip:inacl#300=permit ip any any acl_permit_lcoal_smtp Fall-Through = Yes ### Allow any SMTP ### acl_permit_all_smtp Cisco-AVPair += ip:inacl#90=permit tcp any any eq 25 acl_permit_all_smtp Fall-Through = Yes I am just looking for the best way to do this. Thanks, Chris

2 1