Re: how to account different table sql by time decision

On Jul 7, 2015, at 10:25 AM, johan firdianto <johanfirdi@gmail.com> wrote:

if acct packet goes at first time , sql instance would be insert, and subsquent should be update. if have 2 table radacct, 1rst radacct for accounting for night hours and the others for work hours. how to make sure there are 2 insert operation in a session accounting ?

In 3.0.8 and later, all of this is handled automatically for you. The SQL module runs through a series of queries until one succeeds. The default configuration has the correct combination of insert / update to make this work. Alan DeKok.