Problems with dynamic-clients

Barbara Picci barbara.picci at sardi.it
Wed Sep 9 18:54:54 CEST 2009


Hi all,

I've some difficulties to set dynamic clients with FreeRADIUS Version 
2.1.3 in a debian etch.

I've successfully tested freeradius and mysql and chillispot with nas 
static IP withous problems, but I need to have dynamic clients.

My authentication methos is PAP md5.
In modules/pap
I've:

pap {
authtype = md5
auto_header = yes
}


So I've set the dynamic clients with:


/usr/local/etc/raddb/sites-enabled/dynamic-clients

client dynamic {
         ipaddr = 0.0.0.0
	netmask = 0
	dynamic_clients = dynamic_client_server
	lifetime = 86400
}

server dynamic_client_server {
	authorize {
		update control {
		FreeRADIUS-Client-IP-Address = "%{Packet-Src-IP-Address}"
		FreeRADIUS-Client-Require-MA = no
		FreeRADIUS-Client-Secret = "testing123"
		FreeRADIUS-Client-Shortname = "%{Packet-Src-IP-Address}"
		FreeRADIUS-Client-NAS-Type = "other"
		#FreeRADIUS-Client-Virtual-Server = "something"
		if ("%{sql: SELECT nasname FROM nas WHERE nasname = 
'%{Packet-Src-IP-Address}'}") {
                         update control {
#
                                 #  Echo the IP.
                                 FreeRADIUS-Client-IP-Address = 
"%{Packet-Src-IP-Address}"
                                 #
                                 #  Do multiple SELECT statements to grab
                                 #  the various definitions.
                                 FreeRADIUS-Client-Shortname = "%{sql: 
SELECT shortname FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}"

                                 FreeRADIUS-Client-Secret = "%{sql: 
SELECT secret FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}"

                                 FreeRADIUS-Client-NAS-Type = "%{sql: 
SELECT type FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}"
                         }

                 }
                 ok
		}

	}


I've also tried to add in the authorize section the modules as the 
default file:

server dynamic_client_server {
	authorize {
		preprocess
                 chap
                 mschap
                 suffix
                 unix
                 files
                 sql
                 expiration
                 logintime
                 noresetcounter
                 pap
			update control {
				etc.etc.


and I've tried to add in the update control section:
Auth-Type := pap

The output of radiusd -X is:

FreeRADIUS Version 2.1.3, for host i686-pc-linux-gnu, built on Jan 13 
2009 at 18:44:57
Copyright (C) 1999-2008 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/detail
including configuration file /usr/local/etc/raddb/modules/krb5
including configuration file /usr/local/etc/raddb/modules/pam
including configuration file /usr/local/etc/raddb/modules/etc_group
including configuration file /usr/local/etc/raddb/modules/mac2vlan
including configuration file /usr/local/etc/raddb/modules/radutmp
including configuration file /usr/local/etc/raddb/modules/detail.example.com
including configuration file /usr/local/etc/raddb/modules/sql_log
including configuration file /usr/local/etc/raddb/modules/ippool
including configuration file /usr/local/etc/raddb/modules/wimax
including configuration file /usr/local/etc/raddb/modules/echo
including configuration file /usr/local/etc/raddb/modules/digest
including configuration file /usr/local/etc/raddb/modules/attr_rewrite
including configuration file /usr/local/etc/raddb/modules/realm
including configuration file /usr/local/etc/raddb/modules/logintime
including configuration file /usr/local/etc/raddb/modules/sradutmp
including configuration file /usr/local/etc/raddb/modules/pap
including configuration file /usr/local/etc/raddb/modules/expr
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/linelog
including configuration file /usr/local/etc/raddb/modules/chap
including configuration file /usr/local/etc/raddb/modules/expiration
including configuration file /usr/local/etc/raddb/modules/checkval
including configuration file /usr/local/etc/raddb/modules/detail.log
including configuration file /usr/local/etc/raddb/modules/always
including configuration file /usr/local/etc/raddb/modules/mac2ip
including configuration file /usr/local/etc/raddb/modules/counter
including configuration file /usr/local/etc/raddb/modules/mschap
including configuration file /usr/local/etc/raddb/modules/unix
including configuration file /usr/local/etc/raddb/modules/inner-eap
including configuration file /usr/local/etc/raddb/modules/smbpasswd
including configuration file /usr/local/etc/raddb/modules/policy
including configuration file /usr/local/etc/raddb/modules/acct_unique
including configuration file /usr/local/etc/raddb/modules/files
including configuration file /usr/local/etc/raddb/modules/passwd
including configuration file /usr/local/etc/raddb/modules/preprocess
including configuration file /usr/local/etc/raddb/modules/ldap
including configuration file /usr/local/etc/raddb/modules/perl
including configuration file /usr/local/etc/raddb/modules/attr_filter
including configuration file /usr/local/etc/raddb/eap.conf
including configuration file /usr/local/etc/raddb/sql.conf
including configuration file /usr/local/etc/raddb/sql/mysql/dialup.conf
including configuration file /usr/local/etc/raddb/sql/mysql/counter.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/dynamic-clients
including configuration file /usr/local/etc/raddb/sites-enabled/default
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
         allow_core_dumps = no
         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
  }
}
  client dynamic {
         ipaddr = 0.0.0.0
         netmask = 0
         require_message_authenticator = no
         dynamic_clients = "dynamic_client_server"
         lifetime = 86400
  }
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
         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
  }
  home_server_pool my_auth_failover {
         type = fail-over
         home_server = localhost
  }
  realm example.com {
         auth_pool = my_auth_failover
  }
  realm LOCAL {
  }
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 dynamic_client_server {
  modules {
  Module: Checking authorize {...} for more modules to load
  Module: Linked to module rlm_preprocess
  Module: Instantiating preprocess
   preprocess {
         huntgroups = "/usr/local/etc/raddb/huntgroups"
         hints = "/usr/local/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_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_realm
  Module: Instantiating suffix
   realm suffix {
         format = "suffix"
         delimiter = "@"
         ignore_default = no
         ignore_null = no
   }
  Module: Linked to module rlm_unix
  Module: Instantiating unix
   unix {
         radwtmp = "/usr/local/var/log/radius/radwtmp"
   }
  Module: Linked to module rlm_files
  Module: Instantiating 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"
   }
  Module: Linked to module rlm_sql
  Module: Instantiating sql
   sql {
         driver = "rlm_sql_mysql"
         server = "localhost"
         port = ""
         login = "radius_admin"
         password = "GgtT6722"
         radius_db = "radius_admin"
         read_groups = yes
         sqltrace = no
         sqltracefile = "/usr/local/var/log/radius/sqltrace.sql"
         readclients = yes
         deletestalesessions = yes
         num_sql_socks = 5
         sql_user_name = "%{User-Name}"
         default_user_profile = ""
         nas_query = "SELECT id, nasname, shortname, type, secret FROM nas"
         authorize_check_query = "SELECT radcheck.id, 
radcheck.username, radcheck.attribute,           radcheck.value, 
radcheck.op FROM radcheck INNER JOIN usergroup ON 
usergroup.UserName=radcheck.username INNER JOIN locations ON 
locations.ID=usergroup.location_id INNER JOIN AP ON 
AP.LocationID=locations.ID INNER JOIN nas ON nas.nasname=AP.ipaddress 
WHERE radcheck.username = '%{SQL-User-Name}' AND 
nas.nasname='%{Client-IP-Address}' ORDER BY radcheck.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,nas_ip_address)           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}','%{Client-IP-Address}')"
         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,nas_ip_address) 
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}','%{Client-IP-Address}')"
         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,nas_ip_address)           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}','%{Client-IP-Address}')"
         group_membership_query = "SELECT groupname           FROM 
usergroup           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, reply, authdate)                           VALUES ( 
'%{User-Name}',                           '%{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 radius_admin at localhost:/radius_admin
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
rlm_sql (sql): Processing generate_sql_clients
rlm_sql (sql) in generate_sql_clients: query is SELECT id, nasname, 
shortname, type, secret FROM nas
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql (sql): Read entry nasname=127.0.0.1,shortname=marconi,secret=testing123
rlm_sql (sql): Adding client 127.0.0.1 (marconi, server=<none>) to clients list
rlm_sql (sql): Read entry 
nasname=172.30.0.1,shortname=sonicwall,secret=testing123
rlm_sql (sql): Adding client 172.30.0.1 (sonicwall, server=<none>) to 
clients list
rlm_sql (sql): Read entry 
nasname=217.133.41.174,shortname=buffalo,secret=testing123
rlm_sql (sql): Adding client 217.133.41.174 (buffalo, server=<none>) 
to clients list
rlm_sql (sql): Read entry 
nasname=0.0.0.0,shortname=buffalo_avvca,secret=testing123
rlm_sql (sql): Adding client 0.0.0.0 (buffalo_avvca, server=<none>) 
to clients list
rlm_sql (sql): Released sql socket id: 4
  Module: Linked to module rlm_sqlcounter
  Module: Instantiating noresetcounter
   sqlcounter noresetcounter {
         counter-name = "Max-All-Session-Time"
         check-name = "Max-All-Session"
         key = "User-Name"
         sqlmod-inst = "sql"
         query = "SELECT SUM(AcctSessionTime) FROM radacct WHERE 
UserName='%{%k}'"
         reset = "never"
         safe-characters = 
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: 
/"
   }
rlm_sqlcounter: Reply attribute set to Session-Timeout.
rlm_sqlcounter: Counter attribute Max-All-Session-Time is number 11273
rlm_sqlcounter: Check attribute Max-All-Session is number 11274
rlm_sqlcounter: Current Time: 1252513572 [2009-09-09 18:26:12], Next 
reset 0 [2009-09-09 18:00:00]
rlm_sqlcounter: Current Time: 1252513572 [2009-09-09 18:26:12], Prev 
reset 0 [2009-09-09 18:00:00]
  Module: Linked to module rlm_pap
  Module: Instantiating pap
   pap {
         encryption_scheme = "auto"
         auto_header = yes
   }
  Module: Linked to module rlm_always
  Module: Instantiating ok
   always ok {
         rcode = "ok"
         simulcount = 0
         mpp = no
   }
  }
}
  modules {
  Module: Checking authenticate {...} for more modules to load
  Module: Linked to module rlm_eap
  Module: Instantiating eap
   eap {
         default_eap_type = "ttls"
         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 = "/usr/local/etc/raddb/certs/server_key.pem"
         certificate_file = "/usr/local/etc/raddb/certs/server_cert.pem"
         CA_file = "/usr/local/etc/raddb/certs/radiusCA/cacert.pem"
         private_key_password = "pippo1976!"
         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
    }
WARNING: rlm_eap_tls: Unable to set DH parameters.  DH cipher suites 
may not work!
WARNING: Fix this by running the OpenSSL command listed in eap.conf
  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
    }
  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: 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 = 
"/usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d"
         header = "%t"
         detailperm = 384
         dirperm = 493
         locking = no
         log_packet_header = no
   }
  Module: Linked to module rlm_radutmp
  Module: Instantiating radutmp
   radutmp {
         filename = "/usr/local/var/log/radius/radutmp"
         username = "%{User-Name}"
         case_sensitive = yes
         check_with_nas = yes
         perm = 384
         callerid = yes
   }
  Module: Linked to module rlm_attr_filter
  Module: Instantiating attr_filter.accounting_response
   attr_filter attr_filter.accounting_response {
         attrsfile = "/usr/local/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
  Module: Instantiating attr_filter.access_reject
   attr_filter attr_filter.access_reject {
         attrsfile = "/usr/local/etc/raddb/attrs.access_reject"
         key = "%{User-Name}"
   }
  }
radiusd: #### Opening IP addresses and Ports ####
listen {
         type = "auth"
         ipaddr = *
         port = 0
}
listen {
         type = "acct"
         ipaddr = *
         port = 0
}
Listening on authentication address * port 1812
Listening on accounting address * port 1813
Listening on proxy address * port 1814
Ready to process requests.
server dynamic_client_server {
rlm_sql (sql): Reserving sql socket id: 3
rlm_sql (sql): Released sql socket id: 3
rlm_sqlcounter: Entering module authorize code
rlm_sqlcounter: Could not find Key value pair
rlm_sql (sql): Reserving sql socket id: 2
rlm_sql (sql): Released sql socket id: 2
} # server dynamic_client_server
- Added client 259.153.41.173 with shared secret testing123
rad_recv: Access-Request packet from host 259.153.41.173 port 2051, 
id=0, length=212
         User-Name = "barbara.picci"
         User-Password = "pippo"
         NAS-IP-Address = 0.0.0.0
         Service-Type = Login-User
         Framed-IP-Address = 192.168.182.2
         Calling-Station-Id = "00-13-CE-6C-30-F5"
         Called-Station-Id = "00-1D-73-DE-02-EE"
         NAS-Identifier = "buffalo_avvca"
         Acct-Session-Id = "4aa7e97d00000000"
         NAS-Port-Type = Wireless-802.11
         NAS-Port = 0
         Message-Authenticator = 0x91f7c0ccc206cbf282ec12af6f55db96
         WISPr-Logoff-URL = "http://192.168.182.1:3990/logoff"
+- entering group authorize {...}
++[preprocess] returns ok
++[chap] returns noop
++[mschap] returns noop
[suffix] No '@' in User-Name = "barbara.picci", 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} -> barbara.picci
[sql] sql_set_user escaped user --> 'barbara.picci'
rlm_sql (sql): Reserving sql socket id: 1
[sql]   expand: SELECT radcheck.id, radcheck.username, 
radcheck.attribute,           radcheck.value, radcheck.op FROM 
radcheck INNER JOIN usergroup ON usergroup.UserName=radcheck.username 
INNER JOIN locations ON locations.ID=usergroup.location_id INNER JOIN 
AP ON AP.LocationID=locations.ID INNER JOIN nas ON 
nas.nasname=AP.ipaddress WHERE radcheck.username = '%{SQL-User-Name}' 
AND nas.nasname='%{Client-IP-Address}' ORDER BY radcheck.id -> SELECT 
radcheck.id, radcheck.username, radcheck.attribute, 
radcheck.value, radcheck.op FROM radcheck INNER JOIN usergroup ON 
usergroup.UserName=radcheck.username INNER JOIN locations ON 
locations.ID=usergroup.location_id INNER JOIN AP ON 
AP.LocationID=locations.ID INNER JOIN nas ON nas.nasname=AP.ipaddress 
WHERE radcheck.username = 'barbara.picci' AND 
nas.nasname='259.153.41.173' ORDER BY radcheck.id
[sql]   expand: SELECT groupname           FROM usergroup 
WHERE username = '%{SQL-User-Name}'           ORDER BY priority -> 
SELECT groupname           FROM usergroup           WHERE username = 
'barbara.picci'           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 = 'Avvocati_CA' 
ORDER BY id
[sql] User found in group Avvocati_CA
[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 = 'Avvocati_CA' 
ORDER BY id
rlm_sql (sql): Released sql socket id: 1
++[sql] returns ok
++[expiration] returns noop
++[logintime] returns noop
rlm_sqlcounter: Entering module authorize code
rlm_sqlcounter: Could not find Check item value pair
++[noresetcounter] returns noop
[pap] WARNING! No "known good" password found for the user. 
Authentication may fail because of this.
++[pap] returns noop
No authenticate method (Auth-Type) configuration found for the 
request: Rejecting the user
Failed to authenticate the user.
Using Post-Auth-Type Reject
+- entering group REJECT {...}
[attr_filter.access_reject]     expand: %{User-Name} -> barbara.picci
  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 0 to 259.153.41.173 port 2051
Waking up in 4.9 seconds.
Cleaning up request 0 ID 0 with timestamp +137
Ready to process requests.





for this reason I've tried to add that
Auth-Type := pap
in the update control section as I've red googling with these errors.

But nothing changed.

So I've tried to insert in the radgroupcheck table the Auth-Type, 
using Accept without problems (but all users in the group are 
accepted without correct password), using PAP and my output is:




rlm_sql (sql): Released sql socket id: 0
++[sql] returns ok
++[expiration] returns noop
++[logintime] returns noop
rlm_sqlcounter: Entering module authorize code
rlm_sqlcounter: Could not find Check item value pair
++[noresetcounter] returns noop
[pap] WARNING! No "known good" password found for the user. 
Authentication may fail because of this.
++[pap] returns noop
Found Auth-Type = PAP
+- entering group PAP {...}
[pap] login attempt with password "pippo"
[pap] No password configured for the user.  Cannot do authentication
++[pap] returns fail
Failed to authenticate the user.
Using Post-Auth-Type Reject
+- entering group REJECT {...}
[attr_filter.access_reject]     expand: %{User-Name} -> barbara.picci
  attr_filter: Matched entry DEFAULT at line 11
++[attr_filter.access_reject] returns updated
Delaying reject of request 1 for 1 seconds
Going to the next request
Waking up in 0.9 seconds.
Sending delayed reject for request 1
Sending Access-Reject of id 0 to 259.153.41.173 port 2051
Waking up in 4.9 seconds.
Cleaning up request 1 ID 0 with timestamp +658
Ready to process requests.


I'm sure that the password is that and I successfully authenticate 
with NAS static.
Can anyone help me, please?
Thanks in advance

Barbara Picci



More information about the Freeradius-Users mailing list