17 Mar
2019
17 Mar
'19
9:55 a.m.
On Sun, 2019-03-17 at 12:35 +0530, Somanath Mishra wrote:
'%{NAS-Port-Type}', \ FROM_UNIXTIME(%{integer:Event -Timestamp}), \ FROM_UNIXTIME(%{integer:Event -Timestamp}), \
...
servicetype, framedprotocol, framedipaddress) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User- Name}', '%{Realm}', '%{NAS-IP-Address}', '%{%{NAS-Port-ID}:-%{NAS-Port}}', '%{NAS-Port-Type}', %{%{integer:Event-Timestamp}:-date('now')}, %{%{integer:Event-Timestamp}:-date('now')}, NULL, '0',
You need to find out what config file FreeRADIUS is actually using, because it's not using the one you quoted above. The query is different. -- Matthew