Dear Alan,
I defined the Class attribute as a string because when I store it in
mysql it does not store its ASCII representation.
Below there is the output generated by freeradius (debug mode) from
startup until it receives the Accounting Request containing the Class
attribute. (See at the bottom of the message).
As I said, if I edit the file /etc/freeradius/dictionary with the line:
ATTRIBUTE Class 25 string
the Class attribute does not appear in the request as:
Class = 'whatever_string'
But instead:
/usr/lib (Unknown Type 779252325)
However, when I edit directly the dictionary (under
/usr/share/freeradius/) everything works as expected.
Thanks for any help,
Alex
======================================================
Config: including file: /etc/freeradius/proxy.conf
Config: including file: /etc/freeradius/clients.conf
Config: including file: /etc/freeradius/snmp.conf
Config: including file: /etc/freeradius/sql.conf
main: prefix = "/usr"
main: localstatedir = "/var"
main: logdir = "/var/log/freeradius"
main: libdir = "/usr/lib/freeradius"
main: radacctdir = "/var/log/freeradius/radacct"
main: hostname_lookups = no
main: max_request_time = 30
main: cleanup_delay = 5
main: max_requests = 1024
main: delete_blocked_requests = 0
main: port = 0
main: allow_core_dumps = no
main: log_stripped_names = no
main: log_file = "/var/log/freeradius/radius.log"
main: log_auth = yes
main: log_auth_badpass = yes
main: log_auth_goodpass = yes
main: pidfile = "/var/run/freeradius/freeradius.pid"
main: user = "freerad"
main: group = "freerad"
main: usercollide = no
main: lower_user = "no"
main: lower_pass = "no"
main: nospace_user = "no"
main: nospace_pass = "no"
main: checkrad = "/usr/sbin/checkrad"
main: proxy_requests = yes
proxy: retry_delay = 5
proxy: retry_count = 3
proxy: synchronous = no
proxy: default_fallback = yes
proxy: dead_time = 120
proxy: post_proxy_authorize = yes
proxy: wake_all_if_all_dead = no
security: max_attributes = 200
security: reject_delay = 1
security: status_server = no
main: debug_level = 0
read_config_files: reading dictionary
read_config_files: reading naslist
Using deprecated naslist file. Support for this will go away soon.
read_config_files: reading clients
read_config_files: reading realms
radiusd: entering modules setup
Module: Library search path is /usr/lib/freeradius
Module: Loaded expr
Module: Instantiated expr (expr)
Module: Loaded PAP
pap: encryption_scheme = "crypt"
Module: Instantiated pap (pap)
Module: Loaded CHAP
Module: Instantiated chap (chap)
Module: Loaded MS-CHAP
mschap: use_mppe = yes
mschap: require_encryption = no
mschap: require_strong = no
mschap: with_ntdomain_hack = no
mschap: passwd = "(null)"
mschap: authtype = "MS-CHAP"
mschap: ntlm_auth = "(null)"
Module: Instantiated mschap (mschap)
Module: Loaded System
unix: cache = no
unix: passwd = "(null)"
unix: shadow = "/etc/shadow"
unix: group = "(null)"
unix: radwtmp = "/var/log/freeradius/radwtmp"
unix: usegroup = no
unix: cache_reload = 600
Module: Instantiated unix (unix)
Module: Loaded eap
eap: default_eap_type = "md5"
eap: timer_expire = 60
eap: ignore_unknown_eap_types = no
eap: cisco_accounting_username_bug = no
rlm_eap: Loaded and initialized type md5
rlm_eap: Loaded and initialized type leap
Module: Instantiated eap (eap)
Module: Loaded preprocess
preprocess: huntgroups = "/etc/freeradius/huntgroups"
preprocess: hints = "/etc/freeradius/hints"
preprocess: with_ascend_hack = no
preprocess: ascend_channels_per_line = 23
preprocess: with_ntdomain_hack = no
preprocess: with_specialix_jetstream_hack = no
preprocess: with_cisco_vsa_hack = no
Module: Instantiated preprocess (preprocess)
Module: Loaded detail
detail: detailfile = "/var/log/freeradius/radacct/auth-detail-%Y%m%d"
detail: detailperm = 384
detail: dirperm = 493
detail: locking = no
Module: Instantiated detail (auth_log)
Module: Loaded realm
realm: format = "suffix"
realm: delimiter = "@"
realm: ignore_default = no
realm: ignore_null = no
Module: Instantiated realm (suffix)
Module: Loaded files
files: usersfile = "/etc/freeradius/users"
files: acctusersfile = "/etc/freeradius/acct_users"
files: preproxy_usersfile = "/etc/freeradius/preproxy_users"
files: compat = "no"
Module: Instantiated files (files)
Module: Loaded SQL
sql: driver = "rlm_sql_mysql"
sql: server = "localhost"
sql: port = ""
sql: login = "xxxxxx"
sql: password = "xxxxxxx"
sql: radius_db = "radius"
sql: acct_table = "radacct"
sql: acct_table2 = "radacct"
sql: authcheck_table = "radcheck"
sql: authreply_table = "radreply"
sql: groupcheck_table = "radgroupcheck"
sql: groupreply_table = "radgroupreply"
sql: usergroup_table = "usergroup"
sql: nas_table = "nas"
sql: dict_table = "dictionary"
sql: sqltrace = yes
sql: sqltracefile = "/var/log/freeradius/sqltrace.sql"
sql: readclients = no
sql: deletestalesessions = yes
sql: num_sql_socks = 5
sql: sql_user_name = "%{User-Name}"
sql: default_user_profile = ""
sql: query_on_not_found = no
sql: authorize_check_query = "SELECT id,UserName,Attribute,Value,op
FROM radcheck WHERE Username = '%{SQL-User-N
ame}' ORDER BY id"
sql: authorize_reply_query = "SELECT id,UserName,Attribute,Value,op
FROM radreply WHERE Username = '%{SQL-User-N
ame}' ORDER BY id"
sql: authorize_group_check_query = "SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radg
roupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE
usergroup.Username = '%{SQL-User-Name}' AND
usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id"
sql: authorize_group_reply_query = "SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radg
roupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE
usergroup.Username = '%{SQL-User-Name}' AND
usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id"
sql: accounting_onoff_query = "UPDATE radacct SET AcctStopTime='%S',
AcctSessionTime=unix_timestamp('%S') - unix
_timestamp(AcctStartTime), AcctTerminateCause='%{Acct-Terminate-Cause}',
AcctStopDelay = %{Acct-Delay-Time} WHERE
AcctSessionTime=0 AND AcctStopTime=0 AND NASIPAddress=
'%{NAS-IP-Address}' AND AcctStartTime <= '%S'"
sql: accounting_update_query = "UPDATE radacct SET FramedIPAddress =
'%{Framed-IP-Address}' WHERE AcctSessionId
= '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND
NASIPAddress= '%{NAS-IP-Address}' AND AcctStopTime =
0"
sql: accounting_update_query_alt = ""
sql: accounting_start_query = "INSERT into radacct (RadAcctId,
AcctSessionId, AcctUniqueId, UserName, Realm, NAS
IPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime,
AcctSessionTime, AcctAuthentic, ConnectInfo_start
, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId,
CallingStationId, AcctTerminateCause, Ser
viceType, FramedProtocol, FramedIPAddress, AcctStartDelay,
AcctStopDelay) values('', '%{Acct-Session-Id}', '%{Acc
t-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}',
'%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', '%
S', '0', '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0',
'%{Called-Station-Id}', '%{Calling-Station-Id
}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}',
'%{Acct-Delay-Time}', '0')"
sql: accounting_start_query_alt = "UPDATE radacct SET AcctStartTime =
'%S', AcctStartDelay = '%{Acct-Delay-Time}
', ConnectInfo_start = '%{Connect-Info}' WHERE AcctSessionId =
'%{Acct-Session-Id}' AND UserName = '%{SQL-User-Na
me}' AND NASIPAddress = '%{NAS-IP-Address}' AND AcctStopTime = 0"
sql: accounting_stop_query = ""
sql: accounting_stop_query_alt = ""
sql: group_membership_query = "SELECT GroupName FROM usergroup WHERE
UserName='%{SQL-User-Name}'"
sql: connect_failure_retry_delay = 60
sql: simul_count_query = ""
sql: simul_verify_query = "SELECT RadAcctId, AcctSessionId, UserName,
NASIPAddress, NASPortId, FramedIPAddress,
CallingStationId, FramedProtocol FROM radacct WHERE
UserName='%{SQL-User-Name}' AND AcctStopTime = 0"
sql: postauth_table = "radpostauth"
sql: postauth_query = ""
sql: safe-characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
rlm_sql (sql1): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and
linked
rlm_sql (sql1): Attempting to connect to [EMAIL PROTECTED]:/radius
rlm_sql (sql1): starting 0
rlm_sql (sql1): Attempting to connect rlm_sql_mysql #0
rlm_sql_mysql: Starting connect to MySQL server for #0
rlm_sql (sql1): Connected new DB handle, #0
rlm_sql (sql1): starting 1
rlm_sql (sql1): Attempting to connect rlm_sql_mysql #1
rlm_sql_mysql: Starting connect to MySQL server for #1
rlm_sql (sql1): Connected new DB handle, #1
rlm_sql (sql1): starting 2
rlm_sql (sql1): Attempting to connect rlm_sql_mysql #2
rlm_sql_mysql: Starting connect to MySQL server for #2
rlm_sql (sql1): Connected new DB handle, #2
rlm_sql (sql1): starting 3
rlm_sql (sql1): Attempting to connect rlm_sql_mysql #3
rlm_sql_mysql: Starting connect to MySQL server for #3
rlm_sql (sql1): Connected new DB handle, #3
rlm_sql (sql1): starting 4
rlm_sql (sql1): Attempting to connect rlm_sql_mysql #4
rlm_sql_mysql: Starting connect to MySQL server for #4
rlm_sql (sql1): Connected new DB handle, #4
Module: Instantiated sql (sql1)
sql: driver = "rlm_sql_mysql"
sql: server = "localhost"
sql: port = ""
sql: login = "xxxxx"
sql: password = "xxxxxxx"
sql: radius_db = "radius"
sql: acct_table = "radacct"
sql: acct_table2 = "radacct"
sql: authcheck_table = "rg_info"
sql: authreply_table = "radreply"
sql: groupcheck_table = "radgroupcheck"
sql: groupreply_table = "radgroupreply"
sql: usergroup_table = "usergroup"
sql: nas_table = "nas"
sql: dict_table = "dictionary"
sql: sqltrace = yes
sql: sqltracefile = "/var/log/freeradius/sqltrace.sql"
sql: readclients = no
sql: deletestalesessions = no
sql: num_sql_socks = 5
sql: sql_user_name = "%{User-Name}"
sql: default_user_profile = ""
sql: query_on_not_found = no
sql: authorize_check_query = "SELECT portal_uid, rg_ip, Attribute,
video_pin, op FROM rg_info WHERE STRCMP(rg_ip
, '%{Framed-IP-Address}') = 0 ORDER BY portal_uid"
sql: authorize_reply_query = ""
sql: authorize_group_check_query = ""
sql: authorize_group_reply_query = ""
sql: accounting_onoff_query = ""
sql: accounting_update_query = ""
sql: accounting_update_query_alt = ""
sql: accounting_start_query = "INSERT INTO video_acct (RG_IP, RG_MAC,
SERVICE, MOVIE_CHANNEL, EVENT, DATE_TIME)
values ('%{Framed-IP-Address}', '%{Calling-Station-Id}', 'VoD',
'%{Class}', '%{State}', now())"
sql: accounting_start_query_alt = ""
sql: accounting_stop_query = "INSERT INTO video_acct (RG_IP, RG_MAC,
SERVICE, MOVIE_CHANNEL, EVENT, DATE_TIME)
values ('%{Framed-IP-Address}', '%{Calling-Station-Id}', 'TV',
'%{Class}', '%{State}', now())"
sql: accounting_stop_query_alt = ""
sql: group_membership_query = ""
sql: connect_failure_retry_delay = 60
sql: simul_count_query = ""
sql: simul_verify_query = ""
sql: postauth_table = "radpostauth"
sql: postauth_query = ""
sql: safe-characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
rlm_sql (sql2): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and
linked
rlm_sql (sql2): Attempting to connect to [EMAIL PROTECTED]:/radius
rlm_sql (sql2): starting 0
rlm_sql (sql2): Attempting to connect rlm_sql_mysql #0
rlm_sql_mysql: Starting connect to MySQL server for #0
rlm_sql (sql2): Connected new DB handle, #0
rlm_sql (sql2): starting 1
rlm_sql (sql2): Attempting to connect rlm_sql_mysql #1
rlm_sql_mysql: Starting connect to MySQL server for #1
rlm_sql (sql2): Connected new DB handle, #1
rlm_sql (sql2): starting 2
rlm_sql (sql2): Attempting to connect rlm_sql_mysql #2
rlm_sql_mysql: Starting connect to MySQL server for #2
rlm_sql (sql2): Connected new DB handle, #2
rlm_sql (sql2): starting 3
rlm_sql (sql2): Attempting to connect rlm_sql_mysql #3
rlm_sql_mysql: Starting connect to MySQL server for #3
rlm_sql (sql2): Connected new DB handle, #3
rlm_sql (sql2): starting 4
rlm_sql (sql2): Attempting to connect rlm_sql_mysql #4
rlm_sql_mysql: Starting connect to MySQL server for #4
rlm_sql (sql2): Connected new DB handle, #4
Module: Instantiated sql (sql2)
sql: driver = "rlm_sql_mysql"
sql: server = "localhost"
sql: port = ""
sql: login = "xxx"
sql: password = "xxxxx"
sql: radius_db = "radius"
sql: acct_table = "voice_acct"
sql: acct_table2 = "radacct"
sql: authcheck_table = "voice_auth_check"
sql: authreply_table = "radreply"
sql: groupcheck_table = "radgroupcheck"
sql: groupreply_table = "radgroupreply"
sql: usergroup_table = "voice_usergroup"
sql: nas_table = "nas"
sql: dict_table = "dictionary"
sql: sqltrace = yes
sql: sqltracefile = "/var/log/freeradius/sqltrace.sql"
sql: readclients = no
sql: deletestalesessions = no
sql: num_sql_socks = 5
sql: sql_user_name = "%{User-Name}"
sql: default_user_profile = ""
sql: query_on_not_found = no
sql: authorize_check_query = "SELECT id, UserName, Attribute, Value, op
FROM voice_auth_check WHERE STRCMP(UserName, '%{SQL-User-Name}') = 0
ORDER BY id"
sql: authorize_reply_query = ""
sql: authorize_group_check_query = ""
sql: authorize_group_reply_query = ""
sql: accounting_onoff_query = ""
sql: accounting_update_query = ""
sql: accounting_update_query_alt = ""
sql: accounting_start_query = "INSERT INTO voice_acct (USERNAME,
CALLING_STATION, CALLED_STATION, START_DATE_TIME, STOP_DATE_TIME,
DURATION_SEC, ACCT_SESSION_ID, STATUS) VALUES
('%{SQL-User-Name}','%{Calling-Station-Id}','%{Called-Station-Id}',now()
,'','%{Acct-Session-Time}', '%{Acct-Session-Id}', 1)"
sql: accounting_start_query_alt = ""
sql: accounting_stop_query = "UPDATE voice_acct SET STATUS = 2,???????
STOP_DATE_TIME = now(),??????? DURATION_SEC =
'%{Acct-Session-Time}'?????? WHERE USERNAME =
'%{SQL-User-Name}'?????? AND STATUS = 1?????? AND
ACCT_SESSION_ID = '%{Acct-Session-Id}'"
sql: accounting_stop_query_alt = ""
sql: group_membership_query = ""
sql: connect_failure_retry_delay = 60
sql: simul_count_query = ""
sql: simul_verify_query = ""
sql: postauth_table = "radpostauth"
sql: postauth_query = ""
sql: safe-characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
rlm_sql (sql3): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and
linked
rlm_sql (sql3): Attempting to connect to [EMAIL PROTECTED]:/radius
rlm_sql (sql3): starting 0
rlm_sql (sql3): Attempting to connect rlm_sql_mysql #0
rlm_sql_mysql: Starting connect to MySQL server for #0
rlm_sql (sql3): Connected new DB handle, #0
rlm_sql (sql3): starting 1
rlm_sql (sql3): Attempting to connect rlm_sql_mysql #1
rlm_sql_mysql: Starting connect to MySQL server for #1
rlm_sql (sql3): Connected new DB handle, #1
rlm_sql (sql3): starting 2
rlm_sql (sql3): Attempting to connect rlm_sql_mysql #2
rlm_sql_mysql: Starting connect to MySQL server for #2
rlm_sql (sql3): Connected new DB handle, #2
rlm_sql (sql3): starting 3
rlm_sql (sql3): Attempting to connect rlm_sql_mysql #3
rlm_sql_mysql: Starting connect to MySQL server for #3
rlm_sql (sql3): Connected new DB handle, #3
rlm_sql (sql3): starting 4
rlm_sql (sql3): Attempting to connect rlm_sql_mysql #4
rlm_sql_mysql: Starting connect to MySQL server for #4
rlm_sql (sql3): Connected new DB handle, #4
Module: Instantiated sql (sql3)
sql: driver = "rlm_sql_mysql"
sql: server = "localhost"
sql: port = ""
sql: login = "xxxx"
sql: password = "xxxx"
sql: radius_db = "radius"
sql: acct_table = "radacct"
sql: acct_table2 = "radacct"
sql: authcheck_table = "radcheck"
sql: authreply_table = "radreply"
sql: groupcheck_table = "radgroupcheck"
sql: groupreply_table = "radgroupreply"
sql: usergroup_table = "usergroup"
sql: nas_table = "nas"
sql: dict_table = "dictionary"
sql: sqltrace = yes
sql: sqltracefile = "/var/log/freeradius/sqltrace.sql"
sql: readclients = no
sql: deletestalesessions = no
sql: num_sql_socks = 5
sql: sql_user_name = ""
sql: default_user_profile = ""
sql: query_on_not_found = no
sql: authorize_check_query = ""
sql: authorize_reply_query = ""
sql: authorize_group_check_query = ""
sql: authorize_group_reply_query = ""
sql: accounting_onoff_query = ""
sql: accounting_update_query = ""
sql: accounting_update_query_alt = ""
sql: accounting_start_query = "UPDATE rg_info SET rg_ip =
'%{Framed-IP-Address}', last_update = UNIX_TIMESTAMP(now()) WHERE rg_mac
= '%{Calling-Station-Id}'"
sql: accounting_start_query_alt = ""
sql: accounting_stop_query = "UPDATE rg_info SET rg_ip = '%{Class}',
last_update = UNIX_TIMESTAMP(now()) WHERE rg_mac =
'%{Calling-Station-Id}'"
sql: accounting_stop_query_alt = ""
sql: group_membership_query = ""
sql: connect_failure_retry_delay = 60
sql: simul_count_query = ""
sql: simul_verify_query = ""
sql: postauth_table = "radpostauth"
sql: postauth_query = ""
sql: safe-characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
rlm_sql (sql4): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and
linked
rlm_sql (sql4): Attempting to connect to [EMAIL PROTECTED]:/radius
rlm_sql (sql4): starting 0
rlm_sql (sql4): Attempting to connect rlm_sql_mysql #0
rlm_sql_mysql: Starting connect to MySQL server for #0
rlm_sql (sql4): Connected new DB handle, #0
rlm_sql (sql4): starting 1
rlm_sql (sql4): Attempting to connect rlm_sql_mysql #1
rlm_sql_mysql: Starting connect to MySQL server for #1
rlm_sql (sql4): Connected new DB handle, #1
rlm_sql (sql4): starting 2
rlm_sql (sql4): Attempting to connect rlm_sql_mysql #2
rlm_sql_mysql: Starting connect to MySQL server for #2
rlm_sql (sql4): Connected new DB handle, #2
rlm_sql (sql4): starting 3
rlm_sql (sql4): Attempting to connect rlm_sql_mysql #3
rlm_sql_mysql: Starting connect to MySQL server for #3
rlm_sql (sql4): Connected new DB handle, #3
rlm_sql (sql4): starting 4
rlm_sql (sql4): Attempting to connect rlm_sql_mysql #4
rlm_sql_mysql: Starting connect to MySQL server for #4
rlm_sql (sql4): Connected new DB handle, #4
Module: Instantiated sql (sql4)
sql: driver = "rlm_sql_mysql"
sql: server = "localhost"
sql: port = ""
sql: login = "xxxx"
sql: password = "xxxxx"
sql: radius_db = "radius"
sql: acct_table = "radacct"
sql: acct_table2 = "radacct"
sql: authcheck_table = "users_management"
sql: authreply_table = "users_management"
sql: groupcheck_table = "radgroupcheck"
sql: groupreply_table = "radgroupreply"
sql: usergroup_table = "usergroup"
sql: nas_table = "nas"
sql: dict_table = "dictionary"
sql: sqltrace = yes
sql: sqltracefile = "/var/log/freeradius/sqltrace.sql"
sql: readclients = no
sql: deletestalesessions = no
sql: num_sql_socks = 5
sql: sql_user_name = "%{User-Name}"
sql: default_user_profile = ""
sql: query_on_not_found = no
sql: authorize_check_query = "SELECT id, UserName, Check_Attribute,
Check_Value, Check_op FROM users_management WHERE STRCMP(UserName,
'%{SQL-User-Name}') = 0 ORDER BY id"
sql: authorize_reply_query = "SELECT id, UserName, Reply_Attribute,
Reply_Value, Reply_op FROM users_management WHERE STRCMP(UserName,
'%{SQL-User-Name}') = 0 ORDER BY id"
sql: authorize_group_check_query = ""
sql: authorize_group_reply_query = ""
sql: accounting_onoff_query = ""
sql: accounting_update_query = ""
sql: accounting_update_query_alt = ""
sql: accounting_start_query = ""
sql: accounting_start_query_alt = ""
sql: accounting_stop_query = ""
sql: accounting_stop_query_alt = ""
sql: group_membership_query = ""
sql: connect_failure_retry_delay = 60
sql: simul_count_query = ""
sql: simul_verify_query = ""
sql: postauth_table = "radpostauth"
sql: postauth_query = ""
sql: safe-characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
rlm_sql (sql5): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and
linked
rlm_sql (sql5): Attempting to connect to [EMAIL PROTECTED]:/radius
rlm_sql (sql5): starting 0
rlm_sql (sql5): Attempting to connect rlm_sql_mysql #0
rlm_sql_mysql: Starting connect to MySQL server for #0
rlm_sql (sql5): Connected new DB handle, #0
rlm_sql (sql5): starting 1
rlm_sql (sql5): Attempting to connect rlm_sql_mysql #1
rlm_sql_mysql: Starting connect to MySQL server for #1
rlm_sql (sql5): Connected new DB handle, #1
rlm_sql (sql5): starting 2
rlm_sql (sql5): Attempting to connect rlm_sql_mysql #2
rlm_sql_mysql: Starting connect to MySQL server for #2
rlm_sql (sql5): Connected new DB handle, #2
rlm_sql (sql5): starting 3
rlm_sql (sql5): Attempting to connect rlm_sql_mysql #3
rlm_sql_mysql: Starting connect to MySQL server for #3
rlm_sql (sql5): Connected new DB handle, #3
rlm_sql (sql5): starting 4
rlm_sql (sql5): Attempting to connect rlm_sql_mysql #4
rlm_sql_mysql: Starting connect to MySQL server for #4
rlm_sql (sql5): Connected new DB handle, #4
Module: Instantiated sql (sql5)
Module: Loaded Acct-Unique-Session-Id
acct_unique: key = "User-Name, Acct-Session-Id, NAS-IP-Address,
Client-IP-Address, NAS-Port-Id"
Module: Instantiated acct_unique (acct_unique)
detail: detailfile = "/var/log/freeradius/radacct/detail-%Y%m%d"
detail: detailperm = 384
detail: dirperm = 493
detail: locking = no
Module: Instantiated detail (detail)
Module: Loaded radutmp
radutmp: filename = "/var/log/freeradius/radutmp"
radutmp: username = "%{User-Name}"
radutmp: case_sensitive = yes
radutmp: check_with_nas = yes
radutmp: perm = 384
radutmp: callerid = yes
Module: Instantiated radutmp (radutmp)
detail: detailfile = "/var/log/freeradius/radacct/reply-detail-%Y%m%d"
detail: detailperm = 384
detail: dirperm = 493
detail: locking = no
Module: Instantiated detail (reply_log)
Listening on authentication *:1812
Listening on accounting *:1813
Listening on proxy *:1814
Ready to process requests.
rad_recv: Access-Request packet from host 212.61.71.182:32947, id=32,
length=96
User-Name = "video_user"
NAS-Identifier = "Video_Authentication"
NAS-IP-Address = 212.61.71.182
Framed-IP-Address = 131.155.192.235
CHAP-Password = 0x0109f1abeb4efacf60224ec564005fd300
CHAP-Challenge = 0x313233313534383433
Processing the authorize section of radiusd.conf
modcall: entering group authorize for request 0
modcall[authorize]: module "preprocess" returns ok for request 0
radius_xlat: '/var/log/freeradius/radacct/auth-detail-20040909'
rlm_detail: /var/log/freeradius/radacct/auth-detail-%Y%m%d expands to
/var/log/freeradius/radacct/auth-detail-20040909
modcall[authorize]: module "auth_log" returns ok for request 0
rlm_chap: Setting 'Auth-Type := CHAP'
modcall[authorize]: module "chap" returns ok for request 0
rlm_eap: No EAP-Message, not doing EAP
modcall[authorize]: module "eap" returns noop for request 0
rlm_realm: No '@' in User-Name = "video_user", looking up realm NULL
rlm_realm: No such realm "NULL"
modcall[authorize]: module "suffix" returns noop for request 0
users: Matched DEFAULT at 73
modcall[authorize]: module "files" returns ok for request 0
modcall[authorize]: module "mschap" returns noop for request 0
modcall: group authorize returns ok for request 0
Processing the authorize section of radiusd.conf
modcall: entering group Autz-Type for request 0
radius_xlat: 'video_user'
rlm_sql (sql2): sql_set_user escaped user --> 'video_user'
radius_xlat: 'SELECT portal_uid, rg_ip, Attribute, video_pin, op FROM
rg_info WHERE STRCMP(rg_ip, '131.155.192.235') = 0 ORDER BY portal_uid'
rlm_sql (sql2): Reserving sql socket id: 4
rlm_sql_mysql: query: SELECT portal_uid, rg_ip, Attribute, video_pin,
op FROM rg_info WHERE STRCMP(rg_ip, '131.155.192.235') = 0 ORDER BY
portal_uid
radius_xlat: ''
radius_xlat: ''
radius_xlat: ''
rlm_sql (sql2): Released sql socket id: 4
modcall[authorize]: module "sql2" returns ok for request 0
modcall: group Autz-Type returns ok for request 0
rad_check_password: Found Auth-Type CHAP
auth: type "CHAP"
Processing the authenticate section of radiusd.conf
modcall: entering group Auth-Type for request 0
rlm_chap: login attempt by "video_user" with CHAP password
rlm_chap: Using clear text password 1111 for user video_user
authentication.
rlm_chap: chap user video_user authenticated succesfully
modcall[authenticate]: module "chap" returns ok for request 0
modcall: group Auth-Type returns ok for request 0
Login OK: [video_user/<CHAP-Password>] (from client lyngsat port 0)
Processing the post-auth section of radiusd.conf
modcall: entering group post-auth for request 0
radius_xlat: '/var/log/freeradius/radacct/reply-detail-20040909'
rlm_detail: /var/log/freeradius/radacct/reply-detail-%Y%m%d expands to
/var/log/freeradius/radacct/reply-detail-20040909
modcall[post-auth]: module "reply_log" returns ok for request 0
modcall: group post-auth returns ok for request 0
Sending Access-Accept of id 32 to 212.61.71.182:32947
Finished request 0
Going to the next request
--- Walking the entire request list ---
Waking up in 6 seconds...
rad_recv: Accounting-Request packet from host 212.61.71.182:32947,
id=78, length=92
NAS-Identifier = "Video_Accounting"
Framed-IP-Address = 131.155.192.235
Calling-Station-Id = "00:00:00:00:00:00"
Acct-Status-Type = Start
/usr/lib (Unknown Type 779252325)
Processing the preacct section of radiusd.conf
modcall: entering group preacct for request 1
modcall[preacct]: module "preprocess" returns noop for request 1
rlm_realm: Proxy reply, or no User-Name. Ignoring.
modcall[preacct]: module "suffix" returns noop for request 1
acct_users: Matched DEFAULT at 25
modcall[preacct]: module "files" returns ok for request 1
modcall: group preacct returns ok for request 1
Processing the accounting section of radiusd.conf
modcall: entering group Acct-Type for request 1
radius_xlat: ''
radius_xlat: 'INSERT INTO video_acct (RG_IP, RG_MAC, SERVICE,
MOVIE_CHANNEL, EVENT, DATE_TIME) values ('131.155.192.235',
'00:00:00:00:00:00', 'VoD', '', '', now())'
radius_xlat: '/var/log/freeradius/sqltrace.sql'
rlm_sql (sql2): Reserving sql socket id: 3
rlm_sql_mysql: query: INSERT INTO video_acct (RG_IP, RG_MAC, SERVICE,
MOVIE_CHANNEL, EVENT, DATE_TIME) values ('131.155.192.235',
'00:00:00:00:00:00', 'VoD', '', '', now())
rlm_sql (sql2): Released sql socket id: 3
modcall[accounting]: module "sql2" returns ok for request 1
modcall: group Acct-Type returns ok for request 1
Sending Accounting-Response of id 78 to 212.61.71.182:32947
Finished request 1
Going to the next request
Cleaning up request 1 ID 78 with timestamp 414074f2
Waking up in 6 seconds...
-----Original Message-----
From: Alan DeKok [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 09, 2004 3:20 PM
To: [EMAIL PROTECTED]
Subject: Re: Class attribute
"Lopez, A." <[EMAIL PROTECTED]> wrote:
> I have redefined the 'Class' attribute as a string in the
> /etc/freeradius/dictionary file so that the predefined attribute
> (octets) is overridden, adding the following line:
Why?
> ATTRIBUTE Class 25 string
>
> However, it seems that this change it is not taken into account and
when
> I receive the RADIUS packet it says:
>
> /usr/lib (Unknown Type 779252325)
I doubt very much that's the exact error message produced by editing
the dictionary file.
Could you please post the REAL error, from the debug log, or even
the whole debug log?
Alan DeKok.
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
