Hello,
Thanks Heaps for your help,
This is the output from -X
Thanks Again
Rhys
main: max_requests = 1024
main: delete_blocked_requests = 0
main: port = 0
main: allow_core_dumps = no
main: log_stripped_names = no
main: log_auth = no
main: log_auth_badpass = no
main: log_auth_goodpass = no
main: pidfile = "/usr/local/var/run/radiusd.pid"
main: user = "root"
main: group = "root"
main: usercollide = no
main: lower_user = "no"
main: lower_pass = "no"
main: nospace_user = "no"
main: nospace_pass = "no"
main: proxy_requests = yes
proxy: retry_delay = 5
proxy: retry_count = 3
proxy: synchronous = no
proxy: dead_time = 120
main: debug_level = 0
read_config_files: entering modules setup
Module: Library search path is /usr/local/lib
Module: Loaded SQL
sql: driver = "rlm_sql_mysql"
sql: server = "localhost"
sql: port = ""
sql: login = ""
sql: password = ""
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 = no
sql: sqltracefile = "/usr/local/var/log/radius/sqltrace.sql"
sql: deletestalesessions = yes
sql: num_sql_socks = 5
sql: sql_user_name = "%{User-Name}"
sql: authorize_check_query = "SELECT id,UserName,Attribute,Value FROM
radcheck
WHERE Username = '%{SQL-User-Name}' ORDER BY id"
sql: authorize_reply_query = "SELECT id,UserName,Attribute,Value FROM
radreply
WHERE Username = '%{SQL-User-Name}' ORDER BY id"
sql: authorize_group_check_query = "SELECT
radgroupcheck.id,radgroupcheck.Group
Name,radgroupcheck.Attribute,radgroupcheck.Value FROM
radgroupcheck,usergroup WH
ERE usergroup.Username = '%{SQL-User-Name}' AND usergroup.GroupName =
radgroupch
eck.GroupName ORDER BY radgroupcheck.id"
sql: authorize_group_reply_query = "SELECT
radgroupreply.id,radgroupreply.Group
Name,radgroupreply.Attribute,radgroupreply.Value FROM
radgroupreply,usergroup WH
ERE usergroup.Username = '%{SQL-User-Name}' AND usergroup.GroupName =
radgroupre
ply.GroupName ORDER BY radgroupreply.id"
sql: authenticate_query = "SELECT Value,Attribute FROM radcheck WHERE
UserName
= '%{User-Name}' AND ( Attribute = 'Password' OR Attribute =
'Crypt-Password' )
ORDER BY Attribute DESC"
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
AcctSessionTi
me=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-Us
er-Name}' AND NASIPAddress= '%{NAS-IP-Address}'"
sql: accounting_start_query = "INSERT into radacct (RadAcctId,
AcctSessionId, A
cctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType,
AcctStartTim
e, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start,
ConnectInfo_
stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId,
Acct
TerminateCause, ServiceType, FramedProtocol, FramedIPAddress,
AcctStartDelay, Ac
ctStopDelay) values('', '%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}',
'%{SQ
L-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port-Id}',
'%{NAS-Port-Ty
pe}', '%S', '0', '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0',
'%{C
alled-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}',
'%{Framed-Pr
otocol}', '%{Framed-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 (RadAcctId,
AcctSessionId
, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType,
AcctStart
Time, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start,
ConnectIn
fo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId,
CallingStationId, A
cctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress,
AcctStartDelay,
AcctStopDelay) values('', '%{Acct-Session-Id}',
'%{Acct-Unique-Session-Id}', '%
{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port-Id}',
'%{NAS-Port
-Type}', '0', '%S', '%{Acct-Session-Time}', '%{Acct-Authentic}', '',
'%{Connect-
Info}', '%{Acct-Input-Octets}', '%{Acct-Output-Octets}',
'%{Called-Station-Id}',
'%{Calling-Station-Id}', '%{Acct-Terminate-Cause}', '%{Service-Type}',
'%{Frame
d-Protocol}', '%{Framed-IP-Address}', '0', '%{Acct-Delay-Time}')"
sql: connect_failure_retry_delay = 60
rlm_sql: Driver rlm_sql_mysql loaded and linked
rlm_sql: Attempting to connect to @localhost:/radius
rlm_sql: Connected new DB handle, #0
rlm_sql: Connected new DB handle, #1
rlm_sql: Connected new DB handle, #2
rlm_sql: Connected new DB handle, #3
rlm_sql: Connected new DB handle, #4
Module: Instantiated sql (sql)
Module: Loaded radutmp
radutmp: filename = "/usr/local/var/log/radius/radutmp"
radutmp: username = "%{User-Name}"
radutmp: perm = 384
radutmp: callerid = yes
Module: Instantiated radutmp (radutmp)
Listening on IP address *, ports 1645/udp and 1646/udp, with proxy on
1647/udp.
Ready to process requests.
rad_recv: Access-Request packet from host 192.168.0.15:1430, id=14,
length=96
User-Name = "administrator"
CHAP-Challenge = "\000\374Lwyj\023\322`\r\314>a\337\301\001"
CHAP-Password = "\004>}\240H\035\204\214\232h\271\231FZj\340g"
NAS-Port = 0
Framed-Protocol = PPP
NAS-Identifier = "TEST"
NAS-Port-Type = Async
modcall: entering group authorize
rlm_sql: Reserving sql socket id: 4
radius_xlat: 'administrator'
sql_escape in: 'administrator'
sql_escape out: 'administrator'
sql_set_user: escaped user --> 'administrator'
radius_xlat: 'SELECT id,UserName,Attribute,Value FROM radcheck WHERE
Username =
'administrator' ORDER BY id'
radius_xlat: 'SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Att
ribute,radgroupcheck.Value FROM radgroupcheck,usergroup WHERE
usergroup.Username
= 'administrator' AND usergroup.GroupName = radgroupcheck.GroupName ORDER
BY ra
dgroupcheck.id'
radius_xlat: 'SELECT id,UserName,Attribute,Value FROM radreply WHERE
Username =
'administrator' ORDER BY id'
radius_xlat: 'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Att
ribute,radgroupreply.Value FROM radgroupreply,usergroup WHERE
usergroup.Username
= 'administrator' AND usergroup.GroupName = radgroupreply.GroupName ORDER
BY ra
dgroupreply.id'
rlm_sql: Released sql socket id: 4
modcall[authorize]: module "sql" returns ok
modcall: group authorize returns ok
auth: type Local
auth: user supplied CHAP-Password matches local Password
Sending Access-Accept of id 14 to 192.168.0.15:1430
Framed-Compression = Van-Jacobson-TCP-IP
Framed-Protocol = PPP
Service-Type = Framed-User
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 192.168.0.15:1431, id=15,
length=8
4
Acct-Status-Type = Start
Acct-Session-Id = "65539"
User-Name = "administrator"
NAS-Port = 0
NAS-Identifier = "TEST"
Framed-Protocol = PPP
Framed-IP-Address = 192.168.20.2
Service-Type = Framed-User
NAS-Port-Type = Async
modcall: entering group accounting
rlm_sql: Reserving sql socket id: 4
radius_xlat: 'administrator'
sql_escape in: 'administrator'
sql_escape out: 'administrator'
sql_set_user: escaped user --> 'administrator'
radius_xlat: 'INSERT into radacct (RadAcctId, AcctSessionId, AcctUniqueId,
User
Name, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime,
AcctStopTime,
AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop,
AcctInputOc
tets, AcctOutputOctets, CalledStationId, CallingStationId,
AcctTerminateCause, S
erviceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay)
valu
es('', '65539', '', 'administrator', '', '', '', 'Async', '2002-04-09
09:59:39',
'0', '0', '', '', '', '0', '0', '', '', '', 'Framed-User', 'PPP',
'192.168.20.2
', '', '0')'
rlm_sql: Released sql socket id: 4
modcall[accounting]: module "sql" returns ok
modcall: group accounting returns ok
Sending Accounting-Response of id 15 to 192.168.0.15:1431
Finished request 1
Going to the next request
--- Walking the entire request list ---
Cleaning up request 1 ID 15 with timestamp 3cb22eeb
Waking up in 5 seconds...
--- Walking the entire request list ---
Cleaning up request 0 ID 14 with timestamp 3cb22eea
Nothing to do. Sleeping until we see a request.
rad_recv: Accounting-Request packet from host 192.168.0.15:1432, id=16,
length=8
4
Acct-Status-Type = Stop
Acct-Session-Id = "65539"
User-Name = "administrator"
NAS-Port = 0
NAS-Identifier = "TEST"
Framed-Protocol = PPP
Acct-Session-Time = 84
Acct-Terminate-Cause = Admin-Reset
NAS-Port-Type = Async
modcall: entering group accounting
rlm_sql: Reserving sql socket id: 4
radius_xlat: 'administrator'
sql_escape in: 'administrator'
sql_escape out: 'administrator'
sql_set_user: escaped user --> 'administrator'
radius_xlat: 'UPDATE radacct SET AcctStopTime = '2002-04-09 10:01:01',
AcctSess
ionTime = '84', AcctInputOctets = '', AcctOutputOctets = '',
AcctTerminateCause
= 'Admin-Reset', AcctStopDelay = '', ConnectInfo_stop = '' WHERE
AcctSessionId =
'65539' AND UserName = 'administrator' AND NASIPAddress = '''
rlm_sql: Released sql socket id: 4
modcall[accounting]: module "sql" returns ok
modcall: group accounting returns ok
Sending Accounting-Response of id 16 to 192.168.0.15:1432
Finished request 2
Going to the next request
--- Walking the entire request list ---
Cleaning up request 2 ID 16 with timestamp 3cb22f3d
Nothing to do. Sleeping until we see a request.
----- Original Message -----
From: "3APA3A" <[EMAIL PROTECTED]>
To: "Rhys (gallamda)" <[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 5:16 PM
Subject: Re[2]: Freeradius with NT4 (not recording octets)
> Dear Rhys (gallamda),
>
> start radiusd -xx or radiusd -X, wait for accounting packet and send
> logs for this packet.
>
>
> --Tuesday, April 9, 2002, 2:50:28 AM, you wrote to
[EMAIL PROTECTED]:
>
> Rg> Thank you for your quick reply
>
> Rg> However I am very new to the radius concept,
>
> Rg> snip
> Rg> "Turn on extended logging and send a log for Accounting packet."
>
> Rg> What does this mean?, do I do this from the Radius Client or Server?
>
> Rg> Thanks Again
>
> Rg> Rhys
>
>
>
> Rg> ----- Original Message -----
> Rg> From: "3APA3A" <[EMAIL PROTECTED]>
> Rg> To: "Rhys (Gallamda)" <[EMAIL PROTECTED]>
> Rg> Sent: Monday, April 08, 2002 8:52 PM
> Rg> Subject: Re: Freeradius with NT4 (not recording octets)
>
>
> >> Dear Rhys (Gallamda),
> >>
> >> I really surprised RRAS from NT4 supports RADIUS.
> >>
> >> Turn on extended logging and send a log for Accounting packet.
> >>
> >> --Monday, April 8, 2002, 1:41:36 PM, you wrote to
> Rg> [EMAIL PROTECTED]:
> >>
> >> RG> Hello,
> >>
> >> RG> I have Freeradius 4 running on Mandrake,
> >>
> >> RG> I have an NT4 box loaded with RRAS (radius client)
> >>
> >> RG> The authentication & logging works fine except it shows 0 bytes
always
> >>
> >> RG> Does anyone know of a workaround for this?
> >>
> >> RG> Thanks Heaps
> >>
> >> RG> Rhys
> >>
> >>
> >> --
> >> ~/ZARAZA
> >> Не обращайте внимания на сарказм и явную чепуху,
> >> а поразмыслите просто над фактами. (Твен)
> >>
> >>
> >> -
> >> List info/subscribe/unsubscribe? See
> Rg> http://www.freeradius.org/list/users.html
>
>
> Rg> -
> Rg> List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
>
>
> --
> ~/ZARAZA
> Ну а в целом, Уильям, здешний климат - ежели только
> это можно назвать климатом, вполне сносный. (Твен)
>
>
> -
> List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
