<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;"><div>so thak you ivan...really apreciate for your answer</div>i just install it using apt-get install command ubuntu 7.10. so i'll upgrade to wich version??which version is better..??<div><br><br><br>--- On <b>Sat, 4/18/09, Ivan Kalik <i><tnt@kalik.net></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Ivan Kalik <tnt@kalik.net><br>Subject: RE: NAS table<br>To: "'FreeRadius users mailing list'" <freeradius-users@lists.freeradius.org><br>Date: Saturday, April 18, 2009, 3:06 AM<br><br><div id="yiv1920911167">
<div><span class="640450120-17042009"><font face="Arial" color="#0000ff" size="2">Upgrade. That's a very old server version. In 1.x you had to have an
entry in clients.conf for sql to read clients. And something is wrong with your
clients.conf since debug stops when server tries to read it.</font></span></div>
<div><span class="640450120-17042009"><font face="Arial" color="#0000ff" size="2"></font></span> </div>
<div><span class="640450120-17042009"><font face="Arial" color="#0000ff" size="2">Ivan
Kalik</font></span></div>
<div><span class="640450120-17042009"><font face="Arial" color="#0000ff" size="2">Kalik
Informatika ISP</font></span></div>
<blockquote dir="ltr" style="MARGIN-RIGHT:0px;">
<div></div>
<div class="OutlookMessageHeader" lang="en-us" dir="ltr" align="left"><font face="Tahoma" size="2">-----Original Message-----<br><b>From:</b>
freeradius-users-bounces+tnt=kalik.net@lists.freeradius.org
[mailto:freeradius-users-bounces+tnt=kalik.net@lists.freeradius.org] <b>On
Behalf Of </b>Nizar Zulmi<br><b>Sent:</b> 16 April 2009 13:25<br><b>To:</b>
FreeRadius users mailing list<br><b>Subject:</b> RE: NAS
table<br><br></font></div>
<table cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr>
<td valign="top">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.:D
<div>i've run this command</div>
<div>radiusd -X </div>
<div>but it return this </div>
<div><br>
<div>The program 'radiusd' can be found in the following packages:</div>
<div> * radiusd-livingston</div>
<div> * yardradius</div>
<div> * xtradius</div>
<div>Try: apt-get install <selected package</div><br></div>
<div>i read freeradius documentation to do debug in ubuntu, and i try
this command but i </div>
<div>freeradius -X and return this message</div>
<div>
<div>freeradius -X</div>
<div>Starting - reading configuration files ...</div>
<div>reread_config: reading radiusd.conf</div>
<div>Config: including file: /etc/freeradius/proxy.conf</div>
<div>Config: including file: /etc/freeradius/clients.conf</div>
<div>Config: including file: /etc/freeradius/snmp.conf</div>
<div>Config: including file: /etc/freeradius/eap.conf</div>
<div>Config: including file: /etc/freeradius/sql.conf</div>
<div> main: prefix = "/usr"</div>
<div> main: localstatedir = "/var"</div>
<div> main: logdir = "/var/log/freeradius"</div>
<div> main: libdir = "/usr/lib/freeradius"</div>
<div> main: radacctdir = "/var/log/freeradius/radacct"</div>
<div> main: hostname_lookups = no</div>
<div> main: max_request_time = 30</div>
<div> main: cleanup_delay = 5</div>
<div> main: max_requests = 1024</div>
<div> main: delete_blocked_requests = 0</div>
<div> main: port = 0</div>
<div> main: allow_core_dumps = no</div>
<div> main: log_stripped_names = no</div>
<div> main: log_file = "/var/log/freeradius/radius.log"</div>
<div> main: log_auth = no</div>
<div> main: log_auth_badpass = no</div>
<div> main: log_auth_goodpass = no</div>
<div> main: pidfile = "/var/run/freeradius/freeradius.pid"</div>
<div> main: user = "freerad"</div>
<div> main: group = "freerad"</div>
<div> main: usercollide = no</div>
<div> main: lower_user = "no"</div>
<div> main: lower_pass = "no"</div>
<div> main: nospace_user = "no"</div>
<div> main: nospace_pass = "no"</div>
<div> main: checkrad = "/usr/sbin/checkrad"</div>
<div> main: proxy_requests = yes</div>
<div> proxy: retry_delay = 5</div>
<div> proxy: retry_count = 3</div>
<div> proxy: synchronous = no</div>
<div> proxy: default_fallback = yes</div>
<div> proxy: dead_time = 120</div>
<div> proxy: post_proxy_authorize = no</div>
<div> proxy: wake_all_if_all_dead = no</div>
<div> security: max_attributes = 200</div>
<div> security: reject_delay = 1</div>
<div> security: status_server = no</div>
<div> main: debug_level = 0</div>
<div>read_config_files: reading dictionary</div>
<div>read_config_files: reading naslist</div>
<div>Using deprecated naslist file. Support for this will go away
soon.</div>
<div>read_config_files: reading clients</div>
<div><br></div>
<div>this message after i comment out this inf clients.conf</div>
<div>
<div>#client 127.0.0.1 {</div>
<div>
<div># secret
= passwordradius</div>
<div>
<div># shortname =
localhost</div>
<div># nastype = other
# localhost isn't usually a NAS...<br></div>
<div># }</div></div>
<div><br></div></div>
<div>but if i uncomment that </div>
<div>then i run freeradius -X it return this message</div>
<div>
<div> main: debug_level = 0</div>
<div>read_config_files: reading dictionary</div>
<div>read_config_files: reading naslist</div>
<div>Using deprecated naslist file. Support for this will go away
soon.</div>
<div>read_config_files: reading clients</div>
<div>read_config_files: reading realms</div>
<div>radiusd: entering modules setup</div>
<div>Module: Library search path is /usr/lib/freeradius</div>
<div>Module: Loaded exec</div>
<div> exec: wait = yes</div>
<div> exec: program = "(null)"</div>
<div> exec: input_pairs = "request"</div>
<div> exec: output_pairs = "(null)"</div>
<div> exec: packet_type = "(null)"</div>
<div>rlm_exec: Wait=yes but no output defined. Did you mean
output=none?</div>
<div>Module: Instantiated exec (exec)</div>
<div>Module: Loaded expr</div>
<div>Module: Instantiated expr (expr)</div>
<div>Module: Loaded PAP</div>
<div> pap: encryption_scheme = "crypt"</div>
<div> pap: auto_header = yes</div>
<div>Module: Instantiated pap (pap)</div>
<div>Module: Loaded CHAP</div>
<div>Module: Instantiated chap (chap)</div>
<div>Module: Loaded MS-CHAP</div>
<div> mschap: use_mppe = yes</div>
<div> mschap: require_encryption = no</div>
<div> mschap: require_strong = no</div>
<div> mschap: with_ntdomain_hack = no</div>
<div> mschap: passwd = "(null)"</div>
<div> mschap: ntlm_auth = "(null)"</div>
<div>Module: Instantiated mschap (mschap)</div>
<div>Module: Loaded System</div>
<div> unix: cache = no</div>
<div> unix: passwd = "(null)"</div>
<div> unix: shadow = "/etc/shadow"</div>
<div> unix: group = "(null)"</div>
<div> unix: radwtmp = "/var/log/freeradius/radwtmp"</div>
<div> unix: usegroup = no</div>
<div> unix: cache_reload = 600</div>
<div>Module: Instantiated unix (unix)</div>
<div>Module: Loaded eap</div>
<div> eap: default_eap_type = "md5"</div>
<div> eap: timer_expire = 60</div>
<div> eap: ignore_unknown_eap_types = no</div>
<div> eap: cisco_accounting_username_bug = no</div>
<div>rlm_eap: Loaded and initialized type md5</div>
<div>rlm_eap: Loaded and initialized type leap</div>
<div> gtc: challenge = "Password: "</div>
<div> gtc: auth_type = "PAP"</div>
<div>rlm_eap: Loaded and initialized type gtc</div>
<div> mschapv2: with_ntdomain_hack = no</div>
<div>rlm_eap: Loaded and initialized type mschapv2</div>
<div>Module: Instantiated eap (eap)</div>
<div>Module: Loaded preprocess</div>
<div> preprocess: huntgroups = "/etc/freeradius/huntgroups"</div>
<div> preprocess: hints = "/etc/freeradius/hints"</div>
<div> preprocess: with_ascend_hack = no</div>
<div> preprocess: ascend_channels_per_line = 23</div>
<div> preprocess: with_ntdomain_hack = no</div>
<div> preprocess: with_specialix_jetstream_hack = no</div>
<div> preprocess: with_cisco_vsa_hack = no</div>
<div> preprocess: with_alvarion_vsa_hack = no</div>
<div>Module: Instantiated preprocess (preprocess)</div>
<div>Module: Loaded realm</div>
<div> realm: format = "suffix"</div>
<div> realm: delimiter = "@"</div>
<div> realm: ignore_default = no</div>
<div> realm: ignore_null = no</div>
<div>Module: Instantiated realm (suffix)</div>
<div>Module: Loaded SQL</div>
<div> sql: driver = "rlm_sql_mysql"</div>
<div> sql: server = "localhost"</div>
<div> sql: port = ""</div>
<div> sql: login = "root"</div>
<div> sql: password = "jOeLya"</div>
<div> sql: radius_db = "radius"</div>
<div> sql: nas_table = "nas"</div>
<div> sql: sqltrace = no</div>
<div> sql: sqltracefile = "/var/log/freeradius/sqltrace.sql"</div>
<div> sql: readclients = yes</div>
<div> sql: deletestalesessions = yes</div>
<div> sql: num_sql_socks = 5</div>
<div> sql: sql_user_name = "%{User-Name}"</div>
<div> sql: default_user_profile = ""</div>
<div> sql: query_on_not_found = no</div>
<div> sql: authorize_check_query = "SELECT id, UserName, Attribute,
Value, op
FROM radcheck
WHERE Username = '%{SQL-User-Name}'
ORDER B
Y id"</div>
<div> sql: authorize_reply_query = "SELECT id, UserName, Attribute,
Value, op
FROM radreply
WHERE Username = '%{SQL-User-Name}'
ORDER B
Y id"</div>
<div> 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"</div>
<div> 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"</div>
<div> 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'"</div>
<div> 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}'"</div>
<div> 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')"</div>
<div> 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')"</div>
<div> 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}'"</div>
<div> 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}'"</div>
<div> 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}')"</div>
<div> sql: group_membership_query = "SELECT GroupName FROM
usergroup WHERE UserName='
%{SQL-User-Name}'"</div>
<div> sql: connect_failure_retry_delay = 60</div>
<div> sql: simul_count_query = ""</div>
<div> 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"</div>
<div> sql: postauth_query = "INSERT into radpostauth (id, user,
pass, reply, date) va
lues ('', '%{User-Name}',
'%{User-Password:-Chap-Password}', '%{reply:Packet-Typ
e}', NOW())"</div>
<div> sql: safe-characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ01
23456789.-_: /"</div>
<div>rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded
and linked</div>
<div>rlm_sql (sql): Attempting to connect to
root@localhost:/radius</div>
<div>rlm_sql (sql): starting 0</div>
<div>rlm_sql (sql): Attempting to connect rlm_sql_mysql #0</div>
<div>rlm_sql_mysql: Starting connect to MySQL server for #0</div>
<div>rlm_sql (sql): Connected new DB handle, #0</div>
<div>rlm_sql (sql): starting 1</div>
<div>rlm_sql (sql): Attempting to connect rlm_sql_mysql #1</div>
<div>rlm_sql_mysql: Starting connect to MySQL server for #1</div>
<div>rlm_sql (sql): Connected new DB handle, #1</div>
<div>rlm_sql (sql): starting 2</div>
<div>rlm_sql (sql): Attempting to connect rlm_sql_mysql #2</div>
<div>rlm_sql_mysql: Starting connect to MySQL server for #2</div>
<div>rlm_sql (sql): Connected new DB handle, #2</div>
<div>rlm_sql (sql): starting 3</div>
<div>rlm_sql (sql): Attempting to connect rlm_sql_mysql #3</div>
<div>rlm_sql_mysql: Starting connect to MySQL server for #3</div>
<div>rlm_sql (sql): Connected new DB handle, #3</div>
<div>rlm_sql (sql): starting 4</div>
<div>rlm_sql (sql): Attempting to connect rlm_sql_mysql #4</div>
<div>rlm_sql_mysql: Starting connect to MySQL server for #4</div>
<div>rlm_sql (sql): Connected new DB handle, #4</div>
<div>rlm_sql (sql): - generate_sql_clients</div>
<div>rlm_sql (sql): Query: SELECT * FROM nas</div>
<div>rlm_sql (sql): Reserving sql socket id: 4</div>
<div>rlm_sql (sql): Read entry
nasname=127.0.0.1,shortname=localhost,secret=passwordr
adius</div>
<div>rlm_sql (sql): Adding client 127.0.0.1 (localhost) to clients
list</div>
<div>rlm_sql (sql): Released sql socket id: 4</div>
<div>Module: Instantiated sql (sql)</div>
<div>Module: Loaded Acct-Unique-Session-Id</div>
<div> acct_unique: key = "User-Name, Acct-Session-Id,
NAS-IP-Address, Client-IP-Addre
ss, NAS-Port"</div>
<div>Module: Instantiated acct_unique (acct_unique)</div>
<div>Module: Loaded files</div>
<div> files: usersfile = "/etc/freeradius/users"</div>
<div> files: acctusersfile = "/etc/freeradius/acct_users"</div>
<div> files: preproxy_usersfile =
"/etc/freeradius/preproxy_users"</div>
<div> files: compat = "no"</div>
<div>Module: Instantiated files (files)</div>
<div>Module: Loaded detail</div>
<div> detail: detailfile =
"/var/log/freeradius/radacct/%{Client-IP-Address}/detail-%
Y%m%d"</div>
<div> detail: detailperm = 384</div>
<div> detail: dirperm = 493</div>
<div> detail: locking = no</div>
<div>Module: Instantiated detail (detail)</div>
<div>Module: Loaded radutmp</div>
<div> radutmp: filename = "/var/log/freeradius/radutmp"</div>
<div> radutmp: username = "%{User-Name}"</div>
<div> radutmp: case_sensitive = yes</div>
<div> radutmp: check_with_nas = yes</div>
<div> radutmp: perm = 384</div>
<div> radutmp: callerid = yes</div>
<div>Module: Instantiated radutmp (radutmp)</div>
<div>Listening on authentication *:1812</div>
<div>Listening on accounting *:1813</div>
<div>Ready to process requests.</div>
<div><br></div></div>
<div> whats really wrong...still cannot read NAS from nas table on
radius..was it?<br></div>
<div>really apreciate your answer.</div>
<div><br></div>
<div>Nizar</div></div></div>
<div><br></div>
<div>--- On <b>Thu, 4/16/09, Ivan Kalik <i><tnt@kalik.net></i></b>
wrote:<br>
<blockquote style="PADDING-LEFT:5px;MARGIN-LEFT:5px;BORDER-LEFT:rgb(16,16,255) 2px solid;"><br>From:
Ivan Kalik <tnt@kalik.net><br>Subject: RE: NAS table<br>To:
"'FreeRadius users mailing list'"
<freeradius-users@lists.freeradius.org><br>Date: Thursday, April
16, 2009, 4:02 AM<br><br>
<div id="yiv312792395">
<div>this is result of <br>freeradius -X<br>reread_config:
reading radiusd.conf<br>Config: including file:
/etc/freeradius/proxy.conf<br>Config: including file:
/etc/freeradius/clients.conf<br>Config: including file:
/etc/freeradius/snmp.conf<br>Config: including file:
/etc/freeradius/eap.conf<br>Config: including file:
/etc/freeradius/sql.conf</div>
<div><br></div>
<div><br></div>
<div><span class="807555920-15042009"><font face="Arial" color="#0000ff" size="2"></font></span> </div>
<div><span class="807555920-15042009"><font face="Arial" color="#0000ff" size="2">It's not. It's a result of HUP. Now post what you were
told.</font></span></div>
<div><span class="807555920-15042009"></span> </div>
<div><span class="807555920-15042009"><font face="Arial" color="#0000ff" size="2">Ivan Kalik</font></span></div>
<div><span class="807555920-15042009"><font face="Arial" color="#0000ff" size="2">Kalik Informatika ISP</font> </span></div>
<p><font face="Arial" size="2"></font></p></div><br>-----Inline Attachment
Follows-----<br><br>
<div class="plainMail">-<br>List info/subscribe/unsubscribe? See <a rel="nofollow" target="_blank" href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a></div></blockquote></div></td></tr></tbody></table><br>
<p><font face="Arial" size="2">No virus found in this incoming message.<br>Checked
by AVG - www.avg.com<br>Version: 8.0.238 / Virus Database: 270.11.57/2060 -
Release Date: 04/15/09 19:52:00<br></font></p>
<p><font face="Arial" size="2"></font></p></blockquote>
</div><br>-----Inline Attachment Follows-----<br><br><div class="plainMail">-<br>List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html" target="_blank">http://www.freeradius.org/list/users.html</a></div></blockquote></div></td></tr></table><br>