Thanks very much Fajar, I didn´t noticed that the radacct has also changed, therefore I got some errors. I´ve already changed it and it work greats now. Thanks again. Luiz Gustavo Scandelari Date: Thu, 18 Feb 2010 19:07:27 +0700 From: "Fajar A. Nugraha" <fajar@fajar.net> Subject: Re: Accounting queries logging just after Acct-Stop packet To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Message-ID: <7207d96f1002180407re3919c6wf8418a11bf1ea946@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 On Thu, Feb 18, 2010 at 6:22 PM, Luiz Gustavo de Villa Scandelari <luizgustavo@wni.com.br> wrote:
compared to the previous version (1.x.x) the accounting queries are not logging the accounting session at radacct, as it should. After we receive an Acct-Stop Packet the sql module logs the accounting session data to the database, so what can I do in order to have the sql module logging just after the Acct-Start Packet?
Start by comparing the default sql query for acct-start to the one you currently use. Perhaps you're missing something (wrong table name, wrong fields?). Then run FR in debug mode. verify that you got acct-start packet correctly. After that enable sql trace, so you know what queries were executed. That should help you find out which sql query (if any) is causing the problem. -- Fajar