FreeRadius 3.0.15 - Help with accounting

[Aurélio de Souza Ribeiro Neto]

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?



Em 07/08/2017 08:56, Fajar A. Nugraha escreveu:
> On Mon, Aug 7, 2017 at 6:44 PM, Aurélio de Souza Ribeiro Neto
> <netolistas at mpc.com.br> wrote:
>> Hello,
>>
>>      I have problems with some accounting packets.
>>
>>      Certainly it's my problem, but I need help (or hint).
>>
>>      Sometimes I receive a complete Start request, but in my database (MySQL)
>> the data are inserted incomplete, without nasporttype and callingstationid.
> Easiest way? I'd say log the sql queries, and test / replay them on your db.
>
> https://github.com/FreeRADIUS/freeradius-server/blob/v3.0.x/raddb/mods-available/sql#L141
>
> My GUESS is:
> - some attributes don't make it to the sql queries
> - some queries result in incorrect result (e.g. probably a missing
> quote somewhere?)
>