sql - best practices

[Matthew Newton]

On Thu, Apr 09, 2015 at 05:53:23PM +0200, Marcin wrote:
> 2015-04-09 17:38 GMT+02:00 Anil Thapa <anilth at hi.is>:
> >
> > maybe this line should do for you
> >
> > /usr/bin/mysql -u radiususername -pradiuspassword  radiusdatabase -e
> > "delete  from radacct where acctstoptime is not NULL ;
> 
> but i've thougt that is other solution, because i wanted to resign from
> database to flat files.

As suggested a couple of weeks ago, there are other methods - you
could investigate redis for example. That would synchronize your
session data around without the pain of SQL, and also allows you
to set expiry timers on records so they automatically vanish after
a certain time.

I'm not sure if there is documentation on how to do it, but it
should be possible and be a much cleaner solution.

Matthew


-- 
Matthew Newton, Ph.D. <mcn4 at le.ac.uk>

Systems Specialist, Infrastructure Services,
I.T. Services, University of Leicester, Leicester LE1 7RH, United Kingdom

For IT help contact helpdesk extn. 2253, <ithelp at le.ac.uk>