Using Run-time variables in SQL radreply table
Hi list, in my lab setup i authenticate subscribers based on DHCP Option 82 remode-id against a Freeradius 2.1.8. Our DSLAMs enrich DHCP requests with DSL line-informations like Actual-Up- and Downstream-Rates. I use these values to have a dynamic QoS configuration on my BNG. With "files" authentication module, this works like a charm... Here's my current configuration in users file: HSI/DEU.MYID.47110815 Password := "lab" ERX-CoS-Shaping-Pmt-Type = "T02 %{request:Actual-Data-Rate-Downstream}", ERX-Virtual-Router-Name = VRF-HSI-CGN In Access-Accept, %{request:Actual-Data-Rate-Downstream} is translated to the respective Downstream bandwidth: Wed Dec 20 16:24:46 2017 - User HSI/DEU.MYID.47110815 Packet-Type = Access-Accept ERX-CoS-Shaping-Pmt-Type = "T02 25693" ERX-Virtual-Router-Name = "VRF-HSI-CGN" After successful testing, i tried to migrate to SQL authentication module. But that doesn't work because in rlm_sql %{request:Actual-Data-Rate-Downstream} is just a string and is not translated. Is there a possibility to use run-time variables in SQL radreply table or is there another module i can use to reach my goal ? Thanks in advance. Regards, Alex
On Dec 20, 2017, at 4:43 PM, Alex D. <listensammler@gmx.de> wrote:
in my lab setup i authenticate subscribers based on DHCP Option 82 remode-id against a Freeradius 2.1.8.
You should really use v3. Especially if it's a lab system. Or if you need v2, use 2.2.10. There's just no reason to use 2.1.8 from a decade ago.
Our DSLAMs enrich DHCP requests with DSL line-informations like Actual-Up- and Downstream-Rates. I use these values to have a dynamic QoS configuration on my BNG. With "files" authentication module, this works like a charm... Here's my current configuration in users file: HSI/DEU.MYID.47110815 Password := "lab" ERX-CoS-Shaping-Pmt-Type = "T02 %{request:Actual-Data-Rate-Downstream}", ERX-Virtual-Router-Name = VRF-HSI-CGN
In Access-Accept, %{request:Actual-Data-Rate-Downstream} is translated to the respective Downstream bandwidth: Wed Dec 20 16:24:46 2017 - User HSI/DEU.MYID.47110815 Packet-Type = Access-Accept ERX-CoS-Shaping-Pmt-Type = "T02 25693" ERX-Virtual-Router-Name = "VRF-HSI-CGN"
That's good...
After successful testing, i tried to migrate to SQL authentication module.
There's no "sql authentication module". Do you mean using SQL instead of the "users" file?
But that doesn't work because in rlm_sql %{request:Actual-Data-Rate-Downstream} is just a string and is not translated. Is there a possibility to use run-time variables in SQL radreply table or is there another module i can use to reach my goal ?
Upgrade to v3. This expansion will just work. It's one of the things we fixed in the last 10 years... Alan DeKok.
Hi Alan, thanks for your quick reply.
You should really use v3. Especially if it's a lab system.
Or if you need v2, use 2.2.10. There's just no reason to use 2.1.8 from a decade ago. Okay. I will upgrade my lab system soon. On our production system, we us 2.2.9. I have to talk with our IT guys for upgrade. There's no "sql authentication module".
Do you mean using SQL instead of the "users" file? Yes, you're right of course. I expressed myself wrong...
there a possibility to use run-time variables in SQL radreply table or is there another module i can use to reach my goal ? Upgrade to v3. This expansion will just work.
It's one of the things we fixed in the last 10 years...
If we need to stay on v2, is there no workaround ? Regards, Alex
On Dec 20, 2017, at 5:01 PM, Alex D. <listensammler@gmx.de> wrote:
If we need to stay on v2, is there no workaround ?
Hmm... I just checked v2. The expansion of the attributes in SQL reply table was added before 2.1.8 was released. Post the relevant debug output to show what's going on. Alan DeKok.
Hmm... I just checked v2. The expansion of the attributes in SQL reply table was added before 2.1.8 was released.
Post the relevant debug output to show what's going on.
Wed Dec 20 22:10:09 2017 - User HSI/DEU.MYID.47110815 Packet-Type = Access-Accept ERX-CoS-Shaping-Pmt-Type == "T02 %{request:Actual-Data-Rate-Downstream}" ERX-Virtual-Router-Name = "VRF-HSI-CGN" mysql> select * from radreply; +----+-------------------------+--------------------------+----+--------------------------------------------+ | id | username | attribute | op | value | +----+-------------------------+--------------------------+----+--------------------------------------------+ | 1 | HSI/DEU.MYID.47110815 | ERX-CoS-Shaping-Pmt-Type | == | T02 %{request:Actual-Data-Rate-Downstream} | | 2 | HSI/DEU.MYID.47110815 | ERX-Virtual-Router-Name | == | VRF_HSI_CGN | +----+-------------------------+--------------------------+----+--------------------------------------------+ Is this enough information or should i start radiusd in debug mode (radiusd -X) ? Regards, Alex
Output of radiusd -X.
Here's the output.... root@quagga:/opt/freeradius/etc/raddb# /opt/freeradius/sbin/radiusd -X FreeRADIUS Version 2.1.8, for host i686-pc-linux-gnu, built on Nov 24 2016 at 18:17:42 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 /opt/freeradius/etc/raddb/radiusd.conf including configuration file /opt/freeradius/etc/raddb/proxy.conf including configuration file /opt/freeradius/etc/raddb/clients.conf including files in directory /opt/freeradius/etc/raddb/modules/ including configuration file /opt/freeradius/etc/raddb/modules/files including configuration file /opt/freeradius/etc/raddb/modules/inner-eap including configuration file /opt/freeradius/etc/raddb/modules/sql_log including configuration file /opt/freeradius/etc/raddb/modules/expr including configuration file /opt/freeradius/etc/raddb/modules/attr_rewrite including configuration file /opt/freeradius/etc/raddb/modules/counter including configuration file /opt/freeradius/etc/raddb/modules/radutmp including configuration file /opt/freeradius/etc/raddb/modules/mschap including configuration file /opt/freeradius/etc/raddb/modules/perl including configuration file /opt/freeradius/etc/raddb/modules/ntlm_auth including configuration file /opt/freeradius/etc/raddb/modules/sqlcounter_expire_on_login including configuration file /opt/freeradius/etc/raddb/modules/etc_group including configuration file /opt/freeradius/etc/raddb/modules/otp including configuration file /opt/freeradius/etc/raddb/modules/detail.log including configuration file /opt/freeradius/etc/raddb/modules/krb5 including configuration file /opt/freeradius/etc/raddb/modules/ippool including configuration file /opt/freeradius/etc/raddb/modules/expiration including configuration file /opt/freeradius/etc/raddb/modules/detail.example.com including configuration file /opt/freeradius/etc/raddb/modules/logintime including configuration file /opt/freeradius/etc/raddb/modules/acct_unique including configuration file /opt/freeradius/etc/raddb/modules/ldap including configuration file /opt/freeradius/etc/raddb/modules/policy including configuration file /opt/freeradius/etc/raddb/modules/checkval including configuration file /opt/freeradius/etc/raddb/modules/smsotp including configuration file /opt/freeradius/etc/raddb/modules/digest including configuration file /opt/freeradius/etc/raddb/modules/mac2ip including configuration file /opt/freeradius/etc/raddb/modules/passwd including configuration file /opt/freeradius/etc/raddb/modules/sradutmp including configuration file /opt/freeradius/etc/raddb/modules/echo including configuration file /opt/freeradius/etc/raddb/modules/smbpasswd including configuration file /opt/freeradius/etc/raddb/modules/cui including configuration file /opt/freeradius/etc/raddb/modules/pam including configuration file /opt/freeradius/etc/raddb/modules/realm including configuration file /opt/freeradius/etc/raddb/modules/linelog including configuration file /opt/freeradius/etc/raddb/modules/chap including configuration file /opt/freeradius/etc/raddb/modules/attr_filter including configuration file /opt/freeradius/etc/raddb/modules/detail including configuration file /opt/freeradius/etc/raddb/modules/exec including configuration file /opt/freeradius/etc/raddb/modules/wimax including configuration file /opt/freeradius/etc/raddb/modules/unix including configuration file /opt/freeradius/etc/raddb/modules/preprocess including configuration file /opt/freeradius/etc/raddb/modules/pap including configuration file /opt/freeradius/etc/raddb/modules/always including configuration file /opt/freeradius/etc/raddb/modules/mac2vlan including configuration file /opt/freeradius/etc/raddb/eap.conf including configuration file /opt/freeradius/etc/raddb/sql.conf including configuration file /opt/freeradius/etc/raddb/sql/mysql/dialup.conf including configuration file /opt/freeradius/etc/raddb/policy.conf including files in directory /opt/freeradius/etc/raddb/sites-enabled/ including configuration file /opt/freeradius/etc/raddb/sites-enabled/inner-tunnel including configuration file /opt/freeradius/etc/raddb/sites-enabled/default including configuration file /opt/freeradius/etc/raddb/sites-enabled/control-socket main { allow_core_dumps = no } including dictionary file /opt/freeradius/etc/raddb/dictionary main { prefix = "/opt/freeradius" localstatedir = "/opt/freeradius/var" logdir = "/var/log/radius" libdir = "/opt/freeradius/lib" radacctdir = "/var/log/radius/radacct" hostname_lookups = no max_request_time = 30 cleanup_delay = 5 max_requests = 1024 pidfile = "/opt/freeradius/var/run/radiusd/radiusd.pid" checkrad = "/opt/freeradius/sbin/checkrad" debug_level = 0 proxy_requests = yes log { stripped_names = no auth = yes auth_badpass = yes auth_goodpass = yes } security { max_attributes = 200 reject_delay = 1 status_server = yes } } radiusd: #### Loading Realms and Home Servers #### proxy server { retry_delay = 5 retry_count = 3 default_fallback = no dead_time = 120 wake_all_if_all_dead = no } home_server localhost { ipaddr = 127.0.0.1 port = 1812 type = "auth" secret = "testing123" response_window = 20 max_outstanding = 65536 require_message_authenticator = no zombie_period = 40 status_check = "status-server" ping_interval = 30 check_interval = 30 num_answers_to_alive = 3 num_pings_to_alive = 3 revive_interval = 120 status_check_timeout = 4 irt = 2 mrt = 16 mrc = 5 mrd = 30 } home_server_pool my_auth_failover { type = fail-over home_server = localhost } realm example.com { auth_pool = my_auth_failover } realm LOCAL { } radiusd: #### Loading Clients #### client localhost { ipaddr = 127.0.0.1 require_message_authenticator = no secret = "testing123" nastype = "other" } client 212.88.148.150 { require_message_authenticator = no secret = "RaDiUsKeY" shortname = "ipv6-r1.681" } client 212.88.157.161 { require_message_authenticator = no secret = "RaDiUsKeY" shortname = "vs-cgn.6898" } client 212.88.157.162 { require_message_authenticator = no secret = "RaDiUsKeY" shortname = "vs-cgn-r1.6898" } client 212.88.157.163 { require_message_authenticator = no secret = "RaDiUsKeY" shortname = "vs-cgn-r1.6898" } client 212.88.136.241 { require_message_authenticator = no secret = "wz34th" shortname = "vs-mx5-lab.6898-wan" nastype = "other" } client 212.88.155.47 { require_message_authenticator = no secret = "wz34th" shortname = "vs-mx5-lab.6898-lo0" nastype = "other" } client 212.18.216.16/32 { require_message_authenticator = no secret = "wz34th" shortname = "vs-mx5-lab.6898-vrf-132" nastype = "other" } client 212.18.216.17/32 { require_message_authenticator = no secret = "wz34th" shortname = "vs-mx5-lab.6898-vrf-232" nastype = "other" } client 212.18.216.18/32 { require_message_authenticator = no secret = "wz34th" shortname = "vs-mx5-lab.6898-vrf-432" 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 = 4096 } 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 = "/opt/freeradius/etc/raddb/certs/server.pem" certificate_file = "/opt/freeradius/etc/raddb/certs/server.pem" CA_file = "/opt/freeradius/etc/raddb/certs/ca.pem" private_key_password = "whatever" dh_file = "/opt/freeradius/etc/raddb/certs/dh" random_file = "/opt/freeradius/etc/raddb/certs/random" fragment_size = 1024 include_length = yes check_crl = no cipher_list = "DEFAULT" make_cert_command = "/opt/freeradius/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 = "/opt/freeradius/etc/raddb/users" acctusersfile = "/opt/freeradius/etc/raddb/acct_users" preproxy_usersfile = "/opt/freeradius/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 = "/opt/freeradius/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 = "/opt/freeradius/etc/raddb/huntgroups" hints = "/opt/freeradius/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_detail Module: Instantiating auth_log detail auth_log { detailfile = "/var/log/radius/radacct/auth-detail-%Y%m%d" header = "%t" detailperm = 384 dirperm = 493 locking = no log_packet_header = no } Module: Linked to module rlm_sql Module: Instantiating sql sql { driver = "rlm_sql_mysql" server = "localhost" port = "" login = "radius" password = "IlsFmgB" radius_db = "radius" read_groups = yes sqltrace = yes sqltracefile = "/var/log/radius/sqltrace.sql" readclients = no deletestalesessions = yes num_sql_socks = 5 lifetime = 0 max_queries = 0 sql_user_name = "%{User-Name}" default_user_profile = "" nas_query = "SELECT id, nasname, shortname, type, secret FROM nas" authorize_check_query = "SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id" authorize_reply_query = "SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id" authorize_group_check_query = "SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{Sql-Group}' ORDER BY id" authorize_group_reply_query = "SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{Sql-Group}' ORDER BY id" accounting_onoff_query = " UPDATE radacct SET acctstoptime = '%S', acctsessiontime = unix_timestamp('%S') - unix_timestamp(acctstarttime), acctterminatecause = '%{Acct-Terminate-Cause}', acctstopdelay = %{%{Acct-Delay-Time}:-0} WHERE acctstoptime IS NULL AND nasipaddress = '%{NAS-IP-Address}' AND acctstarttime <= '%S'" accounting_update_query = " UPDATE radacct SET framedipaddress = '%{Framed-IP-Address}', acctsessiontime = '%{Acct-Session-Time}', acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}'" accounting_update_query_alt = " INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctsessiontime, acctauthentic, connectinfo_start, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, servicetype, framedprotocol, framedipaddress, acctstartdelay, xascendsessionsvrkey) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', DATE_SUB('%S', INTERVAL (%{%{Acct-Session-Time}:-0} + %{%{Acct-Delay-Time}:-0}) SECOND), '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0', '%{X-Ascend-Session-Svr-Key}')" accounting_start_query = " INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress, acctstartdelay, acctstopdelay, xascendsessionsvrkey) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', '%S', NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '%{%{Acct-Delay-Time}:-0}', '0', '%{X-Ascend-Session-Svr-Key}')" accounting_start_query_alt = " UPDATE radacct SET acctstarttime = '%S', acctstartdelay = '%{%{Acct-Delay-Time}:-0}', connectinfo_start = '%{Connect-Info}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}'" accounting_stop_query = " UPDATE radacct SET acctstoptime = '%S', acctsessiontime = '%{Acct-Session-Time}', acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}', acctterminatecause = '%{Acct-Terminate-Cause}', acctstopdelay = '%{%{Acct-Delay-Time}:-0}', connectinfo_stop = '%{Connect-Info}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}'" accounting_stop_query_alt = " INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress, acctstartdelay, acctstopdelay) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', DATE_SUB('%S', INTERVAL (%{%{Acct-Session-Time}:-0} + %{%{Acct-Delay-Time}:-0}) SECOND), '%S', '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{Connect-Info}', '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Acct-Terminate-Cause}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0', '%{%{Acct-Delay-Time}:-0}')" group_membership_query = "SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority" connect_failure_retry_delay = 60 simul_count_query = "" simul_verify_query = "SELECT radacctid, acctsessionid, username, nasipaddress, nasportid, framedipaddress, callingstationid, framedprotocol FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL" postauth_query = "INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '%{User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S')" safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" } rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to radius@localhost:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0 rlm_sql (sql): Connected new DB handle, #0 rlm_sql (sql): starting 1 rlm_sql (sql): Attempting to connect rlm_sql_mysql #1 rlm_sql_mysql: Starting connect to MySQL server for #1 rlm_sql (sql): Connected new DB handle, #1 rlm_sql (sql): starting 2 rlm_sql (sql): Attempting to connect rlm_sql_mysql #2 rlm_sql_mysql: Starting connect to MySQL server for #2 rlm_sql (sql): Connected new DB handle, #2 rlm_sql (sql): starting 3 rlm_sql (sql): Attempting to connect rlm_sql_mysql #3 rlm_sql_mysql: Starting connect to MySQL server for #3 rlm_sql (sql): Connected new DB handle, #3 rlm_sql (sql): starting 4 rlm_sql (sql): Attempting to connect rlm_sql_mysql #4 rlm_sql_mysql: Starting connect to MySQL server for #4 rlm_sql (sql): Connected new DB handle, #4 Module: Checking preacct {...} for more modules to load Module: Linked to module rlm_acct_unique Module: Instantiating acct_unique acct_unique { key = "User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port" } Module: Checking accounting {...} for more modules to load Module: Instantiating detail detail { detailfile = "/var/log/radius/radacct/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 = "/opt/freeradius/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 reply_log detail reply_log { detailfile = "/var/log/radius/radacct/reply-detail-%Y%m%d" header = "%t - User %{User-Name}" detailperm = 384 dirperm = 493 locking = no log_packet_header = no } } # 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 = "/opt/freeradius/var/run/radiusd/radiusd.sock" } } Listening on authentication address * port 1812 Listening on accounting address * port 1813 Listening on command file /opt/freeradius/var/run/radiusd/radiusd.sock Listening on proxy address * port 1814 Ready to process requests. rad_recv: Access-Request packet from host 212.88.155.47 port 55529, id=218, length=640 User-Name = "HSI/DEU.MYID.47110815" User-Password = "lab" Service-Type = Framed-User Chargeable-User-Identity = "" Acct-Session-Id = "172564" Calling-Station-Id = "vs-mx5-testlab.6898#1ISAM-GSL-7302 eth 1/1/15/02#DEU.MYID.47110815" ERX-Dhcp-Options = 0x3501013c1341564d2044484350432076392e30342e3339353d0fffd77f2ae8000300010896d77f2ae80c09667269747a2e626f78370b01030679f9d40f782a1a9e528c011c314953414d2d47534c2d373330322065746820312f312f31352f303202114445552e4d5949442e3437313130383135095900000de95481040000049f820400006459830400000200840400000520850400008b878604000000008704000004a08804000064608904000000008a04000000808b04000000088c04000000038d04000000088e0400000008 ERX-Dhcp-Gi-Address = 212.88.155.47 ERX-Dhcp-Mac-Addr = "0896.d77f.2ae8" NAS-Identifier = "vs-mx5-testlab.6898" NAS-Port = 284201092 NAS-Port-Id = "ge-1/1/3.demux0.3221287835:777-132" NAS-Port-Type = Ethernet ERX-Pppoe-Description = "pppoe 08:96:d7:7f:2a:e8" ADSL-Agent-Circuit-Id = "1ISAM-GSL-7302 eth 1/1/15/02" ADSL-Agent-Remote-Id = "DEU.MYID.47110815" Actual-Data-Rate-Upstream = 1183 Actual-Data-Rate-Downstream = 25689 Minimum-Data-Rate-Upstream = 512 Minimum-Data-Rate-Downstream = 1312 Attainable-Data-Rate-Upstream = 35719 Attainable-Data-Rate-Downstream = 0 Maximum-Data-Rate-Upstream = 1184 Maximum-Data-Rate-Downstream = 25696 Minimum-Data-Rate-Upstream-Low-Power = 0 Minimum-Data-Rate-Downstream-Low-Power = 128 Maximum-Interleaving-Delay-Upstream = 8 Actual-Interleaving-Delay-Upstream = 3 Maximum-Interleaving-Delay-Downstream = 8 Actual-Interleaving-Delay-Downstream = 8 NAS-IP-Address = 212.88.155.47 +- entering group authorize {...} ++[preprocess] returns ok [auth_log] expand: /var/log/radius/radacct/auth-detail-%Y%m%d -> /var/log/radius/radacct/auth-detail-20171221 [auth_log] /var/log/radius/radacct/auth-detail-%Y%m%d expands to /var/log/radius/radacct/auth-detail-20171221 [auth_log] expand: %t -> Thu Dec 21 00:09:12 2017 ++[auth_log] returns ok ++[chap] returns noop ++[mschap] returns noop [suffix] No '@' in User-Name = "HSI/DEU.MYID.47110815", 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] expand: %{User-Name} -> HSI/DEU.MYID.47110815 [files] expand: %{User-Name} -> HSI/DEU.MYID.47110815 [files] expand: %{User-Name} -> HSI/DEU.MYID.47110815 ++[files] returns noop [sql] expand: %{User-Name} -> HSI/DEU.MYID.47110815 [sql] sql_set_user escaped user --> 'HSI/DEU.MYID.47110815' rlm_sql (sql): Reserving sql socket id: 4 [sql] expand: SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'HSI/DEU.MYID.47110815' ORDER BY id rlm_sql_mysql: query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'HSI/DEU.MYID.47110815' ORDER BY id WARNING: Found User-Password == "...". WARNING: Are you sure you don't mean Cleartext-Password? WARNING: See "man rlm_pap" for more information. [sql] User found in radcheck table [sql] expand: SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'HSI/DEU.MYID.47110815' ORDER BY id rlm_sql_mysql: query: SELECT id, username, attribute, value, op FROM radreply WHERE username = 'HSI/DEU.MYID.47110815' ORDER BY id [sql] expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup WHERE username = 'HSI/DEU.MYID.47110815' ORDER BY priority rlm_sql_mysql: query: SELECT groupname FROM radusergroup WHERE username = 'HSI/DEU.MYID.47110815' ORDER BY priority rlm_sql (sql): Released sql socket id: 4 ++[sql] returns ok ++[expiration] returns noop ++[logintime] returns noop ++[pap] returns updated Found Auth-Type = PAP !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!! Replacing User-Password in config items with Cleartext-Password. !!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!! Please update your configuration so that the "known good" !!! !!! clear text password is in Cleartext-Password, and not in User-Password. !!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! +- entering group PAP {...} [pap] login attempt with password "lab" [pap] Using clear text password "lab" [pap] User authenticated successfully ++[pap] returns ok Login OK: [HSI/DEU.MYID.47110815/lab] (from client vs-mx5-lab.6898-lo0 port 284201092 cli vs-mx5-testlab.6898#1ISAM-GSL-7302 eth 1/1/15/02#DEU.MYID.47110815) +- entering group post-auth {...} [reply_log] expand: /var/log/radius/radacct/reply-detail-%Y%m%d -> /var/log/radius/radacct/reply-detail-20171221 [reply_log] /var/log/radius/radacct/reply-detail-%Y%m%d expands to /var/log/radius/radacct/reply-detail-20171221 [reply_log] expand: %t - User %{User-Name} -> Thu Dec 21 00:09:12 2017 - User HSI/DEU.MYID.47110815 ++[reply_log] returns ok [sql] expand: %{User-Name} -> HSI/DEU.MYID.47110815 [sql] sql_set_user escaped user --> 'HSI/DEU.MYID.47110815' [sql] expand: %{User-Password} -> lab [sql] expand: INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '%{User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S') -> INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( 'HSI/DEU.MYID.47110815', 'lab', 'Access-Accept', '2017-12-21 00:09:12') [sql] expand: /var/log/radius/sqltrace.sql -> /var/log/radius/sqltrace.sql rlm_sql (sql) in sql_postauth: query is INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( 'HSI/DEU.MYID.47110815', 'lab', 'Access-Accept', '2017-12-21 00:09:12') rlm_sql (sql): Reserving sql socket id: 3 rlm_sql_mysql: query: INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( 'HSI/DEU.MYID.47110815', 'lab', 'Access-Accept', '2017-12-21 00:09:12') rlm_sql (sql): Released sql socket id: 3 ++[sql] returns ok ++[exec] returns noop Sending Access-Accept of id 218 to 212.88.155.47 port 55529 ERX-CoS-Shaping-Pmt-Type == "T02 %{request:Actual-Data-Rate-Downstream}" Finished request 0. Going to the next request Waking up in 4.9 seconds. rad_recv: Accounting-Request packet from host 212.88.155.47 port 55529, id=232, length=672 User-Name = "HSI/DEU.MYID.47110815" Acct-Status-Type = Start Acct-Session-Id = "172564" Event-Timestamp = "Dec 21 2017 00:09:13 CET" Acct-Delay-Time = 0 Service-Type = Framed-User Acct-Authentic = RADIUS Calling-Station-Id = "vs-mx5-testlab.6898#1ISAM-GSL-7302 eth 1/1/15/02#DEU.MYID.47110815" ERX-Dhcp-Options = 0x3501013c1341564d2044484350432076392e30342e3339353d0fffd77f2ae8000300010896d77f2ae80c09667269747a2e626f78370b01030679f9d40f782a1a9e528c011c314953414d2d47534c2d373330322065746820312f312f31352f303202114445552e4d5949442e3437313130383135095900000de95481040000049f820400006459830400000200840400000520850400008b878604000000008704000004a08804000064608904000000008a04000000808b04000000088c04000000038d04000000088e0400000008 ERX-Dhcp-Gi-Address = 212.88.155.47 ERX-Dhcp-Mac-Addr = "0896.d77f.2ae8" Framed-IP-Address = 212.18.214.139 NAS-Identifier = "vs-mx5-testlab.6898" NAS-Port = 284201092 NAS-Port-Id = "ge-1/1/3.demux0.3221287835:777-132" NAS-Port-Type = Ethernet ERX-Virtual-Router-Name = "default:default" ERX-Pppoe-Description = "pppoe 08:96:d7:7f:2a:e8" ADSL-Agent-Circuit-Id = "1ISAM-GSL-7302 eth 1/1/15/02" ADSL-Agent-Remote-Id = "DEU.MYID.47110815" Actual-Data-Rate-Upstream = 1183 Actual-Data-Rate-Downstream = 25689 Minimum-Data-Rate-Upstream = 512 Minimum-Data-Rate-Downstream = 1312 Attainable-Data-Rate-Upstream = 35719 Attainable-Data-Rate-Downstream = 0 Maximum-Data-Rate-Upstream = 1184 Maximum-Data-Rate-Downstream = 25696 Minimum-Data-Rate-Upstream-Low-Power = 0 Minimum-Data-Rate-Downstream-Low-Power = 128 Maximum-Interleaving-Delay-Upstream = 8 Actual-Interleaving-Delay-Upstream = 3 Maximum-Interleaving-Delay-Downstream = 8 Actual-Interleaving-Delay-Downstream = 8 NAS-IP-Address = 212.88.155.47 +- entering group preacct {...} ++[preprocess] returns ok [acct_unique] Hashing 'NAS-Port = 284201092,Client-IP-Address = 212.88.155.47,NAS-IP-Address = 212.88.155.47,Acct-Session-Id = "172564",User-Name = "HSI/DEU.MYID.47110815"' [acct_unique] Acct-Unique-Session-ID = "73ccf076cfde4cbc". ++[acct_unique] returns ok [suffix] No '@' in User-Name = "HSI/DEU.MYID.47110815", looking up realm NULL [suffix] No such realm "NULL" ++[suffix] returns noop ++[files] returns noop +- entering group accounting {...} [detail] expand: /var/log/radius/radacct/detail-%Y%m%d -> /var/log/radius/radacct/detail-20171221 [detail] /var/log/radius/radacct/detail-%Y%m%d expands to /var/log/radius/radacct/detail-20171221 [detail] expand: %t -> Thu Dec 21 00:09:13 2017 ++[detail] returns ok ++[unix] returns ok [radutmp] expand: /var/log/radius/radutmp -> /var/log/radius/radutmp [radutmp] expand: %{User-Name} -> HSI/DEU.MYID.47110815 ++[radutmp] returns ok [sql] expand: %{User-Name} -> HSI/DEU.MYID.47110815 [sql] sql_set_user escaped user --> 'HSI/DEU.MYID.47110815' [sql] expand: %{Acct-Delay-Time} -> 0 [sql] expand: 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}', [sql] expand: /var/log/radius/sqltrace.sql -> /var/log/radius/sqltrace.sql rlm_sql (sql): Reserving sql socket id: 2 rlm_sql_mysql: 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 ('172564', '73ccf076cfde4cbc', 'HSI/DEU.MYID.47110815', '', '212.88.155.47', '284201092', 'Ethernet', '2017-12-21 00:09:13', NULL, '0', 'RADIUS', '', '', '0', '0', '', 'vs-mx5-testlab.6898=231ISAM-GSL-7302 eth 1/1/15/02=23DEU.MYID.47110815', '', 'Framed-User', '', '212.18.214.139', '0', '0', '') rlm_sql (sql): Released sql socket id: 2 ++[sql] returns ok [attr_filter.accounting_response] expand: %{User-Name} -> HSI/DEU.MYID.47110815 attr_filter: Matched entry DEFAULT at line 12 ++[attr_filter.accounting_response] returns updated Sending Accounting-Response of id 232 to 212.88.155.47 port 55529 Finished request 1. Cleaning up request 1 ID 232 with timestamp +39 Going to the next request Waking up in 3.6 seconds. rad_recv: Accounting-Request packet from host 212.88.155.47 port 55529, id=228, length=838 User-Name = "HSI/DEU.MYID.47110815" Acct-Status-Type = Interim-Update Acct-Session-Id = "172564" Event-Timestamp = "Dec 21 2017 00:09:14 CET" Acct-Input-Octets = 0 Acct-Output-Octets = 0 Acct-Session-Time = 1 Acct-Input-Packets = 0 Acct-Output-Packets = 0 Acct-Delay-Time = 0 Service-Type = Framed-User ERX-Attr-177 = 0x506f72742073706565643a20313030303030306b Acct-Authentic = RADIUS Calling-Station-Id = "vs-mx5-testlab.6898#1ISAM-GSL-7302 eth 1/1/15/02#DEU.MYID.47110815" ERX-Dhcp-Options = 0x3501013c1341564d2044484350432076392e30342e3339353d0fffd77f2ae8000300010896d77f2ae80c09667269747a2e626f78370b01030679f9d40f782a1a9e528c011c314953414d2d47534c2d373330322065746820312f312f31352f303202114445552e4d5949442e3437313130383135095900000de95481040000049f820400006459830400000200840400000520850400008b878604000000008704000004a08804000064608904000000008a04000000808b04000000088c04000000038d04000000088e0400000008 ERX-Dhcp-Gi-Address = 212.88.155.47 ERX-Dhcp-Mac-Addr = "0896.d77f.2ae8" Framed-IP-Address = 212.18.214.139 ERX-Input-Gigapkts = 0 Acct-Input-Gigawords = 0 NAS-Identifier = "vs-mx5-testlab.6898" NAS-Port = 284201092 NAS-Port-Id = "ge-1/1/3.demux0.3221287835:777-132" NAS-Port-Type = Ethernet ERX-Output-Gigapkts = 0 Acct-Output-Gigawords = 0 ERX-IPv6-Acct-Input-Octets = 0 ERX-IPv6-Acct-Output-Octets = 0 ERX-IPv6-Acct-Input-Packets = 0 ERX-IPv6-Acct-Output-Packets = 0 ERX-IPv6-Acct-Input-Gigawords = 0 ERX-IPv6-Acct-Output-Gigawords = 0 ERX-Virtual-Router-Name = "default:default" ERX-Pppoe-Description = "pppoe 08:96:d7:7f:2a:e8" ADSL-Agent-Circuit-Id = "1ISAM-GSL-7302 eth 1/1/15/02" ADSL-Agent-Remote-Id = "DEU.MYID.47110815" Actual-Data-Rate-Upstream = 1183 Actual-Data-Rate-Downstream = 25689 Minimum-Data-Rate-Upstream = 512 Minimum-Data-Rate-Downstream = 1312 Attainable-Data-Rate-Upstream = 35719 Attainable-Data-Rate-Downstream = 0 Maximum-Data-Rate-Upstream = 1184 Maximum-Data-Rate-Downstream = 25696 Minimum-Data-Rate-Upstream-Low-Power = 0 Minimum-Data-Rate-Downstream-Low-Power = 128 Maximum-Interleaving-Delay-Upstream = 8 Actual-Interleaving-Delay-Upstream = 3 Maximum-Interleaving-Delay-Downstream = 8 Actual-Interleaving-Delay-Downstream = 8 NAS-IP-Address = 212.88.155.47 +- entering group preacct {...} ++[preprocess] returns ok [acct_unique] Hashing 'NAS-Port = 284201092,Client-IP-Address = 212.88.155.47,NAS-IP-Address = 212.88.155.47,Acct-Session-Id = "172564",User-Name = "HSI/DEU.MYID.47110815"' [acct_unique] Acct-Unique-Session-ID = "73ccf076cfde4cbc". ++[acct_unique] returns ok [suffix] No '@' in User-Name = "HSI/DEU.MYID.47110815", looking up realm NULL [suffix] No such realm "NULL" ++[suffix] returns noop ++[files] returns noop +- entering group accounting {...} [detail] expand: /var/log/radius/radacct/detail-%Y%m%d -> /var/log/radius/radacct/detail-20171221 [detail] /var/log/radius/radacct/detail-%Y%m%d expands to /var/log/radius/radacct/detail-20171221 [detail] expand: %t -> Thu Dec 21 00:09:14 2017 ++[detail] returns ok ++[unix] returns noop [radutmp] expand: /var/log/radius/radutmp -> /var/log/radius/radutmp [radutmp] expand: %{User-Name} -> HSI/DEU.MYID.47110815 ++[radutmp] returns ok [sql] expand: %{User-Name} -> HSI/DEU.MYID.47110815 [sql] sql_set_user escaped user --> 'HSI/DEU.MYID.47110815' [sql] expand: %{Acct-Input-Gigawords} -> 0 [sql] expand: %{Acct-Input-Octets} -> 0 [sql] expand: %{Acct-Output-Gigawords} -> 0 [sql] expand: %{Acct-Output-Octets} -> 0 [sql] expand: 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}' -> UPDATE radacct SET framedipaddress = '212.18.214.139', acctsessiontime = '1', acctinputoctets = '0' << 32 | '0', acctoutputoctets = '0' << 32 | '0' WHERE acctsessionid = '172564' AND username = 'HSI/DEU.MYID.47110815' AND [sql] expand: /var/log/radius/sqltrace.sql -> /var/log/radius/sqltrace.sql rlm_sql (sql): Reserving sql socket id: 1 rlm_sql_mysql: query: UPDATE radacct SET framedipaddress = '212.18.214.139', acctsessiontime = '1', acctinputoctets = '0' << 32 | '0', acctoutputoctets = '0' << 32 | '0' WHERE acctsessionid = '172564' AND username = 'HSI/DEU.MYID.47110815' AND nasipaddress = '212.88.155.47' rlm_sql (sql): Released sql socket id: 1 ++[sql] returns ok [attr_filter.accounting_response] expand: %{User-Name} -> HSI/DEU.MYID.47110815 attr_filter: Matched entry DEFAULT at line 12 ++[attr_filter.accounting_response] returns updated Sending Accounting-Response of id 228 to 212.88.155.47 port 55529 Finished request 2. Cleaning up request 2 ID 228 with timestamp +40 Going to the next request Waking up in 2.9 seconds. Cleaning up request 0 ID 218 with timestamp +38 Ready to process requests.
Output of radiusd -X.
Here's the output....
root@quagga:/opt/freeradius/etc/raddb# /opt/freeradius/sbin/radiusd -X FreeRADIUS Version 2.1.8, for host i686-pc-linux-gnu, built on Nov 24 2016 at 18:17:42 Copyright (C) 1999-2009 The FreeRADIUS server project and contributors. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. ...... I updated my lab RADIUS to freeradius 2.2.10 now. But my problem still remains... Could you already check provided debugging output ? Regards, Alex
On Dec 21, 2017, at 8:27 AM, Alex D. <listensammler@gmx.de> wrote:
I updated my lab RADIUS to freeradius 2.2.10 now. But my problem still remains... Could you already check provided debugging output ?
It's not clear what's going on. Please try v3. v2 is end of life, and I can't spend any time debugging it. Alan DeKok.
It's not clear what's going on.
Please try v3. v2 is end of life, and I can't spend any time debugging it.
FYI After trial and error, it works now. I first tried to put %{request:Actual-Data-Rate-Downstream} between backticks to perform a run-time expansion, but that still doesn't worked. mysql> select * from radreply; +----+-------------------------+--------------------------+----+--------------------------------------------+ | id | username | attribute | op | value | +----+-------------------------+--------------------------+----+--------------------------------------------+ | 1 | HSI/DEU.MYID.47110815 | ERX-CoS-Shaping-Pmt-Type | == | T02 `%{request:Actual-Data-Rate-Downstream}` | | 2 | HSI/DEU.MYID.47110815 | ERX-Virtual-Router-Name | == | VRF_HSI_CGN | +----+-------------------------+--------------------------+----+--------------------------------------------+ Fri Dec 22 03:44:44 2017 Packet-Type = Access-Accept ERX-Virtual-Router-Name := "VRF-132" ERX-CoS-Shaping-Pmt-Type := "T02 `%{Actual-Data-Rate-Downstream}`" Later I put backticks around the *whole* string, and that finally leads me to the goal... mysql> select * from radreply; +----+-------------------------+--------------------------+----+--------------------------------------------+ | id | username | attribute | op | value | +----+-------------------------+--------------------------+----+--------------------------------------------+ | 1 | HSI/DEU.MYID.47110815 | ERX-CoS-Shaping-Pmt-Type | == | `T02 %{request:Actual-Data-Rate-Downstream}` | | 2 | HSI/DEU.MYID.47110815 | ERX-Virtual-Router-Name | == | VRF_HSI_CGN | +----+-------------------------+--------------------------+----+--------------------------------------------+ Fri Dec 22 11:38:44 2017 Packet-Type = Access-Accept ERX-Virtual-Router-Name := "VRF-132" ERX-CoS-Shaping-Pmt-Type := "T02 25693" Regards, Alex
participants (3)
-
Alan DeKok -
Alex D. -
Matt Zagrabelny