FreeRadius 3.0.15 - Help with accounting

[Fajar A. Nugraha]

On Tue, Aug 8, 2017 at 8:04 PM, Aurélio de Souza Ribeiro Neto
<netolistas at mpc.com.br> wrote:
> Fajar,
>
>     I did and not appear to be a Query problem.
>
>     Look the first and the second insert:
>
> INSERT INTO radacct (acctsessionid, acctuniqueid,           username, realm,
> nasipaddress,           nasportid, nasporttype,
>                 acctstarttime,          acctupdatetime, acctstoptime,
> acctsessiontime,        acctauthentic, connectinfo_start,
> connectinfo_stop,
>         acctinputoctets, acctoutputoctets, calledstationid,
> callingstationid, acctterminatecause, servicetype,
> framedprotocol, framedipaddress)
> VALUES ('81b0ec6b', '1e485bcb3cfbe8526b33e4d1fb50fecd', 'katiasantos', '',
> '172.17.43.2', '15791310', '', (NOW() - 0), NOW(), NOW(), 0, '', '', '', '0'
> << 32 | '0', '0'
> 'Framed-User', 'PPP', '187.120.203.169');
>
>
> INSERT INTO radacct (acctsessionid, acctuniqueid,           username, realm,
> nasipaddress,           nasportid, nasporttype,
>                 acctstarttime,          acctupdatetime, acctstoptime,
> acctsessiontime,        acctauthentic, connectinfo_start,
> connectinfo_stop,
>         acctinputoctets, acctoutputoctets, calledstationid,
> callingstationid, acctterminatecause, servicetype,
> framedprotocol, framedipaddress)
>  VALUES ('81b0ecc1', '5b68881f4438da10588f26dbe616c917', 'katiasantos', '',
> '172.17.43.2', '15791396', 'Ethernet', NOW(), NOW(), NULL, '0', 'RADIUS',
> '', '', '0', '0',
>  'CE - POP SM8', '1C:7E:E5:C4:2E:73', '', 'Framed-User', 'PPP',
> '187.120.203.169');
>
>     What I can do?


Then you need to capture what the NAS send when this happens. On the
first insert, FR believes that the NAS is not sending nasporttype and
callingstationid. 'freeradius -X' can show you what FR receives (I did
not see accounting request on your original dump, only
Access-Request).

Again, my GUESS is the NAS sends it that way. In which case you need
to ask whoever configured the NAS (or its creators) why it sends that.

-- 
Fajar