openmeetings-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Maxim Solodovnik <solomax...@gmail.com>
Subject Re: Shell script to delete unsused streams and report stream diskspace usage
Date Fri, 06 Apr 2012 16:05:15 GMT
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
<Thibault.LeMeur@supelec.fr>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
> > <Thibault.LeMeur@supelec.fr> 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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message