September 2010 - Freeradius-Users - lists.freeradius.org

Re: Re: Re: Re: FreeRADIUS with Samba3, AD(Samba4) and and Windows XP
by Бисер Миланов 10 Sep '10

10 Sep '10

I have disabled certificate checking on the Windows machine. Here's the log from the XP client: Reason: An internal error has occurred. Reason code: 327685 Error code: -2147023537 On the switch I see this repeated several times. The ca58 MAC is the Windows MAC, so this means that it somehow manages to answer to the RADIUS? *Mar 10 18:32:57.644: dot1x-ev(Gi0/2): Received pkt saddr =0019.6654.ca58 , daddr = 0180.c200.0003, pae-ether-type = 888e.0100.0029 *Mar 10 18:32:57.644: dot1x-ev(Gi0/2): dot1x_sendRespToServer: Response sent to the server from 0xA00006DE (0019.6654.ca58) *Mar 10 18:32:57.653: dot1x-ev(Gi0/2): Sending EAPOL packet to group PAE address *Mar 10 18:32:57.653: dot1x-ev(Gi0/2): Role determination not required *Mar 10 18:32:57.653: dot1x-ev(Gi0/2): Sending out EAPOL packet *Mar 10 18:32:57.653: dot1x-ev(Gi0/2): Role determination not required *Mar 10 18:32:57.653: dot1x-ev:Enqueued the eapol packet to the global authenticator queue *Mar 10 18:32:57.653: EAPOL pak dump rx *Mar 10 18:32:57.653: EAPOL Version: 0x1 type: 0x0 length: 0x005F *Mar 10 18:32:57.653: dot1x-ev: dot1x_auth_queue_event: Int Gi0/2 CODE= 2,TYPE= 25,LEN= 95 ----------------------------------------------------------------- Чартъри до Египет – Кайро, Хургада и круиз по Нил. 8 дни, от 275€ http://www.astralholidays.bg/pochivki/program/38/country/8.html

1 0

Newbie: help to configure PEAP extension for windows XP wireless Clients
by Stephane Brodeur 10 Sep '10

10 Sep '10

Hi, I am a newbie with Radius and I have problems to authenticate XP wireless clients with eap. I think that my first problem is due to the fact that Windows XP client requires a Certificate Authority since Windows only recognized signed certificate. I could not find the certificate properties windows as shown in the following link: http://deployingradius.com/documents/configuration/eap.html My first question is where is this Smart Card or other Certificate Properties window, is it in the wireless 802.1x configuration window or in the internet explorer where you import certificate. I am using Windows XP with service pack 3. 2) Does FreeRadius generates automatically a self-signed Certificates when we start radiusd -X for the first time. Can we also imports the ca.der file into Windows XP to test our PEAP authentication. Does the server certificate created with the self-signed certificate is good enough to authenticate Windows XP wireless client 3) Can we used the root/server/client self-signed certificate for authentication EAP-TLS. Does making new root/server/client certificate with the make function overides thte self-one Thanks for all your help Stephane

2 1

None
by John 09 Sep '10

09 Sep '10

Hi all, We upgrade freeradius from 1.1.6 to 2.1.18 recently. Looks 2.1.8 will reply a Access-Reject when [ldap] return fail, but 1.1.6 is just keep silence. Is there a way to let 2.1.8 reply nothing in the case? Listening on authentication address * port 1812 Listening on proxy address * port 1814 Ready to process requests. rad_recv: Access-Request packet from host 10.155.20.85 port 32770, id=182, length=130 Service-Type = Authorize-Only NAS-Port-Type = Wireless-802.11 User-Name = "test2008" MS-CHAP-Challenge = 0x766bb4f5ae93e28b4630b8fbc674e137 MS-CHAP2-Response = 0x3700e851effcf3aa3f7731204ca90dcbd98300000000000000006c9248ca4d87e72d0b4a91dbd2672bb1f8f5b725187953ff NAS-IP-Address = 10.155.20.85 +- entering group authorize {...} ++[chap] returns noop [mschap] Found MS-CHAP attributes. Setting 'Auth-Type = mschap' ++[mschap] returns ok [eap] No EAP-Message, not doing EAP ++[eap] returns noop [ldap] performing user authorization for test2008 [ldap] expand: (sAMAccountName=%{mschap:User-Name}) -> (sAMAccountName=test2008) [ldap] expand: OU=Domain Controllers,dc=aero-hz,dc=cn -> OU=Domain Controllers,dc=aerohive-hz,dc=cn [ldap] ldap_get_conn: Checking Id: 0 [ldap] ldap_get_conn: Got Id: 0 [ldap] attempting LDAP reconnection [ldap] (re)connect to 10.155.3.2:389, authentication 0 [ldap] bind as hhe(a)aero-hz.cn/w200h to 10.155.3.2:389 [ldap] hhe(a)aero-hz.cn bind to 10.155.3.2:389 failed: Can't contact LDAP server [ldap] (re)connection attempt failed [ldap] search failed [ldap] ldap_release_conn: Release Id: 0 ++[ldap] returns fail Sending Access-Reject of id 182 to 10.155.20.85 port 32770 Finished request 0. Going to the next request Waking up in 4.9 seconds. Cleaning up request 0 ID 182 with timestamp +10 Ready to process requests.

2 5

Wildcard in realm name? possible??
by Difan Zhao 09 Sep '10

09 Sep '10

Dear developers/experts, I haven't bugged you guys for too long so I decided to come back with a strange question so you know that I'm still your loyal user. I need to proxy requests with the following username pattern to a remote server. host/<PC name>.gtcorp.com This is what the username looks like when the Windows PC is doing PEAP with use of the PC's name instead of the actual user's username. Don't know why but seems to be strange! So I guess my first question is that, is it possible to have wildcard (e.g. "*") in the realm name? I did read all the docs I could possibly found and I tested the configs as well but I couldn't get it to work... Here is the debug while I'm doing testing with radtest program. As you see that it always matches the "DEFAULT" realm but not the *.gtcorp.com that I defined... I'm using 2.1.6 on RHEL4. So! Help help! [root@NE_OVI ~]# radtest 'host/difan.gtcorp.com' xxxx localhost 0 test123 Sending Access-Request of id 163 to 127.0.0.1 port 1812 User-Name = "host/difan.gtcorp.com" User-Password = "xxxx" NAS-IP-Address = 66.150.161.140 NAS-Port = 0 rad_recv: Access-Reject packet from host 127.0.0.1 port 1812, id=163, length=20 ------------------------------------------------------------------------ ------------ rad_recv: Access-Request packet from host 127.0.0.1 port 15676, id=163, length=73 User-Name = "host/difan.gtcorp.com" User-Password = "xxxx" NAS-IP-Address = 66.150.161.140 NAS-Port = 0 +- entering group authorize {...} ++[preprocess] returns ok ++[chap] returns noop ++[mschap] returns noop [GTCORP] Looking up realm "difan.gtcorp.com" for User-Name = "host/difan.gtcorp.com" [GTCORP] Found realm "DEFAULT" [GTCORP] Adding Realm = "DEFAULT" [GTCORP] Proxying request from user host to realm DEFAULT [GTCORP] Preparing to proxy authentication request to realm "DEFAULT" ++[GTCORP] returns updated [suffix] Request already proxied. Ignoring. ++[suffix] returns ok ... The followings are my relevant configs: ================================================================== /etc/raddb/proxy.conf (I did try many other realm names such as *.gtcorp.com as well) ================================================================== proxy server { default_fallback = no } ############################### home_server GTK_Radius_Auth { type = auth ipaddr = 1.1.1.1 port = 1812 secret = xxxx } home_server GTK_Radius_Acct { type = acct ipaddr = 1.1.1.1 port = 1813 secret = xxxx } #################################################### home_server_pool GTK_Radius_Auth_Pool { type = fail-over home_server = GTK_Radius_Auth } home_server_pool GTK_Radius_Acct_Pool { type = fail-over home_server = GTK_Radius_Acct } #################################################### realm ~"*.gtcorp.com" { nostrip auth_pool = GTK_Radius_Auth_Pool acct_pool = GTK_Radius_Acct_Pool } # # This realm is for requests which don't have an explicit realm # prefix or suffix. User names like "bob" will match this one. # realm NULL { nostrip auth_pool = GTK_Radius_Auth_Pool acct_pool = GTK_Radius_Acct_Pool } # # This realm is for ALL OTHER requests. # realm DEFAULT { nostrip auth_pool = GTK_Radius_Auth_Pool acct_pool = GTK_Radius_Acct_Pool } =========================================================== /etc/raddb/modules/realm =========================================================== realm GTCORP { format = suffix delimiter = "/" } ========================================================== /etc/raddb/sites-available/default ========================================================== ... authorize { preprocess chap mschap GTCORP Suffix ... } Thanks!! Difan Zhao, M.Eng Network Engineer Guest-Tek Interactive Entertainment Inc. Email: difan.zhao(a)guest-tek.com <mailto:difan.zhao@guest-tek.com> Office: +1 (403) 509 1010 ext 3048 Cell: +1 (403) 689 7514 www.guest-tek.com <http://www.guest-tek.com> http://www.guest-tek.com/images/Guest-Tek%20-%20Formal_files/Logo.jpg<ht tp://www.guest-tek.com/images/Guest-Tek%20-%20Formal_files/Logo.jpg> INTERNET | MEDIA | VOICE http://www.guest-tek.com/images/Guest-Tek%20-%20Formal_files/image004.jp g<http://www.guest-tek.com/images/Guest-Tek%20-%20Formal_files/image004. jpg> The contents of this email are confidential and intended for the recipient only. If you have received this email in error, please notify us, and destroy all copies.

2 2

Re: Re: Re: FreeRADIUS with Samba3, AD(Samba4) and and Windows XP
by Бисер Миланов 09 Sep '10

09 Sep '10

UPDATE: I istalled the FreeRADIUS certificate and selected it so that the client will check it when it authenticates. I still get the same error. Now I will recreate the same scenario with Samba3 to see if it works. By the way, I'm running FreeRADIUS 2.1.8 and Samba4.0.0alpha12

1 0

Re: Re: FreeRADIUS with Samba3, AD(Samba4) and and Windows XP
by Бисер Миланов 09 Sep '10

09 Sep '10

Woooow, is THAT really the problem?! I will test it as soon as I finish writing this post. I have disabled the client to check the server and it still needs the FreeRADIUS certificate?

1 0

FreeRADIUS with Samba3, AD(Samba4) and and Windows XP
by Бисер Миланов 09 Sep '10

09 Sep '10

Hello! We have a problem with a FreeRADIUS and Active Directory (Samba4) installation. After following: http://deployingradius.com/documents/configuration/active_directory.html ntlm_auth is working correctly when I try to authenticate a WinXP SP3 client, however, the authentication fails here: Found Auth-Type = EAP +- entering group authenticate {...} [eap] Request found, released from the list [eap] EAP/mschapv2 [eap] processing type mschapv2 [mschapv2] +- entering group MS-CHAP {...} [mschap] Told to do MS-CHAPv2 for tester with NT-Password [mschap] expand: %{Stripped-User-Name} -> [mschap] ... expanding second conditional [mschap] WARNING: Deprecated conditional expansion ":-". See "man unlang" for details [mschap] expand: %{User-Name:-None} -> tester [mschap] expand: --username=%{%{Stripped-User-Name}:-%{User-Name:-None}} -> --username=tester [mschap] mschap2: d6 [mschap] expand: --challenge=%{mschap:Challenge:-00} -> --challenge=d403bba2070cf6e8 [mschap] expand: --nt-response=%{mschap:NT-Response:-00} -> --nt-response=af94dd4de371c9841bf877d46e305a02ded73887b31ee1b4 Exec-Program output: NT_KEY: 46400C4F130794910739F005A8C45821 Exec-Program-Wait: plaintext: NT_KEY: 46400C4F130794910739F005A8C45821 Exec-Program: returned: 0 [mschap] adding MS-CHAPv2 MPPE keys ++[mschap] returns ok MSCHAP Success ++[eap] returns handled } # server [peap] Got tunneled reply code 11 EAP-Message = 0x010800331a0307002e533d41343234334238464641363637383739374636463346334543354539344431433641363737383335 Message-Authenticator = 0x00000000000000000000000000000000 State = 0x5543652a544b7f1d5179a5e433696c2c [peap] Got tunneled reply RADIUS code 11 EAP-Message = 0x010800331a0307002e533d41343234334238464641363637383739374636463346334543354539344431433641363737383335 Message-Authenticator = 0x00000000000000000000000000000000 State = 0x5543652a544b7f1d5179a5e433696c2c [peap] Got tunneled Access-Challenge ++[eap] returns handled Sending Access-Challenge of id 19 to 10.2.1.3 port 1645 EAP-Message = 0x0108004a1900170301003f02a1a58fbb50b524475113279c8c6e0233d96507294ed892871d2fe941c1832e90edbc635a5a6306e9aa9b4a21d153b3c6c2b1f34d0d760252495f5c05fabd Message-Authenticator = 0x00000000000000000000000000000000 State = 0x1b05ec0d1d0df5adcd779ed1359b432b Finished request 6. Going to the next request Waking up in 4.9 seconds. Cleaning up request 0 ID 13 with timestamp +18 Cleaning up request 1 ID 14 with timestamp +18 Cleaning up request 2 ID 15 with timestamp +18 Cleaning up request 3 ID 16 with timestamp +18 Cleaning up request 4 ID 17 with timestamp +18 Cleaning up request 5 ID 18 with timestamp +18 Cleaning up request 6 ID 19 with timestamp +18 Ready to process requests. I seems that FreeRADIUS is sending an Access-Challenge but does not get a reply. What can be the source of the problem?

4 4

LDAP Data Mangling
by Kevin Ehlers 09 Sep '10

09 Sep '10

Hi, Is it possible to modify attributes returned from ldap? E.g. We're trying to do wpa-enterprise with peap-mschapv2. We store our nt hash passwords as "{nthash}<hash>" instead of "{nt}<hash>". It looks like the mschap module doesn't auto-detect the hash-type correctly, and says that it never received a valid password hash. All authentication fails at this point. We store it as {nthash} because that's what our other radius servers (radiator) expect to see. I searched the archives, but was unable to find anything about that. Thanks, -- Kevin Ehlers Network Engineer University of Oregon

2 3

sqlcounter help
by Mordor Networks 09 Sep '10

09 Sep '10

Dear Gentlemen I'm having a problem with my daily count : sqlcounter chillispot_max_bytes_daily { counter-name = ChilliSpot-Max-Total-Octets check-name = ChilliSpot-Max-Total-Octets reply-name = ChilliSpot-Max-Total-Octets sqlmod-inst = sql key = User-Name reset = daily query = "SELECT SUM(AcctInputOctets - GREATEST((%b - UNIX_TIMESTAMP(AcctStartTime)), 0))+ SUM(AcctOutputOctets -GREATEST((%b - UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{%k}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'" } It is disconnecting the user if limit is reached but user can connect again like it is not stopping the account, now if i replace the query with #query = "SELECT (SUM(AcctInputOctets)+SUM(AcctOutputOctets)) FROM radacct WHERE UserName='%{%k}'" that will disconnect the account and it wont be able to connect again but the problem here with reset , how i will be able to reset daily? Best regards

2 2

Freeradius2 & Mysql
by shawky skaff 09 Sep '10

09 Sep '10

Hi, Just wondering if I can some help with my Freeradius2 and mysql setup. I'm kind of new to this. I'm receiving an error when trying to radtest while running radiusd -X. This debug is below. I have followed the wiki pages most of the way. Can someone lead my in the right direction? Starting - reading configuration files ... including configuration file /etc/raddb/radiusd.conf including configuration file /etc/raddb/proxy.conf including configuration file /etc/raddb/clients.conf including files in directory /etc/raddb/modules/ including configuration file /etc/raddb/modules/detail including configuration file /etc/raddb/modules/inner-eap including configuration file /etc/raddb/modules/pap including configuration file /etc/raddb/modules/sradutmp including configuration file /etc/raddb/modules/smbpasswd including configuration file /etc/raddb/modules/expr including configuration file /etc/raddb/modules/attr_filter including configuration file /etc/raddb/modules/counter including configuration file /etc/raddb/modules/sqlcounter_expire_on_login including configuration file /etc/raddb/modules/exec including configuration file /etc/raddb/modules/digest including configuration file /etc/raddb/modules/expiration including configuration file /etc/raddb/modules/sql_log including configuration file /etc/raddb/modules/otp including configuration file /etc/raddb/modules/perl including configuration file /etc/raddb/modules/mac2vlan including configuration file /etc/raddb/modules/linelog including configuration file /etc/raddb/modules/echo including configuration file /etc/raddb/modules/smsotp including configuration file /etc/raddb/modules/detail.log including configuration file /etc/raddb/modules/policy including configuration file /etc/raddb/modules/mac2ip including configuration file /etc/raddb/modules/chap including configuration file /etc/raddb/modules/radutmp including configuration file /etc/raddb/modules/wimax including configuration file /etc/raddb/modules/unix including configuration file /etc/raddb/modules/ippool including configuration file /etc/raddb/modules/etc_group including configuration file /etc/raddb/modules/cui including configuration file /etc/raddb/modules/always including configuration file /etc/raddb/modules/preprocess including configuration file /etc/raddb/modules/passwd including configuration file /etc/raddb/modules/pam including configuration file /etc/raddb/modules/realm including configuration file /etc/raddb/modules/detail.example.com including configuration file /etc/raddb/modules/mschap including configuration file /etc/raddb/modules/attr_rewrite including configuration file /etc/raddb/modules/files including configuration file /etc/raddb/modules/logintime including configuration file /etc/raddb/modules/acct_unique including configuration file /etc/raddb/modules/checkval including configuration file /etc/raddb/eap.conf including configuration file /etc/raddb/sql.conf including configuration file /etc/raddb/sql/mysql/dialup.conf including configuration file /etc/raddb/policy.conf including files in directory /etc/raddb/sites-enabled/ including configuration file /etc/raddb/sites-enabled/inner-tunnel including configuration file /etc/raddb/sites-enabled/control-socket including configuration file /etc/raddb/sites-enabled/default group = radiusd user = radiusd including dictionary file /etc/raddb/dictionary main { prefix = "/usr" localstatedir = "/var" logdir = "/var/log/radius" libdir = "/usr/lib/freeradius" radacctdir = "/var/log/radius/radacct" hostname_lookups = no max_request_time = 30 cleanup_delay = 5 max_requests = 1024 allow_core_dumps = no pidfile = "/var/run/radiusd/radiusd.pid" checkrad = "/usr/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 = no 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 exec exec { wait = no input_pairs = "request" shell_escape = yes } Module: Linked to module rlm_expr Module: Instantiating expr Module: Linked to module rlm_expiration Module: Instantiating expiration expiration { reply-message = "Password Has Expired " } Module: Linked to module rlm_logintime Module: Instantiating logintime logintime { reply-message = "You are calling outside your allowed timespan " minimum-timeout = 60 } } radiusd: #### Loading Virtual Servers #### server inner-tunnel { modules { Module: Checking authenticate {...} for more modules to load Module: Linked to module rlm_pap Module: Instantiating pap pap { encryption_scheme = "auto" auto_header = no } Module: Linked to module rlm_chap Module: Instantiating chap Module: Linked to module rlm_mschap Module: Instantiating mschap mschap { use_mppe = yes require_encryption = no require_strong = no with_ntdomain_hack = no } Module: Linked to module rlm_unix Module: Instantiating unix unix { radwtmp = "/var/log/radius/radwtmp" } Module: Linked to module rlm_eap Module: Instantiating eap eap { default_eap_type = "md5" timer_expire = 60 ignore_unknown_eap_types = no cisco_accounting_username_bug = no max_sessions = 2048 } Module: Linked to sub-module rlm_eap_md5 Module: Instantiating eap-md5 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 pem_file_type = yes private_key_file = "/etc/raddb/certs/server.pem" certificate_file = "/etc/raddb/certs/server.pem" CA_file = "/etc/raddb/certs/ca.pem" private_key_password = "whatever" dh_file = "/etc/raddb/certs/dh" random_file = "/etc/raddb/certs/random" fragment_size = 1024 include_length = yes check_crl = no cipher_list = "DEFAULT" make_cert_command = "/etc/raddb/certs/bootstrap" cache { enable = no lifetime = 24 max_entries = 255 } } 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 suffix realm suffix { format = "suffix" delimiter = "@" ignore_default = no ignore_null = no } Module: Linked to module rlm_files Module: Instantiating files files { usersfile = "/etc/raddb/users" acctusersfile = "/etc/raddb/acct_users" preproxy_usersfile = "/etc/raddb/preproxy_users" compat = "no" } Module: Checking session {...} for more modules to load Module: Linked to module rlm_radutmp Module: Instantiating radutmp radutmp { filename = "/var/log/radius/radutmp" username = "%{User-Name}" case_sensitive = yes check_with_nas = yes perm = 384 callerid = yes } Module: Checking post-proxy {...} for more modules to load Module: Checking post-auth {...} for more modules to load Module: Linked to module rlm_attr_filter Module: Instantiating attr_filter.access_reject attr_filter attr_filter.access_reject { attrsfile = "/etc/raddb/attrs.access_reject" key = "%{User-Name}" } } # modules } # server server { modules { Module: Checking authenticate {...} for more modules to load Module: Checking authorize {...} for more modules to load Module: Linked to module rlm_preprocess Module: Instantiating preprocess preprocess { huntgroups = "/etc/raddb/huntgroups" hints = "/etc/raddb/hints" with_ascend_hack = no ascend_channels_per_line = 23 with_ntdomain_hack = no with_specialix_jetstream_hack = no with_cisco_vsa_hack = no with_alvarion_vsa_hack = no } Module: Linked to module rlm_sql Module: Instantiating sql sql { driver = "rlm_sql_mysql" server = "localhost" port = "" login = "root" password = "(mypassword)" radius_db = "radius" read_groups = yes sqltrace = no sqltracefile = "/var/log/radius/sqltrace.sql" readclients = no deletestalesessions = yes num_sql_socks = 5 lifetime = 0 max_queries = 0 sql_user_name = "%{User-Name}" default_user_profile = "" nas_query = "SELECT id, nasname, shortname, type, secret FROM nas" authorize_check_query = "SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id" authorize_reply_query = "SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id" authorize_group_check_query = "SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{Sql-Group}' ORDER BY id" authorize_group_reply_query = "SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{Sql-Group}' ORDER BY id" accounting_onoff_query = " UPDATE radacct SET acctstoptime = '%S', acctsessiontime = unix_timestamp('%S') - unix_timestamp(acctstarttime), acctterminatecause = '%{Acct-Terminate-Cause}', acctstopdelay = %{%{Acct-Delay-Time}:-0} WHERE acctstoptime IS NULL AND nasipaddress = '%{NAS-IP-Address}' AND acctstarttime <= '%S'" accounting_update_query = " UPDATE radacct SET framedipaddress = '%{Framed-IP-Address}', acctsessiontime = '%{Acct-Session-Time}', acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}'" accounting_update_query_alt = " INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctsessiontime, acctauthentic, connectinfo_start, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, servicetype, framedprotocol, framedipaddress, acctstartdelay, xascendsessionsvrkey) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', DATE_SUB('%S', INTERVAL (%{%{Acct-Session-Time}:-0} + %{%{Acct-Delay-Time}:-0}) SECOND), '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0', '%{X-Ascend-Session-Svr-Key}')" accounting_start_query = " INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress, acctstartdelay, acctstopdelay, xascendsessionsvrkey) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', '%S', NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '%{%{Acct-Delay-Time}:-0}', '0', '%{X-Ascend-Session-Svr-Key}')" accounting_start_query_alt = " UPDATE radacct SET acctstarttime = '%S', acctstartdelay = '%{%{Acct-Delay-Time}:-0}', connectinfo_start = '%{Connect-Info}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}'" accounting_stop_query = " UPDATE radacct SET acctstoptime = '%S', acctsessiontime = '%{Acct-Session-Time}', acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}', acctterminatecause = '%{Acct-Terminate-Cause}', acctstopdelay = '%{%{Acct-Delay-Time}:-0}', connectinfo_stop = '%{Connect-Info}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}'" accounting_stop_query_alt = " INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress, acctstartdelay, acctstopdelay) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', DATE_SUB('%S', INTERVAL (%{%{Acct-Session-Time}:-0} + %{%{Acct-Delay-Time}:-0}) SECOND), '%S', '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{Connect-Info}', '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Acct-Terminate-Cause}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0', '%{%{Acct-Delay-Time}:-0}')" group_membership_query = "SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority" connect_failure_retry_delay = 60 simul_count_query = "" simul_verify_query = "SELECT radacctid, acctsessionid, username, nasipaddress, nasportid, framedipaddress, callingstationid, framedprotocol FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL" postauth_query = "INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '%{User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S')" safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" } rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to root@localhost:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0 rlm_sql (sql): Connected new DB handle, #0 rlm_sql (sql): starting 1 rlm_sql (sql): Attempting to connect rlm_sql_mysql #1 rlm_sql_mysql: Starting connect to MySQL server for #1 rlm_sql (sql): Connected new DB handle, #1 rlm_sql (sql): starting 2 rlm_sql (sql): Attempting to connect rlm_sql_mysql #2 rlm_sql_mysql: Starting connect to MySQL server for #2 rlm_sql (sql): Connected new DB handle, #2 rlm_sql (sql): starting 3 rlm_sql (sql): Attempting to connect rlm_sql_mysql #3 rlm_sql_mysql: Starting connect to MySQL server for #3 rlm_sql (sql): Connected new DB handle, #3 rlm_sql (sql): starting 4 rlm_sql (sql): Attempting to connect rlm_sql_mysql #4 rlm_sql_mysql: Starting connect to MySQL server for #4 rlm_sql (sql): Connected new DB handle, #4 Module: Checking preacct {...} for more modules to load Module: Linked to module rlm_acct_unique Module: Instantiating acct_unique acct_unique { key = "User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port" } Module: Checking accounting {...} for more modules to load Module: Linked to module rlm_detail Module: Instantiating detail detail { detailfile = "/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d" header = "%t" detailperm = 384 dirperm = 493 locking = no log_packet_header = no } Module: Instantiating attr_filter.accounting_response attr_filter attr_filter.accounting_response { attrsfile = "/etc/raddb/attrs.accounting_response" key = "%{User-Name}" } Module: Checking session {...} for more modules to load Module: Checking post-proxy {...} for more modules to load Module: Checking post-auth {...} for more modules to load } # modules } # server radiusd: #### Opening IP addresses and Ports #### listen { type = "auth" ipaddr = * port = 0 } listen { type = "acct" ipaddr = * port = 0 } listen { type = "control" listen { socket = "/var/run/radiusd/radiusd.sock" } } Listening on authentication address * port 1812 Listening on accounting address * port 1813 Listening on command file /var/run/radiusd/radiusd.sock Listening on proxy address * port 1814 Ready to process requests. rad_recv: Access-Request packet from host 127.0.0.1 port 40723, id=32, length=57 User-Name = "fredf" User-Password = "wilma" NAS-IP-Address = 192.168.0.210 NAS-Port = 0 +- entering group authorize {...} ++[preprocess] returns ok ++[chap] returns noop ++[mschap] returns noop [suffix] No '@' in User-Name = "fredf", looking up realm NULL [suffix] No such realm "NULL" ++[suffix] returns noop [eap] No EAP-Message, not doing EAP ++[eap] returns noop ++[unix] returns notfound ++[files] returns noop [sql] expand: %{User-Name} -> fredf [sql] sql_set_user escaped user --> 'fredf' rlm_sql (sql): Reserving sql socket id: 4 [sql] expand: SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'fredf' ORDER BY id [sql] User found in radcheck table [sql] expand: SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'fredf' ORDER BY id [sql] expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup WHERE username = 'fredf' 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 = 'dynamic' ORDER BY id rlm_sql_mysql: MYSQL check_error: 1146 received rlm_sql_getvpdata: database query error [sql] Error retrieving check pairs for group dynamic [sql] Error processing groups; rejecting user rlm_sql (sql): Released sql socket id: 4 ++[sql] returns fail Using Post-Auth-Type Reject +- entering group REJECT {...} [attr_filter.access_reject] expand: %{User-Name} -> fredf attr_filter: Matched entry DEFAULT at line 11 ++[attr_filter.access_reject] returns updated Delaying reject of request 0 for 1 seconds Going to the next request Waking up in 0.9 seconds. Sending delayed reject for request 0 Sending Access-Reject of id 32 to 127.0.0.1 port 40723 Waking up in 4.9 seconds. Cleaning up request 0 ID 32 with timestamp +11 Ready to process requests. Mysql database - radius, tables are below mysql> select * from radusergroup; +------------+-----------+----------+ | username | groupname | priority | +------------+-----------+----------+ | fredf | dynamic | 1 | | barney | static | 1 | | dialrouter | netdial | 1 | +------------+-----------+----------+ 3 rows in set (0.00 sec) mysql> select * from radcheck; +----+------------+--------------------+----+--------+ | id | username | attribute | op | value | +----+------------+--------------------+----+--------+ | 1 | fredf | Cleartext-Password | := | wilma | | 2 | barney | Cleartext-Password | := | betty | | 3 | dialrouter | Cleartext-Password | := | dialup | +----+------------+--------------------+----+--------+ 3 rows in set (0.00 sec) mysql> select * from radreply; +----+------------+--------------------+----+-------------------------+ | id | username | attribute | op | value | +----+------------+--------------------+----+-------------------------+ | 1 | dynamic | Framed-Compression | := | Van-Jacobsen-TCP-IP | | 2 | dynamic | Framed-IP-Address | := | 2.3.4.1 | | 3 | dynamic | Framed-IP-Netmask | := | 255.255.255.255 | | 4 | dynamic | Framed-Routing | := | Broadcast-Listen | | 5 | dialrouter | Framed-Route | := | 2.3.4.0 255.255.255.248 | | 6 | dialrouter | Idle-Timeout | := | 900 | +----+------------+--------------------+----+-------------------------+ 6 rows in set (0.01 sec) mysql> select * from radgroupreply; +----+-----------+--------------------+----+---------------------+ | id | groupname | attribute | op | value | +----+-----------+--------------------+----+---------------------+ | 34 | dynamic | Framed-Compression | := | Van-Jacobsen-TCP-IP | | 33 | dynamic | Framed-Protocol | := | PPP | | 32 | dynamic | Service-Type | := | Framed-User | | 35 | dynamic | Framed-MTU | := | 1500 | | 37 | static | Framed-Protocol | := | PPP | | 38 | static | Service-Type | := | Framed-User | | 39 | static | Framed-Compression | := | Van-Jacobsen-TCP-IP | | 41 | netdial | Service-Type | := | Framed-User | | 42 | netdial | Framed-Protocol | := | PPP | +----+-----------+--------------------+----+---------------------+ 9 rows in set (0.00 sec) Thanks, Shawky

3 3