Hello Michael,
In case you are trying to perform cleanup yourself it is your
responsibility to clean up connected tables.
Since you have truncated correspondent tables manually there is no need in
additional backup/import (it make no sense to perform it)
I believe you can do ONE of the following to clean up recordings
I.1 delete all recordings via GUI
I.2 run command line admin to purge records
II.1 perform manual delete from DB tables
II.2 remove files from file system
III.1 perform export
III.2 unzip backup file, remove recordings, delete nodes from
flvrecordings.xml (or similar)
III.3 zip the file back
III.4 drop DB
III.5 perform import
According to command line admin: it has "f" option to report
temporary/unused files/DB records (like there is DB record but no file or
there is file but no DB record) and "--cleanup" option to remove everything
that was found. ("WARNING: all intermadiate
files will be clean up!" means there will be no way back :))) )
I'm afraid it might not work on "manually tuned" DB :(
To get detailed message from it you need to run it with "-v" == verbose key
According to "organizations.xml missing" I'm afraid I only can help if I
got your backup file :( Additionally the whole process might not work very
well since you have manually modified DB
On Fri, Nov 8, 2013 at 8:22 PM, Michael Wuttke <
michael.wut...@beuth-hochschule.de> wrote:
> Hello Alexei,
>
> 1) I deleted manually the record files from the disk.
> 2a) I truncated/cleaned the table flvrecordings manually.
>
> But what about the outher tables: flvrecording_log,
> flvrecording_meta_delta and flvrecording_metadata? Do I have to clean
> them as well?
>
> 2b) I mad a system-backup and prepared the import.zip by deleting the
> records and changing the flvRecordings.xml. Then I tried to import the
> backup zip file and got the following error message, but the
> organizations.xml in the zip file:
>
> DEBUG 11-08 13:10:34.894 o.a.o.s.o.AbstractUploadController:58
> [http-bio-0.0.0.0-5080-exec-29] - Starting validate
> DEBUG 11-08 13:10:34.894 o.a.o.s.o.AbstractUploadController:65
> [http-bio-0.0.0.0-5080-exec-29] - sid: 42445874494fb7e60fe553ac85acbf14
> DEBUG 11-08 13:10:34.900 o.a.o.s.o.AbstractUploadController:69
> [http-bio-0.0.0.0-5080-exec-29] - userId = 1, userLevel = 3
> DEBUG 11-08 13:10:34.900 o.a.o.s.o.AbstractUploadController:83
> [http-bio-0.0.0.0-5080-exec-29] - publicSID:
> ce8e24a327bafb9aae93564dc43442bf
> DEBUG 11-08 13:10:34.902 o.a.o.s.o.AbstractUploadController:92
> [http-bio-0.0.0.0-5080-exec-29] - uploading 114940 bytes
> DEBUG 11-08 13:10:34.903 o.a.o.s.o.BackupImportController:201
> [http-bio-0.0.0.0-5080-exec-29] - ##### WRITE FILE TO:
> /usr/lib/red5/webapps/openmeetings/upload/import/import_2013_11_08_13_10_34
> ERROR 11-08 13:10:34.916 o.a.o.s.o.BackupImportController:634
> [http-bio-0.0.0.0-5080-exec-29] - [ImportExport]
> java.lang.Exception: organizations.xml missing
> at
>
> org.apache.openmeetings.servlet.outputhandler.BackupImportController.readList(BackupImportController.java:653)
> ~[openmeetings-2.2.0-SNAPSHOT.jar:na]
> at
>
> org.apache.openmeetings.servlet.outputhandler.BackupImportController.readList(BackupImportController.java:642)
> ~[openmeetings-2.2.0-SNAPSHOT.jar:na]
> at
>
> org.apache.openmeetings.servlet.outputhandler.BackupImportController.performImport(BackupImportController.java:231)
> ~[openmeetings-2.2.0-SNAPSHOT.jar:na]
> at
>
> org.apache.openmeetings.servlet.outputhandler.BackupImportController.service(BackupImportController.java:621)
> ~[openmeetings-2.2.0-SNAPSHOT.jar:na]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[na:1.6.0_26]
> at
>
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> ~[na:1.6.0_26]
> at
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> ~[na:1.6.0_26]
> at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_26]
> at
>
> org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)
> [spring-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
> at
>
> org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
> [spring-web-3.1.4.RELEASE.jar:3.1.4.RELEASE]
> at
>
> org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96)
> [spring-webmvc-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]
> at
>
> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617)
> [spring-webmvc-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]
> at
>
> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578)
> [spring-webmvc-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]
> at
>
> org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
> [spring-webmvc-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]
> at
>
> org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)
> [spring-webmvc-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]
> at
>
> org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)
> [spring-webmvc-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]
> at
>
> org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
> [spring-webmvc-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]
> at
>
> org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)
> [spring-webmvc-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
> [tomcat-embed-core-7.0.41.jar:7.0.41]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
> [tomcat-embed-core-7.0.41.jar:7.0.41]
> at
>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
> [tomcat-embed-core-7.0.41.jar:7.0.41]
> at
>
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
> [tomcat-embed-core-7.0.41.jar:7.0.41]
> at
> org.red5.logging.LoggerContextFilter.doFilter(LoggerContextFilter.java:77)
> [red5-server.jar:na]
> at
>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
> [tomcat-embed-core-7.0.41.jar:7.0.41]
> at
>
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
> [tomcat-embed-core-7.0.41.jar:7.0.41]
> at
>
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
> [tomcat-embed-core-7.0.41.jar:7.0.41]
> at
>
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
> [tomcat-embed-core-7.0.41.jar:7.0.41]
> at
>
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
> [tomcat-embed-core-7.0.41.jar:7.0.41]
> at
>
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
> [tomcat-embed-core-7.0.41.jar:7.0.41]
> at
>
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
> [tomcat-embed-core-7.0.41.jar:7.0.41]
> at
>
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
> [tomcat-embed-core-7.0.41.jar:7.0.41]
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
> [tomcat-embed-core-7.0.41.jar:7.0.41]
> at
>
> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
> [tomcat-embed-core-7.0.41.jar:7.0.41]
> at
>
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
> [tomcat-embed-core-7.0.41.jar:7.0.41]
> at
>
> org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
> [tomcat-embed-core-7.0.41.jar:7.0.41]
> at
>
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> [na:1.6.0_26]
> at
>
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> [na:1.6.0_26]
> at java.lang.Thread.run(Thread.java:662) [na:1.6.0_26]
>
> Do you have any idea, what was wrong?
>
> Thank you,
> Michael
>
> Am 06.11.2013 17:12, schrieb Alexei Fedotov:
> > Hello Michael,
> >
> > 1) you can manually delete records from the disk,
> > 2) to make them disappear from interface you have to drop them from
> > the database - this can be done manually or via export/import.
> >
> > --
> > With best regards / с наилучшими пожеланиями,
> > Alexei Fedotov / Алексей Федотов,
> >
> > On Wed, Nov 6, 2013 at 8:05 PM, Michael Wuttke
> > <michael.wut...@beuth-hochschule.de> wrote:
> >> Hello,
> >>
> >> is it possible to delete recordings as a teacher/moderator from a moodle
> >> site? Or how can I delete old recordings - created form a moodle site -
> >> as OM admin?
> >>
> >> Is there already an option for the command line or in the OM GUI to drop
> >> all temporary/redundant files for a cleanup of a OM system?
> >>
> >> I am using OM 2.1.1 and moodle 2.4.x.
> >>
> >> Thank you for any advice,
> >> Michael
>
--
WBR
Maxim aka solomax
