For some reason mysql is not being update with the interim accouting
updates. Below is one of the accounting requests sent to free radius and
you can see that it does not send the bytes and up time information to
mysql.
Anyone know why?
rad_recv: Accounting-Request packet from host 204.228.226.18:1306, id=249,
length=181
Service-Type = Framed-User
Framed-Protocol = PPP
NAS-Identifier = "SQN2"
NAS-Port = 60
NAS-Port-Type = Ethernet
User-Name = "shawn"
Calling-Station-Id = "06:2d:1A:05:A2:6B"
Called-Station-Id = "SpeedyQuick"
NAS-Port-Id = "Clients"
Acct-Session-Id = "8120001a"
Framed-IP-Address = 10.69.4.22
Acct-Authentic = RADIUS
Acct-Session-Time = 115201
Acct-Input-Octets = 2350343
Acct-Input-Packets = 27316
Acct-Output-Octets = 36915463
Acct-Output-Packets = 36681
Acct-Status-Type = Alive
NAS-IP-Address = 205.28.26.18
Acct-Delay-Time = 0
modcall: entering group preacct
modcall[preacct]: module "preprocess" returns noop
rlm_realm: No '@' in User-Name = "shawn", looking up realm NULL
rlm_realm: No such realm "NULL"
modcall[preacct]: module "suffix" returns noop
modcall[preacct]: module "files" returns noop
modcall: group preacct returns noop
modcall: entering group accounting
rlm_acct_unique: Hashing 'NAS-Port-Id = "Clients",Client-IP-Address =
205.28.26.18,NAS-IP-Address = 205.28.26.18,Acc
t-Session-Id = "8120001a",User-Name = "shawn"'
rlm_acct_unique: Acct-Unique-Session-ID = "f56023f6b2ffca98".
modcall[accounting]: module "acct_unique" returns ok
radius_xlat:
'/usr/local/var/log/radius/radacct/205.28.26.18/detail-20031119'
rlm_detail:
/usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands
to /usr/local/var/log/radius/ra
dacct/205.28.26.18/detail-20031119
modcall[accounting]: module "detail" returns ok
modcall[accounting]: module "unix" returns noop
radius_xlat: 'shawn'
rlm_sql (sql): sql_set_user escaped user --> 'shawn'
radius_xlat: 'UPDATE radacct SET FramedIPAddress = '10.69.4.22' WHERE
AcctSessionId = '8120001a' AND UserName = 'shawn' AND NASIPAddress=
'205.28.26.18' AND AcctStopTime = 0'
rlm_sql (sql): Reserving sql socket id: 3
rlm_sql (sql): Released sql socket id: 3
modcall[accounting]: module "sql" returns ok
radius_xlat: '/usr/local/var/log/radius/radutmp'
radius_xlat: 'shawn'
modcall[accounting]: module "radutmp" returns ok
modcall: group accounting returns ok
Sending Accounting-Response of id 249 to 205.28.26.18:1306
Finished request 31
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
