I will add multi-OS and multi-DB version of this. I guess having cleanup capabilities is vital while storing video files ...
On Fri, Apr 6, 2012 at 22:58, Thibault Le Meur <[email protected]>wrote: > Hi Alexei, > > I knopw about jira contributions, but I don't think this should be > included into the OM disrtibutions. > Looks more like a "tip and tricks" item, you know, things you put in a > wiki, than a script to be added to the distribution (as I've said it's > quick and dirty). > It can be used until OM has it's own clean way of handling these > operations (User quota, file expirations, ...). > > By the way, here is the little brother of the first script, aimed at > dealing with files uploaded to rooms. > > Regards, > Thibault > > Le 06/04/2012 12:56, Alexei Fedotov a écrit : > > Thibault, > > > > thanks for your contribution. The recommended way is to contribute via > > jira attachment, in that case you transfer rights to ASF correctly. > > > > -- > > With best regards / с наилучшими пожеланиями, > > Alexei Fedotov / Алексей Федотов, > > http://dataved.ru/ > > +7 916 562 8095 > > > > > > > > On Fri, Apr 6, 2012 at 2:28 PM, Thibault Le Meur > > <[email protected]> wrote: > >> Hi, > >> > >> It seems that OM doesn't delete streams form the filesystem. Thus I > >> needed a way to track diskspace usage of streams so I developped a "not > >> so quick and yet dirty script" to do the following tasks: > >> * delete streams marked as deleted in OpenMeetings DB from the > filesystem > >> * report diskspace used by not deleted streams with associated > >> information (owner, room, ...) > >> * report diskspace per user, and send an overquota email if needed > >> * report streams older than and Expiration duration threshold and send > >> an expriation email if needed > >> > >> It requires: > >> * linux system > >> * openmeetings with mysql DB (tested on openmeetings_1_9_1_r4707) > >> * mysql client, a mysqk user able to do selects to the OM DB > >> * usual linux tools like cut, awk, sed and bash 4.x > >> > >> It comes with no warranty as I had to reverse engineer the DB to > >> understand how streams ar recorded and marked as deleted and I'm quite > >> sure there are things I missed so It may be considered as a "template". > >> I just post it here, in case it can prove to be usefull to someone. > >> > >> Now I would need help on how uploaded files are recorded to filesystem > >> and DB to do the same for these ones. If anyone can help me... ;-) > >> > >> Regards, > >> Thibault > > -- WBR Maxim aka solomax
