<div>Are you using sql as users database ?</div>
<div> </div>
<div>I've done a FreeRadius for authentication my wireless users but I've used Ldap+Samba as users database.</div>
<div> </div>
<div>I have done EAP-TLS and everything worked.</div>
<div> </div>
<div>search for EAP-TLS in freeradius maillist and too for maiconlp. it's likely you will find my post. it's showing all step for create ldap + Samba.</div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div><br> </div>
<div class="gmail_quote">2011/3/29 <span dir="ltr"><<a href="mailto:freeradius-users-request@lists.freeradius.org">freeradius-users-request@lists.freeradius.org</a>></span><br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">Send Freeradius-Users mailing list submissions to<br> <a href="mailto:freeradius-users@lists.freeradius.org">freeradius-users@lists.freeradius.org</a><br>
<br>To subscribe or unsubscribe via the World Wide Web, visit<br> <a href="http://lists.freeradius.org/mailman/listinfo/freeradius-users" target="_blank">http://lists.freeradius.org/mailman/listinfo/freeradius-users</a><br>
or, via email, send a message with subject or body 'help' to<br> <a href="mailto:freeradius-users-request@lists.freeradius.org">freeradius-users-request@lists.freeradius.org</a><br><br>You can reach the person managing the list at<br>
<a href="mailto:freeradius-users-owner@lists.freeradius.org">freeradius-users-owner@lists.freeradius.org</a><br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of Freeradius-Users digest..."<br>
<br><br>Today's Topics:<br><br> 1. EAP-TTLS Problem (Milosh Droxy)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Tue, 29 Mar 2011 16:10:41 +0430<br>From: Milosh Droxy <<a href="http://droxy.net/" target="_blank">droxy.net</a>@<a href="http://gmail.com/" target="_blank">gmail.com</a>><br>
Subject: EAP-TTLS Problem<br>To: <a href="mailto:freeradius-users@lists.freeradius.org">freeradius-users@lists.freeradius.org</a><br>Message-ID:<br> <<a href="mailto:AANLkTim1pbcg7w30RLQj-iMTW7BTVCxtHGN_Nc3xS6Rm@mail.gmail.com">AANLkTim1pbcg7w30RLQj-iMTW7BTVCxtHGN_Nc3xS6Rm@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="iso-8859-1"<br><br>Hi<br><br>ok, I've been searching and testing for about a week now. I'm quite sure<br>I've read almost every topic related to my problem on this mailing-list and<br>
others. and I was afraid to ask for help because I've never posted on a<br>mailing list or a forum and I was really afraid of Alan DeKoK.<br>The Problem:<br>I'm trying to use Freeradius to authenticate users using EAP-TTLS MSCHAP,<br>
with no success.<br>I use "FreeRADIUS Version 2.1.10, for host x86_64-unknown-linux-gnu". on a<br>Ubuntu 10.04 64bit Server.<br>I've used these devices as clients<br>two Ubiquiti devices (<a href="http://www.ubnt.com/nanobridge" target="_blank">http://www.ubnt.com/nanobridge</a>) (one as AP and one as<br>
client)<br>A TP-Link TL-WR542G as AP and my laptop (running ubuntu 10.10) as client.<br>(and an iPad)<br>(There were NO Windows XP in any of my tests, so it's not a Microsoft issue)<br><br>and I've used eapol_test, with successful results, the problem only shows<br>
when I try to authenticate remotely. since the eapol_test results were fine<br>I wont post the output here. (or should I ?)<br><br>and here is the output for when I try to authenticate remotely (the output<br>is exactly the same with any combination I've tried)<br>
<br>FreeRADIUS Version 2.1.10, for host x86_64-unknown-linux-gnu, built on Mar<br>5 2011 at 07:22:25<br>Starting - reading configuration files ...<br>including configuration file /usr/local/etc/raddb/radiusd.conf<br>including configuration file /usr/local/etc/raddb/proxy.conf<br>
including configuration file /usr/local/etc/raddb/clients.conf<br>including files in directory /usr/local/etc/raddb/modules/<br>including configuration file /usr/local/etc/raddb/modules/ntlm_auth<br>including configuration file /usr/local/etc/raddb/modules/sradutmp<br>
including configuration file /usr/local/etc/raddb/modules/dynamic_clients<br>including configuration file /usr/local/etc/raddb/modules/realm<br>including configuration file /usr/local/etc/raddb/modules/attr_rewrite<br>including configuration file /usr/local/etc/raddb/modules/mac2vlan<br>
including configuration file /usr/local/etc/raddb/modules/linelog<br>including configuration file /usr/local/etc/raddb/modules/logintime<br>including configuration file /usr/local/etc/raddb/modules/always<br>including configuration file /usr/local/etc/raddb/modules/mschap<br>
including configuration file /usr/local/etc/raddb/modules/etc_group<br>including configuration file /usr/local/etc/raddb/modules/detail.log<br>including configuration file /usr/local/etc/raddb/modules/checkval<br>including configuration file /usr/local/etc/raddb/modules/<a href="http://detail.example.com/" target="_blank">detail.example.com</a><br>
including configuration file /usr/local/etc/raddb/modules/expiration<br>including configuration file<br>/usr/local/etc/raddb/modules/sqlcounter_expire_on_login<br>including configuration file /usr/local/etc/raddb/modules/policy<br>
including configuration file /usr/local/etc/raddb/modules/inner-eap<br>including configuration file /usr/local/etc/raddb/modules/ippool<br>including configuration file /usr/local/etc/raddb/modules/passwd<br>including configuration file /usr/local/etc/raddb/modules/detail<br>
including configuration file /usr/local/etc/raddb/modules/smbpasswd<br>including configuration file /usr/local/etc/raddb/modules/ldap<br>including configuration file /usr/local/etc/raddb/modules/unix<br>including configuration file /usr/local/etc/raddb/modules/chap<br>
including configuration file /usr/local/etc/raddb/modules/preprocess<br>including configuration file /usr/local/etc/raddb/modules/files<br>including configuration file /usr/local/etc/raddb/modules/digest<br>including configuration file /usr/local/etc/raddb/modules/acct_unique<br>
including configuration file /usr/local/etc/raddb/modules/attr_filter<br>including configuration file /usr/local/etc/raddb/modules/otp<br>including configuration file /usr/local/etc/raddb/modules/exec<br>including configuration file /usr/local/etc/raddb/modules/sql_log<br>
including configuration file /usr/local/etc/raddb/modules/echo<br>including configuration file /usr/local/etc/raddb/modules/cui<br>including configuration file /usr/local/etc/raddb/modules/counter<br>including configuration file /usr/local/etc/raddb/modules/smsotp<br>
including configuration file /usr/local/etc/raddb/modules/expr<br>including configuration file /usr/local/etc/raddb/modules/wimax<br>including configuration file /usr/local/etc/raddb/modules/perl<br>including configuration file /usr/local/etc/raddb/modules/pam<br>
including configuration file /usr/local/etc/raddb/modules/radutmp<br>including configuration file /usr/local/etc/raddb/modules/opendirectory<br>including configuration file /usr/local/etc/raddb/modules/krb5<br>including configuration file /usr/local/etc/raddb/modules/mac2ip<br>
including configuration file /usr/local/etc/raddb/modules/pap<br>including configuration file /usr/local/etc/raddb/eap.conf<br>including configuration file /usr/local/etc/raddb/sql.conf<br>including configuration file /usr/local/etc/raddb/sql/mysql/dialup.conf<br>
including configuration file /usr/local/etc/raddb/policy.conf<br>including files in directory /usr/local/etc/raddb/sites-enabled/<br>including configuration file /usr/local/etc/raddb/sites-enabled/default<br>including configuration file /usr/local/etc/raddb/sites-enabled/inner-tunnel<br>
including configuration file<br>/usr/local/etc/raddb/sites-enabled/control-socket<br>main {<br> allow_core_dumps = no<br>}<br>including dictionary file /usr/local/etc/raddb/dictionary<br>main {<br> prefix = "/usr/local"<br>
localstatedir = "/usr/local/var"<br> logdir = "/usr/local/var/log/radius"<br> libdir = "/usr/local/lib"<br> radacctdir = "/usr/local/var/log/radius/radacct"<br> hostname_lookups = no<br>
max_request_time = 30<br> cleanup_delay = 5<br> max_requests = 1024<br> pidfile = "/usr/local/var/run/radiusd/radiusd.pid"<br> checkrad = "/usr/local/sbin/checkrad"<br> debug_level = 0<br>
proxy_requests = yes<br> log {<br> stripped_names = no<br> auth = no<br> auth_badpass = no<br> auth_goodpass = no<br> }<br> security {<br> max_attributes = 200<br> reject_delay = 1<br> status_server = yes<br>
}<br>}<br>radiusd: #### Loading Realms and Home Servers ####<br> proxy server {<br> retry_delay = 5<br> retry_count = 3<br> default_fallback = no<br> dead_time = 120<br> wake_all_if_all_dead = no<br> }<br> home_server localhost {<br>
ipaddr = 127.0.0.1<br> port = 1812<br> type = "auth"<br> secret = "testing123"<br> response_window = 20<br> max_outstanding = 65536<br> require_message_authenticator = yes<br> zombie_period = 40<br>
status_check = "status-server"<br> ping_interval = 30<br> check_interval = 30<br> num_answers_to_alive = 3<br> num_pings_to_alive = 3<br> revive_interval = 120<br> status_check_timeout = 4<br> irt = 2<br>
mrt = 16<br> mrc = 5<br> mrd = 30<br> }<br> home_server_pool my_auth_failover {<br> type = fail-over<br> home_server = localhost<br> }<br> realm <a href="http://example.com/" target="_blank">example.com</a> {<br>
auth_pool = my_auth_failover<br> }<br> realm LOCAL {<br> }<br>radiusd: #### Loading Clients ####<br> client localhost {<br> ipaddr = 127.0.0.1<br> require_message_authenticator = no<br> secret = "testing123"<br>
nastype = "other"<br> }<br>radiusd: #### Instantiating modules ####<br> instantiate {<br> Module: Linked to module rlm_exec<br> Module: Instantiating module "exec" from file<br>/usr/local/etc/raddb/modules/exec<br>
exec {<br> wait = no<br> input_pairs = "request"<br> shell_escape = yes<br> }<br> Module: Linked to module rlm_expr<br> Module: Instantiating module "expr" from file<br>/usr/local/etc/raddb/modules/expr<br>
Module: Linked to module rlm_expiration<br> Module: Instantiating module "expiration" from file<br>/usr/local/etc/raddb/modules/expiration<br> expiration {<br> reply-message = "Password Has Expired "<br>
}<br> Module: Linked to module rlm_logintime<br> Module: Instantiating module "logintime" from file<br>/usr/local/etc/raddb/modules/logintime<br> logintime {<br> reply-message = "You are calling outside your allowed timespan "<br>
minimum-timeout = 60<br> }<br> }<br>radiusd: #### Loading Virtual Servers ####<br>server inner-tunnel { # from file<br>/usr/local/etc/raddb/sites-enabled/inner-tunnel<br> modules {<br> Module: Checking authenticate {...} for more modules to load<br>
Module: Linked to module rlm_pap<br> Module: Instantiating module "pap" from file<br>/usr/local/etc/raddb/modules/pap<br> pap {<br> encryption_scheme = "auto"<br> auto_header = no<br> }<br> Module: Linked to module rlm_chap<br>
Module: Instantiating module "chap" from file<br>/usr/local/etc/raddb/modules/chap<br> Module: Linked to module rlm_mschap<br> Module: Instantiating module "mschap" from file<br>/usr/local/etc/raddb/modules/mschap<br>
mschap {<br> use_mppe = yes<br> require_encryption = yes<br> require_strong = yes<br> with_ntdomain_hack = no<br> }<br> Module: Linked to module rlm_unix<br> Module: Instantiating module "unix" from file<br>
/usr/local/etc/raddb/modules/unix<br> unix {<br> radwtmp = "/usr/local/var/log/radius/radwtmp"<br> }<br> Module: Linked to module rlm_eap<br> Module: Instantiating module "eap" from file /usr/local/etc/raddb/eap.conf<br>
eap {<br> default_eap_type = "ttls"<br> timer_expire = 60<br> ignore_unknown_eap_types = no<br> cisco_accounting_username_bug = no<br> max_sessions = 4096<br> }<br> Module: Linked to sub-module rlm_eap_md5<br>
Module: Instantiating eap-md5<br> Module: Linked to sub-module rlm_eap_leap<br> Module: Instantiating eap-leap<br> Module: Linked to sub-module rlm_eap_gtc<br> Module: Instantiating eap-gtc<br> gtc {<br> challenge = "Password: "<br>
auth_type = "PAP"<br> }<br> Module: Linked to sub-module rlm_eap_tls<br> Module: Instantiating eap-tls<br> tls {<br> rsa_key_exchange = no<br> dh_key_exchange = yes<br> rsa_key_length = 512<br> dh_key_length = 512<br>
verify_depth = 0<br> CA_path = "/usr/local/etc/raddb/mycerts"<br> pem_file_type = yes<br> private_key_file = "/usr/local/etc/raddb/mycerts/server_keycert.pem"<br> certificate_file = "/usr/local/etc/raddb/mycerts/server_keycert.pem"<br>
private_key_password = "usetheserver"<br> dh_file = "/usr/local/etc/raddb/mycerts/dh"<br> random_file = "/usr/local/etc/raddb/mycerts/random"<br> fragment_size = 1024<br> include_length = yes<br>
check_crl = no<br> cipher_list = "DEFAULT"<br> make_cert_command = "/usr/local/etc/raddb/mycerts/bootstrap"<br> cache {<br> enable = no<br> lifetime = 24<br> max_entries = 255<br> }<br>
verify {<br> }<br> }<br> Module: Linked to sub-module rlm_eap_ttls<br> Module: Instantiating eap-ttls<br> ttls {<br> default_eap_type = "mschapv2"<br> copy_request_to_tunnel = no<br> use_tunneled_reply = yes<br>
include_length = yes<br> }<br> Module: Linked to sub-module rlm_eap_mschapv2<br> Module: Instantiating eap-mschapv2<br> mschapv2 {<br> with_ntdomain_hack = no<br> }<br> Module: Checking authorize {...} for more modules to load<br>
Module: Linked to module rlm_realm<br> Module: Instantiating module "suffix" from file<br>/usr/local/etc/raddb/modules/realm<br> realm suffix {<br> format = "suffix"<br> delimiter = "@"<br>
ignore_default = no<br> ignore_null = no<br> }<br> Module: Linked to module rlm_files<br> Module: Instantiating module "files" from file<br>/usr/local/etc/raddb/modules/files<br> files {<br> usersfile = "/usr/local/etc/raddb/users"<br>
acctusersfile = "/usr/local/etc/raddb/acct_users"<br> preproxy_usersfile = "/usr/local/etc/raddb/preproxy_users"<br> compat = "no"<br> }<br> Module: Checking session {...} for more modules to load<br>
Module: Linked to module rlm_radutmp<br> Module: Instantiating module "radutmp" from file<br>/usr/local/etc/raddb/modules/radutmp<br> radutmp {<br> filename = "/usr/local/var/log/radius/radutmp"<br>
username = "%{User-Name}"<br> case_sensitive = yes<br> check_with_nas = yes<br> perm = 384<br> callerid = yes<br> }<br> Module: Checking post-proxy {...} for more modules to load<br> Module: Checking post-auth {...} for more modules to load<br>
Module: Linked to module rlm_attr_filter<br> Module: Instantiating module "attr_filter.access_reject" from file<br>/usr/local/etc/raddb/modules/attr_filter<br> attr_filter attr_filter.access_reject {<br> attrsfile = "/usr/local/etc/raddb/attrs.access_reject"<br>
key = "%{User-Name}"<br> }<br> } # modules<br>} # server<br>server { # from file /usr/local/etc/raddb/radiusd.conf<br> modules {<br> Module: Checking authenticate {...} for more modules to load<br> Module: Linked to module rlm_digest<br>
Module: Instantiating module "digest" from file<br>/usr/local/etc/raddb/modules/digest<br> Module: Checking authorize {...} for more modules to load<br> Module: Linked to module rlm_preprocess<br> Module: Instantiating module "preprocess" from file<br>
/usr/local/etc/raddb/modules/preprocess<br> preprocess {<br> huntgroups = "/usr/local/etc/raddb/huntgroups"<br> hints = "/usr/local/etc/raddb/hints"<br> with_ascend_hack = no<br> ascend_channels_per_line = 23<br>
with_ntdomain_hack = no<br> with_specialix_jetstream_hack = no<br> with_cisco_vsa_hack = no<br> with_alvarion_vsa_hack = no<br> }<br> Module: Linked to module rlm_sql<br> Module: Instantiating module "sql" from file /usr/local/etc/raddb/sql.conf<br>
sql {<br> driver = "rlm_sql_mysql"<br> server = "127.0.0.1"<br> port = ""<br> login = "radius"<br> password = "*************"<br> radius_db = "radius"<br>
read_groups = yes<br> sqltrace = no<br> sqltracefile = "/usr/local/var/log/radius/sqltrace.sql"<br> readclients = yes<br> deletestalesessions = yes<br> num_sql_socks = 5<br> lifetime = 0<br> max_queries = 0<br>
sql_user_name = "%{User-Name}"<br> default_user_profile = ""<br> nas_query = "SELECT id, nasname, shortname, type, secret, server FROM<br>nas"<br> authorize_check_query = "SELECT id, username, attribute, value,<br>
op FROM radcheck WHERE username =<br>'%{SQL-User-Name}' ORDER BY id"<br> authorize_reply_query = "SELECT id, username, attribute, value,<br>op FROM radreply WHERE username =<br>
'%{SQL-User-Name}' ORDER BY id"<br> authorize_group_check_query = "SELECT id, groupname,<br>attribute, Value, op FROM radgroupcheck WHERE<br>groupname = '%{Sql-Group}' ORDER BY id"<br>
authorize_group_reply_query = "SELECT id, groupname,<br>attribute, value, op FROM radgroupreply WHERE<br>groupname = '%{Sql-Group}' ORDER BY id"<br> accounting_onoff_query = " UPDATE radacct<br>
SET acctstoptime = '%S', acctsessiontime<br>= unix_timestamp('%S') -<br>unix_timestamp(acctstarttime), acctterminatecause =<br>'%{Acct-Terminate-Cause}', acctstopdelay =<br>
%{%{Acct-Delay-Time}:-0} WHERE acctstoptime IS NULL AND<br>nasipaddress = '%{NAS-IP-Address}' AND acctstarttime <=<br>'%S'"<br> accounting_update_query = " UPDATE radacct<br>
SET framedipaddress = '%{Framed-IP-Address}',<br>acctsessiontime = '%{Acct-Session-Time}',<br>acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32<br>|<br>'%{%{Acct-Input-Octets}:-0}', acctoutputoctets =<br>
'%{%{Acct-Output-Gigawords}:-0}' << 32 |<br>'%{%{Acct-Output-Octets}:-0}' WHERE acctsessionid =<br>'%{Acct-Session-Id}' AND username =<br>'%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}'"<br>
accounting_update_query_alt = " INSERT INTO<br>radacct (acctsessionid, acctuniqueid,<br>username, realm, nasipaddress,<br>nasportid, nasporttype, acctstarttime,<br>
acctsessiontime, acctauthentic, connectinfo_start,<br>acctinputoctets, acctoutputoctets, calledstationid,<br>callingstationid, servicetype, framedprotocol,<br>framedipaddress, acctstartdelay,<br>
xascendsessionsvrkey) VALUES ('%{Acct-Session-Id}',<br>'%{Acct-Unique-Session-Id}', '%{SQL-User-Name}',<br>'%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}',<br>
'%{NAS-Port-Type}', DATE_SUB('%S',<br>INTERVAL (%{%{Acct-Session-Time}:-0} +<br>%{%{Acct-Delay-Time}:-0}) SECOND),<br>'%{Acct-Session-Time}', '%{Acct-Authentic}', '',<br>
'%{%{Acct-Input-Gigawords}:-0}' << 32 |<br>'%{%{Acct-Input-Octets}:-0}', '%{%{Acct-Output-Gigawords}:-0}'<br><< 32 | '%{%{Acct-Output-Octets}:-0}',<br>
'%{Called-Station-Id}', '%{Calling-Station-Id}',<br>'%{Service-Type}', '%{Framed-Protocol}',<br>'%{Framed-IP-Address}', '0', '%{X-Ascend-Session-Svr-Key}')"<br>
accounting_start_query = " INSERT INTO radacct<br>(acctsessionid, acctuniqueid, username,<br>realm, nasipaddress, nasportid,<br>nasporttype, acctstarttime, acctstoptime,<br>
acctsessiontime, acctauthentic, connectinfo_start,<br>connectinfo_stop, acctinputoctets, acctoutputoctets,<br>calledstationid, callingstationid, acctterminatecause,<br>servicetype, framedprotocol, framedipaddress,<br>
acctstartdelay, acctstopdelay, xascendsessionsvrkey)<br>VALUES ('%{Acct-Session-Id}',<br>'%{Acct-Unique-Session-Id}', '%{SQL-User-Name}',<br>'%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}',<br>
'%{NAS-Port-Type}', '%S', NULL, '0', '%{Acct-Authentic}',<br>'%{Connect-Info}', '', '0', '0',<br>'%{Called-Station-Id}', '%{Calling-Station-Id}', '',<br>
'%{Service-Type}', '%{Framed-Protocol}',<br>'%{Framed-IP-Address}', '%{%{Acct-Delay-Time}:-0}', '0',<br>'%{X-Ascend-Session-Svr-Key}')"<br> accounting_start_query_alt = " UPDATE radacct SET<br>
acctstarttime = '%S', acctstartdelay =<br>'%{%{Acct-Delay-Time}:-0}', connectinfo_start =<br>'%{Connect-Info}' WHERE acctsessionid =<br>'%{Acct-Session-Id}' AND username =<br>
'%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}'"<br> accounting_stop_query = " UPDATE radacct SET<br>acctstoptime = '%S', acctsessiontime =<br>
'%{Acct-Session-Time}', acctinputoctets =<br>'%{%{Acct-Input-Gigawords}:-0}' << 32 |<br>'%{%{Acct-Input-Octets}:-0}', acctoutputoctets =<br>'%{%{Acct-Output-Gigawords}:-0}' << 32 |<br>
'%{%{Acct-Output-Octets}:-0}', acctterminatecause =<br>'%{Acct-Terminate-Cause}', acctstopdelay =<br>'%{%{Acct-Delay-Time}:-0}', connectinfo_stop =<br>
'%{Connect-Info}' WHERE acctsessionid =<br>'%{Acct-Session-Id}' AND username =<br>'%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}'"<br>
accounting_stop_query_alt = " INSERT INTO radacct<br>(acctsessionid, acctuniqueid, username, realm, nasipaddress,<br>nasportid, nasporttype, acctstarttime,<br>acctstoptime, acctsessiontime, acctauthentic,<br>
connectinfo_start, connectinfo_stop, acctinputoctets,<br>acctoutputoctets, calledstationid, callingstationid,<br>acctterminatecause, servicetype, framedprotocol,<br>framedipaddress, acctstartdelay, acctstopdelay)<br>
VALUES ('%{Acct-Session-Id}',<br>'%{Acct-Unique-Session-Id}', '%{SQL-User-Name}',<br>'%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}',<br>'%{NAS-Port-Type}', DATE_SUB('%S', INTERVAL<br>
(%{%{Acct-Session-Time}:-0} + %{%{Acct-Delay-Time}:-0})<br>SECOND), '%S', '%{Acct-Session-Time}', '%{Acct-Authentic}',<br>'', '%{Connect-Info}',<br>
'%{%{Acct-Input-Gigawords}:-0}' << 32 |<br>'%{%{Acct-Input-Octets}:-0}', '%{%{Acct-Output-Gigawords}:-0}'<br><< 32 | '%{%{Acct-Output-Octets}:-0}',<br>
'%{Called-Station-Id}', '%{Calling-Station-Id}',<br>'%{Acct-Terminate-Cause}', '%{Service-Type}',<br>'%{Framed-Protocol}', '%{Framed-IP-Address}', '0',<br>
'%{%{Acct-Delay-Time}:-0}')"<br> group_membership_query = "SELECT groupname FROM<br>radusergroup WHERE username = '%{SQL-User-Name}' ORDER<br>BY priority"<br>
connect_failure_retry_delay = 60<br> simul_count_query = ""<br> simul_verify_query = "SELECT radacctid, acctsessionid,<br>username, nasipaddress, nasportid,<br>framedipaddress, callingstationid,<br>
framedprotocol FROM<br>radacct WHERE username =<br>'%{SQL-User-Name}' AND acctstoptime IS NULL"<br> postauth_query = "INSERT INTO radpostauth<br>
(username, pass, reply, authdate) VALUES<br>( '%{User-Name}',<br>'%{%{User-Password}:-%{Chap-Password}}',<br>'%{reply:Packet-Type}', '%S')"<br>
safe-characters =<br>"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"<br> }<br>rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked<br>rlm_sql (sql): Attempting to connect to radius@127.0.0.1:/radius<br>
rlm_sql (sql): starting 0<br>rlm_sql (sql): Attempting to connect rlm_sql_mysql #0<br>rlm_sql_mysql: Starting connect to MySQL server for #0<br>rlm_sql (sql): Connected new DB handle, #0<br>rlm_sql (sql): starting 1<br>rlm_sql (sql): Attempting to connect rlm_sql_mysql #1<br>
rlm_sql_mysql: Starting connect to MySQL server for #1<br>rlm_sql (sql): Connected new DB handle, #1<br>rlm_sql (sql): starting 2<br>rlm_sql (sql): Attempting to connect rlm_sql_mysql #2<br>rlm_sql_mysql: Starting connect to MySQL server for #2<br>
rlm_sql (sql): Connected new DB handle, #2<br>rlm_sql (sql): starting 3<br>rlm_sql (sql): Attempting to connect rlm_sql_mysql #3<br>rlm_sql_mysql: Starting connect to MySQL server for #3<br>rlm_sql (sql): Connected new DB handle, #3<br>
rlm_sql (sql): starting 4<br>rlm_sql (sql): Attempting to connect rlm_sql_mysql #4<br>rlm_sql_mysql: Starting connect to MySQL server for #4<br>rlm_sql (sql): Connected new DB handle, #4<br>rlm_sql (sql): Processing generate_sql_clients<br>
rlm_sql (sql) in generate_sql_clients: query is SELECT id, nasname,<br>shortname, type, secret, server FROM nas<br>rlm_sql (sql): Reserving sql socket id: 4<br>rlm_sql (sql): Read entry nasname=10.10.10.145,shortname=ubnt,secret=testing<br>
rlm_sql (sql): Adding client 10.10.10.145 (ubnt, server=<none>) to clients<br>list<br>rlm_sql (sql): Read entry nasname=10.10.10.89,shortname=AP,secret=testing<br>rlm_sql (sql): Adding client 10.10.10.89 (AP, server=<none>) to clients list<br>
rlm_sql (sql): Released sql socket id: 4<br> Module: Checking preacct {...} for more modules to load<br> Module: Linked to module rlm_acct_unique<br> Module: Instantiating module "acct_unique" from file<br>/usr/local/etc/raddb/modules/acct_unique<br>
acct_unique {<br> key = "User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address,<br>NAS-Port"<br> }<br> Module: Checking accounting {...} for more modules to load<br> Module: Linked to module rlm_detail<br>
Module: Instantiating module "detail" from file<br>/usr/local/etc/raddb/modules/detail<br> detail {<br> detailfile =<br>"/usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d"<br> header = "%t"<br>
detailperm = 384<br> dirperm = 493<br> locking = no<br> log_packet_header = no<br> }<br> Module: Instantiating module "attr_filter.accounting_response" from file<br>/usr/local/etc/raddb/modules/attr_filter<br>
attr_filter attr_filter.accounting_response {<br> attrsfile = "/usr/local/etc/raddb/attrs.accounting_response"<br> key = "%{User-Name}"<br> }<br> Module: Checking session {...} for more modules to load<br>
Module: Checking post-proxy {...} for more modules to load<br> Module: Checking post-auth {...} for more modules to load<br> } # modules<br>} # server<br>radiusd: #### Opening IP addresses and Ports ####<br>listen {<br> type = "auth"<br>
ipaddr = *<br> port = 0<br>}<br>listen {<br> type = "acct"<br> ipaddr = *<br> port = 0<br>}<br>listen {<br> type = "control"<br> listen {<br> socket = "/usr/local/var/run/radiusd/radiusd.sock"<br>
}<br>}<br>listen {<br> type = "auth"<br> ipaddr = 127.0.0.1<br> port = 18120<br>}<br>Listening on authentication address * port 1812<br>Listening on accounting address * port 1813<br>Listening on command file /usr/local/var/run/radiusd/radiusd.sock<br>
Listening on authentication address 127.0.0.1 port 18120 as server<br>inner-tunnel<br>Listening on proxy address * port 1814<br>Ready to process requests.<br>rad_recv: Access-Request packet from host 10.10.10.89 port 1060, id=0,<br>
length=167<br> Message-Authenticator = 0x811ce545876890cc89ddd343bcc3cca9<br> Service-Type = Framed-User<br> User-Name = "test"<br> Framed-MTU = 1488<br> Called-Station-Id = "D8-5D-4C-C2-A6-08:TEST"<br>
Calling-Station-Id = "10-93-E9-1D-10-1B"<br> NAS-Port-Type = Wireless-802.11<br> Connect-Info = "CONNECT 54Mbps 802.11g"<br> EAP-Message = 0x020000090174657374<br> NAS-IP-Address = 192.168.1.5<br>
NAS-Port = 1<br> NAS-Port-Id = "STA port # 1"<br># Executing section authorize from file<br>/usr/local/etc/raddb/sites-enabled/default<br>+- entering group authorize {...}<br>++[preprocess] returns ok<br>++[chap] returns noop<br>
++[mschap] returns noop<br>++[digest] returns noop<br>[suffix] No '@' in User-Name = "test", looking up realm NULL<br>[suffix] No such realm "NULL"<br>++[suffix] returns noop<br>[eap] EAP packet type response id 0 length 9<br>
[eap] No EAP Start, assuming it's an on-going EAP conversation<br>++[eap] returns updated<br>++[files] returns noop<br>[sql] expand: %{User-Name} -> test<br>[sql] sql_set_user escaped user --> 'test'<br>
rlm_sql (sql): Reserving sql socket id: 3<br>[sql] expand: SELECT id, username, attribute, value, op FROM<br>radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id<br>-> SELECT id, username, attribute, value, op FROM<br>
radcheck WHERE username = 'test' ORDER BY id<br>[sql] User found in radcheck table<br>[sql] expand: SELECT id, username, attribute, value, op FROM<br>radreply WHERE username = '%{SQL-User-Name}' ORDER BY id<br>
-> SELECT id, username, attribute, value, op FROM<br>radreply WHERE username = 'test' ORDER BY id<br>[sql] expand: SELECT groupname FROM radusergroup<br>WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT<br>
groupname FROM radusergroup WHERE username =<br>'test' ORDER BY priority<br>rlm_sql (sql): Released sql socket id: 3<br>++[sql] returns ok<br>++[expiration] returns noop<br>++[logintime] returns noop<br>
[pap] WARNING: Auth-Type already set. Not setting to PAP<br>++[pap] returns noop<br>Found Auth-Type = EAP<br># Executing group from file /usr/local/etc/raddb/sites-enabled/default<br>+- entering group authenticate {...}<br>
[eap] EAP Identity<br>[eap] processing type tls<br>[tls] Initiate<br>[tls] Start returned 1<br>++[eap] returns handled<br>Sending Access-Challenge of id 0 to 10.10.10.89 port 1060<br> EAP-Message = 0x010100061520<br> Message-Authenticator = 0x00000000000000000000000000000000<br>
State = 0x829fae86829ebb1a8141bab516e87a11<br>Finished request 0.<br>Going to the next request<br>Waking up in 4.9 seconds.<br>rad_recv: Access-Request packet from host 10.10.10.89 port 1060, id=0,<br>length=167<br>Sending duplicate reply to client AP port 1060 - ID: 0<br>
Sending Access-Challenge of id 0 to 10.10.10.89 port 1060<br>Waking up in 1.8 seconds.<br>Cleaning up request 0 ID 0 with timestamp +11<br>WARNING:<br>!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!<br>
WARNING: !! EAP session for state 0x829fae86829ebb1a did not finish!<br>WARNING: !! Please read <a href="http://wiki.freeradius.org/Certificate_Compatibility" target="_blank">http://wiki.freeradius.org/Certificate_Compatibility</a><br>
WARNING:<br>!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!<br>Ready to process requests.<br><br>thank you very much<br>P.S: please forgive my ignorance of the proper way of mailing or explaining<br>
my problem.<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <<a href="https://lists.freeradius.org/pipermail/freeradius-users/attachments/20110329/d5c38776/attachment.html" target="_blank">https://lists.freeradius.org/pipermail/freeradius-users/attachments/20110329/d5c38776/attachment.html</a>><br>
<br>------------------------------<br><br>-<br>List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html" target="_blank">http://www.freeradius.org/list/users.html</a><br><br><br>End of Freeradius-Users Digest, Vol 71, Issue 130<br>
*************************************************<br></blockquote></div><br>