Accounting queries logging just after Acct-Stop packet
Hi, I have Just upgraded my freeradius to version 2.1.7 and changed the config files in order to get it working with mysql. It´s working ok now, but 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? If you need more information please tell me that I´ll promptly send so I can solve this problem soon. Ps.: It´s very important to us to have accounting log data at acct-start packets, because we use this information for some Stored Procedure that affects another system. Best regards, Luiz Gustavo Scandelari Skype: luiz.gustavo.wni
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
participants (2)
-
Fajar A. Nugraha -
Luiz Gustavo de Villa Scandelari