how to account different table sql by time decision
    A.L.M.Buxey at lboro.ac.uk 
    A.L.M.Buxey at lboro.ac.uk
       
    Mon Jul  6 14:09:10 CEST 2015
    
    
  
Hi,
> i want to store accounting packet to different table sql with if time
> condition.
> like
> if (time > 1 am) and (time < 9 am)
> { store to acct2}
> else
> { store to acct1}
> 
> i think the solution is using unlang language and put in radius conf.
> im not familiar with unlang language.
> i would appreciate if anybody here could help me.
yep...you've pretty miuch got it - just convert it to unlang and have the required
other SQL instance configured  eg in 
accounting {
if (time logic here, based on regex or unlang and RADIUS attributes) {
	sql
	}
else {
	othersql
    	}
}
othersql being a named instance of the SQL module using a different table etc
alan
    
    
More information about the Freeradius-Users
mailing list