]> git.entuzijast.net Git - freeradius-dialup-admin.git/commit
* Remove one sql query from user_admin which was not needed.
authorkkalev <kkalev>
Thu, 21 Nov 2002 23:33:32 +0000 (23:33 +0000)
committerkkalev <kkalev>
Thu, 21 Nov 2002 23:33:32 +0000 (23:33 +0000)
commit5de222c7056149a131fa1e0fba317a49ca014672
tree6c9efef4e922f5d935beb7f2e8d45d169e2328da
parent75d65e2291303dcf78b34116ca0b9f29642422df
* Remove one sql query from user_admin which was not needed.
* Instead of a query like "LIKE 'YYYY-MM-DD%'" use "AcctStopTime >= 'YYYY-MM-DD 00:00:00 AND AcctStopTime
  <= 'YYYY-MM-DD 23:59:59'" which will allow us to use sql indexes better.
* Add a few comments in bin/clean_radacct
* Add a new script bin/truncate_radacct which will delete all sessions from the radacct table which
  are older than a configurable number of days.
* Add an entry in tuning_guide about creating a multi column index for (UserName,AcctStopTime). This
  will really help sql_checksimul and the corresponding queries.
Changelog
bin/clean_radacct
bin/truncate_radacct [new file with mode: 0755]
htdocs/stats.php3
htdocs/user_admin.php3
htdocs/user_state.php3