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@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-avail...
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?)