dearl list all..don't know how to thanks to you to reply my email and answer my
quest. and sorry for to much question.:Di've run this commandradiusd -X but it
return this
The program 'radiusd' can be found in the following packages: *
radiusd-livingston * yardradius * xtradiusTry: apt-get install <selected package
i read freeradius documentation to do debug in ubuntu, and i try this command
but i freeradius -X and return this messagefreeradius -XStarting - reading
configuration files ...reread_config: reading radiusd.confConfig: including
file: /etc/freeradius/proxy.confConfig: including file:
/etc/freeradius/clients.confConfig: including file:
/etc/freeradius/snmp.confConfig: including file:
/etc/freeradius/eap.confConfig: 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 = no main:
log_auth_badpass = no main: log_auth_goodpass = no 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 = no proxy: wake_all_if_all_dead =
no security: max_attributes = 200 security: reject_delay = 1 security:
status_server = no main: debug_level = 0read_config_files: reading
dictionaryread_config_files: reading naslistUsing deprecated naslist file.
Support for this will go away soon.read_config_files: reading clients
this message after i comment out this inf clients.conf#client 127.0.0.1 {#
secret = passwordradius# shortname = localhost#
nastype = other # localhost isn't usually a NAS...
# }
but if i uncomment that then i run freeradius -X it return this message main:
debug_level = 0read_config_files: reading dictionaryread_config_files:
reading naslistUsing deprecated naslist file. Support for this will go away
soon.read_config_files: reading clientsread_config_files: reading
realmsradiusd: entering modules setupModule: Library search path is
/usr/lib/freeradiusModule: Loaded exec exec: wait = yes exec: program =
"(null)" exec: input_pairs = "request" exec: output_pairs = "(null)" exec:
packet_type = "(null)"rlm_exec: Wait=yes but no output defined. Did you mean
output=none?Module: Instantiated exec (exec)Module: Loaded exprModule:
Instantiated expr (expr)Module: Loaded PAP pap: encryption_scheme =
"crypt" pap: auto_header = yesModule: Instantiated pap (pap)Module: Loaded
CHAPModule: 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: 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 = 600Module: 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 = norlm_eap:
Loaded and initialized type md5rlm_eap: Loaded and initialized type leap gtc:
challenge = "Password: " gtc: auth_type = "PAP"rlm_eap: Loaded and initialized
type gtc mschapv2: with_ntdomain_hack = norlm_eap: Loaded and initialized type
mschapv2Module: 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 preprocess: with_alvarion_vsa_hack = noModule:
Instantiated preprocess (preprocess)Module: Loaded realm realm: format =
"suffix" realm: delimiter = "@" realm: ignore_default = no realm: ignore_null =
noModule: Instantiated realm (suffix)Module: Loaded SQL sql: driver =
"rlm_sql_mysql" sql: server = "localhost" sql: port = "" sql: login =
"root" sql: password = "jOeLya" sql: radius_db = "radius" sql: nas_table =
"nas" sql: sqltrace = no sql: sqltracefile =
"/var/log/freeradius/sqltrace.sql" sql: readclients = yes 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-Name}' ORDER B
Y id" sql:
authorize_reply_query = "SELECT id, UserName, Attribute, Value, op
FROM
radreply WHERE Username = '%{SQL-User-Name}' ORDER B
Y
id" sql: authorize_group_check_query = "SELECT
radgroupcheck.id,radgroupcheck.Group
Name,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM
radgroup
check,usergroup WHERE usergroup.Username = '%{SQL-User-Name}' AND
usergroup.Grou
pName = radgroupcheck.GroupName ORDER BY radgroupcheck.id" sql:
authorize_group_reply_query = "SELECT radgroupreply.id,radgroupreply.Group
Name,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM
radgroup
reply,usergroup WHERE usergroup.Username = '%{SQL-User-Name}' AND
usergroup.Grou
pName =
radgroupreply.GroupName ORDER BY radgroupreply.id" sql: accounting_onoff_query
= "UPDATE radacct SET AcctStopTime='%S', AcctSessio
nTime=unix_timestamp('%S') -
unix_timestamp(AcctStartTime), AcctTerminateCause='
%{Acct-Terminate-Cause}',
AcctStopDelay = '%{Acct-Delay-Time}' WHERE AcctSession
Time=0 AND AcctStopTime=0
AND NASIPAddress= '%{NAS-IP-Address}' AND AcctStartTim
e <= '%S'" sql:
accounting_update_query
= "UPDATE radacct SET FramedIPAddress =
'%{Framed-IP-Address}',
AcctSessionTime = '%{Acct-Session-Time}',
AcctInputOctets =
'%{Acct-Input-Octets}', AcctOutputOctets = '%{
Acct-Output-Octets}'
WHERE AcctSessionId = '%{Acct-Session-Id}'
AND UserName =
'%{SQL-User-Name}' AND NASIPAddress= '%{NAS-IP-Addr
ess}'" sql: accounting_update_query_alt = "INSERT into radacct
(AcctSessionId, AcctUni
queId, UserName, Realm, NASIPAddress, NASPortId,
NASPortType, AcctStartTime, Acc
tSessionTime, AcctAuthentic, ConnectInfo_start,
AcctInputOctets, AcctOutputOctet
s, CalledStationId, CallingStationId,
ServiceType, FramedProtocol, FramedIPAddre
ss, AcctStartDelay)
values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%
{SQL-User-Name}', '%{Realm}',
'%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Ty
pe}', DATE_SUB('%S',INTERVAL
(%{Acct-Session-Time:-0} + %{Acct-Delay-Time:-0}) S
ECOND),
'%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{Acct-Input-Octets}',
'%{Acct-Output-Octets}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Se
rvice-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0')" sql:
accounting_start_query = "INSERT into radacct
(AcctSessionId, AcctUniqueId
, UserName, Realm, NASIPAddress, NASPortId,
NASPortType, AcctStartTime, AcctStop
Time, AcctSessionTime, AcctAuthentic,
ConnectInfo_start, ConnectInfo_stop, AcctI
nputOctets, AcctOutputOctets,
CalledStationId, CallingStationId, AcctTerminateCa
use, 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}', '%S', '0', '
0',
'%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}'
,
'%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Frame
d-IP-Address}', '%{Acct-Delay-Time}', '0')" sql: accounting_start_query_alt =
"UPDATE radacct SET AcctStartTime = '%S', Acc
tStartDelay = '%{Acct-Delay-Time}', ConnectInfo_start =
'%{Connect-Info}' WHERE
AcctSessionId = '%{Acct-Session-Id}' AND UserName =
'%{SQL-User-Name}' AND NASIP
Address = '%{NAS-IP-Address}'" sql:
accounting_stop_query = "UPDATE radacct SET AcctStopTime = '%S', AcctSessi
onTime
= '%{Acct-Session-Time}', AcctInputOctets = '%{Acct-Input-Octets}', AcctO
utputOctets = '%{Acct-Output-Octets}', AcctTerminateCause =
'%{Acct-Terminate-Ca
use}', AcctStopDelay =
'%{Acct-Delay-Time}', ConnectInfo_stop = '%{Connect-Info}
' WHERE AcctSessionId =
'%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' A
ND NASIPAddress =
'%{NAS-IP-Address}'" sql: accounting_stop_query_alt = "INSERT into radacct
(AcctSessionId, AcctUniqu
eId, UserName, Realm, NASIPAddress, NASPortId,
NASPortType, AcctStartTime, AcctS
topTime, AcctSessionTime, AcctAuthentic,
ConnectInfo_start,
ConnectInfo_stop, Ac
ctInputOctets, AcctOutputOctets, CalledStationId,
CallingStationId, AcctTerminat
eCause, ServiceType, FramedProtocol,
FramedIPAddress, AcctStartDelay, AcctStopDe
lay) 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-Inpu
t-Octets}',
'%{Acct-Output-Octets}', '%{Called-Station-Id}', '%{Calling-Station-
Id}',
'%{Acct-Terminate-Cause}', '%{Service-Type}', '%{Framed-Protocol}', '%{Fra
med-IP-Address}', '0', '%{Acct-Delay-Time}')" 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, NASIPAddr
ess, NASPortId, FramedIPAddress,
CallingStationId, FramedProtocol FROM radacct W
HERE UserName='%{SQL-User-Name}'
AND AcctStopTime = 0" sql: postauth_query = "INSERT into radpostauth (id, user,
pass, reply, date) va
lues ('', '%{User-Name}', '%{User-Password:-Chap-Password}',
'%{reply:Packet-Typ
e}',
NOW())" sql: safe-characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ01
23456789.-_: /"rlm_sql
(sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linkedrlm_sql
(sql): Attempting to connect to r...@localhost:/radiusrlm_sql (sql): starting
0rlm_sql (sql): Attempting to connect rlm_sql_mysql #0rlm_sql_mysql: Starting
connect to MySQL server for #0rlm_sql (sql): Connected new DB handle, #0rlm_sql
(sql): starting 1rlm_sql (sql): Attempting to connect rlm_sql_mysql
#1rlm_sql_mysql: Starting connect to MySQL server for #1rlm_sql (sql):
Connected new DB handle, #1rlm_sql (sql): starting 2rlm_sql (sql): Attempting
to connect rlm_sql_mysql #2rlm_sql_mysql: Starting connect to MySQL server for
#2rlm_sql (sql): Connected new DB handle, #2rlm_sql (sql): starting 3rlm_sql
(sql): Attempting to connect rlm_sql_mysql
#3rlm_sql_mysql: Starting connect to MySQL server for #3rlm_sql (sql):
Connected new DB handle, #3rlm_sql (sql): starting 4rlm_sql (sql): Attempting
to connect rlm_sql_mysql #4rlm_sql_mysql: Starting connect to MySQL server for
#4rlm_sql (sql): Connected new DB handle, #4rlm_sql (sql): -
generate_sql_clientsrlm_sql (sql): Query: SELECT * FROM nasrlm_sql (sql):
Reserving sql socket id: 4rlm_sql (sql): Read entry
nasname=127.0.0.1,shortname=localhost,secret=passwordr
adiusrlm_sql (sql): Adding
client 127.0.0.1 (localhost) to clients listrlm_sql (sql): Released sql socket
id: 4Module: Instantiated sql (sql)Module: Loaded
Acct-Unique-Session-Id acct_unique: key = "User-Name, Acct-Session-Id,
NAS-IP-Address, Client-IP-Addre
ss,
NAS-Port"Module: Instantiated acct_unique (acct_unique)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 detail detail: detailfile =
"/var/log/freeradius/radacct/%{Client-IP-Address}/detail-%
Y%m%d" detail:
detailperm = 384 detail: dirperm = 493 detail: locking = noModule: 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 = yesModule: Instantiated radutmp (radutmp)Listening on authentication
*:1812Listening on accounting *:1813Ready to process requests.
whats really wrong...still cannot read NAS from nas table on radius..was it?
really apreciate your answer.
Nizar
--- On Thu, 4/16/09, Ivan Kalik <[email protected]> wrote:
From: Ivan Kalik <[email protected]>
Subject: RE: NAS table
To: "'FreeRadius users mailing list'" <[email protected]>
Date: Thursday, April 16, 2009, 4:02 AM
this is result of
freeradius -X
reread_config: reading
radiusd.conf
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/eap.conf
Config: including file:
/etc/freeradius/sql.conf
It's
not. It's a result of HUP. Now post what you were told.
Ivan
Kalik
Kalik
Informatika ISP
-----Inline Attachment Follows-----
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
