Thank you, I run this select on db:
select * from rooms_organisation where organisation_id IS NULL or rooms_id IS NULL; i have found 6 entries with NULL in organisation_id column and another 4 entries with NULL in rooms_id. I delete all this entries and the backup works. Thank you very much for your help, Geo 2012/8/10 Maxim Solodovnik <[email protected]> > ok > i guess you have entries in room_organisations table (openmeetings > database) with NULL organisation_id > lets check it: > > mysql -u _your_user -p openmeetings > select * from room_organisations where organisation_id IS NULL; > > is this list return anything? > > On Fri, Aug 10, 2012 at 12:03 PM, Geo <[email protected]> wrote: > >> DB: mysql >> From debug mode: >> >> openmeetings.log >> >> DEBUG 08-10 07:54:02.039 BackupExport.java 148915 129 >> org.openmeetings.servlet.outputhandler.BackupExport [http-0.0.0.0-5080-1] - >> sid: ddb7a769d40fb0507cff82c94d0537af >> DEBUG 08-10 07:54:02.047 BackupExport.java 148923 134 >> org.openmeetings.servlet.outputhandler.BackupExport [http-0.0.0.0-5080-1] - >> users_id: 1 >> DEBUG 08-10 07:54:02.048 BackupExport.java 148924 135 >> org.openmeetings.servlet.outputhandler.BackupExport [http-0.0.0.0-5080-1] - >> user_level: 3 >> DEBUG 08-10 07:54:02.048 BackupExport.java 148924 151 >> org.openmeetings.servlet.outputhandler.BackupExport [http-0.0.0.0-5080-1] - >> moduleName: backup >> DEBUG 08-10 07:54:02.170 BackupExport.java 149046 208 >> org.openmeetings.servlet.outputhandler.BackupExport [http-0.0.0.0-5080-1] - >> Number of Users to be deleted 45 >> ERROR 08-10 07:54:02.341 BackupExport.java 149217 534 >> org.openmeetings.servlet.outputhandler.BackupExport [http-0.0.0.0-5080-1] - >> ERROR >> java.lang.NullPointerException: null >> at >> org.openmeetings.servlet.outputhandler.BackupExport.createOrgRoomsDocument(BackupExport.java:1394) >> ~[openmeetings.jar:na] >> at >> org.openmeetings.servlet.outputhandler.BackupExport.service(BackupExport.java:244) >> ~[openmeetings.jar:na] >> at >> org.openmeetings.servlet.outputhandler.BackupExportFacade.service(BackupExportFacade.java:70) >> [openmeetings.jar:na] >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) >> [javaee-api-5.1.2.jar:5.1.2] >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) >> [catalina-6.0.32.jar:6.0.32] >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> [catalina-6.0.32.jar:6.0.32] >> at >> org.openmeetings.servlet.outputhandler.ServletRequestExFilter.doFilter(ServletRequestExFilter.java:31) >> [openmeetings.jar:na] >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> [catalina-6.0.32.jar:6.0.32] >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> [catalina-6.0.32.jar:6.0.32] >> at >> org.red5.logging.LoggerContextFilter.doFilter(LoggerContextFilter.java:78) >> [red5.jar:na] >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> [catalina-6.0.32.jar:6.0.32] >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> [catalina-6.0.32.jar:6.0.32] >> at >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) >> [catalina-6.0.32.jar:6.0.32] >> at >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) >> [catalina-6.0.32.jar:6.0.32] >> at >> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470) >> [catalina-6.0.32.jar:6.0.32] >> at >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) >> [catalina-6.0.32.jar:6.0.32] >> at >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) >> [catalina-6.0.32.jar:6.0.32] >> at >> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:554) >> [catalina-6.0.32.jar:6.0.32] >> at >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) >> [catalina-6.0.32.jar:6.0.32] >> at >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) >> [catalina-6.0.32.jar:6.0.32] >> at >> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) >> [tomcat-coyote-6.0.32.jar:6.0.32] >> at >> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) >> [tomcat-coyote-6.0.32.jar:6.0.32] >> at >> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) >> [tomcat-coyote-6.0.32.jar:6.0.32] >> at java.lang.Thread.run(Thread.java:662) [na:1.6.0_23] >> DEBUG 08-10 07:54:02.341 BackupExport.java 149217 535 >> org.openmeetings.servlet.outputhandler.BackupExport [http-0.0.0.0-5080-1] - >> Error exporting: java.lang.NullPointerException >> java.lang.NullPointerException >> at >> org.openmeetings.servlet.outputhandler.BackupExport.createOrgRoomsDocument(BackupExport.java:1394) >> at >> org.openmeetings.servlet.outputhandler.BackupExport.service(BackupExport.java:244) >> at >> org.openmeetings.servlet.outputhandler.BackupExportFacade.service(BackupExportFacade.java:70) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> at >> org.openmeetings.servlet.outputhandler.ServletRequestExFilter.doFilter(ServletRequestExFilter.java:31) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> at >> org.red5.logging.LoggerContextFilter.doFilter(LoggerContextFilter.java:78) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> at >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) >> at >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) >> at >> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470) >> at >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) >> at >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) >> at >> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:554) >> at >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) >> at >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) >> at >> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) >> at >> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) >> at >> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) >> at java.lang.Thread.run(Thread.java:662) >> DEBUG 08-10 07:55:06.581 MeetingReminderJob.java 213457 16 >> org.openmeetings.app.quartz.scheduler.MeetingReminderJob >> [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-1] - >> MeetingReminderJob.execute >> DEBUG 08-10 07:55:06.583 AppointmentDaoImpl.java 213459 905 >> org.openmeetings.app.data.calendar.daos.AppointmentDaoImpl >> [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-1] - >> startStamp 2012-08-10 07:55:06.583 >> DEBUG 08-10 07:55:06.583 AppointmentDaoImpl.java 213459 906 >> org.openmeetings.app.data.calendar.daos.AppointmentDaoImpl >> [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-1] - >> stopStamp 2012-08-10 08:10:06.583 >> DEBUG 08-10 07:55:06.587 AppointmentLogic.java 213463 386 >> org.openmeetings.app.data.calendar.management.AppointmentLogic >> [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-1] - >> doScheduledMeetingReminder : no Appointments in range >> >> ================= >> error.log >> >> [main] WARN o.a.a.transport.http.AxisServlet - No transportReceiver for >> org.apache.axis2.transport.http.AxisServletListener found. An instance for >> HTTP will be configured automatically. Please update your axis2.xml file! >> >> >> >> Pe 10.08.2012 07:47, Maxim Solodovnik a scris: >> >> can you can OM in debug mode (using red5-debug.sh(bat)) >> And check error log? >> >> One of rooms.xml or users.xml file should be /empty/incomplete and log >> should contain exception. >> Based on the exception I can try to tell you what need to be changed in >> the DB to bypass it. >> >> What DB are you using? >> >> On Fri, Aug 10, 2012 at 11:27 AM, Geo <[email protected]> wrote: >> >>> No exceptions >>> >>> Pe 10.08.2012 04:15, Maxim Solodovnik a scris: >>> >>> Do you have any exceptions in the log? >>> Your backup seems to fain in the middle >>> On Aug 10, 2012 2:10 AM, "Geo" <[email protected]> wrote: >>> >>>> Hello >>>> >>>> I want make a backup using interface, but all i get is a blank page >>>> after i press the backup button. >>>> Anyway in webapps/openmeetings/upload/backup/backup_{date} folder i >>>> found 3 xml file (organizations.xml rooms.xml users.xml). How can i >>>> import this files in openmeetings 2? >>>> >>>> If i zip those 3 files and then import is OK? >>>> >>>> Thank you, >>>> Geo >>>> >>> >>> >> >> >> -- >> WBR >> Maxim aka solomax >> >> >> > > > -- > WBR > Maxim aka solomax >
