You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by aa...@gmail.com on 2018/08/04 01:18:43 UTC
Conference Room creation update error
Looks like an old error is back. I just installed the latest nightly build
and now get thrown to the internal error page if you try to update and
existing conference room or when you type the first letter for a new room
name. Looks like the old error where even if the user was granted admin
access Group Admin Access is denied (see attached log)
Version4.0.5-SNAPSHOT
Revisionb154bef
Build date2018-08-03T10:13:48Z
Also looks like when doing the import there is a problem. When you are 1st
setting up your new install of OM you create an admin account; so in the
database that is "Profile 1". Where the problem lies is when you do an
export from your old system it also exports the old "admin" account (which
on the old system was also profile_1) but when you do the import since there
is already a profile_1 it moves everything down 1 so the old admin account
become id 2 on down the line. My account when exported was profile_2 but
now my account is now labeled as profile_3 so the image is not there but the
old admin account has my profile.jpg. (also in attachment)
Re: Conference Room creation update error
Posted by Maxim Solodovnik <so...@gmail.com>.
Should be fixed!
Thanks for catching this!
On Thu, Aug 9, 2018 at 3:50 AM <aa...@gmail.com> wrote:
>
> I just did the latest snapshot and the import worked as expected using the UI. I would say I had a corrupted back-up was the reason for the failure of placing profiles in the right area.
>
> I can confirm the whiteboard issue is resolved when creating a new WB an image will be uploaded. But now I see a new "clean up" item that may need to be addressed when ever time allows as this is not really a big issue.
>
> When you delete files and drag them up to the garbage, they files get deleted, but it looks like it leaves remnants of their file name and image icon stuck between the folder icons and where My files start (See attached)
>
> Once you exit and come back in, that is gone, so not really an issue. Just some housekeeping for later on.
>
> -----Original Message-----
> From: Maxim Solodovnik <so...@gmail.com>
> Sent: Wednesday, August 8, 2018 8:11 AM
> To: Openmeetings user-list <us...@openmeetings.apache.org>
> Subject: Re: Conference Room creation update error
>
> Hello Aaron,
>
> Just have tested with UI restore from backup Profile picture import works as expected On Tue, Aug 7, 2018 at 1:06 PM Maxim Solodovnik <so...@gmail.com> wrote:
> >
> > No need to file JIRA :)
> > The issue was caused by fix for [OPENMEETINGS-1908] Should be fixed in
> > a new build On Tue, Aug 7, 2018 at 12:22 PM Maxim Solodovnik
> > <so...@gmail.com> wrote:
> > >
> > > Thanks for the report!
> > > Can you please check if this bug is reproducible on 4.0.4?
> > > (https://om.alteametasoft.com/openmeetings/)
> > > and file JIRA?
> > > On Tue, Aug 7, 2018 at 4:49 AM <aa...@gmail.com> wrote:
> > > >
> > > > Ok looks like the error can be reproduced with the demo as well.
> > > >
> > > > When the room is 1st entered on a fresh reboot the white board is present and you can upload a file to that.
> > > >
> > > > But if you close the original WB and then open a new WB you cannot upload a file to the WB. It remains blank.
> > > >
> > > > I have attached the debug log but it does not tell much (to myself
> > > > that is)
> > > >
> > > > -----Original Message-----
> > > > From: Maxim Solodovnik <so...@gmail.com>
> > > > Sent: Monday, August 6, 2018 12:22 PM
> > > > To: Openmeetings user-list <us...@openmeetings.apache.org>
> > > > Subject: Re: Conference Room creation update error
> > > >
> > > > Demo-next is updated to latest revision On Mon, Aug 6, 2018 at
> > > > 10:10 PM <aa...@gmail.com> wrote:
> > > > >
> > > > > Ok. If they are skipped on import then no need to delete the dB object. I just noticed when the backup was ran they were still listed, was the only reason for the delete.
> > > > >
> > > > > If you/someone has the latest snapshot running (revision 3f2c95f) can they test something for me. I am currently running live with the startup script so I cannot get the debug information until after the day is over. But looks like I cannot upload a file to the WB. May be localized, but was wondering if one had the revision up and going if they could test. This is the same VM that has been ran previous version so all needed pacakges should already be installed.
> > > > >
> > > > > Demo looks like its still running some revisions back so couldn't test there.
> > > > >
> > > > > -----Original Message-----
> > > > > From: Maxim Solodovnik <so...@gmail.com>
> > > > > Sent: Monday, August 6, 2018 11:01 AM
> > > > > To: Openmeetings user-list <us...@openmeetings.apache.org>
> > > > > Subject: Re: Conference Room creation update error
> > > > >
> > > > > Actually both command line and UI installers uses same java code
> > > > > I'll retest with UI installer ASAP
> > > > >
> > > > > According to your question: deleted/purged users are included
> > > > > into XML backup files, but are being skipped during import
> > > > >
> > > > > I would not recommend to run queries like 'delete from om_user
> > > > > where id = #' since data integrity will be broken Here is the
> > > > > brief list of what need to done for user "hard" delete
> > > > > https://issues.apache.org/jira/browse/OPENMEETINGS-1864 (hard
> > > > > delete
> > > > > section)
> > > > > On Sun, Aug 5, 2018 at 5:14 PM Aaron H <aa...@gmail.com> wrote:
> > > > > >
> > > > > > Took a back-up of running system *one thing to note that prior to back-up being preformed there was users that were purged, but also deleted from the dB via manual process (delete from om_user where id = #) Wasn't for sure if the back-up would pick up these "purged" users reason for the manual deletion. Everything was restarted before back-up was performed.
> > > > > >
> > > > > > Then followed the normal steps for a build
> > > > > >
> > > > > > Move current install to old
> > > > > > * mv /opt/current /opt/old
> > > > > > Delete existing dB and create new wGET new package and unzip
> > > > > > in /opt/current folder Run new install script *script copies
> > > > > > customization files from stored location into new install (can
> > > > > > supply list of files that are copied if needed) Restart server
> > > > > > Run sh red5.sh to start process Go through the setup process
> > > > > > and restart server once complete
> > > > > > * during setup the tick for install default objects is not
> > > > > > selected Log in as admin and preformed import
> > > > > >
> > > > > > After the import was ran it put everything into the folder
> > > > > > /webapps/Openmeetings/upload/import/import_2018_08_04_05_59_04
> > > > > > /roomF
> > > > > > il
> > > > > > es/profiles
> > > > > >
> > > > > > I had never did a command line import as I have always done it after the system was configured. Since your import was successful then I would assume there is something wrong with the back-up that was taken and not a bug.
> > > > > >
> > > > > > One question to see if the step still needs to be taken. When you delete a user and it creates the "purged" information; when you take a back-up are those entries also included or does it omit them? Since I still seen the entries in the dB I figured that the back-up would include this data. That is the reason for the manual deletion prior to taking the backup.
> > > > > >
> > > > > >
> > > > > > -----Original Message-----
> > > > > > From: Maxim Solodovnik <so...@gmail.com>
> > > > > > Sent: Sunday, August 5, 2018 12:16 AM
> > > > > > To: Openmeetings user-list <us...@openmeetings.apache.org>
> > > > > > Subject: Re: Conference Room creation update error
> > > > > >
> > > > > > Just performed command line import ~50k users with lots of
> > > > > > profile pictures All images seems to be preserved So
> > > > > > everything seems to work as expected
> > > > > >
> > > > > > `./admin.sh -v -i -file
> > > > > > ~/work/openmeetings/backup/backup_2015_12_07_03_35_39.zip`
> > > > > >
> > > > > > Could you please provide your steps?
> > > > > >
> > > > > > On Sun, Aug 5, 2018 at 10:35 AM Maxim Solodovnik <so...@gmail.com> wrote:
> > > > > > >
> > > > > > > According to pictures uploaded by users: format change does
> > > > > > > not affect such profile images, cause file name with
> > > > > > > extension is stored in xml/DB :))) On Sun, Aug 5, 2018 at
> > > > > > > 10:30 AM Maxim Solodovnik <so...@gmail.com> wrote:
> > > > > > > >
> > > > > > > > Hello Aaron,
> > > > > > > >
> > > > > > > > Thanks for detailed testing Profile folders should be
> > > > > > > > moved to proper locations ...
> > > > > > > > (https://github.com/apache/openmeetings/blob/4.0.x/openmee
> > > > > > > > tings-
> > > > > > > > in
> > > > > > > > st
> > > > > > > > all/src/main/java/org/apache/openmeetings/backup/BackupImp
> > > > > > > > ort.ja
> > > > > > > > va
> > > > > > > > #L
> > > > > > > > 1040)
> > > > > > > >
> > > > > > > > I'll double-check and report back On Sun, Aug 5, 2018 at
> > > > > > > > 2:42 AM Aaron H <aa...@gmail.com> wrote:
> > > > > > > > >
> > > > > > > > > After further testing it will still accept the profile image being in jpg format. Any new image will be saved in the .png format.
> > > > > > > > >
> > > > > > > > > Looks like my problem I was having was due to the import not running properly (I'm assuming). The user.xml import was successful (as all user data was there), but what failed was putting each user's profile (profile_#) into the proper place /webapps/openmeeting/upload/profiles/. Instead it left all the files in the import/<importdatetime>/roomfiles/profiles/ folder. So while the users.xml files was parsed and it said in each profile_# the profile image was profile.jpg, that jpg file did not exist due to it not being imported properly.
> > > > > > > > >
> > > > > > > > > After manually moving each users profile_# folder into the proper place everything worked as expected. If a user had no stored image then there was no need to do the import as their profile would be created on their returning login.
> > > > > > > > >
> > > > > > > > > So it was either 1 of 2 things. Either A) a bad import function (as imported filed were placed in wrong locations, or B) import partially failed due to image format change. Was 4.0.4 image format still .jpg or had that one been moved to .png? I was going to stand up an official release if file format was still .jpg to see if it can narrow down what caused the import to not run fully.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > -----Original Message-----
> > > > > > > > > From: aaron.hepp@gmail.com <aa...@gmail.com>
> > > > > > > > > Sent: Saturday, August 4, 2018 6:23 AM
> > > > > > > > > To: user@openmeetings.apache.org
> > > > > > > > > Subject: RE: Conference Room creation update error
> > > > > > > > >
> > > > > > > > > Yes looks like the room crashing has been resolved. Thank you for the prompt fix.
> > > > > > > > >
> > > > > > > > > The profile image I am referring to is the default profile image that is located at /webapps/Openmeetings/images/profile.* But I see why the issue. Looks like the default image format was changed from .jpg to .png and in my customization script I was importing profile.jpg so I changed the script to .png and this resolved that issue. Didn't notice the file extension had changed.
> > > > > > > > >
> > > > > > > > > The last issue I am seeing is the import from the previous backup.
> > > > > > > > > It is importing all the users data for the database
> > > > > > > > > account name / password / contact info / .etc, but it is
> > > > > > > > > not importing the users profile image they had uploaded.
> > > > > > > > > The import was placed at
> > > > > > > > >
> > > > > > > > > /webapps/Openmeetings/upload/import/import_2018_08_04_05
> > > > > > > > > _59_04
> > > > > > > > > /r
> > > > > > > > > oo
> > > > > > > > > mFiles/profiles/
> > > > > > > > >
> > > > > > > > > so when a returning user logs in their profile is created:
> > > > > > > > >
> > > > > > > > > /webapps/Openmeetings/upload/profiles/
> > > > > > > > >
> > > > > > > > > But just now looking as I uploaded a new profile picture for myself as a test I see the reason. It looks like it stems from the file format change. The backup has everything as profile.jpg where it is looking for a .png file.
> > > > > > > > >
> > > > > > > > > Just a heads up for anyone taking an older backup from a
> > > > > > > > > previous version, you will have to manually copy each
> > > > > > > > > users profile.jpg file from the import folder to each
> > > > > > > > > users profile space as a .png file
> > > > > > > > >
> > > > > > > > > For me this was an example:
> > > > > > > > >
> > > > > > > > > cp
> > > > > > > > > /opt/current/webapps/trade-group/upload/import/import_20
> > > > > > > > > 18_08_
> > > > > > > > > 04
> > > > > > > > > _0 5_59_04/roomFiles/profiles/profile_2/profile.jpg
> > > > > > > > > /opt/current/webapps/trade-group/upload/profiles/profile
> > > > > > > > > _2/pro
> > > > > > > > > fi
> > > > > > > > > le
> > > > > > > > > .png
> > > > > > > > >
> > > > > > > > > this must be done for each user or tell each user that they just have to re-upload their image if they want one.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > -----Original Message-----
> > > > > > > > > From: Maxim Solodovnik <so...@gmail.com>
> > > > > > > > > Sent: Friday, August 3, 2018 11:08 PM
> > > > > > > > > To: Openmeetings user-list
> > > > > > > > > <us...@openmeetings.apache.org>
> > > > > > > > > Subject: Re: Conference Room creation update error
> > > > > > > > >
> > > > > > > > > Just have tried, profile images in jpg format are being displayed as expected Could you please tell me what were your exact steps to reproduce?
> > > > > > > > >
> > > > > > > > > BTW Thanks a lot for checking latest nightly :))) On
> > > > > > > > > Sat, Aug 4,
> > > > > > > > > 2018 at
> > > > > > > > > 9:39 AM Maxim Solodovnik <so...@gmail.com> wrote:
> > > > > > > > > >
> > > > > > > > > > Hello Aaron,
> > > > > > > > > >
> > > > > > > > > > page crash was just fixed Will take a look at profile
> > > > > > > > > > image issue (most probably caused by migration from
> > > > > > > > > > JPG to PNG)
> > > > > > > > > >
> > > > > > > > > > According to new install, then import I would
> > > > > > > > > > recommend to use command line admin in this case
> > > > > > > > > > http://openmeetings.apache.org/CommandLineAdmin.html
> > > > > > > > > > the options I'm using: -file --skip-default-objects
> > > > > > > > > > On Sat, Aug 4,
> > > > > > > > > > 2018 at 9:26 AM <aa...@gmail.com> wrote:
> > > > > > > > > > >
> > > > > > > > > > > Looks like my 1st attachment did not have the complete debug in it.
> > > > > > > > > > > Attached is the full log.
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > Looks like also whatever is causing this error is
> > > > > > > > > > > also what is causing the import not to work
> > > > > > > > > > > properly. I use a different profile.jpg image for
> > > > > > > > > > > default users (located at
> > > > > > > > > > > /webapps/openmeetings/images/profile.jpg) and that
> > > > > > > > > > > does not get shown on the users profile. It is
> > > > > > > > > > > pulling the image that is the standard image that has the question mark in the body.
> > > > > > > > > > > Not even sure where it is pulling that from since
> > > > > > > > > > > the file was replaced with a different file all
> > > > > > > > > > > together. When you copy the image location it
> > > > > > > > > > > states
> > > > > > > > > > > (/profile/1?anticache=1532949138000)
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > I re-installed the official release and that one
> > > > > > > > > > > works as expected (room configuration and changed
> > > > > > > > > > > default image)
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > From: aaron.hepp@gmail.com <aa...@gmail.com>
> > > > > > > > > > > Sent: Friday, August 3, 2018 9:19 PM
> > > > > > > > > > > To: user@openmeetings.apache.org
> > > > > > > > > > > Subject: Conference Room creation update error
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > Looks like an old error is back. I just installed
> > > > > > > > > > > the latest nightly build and now get thrown to the
> > > > > > > > > > > internal error page if you try to update and
> > > > > > > > > > > existing conference room or when you type the first letter for a new room name.
> > > > > > > > > > > Looks like the old error where even if the user was
> > > > > > > > > > > granted admin access Group Admin Access is denied
> > > > > > > > > > > (see attached log)
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > Version4.0.5-SNAPSHOT
> > > > > > > > > > >
> > > > > > > > > > > Revisionb154bef
> > > > > > > > > > >
> > > > > > > > > > > Build date2018-08-03T10:13:48Z
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > Also looks like when doing the import there is a problem.
> > > > > > > > > > > When you are 1st setting up your new install of OM
> > > > > > > > > > > you create an admin account; so in the database that is “Profile 1”.
> > > > > > > > > > > Where the problem lies is when you do an export from
> > > > > > > > > > > your old system it also exports the old “admin”
> > > > > > > > > > > account (which on the old system was also profile_1)
> > > > > > > > > > > but when you do the import since there is already a
> > > > > > > > > > > profile_1 it moves everything down 1 so the old admin account become id 2 on down the line. My account when exported was profile_2 but now my account is now labeled as profile_3 so the
> > > > > > > > > > > image is not there but the old admin account has my profile.jpg. (also
> > > > > > > > > > > in attachment)
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > --
> > > > > > > > > > WBR
> > > > > > > > > > Maxim aka solomax
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > --
> > > > > > > > > WBR
> > > > > > > > > Maxim aka solomax
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > --
> > > > > > > > WBR
> > > > > > > > Maxim aka solomax
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > --
> > > > > > > WBR
> > > > > > > Maxim aka solomax
> > > > > >
> > > > > >
> > > > > >
> > > > > > --
> > > > > > WBR
> > > > > > Maxim aka solomax
> > > > > >
> > > > >
> > > > >
> > > > > --
> > > > > WBR
> > > > > Maxim aka solomax
> > > > >
> > > >
> > > >
> > > > --
> > > > WBR
> > > > Maxim aka solomax
> > >
> > >
> > >
> > > --
> > > WBR
> > > Maxim aka solomax
> >
> >
> >
> > --
> > WBR
> > Maxim aka solomax
>
>
>
> --
> WBR
> Maxim aka solomax
--
WBR
Maxim aka solomax
RE: Conference Room creation update error
Posted by aa...@gmail.com.
I just did the latest snapshot and the import worked as expected using the UI. I would say I had a corrupted back-up was the reason for the failure of placing profiles in the right area.
I can confirm the whiteboard issue is resolved when creating a new WB an image will be uploaded. But now I see a new "clean up" item that may need to be addressed when ever time allows as this is not really a big issue.
When you delete files and drag them up to the garbage, they files get deleted, but it looks like it leaves remnants of their file name and image icon stuck between the folder icons and where My files start (See attached)
Once you exit and come back in, that is gone, so not really an issue. Just some housekeeping for later on.
-----Original Message-----
From: Maxim Solodovnik <so...@gmail.com>
Sent: Wednesday, August 8, 2018 8:11 AM
To: Openmeetings user-list <us...@openmeetings.apache.org>
Subject: Re: Conference Room creation update error
Hello Aaron,
Just have tested with UI restore from backup Profile picture import works as expected On Tue, Aug 7, 2018 at 1:06 PM Maxim Solodovnik <so...@gmail.com> wrote:
>
> No need to file JIRA :)
> The issue was caused by fix for [OPENMEETINGS-1908] Should be fixed in
> a new build On Tue, Aug 7, 2018 at 12:22 PM Maxim Solodovnik
> <so...@gmail.com> wrote:
> >
> > Thanks for the report!
> > Can you please check if this bug is reproducible on 4.0.4?
> > (https://om.alteametasoft.com/openmeetings/)
> > and file JIRA?
> > On Tue, Aug 7, 2018 at 4:49 AM <aa...@gmail.com> wrote:
> > >
> > > Ok looks like the error can be reproduced with the demo as well.
> > >
> > > When the room is 1st entered on a fresh reboot the white board is present and you can upload a file to that.
> > >
> > > But if you close the original WB and then open a new WB you cannot upload a file to the WB. It remains blank.
> > >
> > > I have attached the debug log but it does not tell much (to myself
> > > that is)
> > >
> > > -----Original Message-----
> > > From: Maxim Solodovnik <so...@gmail.com>
> > > Sent: Monday, August 6, 2018 12:22 PM
> > > To: Openmeetings user-list <us...@openmeetings.apache.org>
> > > Subject: Re: Conference Room creation update error
> > >
> > > Demo-next is updated to latest revision On Mon, Aug 6, 2018 at
> > > 10:10 PM <aa...@gmail.com> wrote:
> > > >
> > > > Ok. If they are skipped on import then no need to delete the dB object. I just noticed when the backup was ran they were still listed, was the only reason for the delete.
> > > >
> > > > If you/someone has the latest snapshot running (revision 3f2c95f) can they test something for me. I am currently running live with the startup script so I cannot get the debug information until after the day is over. But looks like I cannot upload a file to the WB. May be localized, but was wondering if one had the revision up and going if they could test. This is the same VM that has been ran previous version so all needed pacakges should already be installed.
> > > >
> > > > Demo looks like its still running some revisions back so couldn't test there.
> > > >
> > > > -----Original Message-----
> > > > From: Maxim Solodovnik <so...@gmail.com>
> > > > Sent: Monday, August 6, 2018 11:01 AM
> > > > To: Openmeetings user-list <us...@openmeetings.apache.org>
> > > > Subject: Re: Conference Room creation update error
> > > >
> > > > Actually both command line and UI installers uses same java code
> > > > I'll retest with UI installer ASAP
> > > >
> > > > According to your question: deleted/purged users are included
> > > > into XML backup files, but are being skipped during import
> > > >
> > > > I would not recommend to run queries like 'delete from om_user
> > > > where id = #' since data integrity will be broken Here is the
> > > > brief list of what need to done for user "hard" delete
> > > > https://issues.apache.org/jira/browse/OPENMEETINGS-1864 (hard
> > > > delete
> > > > section)
> > > > On Sun, Aug 5, 2018 at 5:14 PM Aaron H <aa...@gmail.com> wrote:
> > > > >
> > > > > Took a back-up of running system *one thing to note that prior to back-up being preformed there was users that were purged, but also deleted from the dB via manual process (delete from om_user where id = #) Wasn't for sure if the back-up would pick up these "purged" users reason for the manual deletion. Everything was restarted before back-up was performed.
> > > > >
> > > > > Then followed the normal steps for a build
> > > > >
> > > > > Move current install to old
> > > > > * mv /opt/current /opt/old
> > > > > Delete existing dB and create new wGET new package and unzip
> > > > > in /opt/current folder Run new install script *script copies
> > > > > customization files from stored location into new install (can
> > > > > supply list of files that are copied if needed) Restart server
> > > > > Run sh red5.sh to start process Go through the setup process
> > > > > and restart server once complete
> > > > > * during setup the tick for install default objects is not
> > > > > selected Log in as admin and preformed import
> > > > >
> > > > > After the import was ran it put everything into the folder
> > > > > /webapps/Openmeetings/upload/import/import_2018_08_04_05_59_04
> > > > > /roomF
> > > > > il
> > > > > es/profiles
> > > > >
> > > > > I had never did a command line import as I have always done it after the system was configured. Since your import was successful then I would assume there is something wrong with the back-up that was taken and not a bug.
> > > > >
> > > > > One question to see if the step still needs to be taken. When you delete a user and it creates the "purged" information; when you take a back-up are those entries also included or does it omit them? Since I still seen the entries in the dB I figured that the back-up would include this data. That is the reason for the manual deletion prior to taking the backup.
> > > > >
> > > > >
> > > > > -----Original Message-----
> > > > > From: Maxim Solodovnik <so...@gmail.com>
> > > > > Sent: Sunday, August 5, 2018 12:16 AM
> > > > > To: Openmeetings user-list <us...@openmeetings.apache.org>
> > > > > Subject: Re: Conference Room creation update error
> > > > >
> > > > > Just performed command line import ~50k users with lots of
> > > > > profile pictures All images seems to be preserved So
> > > > > everything seems to work as expected
> > > > >
> > > > > `./admin.sh -v -i -file
> > > > > ~/work/openmeetings/backup/backup_2015_12_07_03_35_39.zip`
> > > > >
> > > > > Could you please provide your steps?
> > > > >
> > > > > On Sun, Aug 5, 2018 at 10:35 AM Maxim Solodovnik <so...@gmail.com> wrote:
> > > > > >
> > > > > > According to pictures uploaded by users: format change does
> > > > > > not affect such profile images, cause file name with
> > > > > > extension is stored in xml/DB :))) On Sun, Aug 5, 2018 at
> > > > > > 10:30 AM Maxim Solodovnik <so...@gmail.com> wrote:
> > > > > > >
> > > > > > > Hello Aaron,
> > > > > > >
> > > > > > > Thanks for detailed testing Profile folders should be
> > > > > > > moved to proper locations ...
> > > > > > > (https://github.com/apache/openmeetings/blob/4.0.x/openmee
> > > > > > > tings-
> > > > > > > in
> > > > > > > st
> > > > > > > all/src/main/java/org/apache/openmeetings/backup/BackupImp
> > > > > > > ort.ja
> > > > > > > va
> > > > > > > #L
> > > > > > > 1040)
> > > > > > >
> > > > > > > I'll double-check and report back On Sun, Aug 5, 2018 at
> > > > > > > 2:42 AM Aaron H <aa...@gmail.com> wrote:
> > > > > > > >
> > > > > > > > After further testing it will still accept the profile image being in jpg format. Any new image will be saved in the .png format.
> > > > > > > >
> > > > > > > > Looks like my problem I was having was due to the import not running properly (I'm assuming). The user.xml import was successful (as all user data was there), but what failed was putting each user's profile (profile_#) into the proper place /webapps/openmeeting/upload/profiles/. Instead it left all the files in the import/<importdatetime>/roomfiles/profiles/ folder. So while the users.xml files was parsed and it said in each profile_# the profile image was profile.jpg, that jpg file did not exist due to it not being imported properly.
> > > > > > > >
> > > > > > > > After manually moving each users profile_# folder into the proper place everything worked as expected. If a user had no stored image then there was no need to do the import as their profile would be created on their returning login.
> > > > > > > >
> > > > > > > > So it was either 1 of 2 things. Either A) a bad import function (as imported filed were placed in wrong locations, or B) import partially failed due to image format change. Was 4.0.4 image format still .jpg or had that one been moved to .png? I was going to stand up an official release if file format was still .jpg to see if it can narrow down what caused the import to not run fully.
> > > > > > > >
> > > > > > > >
> > > > > > > > -----Original Message-----
> > > > > > > > From: aaron.hepp@gmail.com <aa...@gmail.com>
> > > > > > > > Sent: Saturday, August 4, 2018 6:23 AM
> > > > > > > > To: user@openmeetings.apache.org
> > > > > > > > Subject: RE: Conference Room creation update error
> > > > > > > >
> > > > > > > > Yes looks like the room crashing has been resolved. Thank you for the prompt fix.
> > > > > > > >
> > > > > > > > The profile image I am referring to is the default profile image that is located at /webapps/Openmeetings/images/profile.* But I see why the issue. Looks like the default image format was changed from .jpg to .png and in my customization script I was importing profile.jpg so I changed the script to .png and this resolved that issue. Didn't notice the file extension had changed.
> > > > > > > >
> > > > > > > > The last issue I am seeing is the import from the previous backup.
> > > > > > > > It is importing all the users data for the database
> > > > > > > > account name / password / contact info / .etc, but it is
> > > > > > > > not importing the users profile image they had uploaded.
> > > > > > > > The import was placed at
> > > > > > > >
> > > > > > > > /webapps/Openmeetings/upload/import/import_2018_08_04_05
> > > > > > > > _59_04
> > > > > > > > /r
> > > > > > > > oo
> > > > > > > > mFiles/profiles/
> > > > > > > >
> > > > > > > > so when a returning user logs in their profile is created:
> > > > > > > >
> > > > > > > > /webapps/Openmeetings/upload/profiles/
> > > > > > > >
> > > > > > > > But just now looking as I uploaded a new profile picture for myself as a test I see the reason. It looks like it stems from the file format change. The backup has everything as profile.jpg where it is looking for a .png file.
> > > > > > > >
> > > > > > > > Just a heads up for anyone taking an older backup from a
> > > > > > > > previous version, you will have to manually copy each
> > > > > > > > users profile.jpg file from the import folder to each
> > > > > > > > users profile space as a .png file
> > > > > > > >
> > > > > > > > For me this was an example:
> > > > > > > >
> > > > > > > > cp
> > > > > > > > /opt/current/webapps/trade-group/upload/import/import_20
> > > > > > > > 18_08_
> > > > > > > > 04
> > > > > > > > _0 5_59_04/roomFiles/profiles/profile_2/profile.jpg
> > > > > > > > /opt/current/webapps/trade-group/upload/profiles/profile
> > > > > > > > _2/pro
> > > > > > > > fi
> > > > > > > > le
> > > > > > > > .png
> > > > > > > >
> > > > > > > > this must be done for each user or tell each user that they just have to re-upload their image if they want one.
> > > > > > > >
> > > > > > > >
> > > > > > > > -----Original Message-----
> > > > > > > > From: Maxim Solodovnik <so...@gmail.com>
> > > > > > > > Sent: Friday, August 3, 2018 11:08 PM
> > > > > > > > To: Openmeetings user-list
> > > > > > > > <us...@openmeetings.apache.org>
> > > > > > > > Subject: Re: Conference Room creation update error
> > > > > > > >
> > > > > > > > Just have tried, profile images in jpg format are being displayed as expected Could you please tell me what were your exact steps to reproduce?
> > > > > > > >
> > > > > > > > BTW Thanks a lot for checking latest nightly :))) On
> > > > > > > > Sat, Aug 4,
> > > > > > > > 2018 at
> > > > > > > > 9:39 AM Maxim Solodovnik <so...@gmail.com> wrote:
> > > > > > > > >
> > > > > > > > > Hello Aaron,
> > > > > > > > >
> > > > > > > > > page crash was just fixed Will take a look at profile
> > > > > > > > > image issue (most probably caused by migration from
> > > > > > > > > JPG to PNG)
> > > > > > > > >
> > > > > > > > > According to new install, then import I would
> > > > > > > > > recommend to use command line admin in this case
> > > > > > > > > http://openmeetings.apache.org/CommandLineAdmin.html
> > > > > > > > > the options I'm using: -file --skip-default-objects
> > > > > > > > > On Sat, Aug 4,
> > > > > > > > > 2018 at 9:26 AM <aa...@gmail.com> wrote:
> > > > > > > > > >
> > > > > > > > > > Looks like my 1st attachment did not have the complete debug in it.
> > > > > > > > > > Attached is the full log.
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > Looks like also whatever is causing this error is
> > > > > > > > > > also what is causing the import not to work
> > > > > > > > > > properly. I use a different profile.jpg image for
> > > > > > > > > > default users (located at
> > > > > > > > > > /webapps/openmeetings/images/profile.jpg) and that
> > > > > > > > > > does not get shown on the users profile. It is
> > > > > > > > > > pulling the image that is the standard image that has the question mark in the body.
> > > > > > > > > > Not even sure where it is pulling that from since
> > > > > > > > > > the file was replaced with a different file all
> > > > > > > > > > together. When you copy the image location it
> > > > > > > > > > states
> > > > > > > > > > (/profile/1?anticache=1532949138000)
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > I re-installed the official release and that one
> > > > > > > > > > works as expected (room configuration and changed
> > > > > > > > > > default image)
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > From: aaron.hepp@gmail.com <aa...@gmail.com>
> > > > > > > > > > Sent: Friday, August 3, 2018 9:19 PM
> > > > > > > > > > To: user@openmeetings.apache.org
> > > > > > > > > > Subject: Conference Room creation update error
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > Looks like an old error is back. I just installed
> > > > > > > > > > the latest nightly build and now get thrown to the
> > > > > > > > > > internal error page if you try to update and
> > > > > > > > > > existing conference room or when you type the first letter for a new room name.
> > > > > > > > > > Looks like the old error where even if the user was
> > > > > > > > > > granted admin access Group Admin Access is denied
> > > > > > > > > > (see attached log)
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > Version4.0.5-SNAPSHOT
> > > > > > > > > >
> > > > > > > > > > Revisionb154bef
> > > > > > > > > >
> > > > > > > > > > Build date2018-08-03T10:13:48Z
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > Also looks like when doing the import there is a problem.
> > > > > > > > > > When you are 1st setting up your new install of OM
> > > > > > > > > > you create an admin account; so in the database that is “Profile 1”.
> > > > > > > > > > Where the problem lies is when you do an export from
> > > > > > > > > > your old system it also exports the old “admin”
> > > > > > > > > > account (which on the old system was also profile_1)
> > > > > > > > > > but when you do the import since there is already a
> > > > > > > > > > profile_1 it moves everything down 1 so the old admin account become id 2 on down the line. My account when exported was profile_2 but now my account is now labeled as profile_3 so the
> > > > > > > > > > image is not there but the old admin account has my profile.jpg. (also
> > > > > > > > > > in attachment)
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > --
> > > > > > > > > WBR
> > > > > > > > > Maxim aka solomax
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > --
> > > > > > > > WBR
> > > > > > > > Maxim aka solomax
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > --
> > > > > > > WBR
> > > > > > > Maxim aka solomax
> > > > > >
> > > > > >
> > > > > >
> > > > > > --
> > > > > > WBR
> > > > > > Maxim aka solomax
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > WBR
> > > > > Maxim aka solomax
> > > > >
> > > >
> > > >
> > > > --
> > > > WBR
> > > > Maxim aka solomax
> > > >
> > >
> > >
> > > --
> > > WBR
> > > Maxim aka solomax
> >
> >
> >
> > --
> > WBR
> > Maxim aka solomax
>
>
>
> --
> WBR
> Maxim aka solomax
--
WBR
Maxim aka solomax
Re: Conference Room creation update error
Posted by Maxim Solodovnik <so...@gmail.com>.
Hello Aaron,
Just have tested with UI restore from backup
Profile picture import works as expected
On Tue, Aug 7, 2018 at 1:06 PM Maxim Solodovnik <so...@gmail.com> wrote:
>
> No need to file JIRA :)
> The issue was caused by fix for [OPENMEETINGS-1908]
> Should be fixed in a new build
> On Tue, Aug 7, 2018 at 12:22 PM Maxim Solodovnik <so...@gmail.com> wrote:
> >
> > Thanks for the report!
> > Can you please check if this bug is reproducible on 4.0.4?
> > (https://om.alteametasoft.com/openmeetings/)
> > and file JIRA?
> > On Tue, Aug 7, 2018 at 4:49 AM <aa...@gmail.com> wrote:
> > >
> > > Ok looks like the error can be reproduced with the demo as well.
> > >
> > > When the room is 1st entered on a fresh reboot the white board is present and you can upload a file to that.
> > >
> > > But if you close the original WB and then open a new WB you cannot upload a file to the WB. It remains blank.
> > >
> > > I have attached the debug log but it does not tell much (to myself that is)
> > >
> > > -----Original Message-----
> > > From: Maxim Solodovnik <so...@gmail.com>
> > > Sent: Monday, August 6, 2018 12:22 PM
> > > To: Openmeetings user-list <us...@openmeetings.apache.org>
> > > Subject: Re: Conference Room creation update error
> > >
> > > Demo-next is updated to latest revision
> > > On Mon, Aug 6, 2018 at 10:10 PM <aa...@gmail.com> wrote:
> > > >
> > > > Ok. If they are skipped on import then no need to delete the dB object. I just noticed when the backup was ran they were still listed, was the only reason for the delete.
> > > >
> > > > If you/someone has the latest snapshot running (revision 3f2c95f) can they test something for me. I am currently running live with the startup script so I cannot get the debug information until after the day is over. But looks like I cannot upload a file to the WB. May be localized, but was wondering if one had the revision up and going if they could test. This is the same VM that has been ran previous version so all needed pacakges should already be installed.
> > > >
> > > > Demo looks like its still running some revisions back so couldn't test there.
> > > >
> > > > -----Original Message-----
> > > > From: Maxim Solodovnik <so...@gmail.com>
> > > > Sent: Monday, August 6, 2018 11:01 AM
> > > > To: Openmeetings user-list <us...@openmeetings.apache.org>
> > > > Subject: Re: Conference Room creation update error
> > > >
> > > > Actually both command line and UI installers uses same java code I'll
> > > > retest with UI installer ASAP
> > > >
> > > > According to your question: deleted/purged users are included into XML
> > > > backup files, but are being skipped during import
> > > >
> > > > I would not recommend to run queries like 'delete from om_user where
> > > > id = #' since data integrity will be broken Here is the brief list of
> > > > what need to done for user "hard" delete
> > > > https://issues.apache.org/jira/browse/OPENMEETINGS-1864 (hard delete
> > > > section)
> > > > On Sun, Aug 5, 2018 at 5:14 PM Aaron H <aa...@gmail.com> wrote:
> > > > >
> > > > > Took a back-up of running system *one thing to note that prior to back-up being preformed there was users that were purged, but also deleted from the dB via manual process (delete from om_user where id = #) Wasn't for sure if the back-up would pick up these "purged" users reason for the manual deletion. Everything was restarted before back-up was performed.
> > > > >
> > > > > Then followed the normal steps for a build
> > > > >
> > > > > Move current install to old
> > > > > * mv /opt/current /opt/old
> > > > > Delete existing dB and create new
> > > > > wGET new package and unzip in /opt/current folder Run new install
> > > > > script *script copies customization files from stored location into
> > > > > new install (can supply list of files that are copied if needed)
> > > > > Restart server Run sh red5.sh to start process Go through the setup
> > > > > process and restart server once complete
> > > > > * during setup the tick for install default objects is not selected
> > > > > Log in as admin and preformed import
> > > > >
> > > > > After the import was ran it put everything into the folder
> > > > > /webapps/Openmeetings/upload/import/import_2018_08_04_05_59_04/roomF
> > > > > il
> > > > > es/profiles
> > > > >
> > > > > I had never did a command line import as I have always done it after the system was configured. Since your import was successful then I would assume there is something wrong with the back-up that was taken and not a bug.
> > > > >
> > > > > One question to see if the step still needs to be taken. When you delete a user and it creates the "purged" information; when you take a back-up are those entries also included or does it omit them? Since I still seen the entries in the dB I figured that the back-up would include this data. That is the reason for the manual deletion prior to taking the backup.
> > > > >
> > > > >
> > > > > -----Original Message-----
> > > > > From: Maxim Solodovnik <so...@gmail.com>
> > > > > Sent: Sunday, August 5, 2018 12:16 AM
> > > > > To: Openmeetings user-list <us...@openmeetings.apache.org>
> > > > > Subject: Re: Conference Room creation update error
> > > > >
> > > > > Just performed command line import ~50k users with lots of profile
> > > > > pictures All images seems to be preserved So everything seems to
> > > > > work as expected
> > > > >
> > > > > `./admin.sh -v -i -file
> > > > > ~/work/openmeetings/backup/backup_2015_12_07_03_35_39.zip`
> > > > >
> > > > > Could you please provide your steps?
> > > > >
> > > > > On Sun, Aug 5, 2018 at 10:35 AM Maxim Solodovnik <so...@gmail.com> wrote:
> > > > > >
> > > > > > According to pictures uploaded by users: format change does not
> > > > > > affect such profile images, cause file name with extension is
> > > > > > stored in xml/DB :))) On Sun, Aug 5, 2018 at 10:30 AM Maxim
> > > > > > Solodovnik <so...@gmail.com> wrote:
> > > > > > >
> > > > > > > Hello Aaron,
> > > > > > >
> > > > > > > Thanks for detailed testing
> > > > > > > Profile folders should be moved to proper locations ...
> > > > > > > (https://github.com/apache/openmeetings/blob/4.0.x/openmeetings-
> > > > > > > in
> > > > > > > st
> > > > > > > all/src/main/java/org/apache/openmeetings/backup/BackupImport.ja
> > > > > > > va
> > > > > > > #L
> > > > > > > 1040)
> > > > > > >
> > > > > > > I'll double-check and report back On Sun, Aug 5, 2018 at 2:42 AM
> > > > > > > Aaron H <aa...@gmail.com> wrote:
> > > > > > > >
> > > > > > > > After further testing it will still accept the profile image being in jpg format. Any new image will be saved in the .png format.
> > > > > > > >
> > > > > > > > Looks like my problem I was having was due to the import not running properly (I'm assuming). The user.xml import was successful (as all user data was there), but what failed was putting each user's profile (profile_#) into the proper place /webapps/openmeeting/upload/profiles/. Instead it left all the files in the import/<importdatetime>/roomfiles/profiles/ folder. So while the users.xml files was parsed and it said in each profile_# the profile image was profile.jpg, that jpg file did not exist due to it not being imported properly.
> > > > > > > >
> > > > > > > > After manually moving each users profile_# folder into the proper place everything worked as expected. If a user had no stored image then there was no need to do the import as their profile would be created on their returning login.
> > > > > > > >
> > > > > > > > So it was either 1 of 2 things. Either A) a bad import function (as imported filed were placed in wrong locations, or B) import partially failed due to image format change. Was 4.0.4 image format still .jpg or had that one been moved to .png? I was going to stand up an official release if file format was still .jpg to see if it can narrow down what caused the import to not run fully.
> > > > > > > >
> > > > > > > >
> > > > > > > > -----Original Message-----
> > > > > > > > From: aaron.hepp@gmail.com <aa...@gmail.com>
> > > > > > > > Sent: Saturday, August 4, 2018 6:23 AM
> > > > > > > > To: user@openmeetings.apache.org
> > > > > > > > Subject: RE: Conference Room creation update error
> > > > > > > >
> > > > > > > > Yes looks like the room crashing has been resolved. Thank you for the prompt fix.
> > > > > > > >
> > > > > > > > The profile image I am referring to is the default profile image that is located at /webapps/Openmeetings/images/profile.* But I see why the issue. Looks like the default image format was changed from .jpg to .png and in my customization script I was importing profile.jpg so I changed the script to .png and this resolved that issue. Didn't notice the file extension had changed.
> > > > > > > >
> > > > > > > > The last issue I am seeing is the import from the previous backup.
> > > > > > > > It is importing all the users data for the database account
> > > > > > > > name / password / contact info / .etc, but it is not importing
> > > > > > > > the users profile image they had uploaded. The import was
> > > > > > > > placed at
> > > > > > > >
> > > > > > > > /webapps/Openmeetings/upload/import/import_2018_08_04_05_59_04
> > > > > > > > /r
> > > > > > > > oo
> > > > > > > > mFiles/profiles/
> > > > > > > >
> > > > > > > > so when a returning user logs in their profile is created:
> > > > > > > >
> > > > > > > > /webapps/Openmeetings/upload/profiles/
> > > > > > > >
> > > > > > > > But just now looking as I uploaded a new profile picture for myself as a test I see the reason. It looks like it stems from the file format change. The backup has everything as profile.jpg where it is looking for a .png file.
> > > > > > > >
> > > > > > > > Just a heads up for anyone taking an older backup from a
> > > > > > > > previous version, you will have to manually copy each users
> > > > > > > > profile.jpg file from the import folder to each users profile
> > > > > > > > space as a .png file
> > > > > > > >
> > > > > > > > For me this was an example:
> > > > > > > >
> > > > > > > > cp
> > > > > > > > /opt/current/webapps/trade-group/upload/import/import_2018_08_
> > > > > > > > 04
> > > > > > > > _0 5_59_04/roomFiles/profiles/profile_2/profile.jpg
> > > > > > > > /opt/current/webapps/trade-group/upload/profiles/profile_2/pro
> > > > > > > > fi
> > > > > > > > le
> > > > > > > > .png
> > > > > > > >
> > > > > > > > this must be done for each user or tell each user that they just have to re-upload their image if they want one.
> > > > > > > >
> > > > > > > >
> > > > > > > > -----Original Message-----
> > > > > > > > From: Maxim Solodovnik <so...@gmail.com>
> > > > > > > > Sent: Friday, August 3, 2018 11:08 PM
> > > > > > > > To: Openmeetings user-list <us...@openmeetings.apache.org>
> > > > > > > > Subject: Re: Conference Room creation update error
> > > > > > > >
> > > > > > > > Just have tried, profile images in jpg format are being displayed as expected Could you please tell me what were your exact steps to reproduce?
> > > > > > > >
> > > > > > > > BTW Thanks a lot for checking latest nightly :))) On Sat, Aug
> > > > > > > > 4,
> > > > > > > > 2018 at
> > > > > > > > 9:39 AM Maxim Solodovnik <so...@gmail.com> wrote:
> > > > > > > > >
> > > > > > > > > Hello Aaron,
> > > > > > > > >
> > > > > > > > > page crash was just fixed
> > > > > > > > > Will take a look at profile image issue (most probably
> > > > > > > > > caused by migration from JPG to PNG)
> > > > > > > > >
> > > > > > > > > According to new install, then import I would recommend to
> > > > > > > > > use command line admin in this case
> > > > > > > > > http://openmeetings.apache.org/CommandLineAdmin.html
> > > > > > > > > the options I'm using: -file --skip-default-objects On
> > > > > > > > > Sat, Aug 4,
> > > > > > > > > 2018 at 9:26 AM <aa...@gmail.com> wrote:
> > > > > > > > > >
> > > > > > > > > > Looks like my 1st attachment did not have the complete debug in it.
> > > > > > > > > > Attached is the full log.
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > Looks like also whatever is causing this error is also
> > > > > > > > > > what is causing the import not to work properly. I use a
> > > > > > > > > > different profile.jpg image for default users (located at
> > > > > > > > > > /webapps/openmeetings/images/profile.jpg) and that does
> > > > > > > > > > not get shown on the users profile. It is pulling the
> > > > > > > > > > image that is the standard image that has the question mark in the body.
> > > > > > > > > > Not even sure where it is pulling that from since the file
> > > > > > > > > > was replaced with a different file all together. When you
> > > > > > > > > > copy the image location it states
> > > > > > > > > > (/profile/1?anticache=1532949138000)
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > I re-installed the official release and that one works as
> > > > > > > > > > expected (room configuration and changed default image)
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > From: aaron.hepp@gmail.com <aa...@gmail.com>
> > > > > > > > > > Sent: Friday, August 3, 2018 9:19 PM
> > > > > > > > > > To: user@openmeetings.apache.org
> > > > > > > > > > Subject: Conference Room creation update error
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > Looks like an old error is back. I just installed the
> > > > > > > > > > latest nightly build and now get thrown to the internal
> > > > > > > > > > error page if you try to update and existing conference
> > > > > > > > > > room or when you type the first letter for a new room name.
> > > > > > > > > > Looks like the old error where even if the user was
> > > > > > > > > > granted admin access Group Admin Access is denied (see
> > > > > > > > > > attached log)
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > Version4.0.5-SNAPSHOT
> > > > > > > > > >
> > > > > > > > > > Revisionb154bef
> > > > > > > > > >
> > > > > > > > > > Build date2018-08-03T10:13:48Z
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > Also looks like when doing the import there is a problem.
> > > > > > > > > > When you are 1st setting up your new install of OM you
> > > > > > > > > > create an admin account; so in the database that is “Profile 1”.
> > > > > > > > > > Where the problem lies is when you do an export from your
> > > > > > > > > > old system it also exports the old “admin” account (which
> > > > > > > > > > on the old system was also profile_1) but when you do the
> > > > > > > > > > import since there is already a profile_1 it moves
> > > > > > > > > > everything down 1 so the old admin account become id 2 on down the line. My account when exported was profile_2 but now my account is now labeled as profile_3 so the
> > > > > > > > > > image is not there but the old admin account has my profile.jpg. (also
> > > > > > > > > > in attachment)
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > --
> > > > > > > > > WBR
> > > > > > > > > Maxim aka solomax
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > --
> > > > > > > > WBR
> > > > > > > > Maxim aka solomax
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > --
> > > > > > > WBR
> > > > > > > Maxim aka solomax
> > > > > >
> > > > > >
> > > > > >
> > > > > > --
> > > > > > WBR
> > > > > > Maxim aka solomax
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > WBR
> > > > > Maxim aka solomax
> > > > >
> > > >
> > > >
> > > > --
> > > > WBR
> > > > Maxim aka solomax
> > > >
> > >
> > >
> > > --
> > > WBR
> > > Maxim aka solomax
> >
> >
> >
> > --
> > WBR
> > Maxim aka solomax
>
>
>
> --
> WBR
> Maxim aka solomax
--
WBR
Maxim aka solomax
Re: Conference Room creation update error
Posted by Maxim Solodovnik <so...@gmail.com>.
No need to file JIRA :)
The issue was caused by fix for [OPENMEETINGS-1908]
Should be fixed in a new build
On Tue, Aug 7, 2018 at 12:22 PM Maxim Solodovnik <so...@gmail.com> wrote:
>
> Thanks for the report!
> Can you please check if this bug is reproducible on 4.0.4?
> (https://om.alteametasoft.com/openmeetings/)
> and file JIRA?
> On Tue, Aug 7, 2018 at 4:49 AM <aa...@gmail.com> wrote:
> >
> > Ok looks like the error can be reproduced with the demo as well.
> >
> > When the room is 1st entered on a fresh reboot the white board is present and you can upload a file to that.
> >
> > But if you close the original WB and then open a new WB you cannot upload a file to the WB. It remains blank.
> >
> > I have attached the debug log but it does not tell much (to myself that is)
> >
> > -----Original Message-----
> > From: Maxim Solodovnik <so...@gmail.com>
> > Sent: Monday, August 6, 2018 12:22 PM
> > To: Openmeetings user-list <us...@openmeetings.apache.org>
> > Subject: Re: Conference Room creation update error
> >
> > Demo-next is updated to latest revision
> > On Mon, Aug 6, 2018 at 10:10 PM <aa...@gmail.com> wrote:
> > >
> > > Ok. If they are skipped on import then no need to delete the dB object. I just noticed when the backup was ran they were still listed, was the only reason for the delete.
> > >
> > > If you/someone has the latest snapshot running (revision 3f2c95f) can they test something for me. I am currently running live with the startup script so I cannot get the debug information until after the day is over. But looks like I cannot upload a file to the WB. May be localized, but was wondering if one had the revision up and going if they could test. This is the same VM that has been ran previous version so all needed pacakges should already be installed.
> > >
> > > Demo looks like its still running some revisions back so couldn't test there.
> > >
> > > -----Original Message-----
> > > From: Maxim Solodovnik <so...@gmail.com>
> > > Sent: Monday, August 6, 2018 11:01 AM
> > > To: Openmeetings user-list <us...@openmeetings.apache.org>
> > > Subject: Re: Conference Room creation update error
> > >
> > > Actually both command line and UI installers uses same java code I'll
> > > retest with UI installer ASAP
> > >
> > > According to your question: deleted/purged users are included into XML
> > > backup files, but are being skipped during import
> > >
> > > I would not recommend to run queries like 'delete from om_user where
> > > id = #' since data integrity will be broken Here is the brief list of
> > > what need to done for user "hard" delete
> > > https://issues.apache.org/jira/browse/OPENMEETINGS-1864 (hard delete
> > > section)
> > > On Sun, Aug 5, 2018 at 5:14 PM Aaron H <aa...@gmail.com> wrote:
> > > >
> > > > Took a back-up of running system *one thing to note that prior to back-up being preformed there was users that were purged, but also deleted from the dB via manual process (delete from om_user where id = #) Wasn't for sure if the back-up would pick up these "purged" users reason for the manual deletion. Everything was restarted before back-up was performed.
> > > >
> > > > Then followed the normal steps for a build
> > > >
> > > > Move current install to old
> > > > * mv /opt/current /opt/old
> > > > Delete existing dB and create new
> > > > wGET new package and unzip in /opt/current folder Run new install
> > > > script *script copies customization files from stored location into
> > > > new install (can supply list of files that are copied if needed)
> > > > Restart server Run sh red5.sh to start process Go through the setup
> > > > process and restart server once complete
> > > > * during setup the tick for install default objects is not selected
> > > > Log in as admin and preformed import
> > > >
> > > > After the import was ran it put everything into the folder
> > > > /webapps/Openmeetings/upload/import/import_2018_08_04_05_59_04/roomF
> > > > il
> > > > es/profiles
> > > >
> > > > I had never did a command line import as I have always done it after the system was configured. Since your import was successful then I would assume there is something wrong with the back-up that was taken and not a bug.
> > > >
> > > > One question to see if the step still needs to be taken. When you delete a user and it creates the "purged" information; when you take a back-up are those entries also included or does it omit them? Since I still seen the entries in the dB I figured that the back-up would include this data. That is the reason for the manual deletion prior to taking the backup.
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: Maxim Solodovnik <so...@gmail.com>
> > > > Sent: Sunday, August 5, 2018 12:16 AM
> > > > To: Openmeetings user-list <us...@openmeetings.apache.org>
> > > > Subject: Re: Conference Room creation update error
> > > >
> > > > Just performed command line import ~50k users with lots of profile
> > > > pictures All images seems to be preserved So everything seems to
> > > > work as expected
> > > >
> > > > `./admin.sh -v -i -file
> > > > ~/work/openmeetings/backup/backup_2015_12_07_03_35_39.zip`
> > > >
> > > > Could you please provide your steps?
> > > >
> > > > On Sun, Aug 5, 2018 at 10:35 AM Maxim Solodovnik <so...@gmail.com> wrote:
> > > > >
> > > > > According to pictures uploaded by users: format change does not
> > > > > affect such profile images, cause file name with extension is
> > > > > stored in xml/DB :))) On Sun, Aug 5, 2018 at 10:30 AM Maxim
> > > > > Solodovnik <so...@gmail.com> wrote:
> > > > > >
> > > > > > Hello Aaron,
> > > > > >
> > > > > > Thanks for detailed testing
> > > > > > Profile folders should be moved to proper locations ...
> > > > > > (https://github.com/apache/openmeetings/blob/4.0.x/openmeetings-
> > > > > > in
> > > > > > st
> > > > > > all/src/main/java/org/apache/openmeetings/backup/BackupImport.ja
> > > > > > va
> > > > > > #L
> > > > > > 1040)
> > > > > >
> > > > > > I'll double-check and report back On Sun, Aug 5, 2018 at 2:42 AM
> > > > > > Aaron H <aa...@gmail.com> wrote:
> > > > > > >
> > > > > > > After further testing it will still accept the profile image being in jpg format. Any new image will be saved in the .png format.
> > > > > > >
> > > > > > > Looks like my problem I was having was due to the import not running properly (I'm assuming). The user.xml import was successful (as all user data was there), but what failed was putting each user's profile (profile_#) into the proper place /webapps/openmeeting/upload/profiles/. Instead it left all the files in the import/<importdatetime>/roomfiles/profiles/ folder. So while the users.xml files was parsed and it said in each profile_# the profile image was profile.jpg, that jpg file did not exist due to it not being imported properly.
> > > > > > >
> > > > > > > After manually moving each users profile_# folder into the proper place everything worked as expected. If a user had no stored image then there was no need to do the import as their profile would be created on their returning login.
> > > > > > >
> > > > > > > So it was either 1 of 2 things. Either A) a bad import function (as imported filed were placed in wrong locations, or B) import partially failed due to image format change. Was 4.0.4 image format still .jpg or had that one been moved to .png? I was going to stand up an official release if file format was still .jpg to see if it can narrow down what caused the import to not run fully.
> > > > > > >
> > > > > > >
> > > > > > > -----Original Message-----
> > > > > > > From: aaron.hepp@gmail.com <aa...@gmail.com>
> > > > > > > Sent: Saturday, August 4, 2018 6:23 AM
> > > > > > > To: user@openmeetings.apache.org
> > > > > > > Subject: RE: Conference Room creation update error
> > > > > > >
> > > > > > > Yes looks like the room crashing has been resolved. Thank you for the prompt fix.
> > > > > > >
> > > > > > > The profile image I am referring to is the default profile image that is located at /webapps/Openmeetings/images/profile.* But I see why the issue. Looks like the default image format was changed from .jpg to .png and in my customization script I was importing profile.jpg so I changed the script to .png and this resolved that issue. Didn't notice the file extension had changed.
> > > > > > >
> > > > > > > The last issue I am seeing is the import from the previous backup.
> > > > > > > It is importing all the users data for the database account
> > > > > > > name / password / contact info / .etc, but it is not importing
> > > > > > > the users profile image they had uploaded. The import was
> > > > > > > placed at
> > > > > > >
> > > > > > > /webapps/Openmeetings/upload/import/import_2018_08_04_05_59_04
> > > > > > > /r
> > > > > > > oo
> > > > > > > mFiles/profiles/
> > > > > > >
> > > > > > > so when a returning user logs in their profile is created:
> > > > > > >
> > > > > > > /webapps/Openmeetings/upload/profiles/
> > > > > > >
> > > > > > > But just now looking as I uploaded a new profile picture for myself as a test I see the reason. It looks like it stems from the file format change. The backup has everything as profile.jpg where it is looking for a .png file.
> > > > > > >
> > > > > > > Just a heads up for anyone taking an older backup from a
> > > > > > > previous version, you will have to manually copy each users
> > > > > > > profile.jpg file from the import folder to each users profile
> > > > > > > space as a .png file
> > > > > > >
> > > > > > > For me this was an example:
> > > > > > >
> > > > > > > cp
> > > > > > > /opt/current/webapps/trade-group/upload/import/import_2018_08_
> > > > > > > 04
> > > > > > > _0 5_59_04/roomFiles/profiles/profile_2/profile.jpg
> > > > > > > /opt/current/webapps/trade-group/upload/profiles/profile_2/pro
> > > > > > > fi
> > > > > > > le
> > > > > > > .png
> > > > > > >
> > > > > > > this must be done for each user or tell each user that they just have to re-upload their image if they want one.
> > > > > > >
> > > > > > >
> > > > > > > -----Original Message-----
> > > > > > > From: Maxim Solodovnik <so...@gmail.com>
> > > > > > > Sent: Friday, August 3, 2018 11:08 PM
> > > > > > > To: Openmeetings user-list <us...@openmeetings.apache.org>
> > > > > > > Subject: Re: Conference Room creation update error
> > > > > > >
> > > > > > > Just have tried, profile images in jpg format are being displayed as expected Could you please tell me what were your exact steps to reproduce?
> > > > > > >
> > > > > > > BTW Thanks a lot for checking latest nightly :))) On Sat, Aug
> > > > > > > 4,
> > > > > > > 2018 at
> > > > > > > 9:39 AM Maxim Solodovnik <so...@gmail.com> wrote:
> > > > > > > >
> > > > > > > > Hello Aaron,
> > > > > > > >
> > > > > > > > page crash was just fixed
> > > > > > > > Will take a look at profile image issue (most probably
> > > > > > > > caused by migration from JPG to PNG)
> > > > > > > >
> > > > > > > > According to new install, then import I would recommend to
> > > > > > > > use command line admin in this case
> > > > > > > > http://openmeetings.apache.org/CommandLineAdmin.html
> > > > > > > > the options I'm using: -file --skip-default-objects On
> > > > > > > > Sat, Aug 4,
> > > > > > > > 2018 at 9:26 AM <aa...@gmail.com> wrote:
> > > > > > > > >
> > > > > > > > > Looks like my 1st attachment did not have the complete debug in it.
> > > > > > > > > Attached is the full log.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Looks like also whatever is causing this error is also
> > > > > > > > > what is causing the import not to work properly. I use a
> > > > > > > > > different profile.jpg image for default users (located at
> > > > > > > > > /webapps/openmeetings/images/profile.jpg) and that does
> > > > > > > > > not get shown on the users profile. It is pulling the
> > > > > > > > > image that is the standard image that has the question mark in the body.
> > > > > > > > > Not even sure where it is pulling that from since the file
> > > > > > > > > was replaced with a different file all together. When you
> > > > > > > > > copy the image location it states
> > > > > > > > > (/profile/1?anticache=1532949138000)
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > I re-installed the official release and that one works as
> > > > > > > > > expected (room configuration and changed default image)
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > From: aaron.hepp@gmail.com <aa...@gmail.com>
> > > > > > > > > Sent: Friday, August 3, 2018 9:19 PM
> > > > > > > > > To: user@openmeetings.apache.org
> > > > > > > > > Subject: Conference Room creation update error
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Looks like an old error is back. I just installed the
> > > > > > > > > latest nightly build and now get thrown to the internal
> > > > > > > > > error page if you try to update and existing conference
> > > > > > > > > room or when you type the first letter for a new room name.
> > > > > > > > > Looks like the old error where even if the user was
> > > > > > > > > granted admin access Group Admin Access is denied (see
> > > > > > > > > attached log)
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Version4.0.5-SNAPSHOT
> > > > > > > > >
> > > > > > > > > Revisionb154bef
> > > > > > > > >
> > > > > > > > > Build date2018-08-03T10:13:48Z
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Also looks like when doing the import there is a problem.
> > > > > > > > > When you are 1st setting up your new install of OM you
> > > > > > > > > create an admin account; so in the database that is “Profile 1”.
> > > > > > > > > Where the problem lies is when you do an export from your
> > > > > > > > > old system it also exports the old “admin” account (which
> > > > > > > > > on the old system was also profile_1) but when you do the
> > > > > > > > > import since there is already a profile_1 it moves
> > > > > > > > > everything down 1 so the old admin account become id 2 on down the line. My account when exported was profile_2 but now my account is now labeled as profile_3 so the
> > > > > > > > > image is not there but the old admin account has my profile.jpg. (also
> > > > > > > > > in attachment)
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > --
> > > > > > > > WBR
> > > > > > > > Maxim aka solomax
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > --
> > > > > > > WBR
> > > > > > > Maxim aka solomax
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > > --
> > > > > > WBR
> > > > > > Maxim aka solomax
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > WBR
> > > > > Maxim aka solomax
> > > >
> > > >
> > > >
> > > > --
> > > > WBR
> > > > Maxim aka solomax
> > > >
> > >
> > >
> > > --
> > > WBR
> > > Maxim aka solomax
> > >
> >
> >
> > --
> > WBR
> > Maxim aka solomax
>
>
>
> --
> WBR
> Maxim aka solomax
--
WBR
Maxim aka solomax
Re: Conference Room creation update error
Posted by Maxim Solodovnik <so...@gmail.com>.
Thanks for the report!
Can you please check if this bug is reproducible on 4.0.4?
(https://om.alteametasoft.com/openmeetings/)
and file JIRA?
On Tue, Aug 7, 2018 at 4:49 AM <aa...@gmail.com> wrote:
>
> Ok looks like the error can be reproduced with the demo as well.
>
> When the room is 1st entered on a fresh reboot the white board is present and you can upload a file to that.
>
> But if you close the original WB and then open a new WB you cannot upload a file to the WB. It remains blank.
>
> I have attached the debug log but it does not tell much (to myself that is)
>
> -----Original Message-----
> From: Maxim Solodovnik <so...@gmail.com>
> Sent: Monday, August 6, 2018 12:22 PM
> To: Openmeetings user-list <us...@openmeetings.apache.org>
> Subject: Re: Conference Room creation update error
>
> Demo-next is updated to latest revision
> On Mon, Aug 6, 2018 at 10:10 PM <aa...@gmail.com> wrote:
> >
> > Ok. If they are skipped on import then no need to delete the dB object. I just noticed when the backup was ran they were still listed, was the only reason for the delete.
> >
> > If you/someone has the latest snapshot running (revision 3f2c95f) can they test something for me. I am currently running live with the startup script so I cannot get the debug information until after the day is over. But looks like I cannot upload a file to the WB. May be localized, but was wondering if one had the revision up and going if they could test. This is the same VM that has been ran previous version so all needed pacakges should already be installed.
> >
> > Demo looks like its still running some revisions back so couldn't test there.
> >
> > -----Original Message-----
> > From: Maxim Solodovnik <so...@gmail.com>
> > Sent: Monday, August 6, 2018 11:01 AM
> > To: Openmeetings user-list <us...@openmeetings.apache.org>
> > Subject: Re: Conference Room creation update error
> >
> > Actually both command line and UI installers uses same java code I'll
> > retest with UI installer ASAP
> >
> > According to your question: deleted/purged users are included into XML
> > backup files, but are being skipped during import
> >
> > I would not recommend to run queries like 'delete from om_user where
> > id = #' since data integrity will be broken Here is the brief list of
> > what need to done for user "hard" delete
> > https://issues.apache.org/jira/browse/OPENMEETINGS-1864 (hard delete
> > section)
> > On Sun, Aug 5, 2018 at 5:14 PM Aaron H <aa...@gmail.com> wrote:
> > >
> > > Took a back-up of running system *one thing to note that prior to back-up being preformed there was users that were purged, but also deleted from the dB via manual process (delete from om_user where id = #) Wasn't for sure if the back-up would pick up these "purged" users reason for the manual deletion. Everything was restarted before back-up was performed.
> > >
> > > Then followed the normal steps for a build
> > >
> > > Move current install to old
> > > * mv /opt/current /opt/old
> > > Delete existing dB and create new
> > > wGET new package and unzip in /opt/current folder Run new install
> > > script *script copies customization files from stored location into
> > > new install (can supply list of files that are copied if needed)
> > > Restart server Run sh red5.sh to start process Go through the setup
> > > process and restart server once complete
> > > * during setup the tick for install default objects is not selected
> > > Log in as admin and preformed import
> > >
> > > After the import was ran it put everything into the folder
> > > /webapps/Openmeetings/upload/import/import_2018_08_04_05_59_04/roomF
> > > il
> > > es/profiles
> > >
> > > I had never did a command line import as I have always done it after the system was configured. Since your import was successful then I would assume there is something wrong with the back-up that was taken and not a bug.
> > >
> > > One question to see if the step still needs to be taken. When you delete a user and it creates the "purged" information; when you take a back-up are those entries also included or does it omit them? Since I still seen the entries in the dB I figured that the back-up would include this data. That is the reason for the manual deletion prior to taking the backup.
> > >
> > >
> > > -----Original Message-----
> > > From: Maxim Solodovnik <so...@gmail.com>
> > > Sent: Sunday, August 5, 2018 12:16 AM
> > > To: Openmeetings user-list <us...@openmeetings.apache.org>
> > > Subject: Re: Conference Room creation update error
> > >
> > > Just performed command line import ~50k users with lots of profile
> > > pictures All images seems to be preserved So everything seems to
> > > work as expected
> > >
> > > `./admin.sh -v -i -file
> > > ~/work/openmeetings/backup/backup_2015_12_07_03_35_39.zip`
> > >
> > > Could you please provide your steps?
> > >
> > > On Sun, Aug 5, 2018 at 10:35 AM Maxim Solodovnik <so...@gmail.com> wrote:
> > > >
> > > > According to pictures uploaded by users: format change does not
> > > > affect such profile images, cause file name with extension is
> > > > stored in xml/DB :))) On Sun, Aug 5, 2018 at 10:30 AM Maxim
> > > > Solodovnik <so...@gmail.com> wrote:
> > > > >
> > > > > Hello Aaron,
> > > > >
> > > > > Thanks for detailed testing
> > > > > Profile folders should be moved to proper locations ...
> > > > > (https://github.com/apache/openmeetings/blob/4.0.x/openmeetings-
> > > > > in
> > > > > st
> > > > > all/src/main/java/org/apache/openmeetings/backup/BackupImport.ja
> > > > > va
> > > > > #L
> > > > > 1040)
> > > > >
> > > > > I'll double-check and report back On Sun, Aug 5, 2018 at 2:42 AM
> > > > > Aaron H <aa...@gmail.com> wrote:
> > > > > >
> > > > > > After further testing it will still accept the profile image being in jpg format. Any new image will be saved in the .png format.
> > > > > >
> > > > > > Looks like my problem I was having was due to the import not running properly (I'm assuming). The user.xml import was successful (as all user data was there), but what failed was putting each user's profile (profile_#) into the proper place /webapps/openmeeting/upload/profiles/. Instead it left all the files in the import/<importdatetime>/roomfiles/profiles/ folder. So while the users.xml files was parsed and it said in each profile_# the profile image was profile.jpg, that jpg file did not exist due to it not being imported properly.
> > > > > >
> > > > > > After manually moving each users profile_# folder into the proper place everything worked as expected. If a user had no stored image then there was no need to do the import as their profile would be created on their returning login.
> > > > > >
> > > > > > So it was either 1 of 2 things. Either A) a bad import function (as imported filed were placed in wrong locations, or B) import partially failed due to image format change. Was 4.0.4 image format still .jpg or had that one been moved to .png? I was going to stand up an official release if file format was still .jpg to see if it can narrow down what caused the import to not run fully.
> > > > > >
> > > > > >
> > > > > > -----Original Message-----
> > > > > > From: aaron.hepp@gmail.com <aa...@gmail.com>
> > > > > > Sent: Saturday, August 4, 2018 6:23 AM
> > > > > > To: user@openmeetings.apache.org
> > > > > > Subject: RE: Conference Room creation update error
> > > > > >
> > > > > > Yes looks like the room crashing has been resolved. Thank you for the prompt fix.
> > > > > >
> > > > > > The profile image I am referring to is the default profile image that is located at /webapps/Openmeetings/images/profile.* But I see why the issue. Looks like the default image format was changed from .jpg to .png and in my customization script I was importing profile.jpg so I changed the script to .png and this resolved that issue. Didn't notice the file extension had changed.
> > > > > >
> > > > > > The last issue I am seeing is the import from the previous backup.
> > > > > > It is importing all the users data for the database account
> > > > > > name / password / contact info / .etc, but it is not importing
> > > > > > the users profile image they had uploaded. The import was
> > > > > > placed at
> > > > > >
> > > > > > /webapps/Openmeetings/upload/import/import_2018_08_04_05_59_04
> > > > > > /r
> > > > > > oo
> > > > > > mFiles/profiles/
> > > > > >
> > > > > > so when a returning user logs in their profile is created:
> > > > > >
> > > > > > /webapps/Openmeetings/upload/profiles/
> > > > > >
> > > > > > But just now looking as I uploaded a new profile picture for myself as a test I see the reason. It looks like it stems from the file format change. The backup has everything as profile.jpg where it is looking for a .png file.
> > > > > >
> > > > > > Just a heads up for anyone taking an older backup from a
> > > > > > previous version, you will have to manually copy each users
> > > > > > profile.jpg file from the import folder to each users profile
> > > > > > space as a .png file
> > > > > >
> > > > > > For me this was an example:
> > > > > >
> > > > > > cp
> > > > > > /opt/current/webapps/trade-group/upload/import/import_2018_08_
> > > > > > 04
> > > > > > _0 5_59_04/roomFiles/profiles/profile_2/profile.jpg
> > > > > > /opt/current/webapps/trade-group/upload/profiles/profile_2/pro
> > > > > > fi
> > > > > > le
> > > > > > .png
> > > > > >
> > > > > > this must be done for each user or tell each user that they just have to re-upload their image if they want one.
> > > > > >
> > > > > >
> > > > > > -----Original Message-----
> > > > > > From: Maxim Solodovnik <so...@gmail.com>
> > > > > > Sent: Friday, August 3, 2018 11:08 PM
> > > > > > To: Openmeetings user-list <us...@openmeetings.apache.org>
> > > > > > Subject: Re: Conference Room creation update error
> > > > > >
> > > > > > Just have tried, profile images in jpg format are being displayed as expected Could you please tell me what were your exact steps to reproduce?
> > > > > >
> > > > > > BTW Thanks a lot for checking latest nightly :))) On Sat, Aug
> > > > > > 4,
> > > > > > 2018 at
> > > > > > 9:39 AM Maxim Solodovnik <so...@gmail.com> wrote:
> > > > > > >
> > > > > > > Hello Aaron,
> > > > > > >
> > > > > > > page crash was just fixed
> > > > > > > Will take a look at profile image issue (most probably
> > > > > > > caused by migration from JPG to PNG)
> > > > > > >
> > > > > > > According to new install, then import I would recommend to
> > > > > > > use command line admin in this case
> > > > > > > http://openmeetings.apache.org/CommandLineAdmin.html
> > > > > > > the options I'm using: -file --skip-default-objects On
> > > > > > > Sat, Aug 4,
> > > > > > > 2018 at 9:26 AM <aa...@gmail.com> wrote:
> > > > > > > >
> > > > > > > > Looks like my 1st attachment did not have the complete debug in it.
> > > > > > > > Attached is the full log.
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > Looks like also whatever is causing this error is also
> > > > > > > > what is causing the import not to work properly. I use a
> > > > > > > > different profile.jpg image for default users (located at
> > > > > > > > /webapps/openmeetings/images/profile.jpg) and that does
> > > > > > > > not get shown on the users profile. It is pulling the
> > > > > > > > image that is the standard image that has the question mark in the body.
> > > > > > > > Not even sure where it is pulling that from since the file
> > > > > > > > was replaced with a different file all together. When you
> > > > > > > > copy the image location it states
> > > > > > > > (/profile/1?anticache=1532949138000)
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > I re-installed the official release and that one works as
> > > > > > > > expected (room configuration and changed default image)
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > From: aaron.hepp@gmail.com <aa...@gmail.com>
> > > > > > > > Sent: Friday, August 3, 2018 9:19 PM
> > > > > > > > To: user@openmeetings.apache.org
> > > > > > > > Subject: Conference Room creation update error
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > Looks like an old error is back. I just installed the
> > > > > > > > latest nightly build and now get thrown to the internal
> > > > > > > > error page if you try to update and existing conference
> > > > > > > > room or when you type the first letter for a new room name.
> > > > > > > > Looks like the old error where even if the user was
> > > > > > > > granted admin access Group Admin Access is denied (see
> > > > > > > > attached log)
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > Version4.0.5-SNAPSHOT
> > > > > > > >
> > > > > > > > Revisionb154bef
> > > > > > > >
> > > > > > > > Build date2018-08-03T10:13:48Z
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > Also looks like when doing the import there is a problem.
> > > > > > > > When you are 1st setting up your new install of OM you
> > > > > > > > create an admin account; so in the database that is “Profile 1”.
> > > > > > > > Where the problem lies is when you do an export from your
> > > > > > > > old system it also exports the old “admin” account (which
> > > > > > > > on the old system was also profile_1) but when you do the
> > > > > > > > import since there is already a profile_1 it moves
> > > > > > > > everything down 1 so the old admin account become id 2 on down the line. My account when exported was profile_2 but now my account is now labeled as profile_3 so the
> > > > > > > > image is not there but the old admin account has my profile.jpg. (also
> > > > > > > > in attachment)
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > --
> > > > > > > WBR
> > > > > > > Maxim aka solomax
> > > > > >
> > > > > >
> > > > > >
> > > > > > --
> > > > > > WBR
> > > > > > Maxim aka solomax
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > --
> > > > > WBR
> > > > > Maxim aka solomax
> > > >
> > > >
> > > >
> > > > --
> > > > WBR
> > > > Maxim aka solomax
> > >
> > >
> > >
> > > --
> > > WBR
> > > Maxim aka solomax
> > >
> >
> >
> > --
> > WBR
> > Maxim aka solomax
> >
>
>
> --
> WBR
> Maxim aka solomax
--
WBR
Maxim aka solomax
RE: Conference Room creation update error
Posted by aa...@gmail.com.
Ok looks like the error can be reproduced with the demo as well.
When the room is 1st entered on a fresh reboot the white board is present and you can upload a file to that.
But if you close the original WB and then open a new WB you cannot upload a file to the WB. It remains blank.
I have attached the debug log but it does not tell much (to myself that is)
-----Original Message-----
From: Maxim Solodovnik <so...@gmail.com>
Sent: Monday, August 6, 2018 12:22 PM
To: Openmeetings user-list <us...@openmeetings.apache.org>
Subject: Re: Conference Room creation update error
Demo-next is updated to latest revision
On Mon, Aug 6, 2018 at 10:10 PM <aa...@gmail.com> wrote:
>
> Ok. If they are skipped on import then no need to delete the dB object. I just noticed when the backup was ran they were still listed, was the only reason for the delete.
>
> If you/someone has the latest snapshot running (revision 3f2c95f) can they test something for me. I am currently running live with the startup script so I cannot get the debug information until after the day is over. But looks like I cannot upload a file to the WB. May be localized, but was wondering if one had the revision up and going if they could test. This is the same VM that has been ran previous version so all needed pacakges should already be installed.
>
> Demo looks like its still running some revisions back so couldn't test there.
>
> -----Original Message-----
> From: Maxim Solodovnik <so...@gmail.com>
> Sent: Monday, August 6, 2018 11:01 AM
> To: Openmeetings user-list <us...@openmeetings.apache.org>
> Subject: Re: Conference Room creation update error
>
> Actually both command line and UI installers uses same java code I'll
> retest with UI installer ASAP
>
> According to your question: deleted/purged users are included into XML
> backup files, but are being skipped during import
>
> I would not recommend to run queries like 'delete from om_user where
> id = #' since data integrity will be broken Here is the brief list of
> what need to done for user "hard" delete
> https://issues.apache.org/jira/browse/OPENMEETINGS-1864 (hard delete
> section)
> On Sun, Aug 5, 2018 at 5:14 PM Aaron H <aa...@gmail.com> wrote:
> >
> > Took a back-up of running system *one thing to note that prior to back-up being preformed there was users that were purged, but also deleted from the dB via manual process (delete from om_user where id = #) Wasn't for sure if the back-up would pick up these "purged" users reason for the manual deletion. Everything was restarted before back-up was performed.
> >
> > Then followed the normal steps for a build
> >
> > Move current install to old
> > * mv /opt/current /opt/old
> > Delete existing dB and create new
> > wGET new package and unzip in /opt/current folder Run new install
> > script *script copies customization files from stored location into
> > new install (can supply list of files that are copied if needed)
> > Restart server Run sh red5.sh to start process Go through the setup
> > process and restart server once complete
> > * during setup the tick for install default objects is not selected
> > Log in as admin and preformed import
> >
> > After the import was ran it put everything into the folder
> > /webapps/Openmeetings/upload/import/import_2018_08_04_05_59_04/roomF
> > il
> > es/profiles
> >
> > I had never did a command line import as I have always done it after the system was configured. Since your import was successful then I would assume there is something wrong with the back-up that was taken and not a bug.
> >
> > One question to see if the step still needs to be taken. When you delete a user and it creates the "purged" information; when you take a back-up are those entries also included or does it omit them? Since I still seen the entries in the dB I figured that the back-up would include this data. That is the reason for the manual deletion prior to taking the backup.
> >
> >
> > -----Original Message-----
> > From: Maxim Solodovnik <so...@gmail.com>
> > Sent: Sunday, August 5, 2018 12:16 AM
> > To: Openmeetings user-list <us...@openmeetings.apache.org>
> > Subject: Re: Conference Room creation update error
> >
> > Just performed command line import ~50k users with lots of profile
> > pictures All images seems to be preserved So everything seems to
> > work as expected
> >
> > `./admin.sh -v -i -file
> > ~/work/openmeetings/backup/backup_2015_12_07_03_35_39.zip`
> >
> > Could you please provide your steps?
> >
> > On Sun, Aug 5, 2018 at 10:35 AM Maxim Solodovnik <so...@gmail.com> wrote:
> > >
> > > According to pictures uploaded by users: format change does not
> > > affect such profile images, cause file name with extension is
> > > stored in xml/DB :))) On Sun, Aug 5, 2018 at 10:30 AM Maxim
> > > Solodovnik <so...@gmail.com> wrote:
> > > >
> > > > Hello Aaron,
> > > >
> > > > Thanks for detailed testing
> > > > Profile folders should be moved to proper locations ...
> > > > (https://github.com/apache/openmeetings/blob/4.0.x/openmeetings-
> > > > in
> > > > st
> > > > all/src/main/java/org/apache/openmeetings/backup/BackupImport.ja
> > > > va
> > > > #L
> > > > 1040)
> > > >
> > > > I'll double-check and report back On Sun, Aug 5, 2018 at 2:42 AM
> > > > Aaron H <aa...@gmail.com> wrote:
> > > > >
> > > > > After further testing it will still accept the profile image being in jpg format. Any new image will be saved in the .png format.
> > > > >
> > > > > Looks like my problem I was having was due to the import not running properly (I'm assuming). The user.xml import was successful (as all user data was there), but what failed was putting each user's profile (profile_#) into the proper place /webapps/openmeeting/upload/profiles/. Instead it left all the files in the import/<importdatetime>/roomfiles/profiles/ folder. So while the users.xml files was parsed and it said in each profile_# the profile image was profile.jpg, that jpg file did not exist due to it not being imported properly.
> > > > >
> > > > > After manually moving each users profile_# folder into the proper place everything worked as expected. If a user had no stored image then there was no need to do the import as their profile would be created on their returning login.
> > > > >
> > > > > So it was either 1 of 2 things. Either A) a bad import function (as imported filed were placed in wrong locations, or B) import partially failed due to image format change. Was 4.0.4 image format still .jpg or had that one been moved to .png? I was going to stand up an official release if file format was still .jpg to see if it can narrow down what caused the import to not run fully.
> > > > >
> > > > >
> > > > > -----Original Message-----
> > > > > From: aaron.hepp@gmail.com <aa...@gmail.com>
> > > > > Sent: Saturday, August 4, 2018 6:23 AM
> > > > > To: user@openmeetings.apache.org
> > > > > Subject: RE: Conference Room creation update error
> > > > >
> > > > > Yes looks like the room crashing has been resolved. Thank you for the prompt fix.
> > > > >
> > > > > The profile image I am referring to is the default profile image that is located at /webapps/Openmeetings/images/profile.* But I see why the issue. Looks like the default image format was changed from .jpg to .png and in my customization script I was importing profile.jpg so I changed the script to .png and this resolved that issue. Didn't notice the file extension had changed.
> > > > >
> > > > > The last issue I am seeing is the import from the previous backup.
> > > > > It is importing all the users data for the database account
> > > > > name / password / contact info / .etc, but it is not importing
> > > > > the users profile image they had uploaded. The import was
> > > > > placed at
> > > > >
> > > > > /webapps/Openmeetings/upload/import/import_2018_08_04_05_59_04
> > > > > /r
> > > > > oo
> > > > > mFiles/profiles/
> > > > >
> > > > > so when a returning user logs in their profile is created:
> > > > >
> > > > > /webapps/Openmeetings/upload/profiles/
> > > > >
> > > > > But just now looking as I uploaded a new profile picture for myself as a test I see the reason. It looks like it stems from the file format change. The backup has everything as profile.jpg where it is looking for a .png file.
> > > > >
> > > > > Just a heads up for anyone taking an older backup from a
> > > > > previous version, you will have to manually copy each users
> > > > > profile.jpg file from the import folder to each users profile
> > > > > space as a .png file
> > > > >
> > > > > For me this was an example:
> > > > >
> > > > > cp
> > > > > /opt/current/webapps/trade-group/upload/import/import_2018_08_
> > > > > 04
> > > > > _0 5_59_04/roomFiles/profiles/profile_2/profile.jpg
> > > > > /opt/current/webapps/trade-group/upload/profiles/profile_2/pro
> > > > > fi
> > > > > le
> > > > > .png
> > > > >
> > > > > this must be done for each user or tell each user that they just have to re-upload their image if they want one.
> > > > >
> > > > >
> > > > > -----Original Message-----
> > > > > From: Maxim Solodovnik <so...@gmail.com>
> > > > > Sent: Friday, August 3, 2018 11:08 PM
> > > > > To: Openmeetings user-list <us...@openmeetings.apache.org>
> > > > > Subject: Re: Conference Room creation update error
> > > > >
> > > > > Just have tried, profile images in jpg format are being displayed as expected Could you please tell me what were your exact steps to reproduce?
> > > > >
> > > > > BTW Thanks a lot for checking latest nightly :))) On Sat, Aug
> > > > > 4,
> > > > > 2018 at
> > > > > 9:39 AM Maxim Solodovnik <so...@gmail.com> wrote:
> > > > > >
> > > > > > Hello Aaron,
> > > > > >
> > > > > > page crash was just fixed
> > > > > > Will take a look at profile image issue (most probably
> > > > > > caused by migration from JPG to PNG)
> > > > > >
> > > > > > According to new install, then import I would recommend to
> > > > > > use command line admin in this case
> > > > > > http://openmeetings.apache.org/CommandLineAdmin.html
> > > > > > the options I'm using: -file --skip-default-objects On
> > > > > > Sat, Aug 4,
> > > > > > 2018 at 9:26 AM <aa...@gmail.com> wrote:
> > > > > > >
> > > > > > > Looks like my 1st attachment did not have the complete debug in it.
> > > > > > > Attached is the full log.
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > Looks like also whatever is causing this error is also
> > > > > > > what is causing the import not to work properly. I use a
> > > > > > > different profile.jpg image for default users (located at
> > > > > > > /webapps/openmeetings/images/profile.jpg) and that does
> > > > > > > not get shown on the users profile. It is pulling the
> > > > > > > image that is the standard image that has the question mark in the body.
> > > > > > > Not even sure where it is pulling that from since the file
> > > > > > > was replaced with a different file all together. When you
> > > > > > > copy the image location it states
> > > > > > > (/profile/1?anticache=1532949138000)
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > I re-installed the official release and that one works as
> > > > > > > expected (room configuration and changed default image)
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > From: aaron.hepp@gmail.com <aa...@gmail.com>
> > > > > > > Sent: Friday, August 3, 2018 9:19 PM
> > > > > > > To: user@openmeetings.apache.org
> > > > > > > Subject: Conference Room creation update error
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > Looks like an old error is back. I just installed the
> > > > > > > latest nightly build and now get thrown to the internal
> > > > > > > error page if you try to update and existing conference
> > > > > > > room or when you type the first letter for a new room name.
> > > > > > > Looks like the old error where even if the user was
> > > > > > > granted admin access Group Admin Access is denied (see
> > > > > > > attached log)
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > Version4.0.5-SNAPSHOT
> > > > > > >
> > > > > > > Revisionb154bef
> > > > > > >
> > > > > > > Build date2018-08-03T10:13:48Z
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > Also looks like when doing the import there is a problem.
> > > > > > > When you are 1st setting up your new install of OM you
> > > > > > > create an admin account; so in the database that is “Profile 1”.
> > > > > > > Where the problem lies is when you do an export from your
> > > > > > > old system it also exports the old “admin” account (which
> > > > > > > on the old system was also profile_1) but when you do the
> > > > > > > import since there is already a profile_1 it moves
> > > > > > > everything down 1 so the old admin account become id 2 on down the line. My account when exported was profile_2 but now my account is now labeled as profile_3 so the
> > > > > > > image is not there but the old admin account has my profile.jpg. (also
> > > > > > > in attachment)
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > --
> > > > > > WBR
> > > > > > Maxim aka solomax
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > WBR
> > > > > Maxim aka solomax
> > > > >
> > > > >
> > > >
> > > >
> > > > --
> > > > WBR
> > > > Maxim aka solomax
> > >
> > >
> > >
> > > --
> > > WBR
> > > Maxim aka solomax
> >
> >
> >
> > --
> > WBR
> > Maxim aka solomax
> >
>
>
> --
> WBR
> Maxim aka solomax
>
--
WBR
Maxim aka solomax
Re: Conference Room creation update error
Posted by Maxim Solodovnik <so...@gmail.com>.
Demo-next is updated to latest revision
On Mon, Aug 6, 2018 at 10:10 PM <aa...@gmail.com> wrote:
>
> Ok. If they are skipped on import then no need to delete the dB object. I just noticed when the backup was ran they were still listed, was the only reason for the delete.
>
> If you/someone has the latest snapshot running (revision 3f2c95f) can they test something for me. I am currently running live with the startup script so I cannot get the debug information until after the day is over. But looks like I cannot upload a file to the WB. May be localized, but was wondering if one had the revision up and going if they could test. This is the same VM that has been ran previous version so all needed pacakges should already be installed.
>
> Demo looks like its still running some revisions back so couldn't test there.
>
> -----Original Message-----
> From: Maxim Solodovnik <so...@gmail.com>
> Sent: Monday, August 6, 2018 11:01 AM
> To: Openmeetings user-list <us...@openmeetings.apache.org>
> Subject: Re: Conference Room creation update error
>
> Actually both command line and UI installers uses same java code I'll retest with UI installer ASAP
>
> According to your question: deleted/purged users are included into XML backup files, but are being skipped during import
>
> I would not recommend to run queries like 'delete from om_user where id = #' since data integrity will be broken Here is the brief list of what need to done for user "hard" delete
> https://issues.apache.org/jira/browse/OPENMEETINGS-1864 (hard delete
> section)
> On Sun, Aug 5, 2018 at 5:14 PM Aaron H <aa...@gmail.com> wrote:
> >
> > Took a back-up of running system *one thing to note that prior to back-up being preformed there was users that were purged, but also deleted from the dB via manual process (delete from om_user where id = #) Wasn't for sure if the back-up would pick up these "purged" users reason for the manual deletion. Everything was restarted before back-up was performed.
> >
> > Then followed the normal steps for a build
> >
> > Move current install to old
> > * mv /opt/current /opt/old
> > Delete existing dB and create new
> > wGET new package and unzip in /opt/current folder Run new install
> > script *script copies customization files from stored location into
> > new install (can supply list of files that are copied if needed)
> > Restart server Run sh red5.sh to start process Go through the setup
> > process and restart server once complete
> > * during setup the tick for install default objects is not selected
> > Log in as admin and preformed import
> >
> > After the import was ran it put everything into the folder
> > /webapps/Openmeetings/upload/import/import_2018_08_04_05_59_04/roomFil
> > es/profiles
> >
> > I had never did a command line import as I have always done it after the system was configured. Since your import was successful then I would assume there is something wrong with the back-up that was taken and not a bug.
> >
> > One question to see if the step still needs to be taken. When you delete a user and it creates the "purged" information; when you take a back-up are those entries also included or does it omit them? Since I still seen the entries in the dB I figured that the back-up would include this data. That is the reason for the manual deletion prior to taking the backup.
> >
> >
> > -----Original Message-----
> > From: Maxim Solodovnik <so...@gmail.com>
> > Sent: Sunday, August 5, 2018 12:16 AM
> > To: Openmeetings user-list <us...@openmeetings.apache.org>
> > Subject: Re: Conference Room creation update error
> >
> > Just performed command line import ~50k users with lots of profile
> > pictures All images seems to be preserved So everything seems to work
> > as expected
> >
> > `./admin.sh -v -i -file
> > ~/work/openmeetings/backup/backup_2015_12_07_03_35_39.zip`
> >
> > Could you please provide your steps?
> >
> > On Sun, Aug 5, 2018 at 10:35 AM Maxim Solodovnik <so...@gmail.com> wrote:
> > >
> > > According to pictures uploaded by users: format change does not
> > > affect such profile images, cause file name with extension is stored
> > > in xml/DB :))) On Sun, Aug 5, 2018 at 10:30 AM Maxim Solodovnik
> > > <so...@gmail.com> wrote:
> > > >
> > > > Hello Aaron,
> > > >
> > > > Thanks for detailed testing
> > > > Profile folders should be moved to proper locations ...
> > > > (https://github.com/apache/openmeetings/blob/4.0.x/openmeetings-in
> > > > st
> > > > all/src/main/java/org/apache/openmeetings/backup/BackupImport.java
> > > > #L
> > > > 1040)
> > > >
> > > > I'll double-check and report back
> > > > On Sun, Aug 5, 2018 at 2:42 AM Aaron H <aa...@gmail.com> wrote:
> > > > >
> > > > > After further testing it will still accept the profile image being in jpg format. Any new image will be saved in the .png format.
> > > > >
> > > > > Looks like my problem I was having was due to the import not running properly (I'm assuming). The user.xml import was successful (as all user data was there), but what failed was putting each user's profile (profile_#) into the proper place /webapps/openmeeting/upload/profiles/. Instead it left all the files in the import/<importdatetime>/roomfiles/profiles/ folder. So while the users.xml files was parsed and it said in each profile_# the profile image was profile.jpg, that jpg file did not exist due to it not being imported properly.
> > > > >
> > > > > After manually moving each users profile_# folder into the proper place everything worked as expected. If a user had no stored image then there was no need to do the import as their profile would be created on their returning login.
> > > > >
> > > > > So it was either 1 of 2 things. Either A) a bad import function (as imported filed were placed in wrong locations, or B) import partially failed due to image format change. Was 4.0.4 image format still .jpg or had that one been moved to .png? I was going to stand up an official release if file format was still .jpg to see if it can narrow down what caused the import to not run fully.
> > > > >
> > > > >
> > > > > -----Original Message-----
> > > > > From: aaron.hepp@gmail.com <aa...@gmail.com>
> > > > > Sent: Saturday, August 4, 2018 6:23 AM
> > > > > To: user@openmeetings.apache.org
> > > > > Subject: RE: Conference Room creation update error
> > > > >
> > > > > Yes looks like the room crashing has been resolved. Thank you for the prompt fix.
> > > > >
> > > > > The profile image I am referring to is the default profile image that is located at /webapps/Openmeetings/images/profile.* But I see why the issue. Looks like the default image format was changed from .jpg to .png and in my customization script I was importing profile.jpg so I changed the script to .png and this resolved that issue. Didn't notice the file extension had changed.
> > > > >
> > > > > The last issue I am seeing is the import from the previous backup.
> > > > > It is importing all the users data for the database account name
> > > > > / password / contact info / .etc, but it is not importing the
> > > > > users profile image they had uploaded. The import was placed at
> > > > >
> > > > > /webapps/Openmeetings/upload/import/import_2018_08_04_05_59_04/r
> > > > > oo
> > > > > mFiles/profiles/
> > > > >
> > > > > so when a returning user logs in their profile is created:
> > > > >
> > > > > /webapps/Openmeetings/upload/profiles/
> > > > >
> > > > > But just now looking as I uploaded a new profile picture for myself as a test I see the reason. It looks like it stems from the file format change. The backup has everything as profile.jpg where it is looking for a .png file.
> > > > >
> > > > > Just a heads up for anyone taking an older backup from a
> > > > > previous version, you will have to manually copy each users
> > > > > profile.jpg file from the import folder to each users profile
> > > > > space as a .png file
> > > > >
> > > > > For me this was an example:
> > > > >
> > > > > cp
> > > > > /opt/current/webapps/trade-group/upload/import/import_2018_08_04
> > > > > _0 5_59_04/roomFiles/profiles/profile_2/profile.jpg
> > > > > /opt/current/webapps/trade-group/upload/profiles/profile_2/profi
> > > > > le
> > > > > .png
> > > > >
> > > > > this must be done for each user or tell each user that they just have to re-upload their image if they want one.
> > > > >
> > > > >
> > > > > -----Original Message-----
> > > > > From: Maxim Solodovnik <so...@gmail.com>
> > > > > Sent: Friday, August 3, 2018 11:08 PM
> > > > > To: Openmeetings user-list <us...@openmeetings.apache.org>
> > > > > Subject: Re: Conference Room creation update error
> > > > >
> > > > > Just have tried, profile images in jpg format are being displayed as expected Could you please tell me what were your exact steps to reproduce?
> > > > >
> > > > > BTW Thanks a lot for checking latest nightly :))) On Sat, Aug 4,
> > > > > 2018 at
> > > > > 9:39 AM Maxim Solodovnik <so...@gmail.com> wrote:
> > > > > >
> > > > > > Hello Aaron,
> > > > > >
> > > > > > page crash was just fixed
> > > > > > Will take a look at profile image issue (most probably caused
> > > > > > by migration from JPG to PNG)
> > > > > >
> > > > > > According to new install, then import I would recommend to use
> > > > > > command line admin in this case
> > > > > > http://openmeetings.apache.org/CommandLineAdmin.html
> > > > > > the options I'm using: -file --skip-default-objects On Sat,
> > > > > > Aug 4,
> > > > > > 2018 at 9:26 AM <aa...@gmail.com> wrote:
> > > > > > >
> > > > > > > Looks like my 1st attachment did not have the complete debug in it.
> > > > > > > Attached is the full log.
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > Looks like also whatever is causing this error is also what
> > > > > > > is causing the import not to work properly. I use a
> > > > > > > different profile.jpg image for default users (located at
> > > > > > > /webapps/openmeetings/images/profile.jpg) and that does not
> > > > > > > get shown on the users profile. It is pulling the image
> > > > > > > that is the standard image that has the question mark in the body.
> > > > > > > Not even sure where it is pulling that from since the file
> > > > > > > was replaced with a different file all together. When you
> > > > > > > copy the image location it states
> > > > > > > (/profile/1?anticache=1532949138000)
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > I re-installed the official release and that one works as
> > > > > > > expected (room configuration and changed default image)
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > From: aaron.hepp@gmail.com <aa...@gmail.com>
> > > > > > > Sent: Friday, August 3, 2018 9:19 PM
> > > > > > > To: user@openmeetings.apache.org
> > > > > > > Subject: Conference Room creation update error
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > Looks like an old error is back. I just installed the
> > > > > > > latest nightly build and now get thrown to the internal
> > > > > > > error page if you try to update and existing conference room
> > > > > > > or when you type the first letter for a new room name.
> > > > > > > Looks like the old error where even if the user was granted
> > > > > > > admin access Group Admin Access is denied (see attached log)
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > Version4.0.5-SNAPSHOT
> > > > > > >
> > > > > > > Revisionb154bef
> > > > > > >
> > > > > > > Build date2018-08-03T10:13:48Z
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > Also looks like when doing the import there is a problem.
> > > > > > > When you are 1st setting up your new install of OM you
> > > > > > > create an admin account; so in the database that is “Profile 1”.
> > > > > > > Where the problem lies is when you do an export from your
> > > > > > > old system it also exports the old “admin” account (which on
> > > > > > > the old system was also profile_1) but when you do the
> > > > > > > import since there is already a profile_1 it moves
> > > > > > > everything down 1 so the old admin account become id 2 on down the line. My account when exported was profile_2 but now my account is now labeled as profile_3 so the
> > > > > > > image is not there but the old admin account has my profile.jpg. (also
> > > > > > > in attachment)
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > --
> > > > > > WBR
> > > > > > Maxim aka solomax
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > WBR
> > > > > Maxim aka solomax
> > > > >
> > > > >
> > > >
> > > >
> > > > --
> > > > WBR
> > > > Maxim aka solomax
> > >
> > >
> > >
> > > --
> > > WBR
> > > Maxim aka solomax
> >
> >
> >
> > --
> > WBR
> > Maxim aka solomax
> >
>
>
> --
> WBR
> Maxim aka solomax
>
--
WBR
Maxim aka solomax
RE: Conference Room creation update error
Posted by aa...@gmail.com.
Ok. If they are skipped on import then no need to delete the dB object. I just noticed when the backup was ran they were still listed, was the only reason for the delete.
If you/someone has the latest snapshot running (revision 3f2c95f) can they test something for me. I am currently running live with the startup script so I cannot get the debug information until after the day is over. But looks like I cannot upload a file to the WB. May be localized, but was wondering if one had the revision up and going if they could test. This is the same VM that has been ran previous version so all needed pacakges should already be installed.
Demo looks like its still running some revisions back so couldn't test there.
-----Original Message-----
From: Maxim Solodovnik <so...@gmail.com>
Sent: Monday, August 6, 2018 11:01 AM
To: Openmeetings user-list <us...@openmeetings.apache.org>
Subject: Re: Conference Room creation update error
Actually both command line and UI installers uses same java code I'll retest with UI installer ASAP
According to your question: deleted/purged users are included into XML backup files, but are being skipped during import
I would not recommend to run queries like 'delete from om_user where id = #' since data integrity will be broken Here is the brief list of what need to done for user "hard" delete
https://issues.apache.org/jira/browse/OPENMEETINGS-1864 (hard delete
section)
On Sun, Aug 5, 2018 at 5:14 PM Aaron H <aa...@gmail.com> wrote:
>
> Took a back-up of running system *one thing to note that prior to back-up being preformed there was users that were purged, but also deleted from the dB via manual process (delete from om_user where id = #) Wasn't for sure if the back-up would pick up these "purged" users reason for the manual deletion. Everything was restarted before back-up was performed.
>
> Then followed the normal steps for a build
>
> Move current install to old
> * mv /opt/current /opt/old
> Delete existing dB and create new
> wGET new package and unzip in /opt/current folder Run new install
> script *script copies customization files from stored location into
> new install (can supply list of files that are copied if needed)
> Restart server Run sh red5.sh to start process Go through the setup
> process and restart server once complete
> * during setup the tick for install default objects is not selected
> Log in as admin and preformed import
>
> After the import was ran it put everything into the folder
> /webapps/Openmeetings/upload/import/import_2018_08_04_05_59_04/roomFil
> es/profiles
>
> I had never did a command line import as I have always done it after the system was configured. Since your import was successful then I would assume there is something wrong with the back-up that was taken and not a bug.
>
> One question to see if the step still needs to be taken. When you delete a user and it creates the "purged" information; when you take a back-up are those entries also included or does it omit them? Since I still seen the entries in the dB I figured that the back-up would include this data. That is the reason for the manual deletion prior to taking the backup.
>
>
> -----Original Message-----
> From: Maxim Solodovnik <so...@gmail.com>
> Sent: Sunday, August 5, 2018 12:16 AM
> To: Openmeetings user-list <us...@openmeetings.apache.org>
> Subject: Re: Conference Room creation update error
>
> Just performed command line import ~50k users with lots of profile
> pictures All images seems to be preserved So everything seems to work
> as expected
>
> `./admin.sh -v -i -file
> ~/work/openmeetings/backup/backup_2015_12_07_03_35_39.zip`
>
> Could you please provide your steps?
>
> On Sun, Aug 5, 2018 at 10:35 AM Maxim Solodovnik <so...@gmail.com> wrote:
> >
> > According to pictures uploaded by users: format change does not
> > affect such profile images, cause file name with extension is stored
> > in xml/DB :))) On Sun, Aug 5, 2018 at 10:30 AM Maxim Solodovnik
> > <so...@gmail.com> wrote:
> > >
> > > Hello Aaron,
> > >
> > > Thanks for detailed testing
> > > Profile folders should be moved to proper locations ...
> > > (https://github.com/apache/openmeetings/blob/4.0.x/openmeetings-in
> > > st
> > > all/src/main/java/org/apache/openmeetings/backup/BackupImport.java
> > > #L
> > > 1040)
> > >
> > > I'll double-check and report back
> > > On Sun, Aug 5, 2018 at 2:42 AM Aaron H <aa...@gmail.com> wrote:
> > > >
> > > > After further testing it will still accept the profile image being in jpg format. Any new image will be saved in the .png format.
> > > >
> > > > Looks like my problem I was having was due to the import not running properly (I'm assuming). The user.xml import was successful (as all user data was there), but what failed was putting each user's profile (profile_#) into the proper place /webapps/openmeeting/upload/profiles/. Instead it left all the files in the import/<importdatetime>/roomfiles/profiles/ folder. So while the users.xml files was parsed and it said in each profile_# the profile image was profile.jpg, that jpg file did not exist due to it not being imported properly.
> > > >
> > > > After manually moving each users profile_# folder into the proper place everything worked as expected. If a user had no stored image then there was no need to do the import as their profile would be created on their returning login.
> > > >
> > > > So it was either 1 of 2 things. Either A) a bad import function (as imported filed were placed in wrong locations, or B) import partially failed due to image format change. Was 4.0.4 image format still .jpg or had that one been moved to .png? I was going to stand up an official release if file format was still .jpg to see if it can narrow down what caused the import to not run fully.
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: aaron.hepp@gmail.com <aa...@gmail.com>
> > > > Sent: Saturday, August 4, 2018 6:23 AM
> > > > To: user@openmeetings.apache.org
> > > > Subject: RE: Conference Room creation update error
> > > >
> > > > Yes looks like the room crashing has been resolved. Thank you for the prompt fix.
> > > >
> > > > The profile image I am referring to is the default profile image that is located at /webapps/Openmeetings/images/profile.* But I see why the issue. Looks like the default image format was changed from .jpg to .png and in my customization script I was importing profile.jpg so I changed the script to .png and this resolved that issue. Didn't notice the file extension had changed.
> > > >
> > > > The last issue I am seeing is the import from the previous backup.
> > > > It is importing all the users data for the database account name
> > > > / password / contact info / .etc, but it is not importing the
> > > > users profile image they had uploaded. The import was placed at
> > > >
> > > > /webapps/Openmeetings/upload/import/import_2018_08_04_05_59_04/r
> > > > oo
> > > > mFiles/profiles/
> > > >
> > > > so when a returning user logs in their profile is created:
> > > >
> > > > /webapps/Openmeetings/upload/profiles/
> > > >
> > > > But just now looking as I uploaded a new profile picture for myself as a test I see the reason. It looks like it stems from the file format change. The backup has everything as profile.jpg where it is looking for a .png file.
> > > >
> > > > Just a heads up for anyone taking an older backup from a
> > > > previous version, you will have to manually copy each users
> > > > profile.jpg file from the import folder to each users profile
> > > > space as a .png file
> > > >
> > > > For me this was an example:
> > > >
> > > > cp
> > > > /opt/current/webapps/trade-group/upload/import/import_2018_08_04
> > > > _0 5_59_04/roomFiles/profiles/profile_2/profile.jpg
> > > > /opt/current/webapps/trade-group/upload/profiles/profile_2/profi
> > > > le
> > > > .png
> > > >
> > > > this must be done for each user or tell each user that they just have to re-upload their image if they want one.
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: Maxim Solodovnik <so...@gmail.com>
> > > > Sent: Friday, August 3, 2018 11:08 PM
> > > > To: Openmeetings user-list <us...@openmeetings.apache.org>
> > > > Subject: Re: Conference Room creation update error
> > > >
> > > > Just have tried, profile images in jpg format are being displayed as expected Could you please tell me what were your exact steps to reproduce?
> > > >
> > > > BTW Thanks a lot for checking latest nightly :))) On Sat, Aug 4,
> > > > 2018 at
> > > > 9:39 AM Maxim Solodovnik <so...@gmail.com> wrote:
> > > > >
> > > > > Hello Aaron,
> > > > >
> > > > > page crash was just fixed
> > > > > Will take a look at profile image issue (most probably caused
> > > > > by migration from JPG to PNG)
> > > > >
> > > > > According to new install, then import I would recommend to use
> > > > > command line admin in this case
> > > > > http://openmeetings.apache.org/CommandLineAdmin.html
> > > > > the options I'm using: -file --skip-default-objects On Sat,
> > > > > Aug 4,
> > > > > 2018 at 9:26 AM <aa...@gmail.com> wrote:
> > > > > >
> > > > > > Looks like my 1st attachment did not have the complete debug in it.
> > > > > > Attached is the full log.
> > > > > >
> > > > > >
> > > > > >
> > > > > > Looks like also whatever is causing this error is also what
> > > > > > is causing the import not to work properly. I use a
> > > > > > different profile.jpg image for default users (located at
> > > > > > /webapps/openmeetings/images/profile.jpg) and that does not
> > > > > > get shown on the users profile. It is pulling the image
> > > > > > that is the standard image that has the question mark in the body.
> > > > > > Not even sure where it is pulling that from since the file
> > > > > > was replaced with a different file all together. When you
> > > > > > copy the image location it states
> > > > > > (/profile/1?anticache=1532949138000)
> > > > > >
> > > > > >
> > > > > >
> > > > > > I re-installed the official release and that one works as
> > > > > > expected (room configuration and changed default image)
> > > > > >
> > > > > >
> > > > > >
> > > > > > From: aaron.hepp@gmail.com <aa...@gmail.com>
> > > > > > Sent: Friday, August 3, 2018 9:19 PM
> > > > > > To: user@openmeetings.apache.org
> > > > > > Subject: Conference Room creation update error
> > > > > >
> > > > > >
> > > > > >
> > > > > > Looks like an old error is back. I just installed the
> > > > > > latest nightly build and now get thrown to the internal
> > > > > > error page if you try to update and existing conference room
> > > > > > or when you type the first letter for a new room name.
> > > > > > Looks like the old error where even if the user was granted
> > > > > > admin access Group Admin Access is denied (see attached log)
> > > > > >
> > > > > >
> > > > > >
> > > > > > Version4.0.5-SNAPSHOT
> > > > > >
> > > > > > Revisionb154bef
> > > > > >
> > > > > > Build date2018-08-03T10:13:48Z
> > > > > >
> > > > > >
> > > > > >
> > > > > > Also looks like when doing the import there is a problem.
> > > > > > When you are 1st setting up your new install of OM you
> > > > > > create an admin account; so in the database that is “Profile 1”.
> > > > > > Where the problem lies is when you do an export from your
> > > > > > old system it also exports the old “admin” account (which on
> > > > > > the old system was also profile_1) but when you do the
> > > > > > import since there is already a profile_1 it moves
> > > > > > everything down 1 so the old admin account become id 2 on down the line. My account when exported was profile_2 but now my account is now labeled as profile_3 so the
> > > > > > image is not there but the old admin account has my profile.jpg. (also
> > > > > > in attachment)
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > WBR
> > > > > Maxim aka solomax
> > > >
> > > >
> > > >
> > > > --
> > > > WBR
> > > > Maxim aka solomax
> > > >
> > > >
> > >
> > >
> > > --
> > > WBR
> > > Maxim aka solomax
> >
> >
> >
> > --
> > WBR
> > Maxim aka solomax
>
>
>
> --
> WBR
> Maxim aka solomax
>
--
WBR
Maxim aka solomax
Re: Conference Room creation update error
Posted by Maxim Solodovnik <so...@gmail.com>.
Actually both command line and UI installers uses same java code
I'll retest with UI installer ASAP
According to your question: deleted/purged users are included into XML
backup files, but are being skipped during import
I would not recommend to run queries like 'delete from om_user where
id = #' since data integrity will be broken
Here is the brief list of what need to done for user "hard" delete
https://issues.apache.org/jira/browse/OPENMEETINGS-1864 (hard delete
section)
On Sun, Aug 5, 2018 at 5:14 PM Aaron H <aa...@gmail.com> wrote:
>
> Took a back-up of running system *one thing to note that prior to back-up being preformed there was users that were purged, but also deleted from the dB via manual process (delete from om_user where id = #) Wasn't for sure if the back-up would pick up these "purged" users reason for the manual deletion. Everything was restarted before back-up was performed.
>
> Then followed the normal steps for a build
>
> Move current install to old
> * mv /opt/current /opt/old
> Delete existing dB and create new
> wGET new package and unzip in /opt/current folder
> Run new install script
> *script copies customization files from stored location into new install (can supply list of files that are copied if needed)
> Restart server
> Run sh red5.sh to start process
> Go through the setup process and restart server once complete
> * during setup the tick for install default objects is not selected
> Log in as admin and preformed import
>
> After the import was ran it put everything into the folder
> /webapps/Openmeetings/upload/import/import_2018_08_04_05_59_04/roomFiles/profiles
>
> I had never did a command line import as I have always done it after the system was configured. Since your import was successful then I would assume there is something wrong with the back-up that was taken and not a bug.
>
> One question to see if the step still needs to be taken. When you delete a user and it creates the "purged" information; when you take a back-up are those entries also included or does it omit them? Since I still seen the entries in the dB I figured that the back-up would include this data. That is the reason for the manual deletion prior to taking the backup.
>
>
> -----Original Message-----
> From: Maxim Solodovnik <so...@gmail.com>
> Sent: Sunday, August 5, 2018 12:16 AM
> To: Openmeetings user-list <us...@openmeetings.apache.org>
> Subject: Re: Conference Room creation update error
>
> Just performed command line import ~50k users with lots of profile pictures All images seems to be preserved So everything seems to work as expected
>
> `./admin.sh -v -i -file
> ~/work/openmeetings/backup/backup_2015_12_07_03_35_39.zip`
>
> Could you please provide your steps?
>
> On Sun, Aug 5, 2018 at 10:35 AM Maxim Solodovnik <so...@gmail.com> wrote:
> >
> > According to pictures uploaded by users: format change does not affect
> > such profile images, cause file name with extension is stored in
> > xml/DB :))) On Sun, Aug 5, 2018 at 10:30 AM Maxim Solodovnik
> > <so...@gmail.com> wrote:
> > >
> > > Hello Aaron,
> > >
> > > Thanks for detailed testing
> > > Profile folders should be moved to proper locations ...
> > > (https://github.com/apache/openmeetings/blob/4.0.x/openmeetings-inst
> > > all/src/main/java/org/apache/openmeetings/backup/BackupImport.java#L
> > > 1040)
> > >
> > > I'll double-check and report back
> > > On Sun, Aug 5, 2018 at 2:42 AM Aaron H <aa...@gmail.com> wrote:
> > > >
> > > > After further testing it will still accept the profile image being in jpg format. Any new image will be saved in the .png format.
> > > >
> > > > Looks like my problem I was having was due to the import not running properly (I'm assuming). The user.xml import was successful (as all user data was there), but what failed was putting each user's profile (profile_#) into the proper place /webapps/openmeeting/upload/profiles/. Instead it left all the files in the import/<importdatetime>/roomfiles/profiles/ folder. So while the users.xml files was parsed and it said in each profile_# the profile image was profile.jpg, that jpg file did not exist due to it not being imported properly.
> > > >
> > > > After manually moving each users profile_# folder into the proper place everything worked as expected. If a user had no stored image then there was no need to do the import as their profile would be created on their returning login.
> > > >
> > > > So it was either 1 of 2 things. Either A) a bad import function (as imported filed were placed in wrong locations, or B) import partially failed due to image format change. Was 4.0.4 image format still .jpg or had that one been moved to .png? I was going to stand up an official release if file format was still .jpg to see if it can narrow down what caused the import to not run fully.
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: aaron.hepp@gmail.com <aa...@gmail.com>
> > > > Sent: Saturday, August 4, 2018 6:23 AM
> > > > To: user@openmeetings.apache.org
> > > > Subject: RE: Conference Room creation update error
> > > >
> > > > Yes looks like the room crashing has been resolved. Thank you for the prompt fix.
> > > >
> > > > The profile image I am referring to is the default profile image that is located at /webapps/Openmeetings/images/profile.* But I see why the issue. Looks like the default image format was changed from .jpg to .png and in my customization script I was importing profile.jpg so I changed the script to .png and this resolved that issue. Didn't notice the file extension had changed.
> > > >
> > > > The last issue I am seeing is the import from the previous backup.
> > > > It is importing all the users data for the database account name /
> > > > password / contact info / .etc, but it is not importing the users
> > > > profile image they had uploaded. The import was placed at
> > > >
> > > > /webapps/Openmeetings/upload/import/import_2018_08_04_05_59_04/roo
> > > > mFiles/profiles/
> > > >
> > > > so when a returning user logs in their profile is created:
> > > >
> > > > /webapps/Openmeetings/upload/profiles/
> > > >
> > > > But just now looking as I uploaded a new profile picture for myself as a test I see the reason. It looks like it stems from the file format change. The backup has everything as profile.jpg where it is looking for a .png file.
> > > >
> > > > Just a heads up for anyone taking an older backup from a previous
> > > > version, you will have to manually copy each users profile.jpg
> > > > file from the import folder to each users profile space as a .png
> > > > file
> > > >
> > > > For me this was an example:
> > > >
> > > > cp
> > > > /opt/current/webapps/trade-group/upload/import/import_2018_08_04_0
> > > > 5_59_04/roomFiles/profiles/profile_2/profile.jpg
> > > > /opt/current/webapps/trade-group/upload/profiles/profile_2/profile
> > > > .png
> > > >
> > > > this must be done for each user or tell each user that they just have to re-upload their image if they want one.
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: Maxim Solodovnik <so...@gmail.com>
> > > > Sent: Friday, August 3, 2018 11:08 PM
> > > > To: Openmeetings user-list <us...@openmeetings.apache.org>
> > > > Subject: Re: Conference Room creation update error
> > > >
> > > > Just have tried, profile images in jpg format are being displayed as expected Could you please tell me what were your exact steps to reproduce?
> > > >
> > > > BTW Thanks a lot for checking latest nightly :))) On Sat, Aug 4,
> > > > 2018 at
> > > > 9:39 AM Maxim Solodovnik <so...@gmail.com> wrote:
> > > > >
> > > > > Hello Aaron,
> > > > >
> > > > > page crash was just fixed
> > > > > Will take a look at profile image issue (most probably caused by
> > > > > migration from JPG to PNG)
> > > > >
> > > > > According to new install, then import I would recommend to use
> > > > > command line admin in this case
> > > > > http://openmeetings.apache.org/CommandLineAdmin.html
> > > > > the options I'm using: -file --skip-default-objects On Sat,
> > > > > Aug 4,
> > > > > 2018 at 9:26 AM <aa...@gmail.com> wrote:
> > > > > >
> > > > > > Looks like my 1st attachment did not have the complete debug in it.
> > > > > > Attached is the full log.
> > > > > >
> > > > > >
> > > > > >
> > > > > > Looks like also whatever is causing this error is also what is
> > > > > > causing the import not to work properly. I use a different
> > > > > > profile.jpg image for default users (located at
> > > > > > /webapps/openmeetings/images/profile.jpg) and that does not
> > > > > > get shown on the users profile. It is pulling the image that
> > > > > > is the standard image that has the question mark in the body.
> > > > > > Not even sure where it is pulling that from since the file was
> > > > > > replaced with a different file all together. When you copy
> > > > > > the image location it states
> > > > > > (/profile/1?anticache=1532949138000)
> > > > > >
> > > > > >
> > > > > >
> > > > > > I re-installed the official release and that one works as
> > > > > > expected (room configuration and changed default image)
> > > > > >
> > > > > >
> > > > > >
> > > > > > From: aaron.hepp@gmail.com <aa...@gmail.com>
> > > > > > Sent: Friday, August 3, 2018 9:19 PM
> > > > > > To: user@openmeetings.apache.org
> > > > > > Subject: Conference Room creation update error
> > > > > >
> > > > > >
> > > > > >
> > > > > > Looks like an old error is back. I just installed the latest
> > > > > > nightly build and now get thrown to the internal error page if
> > > > > > you try to update and existing conference room or when you
> > > > > > type the first letter for a new room name. Looks like the old
> > > > > > error where even if the user was granted admin access Group
> > > > > > Admin Access is denied (see attached log)
> > > > > >
> > > > > >
> > > > > >
> > > > > > Version4.0.5-SNAPSHOT
> > > > > >
> > > > > > Revisionb154bef
> > > > > >
> > > > > > Build date2018-08-03T10:13:48Z
> > > > > >
> > > > > >
> > > > > >
> > > > > > Also looks like when doing the import there is a problem.
> > > > > > When you are 1st setting up your new install of OM you create
> > > > > > an admin account; so in the database that is “Profile 1”.
> > > > > > Where the problem lies is when you do an export from your old
> > > > > > system it also exports the old “admin” account (which on the
> > > > > > old system was also profile_1) but when you do the import
> > > > > > since there is already a profile_1 it moves everything down 1
> > > > > > so the old admin account become id 2 on down the line. My account when exported was profile_2 but now my account is now labeled as profile_3 so the
> > > > > > image is not there but the old admin account has my profile.jpg. (also
> > > > > > in attachment)
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > WBR
> > > > > Maxim aka solomax
> > > >
> > > >
> > > >
> > > > --
> > > > WBR
> > > > Maxim aka solomax
> > > >
> > > >
> > >
> > >
> > > --
> > > WBR
> > > Maxim aka solomax
> >
> >
> >
> > --
> > WBR
> > Maxim aka solomax
>
>
>
> --
> WBR
> Maxim aka solomax
>
--
WBR
Maxim aka solomax
RE: Conference Room creation update error
Posted by Aaron H <aa...@gmail.com>.
Took a back-up of running system *one thing to note that prior to back-up being preformed there was users that were purged, but also deleted from the dB via manual process (delete from om_user where id = #) Wasn't for sure if the back-up would pick up these "purged" users reason for the manual deletion. Everything was restarted before back-up was performed.
Then followed the normal steps for a build
Move current install to old
* mv /opt/current /opt/old
Delete existing dB and create new
wGET new package and unzip in /opt/current folder
Run new install script
*script copies customization files from stored location into new install (can supply list of files that are copied if needed)
Restart server
Run sh red5.sh to start process
Go through the setup process and restart server once complete
* during setup the tick for install default objects is not selected
Log in as admin and preformed import
After the import was ran it put everything into the folder
/webapps/Openmeetings/upload/import/import_2018_08_04_05_59_04/roomFiles/profiles
I had never did a command line import as I have always done it after the system was configured. Since your import was successful then I would assume there is something wrong with the back-up that was taken and not a bug.
One question to see if the step still needs to be taken. When you delete a user and it creates the "purged" information; when you take a back-up are those entries also included or does it omit them? Since I still seen the entries in the dB I figured that the back-up would include this data. That is the reason for the manual deletion prior to taking the backup.
-----Original Message-----
From: Maxim Solodovnik <so...@gmail.com>
Sent: Sunday, August 5, 2018 12:16 AM
To: Openmeetings user-list <us...@openmeetings.apache.org>
Subject: Re: Conference Room creation update error
Just performed command line import ~50k users with lots of profile pictures All images seems to be preserved So everything seems to work as expected
`./admin.sh -v -i -file
~/work/openmeetings/backup/backup_2015_12_07_03_35_39.zip`
Could you please provide your steps?
On Sun, Aug 5, 2018 at 10:35 AM Maxim Solodovnik <so...@gmail.com> wrote:
>
> According to pictures uploaded by users: format change does not affect
> such profile images, cause file name with extension is stored in
> xml/DB :))) On Sun, Aug 5, 2018 at 10:30 AM Maxim Solodovnik
> <so...@gmail.com> wrote:
> >
> > Hello Aaron,
> >
> > Thanks for detailed testing
> > Profile folders should be moved to proper locations ...
> > (https://github.com/apache/openmeetings/blob/4.0.x/openmeetings-inst
> > all/src/main/java/org/apache/openmeetings/backup/BackupImport.java#L
> > 1040)
> >
> > I'll double-check and report back
> > On Sun, Aug 5, 2018 at 2:42 AM Aaron H <aa...@gmail.com> wrote:
> > >
> > > After further testing it will still accept the profile image being in jpg format. Any new image will be saved in the .png format.
> > >
> > > Looks like my problem I was having was due to the import not running properly (I'm assuming). The user.xml import was successful (as all user data was there), but what failed was putting each user's profile (profile_#) into the proper place /webapps/openmeeting/upload/profiles/. Instead it left all the files in the import/<importdatetime>/roomfiles/profiles/ folder. So while the users.xml files was parsed and it said in each profile_# the profile image was profile.jpg, that jpg file did not exist due to it not being imported properly.
> > >
> > > After manually moving each users profile_# folder into the proper place everything worked as expected. If a user had no stored image then there was no need to do the import as their profile would be created on their returning login.
> > >
> > > So it was either 1 of 2 things. Either A) a bad import function (as imported filed were placed in wrong locations, or B) import partially failed due to image format change. Was 4.0.4 image format still .jpg or had that one been moved to .png? I was going to stand up an official release if file format was still .jpg to see if it can narrow down what caused the import to not run fully.
> > >
> > >
> > > -----Original Message-----
> > > From: aaron.hepp@gmail.com <aa...@gmail.com>
> > > Sent: Saturday, August 4, 2018 6:23 AM
> > > To: user@openmeetings.apache.org
> > > Subject: RE: Conference Room creation update error
> > >
> > > Yes looks like the room crashing has been resolved. Thank you for the prompt fix.
> > >
> > > The profile image I am referring to is the default profile image that is located at /webapps/Openmeetings/images/profile.* But I see why the issue. Looks like the default image format was changed from .jpg to .png and in my customization script I was importing profile.jpg so I changed the script to .png and this resolved that issue. Didn't notice the file extension had changed.
> > >
> > > The last issue I am seeing is the import from the previous backup.
> > > It is importing all the users data for the database account name /
> > > password / contact info / .etc, but it is not importing the users
> > > profile image they had uploaded. The import was placed at
> > >
> > > /webapps/Openmeetings/upload/import/import_2018_08_04_05_59_04/roo
> > > mFiles/profiles/
> > >
> > > so when a returning user logs in their profile is created:
> > >
> > > /webapps/Openmeetings/upload/profiles/
> > >
> > > But just now looking as I uploaded a new profile picture for myself as a test I see the reason. It looks like it stems from the file format change. The backup has everything as profile.jpg where it is looking for a .png file.
> > >
> > > Just a heads up for anyone taking an older backup from a previous
> > > version, you will have to manually copy each users profile.jpg
> > > file from the import folder to each users profile space as a .png
> > > file
> > >
> > > For me this was an example:
> > >
> > > cp
> > > /opt/current/webapps/trade-group/upload/import/import_2018_08_04_0
> > > 5_59_04/roomFiles/profiles/profile_2/profile.jpg
> > > /opt/current/webapps/trade-group/upload/profiles/profile_2/profile
> > > .png
> > >
> > > this must be done for each user or tell each user that they just have to re-upload their image if they want one.
> > >
> > >
> > > -----Original Message-----
> > > From: Maxim Solodovnik <so...@gmail.com>
> > > Sent: Friday, August 3, 2018 11:08 PM
> > > To: Openmeetings user-list <us...@openmeetings.apache.org>
> > > Subject: Re: Conference Room creation update error
> > >
> > > Just have tried, profile images in jpg format are being displayed as expected Could you please tell me what were your exact steps to reproduce?
> > >
> > > BTW Thanks a lot for checking latest nightly :))) On Sat, Aug 4,
> > > 2018 at
> > > 9:39 AM Maxim Solodovnik <so...@gmail.com> wrote:
> > > >
> > > > Hello Aaron,
> > > >
> > > > page crash was just fixed
> > > > Will take a look at profile image issue (most probably caused by
> > > > migration from JPG to PNG)
> > > >
> > > > According to new install, then import I would recommend to use
> > > > command line admin in this case
> > > > http://openmeetings.apache.org/CommandLineAdmin.html
> > > > the options I'm using: -file --skip-default-objects On Sat,
> > > > Aug 4,
> > > > 2018 at 9:26 AM <aa...@gmail.com> wrote:
> > > > >
> > > > > Looks like my 1st attachment did not have the complete debug in it.
> > > > > Attached is the full log.
> > > > >
> > > > >
> > > > >
> > > > > Looks like also whatever is causing this error is also what is
> > > > > causing the import not to work properly. I use a different
> > > > > profile.jpg image for default users (located at
> > > > > /webapps/openmeetings/images/profile.jpg) and that does not
> > > > > get shown on the users profile. It is pulling the image that
> > > > > is the standard image that has the question mark in the body.
> > > > > Not even sure where it is pulling that from since the file was
> > > > > replaced with a different file all together. When you copy
> > > > > the image location it states
> > > > > (/profile/1?anticache=1532949138000)
> > > > >
> > > > >
> > > > >
> > > > > I re-installed the official release and that one works as
> > > > > expected (room configuration and changed default image)
> > > > >
> > > > >
> > > > >
> > > > > From: aaron.hepp@gmail.com <aa...@gmail.com>
> > > > > Sent: Friday, August 3, 2018 9:19 PM
> > > > > To: user@openmeetings.apache.org
> > > > > Subject: Conference Room creation update error
> > > > >
> > > > >
> > > > >
> > > > > Looks like an old error is back. I just installed the latest
> > > > > nightly build and now get thrown to the internal error page if
> > > > > you try to update and existing conference room or when you
> > > > > type the first letter for a new room name. Looks like the old
> > > > > error where even if the user was granted admin access Group
> > > > > Admin Access is denied (see attached log)
> > > > >
> > > > >
> > > > >
> > > > > Version4.0.5-SNAPSHOT
> > > > >
> > > > > Revisionb154bef
> > > > >
> > > > > Build date2018-08-03T10:13:48Z
> > > > >
> > > > >
> > > > >
> > > > > Also looks like when doing the import there is a problem.
> > > > > When you are 1st setting up your new install of OM you create
> > > > > an admin account; so in the database that is “Profile 1”.
> > > > > Where the problem lies is when you do an export from your old
> > > > > system it also exports the old “admin” account (which on the
> > > > > old system was also profile_1) but when you do the import
> > > > > since there is already a profile_1 it moves everything down 1
> > > > > so the old admin account become id 2 on down the line. My account when exported was profile_2 but now my account is now labeled as profile_3 so the
> > > > > image is not there but the old admin account has my profile.jpg. (also
> > > > > in attachment)
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > WBR
> > > > Maxim aka solomax
> > >
> > >
> > >
> > > --
> > > WBR
> > > Maxim aka solomax
> > >
> > >
> >
> >
> > --
> > WBR
> > Maxim aka solomax
>
>
>
> --
> WBR
> Maxim aka solomax
--
WBR
Maxim aka solomax
Re: Conference Room creation update error
Posted by Maxim Solodovnik <so...@gmail.com>.
Just performed command line import ~50k users with lots of profile pictures
All images seems to be preserved
So everything seems to work as expected
`./admin.sh -v -i -file
~/work/openmeetings/backup/backup_2015_12_07_03_35_39.zip`
Could you please provide your steps?
On Sun, Aug 5, 2018 at 10:35 AM Maxim Solodovnik <so...@gmail.com> wrote:
>
> According to pictures uploaded by users: format change does not affect
> such profile images, cause file name with extension is stored in
> xml/DB :)))
> On Sun, Aug 5, 2018 at 10:30 AM Maxim Solodovnik <so...@gmail.com> wrote:
> >
> > Hello Aaron,
> >
> > Thanks for detailed testing
> > Profile folders should be moved to proper locations ...
> > (https://github.com/apache/openmeetings/blob/4.0.x/openmeetings-install/src/main/java/org/apache/openmeetings/backup/BackupImport.java#L1040)
> >
> > I'll double-check and report back
> > On Sun, Aug 5, 2018 at 2:42 AM Aaron H <aa...@gmail.com> wrote:
> > >
> > > After further testing it will still accept the profile image being in jpg format. Any new image will be saved in the .png format.
> > >
> > > Looks like my problem I was having was due to the import not running properly (I'm assuming). The user.xml import was successful (as all user data was there), but what failed was putting each user's profile (profile_#) into the proper place /webapps/openmeeting/upload/profiles/. Instead it left all the files in the import/<importdatetime>/roomfiles/profiles/ folder. So while the users.xml files was parsed and it said in each profile_# the profile image was profile.jpg, that jpg file did not exist due to it not being imported properly.
> > >
> > > After manually moving each users profile_# folder into the proper place everything worked as expected. If a user had no stored image then there was no need to do the import as their profile would be created on their returning login.
> > >
> > > So it was either 1 of 2 things. Either A) a bad import function (as imported filed were placed in wrong locations, or B) import partially failed due to image format change. Was 4.0.4 image format still .jpg or had that one been moved to .png? I was going to stand up an official release if file format was still .jpg to see if it can narrow down what caused the import to not run fully.
> > >
> > >
> > > -----Original Message-----
> > > From: aaron.hepp@gmail.com <aa...@gmail.com>
> > > Sent: Saturday, August 4, 2018 6:23 AM
> > > To: user@openmeetings.apache.org
> > > Subject: RE: Conference Room creation update error
> > >
> > > Yes looks like the room crashing has been resolved. Thank you for the prompt fix.
> > >
> > > The profile image I am referring to is the default profile image that is located at /webapps/Openmeetings/images/profile.* But I see why the issue. Looks like the default image format was changed from .jpg to .png and in my customization script I was importing profile.jpg so I changed the script to .png and this resolved that issue. Didn't notice the file extension had changed.
> > >
> > > The last issue I am seeing is the import from the previous backup. It is importing all the users data for the database account name / password / contact info / .etc, but it is not importing the users profile image they had uploaded. The import was placed at
> > >
> > > /webapps/Openmeetings/upload/import/import_2018_08_04_05_59_04/roomFiles/profiles/
> > >
> > > so when a returning user logs in their profile is created:
> > >
> > > /webapps/Openmeetings/upload/profiles/
> > >
> > > But just now looking as I uploaded a new profile picture for myself as a test I see the reason. It looks like it stems from the file format change. The backup has everything as profile.jpg where it is looking for a .png file.
> > >
> > > Just a heads up for anyone taking an older backup from a previous version, you will have to manually copy each users profile.jpg file from the import folder to each users profile space as a .png file
> > >
> > > For me this was an example:
> > >
> > > cp /opt/current/webapps/trade-group/upload/import/import_2018_08_04_05_59_04/roomFiles/profiles/profile_2/profile.jpg /opt/current/webapps/trade-group/upload/profiles/profile_2/profile.png
> > >
> > > this must be done for each user or tell each user that they just have to re-upload their image if they want one.
> > >
> > >
> > > -----Original Message-----
> > > From: Maxim Solodovnik <so...@gmail.com>
> > > Sent: Friday, August 3, 2018 11:08 PM
> > > To: Openmeetings user-list <us...@openmeetings.apache.org>
> > > Subject: Re: Conference Room creation update error
> > >
> > > Just have tried, profile images in jpg format are being displayed as expected Could you please tell me what were your exact steps to reproduce?
> > >
> > > BTW Thanks a lot for checking latest nightly :))) On Sat, Aug 4, 2018 at
> > > 9:39 AM Maxim Solodovnik <so...@gmail.com> wrote:
> > > >
> > > > Hello Aaron,
> > > >
> > > > page crash was just fixed
> > > > Will take a look at profile image issue (most probably caused by
> > > > migration from JPG to PNG)
> > > >
> > > > According to new install, then import I would recommend to use command
> > > > line admin in this case
> > > > http://openmeetings.apache.org/CommandLineAdmin.html
> > > > the options I'm using: -file --skip-default-objects On Sat, Aug 4,
> > > > 2018 at 9:26 AM <aa...@gmail.com> wrote:
> > > > >
> > > > > Looks like my 1st attachment did not have the complete debug in it.
> > > > > Attached is the full log.
> > > > >
> > > > >
> > > > >
> > > > > Looks like also whatever is causing this error is also what is
> > > > > causing the import not to work properly. I use a different
> > > > > profile.jpg image for default users (located at
> > > > > /webapps/openmeetings/images/profile.jpg) and that does not get
> > > > > shown on the users profile. It is pulling the image that is the
> > > > > standard image that has the question mark in the body. Not even
> > > > > sure where it is pulling that from since the file was replaced with
> > > > > a different file all together. When you copy the image location it
> > > > > states (/profile/1?anticache=1532949138000)
> > > > >
> > > > >
> > > > >
> > > > > I re-installed the official release and that one works as expected
> > > > > (room configuration and changed default image)
> > > > >
> > > > >
> > > > >
> > > > > From: aaron.hepp@gmail.com <aa...@gmail.com>
> > > > > Sent: Friday, August 3, 2018 9:19 PM
> > > > > To: user@openmeetings.apache.org
> > > > > Subject: Conference Room creation update error
> > > > >
> > > > >
> > > > >
> > > > > Looks like an old error is back. I just installed the latest
> > > > > nightly build and now get thrown to the internal error page if you
> > > > > try to update and existing conference room or when you type the
> > > > > first letter for a new room name. Looks like the old error where
> > > > > even if the user was granted admin access Group Admin Access is
> > > > > denied (see attached log)
> > > > >
> > > > >
> > > > >
> > > > > Version4.0.5-SNAPSHOT
> > > > >
> > > > > Revisionb154bef
> > > > >
> > > > > Build date2018-08-03T10:13:48Z
> > > > >
> > > > >
> > > > >
> > > > > Also looks like when doing the import there is a problem. When you
> > > > > are 1st setting up your new install of OM you create an admin
> > > > > account; so in the database that is “Profile 1”. Where the problem
> > > > > lies is when you do an export from your old system it also exports
> > > > > the old “admin” account (which on the old system was also profile_1)
> > > > > but when you do the import since there is already a profile_1 it
> > > > > moves everything down 1 so the old admin account become id 2 on down
> > > > > the line. My account when exported was profile_2 but now my account is now labeled as profile_3 so the
> > > > > image is not there but the old admin account has my profile.jpg. (also
> > > > > in attachment)
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > WBR
> > > > Maxim aka solomax
> > >
> > >
> > >
> > > --
> > > WBR
> > > Maxim aka solomax
> > >
> > >
> >
> >
> > --
> > WBR
> > Maxim aka solomax
>
>
>
> --
> WBR
> Maxim aka solomax
--
WBR
Maxim aka solomax
Re: Conference Room creation update error
Posted by Maxim Solodovnik <so...@gmail.com>.
According to pictures uploaded by users: format change does not affect
such profile images, cause file name with extension is stored in
xml/DB :)))
On Sun, Aug 5, 2018 at 10:30 AM Maxim Solodovnik <so...@gmail.com> wrote:
>
> Hello Aaron,
>
> Thanks for detailed testing
> Profile folders should be moved to proper locations ...
> (https://github.com/apache/openmeetings/blob/4.0.x/openmeetings-install/src/main/java/org/apache/openmeetings/backup/BackupImport.java#L1040)
>
> I'll double-check and report back
> On Sun, Aug 5, 2018 at 2:42 AM Aaron H <aa...@gmail.com> wrote:
> >
> > After further testing it will still accept the profile image being in jpg format. Any new image will be saved in the .png format.
> >
> > Looks like my problem I was having was due to the import not running properly (I'm assuming). The user.xml import was successful (as all user data was there), but what failed was putting each user's profile (profile_#) into the proper place /webapps/openmeeting/upload/profiles/. Instead it left all the files in the import/<importdatetime>/roomfiles/profiles/ folder. So while the users.xml files was parsed and it said in each profile_# the profile image was profile.jpg, that jpg file did not exist due to it not being imported properly.
> >
> > After manually moving each users profile_# folder into the proper place everything worked as expected. If a user had no stored image then there was no need to do the import as their profile would be created on their returning login.
> >
> > So it was either 1 of 2 things. Either A) a bad import function (as imported filed were placed in wrong locations, or B) import partially failed due to image format change. Was 4.0.4 image format still .jpg or had that one been moved to .png? I was going to stand up an official release if file format was still .jpg to see if it can narrow down what caused the import to not run fully.
> >
> >
> > -----Original Message-----
> > From: aaron.hepp@gmail.com <aa...@gmail.com>
> > Sent: Saturday, August 4, 2018 6:23 AM
> > To: user@openmeetings.apache.org
> > Subject: RE: Conference Room creation update error
> >
> > Yes looks like the room crashing has been resolved. Thank you for the prompt fix.
> >
> > The profile image I am referring to is the default profile image that is located at /webapps/Openmeetings/images/profile.* But I see why the issue. Looks like the default image format was changed from .jpg to .png and in my customization script I was importing profile.jpg so I changed the script to .png and this resolved that issue. Didn't notice the file extension had changed.
> >
> > The last issue I am seeing is the import from the previous backup. It is importing all the users data for the database account name / password / contact info / .etc, but it is not importing the users profile image they had uploaded. The import was placed at
> >
> > /webapps/Openmeetings/upload/import/import_2018_08_04_05_59_04/roomFiles/profiles/
> >
> > so when a returning user logs in their profile is created:
> >
> > /webapps/Openmeetings/upload/profiles/
> >
> > But just now looking as I uploaded a new profile picture for myself as a test I see the reason. It looks like it stems from the file format change. The backup has everything as profile.jpg where it is looking for a .png file.
> >
> > Just a heads up for anyone taking an older backup from a previous version, you will have to manually copy each users profile.jpg file from the import folder to each users profile space as a .png file
> >
> > For me this was an example:
> >
> > cp /opt/current/webapps/trade-group/upload/import/import_2018_08_04_05_59_04/roomFiles/profiles/profile_2/profile.jpg /opt/current/webapps/trade-group/upload/profiles/profile_2/profile.png
> >
> > this must be done for each user or tell each user that they just have to re-upload their image if they want one.
> >
> >
> > -----Original Message-----
> > From: Maxim Solodovnik <so...@gmail.com>
> > Sent: Friday, August 3, 2018 11:08 PM
> > To: Openmeetings user-list <us...@openmeetings.apache.org>
> > Subject: Re: Conference Room creation update error
> >
> > Just have tried, profile images in jpg format are being displayed as expected Could you please tell me what were your exact steps to reproduce?
> >
> > BTW Thanks a lot for checking latest nightly :))) On Sat, Aug 4, 2018 at
> > 9:39 AM Maxim Solodovnik <so...@gmail.com> wrote:
> > >
> > > Hello Aaron,
> > >
> > > page crash was just fixed
> > > Will take a look at profile image issue (most probably caused by
> > > migration from JPG to PNG)
> > >
> > > According to new install, then import I would recommend to use command
> > > line admin in this case
> > > http://openmeetings.apache.org/CommandLineAdmin.html
> > > the options I'm using: -file --skip-default-objects On Sat, Aug 4,
> > > 2018 at 9:26 AM <aa...@gmail.com> wrote:
> > > >
> > > > Looks like my 1st attachment did not have the complete debug in it.
> > > > Attached is the full log.
> > > >
> > > >
> > > >
> > > > Looks like also whatever is causing this error is also what is
> > > > causing the import not to work properly. I use a different
> > > > profile.jpg image for default users (located at
> > > > /webapps/openmeetings/images/profile.jpg) and that does not get
> > > > shown on the users profile. It is pulling the image that is the
> > > > standard image that has the question mark in the body. Not even
> > > > sure where it is pulling that from since the file was replaced with
> > > > a different file all together. When you copy the image location it
> > > > states (/profile/1?anticache=1532949138000)
> > > >
> > > >
> > > >
> > > > I re-installed the official release and that one works as expected
> > > > (room configuration and changed default image)
> > > >
> > > >
> > > >
> > > > From: aaron.hepp@gmail.com <aa...@gmail.com>
> > > > Sent: Friday, August 3, 2018 9:19 PM
> > > > To: user@openmeetings.apache.org
> > > > Subject: Conference Room creation update error
> > > >
> > > >
> > > >
> > > > Looks like an old error is back. I just installed the latest
> > > > nightly build and now get thrown to the internal error page if you
> > > > try to update and existing conference room or when you type the
> > > > first letter for a new room name. Looks like the old error where
> > > > even if the user was granted admin access Group Admin Access is
> > > > denied (see attached log)
> > > >
> > > >
> > > >
> > > > Version4.0.5-SNAPSHOT
> > > >
> > > > Revisionb154bef
> > > >
> > > > Build date2018-08-03T10:13:48Z
> > > >
> > > >
> > > >
> > > > Also looks like when doing the import there is a problem. When you
> > > > are 1st setting up your new install of OM you create an admin
> > > > account; so in the database that is “Profile 1”. Where the problem
> > > > lies is when you do an export from your old system it also exports
> > > > the old “admin” account (which on the old system was also profile_1)
> > > > but when you do the import since there is already a profile_1 it
> > > > moves everything down 1 so the old admin account become id 2 on down
> > > > the line. My account when exported was profile_2 but now my account is now labeled as profile_3 so the
> > > > image is not there but the old admin account has my profile.jpg. (also
> > > > in attachment)
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > > --
> > > WBR
> > > Maxim aka solomax
> >
> >
> >
> > --
> > WBR
> > Maxim aka solomax
> >
> >
>
>
> --
> WBR
> Maxim aka solomax
--
WBR
Maxim aka solomax
Re: Conference Room creation update error
Posted by Maxim Solodovnik <so...@gmail.com>.
Hello Aaron,
Thanks for detailed testing
Profile folders should be moved to proper locations ...
(https://github.com/apache/openmeetings/blob/4.0.x/openmeetings-install/src/main/java/org/apache/openmeetings/backup/BackupImport.java#L1040)
I'll double-check and report back
On Sun, Aug 5, 2018 at 2:42 AM Aaron H <aa...@gmail.com> wrote:
>
> After further testing it will still accept the profile image being in jpg format. Any new image will be saved in the .png format.
>
> Looks like my problem I was having was due to the import not running properly (I'm assuming). The user.xml import was successful (as all user data was there), but what failed was putting each user's profile (profile_#) into the proper place /webapps/openmeeting/upload/profiles/. Instead it left all the files in the import/<importdatetime>/roomfiles/profiles/ folder. So while the users.xml files was parsed and it said in each profile_# the profile image was profile.jpg, that jpg file did not exist due to it not being imported properly.
>
> After manually moving each users profile_# folder into the proper place everything worked as expected. If a user had no stored image then there was no need to do the import as their profile would be created on their returning login.
>
> So it was either 1 of 2 things. Either A) a bad import function (as imported filed were placed in wrong locations, or B) import partially failed due to image format change. Was 4.0.4 image format still .jpg or had that one been moved to .png? I was going to stand up an official release if file format was still .jpg to see if it can narrow down what caused the import to not run fully.
>
>
> -----Original Message-----
> From: aaron.hepp@gmail.com <aa...@gmail.com>
> Sent: Saturday, August 4, 2018 6:23 AM
> To: user@openmeetings.apache.org
> Subject: RE: Conference Room creation update error
>
> Yes looks like the room crashing has been resolved. Thank you for the prompt fix.
>
> The profile image I am referring to is the default profile image that is located at /webapps/Openmeetings/images/profile.* But I see why the issue. Looks like the default image format was changed from .jpg to .png and in my customization script I was importing profile.jpg so I changed the script to .png and this resolved that issue. Didn't notice the file extension had changed.
>
> The last issue I am seeing is the import from the previous backup. It is importing all the users data for the database account name / password / contact info / .etc, but it is not importing the users profile image they had uploaded. The import was placed at
>
> /webapps/Openmeetings/upload/import/import_2018_08_04_05_59_04/roomFiles/profiles/
>
> so when a returning user logs in their profile is created:
>
> /webapps/Openmeetings/upload/profiles/
>
> But just now looking as I uploaded a new profile picture for myself as a test I see the reason. It looks like it stems from the file format change. The backup has everything as profile.jpg where it is looking for a .png file.
>
> Just a heads up for anyone taking an older backup from a previous version, you will have to manually copy each users profile.jpg file from the import folder to each users profile space as a .png file
>
> For me this was an example:
>
> cp /opt/current/webapps/trade-group/upload/import/import_2018_08_04_05_59_04/roomFiles/profiles/profile_2/profile.jpg /opt/current/webapps/trade-group/upload/profiles/profile_2/profile.png
>
> this must be done for each user or tell each user that they just have to re-upload their image if they want one.
>
>
> -----Original Message-----
> From: Maxim Solodovnik <so...@gmail.com>
> Sent: Friday, August 3, 2018 11:08 PM
> To: Openmeetings user-list <us...@openmeetings.apache.org>
> Subject: Re: Conference Room creation update error
>
> Just have tried, profile images in jpg format are being displayed as expected Could you please tell me what were your exact steps to reproduce?
>
> BTW Thanks a lot for checking latest nightly :))) On Sat, Aug 4, 2018 at
> 9:39 AM Maxim Solodovnik <so...@gmail.com> wrote:
> >
> > Hello Aaron,
> >
> > page crash was just fixed
> > Will take a look at profile image issue (most probably caused by
> > migration from JPG to PNG)
> >
> > According to new install, then import I would recommend to use command
> > line admin in this case
> > http://openmeetings.apache.org/CommandLineAdmin.html
> > the options I'm using: -file --skip-default-objects On Sat, Aug 4,
> > 2018 at 9:26 AM <aa...@gmail.com> wrote:
> > >
> > > Looks like my 1st attachment did not have the complete debug in it.
> > > Attached is the full log.
> > >
> > >
> > >
> > > Looks like also whatever is causing this error is also what is
> > > causing the import not to work properly. I use a different
> > > profile.jpg image for default users (located at
> > > /webapps/openmeetings/images/profile.jpg) and that does not get
> > > shown on the users profile. It is pulling the image that is the
> > > standard image that has the question mark in the body. Not even
> > > sure where it is pulling that from since the file was replaced with
> > > a different file all together. When you copy the image location it
> > > states (/profile/1?anticache=1532949138000)
> > >
> > >
> > >
> > > I re-installed the official release and that one works as expected
> > > (room configuration and changed default image)
> > >
> > >
> > >
> > > From: aaron.hepp@gmail.com <aa...@gmail.com>
> > > Sent: Friday, August 3, 2018 9:19 PM
> > > To: user@openmeetings.apache.org
> > > Subject: Conference Room creation update error
> > >
> > >
> > >
> > > Looks like an old error is back. I just installed the latest
> > > nightly build and now get thrown to the internal error page if you
> > > try to update and existing conference room or when you type the
> > > first letter for a new room name. Looks like the old error where
> > > even if the user was granted admin access Group Admin Access is
> > > denied (see attached log)
> > >
> > >
> > >
> > > Version4.0.5-SNAPSHOT
> > >
> > > Revisionb154bef
> > >
> > > Build date2018-08-03T10:13:48Z
> > >
> > >
> > >
> > > Also looks like when doing the import there is a problem. When you
> > > are 1st setting up your new install of OM you create an admin
> > > account; so in the database that is “Profile 1”. Where the problem
> > > lies is when you do an export from your old system it also exports
> > > the old “admin” account (which on the old system was also profile_1)
> > > but when you do the import since there is already a profile_1 it
> > > moves everything down 1 so the old admin account become id 2 on down
> > > the line. My account when exported was profile_2 but now my account is now labeled as profile_3 so the
> > > image is not there but the old admin account has my profile.jpg. (also
> > > in attachment)
> > >
> > >
> > >
> > >
> >
> >
> >
> > --
> > WBR
> > Maxim aka solomax
>
>
>
> --
> WBR
> Maxim aka solomax
>
>
--
WBR
Maxim aka solomax
RE: Conference Room creation update error
Posted by Aaron H <aa...@gmail.com>.
After further testing it will still accept the profile image being in jpg format. Any new image will be saved in the .png format.
Looks like my problem I was having was due to the import not running properly (I'm assuming). The user.xml import was successful (as all user data was there), but what failed was putting each user's profile (profile_#) into the proper place /webapps/openmeeting/upload/profiles/. Instead it left all the files in the import/<importdatetime>/roomfiles/profiles/ folder. So while the users.xml files was parsed and it said in each profile_# the profile image was profile.jpg, that jpg file did not exist due to it not being imported properly.
After manually moving each users profile_# folder into the proper place everything worked as expected. If a user had no stored image then there was no need to do the import as their profile would be created on their returning login.
So it was either 1 of 2 things. Either A) a bad import function (as imported filed were placed in wrong locations, or B) import partially failed due to image format change. Was 4.0.4 image format still .jpg or had that one been moved to .png? I was going to stand up an official release if file format was still .jpg to see if it can narrow down what caused the import to not run fully.
-----Original Message-----
From: aaron.hepp@gmail.com <aa...@gmail.com>
Sent: Saturday, August 4, 2018 6:23 AM
To: user@openmeetings.apache.org
Subject: RE: Conference Room creation update error
Yes looks like the room crashing has been resolved. Thank you for the prompt fix.
The profile image I am referring to is the default profile image that is located at /webapps/Openmeetings/images/profile.* But I see why the issue. Looks like the default image format was changed from .jpg to .png and in my customization script I was importing profile.jpg so I changed the script to .png and this resolved that issue. Didn't notice the file extension had changed.
The last issue I am seeing is the import from the previous backup. It is importing all the users data for the database account name / password / contact info / .etc, but it is not importing the users profile image they had uploaded. The import was placed at
/webapps/Openmeetings/upload/import/import_2018_08_04_05_59_04/roomFiles/profiles/
so when a returning user logs in their profile is created:
/webapps/Openmeetings/upload/profiles/
But just now looking as I uploaded a new profile picture for myself as a test I see the reason. It looks like it stems from the file format change. The backup has everything as profile.jpg where it is looking for a .png file.
Just a heads up for anyone taking an older backup from a previous version, you will have to manually copy each users profile.jpg file from the import folder to each users profile space as a .png file
For me this was an example:
cp /opt/current/webapps/trade-group/upload/import/import_2018_08_04_05_59_04/roomFiles/profiles/profile_2/profile.jpg /opt/current/webapps/trade-group/upload/profiles/profile_2/profile.png
this must be done for each user or tell each user that they just have to re-upload their image if they want one.
-----Original Message-----
From: Maxim Solodovnik <so...@gmail.com>
Sent: Friday, August 3, 2018 11:08 PM
To: Openmeetings user-list <us...@openmeetings.apache.org>
Subject: Re: Conference Room creation update error
Just have tried, profile images in jpg format are being displayed as expected Could you please tell me what were your exact steps to reproduce?
BTW Thanks a lot for checking latest nightly :))) On Sat, Aug 4, 2018 at
9:39 AM Maxim Solodovnik <so...@gmail.com> wrote:
>
> Hello Aaron,
>
> page crash was just fixed
> Will take a look at profile image issue (most probably caused by
> migration from JPG to PNG)
>
> According to new install, then import I would recommend to use command
> line admin in this case
> http://openmeetings.apache.org/CommandLineAdmin.html
> the options I'm using: -file --skip-default-objects On Sat, Aug 4,
> 2018 at 9:26 AM <aa...@gmail.com> wrote:
> >
> > Looks like my 1st attachment did not have the complete debug in it.
> > Attached is the full log.
> >
> >
> >
> > Looks like also whatever is causing this error is also what is
> > causing the import not to work properly. I use a different
> > profile.jpg image for default users (located at
> > /webapps/openmeetings/images/profile.jpg) and that does not get
> > shown on the users profile. It is pulling the image that is the
> > standard image that has the question mark in the body. Not even
> > sure where it is pulling that from since the file was replaced with
> > a different file all together. When you copy the image location it
> > states (/profile/1?anticache=1532949138000)
> >
> >
> >
> > I re-installed the official release and that one works as expected
> > (room configuration and changed default image)
> >
> >
> >
> > From: aaron.hepp@gmail.com <aa...@gmail.com>
> > Sent: Friday, August 3, 2018 9:19 PM
> > To: user@openmeetings.apache.org
> > Subject: Conference Room creation update error
> >
> >
> >
> > Looks like an old error is back. I just installed the latest
> > nightly build and now get thrown to the internal error page if you
> > try to update and existing conference room or when you type the
> > first letter for a new room name. Looks like the old error where
> > even if the user was granted admin access Group Admin Access is
> > denied (see attached log)
> >
> >
> >
> > Version4.0.5-SNAPSHOT
> >
> > Revisionb154bef
> >
> > Build date2018-08-03T10:13:48Z
> >
> >
> >
> > Also looks like when doing the import there is a problem. When you
> > are 1st setting up your new install of OM you create an admin
> > account; so in the database that is “Profile 1”. Where the problem
> > lies is when you do an export from your old system it also exports
> > the old “admin” account (which on the old system was also profile_1)
> > but when you do the import since there is already a profile_1 it
> > moves everything down 1 so the old admin account become id 2 on down
> > the line. My account when exported was profile_2 but now my account is now labeled as profile_3 so the
> > image is not there but the old admin account has my profile.jpg. (also
> > in attachment)
> >
> >
> >
> >
>
>
>
> --
> WBR
> Maxim aka solomax
--
WBR
Maxim aka solomax
RE: Conference Room creation update error
Posted by aa...@gmail.com.
Yes looks like the room crashing has been resolved. Thank you for the prompt fix.
The profile image I am referring to is the default profile image that is located at /webapps/Openmeetings/images/profile.* But I see why the issue. Looks like the default image format was changed from .jpg to .png and in my customization script I was importing profile.jpg so I changed the script to .png and this resolved that issue. Didn't notice the file extension had changed.
The last issue I am seeing is the import from the previous backup. It is importing all the users data for the database account name / password / contact info / .etc, but it is not importing the users profile image they had uploaded. The import was placed at
/webapps/Openmeetings/upload/import/import_2018_08_04_05_59_04/roomFiles/profiles/
so when a returning user logs in their profile is created:
/webapps/Openmeetings/upload/profiles/
But just now looking as I uploaded a new profile picture for myself as a test I see the reason. It looks like it stems from the file format change. The backup has everything as profile.jpg where it is looking for a .png file.
Just a heads up for anyone taking an older backup from a previous version, you will have to manually copy each users profile.jpg file from the import folder to each users profile space as a .png file
For me this was an example:
cp /opt/current/webapps/trade-group/upload/import/import_2018_08_04_05_59_04/roomFiles/profiles/profile_2/profile.jpg /opt/current/webapps/trade-group/upload/profiles/profile_2/profile.png
this must be done for each user or tell each user that they just have to re-upload their image if they want one.
-----Original Message-----
From: Maxim Solodovnik <so...@gmail.com>
Sent: Friday, August 3, 2018 11:08 PM
To: Openmeetings user-list <us...@openmeetings.apache.org>
Subject: Re: Conference Room creation update error
Just have tried, profile images in jpg format are being displayed as
expected Could you please tell me what were your exact steps to reproduce?
BTW Thanks a lot for checking latest nightly :))) On Sat, Aug 4, 2018 at
9:39 AM Maxim Solodovnik <so...@gmail.com> wrote:
>
> Hello Aaron,
>
> page crash was just fixed
> Will take a look at profile image issue (most probably caused by
> migration from JPG to PNG)
>
> According to new install, then import I would recommend to use command
> line admin in this case
> http://openmeetings.apache.org/CommandLineAdmin.html
> the options I'm using: -file --skip-default-objects On Sat, Aug 4,
> 2018 at 9:26 AM <aa...@gmail.com> wrote:
> >
> > Looks like my 1st attachment did not have the complete debug in it.
> > Attached is the full log.
> >
> >
> >
> > Looks like also whatever is causing this error is also what is
> > causing the import not to work properly. I use a different
> > profile.jpg image for default users (located at
> > /webapps/openmeetings/images/profile.jpg) and that does not get
> > shown on the users profile. It is pulling the image that is the
> > standard image that has the question mark in the body. Not even
> > sure where it is pulling that from since the file was replaced with
> > a different file all together. When you copy the image location it
> > states (/profile/1?anticache=1532949138000)
> >
> >
> >
> > I re-installed the official release and that one works as expected
> > (room configuration and changed default image)
> >
> >
> >
> > From: aaron.hepp@gmail.com <aa...@gmail.com>
> > Sent: Friday, August 3, 2018 9:19 PM
> > To: user@openmeetings.apache.org
> > Subject: Conference Room creation update error
> >
> >
> >
> > Looks like an old error is back. I just installed the latest
> > nightly build and now get thrown to the internal error page if you
> > try to update and existing conference room or when you type the
> > first letter for a new room name. Looks like the old error where
> > even if the user was granted admin access Group Admin Access is
> > denied (see attached log)
> >
> >
> >
> > Version4.0.5-SNAPSHOT
> >
> > Revisionb154bef
> >
> > Build date2018-08-03T10:13:48Z
> >
> >
> >
> > Also looks like when doing the import there is a problem. When you are
> > 1st setting up your new install of OM you create an admin account; so in
> > the database that is “Profile 1”. Where the problem lies is when you do
> > an export from your old system it also exports the old “admin” account
> > (which on the old system was also profile_1) but when you do the import
> > since there is already a profile_1 it moves everything down 1 so the old
> > admin account become id 2 on down the line. My account when exported
> > was profile_2 but now my account is now labeled as profile_3 so the
> > image is not there but the old admin account has my profile.jpg. (also
> > in attachment)
> >
> >
> >
> >
>
>
>
> --
> WBR
> Maxim aka solomax
--
WBR
Maxim aka solomax
Re: Conference Room creation update error
Posted by Maxim Solodovnik <so...@gmail.com>.
Just have tried, profile images in jpg format are being displayed as expected
Could you please tell me what were your exact steps to reproduce?
BTW Thanks a lot for checking latest nightly :)))
On Sat, Aug 4, 2018 at 9:39 AM Maxim Solodovnik <so...@gmail.com> wrote:
>
> Hello Aaron,
>
> page crash was just fixed
> Will take a look at profile image issue (most probably caused by
> migration from JPG to PNG)
>
> According to new install, then import I would recommend to use command
> line admin in this case
> http://openmeetings.apache.org/CommandLineAdmin.html
> the options I'm using: -file --skip-default-objects
> On Sat, Aug 4, 2018 at 9:26 AM <aa...@gmail.com> wrote:
> >
> > Looks like my 1st attachment did not have the complete debug in it. Attached is the full log.
> >
> >
> >
> > Looks like also whatever is causing this error is also what is causing the import not to work properly. I use a different profile.jpg image for default users (located at /webapps/openmeetings/images/profile.jpg) and that does not get shown on the users profile. It is pulling the image that is the standard image that has the question mark in the body. Not even sure where it is pulling that from since the file was replaced with a different file all together. When you copy the image location it states (/profile/1?anticache=1532949138000)
> >
> >
> >
> > I re-installed the official release and that one works as expected (room configuration and changed default image)
> >
> >
> >
> > From: aaron.hepp@gmail.com <aa...@gmail.com>
> > Sent: Friday, August 3, 2018 9:19 PM
> > To: user@openmeetings.apache.org
> > Subject: Conference Room creation update error
> >
> >
> >
> > Looks like an old error is back. I just installed the latest nightly build and now get thrown to the internal error page if you try to update and existing conference room or when you type the first letter for a new room name. Looks like the old error where even if the user was granted admin access Group Admin Access is denied (see attached log)
> >
> >
> >
> > Version4.0.5-SNAPSHOT
> >
> > Revisionb154bef
> >
> > Build date2018-08-03T10:13:48Z
> >
> >
> >
> > Also looks like when doing the import there is a problem. When you are 1st setting up your new install of OM you create an admin account; so in the database that is “Profile 1”. Where the problem lies is when you do an export from your old system it also exports the old “admin” account (which on the old system was also profile_1) but when you do the import since there is already a profile_1 it moves everything down 1 so the old admin account become id 2 on down the line. My account when exported was profile_2 but now my account is now labeled as profile_3 so the image is not there but the old admin account has my profile.jpg. (also in attachment)
> >
> >
> >
> >
>
>
>
> --
> WBR
> Maxim aka solomax
--
WBR
Maxim aka solomax
Re: Conference Room creation update error
Posted by Maxim Solodovnik <so...@gmail.com>.
Hello Aaron,
page crash was just fixed
Will take a look at profile image issue (most probably caused by
migration from JPG to PNG)
According to new install, then import I would recommend to use command
line admin in this case
http://openmeetings.apache.org/CommandLineAdmin.html
the options I'm using: -file --skip-default-objects
On Sat, Aug 4, 2018 at 9:26 AM <aa...@gmail.com> wrote:
>
> Looks like my 1st attachment did not have the complete debug in it. Attached is the full log.
>
>
>
> Looks like also whatever is causing this error is also what is causing the import not to work properly. I use a different profile.jpg image for default users (located at /webapps/openmeetings/images/profile.jpg) and that does not get shown on the users profile. It is pulling the image that is the standard image that has the question mark in the body. Not even sure where it is pulling that from since the file was replaced with a different file all together. When you copy the image location it states (/profile/1?anticache=1532949138000)
>
>
>
> I re-installed the official release and that one works as expected (room configuration and changed default image)
>
>
>
> From: aaron.hepp@gmail.com <aa...@gmail.com>
> Sent: Friday, August 3, 2018 9:19 PM
> To: user@openmeetings.apache.org
> Subject: Conference Room creation update error
>
>
>
> Looks like an old error is back. I just installed the latest nightly build and now get thrown to the internal error page if you try to update and existing conference room or when you type the first letter for a new room name. Looks like the old error where even if the user was granted admin access Group Admin Access is denied (see attached log)
>
>
>
> Version4.0.5-SNAPSHOT
>
> Revisionb154bef
>
> Build date2018-08-03T10:13:48Z
>
>
>
> Also looks like when doing the import there is a problem. When you are 1st setting up your new install of OM you create an admin account; so in the database that is “Profile 1”. Where the problem lies is when you do an export from your old system it also exports the old “admin” account (which on the old system was also profile_1) but when you do the import since there is already a profile_1 it moves everything down 1 so the old admin account become id 2 on down the line. My account when exported was profile_2 but now my account is now labeled as profile_3 so the image is not there but the old admin account has my profile.jpg. (also in attachment)
>
>
>
>
--
WBR
Maxim aka solomax
RE: Conference Room creation update error
Posted by aa...@gmail.com.
Looks like my 1st attachment did not have the complete debug in it.
Attached is the full log.
Looks like also whatever is causing this error is also what is causing the
import not to work properly. I use a different profile.jpg image for
default users (located at /webapps/openmeetings/images/profile.jpg) and that
does not get shown on the users profile. It is pulling the image that is
the standard image that has the question mark in the body. Not even sure
where it is pulling that from since the file was replaced with a different
file all together. When you copy the image location it states
(/profile/1?anticache=1532949138000)
I re-installed the official release and that one works as expected (room
configuration and changed default image)
From: aaron.hepp@gmail.com <aa...@gmail.com>
Sent: Friday, August 3, 2018 9:19 PM
To: user@openmeetings.apache.org
Subject: Conference Room creation update error
Looks like an old error is back. I just installed the latest nightly build
and now get thrown to the internal error page if you try to update and
existing conference room or when you type the first letter for a new room
name. Looks like the old error where even if the user was granted admin
access Group Admin Access is denied (see attached log)
Version4.0.5-SNAPSHOT
Revisionb154bef
Build date2018-08-03T10:13:48Z
Also looks like when doing the import there is a problem. When you are 1st
setting up your new install of OM you create an admin account; so in the
database that is "Profile 1". Where the problem lies is when you do an
export from your old system it also exports the old "admin" account (which
on the old system was also profile_1) but when you do the import since there
is already a profile_1 it moves everything down 1 so the old admin account
become id 2 on down the line. My account when exported was profile_2 but
now my account is now labeled as profile_3 so the image is not there but the
old admin account has my profile.jpg. (also in attachment)