On Wed, 19 Nov 2003, David Blood wrote:
> 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
>
What does your sql.conf look like?
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
