You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by Jean-Marie Landri <je...@gmail.com> on 2013/12/29 09:54:27 UTC
custome image button
Hello,
Trying to add 2 image button to direct edit the profile settings and the
contact and messages/ -
but the link doesnt work, where am i rong?
code-
<image name="contact_message_icon" resource="contact_message_icon" x="10"
y="0" height="40" width="40">
onclick="this.parent.storeSettings();">
<handler name="onclick">
canvas.userSettingsModuleOpt = "userProfile";
quicklinkActAct("_editUserContacts");
</handler>
<labelTooltip labelid="1259" />
</image>
<image name="user_profile_icon" resource="user_profile_icon" x="10" y="0"
height="40" width="40">
onclick="this.parent.storeSettings();">
<handler name="onclick">
canvas.userSettingsModuleOpt = "userProfile";
quicklinkAct("_editUserProfile");
</handler>
<labelTooltip labelid="377" />
</image>
Thank you?
Re: custome image button
Posted by Maxim Solodovnik <so...@gmail.com>.
code pasted is not valid XML
this line
*onclick="this.parent.storeSettings();">*
seems to be redundant
On Sun, Dec 29, 2013 at 3:54 PM, Jean-Marie Landri <
jeanmarielandri@gmail.com> wrote:
> Hello,
> Trying to add 2 image button to direct edit the profile settings and the
> contact and messages/ -
> but the link doesnt work, where am i rong?
> code-
>
> <image name="contact_message_icon" resource="contact_message_icon"
> x="10" y="0" height="40" width="40">
> onclick="this.parent.storeSettings();">
> <handler name="onclick">
> canvas.userSettingsModuleOpt = "userProfile";
> quicklinkActAct("_editUserContacts");
> </handler>
> <labelTooltip labelid="1259" />
> </image>
>
>
>
> <image name="user_profile_icon" resource="user_profile_icon" x="10" y="0"
> height="40" width="40">
> onclick="this.parent.storeSettings();">
> <handler name="onclick">
> canvas.userSettingsModuleOpt = "userProfile";
> quicklinkAct("_editUserProfile");
> </handler>
> <labelTooltip labelid="377" />
>
> </image>
>
> Thank you?
>
>
--
WBR
Maxim aka solomax
RE: OpenMeetings 2.2.0 - Changing http port from 5080 to 80
Posted by George Kirkham <gk...@co2crc.com.au>.
Maxim
Thanks for reminding me, I forgot to change the user to a root user (embarrising).
# /etc/init.d/red5 checkports
tcp6 0 0 :::1935 :::* LISTEN 3879/java
tcp6 0 0 :::9999 :::* LISTEN 3879/java
tcp6 0 0 :::80 :::* LISTEN 3879/java
tcp6 0 0 :::45979 :::* LISTEN 3879/java
Thanks,
George Kirkham
From: Maxim Solodovnik [mailto:solomax666@gmail.com]
Sent: Tuesday, 14 January 2014 4:28 PM
To: Openmeetings user-list
Subject: Re: OpenMeetings 2.2.0 - Changing http port from 5080 to 80
Hello George,
Maybe it is permissions issue? (ports below 1024 are only available for root by default)
On Tue, Jan 14, 2014 at 12:25 PM, George Kirkham <gk...@co2crc.com.au> wrote:
Hi,
Have a number of issues getting OpenMeetings 2.2.0 working under a Debian Wheezy server.
Issue #1: I normally run OpenMeetings on port 80 (there is no Apache web server on the Debian Wheezy server), but when I change the port from 5080 to 80, nothing is listening on port 80, where it was listening under port 5080 before the changes.
Are there other settings that need to be changed ?
Why is OpenMeetings not listening on port 80 after the configuration files have been changed and the server has been restarted. ?
Unable to get the server to listen on port 80.
Checking ports before changing to port 80 (or changing back from port 80 to port 5080)
root@co2om01:~# /etc/init.d/red5 checkports
tcp6 0 0 :::59022 :::* LISTEN 3585/java
tcp6 0 0 :::1935 :::* LISTEN 3585/java
tcp6 0 0 :::9999 :::* LISTEN 3585/java
tcp6 0 0 :::5080 :::* LISTEN 3585/java
Stop OpenMeetings and make changes;
/usr/lib/red5/webapps/openmeetings/config.xml
<red5httpport>80</red5httpport>
----------------------------------------------
/usr/lib/red5/conf/red5.properties
# HTTP
http.port=80
==================================================================================
After making changes start OpenMeetings and check ports
-------------------------------------------------
tcp6 0 0 :::1935 :::* LISTEN 2854/java
tcp6 0 0 :::9999 :::* LISTEN 2854/java
tcp6 0 0 :::53822 :::* LISTEN 2854/java
Thanks,
--
WBR
Maxim aka solomax
Re: OpenMeetings 2.2.0 - Changing http port from 5080 to 80
Posted by Maxim Solodovnik <so...@gmail.com>.
Hello George,
Maybe it is permissions issue? (ports below 1024 are only available for
root by default)
On Tue, Jan 14, 2014 at 12:25 PM, George Kirkham <gk...@co2crc.com.au>wrote:
> Hi,
>
>
>
> Have a number of issues getting OpenMeetings 2.2.0 working under a Debian
> Wheezy server.
>
>
>
> *Issue #1:* I normally run OpenMeetings on port 80 (there is no Apache
> web server on the Debian Wheezy server), but when I change the port from
> 5080 to 80, nothing is listening on port 80, where it was listening under
> port 5080 before the changes.
>
> *Are there other settings that need to be changed ? *
>
> *Why is OpenMeetings not listening on port 80 after the configuration
> files have been changed and the server has been restarted. ?*
>
>
>
> *Unable to get the server to listen on port 80.*
>
> Checking ports before changing to port 80 (or changing back from port 80
> to port 5080)
>
> root@co2om01:~# /etc/init.d/red5 checkports
>
> tcp6 0 0 :::59022 :::*
> LISTEN 3585/java
>
> tcp6 0 0 :::1935 :::*
> LISTEN 3585/java
>
> tcp6 0 0 :::9999 :::*
> LISTEN 3585/java
>
> tcp6 0 0 :::5080 :::*
> LISTEN 3585/java
>
>
>
> *Stop OpenMeetings and make changes;*
>
> /usr/lib/red5/webapps/openmeetings/config.xml
>
> <red5httpport>80</red5httpport>
>
> ----------------------------------------------
>
> /usr/lib/red5/conf/red5.properties
>
> # HTTP
>
> http.port=80
>
>
>
>
> *==================================================================================*
>
> *After making changes start OpenMeetings and check ports*
>
> -------------------------------------------------
>
> tcp6 0 0 :::1935 :::*
> LISTEN 2854/java
>
> tcp6 0 0 :::9999 :::*
> LISTEN 2854/java
>
> tcp6 0 0 :::53822 :::*
> LISTEN 2854/java
>
>
>
>
>
> Thanks,
>
--
WBR
Maxim aka solomax
Re: OpenMeetings 2.2.0 - Error on users table when importing from
OpenMeetings 2.0
Posted by Maxim Solodovnik <so...@gmail.com>.
sure:
./admin.sh -v -b --exclude-files
On Thu, Jan 16, 2014 at 12:34 PM, George Kirkham <gk...@co2crc.com.au>wrote:
> Maxim,
>
>
>
> Is there a way to use the command line backup to create a backup file
> without uploaded files and recordings ?
>
> http://openmeetings.apache.org/CommandLineAdmin.html
>
>
>
> I did use the OpenMeetings export feature and created a backup file using
> this method and received the same results (and privately emailed this to
> you).
>
>
>
>
>
> Thanks,
>
>
>
> George Kirkham
>
>
>
>
>
>
>
> *From:* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Sent:* Thursday, 16 January 2014 3:35 PM
> *To:* Openmeetings user-list
> *Subject:* Re: OpenMeetings 2.2.0 - Error on users table when importing
> from OpenMeetings 2.0
>
>
>
> Is it possible to get your backup file (without recordings) privately so I
> can debug it?
>
> Unfortunately error reports from simple-xml are not very informative :(
>
>
>
> On Thu, Jan 16, 2014 at 10:55 AM, George Kirkham <gk...@co2crc.com.au>
> wrote:
>
> Hi Maxim,
>
>
>
> Still issues with the install import.
>
>
>
> Below are the results for running;
>
> ./admin.sh -v -i -file omProd20140114.zip
>
>
>
>
>
> ======================================================================
>
> This is a bit more information about the Debian Wheezy’s Java environment
>
>
>
> /usr/lib/red5# java -version
>
> java version "1.6.0_32"
>
> Java(TM) SE Runtime Environment (build 1.6.0_32-b05)
>
> Java HotSpot(TM) 64-Bit Server VM (build 20.7-b02, mixed mode)
>
>
>
> Using mysql-connector-java-5.1.28.tar.gz, extracted and copied to;
>
>
> /usr/lib/red5/webapps/openmeetings/WEB-INF/lib/mysql-connector-java-5.1.28-bin.jar
>
>
>
> ======================================================================
>
> ./admin script's report to terminal window
>
> DEBUG 01-16 14:22:40.203 ImportInitvalues.java 41191 521
> org.apache.openmeetings.installation.ImportInitvalues [main] - RoomTypes
> ADDED
>
> DEBUG 01-16 14:22:40.879 ImportInitvalues.java 41867 499
> org.apache.openmeetings.installation.ImportInitvalues [main] -
> Configuration ADDED
>
> DEBUG 01-16 14:22:40.880 BackupImportController.java 41868 201
> org.apache.openmeetings.servlet.outputhandler.BackupImportController [main]
> - ##### WRITE FILE TO:
> /usr/lib/red5/webapps/openmeetings/upload/import/import_2014_01_16_14_22_40
>
> INFO 01-16 14:24:29.853 BackupImportController.java 150841 240
> org.apache.openmeetings.servlet.outputhandler.BackupImportController [main]
> - Organizations import complete, starting user import
>
> [ERROR] [main] org.apache.openmeetings.cli.Admin - Restore failed
>
> java.lang.NullPointerException: null
>
> at
> org.simpleframework.xml.convert.Reference.getType(Reference.java:70)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Factory.getOverride(Factory.java:143)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.ObjectFactory.getInstance(ObjectFactory.java:63)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at org.simpleframework.xml.core.Composite.read(Composite.java:139)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.readVariable(Composite.java:623)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.readInstance(Composite.java:573)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.readUnion(Composite.java:549)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.readElement(Composite.java:532)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.readElements(Composite.java:445)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.access$400(Composite.java:59)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite$Builder.read(Composite.java:1383)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at org.simpleframework.xml.core.Composite.read(Composite.java:201)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at org.simpleframework.xml.core.Composite.read(Composite.java:148)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at org.simpleframework.xml.core.Traverser.read(Traverser.java:92)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at org.simpleframework.xml.core.Persister.read(Persister.java:625)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at org.simpleframework.xml.core.Persister.read(Persister.java:606)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at org.simpleframework.xml.core.Persister.read(Persister.java:584)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.apache.openmeetings.servlet.outputhandler.BackupImportController.readUserList(BackupImportController.java:737)
> ~[openmeetings-2.2.0-RELEASE.jar:na]
>
> at
> org.apache.openmeetings.servlet.outputhandler.BackupImportController.readUserList(BackupImportController.java:691)
> ~[openmeetings-2.2.0-RELEASE.jar:na]
>
> at
> org.apache.openmeetings.servlet.outputhandler.BackupImportController.performImport(BackupImportController.java:245)
> ~[openmeetings-2.2.0-RELEASE.jar:na]
>
> at org.apache.openmeetings.cli.Admin.restoreOm(Admin.java:623)
> [openmeetings-2.2.0-RELEASE.jar:na]
>
> at org.apache.openmeetings.cli.Admin.process(Admin.java:269)
> [openmeetings-2.2.0-RELEASE.jar:na]
>
> at org.apache.openmeetings.cli.Admin.main(Admin.java:630)
> [openmeetings-2.2.0-RELEASE.jar:na]
>
>
>
>
>
>
> =========================================================================================================
>
> /usr/lib/red5/log/red5.log
>
> 2014-01-16 14:22:01,808 [main] INFO o.s.c.s.DefaultLifecycleProcessor -
> Starting beans in phase 2147483647
>
> 2014-01-16 14:22:01,809 [main] INFO o.s.s.quartz.SchedulerFactoryBean -
> Starting Quartz Scheduler now
>
> 2014-01-16 14:22:01,809 [main] INFO org.quartz.core.QuartzScheduler -
> Scheduler
> org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED
> started.
>
> 2014-01-16 14:22:01,810 [main] INFO org.quartz.core.QuartzScheduler -
> Scheduler
> org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED
> shutting down.
>
> 2014-01-16 14:22:01,810 [main] INFO org.quartz.core.QuartzScheduler -
> Scheduler
> org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED
> paused.
>
> 2014-01-16 14:22:01,810 [main] INFO org.quartz.core.QuartzScheduler -
> Scheduler
> org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED
> shutdown complete.
>
> 2014-01-16 14:22:05,699 [main] WARN o.a.o.data.conference.dao.SipDao -
> There is no Asterisk configured
>
> 2014-01-16 14:24:30,324 [main] ERROR org.apache.openmeetings.cli.Admin -
> Restore failed
>
> java.lang.NullPointerException: null
>
> at
> org.simpleframework.xml.convert.Reference.getType(Reference.java:70)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Factory.getOverride(Factory.java:143)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.ObjectFactory.getInstance(ObjectFactory.java:63)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.read(Composite.java:139)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.readVariable(Composite.java:623)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.readInstance(Composite.java:573)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.readUnion(Composite.java:549)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.readElement(Composite.java:532)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.readElements(Composite.java:445)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.access$400(Composite.java:59)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite$Builder.read(Composite.java:1383)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.read(Composite.java:201)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.read(Composite.java:148)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Traverser.read(Traverser.java:92)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Persister.read(Persister.java:625)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Persister.read(Persister.java:606)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Persister.read(Persister.java:584)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.apache.openmeetings.servlet.outputhandler.BackupImportController.readUserList(BackupImportController.java:737)
> ~[openmeetings-2.2.0-RELEASE.jar:na]
>
> at
> org.apache.openmeetings.servlet.outputhandler.BackupImportController.readUserList(BackupImportController.java:691)
> ~[openmeetings-2.2.0-RELEASE.jar:na]
>
> at
> org.apache.openmeetings.servlet.outputhandler.BackupImportController.performImport(BackupImportController.java:245)
> ~[openmeetings-2.2.0-RELEASE.jar:na]
>
> at
> org.apache.openmeetings.cli.Admin.restoreOm(Admin.java:623)
> [openmeetings-2.2.0-RELEASE.jar:na]
>
> at
> org.apache.openmeetings.cli.Admin.process(Admin.java:269)
> [openmeetings-2.2.0-RELEASE.jar:na]
>
> at org.apache.openmeetings.cli.Admin.main(Admin.java:630)
> [openmeetings-2.2.0-RELEASE.jar:na]
>
>
>
> ===========================================================================
>
> /usr/lib/red5/log/openmeetings.log
>
> DEBUG 01-16 14:22:39.695 o.a.o.i.ImportInitvalues:975 [main] - All
> languages are imported
>
> DEBUG 01-16 14:22:39.868 o.a.o.i.ImportInitvalues:260 [main] - Salutations
> ADDED
>
> DEBUG 01-16 14:22:39.868 o.a.o.i.ImportInitvalues:838 [main] -
> ImportInitValues.loadInitAppointmentCategories
>
> INFO 01-16 14:22:39.894 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info:
> No USER_ID given
>
> DEBUG 01-16 14:22:39.914 o.a.o.i.ImportInitvalues:858 [main] -
> ImportInitValues.loadInitAppointmentReminderTypes
>
> INFO 01-16 14:22:39.920 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info:
> No USER_ID given
>
> INFO 01-16 14:22:39.933 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info:
> No USER_ID given
>
> INFO 01-16 14:22:39.943 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info:
> No USER_ID given
>
> DEBUG 01-16 14:22:40.023 o.a.o.i.ImportInitvalues:505 [main] -
> conference_Id: 1
>
> DEBUG 01-16 14:22:40.117 o.a.o.i.ImportInitvalues:512 [main] -
> restricted_Id: 3
>
> DEBUG 01-16 14:22:40.151 o.a.o.i.ImportInitvalues:516 [main] -
> interview_Id: 4
>
> DEBUG 01-16 14:22:40.203 o.a.o.i.ImportInitvalues:521 [main] - RoomTypes
> ADDED
>
> DEBUG 01-16 14:22:40.879 o.a.o.i.ImportInitvalues:499 [main] -
> Configuration ADDED
>
> DEBUG 01-16 14:22:40.880 o.a.o.s.o.BackupImportController:201 [main] -
> ##### WRITE FILE TO:
> /usr/lib/red5/webapps/openmeetings/upload/import/import_2014_01_16_14_22_40
>
> INFO 01-16 14:24:29.853 o.a.o.s.o.BackupImportController:240 [main] -
> Organizations import complete, starting user import
>
> ===========================================================================
>
>
>
> Thanks,
>
>
>
> George Kirkham
>
>
>
>
>
> *From:* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Sent:* Tuesday, 14 January 2014 5:48 PM
> *To:* Openmeetings user-list
> *Subject:* Re: OpenMeetings 2.2.0 - Error on users table when importing
> from OpenMeetings 2.0
>
>
>
> Could you please run
>
> ./admin.sh -v -i -file omProd20140114.zip
>
> instead of
>
> ./admin.sh -i -file omProd20140114.zip
>
>
>
> and provide the output?
>
>
>
> On Tue, Jan 14, 2014 at 12:41 PM, George Kirkham <gk...@co2crc.com.au>
> wrote:
>
> Hi,
>
>
>
> Have a number of issues getting OpenMeetings 2.2.0 working under a Debian
> Wheezy server.
>
>
>
> *Issue #2:* I attempted to backup our OpenMeetings 2.0 server and do a
> install with the backup on the new OpenMeetings 2.2.0 Debian Wheezy server
> that I have built. The upgrade/install from the backup file seems to be
> failing on importing the user table. Checking the user table, the new
> OpenMeetings 2.2.0 has both a different table name (om_user) and
> different database columns to that of the OpenMeetings 2.0 version (users),
> which may be a cause of the issue?
>
> Is there an easy way to move users (userid, names, contact details and
> their passwords) from the old server to the new server?
>
>
>
> http://openmeetings.apache.org/Upgrade.html
>
>
>
> Step 1 stop the production OpenMeetings 2.0 server and perform the back up
>
> # ./admin.sh -b -file omProd20140114.zip
>
>
>
> Step 2 copy the backup file omProd20140114.zip to the new OpenMeetings
> 2.2.0 server
>
>
>
> Step 3 Change to the /usr/lib/red5 directory (OpenMeetings is not running)
> and run
>
> # ./admin.sh -i -file omProd20140114.zip
>
>
>
> This produces the following errors
>
> Error output to the screen;
>
>
>
> [INFO] [main] org.quartz.core.QuartzScheduler - Scheduler
> org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED
> shutdown complete.
>
> DEBUG 01-14 09:30:47.633 BackupImportController.java 2694 201
> org.apache.openmeetings.servlet.outputhandler.BackupImportController [main]
> - ##### WRITE FILE TO:
> /usr/lib/red5/webapps/openmeetings/upload/import/import_2014_01_14_09_30_47
>
> 88012 openmeetings INFO [main] openjpa.Runtime - Starting OpenJPA 2.2.1
>
> INFO 01-14 09:32:14.996 BackupImportController.java 90057 240
> org.apache.openmeetings.servlet.outputhandler.BackupImportController [main]
> - Organizations import complete, starting user import
>
> [ERROR] [main] org.apache.openmeetings.cli.Admin - Restore failed null
>
>
>
> --------------------------------
>
> /usr/lib/red5/log/red5.log
>
>
>
> 2014-01-14 09:37:32,888 [main] INFO org.quartz.impl.StdSchedulerFactory -
> Quartz scheduler
> 'org.springframework.scheduling.quartz.SchedulerFactoryBean#0' initialized
> from an externally provided properties instance.
>
> 2014-01-14 09:37:32,888 [main] INFO org.quartz.impl.StdSchedulerFactory -
> Quartz scheduler version: 1.8.5
>
> 2014-01-14 09:37:32,889 [main] INFO org.quartz.core.QuartzScheduler -
> JobFactory set to:
> org.springframework.scheduling.quartz.AdaptableJobFactory@5d51fe8a
>
> 2014-01-14 09:37:32,960 [main] INFO o.s.c.s.DefaultLifecycleProcessor -
> Starting beans in phase 2147483647
>
> 2014-01-14 09:37:32,961 [main] INFO o.s.s.quartz.SchedulerFactoryBean -
> Starting Quartz Scheduler now
>
> 2014-01-14 09:37:32,961 [main] INFO org.quartz.core.QuartzScheduler -
> Scheduler
> org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED
> started.
>
> 2014-01-14 09:37:32,962 [main] INFO org.quartz.core.QuartzScheduler -
> Scheduler
> org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED
> shutting down.
>
> 2014-01-14 09:37:32,962 [main] INFO org.quartz.core.QuartzScheduler -
> Scheduler
> org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED
> paused.
>
> 2014-01-14 09:37:32,962 [main] INFO org.quartz.core.QuartzScheduler -
> Scheduler
> org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED
> shutdown complete.
>
> 2014-01-14 09:37:34,331 [main] WARN o.a.o.data.conference.dao.SipDao -
> There is no Asterisk configured
>
> 2014-01-14 09:42:26,908 [main] ERROR org.apache.openmeetings.cli.Admin - Restore
> failed null
>
>
>
> ----------------------------------------------------
>
> /usr/lib/red5/log/openmeetings.log
>
>
>
> DEBUG 01-14 09:37:45.320 o.a.o.i.ImportInitvalues:962 [main] - Lang ADDED:
> org.apache.openmeetings.persistence.beans.lang.FieldLanguage@59dac7d;
> seconds passed: 0
>
> DEBUG 01-14 09:37:45.320 o.a.o.i.ImportInitvalues:975 [main] - All
> languages are imported
>
> DEBUG 01-14 09:37:45.345 o.a.o.i.ImportInitvalues:260 [main] - Salutations
> ADDED
>
> DEBUG 01-14 09:37:45.345 o.a.o.i.ImportInitvalues:838 [main] -
> ImportInitValues.loadInitAppointmentCategories
>
> INFO 01-14 09:37:45.354 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info:
> No USER_ID given
>
> DEBUG 01-14 09:37:45.359 o.a.o.i.ImportInitvalues:858 [main] -
> ImportInitValues.loadInitAppointmentReminderTypes
>
> INFO 01-14 09:37:45.373 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info:
> No USER_ID given
>
> INFO 01-14 09:37:45.381 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info:
> No USER_ID given
>
> INFO 01-14 09:37:45.384 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info:
> No USER_ID given
>
> DEBUG 01-14 09:37:45.441 o.a.o.i.ImportInitvalues:505 [main] -
> conference_Id: 16
>
> DEBUG 01-14 09:37:45.446 o.a.o.i.ImportInitvalues:512 [main] -
> restricted_Id: 18
>
> DEBUG 01-14 09:37:45.448 o.a.o.i.ImportInitvalues:516 [main] -
> interview_Id: 19
>
> DEBUG 01-14 09:37:45.450 o.a.o.i.ImportInitvalues:521 [main] - RoomTypes
> ADDED
>
> DEBUG 01-14 09:37:45.537 o.a.o.i.ImportInitvalues:499 [main] -
> Configuration ADDED
>
> DEBUG 01-14 09:37:45.539 o.a.o.s.o.BackupImportController:201 [main] -
> ##### WRITE FILE TO:
> /usr/lib/red5/webapps/openmeetings/upload/import/import_2014_01_14_09_37_45
>
> INFO 01-14 09:42:26.669 o.a.o.s.o.BackupImportController:240 [main] - Organizations
> import complete, starting user import
>
>
>
>
>
> mysql> show tables;
>
> +-------------------------+
>
> | Tables_in_openmeetings |
>
> +-------------------------+
>
> | address |
>
> | appointmentcategory |
>
> | appointmentremindertyps |
>
> | appointments |
>
> | chat |
>
> | client |
>
> | conferencelog |
>
> | conferencelogtype |
>
> | configuration |
>
> | email_queue |
>
> | errortypes |
>
> | errorvalue |
>
> | fieldlanguage |
>
> | fieldlanguagesvalues |
>
> | fieldvalues |
>
> | fileexploreritem |
>
> | flvrecording |
>
> | flvrecording_log |
>
> | flvrecording_meta_delta |
>
> | flvrecording_metadata |
>
> | invitations |
>
> | ldapconfig |
>
> | meeting_members |
>
> | naviglobal |
>
> | navimain |
>
> | om_timezone |
>
> | om_user |
>
> | organisation |
>
> | organisation_users |
>
> | poll_types |
>
> | private_message |
>
> | private_messages_folder |
>
> | room |
>
> | room_poll_answers |
>
> | room_polls |
>
> | rooms_moderator |
>
> | rooms_organisation |
>
> | roomtype |
>
> | salutation |
>
> | server |
>
> | sessiondata |
>
> | sipusers |
>
> | soaplogin |
>
> | state |
>
> | user_contact |
>
> | user_data |
>
> | user_level |
>
> | whiteboard |
>
> | whiteboard_item |
>
> +-------------------------+
>
> 49 rows in set (0.00 sec)
>
>
>
>
>
> =========================================================
>
>
>
> mysql> show tables;
>
> +-------------------------+
>
> | Tables_in_openmeetings |
>
> +-------------------------+
>
> | OPENJPA_SEQUENCE_TABLE |
>
> | adresses |
>
> | appointmentcategory |
>
> | appointmentremindertyps |
>
> | appointments |
>
> | conferencelog |
>
> | conferencelogtype |
>
> | configuration |
>
> | errortypes |
>
> | errorvalues |
>
> | extensions |
>
> | fieldlanguage |
>
> | fieldlanguagesvalues |
>
> | fieldvalues |
>
> | fileexploreritem |
>
> | flvrecording |
>
> | flvrecording_log |
>
> | flvrecording_meta_delta |
>
> | flvrecording_metadata |
>
> | invitations |
>
> | ldapconfig |
>
> | meeting_members |
>
> | meetme |
>
> | naviglobal |
>
> | navimain |
>
> | om_timezone |
>
> | open_xg_return_object |
>
> | organisation |
>
> | organisation_users |
>
> | poll_types |
>
> | private_messages |
>
> | private_messages_folder |
>
> | room_poll_answers |
>
> | room_polls |
>
> | rooms |
>
> | rooms_moderator |
>
> | rooms_organisation |
>
> | roomtypes |
>
> | salutations |
>
> | sessiondata |
>
> | sipusers |
>
> | soaplogin |
>
> | states |
>
> | user_contacts |
>
> | user_sip_data |
>
> | userdata |
>
> | userlevel |
>
> | users |
>
> +-------------------------+
>
> 48 rows in set (0.00 sec)
>
>
>
> =================================================
>
>
>
> mysql> show columns from om_user;
>
>
> +-------------------------------+--------------+------+-----+---------+----------------+
>
> | Field | Type | Null | Key | Default |
> Extra |
>
>
> +-------------------------------+--------------+------+-----+---------+----------------+
>
> | id | bigint(20) | NO | PRI | NULL |
> auto_increment |
>
> | activatehash | varchar(255) | YES | | NULL
> | |
>
> | age | datetime | YES | | NULL
> | |
>
> | availible | int(11) | YES | | NULL
> | |
>
> | deleted | bit(1) | YES | | NULL
> | |
>
> | externalUserId | varchar(255) | YES | | NULL
> | |
>
> | externalUserType | varchar(255) | YES | | NULL
> | |
>
> | firstname | varchar(255) | YES | | NULL
> | |
>
> | forceTimeZoneCheck | bit(1) | YES | | NULL
> | |
>
> | language_id | bigint(20) | YES | | NULL
> | |
>
> | lastlogin | datetime | YES | | NULL
> | |
>
> | lastname | varchar(255) | YES | | NULL
> | |
>
> | lasttrans | bigint(20) | YES | | NULL
> | |
>
> | level_id | bigint(20) | YES | | NULL
> | |
>
> | login | varchar(255) | YES | | NULL
> | |
>
> | password | varchar(255) | YES | | NULL
> | |
>
> | pictureuri | varchar(255) | YES | | NULL
> | |
>
> | regdate | datetime | YES | | NULL
> | |
>
> | resethash | varchar(255) | YES | | NULL
> | |
>
> | salutations_id | bigint(20) | YES | | NULL
> | |
>
> | sendSMS | bit(1) | YES | | NULL
> | |
>
> | show_contact_data | bit(1) | YES | | NULL
> | |
>
> | show_contact_data_to_contacts | bit(1) | YES | | NULL
> | |
>
> | starttime | datetime | YES | | NULL
> | |
>
> | status | int(11) | YES | | NULL
> | |
>
> | updatetime | datetime | YES | | NULL
> | |
>
> | user_offers | varchar(255) | YES | | NULL
> | |
>
> | user_searchs | varchar(255) | YES | | NULL
> | |
>
> | adresses_id | bigint(20) | YES | MUL | NULL
> | |
>
> | omtimezoneId | bigint(20) | YES | MUL | NULL
> | |
>
> | sip_user_id | bigint(20) | YES | MUL | NULL
> | |
>
>
> +-------------------------------+--------------+------+-----+---------+----------------+
>
> 31 rows in set (0.01 sec)
>
>
>
> =============================================================
>
> Old Users
>
> mysql> show columns from users;
>
>
> +-------------------------------+--------------+------+-----+---------+----------------+
>
> | Field | Type | Null | Key | Default |
> Extra |
>
>
> +-------------------------------+--------------+------+-----+---------+----------------+
>
> | user_id | bigint(20) | NO | PRI | NULL |
> auto_increment |
>
> | activatehash | varchar(255) | YES | | NULL
> | |
>
> | age | datetime | YES | | NULL
> | |
>
> | availible | int(11) | YES | | NULL
> | |
>
> | deleted | varchar(255) | YES | | NULL
> | |
>
> | externalUserId | varchar(255) | YES | | NULL
> | |
>
> | externalUserType | varchar(255) | YES | | NULL
> | |
>
> | firstname | varchar(255) | YES | | NULL
> | |
>
> | forceTimeZoneCheck | bit(1) | YES | | NULL
> | |
>
> | language_id | bigint(20) | YES | | NULL
> | |
>
> | lastlogin | datetime | YES | | NULL
> | |
>
> | lastname | varchar(255) | YES | | NULL
> | |
>
> | lasttrans | bigint(20) | YES | | NULL
> | |
>
> | level_id | bigint(20) | YES | | NULL
> | |
>
> | login | varchar(255) | YES | | NULL
> | |
>
> | password | varchar(255) | YES | | NULL
> | |
>
> | pictureuri | varchar(255) | YES | | NULL
> | |
>
> | regdate | datetime | YES | | NULL
> | |
>
> | resethash | varchar(255) | YES | | NULL
> | |
>
> | show_contact_data | bit(1) | YES | | NULL
> | |
>
> | show_contact_data_to_contacts | bit(1) | YES | | NULL
> | |
>
> | starttime | datetime | YES | | NULL
> | |
>
> | status | int(11) | YES | | NULL
> | |
>
> | title_id | int(11) | YES | | NULL
> | |
>
> | updatetime | datetime | YES | | NULL
> | |
>
> | user_offers | varchar(255) | YES | | NULL
> | |
>
> | user_searchs | varchar(255) | YES | | NULL
> | |
>
> | adresses_id | bigint(20) | YES | MUL | NULL
> | |
>
> | omtimezoneId | bigint(20) | YES | MUL | NULL
> | |
>
> | userSipDataId | bigint(20) | YES | MUL | NULL
> | |
>
>
> +-------------------------------+--------------+------+-----+---------+----------------+
>
> 30 rows in set (0.00 sec)
>
>
>
>
>
>
> ==================================================================================
>
>
>
> Thanks,
>
>
>
> George Kirkham
>
>
>
>
>
> --
> WBR
> Maxim aka solomax
>
>
>
>
>
> --
> WBR
> Maxim aka solomax
>
--
WBR
Maxim aka solomax
RE: OpenMeetings 2.2.0 - Error on users table when importing from OpenMeetings 2.0
Posted by George Kirkham <gk...@co2crc.com.au>.
Maxim,
Is there a way to use the command line backup to create a backup file without uploaded files and recordings ?
http://openmeetings.apache.org/CommandLineAdmin.html
I did use the OpenMeetings export feature and created a backup file using this method and received the same results (and privately emailed this to you).
Thanks,
George Kirkham
From: Maxim Solodovnik [mailto:solomax666@gmail.com]
Sent: Thursday, 16 January 2014 3:35 PM
To: Openmeetings user-list
Subject: Re: OpenMeetings 2.2.0 - Error on users table when importing from OpenMeetings 2.0
Is it possible to get your backup file (without recordings) privately so I can debug it?
Unfortunately error reports from simple-xml are not very informative :(
On Thu, Jan 16, 2014 at 10:55 AM, George Kirkham <gk...@co2crc.com.au> wrote:
Hi Maxim,
Still issues with the install import.
Below are the results for running;
./admin.sh -v -i -file omProd20140114.zip
======================================================================
This is a bit more information about the Debian Wheezy’s Java environment
/usr/lib/red5# java -version
java version "1.6.0_32"
Java(TM) SE Runtime Environment (build 1.6.0_32-b05)
Java HotSpot(TM) 64-Bit Server VM (build 20.7-b02, mixed mode)
Using mysql-connector-java-5.1.28.tar.gz, extracted and copied to;
/usr/lib/red5/webapps/openmeetings/WEB-INF/lib/mysql-connector-java-5.1.28-bin.jar
======================================================================
./admin script's report to terminal window
DEBUG 01-16 14:22:40.203 ImportInitvalues.java 41191 521 org.apache.openmeetings.installation.ImportInitvalues [main] - RoomTypes ADDED
DEBUG 01-16 14:22:40.879 ImportInitvalues.java 41867 499 org.apache.openmeetings.installation.ImportInitvalues [main] - Configuration ADDED
DEBUG 01-16 14:22:40.880 BackupImportController.java 41868 201 org.apache.openmeetings.servlet.outputhandler.BackupImportController [main] - ##### WRITE FILE TO: /usr/lib/red5/webapps/openmeetings/upload/import/import_2014_01_16_14_22_40
INFO 01-16 14:24:29.853 BackupImportController.java 150841 240 org.apache.openmeetings.servlet.outputhandler.BackupImportController [main] - Organizations import complete, starting user import
[ERROR] [main] org.apache.openmeetings.cli.Admin - Restore failed
java.lang.NullPointerException: null
at org.simpleframework.xml.convert.Reference.getType(Reference.java:70) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Factory.getOverride(Factory.java:143) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.ObjectFactory.getInstance(ObjectFactory.java:63) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.read(Composite.java:139) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.readVariable(Composite.java:623) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.readInstance(Composite.java:573) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.readUnion(Composite.java:549) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.readElement(Composite.java:532) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.readElements(Composite.java:445) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.access$400(Composite.java:59) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite$Builder.read(Composite.java:1383) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.read(Composite.java:201) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.read(Composite.java:148) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Traverser.read(Traverser.java:92) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Persister.read(Persister.java:625) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Persister.read(Persister.java:606) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Persister.read(Persister.java:584) ~[simple-xml-jar-2.6.9.jar:na]
at org.apache.openmeetings.servlet.outputhandler.BackupImportController.readUserList(BackupImportController.java:737) ~[openmeetings-2.2.0-RELEASE.jar:na]
at org.apache.openmeetings.servlet.outputhandler.BackupImportController.readUserList(BackupImportController.java:691) ~[openmeetings-2.2.0-RELEASE.jar:na]
at org.apache.openmeetings.servlet.outputhandler.BackupImportController.performImport(BackupImportController.java:245) ~[openmeetings-2.2.0-RELEASE.jar:na]
at org.apache.openmeetings.cli.Admin.restoreOm(Admin.java:623) [openmeetings-2.2.0-RELEASE.jar:na]
at org.apache.openmeetings.cli.Admin.process(Admin.java:269) [openmeetings-2.2.0-RELEASE.jar:na]
at org.apache.openmeetings.cli.Admin.main(Admin.java:630) [openmeetings-2.2.0-RELEASE.jar:na]
=========================================================================================================
/usr/lib/red5/log/red5.log
2014-01-16 14:22:01,808 [main] INFO o.s.c.s.DefaultLifecycleProcessor - Starting beans in phase 2147483647
2014-01-16 14:22:01,809 [main] INFO o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now
2014-01-16 14:22:01,809 [main] INFO org.quartz.core.QuartzScheduler - Scheduler org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED started.
2014-01-16 14:22:01,810 [main] INFO org.quartz.core.QuartzScheduler - Scheduler org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED shutting down.
2014-01-16 14:22:01,810 [main] INFO org.quartz.core.QuartzScheduler - Scheduler org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED paused.
2014-01-16 14:22:01,810 [main] INFO org.quartz.core.QuartzScheduler - Scheduler org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED shutdown complete.
2014-01-16 14:22:05,699 [main] WARN o.a.o.data.conference.dao.SipDao - There is no Asterisk configured
2014-01-16 14:24:30,324 [main] ERROR org.apache.openmeetings.cli.Admin - Restore failed
java.lang.NullPointerException: null
at org.simpleframework.xml.convert.Reference.getType(Reference.java:70) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Factory.getOverride(Factory.java:143) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.ObjectFactory.getInstance(ObjectFactory.java:63) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.read(Composite.java:139) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.readVariable(Composite.java:623) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.readInstance(Composite.java:573) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.readUnion(Composite.java:549) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.readElement(Composite.java:532) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.readElements(Composite.java:445) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.access$400(Composite.java:59) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite$Builder.read(Composite.java:1383) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.read(Composite.java:201) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.read(Composite.java:148) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Traverser.read(Traverser.java:92) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Persister.read(Persister.java:625) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Persister.read(Persister.java:606) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Persister.read(Persister.java:584) ~[simple-xml-jar-2.6.9.jar:na]
at org.apache.openmeetings.servlet.outputhandler.BackupImportController.readUserList(BackupImportController.java:737) ~[openmeetings-2.2.0-RELEASE.jar:na]
at org.apache.openmeetings.servlet.outputhandler.BackupImportController.readUserList(BackupImportController.java:691) ~[openmeetings-2.2.0-RELEASE.jar:na]
at org.apache.openmeetings.servlet.outputhandler.BackupImportController.performImport(BackupImportController.java:245) ~[openmeetings-2.2.0-RELEASE.jar:na]
at org.apache.openmeetings.cli.Admin.restoreOm(Admin.java:623) [openmeetings-2.2.0-RELEASE.jar:na]
at org.apache.openmeetings.cli.Admin.process(Admin.java:269) [openmeetings-2.2.0-RELEASE.jar:na]
at org.apache.openmeetings.cli.Admin.main(Admin.java:630) [openmeetings-2.2.0-RELEASE.jar:na]
===========================================================================
/usr/lib/red5/log/openmeetings.log
DEBUG 01-16 14:22:39.695 o.a.o.i.ImportInitvalues:975 [main] - All languages are imported
DEBUG 01-16 14:22:39.868 o.a.o.i.ImportInitvalues:260 [main] - Salutations ADDED
DEBUG 01-16 14:22:39.868 o.a.o.i.ImportInitvalues:838 [main] - ImportInitValues.loadInitAppointmentCategories
INFO 01-16 14:22:39.894 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info: No USER_ID given
DEBUG 01-16 14:22:39.914 o.a.o.i.ImportInitvalues:858 [main] - ImportInitValues.loadInitAppointmentReminderTypes
INFO 01-16 14:22:39.920 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info: No USER_ID given
INFO 01-16 14:22:39.933 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info: No USER_ID given
INFO 01-16 14:22:39.943 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info: No USER_ID given
DEBUG 01-16 14:22:40.023 o.a.o.i.ImportInitvalues:505 [main] - conference_Id: 1
DEBUG 01-16 14:22:40.117 o.a.o.i.ImportInitvalues:512 [main] - restricted_Id: 3
DEBUG 01-16 14:22:40.151 o.a.o.i.ImportInitvalues:516 [main] - interview_Id: 4
DEBUG 01-16 14:22:40.203 o.a.o.i.ImportInitvalues:521 [main] - RoomTypes ADDED
DEBUG 01-16 14:22:40.879 o.a.o.i.ImportInitvalues:499 [main] - Configuration ADDED
DEBUG 01-16 14:22:40.880 o.a.o.s.o.BackupImportController:201 [main] - ##### WRITE FILE TO: /usr/lib/red5/webapps/openmeetings/upload/import/import_2014_01_16_14_22_40
INFO 01-16 14:24:29.853 o.a.o.s.o.BackupImportController:240 [main] - Organizations import complete, starting user import
===========================================================================
Thanks,
George Kirkham
From: Maxim Solodovnik [mailto:solomax666@gmail.com]
Sent: Tuesday, 14 January 2014 5:48 PM
To: Openmeetings user-list
Subject: Re: OpenMeetings 2.2.0 - Error on users table when importing from OpenMeetings 2.0
Could you please run
./admin.sh -v -i -file omProd20140114.zip
instead of
./admin.sh -i -file omProd20140114.zip
and provide the output?
On Tue, Jan 14, 2014 at 12:41 PM, George Kirkham <gk...@co2crc.com.au> wrote:
Hi,
Have a number of issues getting OpenMeetings 2.2.0 working under a Debian Wheezy server.
Issue #2: I attempted to backup our OpenMeetings 2.0 server and do a install with the backup on the new OpenMeetings 2.2.0 Debian Wheezy server that I have built. The upgrade/install from the backup file seems to be failing on importing the user table. Checking the user table, the new OpenMeetings 2.2.0 has both a different table name (om_user) and different database columns to that of the OpenMeetings 2.0 version (users), which may be a cause of the issue?
Is there an easy way to move users (userid, names, contact details and their passwords) from the old server to the new server?
http://openmeetings.apache.org/Upgrade.html
Step 1 stop the production OpenMeetings 2.0 server and perform the back up
# ./admin.sh -b -file omProd20140114.zip
Step 2 copy the backup file omProd20140114.zip to the new OpenMeetings 2.2.0 server
Step 3 Change to the /usr/lib/red5 directory (OpenMeetings is not running) and run
# ./admin.sh -i -file omProd20140114.zip
This produces the following errors
Error output to the screen;
[INFO] [main] org.quartz.core.QuartzScheduler - Scheduler org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED shutdown complete.
DEBUG 01-14 09:30:47.633 BackupImportController.java 2694 201 org.apache.openmeetings.servlet.outputhandler.BackupImportController [main] - ##### WRITE FILE TO: /usr/lib/red5/webapps/openmeetings/upload/import/import_2014_01_14_09_30_47
88012 openmeetings INFO [main] openjpa.Runtime - Starting OpenJPA 2.2.1
INFO 01-14 09:32:14.996 BackupImportController.java 90057 240 org.apache.openmeetings.servlet.outputhandler.BackupImportController [main] - Organizations import complete, starting user import
[ERROR] [main] org.apache.openmeetings.cli.Admin - Restore failed null
--------------------------------
/usr/lib/red5/log/red5.log
2014-01-14 09:37:32,888 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'org.springframework.scheduling.quartz.SchedulerFactoryBean#0' initialized from an externally provided properties instance.
2014-01-14 09:37:32,888 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 1.8.5
2014-01-14 09:37:32,889 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@5d51fe8a
2014-01-14 09:37:32,960 [main] INFO o.s.c.s.DefaultLifecycleProcessor - Starting beans in phase 2147483647
2014-01-14 09:37:32,961 [main] INFO o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now
2014-01-14 09:37:32,961 [main] INFO org.quartz.core.QuartzScheduler - Scheduler org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED started.
2014-01-14 09:37:32,962 [main] INFO org.quartz.core.QuartzScheduler - Scheduler org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED shutting down.
2014-01-14 09:37:32,962 [main] INFO org.quartz.core.QuartzScheduler - Scheduler org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED paused.
2014-01-14 09:37:32,962 [main] INFO org.quartz.core.QuartzScheduler - Scheduler org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED shutdown complete.
2014-01-14 09:37:34,331 [main] WARN o.a.o.data.conference.dao.SipDao - There is no Asterisk configured
2014-01-14 09:42:26,908 [main] ERROR org.apache.openmeetings.cli.Admin - Restore failed null
----------------------------------------------------
/usr/lib/red5/log/openmeetings.log
DEBUG 01-14 09:37:45.320 o.a.o.i.ImportInitvalues:962 [main] - Lang ADDED: org.apache.openmeetings.persistence.beans.lang.FieldLanguage@59dac7d; seconds passed: 0
DEBUG 01-14 09:37:45.320 o.a.o.i.ImportInitvalues:975 [main] - All languages are imported
DEBUG 01-14 09:37:45.345 o.a.o.i.ImportInitvalues:260 [main] - Salutations ADDED
DEBUG 01-14 09:37:45.345 o.a.o.i.ImportInitvalues:838 [main] - ImportInitValues.loadInitAppointmentCategories
INFO 01-14 09:37:45.354 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info: No USER_ID given
DEBUG 01-14 09:37:45.359 o.a.o.i.ImportInitvalues:858 [main] - ImportInitValues.loadInitAppointmentReminderTypes
INFO 01-14 09:37:45.373 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info: No USER_ID given
INFO 01-14 09:37:45.381 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info: No USER_ID given
INFO 01-14 09:37:45.384 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info: No USER_ID given
DEBUG 01-14 09:37:45.441 o.a.o.i.ImportInitvalues:505 [main] - conference_Id: 16
DEBUG 01-14 09:37:45.446 o.a.o.i.ImportInitvalues:512 [main] - restricted_Id: 18
DEBUG 01-14 09:37:45.448 o.a.o.i.ImportInitvalues:516 [main] - interview_Id: 19
DEBUG 01-14 09:37:45.450 o.a.o.i.ImportInitvalues:521 [main] - RoomTypes ADDED
DEBUG 01-14 09:37:45.537 o.a.o.i.ImportInitvalues:499 [main] - Configuration ADDED
DEBUG 01-14 09:37:45.539 o.a.o.s.o.BackupImportController:201 [main] - ##### WRITE FILE TO: /usr/lib/red5/webapps/openmeetings/upload/import/import_2014_01_14_09_37_45
INFO 01-14 09:42:26.669 o.a.o.s.o.BackupImportController:240 [main] - Organizations import complete, starting user import
mysql> show tables;
+-------------------------+
| Tables_in_openmeetings |
+-------------------------+
| address |
| appointmentcategory |
| appointmentremindertyps |
| appointments |
| chat |
| client |
| conferencelog |
| conferencelogtype |
| configuration |
| email_queue |
| errortypes |
| errorvalue |
| fieldlanguage |
| fieldlanguagesvalues |
| fieldvalues |
| fileexploreritem |
| flvrecording |
| flvrecording_log |
| flvrecording_meta_delta |
| flvrecording_metadata |
| invitations |
| ldapconfig |
| meeting_members |
| naviglobal |
| navimain |
| om_timezone |
| om_user |
| organisation |
| organisation_users |
| poll_types |
| private_message |
| private_messages_folder |
| room |
| room_poll_answers |
| room_polls |
| rooms_moderator |
| rooms_organisation |
| roomtype |
| salutation |
| server |
| sessiondata |
| sipusers |
| soaplogin |
| state |
| user_contact |
| user_data |
| user_level |
| whiteboard |
| whiteboard_item |
+-------------------------+
49 rows in set (0.00 sec)
=========================================================
mysql> show tables;
+-------------------------+
| Tables_in_openmeetings |
+-------------------------+
| OPENJPA_SEQUENCE_TABLE |
| adresses |
| appointmentcategory |
| appointmentremindertyps |
| appointments |
| conferencelog |
| conferencelogtype |
| configuration |
| errortypes |
| errorvalues |
| extensions |
| fieldlanguage |
| fieldlanguagesvalues |
| fieldvalues |
| fileexploreritem |
| flvrecording |
| flvrecording_log |
| flvrecording_meta_delta |
| flvrecording_metadata |
| invitations |
| ldapconfig |
| meeting_members |
| meetme |
| naviglobal |
| navimain |
| om_timezone |
| open_xg_return_object |
| organisation |
| organisation_users |
| poll_types |
| private_messages |
| private_messages_folder |
| room_poll_answers |
| room_polls |
| rooms |
| rooms_moderator |
| rooms_organisation |
| roomtypes |
| salutations |
| sessiondata |
| sipusers |
| soaplogin |
| states |
| user_contacts |
| user_sip_data |
| userdata |
| userlevel |
| users |
+-------------------------+
48 rows in set (0.00 sec)
=================================================
mysql> show columns from om_user;
+-------------------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------------------+--------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| activatehash | varchar(255) | YES | | NULL | |
| age | datetime | YES | | NULL | |
| availible | int(11) | YES | | NULL | |
| deleted | bit(1) | YES | | NULL | |
| externalUserId | varchar(255) | YES | | NULL | |
| externalUserType | varchar(255) | YES | | NULL | |
| firstname | varchar(255) | YES | | NULL | |
| forceTimeZoneCheck | bit(1) | YES | | NULL | |
| language_id | bigint(20) | YES | | NULL | |
| lastlogin | datetime | YES | | NULL | |
| lastname | varchar(255) | YES | | NULL | |
| lasttrans | bigint(20) | YES | | NULL | |
| level_id | bigint(20) | YES | | NULL | |
| login | varchar(255) | YES | | NULL | |
| password | varchar(255) | YES | | NULL | |
| pictureuri | varchar(255) | YES | | NULL | |
| regdate | datetime | YES | | NULL | |
| resethash | varchar(255) | YES | | NULL | |
| salutations_id | bigint(20) | YES | | NULL | |
| sendSMS | bit(1) | YES | | NULL | |
| show_contact_data | bit(1) | YES | | NULL | |
| show_contact_data_to_contacts | bit(1) | YES | | NULL | |
| starttime | datetime | YES | | NULL | |
| status | int(11) | YES | | NULL | |
| updatetime | datetime | YES | | NULL | |
| user_offers | varchar(255) | YES | | NULL | |
| user_searchs | varchar(255) | YES | | NULL | |
| adresses_id | bigint(20) | YES | MUL | NULL | |
| omtimezoneId | bigint(20) | YES | MUL | NULL | |
| sip_user_id | bigint(20) | YES | MUL | NULL | |
+-------------------------------+--------------+------+-----+---------+----------------+
31 rows in set (0.01 sec)
=============================================================
Old Users
mysql> show columns from users;
+-------------------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------------------+--------------+------+-----+---------+----------------+
| user_id | bigint(20) | NO | PRI | NULL | auto_increment |
| activatehash | varchar(255) | YES | | NULL | |
| age | datetime | YES | | NULL | |
| availible | int(11) | YES | | NULL | |
| deleted | varchar(255) | YES | | NULL | |
| externalUserId | varchar(255) | YES | | NULL | |
| externalUserType | varchar(255) | YES | | NULL | |
| firstname | varchar(255) | YES | | NULL | |
| forceTimeZoneCheck | bit(1) | YES | | NULL | |
| language_id | bigint(20) | YES | | NULL | |
| lastlogin | datetime | YES | | NULL | |
| lastname | varchar(255) | YES | | NULL | |
| lasttrans | bigint(20) | YES | | NULL | |
| level_id | bigint(20) | YES | | NULL | |
| login | varchar(255) | YES | | NULL | |
| password | varchar(255) | YES | | NULL | |
| pictureuri | varchar(255) | YES | | NULL | |
| regdate | datetime | YES | | NULL | |
| resethash | varchar(255) | YES | | NULL | |
| show_contact_data | bit(1) | YES | | NULL | |
| show_contact_data_to_contacts | bit(1) | YES | | NULL | |
| starttime | datetime | YES | | NULL | |
| status | int(11) | YES | | NULL | |
| title_id | int(11) | YES | | NULL | |
| updatetime | datetime | YES | | NULL | |
| user_offers | varchar(255) | YES | | NULL | |
| user_searchs | varchar(255) | YES | | NULL | |
| adresses_id | bigint(20) | YES | MUL | NULL | |
| omtimezoneId | bigint(20) | YES | MUL | NULL | |
| userSipDataId | bigint(20) | YES | MUL | NULL | |
+-------------------------------+--------------+------+-----+---------+----------------+
30 rows in set (0.00 sec)
==================================================================================
Thanks,
George Kirkham
--
WBR
Maxim aka solomax
--
WBR
Maxim aka solomax
Re: OpenMeetings 2.2.0 - Error on users table when importing from
OpenMeetings 2.0
Posted by Maxim Solodovnik <so...@gmail.com>.
Is it possible to get your backup file (without recordings) privately so I
can debug it?
Unfortunately error reports from simple-xml are not very informative :(
On Thu, Jan 16, 2014 at 10:55 AM, George Kirkham <gk...@co2crc.com.au>wrote:
> Hi Maxim,
>
>
>
> Still issues with the install import.
>
>
>
> Below are the results for running;
>
> ./admin.sh -v -i -file omProd20140114.zip
>
>
>
>
>
> ======================================================================
>
> This is a bit more information about the Debian Wheezy’s Java environment
>
>
>
> /usr/lib/red5# java -version
>
> java version "1.6.0_32"
>
> Java(TM) SE Runtime Environment (build 1.6.0_32-b05)
>
> Java HotSpot(TM) 64-Bit Server VM (build 20.7-b02, mixed mode)
>
>
>
> Using mysql-connector-java-5.1.28.tar.gz, extracted and copied to;
>
>
> /usr/lib/red5/webapps/openmeetings/WEB-INF/lib/mysql-connector-java-5.1.28-bin.jar
>
>
>
> ======================================================================
>
> ./admin script's report to terminal window
>
> DEBUG 01-16 14:22:40.203 ImportInitvalues.java 41191 521
> org.apache.openmeetings.installation.ImportInitvalues [main] - RoomTypes
> ADDED
>
> DEBUG 01-16 14:22:40.879 ImportInitvalues.java 41867 499
> org.apache.openmeetings.installation.ImportInitvalues [main] -
> Configuration ADDED
>
> DEBUG 01-16 14:22:40.880 BackupImportController.java 41868 201
> org.apache.openmeetings.servlet.outputhandler.BackupImportController [main]
> - ##### WRITE FILE TO:
> /usr/lib/red5/webapps/openmeetings/upload/import/import_2014_01_16_14_22_40
>
> INFO 01-16 14:24:29.853 BackupImportController.java 150841 240
> org.apache.openmeetings.servlet.outputhandler.BackupImportController [main]
> - Organizations import complete, starting user import
>
> [ERROR] [main] org.apache.openmeetings.cli.Admin - Restore failed
>
> java.lang.NullPointerException: null
>
> at
> org.simpleframework.xml.convert.Reference.getType(Reference.java:70)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Factory.getOverride(Factory.java:143)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.ObjectFactory.getInstance(ObjectFactory.java:63)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at org.simpleframework.xml.core.Composite.read(Composite.java:139)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.readVariable(Composite.java:623)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.readInstance(Composite.java:573)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.readUnion(Composite.java:549)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.readElement(Composite.java:532)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.readElements(Composite.java:445)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.access$400(Composite.java:59)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite$Builder.read(Composite.java:1383)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at org.simpleframework.xml.core.Composite.read(Composite.java:201)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at org.simpleframework.xml.core.Composite.read(Composite.java:148)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at org.simpleframework.xml.core.Traverser.read(Traverser.java:92)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at org.simpleframework.xml.core.Persister.read(Persister.java:625)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at org.simpleframework.xml.core.Persister.read(Persister.java:606)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at org.simpleframework.xml.core.Persister.read(Persister.java:584)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.apache.openmeetings.servlet.outputhandler.BackupImportController.readUserList(BackupImportController.java:737)
> ~[openmeetings-2.2.0-RELEASE.jar:na]
>
> at
> org.apache.openmeetings.servlet.outputhandler.BackupImportController.readUserList(BackupImportController.java:691)
> ~[openmeetings-2.2.0-RELEASE.jar:na]
>
> at
> org.apache.openmeetings.servlet.outputhandler.BackupImportController.performImport(BackupImportController.java:245)
> ~[openmeetings-2.2.0-RELEASE.jar:na]
>
> at org.apache.openmeetings.cli.Admin.restoreOm(Admin.java:623)
> [openmeetings-2.2.0-RELEASE.jar:na]
>
> at org.apache.openmeetings.cli.Admin.process(Admin.java:269)
> [openmeetings-2.2.0-RELEASE.jar:na]
>
> at org.apache.openmeetings.cli.Admin.main(Admin.java:630)
> [openmeetings-2.2.0-RELEASE.jar:na]
>
>
>
>
>
>
> =========================================================================================================
>
> /usr/lib/red5/log/red5.log
>
> 2014-01-16 14:22:01,808 [main] INFO o.s.c.s.DefaultLifecycleProcessor -
> Starting beans in phase 2147483647
>
> 2014-01-16 14:22:01,809 [main] INFO o.s.s.quartz.SchedulerFactoryBean -
> Starting Quartz Scheduler now
>
> 2014-01-16 14:22:01,809 [main] INFO org.quartz.core.QuartzScheduler -
> Scheduler
> org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED
> started.
>
> 2014-01-16 14:22:01,810 [main] INFO org.quartz.core.QuartzScheduler -
> Scheduler
> org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED
> shutting down.
>
> 2014-01-16 14:22:01,810 [main] INFO org.quartz.core.QuartzScheduler -
> Scheduler
> org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED
> paused.
>
> 2014-01-16 14:22:01,810 [main] INFO org.quartz.core.QuartzScheduler -
> Scheduler
> org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED
> shutdown complete.
>
> 2014-01-16 14:22:05,699 [main] WARN o.a.o.data.conference.dao.SipDao -
> There is no Asterisk configured
>
> 2014-01-16 14:24:30,324 [main] ERROR org.apache.openmeetings.cli.Admin -
> Restore failed
>
> java.lang.NullPointerException: null
>
> at
> org.simpleframework.xml.convert.Reference.getType(Reference.java:70)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Factory.getOverride(Factory.java:143)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.ObjectFactory.getInstance(ObjectFactory.java:63)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.read(Composite.java:139)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.readVariable(Composite.java:623)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.readInstance(Composite.java:573)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.readUnion(Composite.java:549)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.readElement(Composite.java:532)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.readElements(Composite.java:445)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.access$400(Composite.java:59)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite$Builder.read(Composite.java:1383)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.read(Composite.java:201)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Composite.read(Composite.java:148)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Traverser.read(Traverser.java:92)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Persister.read(Persister.java:625)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Persister.read(Persister.java:606)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.simpleframework.xml.core.Persister.read(Persister.java:584)
> ~[simple-xml-jar-2.6.9.jar:na]
>
> at
> org.apache.openmeetings.servlet.outputhandler.BackupImportController.readUserList(BackupImportController.java:737)
> ~[openmeetings-2.2.0-RELEASE.jar:na]
>
> at
> org.apache.openmeetings.servlet.outputhandler.BackupImportController.readUserList(BackupImportController.java:691)
> ~[openmeetings-2.2.0-RELEASE.jar:na]
>
> at
> org.apache.openmeetings.servlet.outputhandler.BackupImportController.performImport(BackupImportController.java:245)
> ~[openmeetings-2.2.0-RELEASE.jar:na]
>
> at
> org.apache.openmeetings.cli.Admin.restoreOm(Admin.java:623)
> [openmeetings-2.2.0-RELEASE.jar:na]
>
> at
> org.apache.openmeetings.cli.Admin.process(Admin.java:269)
> [openmeetings-2.2.0-RELEASE.jar:na]
>
> at org.apache.openmeetings.cli.Admin.main(Admin.java:630)
> [openmeetings-2.2.0-RELEASE.jar:na]
>
>
>
> ===========================================================================
>
> /usr/lib/red5/log/openmeetings.log
>
> DEBUG 01-16 14:22:39.695 o.a.o.i.ImportInitvalues:975 [main] - All
> languages are imported
>
> DEBUG 01-16 14:22:39.868 o.a.o.i.ImportInitvalues:260 [main] - Salutations
> ADDED
>
> DEBUG 01-16 14:22:39.868 o.a.o.i.ImportInitvalues:838 [main] -
> ImportInitValues.loadInitAppointmentCategories
>
> INFO 01-16 14:22:39.894 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info:
> No USER_ID given
>
> DEBUG 01-16 14:22:39.914 o.a.o.i.ImportInitvalues:858 [main] -
> ImportInitValues.loadInitAppointmentReminderTypes
>
> INFO 01-16 14:22:39.920 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info:
> No USER_ID given
>
> INFO 01-16 14:22:39.933 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info:
> No USER_ID given
>
> INFO 01-16 14:22:39.943 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info:
> No USER_ID given
>
> DEBUG 01-16 14:22:40.023 o.a.o.i.ImportInitvalues:505 [main] -
> conference_Id: 1
>
> DEBUG 01-16 14:22:40.117 o.a.o.i.ImportInitvalues:512 [main] -
> restricted_Id: 3
>
> DEBUG 01-16 14:22:40.151 o.a.o.i.ImportInitvalues:516 [main] -
> interview_Id: 4
>
> DEBUG 01-16 14:22:40.203 o.a.o.i.ImportInitvalues:521 [main] - RoomTypes
> ADDED
>
> DEBUG 01-16 14:22:40.879 o.a.o.i.ImportInitvalues:499 [main] -
> Configuration ADDED
>
> DEBUG 01-16 14:22:40.880 o.a.o.s.o.BackupImportController:201 [main] -
> ##### WRITE FILE TO:
> /usr/lib/red5/webapps/openmeetings/upload/import/import_2014_01_16_14_22_40
>
> INFO 01-16 14:24:29.853 o.a.o.s.o.BackupImportController:240 [main] -
> Organizations import complete, starting user import
>
> ===========================================================================
>
>
>
> Thanks,
>
>
>
> George Kirkham
>
>
>
>
>
> *From:* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Sent:* Tuesday, 14 January 2014 5:48 PM
> *To:* Openmeetings user-list
> *Subject:* Re: OpenMeetings 2.2.0 - Error on users table when importing
> from OpenMeetings 2.0
>
>
>
> Could you please run
>
> ./admin.sh -v -i -file omProd20140114.zip
>
> instead of
>
> ./admin.sh -i -file omProd20140114.zip
>
>
>
> and provide the output?
>
>
>
> On Tue, Jan 14, 2014 at 12:41 PM, George Kirkham <gk...@co2crc.com.au>
> wrote:
>
> Hi,
>
>
>
> Have a number of issues getting OpenMeetings 2.2.0 working under a Debian
> Wheezy server.
>
>
>
> *Issue #2:* I attempted to backup our OpenMeetings 2.0 server and do a
> install with the backup on the new OpenMeetings 2.2.0 Debian Wheezy server
> that I have built. The upgrade/install from the backup file seems to be
> failing on importing the user table. Checking the user table, the new
> OpenMeetings 2.2.0 has both a different table name (om_user) and
> different database columns to that of the OpenMeetings 2.0 version (users),
> which may be a cause of the issue?
>
> Is there an easy way to move users (userid, names, contact details and
> their passwords) from the old server to the new server?
>
>
>
> http://openmeetings.apache.org/Upgrade.html
>
>
>
> Step 1 stop the production OpenMeetings 2.0 server and perform the back up
>
> # ./admin.sh -b -file omProd20140114.zip
>
>
>
> Step 2 copy the backup file omProd20140114.zip to the new OpenMeetings
> 2.2.0 server
>
>
>
> Step 3 Change to the /usr/lib/red5 directory (OpenMeetings is not running)
> and run
>
> # ./admin.sh -i -file omProd20140114.zip
>
>
>
> This produces the following errors
>
> Error output to the screen;
>
>
>
> [INFO] [main] org.quartz.core.QuartzScheduler - Scheduler
> org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED
> shutdown complete.
>
> DEBUG 01-14 09:30:47.633 BackupImportController.java 2694 201
> org.apache.openmeetings.servlet.outputhandler.BackupImportController [main]
> - ##### WRITE FILE TO:
> /usr/lib/red5/webapps/openmeetings/upload/import/import_2014_01_14_09_30_47
>
> 88012 openmeetings INFO [main] openjpa.Runtime - Starting OpenJPA 2.2.1
>
> INFO 01-14 09:32:14.996 BackupImportController.java 90057 240
> org.apache.openmeetings.servlet.outputhandler.BackupImportController [main]
> - Organizations import complete, starting user import
>
> [ERROR] [main] org.apache.openmeetings.cli.Admin - Restore failed null
>
>
>
> --------------------------------
>
> /usr/lib/red5/log/red5.log
>
>
>
> 2014-01-14 09:37:32,888 [main] INFO org.quartz.impl.StdSchedulerFactory -
> Quartz scheduler
> 'org.springframework.scheduling.quartz.SchedulerFactoryBean#0' initialized
> from an externally provided properties instance.
>
> 2014-01-14 09:37:32,888 [main] INFO org.quartz.impl.StdSchedulerFactory -
> Quartz scheduler version: 1.8.5
>
> 2014-01-14 09:37:32,889 [main] INFO org.quartz.core.QuartzScheduler -
> JobFactory set to:
> org.springframework.scheduling.quartz.AdaptableJobFactory@5d51fe8a
>
> 2014-01-14 09:37:32,960 [main] INFO o.s.c.s.DefaultLifecycleProcessor -
> Starting beans in phase 2147483647
>
> 2014-01-14 09:37:32,961 [main] INFO o.s.s.quartz.SchedulerFactoryBean -
> Starting Quartz Scheduler now
>
> 2014-01-14 09:37:32,961 [main] INFO org.quartz.core.QuartzScheduler -
> Scheduler
> org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED
> started.
>
> 2014-01-14 09:37:32,962 [main] INFO org.quartz.core.QuartzScheduler -
> Scheduler
> org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED
> shutting down.
>
> 2014-01-14 09:37:32,962 [main] INFO org.quartz.core.QuartzScheduler -
> Scheduler
> org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED
> paused.
>
> 2014-01-14 09:37:32,962 [main] INFO org.quartz.core.QuartzScheduler -
> Scheduler
> org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED
> shutdown complete.
>
> 2014-01-14 09:37:34,331 [main] WARN o.a.o.data.conference.dao.SipDao -
> There is no Asterisk configured
>
> 2014-01-14 09:42:26,908 [main] ERROR org.apache.openmeetings.cli.Admin - Restore
> failed null
>
>
>
> ----------------------------------------------------
>
> /usr/lib/red5/log/openmeetings.log
>
>
>
> DEBUG 01-14 09:37:45.320 o.a.o.i.ImportInitvalues:962 [main] - Lang ADDED:
> org.apache.openmeetings.persistence.beans.lang.FieldLanguage@59dac7d;
> seconds passed: 0
>
> DEBUG 01-14 09:37:45.320 o.a.o.i.ImportInitvalues:975 [main] - All
> languages are imported
>
> DEBUG 01-14 09:37:45.345 o.a.o.i.ImportInitvalues:260 [main] - Salutations
> ADDED
>
> DEBUG 01-14 09:37:45.345 o.a.o.i.ImportInitvalues:838 [main] -
> ImportInitValues.loadInitAppointmentCategories
>
> INFO 01-14 09:37:45.354 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info:
> No USER_ID given
>
> DEBUG 01-14 09:37:45.359 o.a.o.i.ImportInitvalues:858 [main] -
> ImportInitValues.loadInitAppointmentReminderTypes
>
> INFO 01-14 09:37:45.373 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info:
> No USER_ID given
>
> INFO 01-14 09:37:45.381 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info:
> No USER_ID given
>
> INFO 01-14 09:37:45.384 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info:
> No USER_ID given
>
> DEBUG 01-14 09:37:45.441 o.a.o.i.ImportInitvalues:505 [main] -
> conference_Id: 16
>
> DEBUG 01-14 09:37:45.446 o.a.o.i.ImportInitvalues:512 [main] -
> restricted_Id: 18
>
> DEBUG 01-14 09:37:45.448 o.a.o.i.ImportInitvalues:516 [main] -
> interview_Id: 19
>
> DEBUG 01-14 09:37:45.450 o.a.o.i.ImportInitvalues:521 [main] - RoomTypes
> ADDED
>
> DEBUG 01-14 09:37:45.537 o.a.o.i.ImportInitvalues:499 [main] -
> Configuration ADDED
>
> DEBUG 01-14 09:37:45.539 o.a.o.s.o.BackupImportController:201 [main] -
> ##### WRITE FILE TO:
> /usr/lib/red5/webapps/openmeetings/upload/import/import_2014_01_14_09_37_45
>
> INFO 01-14 09:42:26.669 o.a.o.s.o.BackupImportController:240 [main] - Organizations
> import complete, starting user import
>
>
>
>
>
> mysql> show tables;
>
> +-------------------------+
>
> | Tables_in_openmeetings |
>
> +-------------------------+
>
> | address |
>
> | appointmentcategory |
>
> | appointmentremindertyps |
>
> | appointments |
>
> | chat |
>
> | client |
>
> | conferencelog |
>
> | conferencelogtype |
>
> | configuration |
>
> | email_queue |
>
> | errortypes |
>
> | errorvalue |
>
> | fieldlanguage |
>
> | fieldlanguagesvalues |
>
> | fieldvalues |
>
> | fileexploreritem |
>
> | flvrecording |
>
> | flvrecording_log |
>
> | flvrecording_meta_delta |
>
> | flvrecording_metadata |
>
> | invitations |
>
> | ldapconfig |
>
> | meeting_members |
>
> | naviglobal |
>
> | navimain |
>
> | om_timezone |
>
> | om_user |
>
> | organisation |
>
> | organisation_users |
>
> | poll_types |
>
> | private_message |
>
> | private_messages_folder |
>
> | room |
>
> | room_poll_answers |
>
> | room_polls |
>
> | rooms_moderator |
>
> | rooms_organisation |
>
> | roomtype |
>
> | salutation |
>
> | server |
>
> | sessiondata |
>
> | sipusers |
>
> | soaplogin |
>
> | state |
>
> | user_contact |
>
> | user_data |
>
> | user_level |
>
> | whiteboard |
>
> | whiteboard_item |
>
> +-------------------------+
>
> 49 rows in set (0.00 sec)
>
>
>
>
>
> =========================================================
>
>
>
> mysql> show tables;
>
> +-------------------------+
>
> | Tables_in_openmeetings |
>
> +-------------------------+
>
> | OPENJPA_SEQUENCE_TABLE |
>
> | adresses |
>
> | appointmentcategory |
>
> | appointmentremindertyps |
>
> | appointments |
>
> | conferencelog |
>
> | conferencelogtype |
>
> | configuration |
>
> | errortypes |
>
> | errorvalues |
>
> | extensions |
>
> | fieldlanguage |
>
> | fieldlanguagesvalues |
>
> | fieldvalues |
>
> | fileexploreritem |
>
> | flvrecording |
>
> | flvrecording_log |
>
> | flvrecording_meta_delta |
>
> | flvrecording_metadata |
>
> | invitations |
>
> | ldapconfig |
>
> | meeting_members |
>
> | meetme |
>
> | naviglobal |
>
> | navimain |
>
> | om_timezone |
>
> | open_xg_return_object |
>
> | organisation |
>
> | organisation_users |
>
> | poll_types |
>
> | private_messages |
>
> | private_messages_folder |
>
> | room_poll_answers |
>
> | room_polls |
>
> | rooms |
>
> | rooms_moderator |
>
> | rooms_organisation |
>
> | roomtypes |
>
> | salutations |
>
> | sessiondata |
>
> | sipusers |
>
> | soaplogin |
>
> | states |
>
> | user_contacts |
>
> | user_sip_data |
>
> | userdata |
>
> | userlevel |
>
> | users |
>
> +-------------------------+
>
> 48 rows in set (0.00 sec)
>
>
>
> =================================================
>
>
>
> mysql> show columns from om_user;
>
>
> +-------------------------------+--------------+------+-----+---------+----------------+
>
> | Field | Type | Null | Key | Default |
> Extra |
>
>
> +-------------------------------+--------------+------+-----+---------+----------------+
>
> | id | bigint(20) | NO | PRI | NULL |
> auto_increment |
>
> | activatehash | varchar(255) | YES | | NULL
> | |
>
> | age | datetime | YES | | NULL
> | |
>
> | availible | int(11) | YES | | NULL
> | |
>
> | deleted | bit(1) | YES | | NULL
> | |
>
> | externalUserId | varchar(255) | YES | | NULL
> | |
>
> | externalUserType | varchar(255) | YES | | NULL
> | |
>
> | firstname | varchar(255) | YES | | NULL
> | |
>
> | forceTimeZoneCheck | bit(1) | YES | | NULL
> | |
>
> | language_id | bigint(20) | YES | | NULL
> | |
>
> | lastlogin | datetime | YES | | NULL
> | |
>
> | lastname | varchar(255) | YES | | NULL
> | |
>
> | lasttrans | bigint(20) | YES | | NULL
> | |
>
> | level_id | bigint(20) | YES | | NULL
> | |
>
> | login | varchar(255) | YES | | NULL
> | |
>
> | password | varchar(255) | YES | | NULL
> | |
>
> | pictureuri | varchar(255) | YES | | NULL
> | |
>
> | regdate | datetime | YES | | NULL
> | |
>
> | resethash | varchar(255) | YES | | NULL
> | |
>
> | salutations_id | bigint(20) | YES | | NULL
> | |
>
> | sendSMS | bit(1) | YES | | NULL
> | |
>
> | show_contact_data | bit(1) | YES | | NULL
> | |
>
> | show_contact_data_to_contacts | bit(1) | YES | | NULL
> | |
>
> | starttime | datetime | YES | | NULL
> | |
>
> | status | int(11) | YES | | NULL
> | |
>
> | updatetime | datetime | YES | | NULL
> | |
>
> | user_offers | varchar(255) | YES | | NULL
> | |
>
> | user_searchs | varchar(255) | YES | | NULL
> | |
>
> | adresses_id | bigint(20) | YES | MUL | NULL
> | |
>
> | omtimezoneId | bigint(20) | YES | MUL | NULL
> | |
>
> | sip_user_id | bigint(20) | YES | MUL | NULL
> | |
>
>
> +-------------------------------+--------------+------+-----+---------+----------------+
>
> 31 rows in set (0.01 sec)
>
>
>
> =============================================================
>
> Old Users
>
> mysql> show columns from users;
>
>
> +-------------------------------+--------------+------+-----+---------+----------------+
>
> | Field | Type | Null | Key | Default |
> Extra |
>
>
> +-------------------------------+--------------+------+-----+---------+----------------+
>
> | user_id | bigint(20) | NO | PRI | NULL |
> auto_increment |
>
> | activatehash | varchar(255) | YES | | NULL
> | |
>
> | age | datetime | YES | | NULL
> | |
>
> | availible | int(11) | YES | | NULL
> | |
>
> | deleted | varchar(255) | YES | | NULL
> | |
>
> | externalUserId | varchar(255) | YES | | NULL
> | |
>
> | externalUserType | varchar(255) | YES | | NULL
> | |
>
> | firstname | varchar(255) | YES | | NULL
> | |
>
> | forceTimeZoneCheck | bit(1) | YES | | NULL
> | |
>
> | language_id | bigint(20) | YES | | NULL
> | |
>
> | lastlogin | datetime | YES | | NULL
> | |
>
> | lastname | varchar(255) | YES | | NULL
> | |
>
> | lasttrans | bigint(20) | YES | | NULL
> | |
>
> | level_id | bigint(20) | YES | | NULL
> | |
>
> | login | varchar(255) | YES | | NULL
> | |
>
> | password | varchar(255) | YES | | NULL
> | |
>
> | pictureuri | varchar(255) | YES | | NULL
> | |
>
> | regdate | datetime | YES | | NULL
> | |
>
> | resethash | varchar(255) | YES | | NULL
> | |
>
> | show_contact_data | bit(1) | YES | | NULL
> | |
>
> | show_contact_data_to_contacts | bit(1) | YES | | NULL
> | |
>
> | starttime | datetime | YES | | NULL
> | |
>
> | status | int(11) | YES | | NULL
> | |
>
> | title_id | int(11) | YES | | NULL
> | |
>
> | updatetime | datetime | YES | | NULL
> | |
>
> | user_offers | varchar(255) | YES | | NULL
> | |
>
> | user_searchs | varchar(255) | YES | | NULL
> | |
>
> | adresses_id | bigint(20) | YES | MUL | NULL
> | |
>
> | omtimezoneId | bigint(20) | YES | MUL | NULL
> | |
>
> | userSipDataId | bigint(20) | YES | MUL | NULL
> | |
>
>
> +-------------------------------+--------------+------+-----+---------+----------------+
>
> 30 rows in set (0.00 sec)
>
>
>
>
>
>
> ==================================================================================
>
>
>
> Thanks,
>
>
>
> George Kirkham
>
>
>
>
>
> --
> WBR
> Maxim aka solomax
>
--
WBR
Maxim aka solomax
RE: OpenMeetings 2.2.0 - Error on users table when importing from OpenMeetings 2.0
Posted by George Kirkham <gk...@co2crc.com.au>.
Hi Maxim,
Still issues with the install import.
Below are the results for running;
./admin.sh -v -i -file omProd20140114.zip
======================================================================
This is a bit more information about the Debian Wheezy’s Java environment
/usr/lib/red5# java -version
java version "1.6.0_32"
Java(TM) SE Runtime Environment (build 1.6.0_32-b05)
Java HotSpot(TM) 64-Bit Server VM (build 20.7-b02, mixed mode)
Using mysql-connector-java-5.1.28.tar.gz, extracted and copied to;
/usr/lib/red5/webapps/openmeetings/WEB-INF/lib/mysql-connector-java-5.1.28-bin.jar
======================================================================
./admin script's report to terminal window
DEBUG 01-16 14:22:40.203 ImportInitvalues.java 41191 521 org.apache.openmeetings.installation.ImportInitvalues [main] - RoomTypes ADDED
DEBUG 01-16 14:22:40.879 ImportInitvalues.java 41867 499 org.apache.openmeetings.installation.ImportInitvalues [main] - Configuration ADDED
DEBUG 01-16 14:22:40.880 BackupImportController.java 41868 201 org.apache.openmeetings.servlet.outputhandler.BackupImportController [main] - ##### WRITE FILE TO: /usr/lib/red5/webapps/openmeetings/upload/import/import_2014_01_16_14_22_40
INFO 01-16 14:24:29.853 BackupImportController.java 150841 240 org.apache.openmeetings.servlet.outputhandler.BackupImportController [main] - Organizations import complete, starting user import
[ERROR] [main] org.apache.openmeetings.cli.Admin - Restore failed
java.lang.NullPointerException: null
at org.simpleframework.xml.convert.Reference.getType(Reference.java:70) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Factory.getOverride(Factory.java:143) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.ObjectFactory.getInstance(ObjectFactory.java:63) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.read(Composite.java:139) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.readVariable(Composite.java:623) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.readInstance(Composite.java:573) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.readUnion(Composite.java:549) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.readElement(Composite.java:532) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.readElements(Composite.java:445) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.access$400(Composite.java:59) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite$Builder.read(Composite.java:1383) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.read(Composite.java:201) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.read(Composite.java:148) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Traverser.read(Traverser.java:92) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Persister.read(Persister.java:625) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Persister.read(Persister.java:606) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Persister.read(Persister.java:584) ~[simple-xml-jar-2.6.9.jar:na]
at org.apache.openmeetings.servlet.outputhandler.BackupImportController.readUserList(BackupImportController.java:737) ~[openmeetings-2.2.0-RELEASE.jar:na]
at org.apache.openmeetings.servlet.outputhandler.BackupImportController.readUserList(BackupImportController.java:691) ~[openmeetings-2.2.0-RELEASE.jar:na]
at org.apache.openmeetings.servlet.outputhandler.BackupImportController.performImport(BackupImportController.java:245) ~[openmeetings-2.2.0-RELEASE.jar:na]
at org.apache.openmeetings.cli.Admin.restoreOm(Admin.java:623) [openmeetings-2.2.0-RELEASE.jar:na]
at org.apache.openmeetings.cli.Admin.process(Admin.java:269) [openmeetings-2.2.0-RELEASE.jar:na]
at org.apache.openmeetings.cli.Admin.main(Admin.java:630) [openmeetings-2.2.0-RELEASE.jar:na]
=========================================================================================================
/usr/lib/red5/log/red5.log
2014-01-16 14:22:01,808 [main] INFO o.s.c.s.DefaultLifecycleProcessor - Starting beans in phase 2147483647
2014-01-16 14:22:01,809 [main] INFO o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now
2014-01-16 14:22:01,809 [main] INFO org.quartz.core.QuartzScheduler - Scheduler org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED started.
2014-01-16 14:22:01,810 [main] INFO org.quartz.core.QuartzScheduler - Scheduler org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED shutting down.
2014-01-16 14:22:01,810 [main] INFO org.quartz.core.QuartzScheduler - Scheduler org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED paused.
2014-01-16 14:22:01,810 [main] INFO org.quartz.core.QuartzScheduler - Scheduler org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED shutdown complete.
2014-01-16 14:22:05,699 [main] WARN o.a.o.data.conference.dao.SipDao - There is no Asterisk configured
2014-01-16 14:24:30,324 [main] ERROR org.apache.openmeetings.cli.Admin - Restore failed
java.lang.NullPointerException: null
at org.simpleframework.xml.convert.Reference.getType(Reference.java:70) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Factory.getOverride(Factory.java:143) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.ObjectFactory.getInstance(ObjectFactory.java:63) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.read(Composite.java:139) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.readVariable(Composite.java:623) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.readInstance(Composite.java:573) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.readUnion(Composite.java:549) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.readElement(Composite.java:532) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.readElements(Composite.java:445) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.access$400(Composite.java:59) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite$Builder.read(Composite.java:1383) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.read(Composite.java:201) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Composite.read(Composite.java:148) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Traverser.read(Traverser.java:92) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Persister.read(Persister.java:625) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Persister.read(Persister.java:606) ~[simple-xml-jar-2.6.9.jar:na]
at org.simpleframework.xml.core.Persister.read(Persister.java:584) ~[simple-xml-jar-2.6.9.jar:na]
at org.apache.openmeetings.servlet.outputhandler.BackupImportController.readUserList(BackupImportController.java:737) ~[openmeetings-2.2.0-RELEASE.jar:na]
at org.apache.openmeetings.servlet.outputhandler.BackupImportController.readUserList(BackupImportController.java:691) ~[openmeetings-2.2.0-RELEASE.jar:na]
at org.apache.openmeetings.servlet.outputhandler.BackupImportController.performImport(BackupImportController.java:245) ~[openmeetings-2.2.0-RELEASE.jar:na]
at org.apache.openmeetings.cli.Admin.restoreOm(Admin.java:623) [openmeetings-2.2.0-RELEASE.jar:na]
at org.apache.openmeetings.cli.Admin.process(Admin.java:269) [openmeetings-2.2.0-RELEASE.jar:na]
at org.apache.openmeetings.cli.Admin.main(Admin.java:630) [openmeetings-2.2.0-RELEASE.jar:na]
===========================================================================
/usr/lib/red5/log/openmeetings.log
DEBUG 01-16 14:22:39.695 o.a.o.i.ImportInitvalues:975 [main] - All languages are imported
DEBUG 01-16 14:22:39.868 o.a.o.i.ImportInitvalues:260 [main] - Salutations ADDED
DEBUG 01-16 14:22:39.868 o.a.o.i.ImportInitvalues:838 [main] - ImportInitValues.loadInitAppointmentCategories
INFO 01-16 14:22:39.894 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info: No USER_ID given
DEBUG 01-16 14:22:39.914 o.a.o.i.ImportInitvalues:858 [main] - ImportInitValues.loadInitAppointmentReminderTypes
INFO 01-16 14:22:39.920 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info: No USER_ID given
INFO 01-16 14:22:39.933 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info: No USER_ID given
INFO 01-16 14:22:39.943 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info: No USER_ID given
DEBUG 01-16 14:22:40.023 o.a.o.i.ImportInitvalues:505 [main] - conference_Id: 1
DEBUG 01-16 14:22:40.117 o.a.o.i.ImportInitvalues:512 [main] - restricted_Id: 3
DEBUG 01-16 14:22:40.151 o.a.o.i.ImportInitvalues:516 [main] - interview_Id: 4
DEBUG 01-16 14:22:40.203 o.a.o.i.ImportInitvalues:521 [main] - RoomTypes ADDED
DEBUG 01-16 14:22:40.879 o.a.o.i.ImportInitvalues:499 [main] - Configuration ADDED
DEBUG 01-16 14:22:40.880 o.a.o.s.o.BackupImportController:201 [main] - ##### WRITE FILE TO: /usr/lib/red5/webapps/openmeetings/upload/import/import_2014_01_16_14_22_40
INFO 01-16 14:24:29.853 o.a.o.s.o.BackupImportController:240 [main] - Organizations import complete, starting user import
===========================================================================
Thanks,
George Kirkham
From: Maxim Solodovnik [mailto:solomax666@gmail.com]
Sent: Tuesday, 14 January 2014 5:48 PM
To: Openmeetings user-list
Subject: Re: OpenMeetings 2.2.0 - Error on users table when importing from OpenMeetings 2.0
Could you please run
./admin.sh -v -i -file omProd20140114.zip
instead of
./admin.sh -i -file omProd20140114.zip
and provide the output?
On Tue, Jan 14, 2014 at 12:41 PM, George Kirkham <gk...@co2crc.com.au> wrote:
Hi,
Have a number of issues getting OpenMeetings 2.2.0 working under a Debian Wheezy server.
Issue #2: I attempted to backup our OpenMeetings 2.0 server and do a install with the backup on the new OpenMeetings 2.2.0 Debian Wheezy server that I have built. The upgrade/install from the backup file seems to be failing on importing the user table. Checking the user table, the new OpenMeetings 2.2.0 has both a different table name (om_user) and different database columns to that of the OpenMeetings 2.0 version (users), which may be a cause of the issue?
Is there an easy way to move users (userid, names, contact details and their passwords) from the old server to the new server?
http://openmeetings.apache.org/Upgrade.html
Step 1 stop the production OpenMeetings 2.0 server and perform the back up
# ./admin.sh -b -file omProd20140114.zip
Step 2 copy the backup file omProd20140114.zip to the new OpenMeetings 2.2.0 server
Step 3 Change to the /usr/lib/red5 directory (OpenMeetings is not running) and run
# ./admin.sh -i -file omProd20140114.zip
This produces the following errors
Error output to the screen;
[INFO] [main] org.quartz.core.QuartzScheduler - Scheduler org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED shutdown complete.
DEBUG 01-14 09:30:47.633 BackupImportController.java 2694 201 org.apache.openmeetings.servlet.outputhandler.BackupImportController [main] - ##### WRITE FILE TO: /usr/lib/red5/webapps/openmeetings/upload/import/import_2014_01_14_09_30_47
88012 openmeetings INFO [main] openjpa.Runtime - Starting OpenJPA 2.2.1
INFO 01-14 09:32:14.996 BackupImportController.java 90057 240 org.apache.openmeetings.servlet.outputhandler.BackupImportController [main] - Organizations import complete, starting user import
[ERROR] [main] org.apache.openmeetings.cli.Admin - Restore failed null
--------------------------------
/usr/lib/red5/log/red5.log
2014-01-14 09:37:32,888 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'org.springframework.scheduling.quartz.SchedulerFactoryBean#0' initialized from an externally provided properties instance.
2014-01-14 09:37:32,888 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 1.8.5
2014-01-14 09:37:32,889 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@5d51fe8a
2014-01-14 09:37:32,960 [main] INFO o.s.c.s.DefaultLifecycleProcessor - Starting beans in phase 2147483647
2014-01-14 09:37:32,961 [main] INFO o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now
2014-01-14 09:37:32,961 [main] INFO org.quartz.core.QuartzScheduler - Scheduler org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED started.
2014-01-14 09:37:32,962 [main] INFO org.quartz.core.QuartzScheduler - Scheduler org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED shutting down.
2014-01-14 09:37:32,962 [main] INFO org.quartz.core.QuartzScheduler - Scheduler org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED paused.
2014-01-14 09:37:32,962 [main] INFO org.quartz.core.QuartzScheduler - Scheduler org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED shutdown complete.
2014-01-14 09:37:34,331 [main] WARN o.a.o.data.conference.dao.SipDao - There is no Asterisk configured
2014-01-14 09:42:26,908 [main] ERROR org.apache.openmeetings.cli.Admin - Restore failed null
----------------------------------------------------
/usr/lib/red5/log/openmeetings.log
DEBUG 01-14 09:37:45.320 o.a.o.i.ImportInitvalues:962 [main] - Lang ADDED: org.apache.openmeetings.persistence.beans.lang.FieldLanguage@59dac7d; seconds passed: 0
DEBUG 01-14 09:37:45.320 o.a.o.i.ImportInitvalues:975 [main] - All languages are imported
DEBUG 01-14 09:37:45.345 o.a.o.i.ImportInitvalues:260 [main] - Salutations ADDED
DEBUG 01-14 09:37:45.345 o.a.o.i.ImportInitvalues:838 [main] - ImportInitValues.loadInitAppointmentCategories
INFO 01-14 09:37:45.354 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info: No USER_ID given
DEBUG 01-14 09:37:45.359 o.a.o.i.ImportInitvalues:858 [main] - ImportInitValues.loadInitAppointmentReminderTypes
INFO 01-14 09:37:45.373 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info: No USER_ID given
INFO 01-14 09:37:45.381 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info: No USER_ID given
INFO 01-14 09:37:45.384 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info: No USER_ID given
DEBUG 01-14 09:37:45.441 o.a.o.i.ImportInitvalues:505 [main] - conference_Id: 16
DEBUG 01-14 09:37:45.446 o.a.o.i.ImportInitvalues:512 [main] - restricted_Id: 18
DEBUG 01-14 09:37:45.448 o.a.o.i.ImportInitvalues:516 [main] - interview_Id: 19
DEBUG 01-14 09:37:45.450 o.a.o.i.ImportInitvalues:521 [main] - RoomTypes ADDED
DEBUG 01-14 09:37:45.537 o.a.o.i.ImportInitvalues:499 [main] - Configuration ADDED
DEBUG 01-14 09:37:45.539 o.a.o.s.o.BackupImportController:201 [main] - ##### WRITE FILE TO: /usr/lib/red5/webapps/openmeetings/upload/import/import_2014_01_14_09_37_45
INFO 01-14 09:42:26.669 o.a.o.s.o.BackupImportController:240 [main] - Organizations import complete, starting user import
mysql> show tables;
+-------------------------+
| Tables_in_openmeetings |
+-------------------------+
| address |
| appointmentcategory |
| appointmentremindertyps |
| appointments |
| chat |
| client |
| conferencelog |
| conferencelogtype |
| configuration |
| email_queue |
| errortypes |
| errorvalue |
| fieldlanguage |
| fieldlanguagesvalues |
| fieldvalues |
| fileexploreritem |
| flvrecording |
| flvrecording_log |
| flvrecording_meta_delta |
| flvrecording_metadata |
| invitations |
| ldapconfig |
| meeting_members |
| naviglobal |
| navimain |
| om_timezone |
| om_user |
| organisation |
| organisation_users |
| poll_types |
| private_message |
| private_messages_folder |
| room |
| room_poll_answers |
| room_polls |
| rooms_moderator |
| rooms_organisation |
| roomtype |
| salutation |
| server |
| sessiondata |
| sipusers |
| soaplogin |
| state |
| user_contact |
| user_data |
| user_level |
| whiteboard |
| whiteboard_item |
+-------------------------+
49 rows in set (0.00 sec)
=========================================================
mysql> show tables;
+-------------------------+
| Tables_in_openmeetings |
+-------------------------+
| OPENJPA_SEQUENCE_TABLE |
| adresses |
| appointmentcategory |
| appointmentremindertyps |
| appointments |
| conferencelog |
| conferencelogtype |
| configuration |
| errortypes |
| errorvalues |
| extensions |
| fieldlanguage |
| fieldlanguagesvalues |
| fieldvalues |
| fileexploreritem |
| flvrecording |
| flvrecording_log |
| flvrecording_meta_delta |
| flvrecording_metadata |
| invitations |
| ldapconfig |
| meeting_members |
| meetme |
| naviglobal |
| navimain |
| om_timezone |
| open_xg_return_object |
| organisation |
| organisation_users |
| poll_types |
| private_messages |
| private_messages_folder |
| room_poll_answers |
| room_polls |
| rooms |
| rooms_moderator |
| rooms_organisation |
| roomtypes |
| salutations |
| sessiondata |
| sipusers |
| soaplogin |
| states |
| user_contacts |
| user_sip_data |
| userdata |
| userlevel |
| users |
+-------------------------+
48 rows in set (0.00 sec)
=================================================
mysql> show columns from om_user;
+-------------------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------------------+--------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| activatehash | varchar(255) | YES | | NULL | |
| age | datetime | YES | | NULL | |
| availible | int(11) | YES | | NULL | |
| deleted | bit(1) | YES | | NULL | |
| externalUserId | varchar(255) | YES | | NULL | |
| externalUserType | varchar(255) | YES | | NULL | |
| firstname | varchar(255) | YES | | NULL | |
| forceTimeZoneCheck | bit(1) | YES | | NULL | |
| language_id | bigint(20) | YES | | NULL | |
| lastlogin | datetime | YES | | NULL | |
| lastname | varchar(255) | YES | | NULL | |
| lasttrans | bigint(20) | YES | | NULL | |
| level_id | bigint(20) | YES | | NULL | |
| login | varchar(255) | YES | | NULL | |
| password | varchar(255) | YES | | NULL | |
| pictureuri | varchar(255) | YES | | NULL | |
| regdate | datetime | YES | | NULL | |
| resethash | varchar(255) | YES | | NULL | |
| salutations_id | bigint(20) | YES | | NULL | |
| sendSMS | bit(1) | YES | | NULL | |
| show_contact_data | bit(1) | YES | | NULL | |
| show_contact_data_to_contacts | bit(1) | YES | | NULL | |
| starttime | datetime | YES | | NULL | |
| status | int(11) | YES | | NULL | |
| updatetime | datetime | YES | | NULL | |
| user_offers | varchar(255) | YES | | NULL | |
| user_searchs | varchar(255) | YES | | NULL | |
| adresses_id | bigint(20) | YES | MUL | NULL | |
| omtimezoneId | bigint(20) | YES | MUL | NULL | |
| sip_user_id | bigint(20) | YES | MUL | NULL | |
+-------------------------------+--------------+------+-----+---------+----------------+
31 rows in set (0.01 sec)
=============================================================
Old Users
mysql> show columns from users;
+-------------------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------------------+--------------+------+-----+---------+----------------+
| user_id | bigint(20) | NO | PRI | NULL | auto_increment |
| activatehash | varchar(255) | YES | | NULL | |
| age | datetime | YES | | NULL | |
| availible | int(11) | YES | | NULL | |
| deleted | varchar(255) | YES | | NULL | |
| externalUserId | varchar(255) | YES | | NULL | |
| externalUserType | varchar(255) | YES | | NULL | |
| firstname | varchar(255) | YES | | NULL | |
| forceTimeZoneCheck | bit(1) | YES | | NULL | |
| language_id | bigint(20) | YES | | NULL | |
| lastlogin | datetime | YES | | NULL | |
| lastname | varchar(255) | YES | | NULL | |
| lasttrans | bigint(20) | YES | | NULL | |
| level_id | bigint(20) | YES | | NULL | |
| login | varchar(255) | YES | | NULL | |
| password | varchar(255) | YES | | NULL | |
| pictureuri | varchar(255) | YES | | NULL | |
| regdate | datetime | YES | | NULL | |
| resethash | varchar(255) | YES | | NULL | |
| show_contact_data | bit(1) | YES | | NULL | |
| show_contact_data_to_contacts | bit(1) | YES | | NULL | |
| starttime | datetime | YES | | NULL | |
| status | int(11) | YES | | NULL | |
| title_id | int(11) | YES | | NULL | |
| updatetime | datetime | YES | | NULL | |
| user_offers | varchar(255) | YES | | NULL | |
| user_searchs | varchar(255) | YES | | NULL | |
| adresses_id | bigint(20) | YES | MUL | NULL | |
| omtimezoneId | bigint(20) | YES | MUL | NULL | |
| userSipDataId | bigint(20) | YES | MUL | NULL | |
+-------------------------------+--------------+------+-----+---------+----------------+
30 rows in set (0.00 sec)
==================================================================================
Thanks,
George Kirkham
--
WBR
Maxim aka solomax
Re: OpenMeetings 2.2.0 - Error on users table when importing from
OpenMeetings 2.0
Posted by Maxim Solodovnik <so...@gmail.com>.
Could you please run
./admin.sh -v -i -file omProd20140114.zip
instead of
./admin.sh -i -file omProd20140114.zip
and provide the output?
On Tue, Jan 14, 2014 at 12:41 PM, George Kirkham <gk...@co2crc.com.au>wrote:
> Hi,
>
>
>
> Have a number of issues getting OpenMeetings 2.2.0 working under a Debian
> Wheezy server.
>
>
>
> *Issue #**2**:* I attempted to backup our OpenMeetings 2.0 server and do
> a install with the backup on the new OpenMeetings 2.2.0 Debian Wheezy
> server that I have built. The upgrade/install from the backup file seems
> to be failing on importing the user table. Checking the user table, the
> new OpenMeetings 2.2.0 has both a different table name (om_user) and
> different database columns to that of the OpenMeetings 2.0 version (users),
> which may be a cause of the issue?
>
> Is there an easy way to move users (userid, names, contact details and
> their passwords) from the old server to the new server?
>
>
>
> http://openmeetings.apache.org/Upgrade.html
>
>
>
> Step 1 stop the production OpenMeetings 2.0 server and perform the back up
>
> # ./admin.sh -b -file omProd20140114.zip
>
>
>
> Step 2 copy the backup file omProd20140114.zip to the new OpenMeetings
> 2.2.0 server
>
>
>
> Step 3 Change to the /usr/lib/red5 directory (OpenMeetings is not running)
> and run
>
> # ./admin.sh -i -file omProd20140114.zip
>
>
>
> This produces the following errors
>
> Error output to the screen;
>
>
>
> [INFO] [main] org.quartz.core.QuartzScheduler - Scheduler
> org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED
> shutdown complete.
>
> DEBUG 01-14 09:30:47.633 BackupImportController.java 2694 201
> org.apache.openmeetings.servlet.outputhandler.BackupImportController [main]
> - ##### WRITE FILE TO:
> /usr/lib/red5/webapps/openmeetings/upload/import/import_2014_01_14_09_30_47
>
> 88012 openmeetings INFO [main] openjpa.Runtime - Starting OpenJPA 2.2.1
>
> INFO 01-14 09:32:14.996 BackupImportController.java 90057 240
> org.apache.openmeetings.servlet.outputhandler.BackupImportController [main]
> - Organizations import complete, starting user import
>
> [ERROR] [main] org.apache.openmeetings.cli.Admin - Restore failed null
>
>
>
> --------------------------------
>
> /usr/lib/red5/log/red5.log
>
>
>
> 2014-01-14 09:37:32,888 [main] INFO org.quartz.impl.StdSchedulerFactory -
> Quartz scheduler
> 'org.springframework.scheduling.quartz.SchedulerFactoryBean#0' initialized
> from an externally provided properties instance.
>
> 2014-01-14 09:37:32,888 [main] INFO org.quartz.impl.StdSchedulerFactory -
> Quartz scheduler version: 1.8.5
>
> 2014-01-14 09:37:32,889 [main] INFO org.quartz.core.QuartzScheduler -
> JobFactory set to:
> org.springframework.scheduling.quartz.AdaptableJobFactory@5d51fe8a
>
> 2014-01-14 09:37:32,960 [main] INFO o.s.c.s.DefaultLifecycleProcessor -
> Starting beans in phase 2147483647
>
> 2014-01-14 09:37:32,961 [main] INFO o.s.s.quartz.SchedulerFactoryBean -
> Starting Quartz Scheduler now
>
> 2014-01-14 09:37:32,961 [main] INFO org.quartz.core.QuartzScheduler -
> Scheduler
> org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED
> started.
>
> 2014-01-14 09:37:32,962 [main] INFO org.quartz.core.QuartzScheduler -
> Scheduler
> org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED
> shutting down.
>
> 2014-01-14 09:37:32,962 [main] INFO org.quartz.core.QuartzScheduler -
> Scheduler
> org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED
> paused.
>
> 2014-01-14 09:37:32,962 [main] INFO org.quartz.core.QuartzScheduler -
> Scheduler
> org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED
> shutdown complete.
>
> 2014-01-14 09:37:34,331 [main] WARN o.a.o.data.conference.dao.SipDao -
> There is no Asterisk configured
>
> 2014-01-14 09:42:26,908 [main] ERROR org.apache.openmeetings.cli.Admin - Restore
> failed null
>
>
>
> ----------------------------------------------------
>
> /usr/lib/red5/log/openmeetings.log
>
>
>
> DEBUG 01-14 09:37:45.320 o.a.o.i.ImportInitvalues:962 [main] - Lang ADDED:
> org.apache.openmeetings.persistence.beans.lang.FieldLanguage@59dac7d;
> seconds passed: 0
>
> DEBUG 01-14 09:37:45.320 o.a.o.i.ImportInitvalues:975 [main] - All
> languages are imported
>
> DEBUG 01-14 09:37:45.345 o.a.o.i.ImportInitvalues:260 [main] - Salutations
> ADDED
>
> DEBUG 01-14 09:37:45.345 o.a.o.i.ImportInitvalues:838 [main] -
> ImportInitValues.loadInitAppointmentCategories
>
> INFO 01-14 09:37:45.354 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info:
> No USER_ID given
>
> DEBUG 01-14 09:37:45.359 o.a.o.i.ImportInitvalues:858 [main] -
> ImportInitValues.loadInitAppointmentReminderTypes
>
> INFO 01-14 09:37:45.373 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info:
> No USER_ID given
>
> INFO 01-14 09:37:45.381 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info:
> No USER_ID given
>
> INFO 01-14 09:37:45.384 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info:
> No USER_ID given
>
> DEBUG 01-14 09:37:45.441 o.a.o.i.ImportInitvalues:505 [main] -
> conference_Id: 16
>
> DEBUG 01-14 09:37:45.446 o.a.o.i.ImportInitvalues:512 [main] -
> restricted_Id: 18
>
> DEBUG 01-14 09:37:45.448 o.a.o.i.ImportInitvalues:516 [main] -
> interview_Id: 19
>
> DEBUG 01-14 09:37:45.450 o.a.o.i.ImportInitvalues:521 [main] - RoomTypes
> ADDED
>
> DEBUG 01-14 09:37:45.537 o.a.o.i.ImportInitvalues:499 [main] -
> Configuration ADDED
>
> DEBUG 01-14 09:37:45.539 o.a.o.s.o.BackupImportController:201 [main] -
> ##### WRITE FILE TO:
> /usr/lib/red5/webapps/openmeetings/upload/import/import_2014_01_14_09_37_45
>
> INFO 01-14 09:42:26.669 o.a.o.s.o.BackupImportController:240 [main] - Organizations
> import complete, starting user import
>
>
>
>
>
> mysql> show tables;
>
> +-------------------------+
>
> | Tables_in_openmeetings |
>
> +-------------------------+
>
> | address |
>
> | appointmentcategory |
>
> | appointmentremindertyps |
>
> | appointments |
>
> | chat |
>
> | client |
>
> | conferencelog |
>
> | conferencelogtype |
>
> | configuration |
>
> | email_queue |
>
> | errortypes |
>
> | errorvalue |
>
> | fieldlanguage |
>
> | fieldlanguagesvalues |
>
> | fieldvalues |
>
> | fileexploreritem |
>
> | flvrecording |
>
> | flvrecording_log |
>
> | flvrecording_meta_delta |
>
> | flvrecording_metadata |
>
> | invitations |
>
> | ldapconfig |
>
> | meeting_members |
>
> | naviglobal |
>
> | navimain |
>
> | om_timezone |
>
> | om_user |
>
> | organisation |
>
> | organisation_users |
>
> | poll_types |
>
> | private_message |
>
> | private_messages_folder |
>
> | room |
>
> | room_poll_answers |
>
> | room_polls |
>
> | rooms_moderator |
>
> | rooms_organisation |
>
> | roomtype |
>
> | salutation |
>
> | server |
>
> | sessiondata |
>
> | sipusers |
>
> | soaplogin |
>
> | state |
>
> | user_contact |
>
> | user_data |
>
> | user_level |
>
> | whiteboard |
>
> | whiteboard_item |
>
> +-------------------------+
>
> 49 rows in set (0.00 sec)
>
>
>
>
>
> =========================================================
>
>
>
> mysql> show tables;
>
> +-------------------------+
>
> | Tables_in_openmeetings |
>
> +-------------------------+
>
> | OPENJPA_SEQUENCE_TABLE |
>
> | adresses |
>
> | appointmentcategory |
>
> | appointmentremindertyps |
>
> | appointments |
>
> | conferencelog |
>
> | conferencelogtype |
>
> | configuration |
>
> | errortypes |
>
> | errorvalues |
>
> | extensions |
>
> | fieldlanguage |
>
> | fieldlanguagesvalues |
>
> | fieldvalues |
>
> | fileexploreritem |
>
> | flvrecording |
>
> | flvrecording_log |
>
> | flvrecording_meta_delta |
>
> | flvrecording_metadata |
>
> | invitations |
>
> | ldapconfig |
>
> | meeting_members |
>
> | meetme |
>
> | naviglobal |
>
> | navimain |
>
> | om_timezone |
>
> | open_xg_return_object |
>
> | organisation |
>
> | organisation_users |
>
> | poll_types |
>
> | private_messages |
>
> | private_messages_folder |
>
> | room_poll_answers |
>
> | room_polls |
>
> | rooms |
>
> | rooms_moderator |
>
> | rooms_organisation |
>
> | roomtypes |
>
> | salutations |
>
> | sessiondata |
>
> | sipusers |
>
> | soaplogin |
>
> | states |
>
> | user_contacts |
>
> | user_sip_data |
>
> | userdata |
>
> | userlevel |
>
> | users |
>
> +-------------------------+
>
> 48 rows in set (0.00 sec)
>
>
>
> =================================================
>
>
>
> mysql> show columns from om_user;
>
>
> +-------------------------------+--------------+------+-----+---------+----------------+
>
> | Field | Type | Null | Key | Default |
> Extra |
>
>
> +-------------------------------+--------------+------+-----+---------+----------------+
>
> | id | bigint(20) | NO | PRI | NULL |
> auto_increment |
>
> | activatehash | varchar(255) | YES | | NULL
> | |
>
> | age | datetime | YES | | NULL
> | |
>
> | availible | int(11) | YES | | NULL
> | |
>
> | deleted | bit(1) | YES | | NULL
> | |
>
> | externalUserId | varchar(255) | YES | | NULL
> | |
>
> | externalUserType | varchar(255) | YES | | NULL
> | |
>
> | firstname | varchar(255) | YES | | NULL
> | |
>
> | forceTimeZoneCheck | bit(1) | YES | | NULL
> | |
>
> | language_id | bigint(20) | YES | | NULL
> | |
>
> | lastlogin | datetime | YES | | NULL
> | |
>
> | lastname | varchar(255) | YES | | NULL
> | |
>
> | lasttrans | bigint(20) | YES | | NULL
> | |
>
> | level_id | bigint(20) | YES | | NULL
> | |
>
> | login | varchar(255) | YES | | NULL
> | |
>
> | password | varchar(255) | YES | | NULL
> | |
>
> | pictureuri | varchar(255) | YES | | NULL
> | |
>
> | regdate | datetime | YES | | NULL
> | |
>
> | resethash | varchar(255) | YES | | NULL
> | |
>
> | salutations_id | bigint(20) | YES | | NULL
> | |
>
> | sendSMS | bit(1) | YES | | NULL
> | |
>
> | show_contact_data | bit(1) | YES | | NULL
> | |
>
> | show_contact_data_to_contacts | bit(1) | YES | | NULL
> | |
>
> | starttime | datetime | YES | | NULL
> | |
>
> | status | int(11) | YES | | NULL
> | |
>
> | updatetime | datetime | YES | | NULL
> | |
>
> | user_offers | varchar(255) | YES | | NULL
> | |
>
> | user_searchs | varchar(255) | YES | | NULL
> | |
>
> | adresses_id | bigint(20) | YES | MUL | NULL
> | |
>
> | omtimezoneId | bigint(20) | YES | MUL | NULL
> | |
>
> | sip_user_id | bigint(20) | YES | MUL | NULL
> | |
>
>
> +-------------------------------+--------------+------+-----+---------+----------------+
>
> 31 rows in set (0.01 sec)
>
>
>
> =============================================================
>
> Old Users
>
> mysql> show columns from users;
>
>
> +-------------------------------+--------------+------+-----+---------+----------------+
>
> | Field | Type | Null | Key | Default |
> Extra |
>
>
> +-------------------------------+--------------+------+-----+---------+----------------+
>
> | user_id | bigint(20) | NO | PRI | NULL |
> auto_increment |
>
> | activatehash | varchar(255) | YES | | NULL
> | |
>
> | age | datetime | YES | | NULL
> | |
>
> | availible | int(11) | YES | | NULL
> | |
>
> | deleted | varchar(255) | YES | | NULL
> | |
>
> | externalUserId | varchar(255) | YES | | NULL
> | |
>
> | externalUserType | varchar(255) | YES | | NULL
> | |
>
> | firstname | varchar(255) | YES | | NULL
> | |
>
> | forceTimeZoneCheck | bit(1) | YES | | NULL
> | |
>
> | language_id | bigint(20) | YES | | NULL
> | |
>
> | lastlogin | datetime | YES | | NULL
> | |
>
> | lastname | varchar(255) | YES | | NULL
> | |
>
> | lasttrans | bigint(20) | YES | | NULL
> | |
>
> | level_id | bigint(20) | YES | | NULL
> | |
>
> | login | varchar(255) | YES | | NULL
> | |
>
> | password | varchar(255) | YES | | NULL
> | |
>
> | pictureuri | varchar(255) | YES | | NULL
> | |
>
> | regdate | datetime | YES | | NULL
> | |
>
> | resethash | varchar(255) | YES | | NULL
> | |
>
> | show_contact_data | bit(1) | YES | | NULL
> | |
>
> | show_contact_data_to_contacts | bit(1) | YES | | NULL
> | |
>
> | starttime | datetime | YES | | NULL
> | |
>
> | status | int(11) | YES | | NULL
> | |
>
> | title_id | int(11) | YES | | NULL
> | |
>
> | updatetime | datetime | YES | | NULL
> | |
>
> | user_offers | varchar(255) | YES | | NULL
> | |
>
> | user_searchs | varchar(255) | YES | | NULL
> | |
>
> | adresses_id | bigint(20) | YES | MUL | NULL
> | |
>
> | omtimezoneId | bigint(20) | YES | MUL | NULL
> | |
>
> | userSipDataId | bigint(20) | YES | MUL | NULL
> | |
>
>
> +-------------------------------+--------------+------+-----+---------+----------------+
>
> 30 rows in set (0.00 sec)
>
>
>
>
>
>
> ==================================================================================
>
>
>
> Thanks,
>
>
>
> George Kirkham
>
--
WBR
Maxim aka solomax
RE: OpenMeetings 2.2.0 - Private rooms sometimes displaying rooms and sometimes not displaying rooms
Posted by George Kirkham <gk...@co2crc.com.au>.
Maxim, thanks, that is just what I was trying to find…
Thanks,
George Kirkham
From: Maxim Solodovnik [mailto:solomax666@gmail.com]
Sent: Friday, 17 January 2014 3:34 PM
To: Openmeetings user-list
Subject: Re: OpenMeetings 2.2.0 - Private rooms sometimes displaying rooms and sometimes not displaying rooms
Hopefully will start voting this weekend (need to test/fix plugins compatibility)
You can get 3.0 nightly from here: https://builds.apache.org/view/M-R/view/OpenMeetings/job/openmeetings/
On Fri, Jan 17, 2014 at 11:30 AM, George Kirkham <gk...@co2crc.com.au> wrote:
I now have OpenMeetings 2.2 working in production and it seems quite stable and working well.
I don’t really know what caused the issue but when I downloaded OpenMeetings again, this time from http://archive.apache.org/dist/openmeetings/2.2.0/bin/apache-openmeetings-2.2.0.tar.gz
I have not had any issues with the Private rooms not displaying.
I still am unable to import from a backup of my version 2.0, but not having many users, I was able to re-enter them in manually.
I look forward to testing OpenMeetings 3.0
Thanks,
George Kirkham
From: George Kirkham [mailto:gkirkham@co2crc.com.au]
Sent: Thursday, 16 January 2014 2:16 PM
To: user@openmeetings.apache.org
Subject: RE: OpenMeetings 2.2.0 - Private rooms sometimes displaying rooms and sometimes not displaying rooms
The behaviour may be my fault, I am checking into it now and will report back later.
Thanks,
George Kirkham
From: Maxim Solodovnik [mailto:solomax666@gmail.com]
Sent: Thursday, 16 January 2014 2:05 PM
To: Openmeetings user-list
Subject: Re: OpenMeetings 2.2.0 - Private rooms sometimes displaying rooms and sometimes not displaying rooms
I believe I never saw such behavior
On Wed, Jan 15, 2014 at 12:11 PM, George Kirkham <gk...@co2crc.com.au> wrote:
Hi,
Have a issue with “Private rooms” tab sometimes displaying rooms and sometimes not displaying rooms.
A new clean OpenMeetings 2.2.0 build downloaded (this week) and working on a Debian Wheezy server.
Issue #3: In my OpenMeetings configuration, I have four groups, one private Conference room and one or two private conference rooms for each group. When any user logs in, there seems to be a random chance that the Private rooms will display or not display. If they select “Recordings”, “Recordings”, then “Rooms”, “Private Rooms” then more than likely there will be no rooms displayed in the “Private rooms” listing.
Has anyone had an issue like this or can reproduce such and issue?
George.
--
WBR
Maxim aka solomax
--
WBR
Maxim aka solomax
Re: OpenMeetings 2.2.0 - Private rooms sometimes displaying rooms and
sometimes not displaying rooms
Posted by Maxim Solodovnik <so...@gmail.com>.
Hopefully will start voting this weekend (need to test/fix plugins
compatibility)
You can get 3.0 nightly from here:
https://builds.apache.org/view/M-R/view/OpenMeetings/job/openmeetings/
On Fri, Jan 17, 2014 at 11:30 AM, George Kirkham <gk...@co2crc.com.au>wrote:
> I now have OpenMeetings 2.2 working in production and it seems quite
> stable and working well.
>
>
>
> I don’t really know what caused the issue but when I downloaded
> OpenMeetings again, this time from
> http://archive.apache.org/dist/openmeetings/2.2.0/bin/apache-openmeetings-2.2.0.tar.gz
>
> I have not had any issues with the Private rooms not displaying.
>
>
>
> I still am unable to import from a backup of my version 2.0, but not
> having many users, I was able to re-enter them in manually.
>
>
>
> I look forward to testing OpenMeetings 3.0
>
>
>
> Thanks,
>
>
>
> George Kirkham
>
>
>
>
>
> *From:* George Kirkham [mailto:gkirkham@co2crc.com.au]
> *Sent:* Thursday, 16 January 2014 2:16 PM
> *To:* user@openmeetings.apache.org
> *Subject:* RE: OpenMeetings 2.2.0 - Private rooms sometimes displaying
> rooms and sometimes not displaying rooms
>
>
>
> The behaviour may be my fault, I am checking into it now and will report
> back later.
>
>
>
> Thanks,
>
>
>
> George Kirkham
>
>
>
>
>
>
>
> *From:* Maxim Solodovnik [mailto:solomax666@gmail.com<so...@gmail.com>]
>
> *Sent:* Thursday, 16 January 2014 2:05 PM
> *To:* Openmeetings user-list
> *Subject:* Re: OpenMeetings 2.2.0 - Private rooms sometimes displaying
> rooms and sometimes not displaying rooms
>
>
>
> I believe I never saw such behavior
>
>
>
>
>
> On Wed, Jan 15, 2014 at 12:11 PM, George Kirkham <gk...@co2crc.com.au>
> wrote:
>
> Hi,
>
>
>
> Have a issue with “Private rooms” tab sometimes displaying rooms and
> sometimes not displaying rooms.
>
>
>
> A new clean OpenMeetings 2.2.0 build downloaded (this week) and working on
> a Debian Wheezy server.
>
>
>
> *Issue #3:* In my OpenMeetings configuration, I have four groups, one
> private Conference room and one or two private conference rooms for each
> group. When any user logs in, there seems to be a random chance that the
> Private rooms will display or not display. If they select “Recordings”,
> “Recordings”, then “Rooms”, “Private Rooms” then more than likely there
> will be no rooms displayed in the “Private rooms” listing.
>
>
>
> Has anyone had an issue like this or can reproduce such and issue?
>
>
>
> George.
>
>
>
>
>
> --
> WBR
> Maxim aka solomax
>
--
WBR
Maxim aka solomax
RE: OpenMeetings 2.2.0 - Private rooms sometimes displaying rooms and sometimes not displaying rooms
Posted by George Kirkham <gk...@co2crc.com.au>.
I now have OpenMeetings 2.2 working in production and it seems quite stable and working well.
I don’t really know what caused the issue but when I downloaded OpenMeetings again, this time from http://archive.apache.org/dist/openmeetings/2.2.0/bin/apache-openmeetings-2.2.0.tar.gz
I have not had any issues with the Private rooms not displaying.
I still am unable to import from a backup of my version 2.0, but not having many users, I was able to re-enter them in manually.
I look forward to testing OpenMeetings 3.0
Thanks,
George Kirkham
From: George Kirkham [mailto:gkirkham@co2crc.com.au]
Sent: Thursday, 16 January 2014 2:16 PM
To: user@openmeetings.apache.org
Subject: RE: OpenMeetings 2.2.0 - Private rooms sometimes displaying rooms and sometimes not displaying rooms
The behaviour may be my fault, I am checking into it now and will report back later.
Thanks,
George Kirkham
From: Maxim Solodovnik [mailto:solomax666@gmail.com]
Sent: Thursday, 16 January 2014 2:05 PM
To: Openmeetings user-list
Subject: Re: OpenMeetings 2.2.0 - Private rooms sometimes displaying rooms and sometimes not displaying rooms
I believe I never saw such behavior
On Wed, Jan 15, 2014 at 12:11 PM, George Kirkham <gk...@co2crc.com.au> wrote:
Hi,
Have a issue with “Private rooms” tab sometimes displaying rooms and sometimes not displaying rooms.
A new clean OpenMeetings 2.2.0 build downloaded (this week) and working on a Debian Wheezy server.
Issue #3: In my OpenMeetings configuration, I have four groups, one private Conference room and one or two private conference rooms for each group. When any user logs in, there seems to be a random chance that the Private rooms will display or not display. If they select “Recordings”, “Recordings”, then “Rooms”, “Private Rooms” then more than likely there will be no rooms displayed in the “Private rooms” listing.
Has anyone had an issue like this or can reproduce such and issue?
George.
--
WBR
Maxim aka solomax
RE: OpenMeetings 2.2.0 - Private rooms sometimes displaying rooms and sometimes not displaying rooms
Posted by George Kirkham <gk...@co2crc.com.au>.
The behaviour may be my fault, I am checking into it now and will report back later.
Thanks,
George Kirkham
From: Maxim Solodovnik [mailto:solomax666@gmail.com]
Sent: Thursday, 16 January 2014 2:05 PM
To: Openmeetings user-list
Subject: Re: OpenMeetings 2.2.0 - Private rooms sometimes displaying rooms and sometimes not displaying rooms
I believe I never saw such behavior
On Wed, Jan 15, 2014 at 12:11 PM, George Kirkham <gk...@co2crc.com.au> wrote:
Hi,
Have a issue with “Private rooms” tab sometimes displaying rooms and sometimes not displaying rooms.
A new clean OpenMeetings 2.2.0 build downloaded (this week) and working on a Debian Wheezy server.
Issue #3: In my OpenMeetings configuration, I have four groups, one private Conference room and one or two private conference rooms for each group. When any user logs in, there seems to be a random chance that the Private rooms will display or not display. If they select “Recordings”, “Recordings”, then “Rooms”, “Private Rooms” then more than likely there will be no rooms displayed in the “Private rooms” listing.
Has anyone had an issue like this or can reproduce such and issue?
George.
--
WBR
Maxim aka solomax
Re: OpenMeetings 2.2.0 - Private rooms sometimes displaying rooms
and sometimes not displaying rooms
Posted by Dušan Stloukal <du...@devportal.eu>.
Using nightbuild 2014-01-25, the issue seems resolved. The solution with
bookmarks and without need to choose the organization is very good!
Thank you
D.
On 01/23/2014 02:24 AM, Maxim Solodovnik wrote:
>
> Could you please check if the issue is reproducible in 3.0?
> Please file JIRA issue if still reproducible
>
> On Jan 23, 2014 1:46 AM, "Dušan Stloukal" <dusan.stloukal@devportal.eu
> <ma...@devportal.eu>> wrote:
>
> I was facing this behaviour using OM 2.2.0 many times with this log:
>
> DEBUG 01-21 23:21:12.056 o.a.o.r.ConferenceService:223
> [http-nio-0.0.0.0-5080-exec-7] - getRoomsPublic user_level: 3
> DEBUG 01-21 23:21:12.092 o.a.o.r.ConferenceService:138
> [http-nio-0.0.0.0-5080-exec-4] - getRoomsByOrganisationAndType
> ERROR 01-21 23:21:12.098 o.a.o.r.ConferenceService:153
> [http-nio-0.0.0.0-5080-exec-4] - [getRoomsByOrganisationAndType]
> java.lang.NullPointerException: null
> at
> org.apache.openmeetings.remote.ConferenceService.getRoomsByOrganisationWithoutType(ConferenceService.java:148)
> ~[openmeetings-2.2.0-RELEASE.jar:na]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method) ~[na:1.6.0_28]
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> ~[na:1.6.0_28]
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.6.0_28]
> at java.lang.reflect.Method.invoke(Method.java:622)
> ~[na:1.6.0_28]
> at
> org.red5.server.service.ServiceInvoker.invoke(ServiceInvoker.java:196)
> ~[red5.jar:na]
> at
> org.red5.server.service.ServiceInvoker.invoke(ServiceInvoker.java:115)
> ~[red5.jar:na]
> at
> org.red5.server.net.rtmp.RTMPHandler.invokeCall(RTMPHandler.java:157)
> ~[red5.jar:na]
> at
> org.red5.server.net.rtmp.RTMPHandler.onInvoke(RTMPHandler.java:399) ~[red5.jar:na]
> at
> org.red5.server.net.rtmp.BaseRTMPHandler.messageReceived(BaseRTMPHandler.java:130)
> ~[red5.jar:na]
> at
> org.red5.server.net.rtmpt.RTMPTHandler.messageReceived(RTMPTHandler.java:129)
> ~[red5.jar:na]
> at
> org.red5.server.net.rtmpt.RTMPTServlet.handleSend(RTMPTServlet.java:410)
> ~[red5.jar:na]
> at
> org.red5.server.net.rtmpt.RTMPTServlet.service(RTMPTServlet.java:488)
> ~[red5.jar:na]
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
> ~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
> ~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
> ~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
> ~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
> ~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
> ~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
> ~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
> ~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
> ~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
> ~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
> at
> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
> ~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
> at
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
> ~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
> at
> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1686)
> ~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146)
> ~[na:1.6.0_28]
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> ~[na:1.6.0_28]
> at java.lang.Thread.run(Thread.java:701) ~[na:1.6.0_28]
>
> That was yesterday. Today everything works fine without changes...
>
> By the way, if I set the isPublic attribute and assign some
> organization to the room too (I know, it is not good idea, but I
> tried everything to get the list of the private rooms to work),
> the room in the list of the rooms in the "New event" form is
> duplicated. I believe that is because of the room is public and
> assigned to the organization too in one moment, but I think the
> room in the list should be contained only once.
>
> Thank you
>
> D.
>
>
> On 01/16/2014 04:05 AM, Maxim Solodovnik wrote:
>> I believe I never saw such behavior
>>
>>
>>
>> On Wed, Jan 15, 2014 at 12:11 PM, George Kirkham
>> <gkirkham@co2crc.com.au <ma...@co2crc.com.au>> wrote:
>>
>> Hi,
>>
>> Have a issuewith “Private rooms” tab sometimes displaying
>> rooms and sometimes not displaying rooms.
>>
>> A new clean OpenMeetings 2.2.0 build downloaded (this week)
>> and working ona Debian Wheezy server.
>>
>> *Issue #**3**:*In my OpenMeetings configuration, I have four
>> groups, one private Conference room and one or two private
>> conference rooms for each group. When any user logs in,
>> there seems to be a random chance that the Private rooms will
>> display or not display. If they select “Recordings”,
>> “Recordings”, then “Rooms”, “Private Rooms” then more than
>> likely there will be no rooms displayed in the “Private
>> rooms” listing.
>>
>> Has anyone had an issue like this or can reproduce such and
>> issue?
>>
>> George.
>>
>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>
Re: OpenMeetings 2.2.0 - Private rooms sometimes displaying rooms and
sometimes not displaying rooms
Posted by Maxim Solodovnik <so...@gmail.com>.
Could you please check if the issue is reproducible in 3.0?
Please file JIRA issue if still reproducible
On Jan 23, 2014 1:46 AM, "Dušan Stloukal" <du...@devportal.eu>
wrote:
> I was facing this behaviour using OM 2.2.0 many times with this log:
>
> DEBUG 01-21 23:21:12.056 o.a.o.r.ConferenceService:223
> [http-nio-0.0.0.0-5080-exec-7] - getRoomsPublic user_level: 3
> DEBUG 01-21 23:21:12.092 o.a.o.r.ConferenceService:138
> [http-nio-0.0.0.0-5080-exec-4] - getRoomsByOrganisationAndType
> ERROR 01-21 23:21:12.098 o.a.o.r.ConferenceService:153
> [http-nio-0.0.0.0-5080-exec-4] - [getRoomsByOrganisationAndType]
> java.lang.NullPointerException: null
> at
> org.apache.openmeetings.remote.ConferenceService.getRoomsByOrganisationWithoutType(ConferenceService.java:148)
> ~[openmeetings-2.2.0-RELEASE.jar:na]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[na:1.6.0_28]
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> ~[na:1.6.0_28]
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.6.0_28]
> at java.lang.reflect.Method.invoke(Method.java:622) ~[na:1.6.0_28]
> at
> org.red5.server.service.ServiceInvoker.invoke(ServiceInvoker.java:196)
> ~[red5.jar:na]
> at
> org.red5.server.service.ServiceInvoker.invoke(ServiceInvoker.java:115)
> ~[red5.jar:na]
> at
> org.red5.server.net.rtmp.RTMPHandler.invokeCall(RTMPHandler.java:157)
> ~[red5.jar:na]
> at
> org.red5.server.net.rtmp.RTMPHandler.onInvoke(RTMPHandler.java:399)
> ~[red5.jar:na]
> at
> org.red5.server.net.rtmp.BaseRTMPHandler.messageReceived(BaseRTMPHandler.java:130)
> ~[red5.jar:na]
> at
> org.red5.server.net.rtmpt.RTMPTHandler.messageReceived(RTMPTHandler.java:129)
> ~[red5.jar:na]
> at
> org.red5.server.net.rtmpt.RTMPTServlet.handleSend(RTMPTServlet.java:410)
> ~[red5.jar:na]
> at
> org.red5.server.net.rtmpt.RTMPTServlet.service(RTMPTServlet.java:488)
> ~[red5.jar:na]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
> ~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
> ~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
> ~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
> ~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
> ~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
> ~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
> ~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
> ~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
> ~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
> ~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
> at
> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
> ~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
> at
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
> ~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
> at
> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1686)
> ~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146)
> ~[na:1.6.0_28]
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> ~[na:1.6.0_28]
> at java.lang.Thread.run(Thread.java:701) ~[na:1.6.0_28]
>
> That was yesterday. Today everything works fine without changes...
>
> By the way, if I set the isPublic attribute and assign some organization
> to the room too (I know, it is not good idea, but I tried everything to get
> the list of the private rooms to work), the room in the list of the rooms
> in the "New event" form is duplicated. I believe that is because of the
> room is public and assigned to the organization too in one moment, but I
> think the room in the list should be contained only once.
>
> Thank you
>
> D.
>
>
> On 01/16/2014 04:05 AM, Maxim Solodovnik wrote:
>
> I believe I never saw such behavior
>
>
>
> On Wed, Jan 15, 2014 at 12:11 PM, George Kirkham <gk...@co2crc.com.au>wrote:
>
>> Hi,
>>
>>
>>
>> Have a issue with “Private rooms” tab sometimes displaying rooms and
>> sometimes not displaying rooms.
>>
>>
>>
>> A new clean OpenMeetings 2.2.0 build downloaded (this week) and working
>> on a Debian Wheezy server.
>>
>>
>>
>> *Issue #**3**:* In my OpenMeetings configuration, I have four groups,
>> one private Conference room and one or two private conference rooms for
>> each group. When any user logs in, there seems to be a random chance that
>> the Private rooms will display or not display. If they select “Recordings”,
>> “Recordings”, then “Rooms”, “Private Rooms” then more than likely there
>> will be no rooms displayed in the “Private rooms” listing.
>>
>>
>>
>> Has anyone had an issue like this or can reproduce such and issue?
>>
>>
>>
>> George.
>>
>
>
>
> --
> WBR
> Maxim aka solomax
>
>
>
Re: OpenMeetings 2.2.0 - Private rooms sometimes displaying rooms
and sometimes not displaying rooms
Posted by Dušan Stloukal <du...@devportal.eu>.
I was facing this behaviour using OM 2.2.0 many times with this log:
DEBUG 01-21 23:21:12.056 o.a.o.r.ConferenceService:223
[http-nio-0.0.0.0-5080-exec-7] - getRoomsPublic user_level: 3
DEBUG 01-21 23:21:12.092 o.a.o.r.ConferenceService:138
[http-nio-0.0.0.0-5080-exec-4] - getRoomsByOrganisationAndType
ERROR 01-21 23:21:12.098 o.a.o.r.ConferenceService:153
[http-nio-0.0.0.0-5080-exec-4] - [getRoomsByOrganisationAndType]
java.lang.NullPointerException: null
at
org.apache.openmeetings.remote.ConferenceService.getRoomsByOrganisationWithoutType(ConferenceService.java:148)
~[openmeetings-2.2.0-RELEASE.jar:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.6.0_28]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
~[na:1.6.0_28]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.6.0_28]
at java.lang.reflect.Method.invoke(Method.java:622) ~[na:1.6.0_28]
at
org.red5.server.service.ServiceInvoker.invoke(ServiceInvoker.java:196)
~[red5.jar:na]
at
org.red5.server.service.ServiceInvoker.invoke(ServiceInvoker.java:115)
~[red5.jar:na]
at
org.red5.server.net.rtmp.RTMPHandler.invokeCall(RTMPHandler.java:157)
~[red5.jar:na]
at
org.red5.server.net.rtmp.RTMPHandler.onInvoke(RTMPHandler.java:399)
~[red5.jar:na]
at
org.red5.server.net.rtmp.BaseRTMPHandler.messageReceived(BaseRTMPHandler.java:130)
~[red5.jar:na]
at
org.red5.server.net.rtmpt.RTMPTHandler.messageReceived(RTMPTHandler.java:129)
~[red5.jar:na]
at
org.red5.server.net.rtmpt.RTMPTServlet.handleSend(RTMPTServlet.java:410)
~[red5.jar:na]
at
org.red5.server.net.rtmpt.RTMPTServlet.service(RTMPTServlet.java:488)
~[red5.jar:na]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1686)
~[tomcat-embed-core-jar-7.0.42.jar:7.0.42]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146)
~[na:1.6.0_28]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
~[na:1.6.0_28]
at java.lang.Thread.run(Thread.java:701) ~[na:1.6.0_28]
That was yesterday. Today everything works fine without changes...
By the way, if I set the isPublic attribute and assign some organization
to the room too (I know, it is not good idea, but I tried everything to
get the list of the private rooms to work), the room in the list of the
rooms in the "New event" form is duplicated. I believe that is because
of the room is public and assigned to the organization too in one
moment, but I think the room in the list should be contained only once.
Thank you
D.
On 01/16/2014 04:05 AM, Maxim Solodovnik wrote:
> I believe I never saw such behavior
>
>
>
> On Wed, Jan 15, 2014 at 12:11 PM, George Kirkham
> <gkirkham@co2crc.com.au <ma...@co2crc.com.au>> wrote:
>
> Hi,
>
> Have a issuewith “Private rooms” tab sometimes displaying rooms
> and sometimes not displaying rooms.
>
> A new clean OpenMeetings 2.2.0 build downloaded (this week) and
> working ona Debian Wheezy server.
>
> *Issue #**3**:*In my OpenMeetings configuration, I have four
> groups, one private Conference room and one or two private
> conference rooms for each group. When any user logs in, there
> seems to be a random chance that the Private rooms will display or
> not display. If they select “Recordings”, “Recordings”, then
> “Rooms”, “Private Rooms” then more than likely there will be no
> rooms displayed in the “Private rooms” listing.
>
> Has anyone had an issue like this or can reproduce such and issue?
>
> George.
>
>
>
>
> --
> WBR
> Maxim aka solomax
Re: OpenMeetings 2.2.0 - Private rooms sometimes displaying rooms and
sometimes not displaying rooms
Posted by Maxim Solodovnik <so...@gmail.com>.
I believe I never saw such behavior
On Wed, Jan 15, 2014 at 12:11 PM, George Kirkham <gk...@co2crc.com.au>wrote:
> Hi,
>
>
>
> Have a issue with “Private rooms” tab sometimes displaying rooms and
> sometimes not displaying rooms.
>
>
>
> A new clean OpenMeetings 2.2.0 build downloaded (this week) and working ona Debian Wheezy server.
>
>
>
> *Issue #**3**:* In my OpenMeetings configuration, I have four groups,
> one private Conference room and one or two private conference rooms for
> each group. When any user logs in, there seems to be a random chance that
> the Private rooms will display or not display. If they select “Recordings”,
> “Recordings”, then “Rooms”, “Private Rooms” then more than likely there
> will be no rooms displayed in the “Private rooms” listing.
>
>
>
> Has anyone had an issue like this or can reproduce such and issue?
>
>
>
> George.
>
--
WBR
Maxim aka solomax
RE: OpenMeetings 2.2.0 - Private rooms sometimes displaying rooms and sometimes not displaying rooms
Posted by George Kirkham <gk...@co2crc.com.au>.
Hi,
Have a issue with “Private rooms” tab sometimes displaying rooms and sometimes not displaying rooms.
A new clean OpenMeetings 2.2.0 build downloaded (this week) and working on a Debian Wheezy server.
Issue #3: In my OpenMeetings configuration, I have four groups, one private Conference room and one or two private conference rooms for each group. When any user logs in, there seems to be a random chance that the Private rooms will display or not display. If they select “Recordings”, “Recordings”, then “Rooms”, “Private Rooms” then more than likely there will be no rooms displayed in the “Private rooms” listing.
Has anyone had an issue like this or can reproduce such and issue?
George.
OpenMeetings 2.2.0 - Error on users table when importing from OpenMeetings 2.0
Posted by George Kirkham <gk...@co2crc.com.au>.
Hi,
Have a number of issues getting OpenMeetings 2.2.0 working under a Debian Wheezy server.
Issue #2: I attempted to backup our OpenMeetings 2.0 server and do a install with the backup on the new OpenMeetings 2.2.0 Debian Wheezy server that I have built. The upgrade/install from the backup file seems to be failing on importing the user table. Checking the user table, the new OpenMeetings 2.2.0 has both a different table name (om_user) and different database columns to that of the OpenMeetings 2.0 version (users), which may be a cause of the issue?
Is there an easy way to move users (userid, names, contact details and their passwords) from the old server to the new server?
http://openmeetings.apache.org/Upgrade.html
Step 1 stop the production OpenMeetings 2.0 server and perform the back up
# ./admin.sh -b -file omProd20140114.zip
Step 2 copy the backup file omProd20140114.zip to the new OpenMeetings 2.2.0 server
Step 3 Change to the /usr/lib/red5 directory (OpenMeetings is not running) and run
# ./admin.sh -i -file omProd20140114.zip
This produces the following errors
Error output to the screen;
[INFO] [main] org.quartz.core.QuartzScheduler - Scheduler org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED shutdown complete.
DEBUG 01-14 09:30:47.633 BackupImportController.java 2694 201 org.apache.openmeetings.servlet.outputhandler.BackupImportController [main] - ##### WRITE FILE TO: /usr/lib/red5/webapps/openmeetings/upload/import/import_2014_01_14_09_30_47
88012 openmeetings INFO [main] openjpa.Runtime - Starting OpenJPA 2.2.1
INFO 01-14 09:32:14.996 BackupImportController.java 90057 240 org.apache.openmeetings.servlet.outputhandler.BackupImportController [main] - Organizations import complete, starting user import
[ERROR] [main] org.apache.openmeetings.cli.Admin - Restore failed null
--------------------------------
/usr/lib/red5/log/red5.log
2014-01-14 09:37:32,888 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'org.springframework.scheduling.quartz.SchedulerFactoryBean#0' initialized from an externally provided properties instance.
2014-01-14 09:37:32,888 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 1.8.5
2014-01-14 09:37:32,889 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@5d51fe8a
2014-01-14 09:37:32,960 [main] INFO o.s.c.s.DefaultLifecycleProcessor - Starting beans in phase 2147483647
2014-01-14 09:37:32,961 [main] INFO o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now
2014-01-14 09:37:32,961 [main] INFO org.quartz.core.QuartzScheduler - Scheduler org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED started.
2014-01-14 09:37:32,962 [main] INFO org.quartz.core.QuartzScheduler - Scheduler org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED shutting down.
2014-01-14 09:37:32,962 [main] INFO org.quartz.core.QuartzScheduler - Scheduler org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED paused.
2014-01-14 09:37:32,962 [main] INFO org.quartz.core.QuartzScheduler - Scheduler org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED shutdown complete.
2014-01-14 09:37:34,331 [main] WARN o.a.o.data.conference.dao.SipDao - There is no Asterisk configured
2014-01-14 09:42:26,908 [main] ERROR org.apache.openmeetings.cli.Admin - Restore failed null
----------------------------------------------------
/usr/lib/red5/log/openmeetings.log
DEBUG 01-14 09:37:45.320 o.a.o.i.ImportInitvalues:962 [main] - Lang ADDED: org.apache.openmeetings.persistence.beans.lang.FieldLanguage@59dac7d; seconds passed: 0
DEBUG 01-14 09:37:45.320 o.a.o.i.ImportInitvalues:975 [main] - All languages are imported
DEBUG 01-14 09:37:45.345 o.a.o.i.ImportInitvalues:260 [main] - Salutations ADDED
DEBUG 01-14 09:37:45.345 o.a.o.i.ImportInitvalues:838 [main] - ImportInitValues.loadInitAppointmentCategories
INFO 01-14 09:37:45.354 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info: No USER_ID given
DEBUG 01-14 09:37:45.359 o.a.o.i.ImportInitvalues:858 [main] - ImportInitValues.loadInitAppointmentReminderTypes
INFO 01-14 09:37:45.373 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info: No USER_ID given
INFO 01-14 09:37:45.381 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info: No USER_ID given
INFO 01-14 09:37:45.384 o.a.o.d.u.d.UsersDao:163 [main] - [getUser] Info: No USER_ID given
DEBUG 01-14 09:37:45.441 o.a.o.i.ImportInitvalues:505 [main] - conference_Id: 16
DEBUG 01-14 09:37:45.446 o.a.o.i.ImportInitvalues:512 [main] - restricted_Id: 18
DEBUG 01-14 09:37:45.448 o.a.o.i.ImportInitvalues:516 [main] - interview_Id: 19
DEBUG 01-14 09:37:45.450 o.a.o.i.ImportInitvalues:521 [main] - RoomTypes ADDED
DEBUG 01-14 09:37:45.537 o.a.o.i.ImportInitvalues:499 [main] - Configuration ADDED
DEBUG 01-14 09:37:45.539 o.a.o.s.o.BackupImportController:201 [main] - ##### WRITE FILE TO: /usr/lib/red5/webapps/openmeetings/upload/import/import_2014_01_14_09_37_45
INFO 01-14 09:42:26.669 o.a.o.s.o.BackupImportController:240 [main] - Organizations import complete, starting user import
mysql> show tables;
+-------------------------+
| Tables_in_openmeetings |
+-------------------------+
| address |
| appointmentcategory |
| appointmentremindertyps |
| appointments |
| chat |
| client |
| conferencelog |
| conferencelogtype |
| configuration |
| email_queue |
| errortypes |
| errorvalue |
| fieldlanguage |
| fieldlanguagesvalues |
| fieldvalues |
| fileexploreritem |
| flvrecording |
| flvrecording_log |
| flvrecording_meta_delta |
| flvrecording_metadata |
| invitations |
| ldapconfig |
| meeting_members |
| naviglobal |
| navimain |
| om_timezone |
| om_user |
| organisation |
| organisation_users |
| poll_types |
| private_message |
| private_messages_folder |
| room |
| room_poll_answers |
| room_polls |
| rooms_moderator |
| rooms_organisation |
| roomtype |
| salutation |
| server |
| sessiondata |
| sipusers |
| soaplogin |
| state |
| user_contact |
| user_data |
| user_level |
| whiteboard |
| whiteboard_item |
+-------------------------+
49 rows in set (0.00 sec)
=========================================================
mysql> show tables;
+-------------------------+
| Tables_in_openmeetings |
+-------------------------+
| OPENJPA_SEQUENCE_TABLE |
| adresses |
| appointmentcategory |
| appointmentremindertyps |
| appointments |
| conferencelog |
| conferencelogtype |
| configuration |
| errortypes |
| errorvalues |
| extensions |
| fieldlanguage |
| fieldlanguagesvalues |
| fieldvalues |
| fileexploreritem |
| flvrecording |
| flvrecording_log |
| flvrecording_meta_delta |
| flvrecording_metadata |
| invitations |
| ldapconfig |
| meeting_members |
| meetme |
| naviglobal |
| navimain |
| om_timezone |
| open_xg_return_object |
| organisation |
| organisation_users |
| poll_types |
| private_messages |
| private_messages_folder |
| room_poll_answers |
| room_polls |
| rooms |
| rooms_moderator |
| rooms_organisation |
| roomtypes |
| salutations |
| sessiondata |
| sipusers |
| soaplogin |
| states |
| user_contacts |
| user_sip_data |
| userdata |
| userlevel |
| users |
+-------------------------+
48 rows in set (0.00 sec)
=================================================
mysql> show columns from om_user;
+-------------------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------------------+--------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| activatehash | varchar(255) | YES | | NULL | |
| age | datetime | YES | | NULL | |
| availible | int(11) | YES | | NULL | |
| deleted | bit(1) | YES | | NULL | |
| externalUserId | varchar(255) | YES | | NULL | |
| externalUserType | varchar(255) | YES | | NULL | |
| firstname | varchar(255) | YES | | NULL | |
| forceTimeZoneCheck | bit(1) | YES | | NULL | |
| language_id | bigint(20) | YES | | NULL | |
| lastlogin | datetime | YES | | NULL | |
| lastname | varchar(255) | YES | | NULL | |
| lasttrans | bigint(20) | YES | | NULL | |
| level_id | bigint(20) | YES | | NULL | |
| login | varchar(255) | YES | | NULL | |
| password | varchar(255) | YES | | NULL | |
| pictureuri | varchar(255) | YES | | NULL | |
| regdate | datetime | YES | | NULL | |
| resethash | varchar(255) | YES | | NULL | |
| salutations_id | bigint(20) | YES | | NULL | |
| sendSMS | bit(1) | YES | | NULL | |
| show_contact_data | bit(1) | YES | | NULL | |
| show_contact_data_to_contacts | bit(1) | YES | | NULL | |
| starttime | datetime | YES | | NULL | |
| status | int(11) | YES | | NULL | |
| updatetime | datetime | YES | | NULL | |
| user_offers | varchar(255) | YES | | NULL | |
| user_searchs | varchar(255) | YES | | NULL | |
| adresses_id | bigint(20) | YES | MUL | NULL | |
| omtimezoneId | bigint(20) | YES | MUL | NULL | |
| sip_user_id | bigint(20) | YES | MUL | NULL | |
+-------------------------------+--------------+------+-----+---------+----------------+
31 rows in set (0.01 sec)
=============================================================
Old Users
mysql> show columns from users;
+-------------------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------------------+--------------+------+-----+---------+----------------+
| user_id | bigint(20) | NO | PRI | NULL | auto_increment |
| activatehash | varchar(255) | YES | | NULL | |
| age | datetime | YES | | NULL | |
| availible | int(11) | YES | | NULL | |
| deleted | varchar(255) | YES | | NULL | |
| externalUserId | varchar(255) | YES | | NULL | |
| externalUserType | varchar(255) | YES | | NULL | |
| firstname | varchar(255) | YES | | NULL | |
| forceTimeZoneCheck | bit(1) | YES | | NULL | |
| language_id | bigint(20) | YES | | NULL | |
| lastlogin | datetime | YES | | NULL | |
| lastname | varchar(255) | YES | | NULL | |
| lasttrans | bigint(20) | YES | | NULL | |
| level_id | bigint(20) | YES | | NULL | |
| login | varchar(255) | YES | | NULL | |
| password | varchar(255) | YES | | NULL | |
| pictureuri | varchar(255) | YES | | NULL | |
| regdate | datetime | YES | | NULL | |
| resethash | varchar(255) | YES | | NULL | |
| show_contact_data | bit(1) | YES | | NULL | |
| show_contact_data_to_contacts | bit(1) | YES | | NULL | |
| starttime | datetime | YES | | NULL | |
| status | int(11) | YES | | NULL | |
| title_id | int(11) | YES | | NULL | |
| updatetime | datetime | YES | | NULL | |
| user_offers | varchar(255) | YES | | NULL | |
| user_searchs | varchar(255) | YES | | NULL | |
| adresses_id | bigint(20) | YES | MUL | NULL | |
| omtimezoneId | bigint(20) | YES | MUL | NULL | |
| userSipDataId | bigint(20) | YES | MUL | NULL | |
+-------------------------------+--------------+------+-----+---------+----------------+
30 rows in set (0.00 sec)
==================================================================================
Thanks,
George Kirkham
OpenMeetings 2.2.0 - Changing http port from 5080 to 80
Posted by George Kirkham <gk...@co2crc.com.au>.
Hi,
Have a number of issues getting OpenMeetings 2.2.0 working under a Debian Wheezy server.
Issue #1: I normally run OpenMeetings on port 80 (there is no Apache web server on the Debian Wheezy server), but when I change the port from 5080 to 80, nothing is listening on port 80, where it was listening under port 5080 before the changes.
Are there other settings that need to be changed ?
Why is OpenMeetings not listening on port 80 after the configuration files have been changed and the server has been restarted. ?
Unable to get the server to listen on port 80.
Checking ports before changing to port 80 (or changing back from port 80 to port 5080)
root@co2om01:~# /etc/init.d/red5 checkports
tcp6 0 0 :::59022 :::* LISTEN 3585/java
tcp6 0 0 :::1935 :::* LISTEN 3585/java
tcp6 0 0 :::9999 :::* LISTEN 3585/java
tcp6 0 0 :::5080 :::* LISTEN 3585/java
Stop OpenMeetings and make changes;
/usr/lib/red5/webapps/openmeetings/config.xml
<red5httpport>80</red5httpport>
----------------------------------------------
/usr/lib/red5/conf/red5.properties
# HTTP
http.port=80
==================================================================================
After making changes start OpenMeetings and check ports
-------------------------------------------------
tcp6 0 0 :::1935 :::* LISTEN 2854/java
tcp6 0 0 :::9999 :::* LISTEN 2854/java
tcp6 0 0 :::53822 :::* LISTEN 2854/java
Thanks,
Re: Configuration for Live operation
Posted by Rene' Rosenbaum <re...@meecoda.de>.
Dear Maxime,
got it, thanks!
Rene'
~~~~~~~
*Dr.-Ing. Rene' Rosenbaum
meeCoda^IT * - Consulting and Services
~: Neue Reihe 15, 18182 Goorstorf, Germany
#: ++49-(0)-1781408041
@:info@meecoda.de <ma...@meecoda.de>
//:www.meecoda.de <http://www.meecoda.de>
~~~~~~~~~~~~~~ +++ ~~~~~~~~~~~~~~~~
On 1/13/2014 6:22 PM, Maxim Solodovnik wrote:
> profiling is the process of finding "bottlenecks" in performance (the
> parts of the code consuming lots of time and need to be optimized)
>
>
> On Mon, Jan 13, 2014 at 10:44 PM, Rene' Rosenbaum <rene@meecoda.de
> <ma...@meecoda.de>> wrote:
>
> Dear Maxime,
> thanks for your answer. Quick question: What do you mean by "to
> profile"?
> Cheers,
> Rene'
>
> ~~~~~~~
> *Dr.-Ing. Rene' Rosenbaum
> meeCoda^IT * - Consulting and Services
> ~: Neue Reihe 15, 18182 Goorstorf, Germany
> #: ++49-(0)-1781408041
> @:info@meecoda.de <ma...@meecoda.de>
> //:www.meecoda.de <http://www.meecoda.de>
> ~~~~~~~~~~~~~~ +++ ~~~~~~~~~~~~~~~~
>
> On 1/10/2014 6:28 PM, Maxim Solodovnik wrote:
>> I believe speed up might be possible after internal optimizations
>> (after profiling)
>> I will try to profile OM after 3.0 release (I guess it is better
>> to profile after 3.1, I think 3.1 might work faster)
>>
>>
>> On Fri, Jan 10, 2014 at 6:23 PM, Rene' Rosenbaum <rene@meecoda.de
>> <ma...@meecoda.de>> wrote:
>>
>> Hi all,
>> after quite a while of development, we want to go live with
>> our (slightly, though) adapted OM. Is there yet any source
>> what configurations may be applied to speed up OM for live
>> operation? I know there is the high-perf start script of
>> red5, but expect that there is much more here. When the list
>> of proposals exceeds a meaningful length, I'll compile all
>> the different points to put them on the website (guess this
>> is of general interest).
>> Help is highly appreciated!!!
>> Cheers,
>> Rene'
>>
>> ~~~~~~~
>> *Dr.-Ing. Rene' Rosenbaum
>> meeCoda^IT * - Consulting and Services
>> ~: Neue Reihe 15, 18182 Goorstorf, Germany
>> #: ++49-(0)-1781408041
>> @:info@meecoda.de <ma...@meecoda.de>
>> //:www.meecoda.de <http://www.meecoda.de>
>> ~~~~~~~~~~~~~~ +++ ~~~~~~~~~~~~~~~~
>>
>> On 12/29/2013 9:54 AM, Jean-Marie Landri wrote:
>>> Hello,
>>> Trying to add 2 image button to direct edit the profile
>>> settings and the contact and messages/ -
>>> but the link doesnt work, where am i rong?
>>> code-
>>>
>>> <image name="contact_message_icon"
>>> resource="contact_message_icon" x="10" y="0" height="40"
>>> width="40">
>>> onclick="this.parent.storeSettings();">
>>> <handler name="onclick">
>>> canvas.userSettingsModuleOpt = "userProfile";
>>> quicklinkActAct("_editUserContacts");
>>> </handler>
>>> <labelTooltip labelid="1259" />
>>> </image>
>>>
>>>
>>>
>>> <image name="user_profile_icon" resource="user_profile_icon"
>>> x="10" y="0" height="40" width="40">
>>> onclick="this.parent.storeSettings();">
>>> <handler name="onclick">
>>> canvas.userSettingsModuleOpt = "userProfile";
>>> quicklinkAct("_editUserProfile");
>>> </handler>
>>> <labelTooltip labelid="377" />
>>>
>>> </image>
>>>
>>> Thank you?
>>>
>>
>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>
>
>
>
> --
> WBR
> Maxim aka solomax
Re: Configuration for Live operation
Posted by Maxim Solodovnik <so...@gmail.com>.
profiling is the process of finding "bottlenecks" in performance (the parts
of the code consuming lots of time and need to be optimized)
On Mon, Jan 13, 2014 at 10:44 PM, Rene' Rosenbaum <re...@meecoda.de> wrote:
> Dear Maxime,
> thanks for your answer. Quick question: What do you mean by "to profile"?
> Cheers,
> Rene'
>
> ~~~~~~~*Dr.-Ing. Rene' Rosenbaum
> meeCodaIT* - Consulting and Services
> ~: Neue Reihe 15, 18182 Goorstorf, Germany
> #: ++49-(0)-1781408041
> @: info@meecoda.de
> //: www.meecoda.de
> ~~~~~~~~~~~~~~ +++ ~~~~~~~~~~~~~~~~
>
> On 1/10/2014 6:28 PM, Maxim Solodovnik wrote:
>
> I believe speed up might be possible after internal optimizations (after
> profiling)
> I will try to profile OM after 3.0 release (I guess it is better to
> profile after 3.1, I think 3.1 might work faster)
>
>
> On Fri, Jan 10, 2014 at 6:23 PM, Rene' Rosenbaum <re...@meecoda.de> wrote:
>
>> Hi all,
>> after quite a while of development, we want to go live with our
>> (slightly, though) adapted OM. Is there yet any source what configurations
>> may be applied to speed up OM for live operation? I know there is the
>> high-perf start script of red5, but expect that there is much more here.
>> When the list of proposals exceeds a meaningful length, I'll compile all
>> the different points to put them on the website (guess this is of general
>> interest).
>> Help is highly appreciated!!!
>> Cheers,
>> Rene'
>>
>> ~~~~~~~*Dr.-Ing. Rene' Rosenbaum
>> meeCodaIT* - Consulting and Services
>> ~: Neue Reihe 15, 18182 Goorstorf, Germany
>> #: ++49-(0)-1781408041
>> @: info@meecoda.de
>> //: www.meecoda.de
>> ~~~~~~~~~~~~~~ +++ ~~~~~~~~~~~~~~~~
>>
>> On 12/29/2013 9:54 AM, Jean-Marie Landri wrote:
>>
>> Hello,
>> Trying to add 2 image button to direct edit the profile settings and the
>> contact and messages/ -
>> but the link doesnt work, where am i rong?
>> code-
>>
>> <image name="contact_message_icon" resource="contact_message_icon"
>> x="10" y="0" height="40" width="40">
>> onclick="this.parent.storeSettings();">
>> <handler name="onclick">
>> canvas.userSettingsModuleOpt = "userProfile";
>> quicklinkActAct("_editUserContacts");
>> </handler>
>> <labelTooltip labelid="1259" />
>> </image>
>>
>>
>>
>> <image name="user_profile_icon" resource="user_profile_icon" x="10"
>> y="0" height="40" width="40">
>> onclick="this.parent.storeSettings();">
>> <handler name="onclick">
>> canvas.userSettingsModuleOpt = "userProfile";
>> quicklinkAct("_editUserProfile");
>> </handler>
>> <labelTooltip labelid="377" />
>>
>> </image>
>>
>> Thank you?
>>
>>
>>
>
>
> --
> WBR
> Maxim aka solomax
>
>
>
--
WBR
Maxim aka solomax
Re: Configuration for Live operation
Posted by Rene' Rosenbaum <re...@meecoda.de>.
Dear Maxime,
thanks for your answer. Quick question: What do you mean by "to profile"?
Cheers,
Rene'
~~~~~~~
*Dr.-Ing. Rene' Rosenbaum
meeCoda^IT * - Consulting and Services
~: Neue Reihe 15, 18182 Goorstorf, Germany
#: ++49-(0)-1781408041
@:info@meecoda.de <ma...@meecoda.de>
//:www.meecoda.de <http://www.meecoda.de>
~~~~~~~~~~~~~~ +++ ~~~~~~~~~~~~~~~~
On 1/10/2014 6:28 PM, Maxim Solodovnik wrote:
> I believe speed up might be possible after internal optimizations
> (after profiling)
> I will try to profile OM after 3.0 release (I guess it is better to
> profile after 3.1, I think 3.1 might work faster)
>
>
> On Fri, Jan 10, 2014 at 6:23 PM, Rene' Rosenbaum <rene@meecoda.de
> <ma...@meecoda.de>> wrote:
>
> Hi all,
> after quite a while of development, we want to go live with our
> (slightly, though) adapted OM. Is there yet any source what
> configurations may be applied to speed up OM for live operation? I
> know there is the high-perf start script of red5, but expect that
> there is much more here. When the list of proposals exceeds a
> meaningful length, I'll compile all the different points to put
> them on the website (guess this is of general interest).
> Help is highly appreciated!!!
> Cheers,
> Rene'
>
> ~~~~~~~
> *Dr.-Ing. Rene' Rosenbaum
> meeCoda^IT * - Consulting and Services
> ~: Neue Reihe 15, 18182 Goorstorf, Germany
> #: ++49-(0)-1781408041
> @:info@meecoda.de <ma...@meecoda.de>
> //:www.meecoda.de <http://www.meecoda.de>
> ~~~~~~~~~~~~~~ +++ ~~~~~~~~~~~~~~~~
>
> On 12/29/2013 9:54 AM, Jean-Marie Landri wrote:
>> Hello,
>> Trying to add 2 image button to direct edit the profile settings
>> and the contact and messages/ -
>> but the link doesnt work, where am i rong?
>> code-
>>
>> <image name="contact_message_icon"
>> resource="contact_message_icon" x="10" y="0" height="40"
>> width="40">
>> onclick="this.parent.storeSettings();">
>> <handler name="onclick">
>> canvas.userSettingsModuleOpt = "userProfile";
>> quicklinkActAct("_editUserContacts");
>> </handler>
>> <labelTooltip labelid="1259" />
>> </image>
>>
>>
>>
>> <image name="user_profile_icon" resource="user_profile_icon"
>> x="10" y="0" height="40" width="40">
>> onclick="this.parent.storeSettings();">
>> <handler name="onclick">
>> canvas.userSettingsModuleOpt = "userProfile";
>> quicklinkAct("_editUserProfile");
>> </handler>
>> <labelTooltip labelid="377" />
>>
>> </image>
>>
>> Thank you?
>>
>
>
>
>
> --
> WBR
> Maxim aka solomax
Re: Configuration for Live operation
Posted by Maxim Solodovnik <so...@gmail.com>.
I believe speed up might be possible after internal optimizations (after
profiling)
I will try to profile OM after 3.0 release (I guess it is better to profile
after 3.1, I think 3.1 might work faster)
On Fri, Jan 10, 2014 at 6:23 PM, Rene' Rosenbaum <re...@meecoda.de> wrote:
> Hi all,
> after quite a while of development, we want to go live with our (slightly,
> though) adapted OM. Is there yet any source what configurations may be
> applied to speed up OM for live operation? I know there is the high-perf
> start script of red5, but expect that there is much more here. When the
> list of proposals exceeds a meaningful length, I'll compile all the
> different points to put them on the website (guess this is of general
> interest).
> Help is highly appreciated!!!
> Cheers,
> Rene'
>
> ~~~~~~~*Dr.-Ing. Rene' Rosenbaum
> meeCodaIT* - Consulting and Services
> ~: Neue Reihe 15, 18182 Goorstorf, Germany
> #: ++49-(0)-1781408041
> @: info@meecoda.de
> //: www.meecoda.de
> ~~~~~~~~~~~~~~ +++ ~~~~~~~~~~~~~~~~
>
> On 12/29/2013 9:54 AM, Jean-Marie Landri wrote:
>
> Hello,
> Trying to add 2 image button to direct edit the profile settings and the
> contact and messages/ -
> but the link doesnt work, where am i rong?
> code-
>
> <image name="contact_message_icon" resource="contact_message_icon"
> x="10" y="0" height="40" width="40">
> onclick="this.parent.storeSettings();">
> <handler name="onclick">
> canvas.userSettingsModuleOpt = "userProfile";
> quicklinkActAct("_editUserContacts");
> </handler>
> <labelTooltip labelid="1259" />
> </image>
>
>
>
> <image name="user_profile_icon" resource="user_profile_icon" x="10"
> y="0" height="40" width="40">
> onclick="this.parent.storeSettings();">
> <handler name="onclick">
> canvas.userSettingsModuleOpt = "userProfile";
> quicklinkAct("_editUserProfile");
> </handler>
> <labelTooltip labelid="377" />
>
> </image>
>
> Thank you?
>
>
>
--
WBR
Maxim aka solomax
Configuration for Live operation
Posted by Rene' Rosenbaum <re...@meecoda.de>.
Hi all,
after quite a while of development, we want to go live with our
(slightly, though) adapted OM. Is there yet any source what
configurations may be applied to speed up OM for live operation? I know
there is the high-perf start script of red5, but expect that there is
much more here. When the list of proposals exceeds a meaningful length,
I'll compile all the different points to put them on the website (guess
this is of general interest).
Help is highly appreciated!!!
Cheers,
Rene'
~~~~~~~
*Dr.-Ing. Rene' Rosenbaum
meeCoda^IT * - Consulting and Services
~: Neue Reihe 15, 18182 Goorstorf, Germany
#: ++49-(0)-1781408041
@:info@meecoda.de <ma...@meecoda.de>
//:www.meecoda.de <http://www.meecoda.de>
~~~~~~~~~~~~~~ +++ ~~~~~~~~~~~~~~~~
On 12/29/2013 9:54 AM, Jean-Marie Landri wrote:
> Hello,
> Trying to add 2 image button to direct edit the profile settings and
> the contact and messages/ -
> but the link doesnt work, where am i rong?
> code-
>
> <image name="contact_message_icon" resource="contact_message_icon"
> x="10" y="0" height="40" width="40">
> onclick="this.parent.storeSettings();">
> <handler name="onclick">
> canvas.userSettingsModuleOpt = "userProfile";
> quicklinkActAct("_editUserContacts");
> </handler>
> <labelTooltip labelid="1259" />
> </image>
>
>
>
> <image name="user_profile_icon" resource="user_profile_icon" x="10"
> y="0" height="40" width="40">
> onclick="this.parent.storeSettings();">
> <handler name="onclick">
> canvas.userSettingsModuleOpt = "userProfile";
> quicklinkAct("_editUserProfile");
> </handler>
> <labelTooltip labelid="377" />
>
> </image>
>
> Thank you?
>