>>I have freeradius virtual configurations. >>Until today all were working without a problem. >>But today i created a new one and i have a tiny problem about it. >>It doesnt update sql queries until the user logs off. SO i can not track >>the statistics of online users and transferred data etc via mysql. >>But as i see freeradius gets the following packets below in normal >> intervals >>And if it was an error about sql.conf i think it wont write the data when >>user disconnected too.It just does not update the online users data..and >> i >>wonder why..Seems like it does not create user data at the begining so it >>can not update the data too. >> > > If server doesn't get accounting start packet it will use alternative > update query (INSERT) because there is nothing to update. That is if > this is an update packet at all. You will need to post the request that > was processed as well. > > If you are not getting updates from the NAS at all you need to fix that > on the NAS or by sending Acct-Interim-Inetrval in the Access-Accept > reply. No guarantee that your NAS will respect it. > > Ivan Kalik > Kalik Informatika ISP > > -
Ok found the problem.. Couldn't insert SQL accounting ALIVE record - Unknown column 'xascendsessionsvrkey' in 'field list' I forgot to add the field on radacct table.. Ok added and everything works fine. > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
