thanks. will do some research. But I guess I can not send this as syslog entry to a syslog server, right? Also about the username, you are right on the Mac address - I misread it - but I do see unreadable accounting log like this one in the packet. Is this something fixable at NAS? Frank rad_recv: Accounting-Request packet from host 172.18.47.242 port 32768, id=127, length=235 User-Name = "f87b7a92466d" NAS-Port = 29 NAS-IP-Address = 172.18.47.242 Framed-IP-Address = 172.24.7.145 NAS-Identifier = "xxxxxxxxxxx" Airespace-Wlan-Id = 5 Acct-Session-Id = "4fccbbf1/f8:7b:7a:92:46:6d/197670" Acct-Authentic = Remote Tunnel-Type:0 = VLAN Tunnel-Medium-Type:0 = IEEE-802 Tunnel-Private-Group-Id:0 = "1632" Acct-Status-Type = Stop Acct-Input-Octets = 3790 Acct-Output-Octets = 5427 Acct-Input-Packets = 42 Acct-Output-Packets = 12 Acct-Terminate-Cause = User-Request Acct-Session-Time = 77 Acct-Delay-Time = 0 Calling-Station-Id = "0.0.0.0" Called-Station-Id = "172.18.47.242" Cisco-AVPair = "nas-update=true" On May 30, 2012, at 1:30 PM, Phil Mayers wrote:
On 30/05/12 18:00, Luo, Frank Y.F. Mr. wrote:
Is there a way to send accounting log to syslog instead of detail file in radacct?
See "linelog"
Also instead of sending it to sql db, i tried to use sql-file but it results in a lot of sql command (we really don't want to run the sql command later).
I don't know what this means, I'm afraid.
Also noticing the UserName part, a lot of times that a binary username is logged, like here "1040f31ca3b4", instead of the real name. How to fix this?
That's not a "binary username". It's the MAC address, without any colons. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html