Hi, I am using freeradius 2.1.6 in CentOS 5.3 with mysql backend. As a follow up question to my previous posting, I have modified the following in dynamic-clients file. ====================================================== client dynamic { ipaddr = 0.0.0.0 netmask = 0 dynamic_clients = dynamic_client_server lifetime = 86400 } server dynamic_client_server { authorize { preprocess chap mschap suffix unix sql expiration logintime pap noresetcounter dailycounter monthlycounter accessperiod 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 { FreeRADIUS-Client-IP-Address = "%{Packet-Src-IP-Address}" 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 am not sure if I have to put all the modules as in the default file. I skipped the ========== eap { ok = return } ========== but rest is same as default in authorize section In my "nas" table, I have following: ==================== nasname: 0.0.0.0 shortname: <shortname> type: other ports: 0 secret: <sharedsecret> ==================== My AP have same secret set but still the request is ignored. What are the other things I need to consider? I am trying to authenticate users from NAS somewhere in the internet. Thanks -- ============================== Registered Linux User #460714 Currently Using Fedora 10, CentOS 5.3 ==============================
I am using freeradius 2.1.6 in CentOS 5.3 with mysql backend.
As a follow up question to my previous posting, I have modified the following in dynamic-clients file.
Why did you feel the urge to modify anything apart from the shared secret???
server dynamic_client_server {
authorize {
Remove all this. Perhaps you should first read the comments in dynamic-clients to see what is it used for?
preprocess chap mschap suffix unix sql expiration logintime pap noresetcounter dailycounter monthlycounter accessperiod
So you added stuff you don't need and commented out what you do.
update control {
Remove comments from this:
#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"
You should leave this one commented out.
#FreeRADIUS-Client-Virtual-Server = "something"
}
This didn't match anything:
if ("%{sql: SELECT nasname FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}") {
I am not sure if I have to put all the modules as in the default file.
No. None. Read comments in the file to see what dynamic-clients example actually does.
In my "nas" table, I have following:
==================== nasname: 0.0.0.0 shortname: <shortname> type: other ports: 0 secret: <sharedsecret> ====================
Delete that. It's wrong. Ivan Kalik Kalik Informatika ISP
Hi,
server dynamic_client_server {
<snip> what have you done? why have you added all of that stuff to the default example??? dynamic_client_server is a very basic virtual server for one function - its not a complete virtual host. all you need is something like client dynamic { ipaddr = 0.0.0.0 netmask = 0 dynamic_clients = dynamic_client_server lifetime = 86400 } server dynamic_client_server { authorize { ..and now you choose to have a static selection to choose the shared secret or you choose to use eg SQL to get the required shared secret - which can be decided by eg special VSAs sent in the packet from the random NAS out there on the internet } } alan
On Tue, Sep 15, 2009 at 6:01 AM, Alan Buxey <A.L.M.Buxey@lboro.ac.uk> wrote:
Hi,
server dynamic_client_server {
<snip>
what have you done? why have you added all of that stuff to the default example???
dynamic_client_server is a very basic virtual server for one function - its not a complete virtual host.
all you need is something like
client dynamic { ipaddr = 0.0.0.0 netmask = 0 dynamic_clients = dynamic_client_server lifetime = 86400 }
server dynamic_client_server { authorize {
..and now you choose to have a static selection to choose the shared secret or you choose to use eg SQL to get the required shared secret - which can be decided by eg special VSAs sent in the packet from the random NAS out there on the internet
} }
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Sorry I completely misunderstood. I thought that only SQL part is used if we are using sql as backend instead of file. I have reverted back the changes I made. There is still something not clear to me regarding the secret and entry in nas table. My question is: 1) Do I need entry in nas table or not? I want that each NAS have different secret so that I can monitor each NAS.
In my "nas" table, I have following:
==================== nasname: 0.0.0.0 shortname: <shortname> type: other ports: 0 secret: <sharedsecret> ====================
Delete that. It's wrong.
In this case what should be the setting? Thanks -- ============================== Registered Linux User #460714 Currently Using Fedora 10, CentOS 5.3 ==============================
There is still something not clear to me regarding the secret and entry in nas table.
My question is:
1) Do I need entry in nas table or not?
No. You don't need that. You can have a single static shared secret value in the dynamic-clients configuration.
I want that each NAS have different secret so that I can monitor each NAS.
Without knowing the IP address? You can't do that at the moment. You will have to wait for NAS-Identifier to be made available for dynamic-clients or compile server with rlm_raw and extract it yourself. There should be a thread on the list about finding and using rlm_raw a few months back. Ivan Kalik Kalik Informatika ISP
I've nas entry in the db because I've modified the authentication query so that I need a nas entry, and the IP-Address can be as you want, also fantasy IP Address. Only, freeradius don't start if there are two identical IP-address in the Nas table or in the nas table and in the clients file. Bye
There is still something not clear to me regarding the secret and entry in nas table.
My question is:
1) Do I need entry in nas table or not?
No. You don't need that. You can have a single static shared secret value in the dynamic-clients configuration.
I want that each NAS have different secret so that I can monitor each NAS.
Without knowing the IP address? You can't do that at the moment. You will have to wait for NAS-Identifier to be made available for dynamic-clients or compile server with rlm_raw and extract it yourself. There should be a thread on the list about finding and using rlm_raw a few months back.
Ivan Kalik Kalik Informatika ISP
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Barbara Picci wrote:
I've nas entry in the db because I've modified the authentication query so that I need a nas entry, and the IP-Address can be as you want, also fantasy IP Address. Only, freeradius don't start if there are two identical IP-address in the Nas table or in the nas table and in the clients file.
RADIUS requires that client IP addresses be unique. You *cannot* use the same IP address for two different clients. Alan DeKok.
Thank you all for the valuable suggestions. I have one AP connected directly to radius server. For this, I have a entry in the nas table and was working fine. Now I have this client dynamic { ipaddr = 0.0.0.0 netmask = 0 dynamic_clients = dynamic_client_server lifetime = 86400 } and also changed the secret in my dynamic-clients to reflect my local AP's secret. I have removed the entry of my local AP from nas table and restarted the radius. Since dynamic-clients is in action, I thought I can authenticate through my local AP (since any ip should be fine with this config) but now the request is ignored. What can be the cause? Thanks again -- ============================== Registered Linux User #460714 Currently Using Fedora 10, CentOS 5.3 ==============================
Deepak wrote:
Thank you all for the valuable suggestions.
A large part of the problems you're running into is because you're not following the documentation.
Since dynamic-clients is in action, I thought I can authenticate through my local AP (since any ip should be fine with this config) but now the request is ignored. What can be the cause?
Run the server in debugging mode as suggested in the FAQ, README, INSTALL, and nearly daily on this list. Alan DeKok.
Run the server in debugging mode as suggested in the FAQ, README, INSTALL, and nearly daily on this list.
Alan DeKok.
I did that. Server runs smoothly without any warning or errors. Trying to authenticate generates this: =========== Ignoring request to authentication address * port 1812 from unknown client 192.168.1.5 port 32770 Ready to process requests. ========== I know that NAS is unknown but isn't that the dynamic-clients supposed to do its job in this situation? Thanks -- ============================== Registered Linux User #460714 Currently Using Fedora 10, CentOS 5.3 ==============================
On Wed, Sep 16, 2009 at 5:42 PM, Deepak <d88pak@gmail.com> wrote:
Run the server in debugging mode as suggested in the FAQ, README, INSTALL, and nearly daily on this list.
Alan DeKok.
I did that. Server runs smoothly without any warning or errors.
Trying to authenticate generates this: =========== Ignoring request to authentication address * port 1812 from unknown client 192.168.1.5 port 32770 Ready to process requests. ==========
I know that NAS is unknown but isn't that the dynamic-clients supposed to do its job in this situation?
Thanks
Full output of debug mode ==================================== FreeRADIUS Version 2.1.6, for host i386-redhat-linux-gnu, built on Jun 2 2009 at 17:33:54 Copyright (C) 1999-2009 The FreeRADIUS server project and contributors. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. You may redistribute copies of FreeRADIUS under the terms of the GNU General Public License v2. Starting - reading configuration files ... including configuration file /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/echo including configuration file /etc/raddb/modules/digest including configuration file /etc/raddb/modules/mac2vlan including configuration file /etc/raddb/modules/mac2ip including configuration file /etc/raddb/modules/checkval including configuration file /etc/raddb/modules/logintime including configuration file /etc/raddb/modules/pap including configuration file /etc/raddb/modules/preprocess including configuration file /etc/raddb/modules/acct_unique including configuration file /etc/raddb/modules/pam including configuration file /etc/raddb/modules/realm including configuration file /etc/raddb/modules/linelog including configuration file /etc/raddb/modules/ippool including configuration file /etc/raddb/modules/passwd including configuration file /etc/raddb/modules/counter including configuration file /etc/raddb/modules/detail including configuration file /etc/raddb/modules/expr including configuration file /etc/raddb/modules/detail.example.com including configuration file /etc/raddb/modules/etc_group including configuration file /etc/raddb/modules/sqlcounter_expire_on_login including configuration file /etc/raddb/modules/chap including configuration file /etc/raddb/modules/wimax including configuration file /etc/raddb/modules/otp including configuration file /etc/raddb/modules/always including configuration file /etc/raddb/modules/exec including configuration file /etc/raddb/modules/smsotp including configuration file /etc/raddb/modules/sradutmp including configuration file /etc/raddb/modules/mschap including configuration file /etc/raddb/modules/inner-eap including configuration file /etc/raddb/modules/detail.log including configuration file /etc/raddb/modules/expiration including configuration file /etc/raddb/modules/policy including configuration file /etc/raddb/modules/sql_log including configuration file /etc/raddb/modules/smbpasswd including configuration file /etc/raddb/modules/radutmp including configuration file /etc/raddb/modules/attr_rewrite including configuration file /etc/raddb/modules/attr_filter including configuration file /etc/raddb/modules/unix including configuration file /etc/raddb/modules/perl including configuration file /etc/raddb/modules/files 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/sql/mysql/counter.conf including configuration file /etc/raddb/policy.conf including files in directory /etc/raddb/sites-enabled/ including configuration file /etc/raddb/sites-enabled/default including configuration file /etc/raddb/sites-enabled/inner-tunnel including configuration file /etc/raddb/sites-enabled/control-socket 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 = "localhost123" 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 = "radiususer" password = "radiususer" radius_db = "radius" read_groups = yes sqltrace = no sqltracefile = "/var/log/radius/sqltrace.sql" readclients = yes 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 = "SELECT COUNT(*) FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL" 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 radiususer@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 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): 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 IFNULL(SUM(AcctSessionTime),0) 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: 1253094560 [2009-09-16 17:49:20], Next reset 0 [2009-09-16 17:00:00] rlm_sqlcounter: Current Time: 1253094560 [2009-09-16 17:49:20], Prev reset 0 [2009-09-16 17:00:00] Module: Instantiating dailycounter sqlcounter dailycounter { counter-name = "Daily-Session-Time" check-name = "Max-Daily-Session" reply-name = "Session-Timeout" key = "User-Name" sqlmod-inst = "sql" query = "SELECT SUM(acctsessiontime - GREATEST((%b - UNIX_TIMESTAMP(acctstarttime)), 0)) FROM radacct WHERE username = '%{%k}' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '%b'" reset = "daily" safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" } rlm_sqlcounter: Reply attribute Session-Timeout is number 27 rlm_sqlcounter: Counter attribute Daily-Session-Time is number 11275 rlm_sqlcounter: Check attribute Max-Daily-Session is number 11276 rlm_sqlcounter: Current Time: 1253094560 [2009-09-16 17:49:20], Next reset 1253116800 [2009-09-17 00:00:00] rlm_sqlcounter: Current Time: 1253094560 [2009-09-16 17:49:20], Prev reset 1253030400 [2009-09-16 00:00:00] Module: Instantiating monthlycounter sqlcounter monthlycounter { counter-name = "Monthly-Session-Time" check-name = "Max-Monthly-Session" reply-name = "Session-Timeout" key = "User-Name" sqlmod-inst = "sql" query = "SELECT SUM(acctsessiontime - GREATEST((%b - UNIX_TIMESTAMP(acctstarttime)), 0)) FROM radacct WHERE username='%{%k}' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '%b'" reset = "monthly" safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" } rlm_sqlcounter: Reply attribute Session-Timeout is number 27 rlm_sqlcounter: Counter attribute Monthly-Session-Time is number 11277 rlm_sqlcounter: Check attribute Max-Monthly-Session is number 11278 rlm_sqlcounter: Current Time: 1253094560 [2009-09-16 17:49:20], Next reset 1254326400 [2009-10-01 00:00:00] rlm_sqlcounter: Current Time: 1253094560 [2009-09-16 17:49:20], Prev reset 1251734400 [2009-09-01 00:00:00] Module: Instantiating accessperiod sqlcounter accessperiod { counter-name = "Max-Access-Period-Time" check-name = "Access-Period" key = "User-Name" sqlmod-inst = "sql" query = "SELECT UNIX_TIMESTAMP() - UNIX_TIMESTAMP(AcctStartTime) FROM radacct WHERE UserName = '%{%k}' ORDER BY AcctStartTime LIMIT 1 " reset = "never" safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" } rlm_sqlcounter: Reply attribute set to Session-Timeout. rlm_sqlcounter: Counter attribute Max-Access-Period-Time is number 11279 rlm_sqlcounter: Check attribute Access-Period is number 11280 rlm_sqlcounter: Current Time: 1253094560 [2009-09-16 17:49:20], Next reset 0 [2009-09-16 17:00:00] rlm_sqlcounter: Current Time: 1253094560 [2009-09-16 17:49:20], Prev reset 0 [2009-09-16 17:00:00] 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. Ignoring request to authentication address * port 1812 from unknown client 192.168.1.5 port 32770 Ignoring request to authentication address * port 1812 from unknown client 192.168.1.5 port 32770 Ignoring request to authentication address * port 1812 from unknown client 192.168.1.5 port 32770 Ignoring request to authentication address * port 1812 from unknown client 192.168.1.5 port 32770 Ignoring request to authentication address * port 1812 from unknown client 192.168.1.5 port 32770 Ignoring request to authentication address * port 1812 from unknown client 192.168.1.5 port 32770 Ignoring request to authentication address * port 1812 from unknown client 192.168.1.5 port 32770 Ignoring request to authentication address * port 1812 from unknown client 192.168.1.5 port 32770 Ignoring request to authentication address * port 1812 from unknown client 192.168.1.5 port 32770 Ignoring request to authentication address * port 1812 from unknown client 192.168.1.5 port 32770 Ignoring request to authentication address * port 1812 from unknown client 192.168.1.5 port 32770 Ignoring request to authentication address * port 1812 from unknown client 192.168.1.5 port 32770 Ready to process requests. ==================================== Thanks -- ============================== Registered Linux User #460714 Currently Using Fedora 10, CentOS 5.3 ==============================
Full output of debug mode ==================================== ... including files in directory /etc/raddb/sites-enabled/ including configuration file /etc/raddb/sites-enabled/default including configuration file /etc/raddb/sites-enabled/inner-tunnel including configuration file /etc/raddb/sites-enabled/control-socket ...
So, where is the dynamic-clients server? You haven't enabled it. Ivan Kalik Kalik Informatika ISP
So, where is the dynamic-clients server? You haven't enabled it.
Ivan Kalik Kalik Informatika ISP
I forgot to mention that I have enabled it. It is working. Thanks again -- ============================== Registered Linux User #460714 Currently Using Fedora 10, CentOS 5.3 ==============================
Run the server in debugging mode as suggested in the FAQ, README, INSTALL, and nearly daily on this list.
Alan DeKok.
I did that. Server runs smoothly without any warning or errors.
Trying to authenticate generates this: =========== Ignoring request to authentication address * port 1812 from unknown client 192.168.1.5 port 32770 Ready to process requests. ==========
I know that NAS is unknown but isn't that the dynamic-clients supposed to do its job in this situation?
It is. But you have made changes to default dznamic-clients configuration and broken it. Did you reverse the changes as you were told? The only change you were supposed to make is to comment out the virtual_server "something" line. Ivan Kalik Kalik Informatika ISP
Did you reverse the changes as you were told? The only change you were supposed to make is to comment out the virtual_server "something" line.
Ivan Kalik Kalik Informatika ISP
Thanks for pointing out. Actually I had a backup copy of the original and just restored it from there. When I was changing the sharedkey using nano, it was pushed to next line by nano. This was supposed to be in one line. After minor fix, all is OK. By the way monitoring AP doesn't seems a big deal since radacct table has callingstationID (MAC) of AP. Thanks again -- ============================== Registered Linux User #460714 Currently Using Fedora 10, CentOS 5.3 ==============================
participants (5)
-
Alan Buxey -
Alan DeKok -
Barbara Picci -
Deepak -
Ivan Kalik