You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by Maxim Solodovnik <so...@gmail.com> on 2019/07/11 05:17:30 UTC

Re: conversion problem during update

No answers for a long time
I guess this one is not a common problem

On Mon, 3 Jun 2019 at 13:44, Peter Dähn <da...@vcrp.de> wrote:
>
> Hi Maxim,
>
> you are right, to add this would help, if it is a common problem.
>
> This is a really old file. It seems that it was already a pdf-file.
> Original content of the folder was
>
> HASH.pdf, HASH.swf, library.xml and for each page of the pdf a
> _thumb_page-XXXX.jpg.
>
> Greetings Peter
>
> Am 31.05.19 um 18:39 schrieb Maxim Solodovnik:
> > Hello Peter,
> >
> > I guess you propose to add "profile" param to OM code :)
> > I'm OK with it, could you check if your original document is being
> > converted by OM UI as expected or not?
> >
> > On Fri, 31 May 2019 at 20:03, Peter Dähn <da...@vcrp.de> wrote:
> >> Hi Maxim,
> >>
> >> I needed to convert some room files afterwards. I user command out of
> >> the logs and got for some files an error.
> >>
> >> /usr/bin/convert -density 125
> >> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf -quality
> >> 100 /SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
> >>
> >> convert: profile 'icc': 'RGB ': RGB color space not permitted on
> >> grayscale PNG
> >> `/SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png' @
> >> warning/png.c/MagickPNGWarningHandler/1654.
> >>
> >> I needed to add parameter +profile '*' . Now convert is working without
> >> error.
> >>
> >> /usr/bin/convert -density 125
> >> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf +profile
> >> '*' -quality 100
> >> /usr/lib/red5/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
> >>
> >> Greetings Peter
> >>
> >> Am 15.05.19 um 13:15 schrieb Peter Dähn:
> >>> Hi,
> >>>
> >>> I had a little problem during the last update (from 3.0.7 to 4.0.8). I
> >>> didn't realise, that ffmpeg didn't work after server update. The
> >>> following om update went throug, despite the fact, that
> >>> screen-recordings were not converted.
> >>>
> >>> That why I needed to figure out (with a little bit help of Maxim) how to
> >>> manage that afterwards. I would like to share my steps, in case someone
> >>> has a similar problem.
> >>>
> >>> 1. Get needed information from database (in my case it is postgres)
> >>>
> >>>  select id,hash from om_file where deleted=false and type='Recording'
> >>> and dtype='Recording' order by id;
> >>>
> >>> 2. save the result in a text file e.g. convert_recordings.txt
> >>>
> >>> 3. prepare a little script (linux/bash)
> >>>
> >>> #!/bin/bash
> >>> i=0
> >>> while read line
> >>> do
> >>>    #echo "$line"
> >>>    id=`echo $line | awk '{split($0, a, "|"); print a[1]}'`
> >>>    #echo $id
> >>>    hash=`echo $line | awk '{split($0, a, "|"); print a[2]}'`
> >>>    #echo $hash
> >>> #   echo "bearbeite $id"
> >>>    command_mp4="/usr/local/bin/ffmpeg -y -nostdin -i
> >>> /OM_OLD_DIR/webapps/openmeetings/data/streams/hibernate/flvRecording_$id.avi
> >>> -c:v h264 -crf 24 -pix_fmt yuv420p -preset medium -profile:v baseline
> >>> -level 3.0 -movflags faststart -c:a aac -ar 22050 -b:a 32k
> >>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4"
> >>> #   echo $command_mp4
> >>>    command_png="/usr/local/bin/ffmpeg -y -nostdin -i
> >>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4 -vf
> >>> thumbnail,scale=640:-1 -frames:v 1
> >>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.png"
> >>> #   echo $command_png
> >>>    $command_mp4
> >>>    $command_png
> >>> done < convert_recordings.txt
> >>>
> >>> 4. wait a looooong time (I had over 500 videos)
> >>>
> >>>
> >>> Maybe ffmpeg command is a bit different for other versions.
> >>>
> >>> Greetings Peter
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>
> >
>
>


-- 
WBR
Maxim aka solomax

Re: new version and mysql-connector

Posted by Maxim Solodovnik <so...@gmail.com>.
It is perfectly fine to ask something from someone using user@ mailing-list

But you wrote: "Maxim please ask Alvaro" .... :))))

On Fri, 12 Jul 2019 at 11:28, Denis Noctor <de...@gmail.com> wrote:
>
> :) ... sorry Maxim... I was following protocol by emailing the user group :) Will email him directly tomorrow.
>
> Would be happy to pitch in by updating the manuals in English. Will be away for a week and will look into it then.
>
> Sent from my iPhone
>
> > On Jul 11, 2019, at 10:41 PM, Maxim Solodovnik <so...@gmail.com> wrote:
> >
> > I believe Alvaro can answer for himself :)))
> > It would be too expensive for me to go Spain right now :)
> >
> >> On Fri, 12 Jul 2019 at 10:33, Denis Noctor <de...@gmail.com> wrote:
> >>
> >> Hi there Maxim,
> >>
> >> Let me know if Alvaro would like me to review any of the installation PDFs in English as a token of my appreciation.
> >>
> >> All the best,
> >>
> >> Denis.
> >>
> >> Sent from my iPhone
> >>
> >>> On Jul 11, 2019, at 10:19 PM, Maxim Solodovnik <so...@gmail.com> wrote:
> >>>
> >>> M2 will be released next week (hopefully :))
> >>> MySql driver is not bundled, so it can't be hardcoded :)
> >>> Works here as expected :)
> >>>
> >>> I haven't tested OM with java12, Thanks for the feedback!
> >>>
> >>> On Fri, 12 Jul 2019 at 00:08, Juan Antonio Moreno Carmona
> >>> <ja...@gmail.com> wrote:
> >>>>
> >>>> Hi
> >>>>
> >>>> I have installed M2 downloaded three days ago (buildtime
> >>>> 2019-07-08T17:16:31Z) and I can confirm that jdk-openjdk 12 and
> >>>> mysql-connector-java-8.0.16.jar works well together.
> >>>>
> >>>>> El 11/7/19 a las 18:52, Stefan Kühl escribió:
> >>>>>
> >>>>> Hey all,
> >>>>>
> >>>>> I'm going to run a new installation and wonder if I should wait for M2
> >>>>> or not?
> >>>>> Another question: Will mysql-connector-java-8.0.16.jar (out since
> >>>>> march) also work or is 8.0.16 hardcoded anywhere?
> >>>>>
> >>>>> Greetz
> >>>>>
> >>>>> Stefan
> >>>>>
> >>>
> >>>
> >>>
> >>> --
> >>> WBR
> >>> Maxim aka solomax
> >
> >
> >
> > --
> > WBR
> > Maxim aka solomax



-- 
WBR
Maxim aka solomax

Re: new version and mysql-connector

Posted by Denis Noctor <de...@gmail.com>.
:) ... sorry Maxim... I was following protocol by emailing the user group :) Will email him directly tomorrow.

Would be happy to pitch in by updating the manuals in English. Will be away for a week and will look into it then.

Sent from my iPhone

> On Jul 11, 2019, at 10:41 PM, Maxim Solodovnik <so...@gmail.com> wrote:
> 
> I believe Alvaro can answer for himself :)))
> It would be too expensive for me to go Spain right now :)
> 
>> On Fri, 12 Jul 2019 at 10:33, Denis Noctor <de...@gmail.com> wrote:
>> 
>> Hi there Maxim,
>> 
>> Let me know if Alvaro would like me to review any of the installation PDFs in English as a token of my appreciation.
>> 
>> All the best,
>> 
>> Denis.
>> 
>> Sent from my iPhone
>> 
>>> On Jul 11, 2019, at 10:19 PM, Maxim Solodovnik <so...@gmail.com> wrote:
>>> 
>>> M2 will be released next week (hopefully :))
>>> MySql driver is not bundled, so it can't be hardcoded :)
>>> Works here as expected :)
>>> 
>>> I haven't tested OM with java12, Thanks for the feedback!
>>> 
>>> On Fri, 12 Jul 2019 at 00:08, Juan Antonio Moreno Carmona
>>> <ja...@gmail.com> wrote:
>>>> 
>>>> Hi
>>>> 
>>>> I have installed M2 downloaded three days ago (buildtime
>>>> 2019-07-08T17:16:31Z) and I can confirm that jdk-openjdk 12 and
>>>> mysql-connector-java-8.0.16.jar works well together.
>>>> 
>>>>> El 11/7/19 a las 18:52, Stefan Kühl escribió:
>>>>> 
>>>>> Hey all,
>>>>> 
>>>>> I'm going to run a new installation and wonder if I should wait for M2
>>>>> or not?
>>>>> Another question: Will mysql-connector-java-8.0.16.jar (out since
>>>>> march) also work or is 8.0.16 hardcoded anywhere?
>>>>> 
>>>>> Greetz
>>>>> 
>>>>> Stefan
>>>>> 
>>> 
>>> 
>>> 
>>> --
>>> WBR
>>> Maxim aka solomax
> 
> 
> 
> -- 
> WBR
> Maxim aka solomax

Re: new version and mysql-connector

Posted by Maxim Solodovnik <so...@gmail.com>.
I believe Alvaro can answer for himself :)))
It would be too expensive for me to go Spain right now :)

On Fri, 12 Jul 2019 at 10:33, Denis Noctor <de...@gmail.com> wrote:
>
> Hi there Maxim,
>
> Let me know if Alvaro would like me to review any of the installation PDFs in English as a token of my appreciation.
>
> All the best,
>
> Denis.
>
> Sent from my iPhone
>
> > On Jul 11, 2019, at 10:19 PM, Maxim Solodovnik <so...@gmail.com> wrote:
> >
> > M2 will be released next week (hopefully :))
> > MySql driver is not bundled, so it can't be hardcoded :)
> > Works here as expected :)
> >
> > I haven't tested OM with java12, Thanks for the feedback!
> >
> > On Fri, 12 Jul 2019 at 00:08, Juan Antonio Moreno Carmona
> > <ja...@gmail.com> wrote:
> >>
> >> Hi
> >>
> >> I have installed M2 downloaded three days ago (buildtime
> >> 2019-07-08T17:16:31Z) and I can confirm that jdk-openjdk 12 and
> >> mysql-connector-java-8.0.16.jar works well together.
> >>
> >>> El 11/7/19 a las 18:52, Stefan Kühl escribió:
> >>>
> >>> Hey all,
> >>>
> >>> I'm going to run a new installation and wonder if I should wait for M2
> >>> or not?
> >>> Another question: Will mysql-connector-java-8.0.16.jar (out since
> >>> march) also work or is 8.0.16 hardcoded anywhere?
> >>>
> >>> Greetz
> >>>
> >>> Stefan
> >>>
> >
> >
> >
> > --
> > WBR
> > Maxim aka solomax



-- 
WBR
Maxim aka solomax

Re: new version and mysql-connector

Posted by Denis Noctor <de...@gmail.com>.
Hi there Maxim,

Let me know if Alvaro would like me to review any of the installation PDFs in English as a token of my appreciation.

All the best,

Denis.

Sent from my iPhone

> On Jul 11, 2019, at 10:19 PM, Maxim Solodovnik <so...@gmail.com> wrote:
> 
> M2 will be released next week (hopefully :))
> MySql driver is not bundled, so it can't be hardcoded :)
> Works here as expected :)
> 
> I haven't tested OM with java12, Thanks for the feedback!
> 
> On Fri, 12 Jul 2019 at 00:08, Juan Antonio Moreno Carmona
> <ja...@gmail.com> wrote:
>> 
>> Hi
>> 
>> I have installed M2 downloaded three days ago (buildtime
>> 2019-07-08T17:16:31Z) and I can confirm that jdk-openjdk 12 and
>> mysql-connector-java-8.0.16.jar works well together.
>> 
>>> El 11/7/19 a las 18:52, Stefan Kühl escribió:
>>> 
>>> Hey all,
>>> 
>>> I'm going to run a new installation and wonder if I should wait for M2
>>> or not?
>>> Another question: Will mysql-connector-java-8.0.16.jar (out since
>>> march) also work or is 8.0.16 hardcoded anywhere?
>>> 
>>> Greetz
>>> 
>>> Stefan
>>> 
> 
> 
> 
> -- 
> WBR
> Maxim aka solomax

Re: new version and mysql-connector

Posted by Maxim Solodovnik <so...@gmail.com>.
M2 will be released next week (hopefully :))
MySql driver is not bundled, so it can't be hardcoded :)
Works here as expected :)

I haven't tested OM with java12, Thanks for the feedback!

On Fri, 12 Jul 2019 at 00:08, Juan Antonio Moreno Carmona
<ja...@gmail.com> wrote:
>
> Hi
>
> I have installed M2 downloaded three days ago (buildtime
> 2019-07-08T17:16:31Z) and I can confirm that jdk-openjdk 12 and
> mysql-connector-java-8.0.16.jar works well together.
>
> El 11/7/19 a las 18:52, Stefan Kühl escribió:
> >
> > Hey all,
> >
> > I'm going to run a new installation and wonder if I should wait for M2
> > or not?
> > Another question: Will mysql-connector-java-8.0.16.jar (out since
> > march) also work or is 8.0.16 hardcoded anywhere?
> >
> > Greetz
> >
> > Stefan
> >



-- 
WBR
Maxim aka solomax

Re: new version and mysql-connector

Posted by Juan Antonio Moreno Carmona <ja...@gmail.com>.
Hi

I have installed M2 downloaded three days ago (buildtime 
2019-07-08T17:16:31Z) and I can confirm that jdk-openjdk 12 and 
mysql-connector-java-8.0.16.jar works well together.

El 11/7/19 a las 18:52, Stefan Kühl escribió:
>
> Hey all,
>
> I'm going to run a new installation and wonder if I should wait for M2 
> or not?
> Another question: Will mysql-connector-java-8.0.16.jar (out since 
> march) also work or is 8.0.16 hardcoded anywhere?
>
> Greetz
>
> Stefan
>

Re: conversion problem during update

Posted by Maxim Solodovnik <so...@gmail.com>.
https://issues.apache.org/jira/browse/OPENMEETINGS-2089

On Tue, 16 Jul 2019 at 14:17, Maxim Solodovnik <so...@gmail.com> wrote:
>
> Thanks for checking!
>
> It seems this parameter is safe to add
> Will do ASAP
>
> Can someone file JIRA?
>
> On Tue, 16 Jul 2019 at 13:56, Xavier M <xa...@hotmail.com> wrote:
> >
> > Hello,
> >
> > Yes, it works fine with:
> > cd (Directory where the file to be converted is)
> > convert -density 125 OpenMeet.pdf +profile '*' -quality 100 page-%04d.png
> > (where OpenMeet.pdf is the name of the file to be converted).
> >
> > Nota Bene : transparency is active in the results (the .png files) : when the background of the PDF-file is white, it becomes transparent in the PNG-files.
> >
> > Xavier
> >
> > ________________________________
> > De : Maxim Solodovnik <so...@gmail.com>
> > Envoyé : lundi 15 juillet 2019 13:48
> > À : Openmeetings user-list
> > Objet : Re: conversion problem during update
> >
> > even better if it will be "+profile '*'" (typo in `profile` is also fixed)
> >
> > On Mon, 15 Jul 2019 at 16:17, Maxim Solodovnik <so...@gmail.com> wrote:
> > >
> > > This string "+ profil '*'"
> > > Should be "+profil '*'" (no space)
> > >
> > > On Mon, 15 Jul 2019 at 16:11, Xavier M <xa...@hotmail.com> wrote:
> > > >
> > > > Hi all,
> > > >
> > > > I just tested the command lines with a Mac... There must be a mistake somewhere, but it is quite encouraging.
> > > >
> > > >  * I used a copy of the tutorial of OpenMeetings Installation by Alvaro (16 pages), and put it into a directory "Test". I renamed it OpenMeet.pdf to (preventively) avoid some undesirable effects of spaces or long names.
> > > >  * I launched a console and cd into this directory.
> > > >  * I typed following command:
> > > > convert -density 125 OpenMeet.pdf + profil '*' -quality 100 page-%04d.png
> > > >   * I got following errors:
> > > > convert: unable to open image '+': No such file or directory @ error/blob.c/OpenBlob/3485.
> > > > convert: no decode delegate for this image format `' @ error/constitute.c/ReadImage/556.
> > > > convert: unable to open image 'profil': No such file or directory @ error/blob.c/OpenBlob/3485.
> > > > convert: unable to open image 'profil': No such file or directory @ error/blob.c/OpenBlob/3485.
> > > > convert: no decode delegate for this image format `' @ error/constitute.c/ReadImage/556.
> > > >  * BUT I've got now 32 new png-files, numerotated 0000 to 0035. The files page-0000.png and page-0015.png correspond to the first page of the PDF file.
> > > >
> > > > --> I guess that ImageMagick works, but that there is some problem with the options in the command lines.
> > > >
> > > > Hope this helps...
> > > > Xavier
> > > >
> > > > ________________________________
> > > > De : Maxim Solodovnik <so...@gmail.com>
> > > > Envoyé : jeudi 11 juillet 2019 09:44
> > > > À : Openmeetings user-list
> > > > Objet : Re: conversion problem during update
> > > >
> > > > the page seems to correct
> > > >
> > > > On Thu, 11 Jul 2019 at 14:42, Xavier M <xa...@hotmail.com> wrote:
> > > > >
> > > > > Just to check for step 1, due to the way it is written: do I follow the instructions here?
> > > > > https://imagemagick.org/script/download.php#macosx
> > > > >
> > > > >
> > > > >
> > > > > ________________________________
> > > > > De : Maxim Solodovnik <so...@gmail.com>
> > > > > Envoyé : jeudi 11 juillet 2019 09:33
> > > > > À : Openmeetings user-list
> > > > > Objet : Re: conversion problem during update
> > > > >
> > > > > Steps:
> > > > > 1) Install ImageMagic
> > > > > 2) create empty folder, cd into this folder, put any PDF file to it
> > > > > Using terminal/console app
> > > > > 3) run
> > > > > `PATH_TO_IMAGIC_BIN/convert -density 125 NAME_OF_PDF.pdf +profile
> > > > > '*' -quality 100 page-%04d.png`
> > > > >
> > > > > should be no errors
> > > > > (NOTE PDF conversion might be blocked in ImageMagic policy.xml file)
> > > > >
> > > > > On Thu, 11 Jul 2019 at 14:29, Xavier M <xa...@hotmail.com> wrote:
> > > > > >
> > > > > > Hi,
> > > > > >
> > > > > > I'm a Mac user at work - be aware that it is not a server on the web. I do not fully understand the point, but if you detail me the steps, I can maybe help? I'll find time to do on Monday or Tuesday.
> > > > > >
> > > > > > Xavier
> > > > > >
> > > > > > ________________________________
> > > > > > De : Peter Dähn <da...@vcrp.de>
> > > > > > Envoyé : jeudi 11 juillet 2019 09:13
> > > > > > À : user@openmeetings.apache.org
> > > > > > Objet : Re: conversion problem during update
> > > > > >
> > > > > > I will ask MAC user around here...
> > > > > >
> > > > > > Am 11.07.19 um 08:32 schrieb Maxim Solodovnik:
> > > > > > > I can test it on Windows
> > > > > > > Not on Mac :(
> > > > > > >
> > > > > > > should be easy:
> > > > > > > 1) install ImageMagic
> > > > > > > 2) run command
> > > > > > > 3) report back :)
> > > > > > >
> > > > > > > Are there any volunteers?
> > > > > > >
> > > > > > > On Thu, 11 Jul 2019 at 13:29, Peter Dähn <da...@vcrp.de> wrote:
> > > > > > >> you are right... I simply try to keep it in mind... Maybe updates to
> > > > > > >> 5.0.x will be done by moving to a new server. I think complete migration
> > > > > > >> with conversion etc. will to be tested by more admins... ;-)
> > > > > > >>
> > > > > > >> Greetings Peter
> > > > > > >>
> > > > > > >> Am 11.07.19 um 08:17 schrieb Maxim Solodovnik:
> > > > > > >>> Actually this is "one minute task" BUT
> > > > > > >>> Someone need to test it using Win and Mac (I guess it will work on Linux)
> > > > > > >>>
> > > > > > >>> On Thu, 11 Jul 2019 at 13:15, Peter Dähn <da...@vcrp.de> wrote:
> > > > > > >>>> Hi Maxim,
> > > > > > >>>>
> > > > > > >>>> seems to be. Does it hurt to add that parameter anyway?
> > > > > > >>>>
> > > > > > >>>> Greetigs Peter
> > > > > > >>>>
> > > > > > >>>> Am 11.07.19 um 07:17 schrieb Maxim Solodovnik:
> > > > > > >>>>> No answers for a long time
> > > > > > >>>>> I guess this one is not a common problem
> > > > > > >>>>>
> > > > > > >>>>> On Mon, 3 Jun 2019 at 13:44, Peter Dähn <da...@vcrp.de> wrote:
> > > > > > >>>>>> Hi Maxim,
> > > > > > >>>>>>
> > > > > > >>>>>> you are right, to add this would help, if it is a common problem.
> > > > > > >>>>>>
> > > > > > >>>>>> This is a really old file. It seems that it was already a pdf-file.
> > > > > > >>>>>> Original content of the folder was
> > > > > > >>>>>>
> > > > > > >>>>>> HASH.pdf, HASH.swf, library.xml and for each page of the pdf a
> > > > > > >>>>>> _thumb_page-XXXX.jpg.
> > > > > > >>>>>>
> > > > > > >>>>>> Greetings Peter
> > > > > > >>>>>>
> > > > > > >>>>>> Am 31.05.19 um 18:39 schrieb Maxim Solodovnik:
> > > > > > >>>>>>> Hello Peter,
> > > > > > >>>>>>>
> > > > > > >>>>>>> I guess you propose to add "profile" param to OM code :)
> > > > > > >>>>>>> I'm OK with it, could you check if your original document is being
> > > > > > >>>>>>> converted by OM UI as expected or not?
> > > > > > >>>>>>>
> > > > > > >>>>>>> On Fri, 31 May 2019 at 20:03, Peter Dähn <da...@vcrp.de> wrote:
> > > > > > >>>>>>>> Hi Maxim,
> > > > > > >>>>>>>>
> > > > > > >>>>>>>> I needed to convert some room files afterwards. I user command out of
> > > > > > >>>>>>>> the logs and got for some files an error.
> > > > > > >>>>>>>>
> > > > > > >>>>>>>> /usr/bin/convert -density 125
> > > > > > >>>>>>>> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf -quality
> > > > > > >>>>>>>> 100 /SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
> > > > > > >>>>>>>>
> > > > > > >>>>>>>> convert: profile 'icc': 'RGB ': RGB color space not permitted on
> > > > > > >>>>>>>> grayscale PNG
> > > > > > >>>>>>>> `/SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png' @
> > > > > > >>>>>>>> warning/png.c/MagickPNGWarningHandler/1654.
> > > > > > >>>>>>>>
> > > > > > >>>>>>>> I needed to add parameter +profile '*' . Now convert is working without
> > > > > > >>>>>>>> error.
> > > > > > >>>>>>>>
> > > > > > >>>>>>>> /usr/bin/convert -density 125
> > > > > > >>>>>>>> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf +profile
> > > > > > >>>>>>>> '*' -quality 100
> > > > > > >>>>>>>> /usr/lib/red5/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
> > > > > > >>>>>>>>
> > > > > > >>>>>>>> Greetings Peter
> > > > > > >>>>>>>>
> > > > > > >>>>>>>> Am 15.05.19 um 13:15 schrieb Peter Dähn:
> > > > > > >>>>>>>>> Hi,
> > > > > > >>>>>>>>>
> > > > > > >>>>>>>>> I had a little problem during the last update (from 3.0.7 to 4.0.8). I
> > > > > > >>>>>>>>> didn't realise, that ffmpeg didn't work after server update. The
> > > > > > >>>>>>>>> following om update went throug, despite the fact, that
> > > > > > >>>>>>>>> screen-recordings were not converted.
> > > > > > >>>>>>>>>
> > > > > > >>>>>>>>> That why I needed to figure out (with a little bit help of Maxim) how to
> > > > > > >>>>>>>>> manage that afterwards. I would like to share my steps, in case someone
> > > > > > >>>>>>>>> has a similar problem.
> > > > > > >>>>>>>>>
> > > > > > >>>>>>>>> 1. Get needed information from database (in my case it is postgres)
> > > > > > >>>>>>>>>
> > > > > > >>>>>>>>>  select id,hash from om_file where deleted=false and type='Recording'
> > > > > > >>>>>>>>> and dtype='Recording' order by id;
> > > > > > >>>>>>>>>
> > > > > > >>>>>>>>> 2. save the result in a text file e.g. convert_recordings.txt
> > > > > > >>>>>>>>>
> > > > > > >>>>>>>>> 3. prepare a little script (linux/bash)
> > > > > > >>>>>>>>>
> > > > > > >>>>>>>>> #!/bin/bash
> > > > > > >>>>>>>>> i=0
> > > > > > >>>>>>>>> while read line
> > > > > > >>>>>>>>> do
> > > > > > >>>>>>>>>    #echo "$line"
> > > > > > >>>>>>>>>    id=`echo $line | awk '{split($0, a, "|"); print a[1]}'`
> > > > > > >>>>>>>>>    #echo $id
> > > > > > >>>>>>>>>    hash=`echo $line | awk '{split($0, a, "|"); print a[2]}'`
> > > > > > >>>>>>>>>    #echo $hash
> > > > > > >>>>>>>>> #   echo "bearbeite $id"
> > > > > > >>>>>>>>>    command_mp4="/usr/local/bin/ffmpeg -y -nostdin -i
> > > > > > >>>>>>>>> /OM_OLD_DIR/webapps/openmeetings/data/streams/hibernate/flvRecording_$id.avi
> > > > > > >>>>>>>>> -c:v h264 -crf 24 -pix_fmt yuv420p -preset medium -profile:v baseline
> > > > > > >>>>>>>>> -level 3.0 -movflags faststart -c:a aac -ar 22050 -b:a 32k
> > > > > > >>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4"
> > > > > > >>>>>>>>> #   echo $command_mp4
> > > > > > >>>>>>>>>    command_png="/usr/local/bin/ffmpeg -y -nostdin -i
> > > > > > >>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4 -vf
> > > > > > >>>>>>>>> thumbnail,scale=640:-1 -frames:v 1
> > > > > > >>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.png"
> > > > > > >>>>>>>>> #   echo $command_png
> > > > > > >>>>>>>>>    $command_mp4
> > > > > > >>>>>>>>>    $command_png
> > > > > > >>>>>>>>> done < convert_recordings.txt
> > > > > > >>>>>>>>>
> > > > > > >>>>>>>>> 4. wait a looooong time (I had over 500 videos)
> > > > > > >>>>>>>>>
> > > > > > >>>>>>>>>
> > > > > > >>>>>>>>> Maybe ffmpeg command is a bit different for other versions.
> > > > > > >>>>>>>>>
> > > > > > >>>>>>>>> Greetings Peter
> > > > > > >>>>>>>>>
> > > > > > >>>>>>>>>
> > > > > > >>>>>>>>>
> > > > > > >>>>>>>>>
> > > > > > >>>>>>>>>
> > > > > > >>>>>>>>>
> > > > > > >>
> > > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > --
> > > > > 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: conversion problem during update

Posted by Maxim Solodovnik <so...@gmail.com>.
Thanks for checking!

It seems this parameter is safe to add
Will do ASAP

Can someone file JIRA?

On Tue, 16 Jul 2019 at 13:56, Xavier M <xa...@hotmail.com> wrote:
>
> Hello,
>
> Yes, it works fine with:
> cd (Directory where the file to be converted is)
> convert -density 125 OpenMeet.pdf +profile '*' -quality 100 page-%04d.png
> (where OpenMeet.pdf is the name of the file to be converted).
>
> Nota Bene : transparency is active in the results (the .png files) : when the background of the PDF-file is white, it becomes transparent in the PNG-files.
>
> Xavier
>
> ________________________________
> De : Maxim Solodovnik <so...@gmail.com>
> Envoyé : lundi 15 juillet 2019 13:48
> À : Openmeetings user-list
> Objet : Re: conversion problem during update
>
> even better if it will be "+profile '*'" (typo in `profile` is also fixed)
>
> On Mon, 15 Jul 2019 at 16:17, Maxim Solodovnik <so...@gmail.com> wrote:
> >
> > This string "+ profil '*'"
> > Should be "+profil '*'" (no space)
> >
> > On Mon, 15 Jul 2019 at 16:11, Xavier M <xa...@hotmail.com> wrote:
> > >
> > > Hi all,
> > >
> > > I just tested the command lines with a Mac... There must be a mistake somewhere, but it is quite encouraging.
> > >
> > >  * I used a copy of the tutorial of OpenMeetings Installation by Alvaro (16 pages), and put it into a directory "Test". I renamed it OpenMeet.pdf to (preventively) avoid some undesirable effects of spaces or long names.
> > >  * I launched a console and cd into this directory.
> > >  * I typed following command:
> > > convert -density 125 OpenMeet.pdf + profil '*' -quality 100 page-%04d.png
> > >   * I got following errors:
> > > convert: unable to open image '+': No such file or directory @ error/blob.c/OpenBlob/3485.
> > > convert: no decode delegate for this image format `' @ error/constitute.c/ReadImage/556.
> > > convert: unable to open image 'profil': No such file or directory @ error/blob.c/OpenBlob/3485.
> > > convert: unable to open image 'profil': No such file or directory @ error/blob.c/OpenBlob/3485.
> > > convert: no decode delegate for this image format `' @ error/constitute.c/ReadImage/556.
> > >  * BUT I've got now 32 new png-files, numerotated 0000 to 0035. The files page-0000.png and page-0015.png correspond to the first page of the PDF file.
> > >
> > > --> I guess that ImageMagick works, but that there is some problem with the options in the command lines.
> > >
> > > Hope this helps...
> > > Xavier
> > >
> > > ________________________________
> > > De : Maxim Solodovnik <so...@gmail.com>
> > > Envoyé : jeudi 11 juillet 2019 09:44
> > > À : Openmeetings user-list
> > > Objet : Re: conversion problem during update
> > >
> > > the page seems to correct
> > >
> > > On Thu, 11 Jul 2019 at 14:42, Xavier M <xa...@hotmail.com> wrote:
> > > >
> > > > Just to check for step 1, due to the way it is written: do I follow the instructions here?
> > > > https://imagemagick.org/script/download.php#macosx
> > > >
> > > >
> > > >
> > > > ________________________________
> > > > De : Maxim Solodovnik <so...@gmail.com>
> > > > Envoyé : jeudi 11 juillet 2019 09:33
> > > > À : Openmeetings user-list
> > > > Objet : Re: conversion problem during update
> > > >
> > > > Steps:
> > > > 1) Install ImageMagic
> > > > 2) create empty folder, cd into this folder, put any PDF file to it
> > > > Using terminal/console app
> > > > 3) run
> > > > `PATH_TO_IMAGIC_BIN/convert -density 125 NAME_OF_PDF.pdf +profile
> > > > '*' -quality 100 page-%04d.png`
> > > >
> > > > should be no errors
> > > > (NOTE PDF conversion might be blocked in ImageMagic policy.xml file)
> > > >
> > > > On Thu, 11 Jul 2019 at 14:29, Xavier M <xa...@hotmail.com> wrote:
> > > > >
> > > > > Hi,
> > > > >
> > > > > I'm a Mac user at work - be aware that it is not a server on the web. I do not fully understand the point, but if you detail me the steps, I can maybe help? I'll find time to do on Monday or Tuesday.
> > > > >
> > > > > Xavier
> > > > >
> > > > > ________________________________
> > > > > De : Peter Dähn <da...@vcrp.de>
> > > > > Envoyé : jeudi 11 juillet 2019 09:13
> > > > > À : user@openmeetings.apache.org
> > > > > Objet : Re: conversion problem during update
> > > > >
> > > > > I will ask MAC user around here...
> > > > >
> > > > > Am 11.07.19 um 08:32 schrieb Maxim Solodovnik:
> > > > > > I can test it on Windows
> > > > > > Not on Mac :(
> > > > > >
> > > > > > should be easy:
> > > > > > 1) install ImageMagic
> > > > > > 2) run command
> > > > > > 3) report back :)
> > > > > >
> > > > > > Are there any volunteers?
> > > > > >
> > > > > > On Thu, 11 Jul 2019 at 13:29, Peter Dähn <da...@vcrp.de> wrote:
> > > > > >> you are right... I simply try to keep it in mind... Maybe updates to
> > > > > >> 5.0.x will be done by moving to a new server. I think complete migration
> > > > > >> with conversion etc. will to be tested by more admins... ;-)
> > > > > >>
> > > > > >> Greetings Peter
> > > > > >>
> > > > > >> Am 11.07.19 um 08:17 schrieb Maxim Solodovnik:
> > > > > >>> Actually this is "one minute task" BUT
> > > > > >>> Someone need to test it using Win and Mac (I guess it will work on Linux)
> > > > > >>>
> > > > > >>> On Thu, 11 Jul 2019 at 13:15, Peter Dähn <da...@vcrp.de> wrote:
> > > > > >>>> Hi Maxim,
> > > > > >>>>
> > > > > >>>> seems to be. Does it hurt to add that parameter anyway?
> > > > > >>>>
> > > > > >>>> Greetigs Peter
> > > > > >>>>
> > > > > >>>> Am 11.07.19 um 07:17 schrieb Maxim Solodovnik:
> > > > > >>>>> No answers for a long time
> > > > > >>>>> I guess this one is not a common problem
> > > > > >>>>>
> > > > > >>>>> On Mon, 3 Jun 2019 at 13:44, Peter Dähn <da...@vcrp.de> wrote:
> > > > > >>>>>> Hi Maxim,
> > > > > >>>>>>
> > > > > >>>>>> you are right, to add this would help, if it is a common problem.
> > > > > >>>>>>
> > > > > >>>>>> This is a really old file. It seems that it was already a pdf-file.
> > > > > >>>>>> Original content of the folder was
> > > > > >>>>>>
> > > > > >>>>>> HASH.pdf, HASH.swf, library.xml and for each page of the pdf a
> > > > > >>>>>> _thumb_page-XXXX.jpg.
> > > > > >>>>>>
> > > > > >>>>>> Greetings Peter
> > > > > >>>>>>
> > > > > >>>>>> Am 31.05.19 um 18:39 schrieb Maxim Solodovnik:
> > > > > >>>>>>> Hello Peter,
> > > > > >>>>>>>
> > > > > >>>>>>> I guess you propose to add "profile" param to OM code :)
> > > > > >>>>>>> I'm OK with it, could you check if your original document is being
> > > > > >>>>>>> converted by OM UI as expected or not?
> > > > > >>>>>>>
> > > > > >>>>>>> On Fri, 31 May 2019 at 20:03, Peter Dähn <da...@vcrp.de> wrote:
> > > > > >>>>>>>> Hi Maxim,
> > > > > >>>>>>>>
> > > > > >>>>>>>> I needed to convert some room files afterwards. I user command out of
> > > > > >>>>>>>> the logs and got for some files an error.
> > > > > >>>>>>>>
> > > > > >>>>>>>> /usr/bin/convert -density 125
> > > > > >>>>>>>> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf -quality
> > > > > >>>>>>>> 100 /SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
> > > > > >>>>>>>>
> > > > > >>>>>>>> convert: profile 'icc': 'RGB ': RGB color space not permitted on
> > > > > >>>>>>>> grayscale PNG
> > > > > >>>>>>>> `/SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png' @
> > > > > >>>>>>>> warning/png.c/MagickPNGWarningHandler/1654.
> > > > > >>>>>>>>
> > > > > >>>>>>>> I needed to add parameter +profile '*' . Now convert is working without
> > > > > >>>>>>>> error.
> > > > > >>>>>>>>
> > > > > >>>>>>>> /usr/bin/convert -density 125
> > > > > >>>>>>>> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf +profile
> > > > > >>>>>>>> '*' -quality 100
> > > > > >>>>>>>> /usr/lib/red5/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
> > > > > >>>>>>>>
> > > > > >>>>>>>> Greetings Peter
> > > > > >>>>>>>>
> > > > > >>>>>>>> Am 15.05.19 um 13:15 schrieb Peter Dähn:
> > > > > >>>>>>>>> Hi,
> > > > > >>>>>>>>>
> > > > > >>>>>>>>> I had a little problem during the last update (from 3.0.7 to 4.0.8). I
> > > > > >>>>>>>>> didn't realise, that ffmpeg didn't work after server update. The
> > > > > >>>>>>>>> following om update went throug, despite the fact, that
> > > > > >>>>>>>>> screen-recordings were not converted.
> > > > > >>>>>>>>>
> > > > > >>>>>>>>> That why I needed to figure out (with a little bit help of Maxim) how to
> > > > > >>>>>>>>> manage that afterwards. I would like to share my steps, in case someone
> > > > > >>>>>>>>> has a similar problem.
> > > > > >>>>>>>>>
> > > > > >>>>>>>>> 1. Get needed information from database (in my case it is postgres)
> > > > > >>>>>>>>>
> > > > > >>>>>>>>>  select id,hash from om_file where deleted=false and type='Recording'
> > > > > >>>>>>>>> and dtype='Recording' order by id;
> > > > > >>>>>>>>>
> > > > > >>>>>>>>> 2. save the result in a text file e.g. convert_recordings.txt
> > > > > >>>>>>>>>
> > > > > >>>>>>>>> 3. prepare a little script (linux/bash)
> > > > > >>>>>>>>>
> > > > > >>>>>>>>> #!/bin/bash
> > > > > >>>>>>>>> i=0
> > > > > >>>>>>>>> while read line
> > > > > >>>>>>>>> do
> > > > > >>>>>>>>>    #echo "$line"
> > > > > >>>>>>>>>    id=`echo $line | awk '{split($0, a, "|"); print a[1]}'`
> > > > > >>>>>>>>>    #echo $id
> > > > > >>>>>>>>>    hash=`echo $line | awk '{split($0, a, "|"); print a[2]}'`
> > > > > >>>>>>>>>    #echo $hash
> > > > > >>>>>>>>> #   echo "bearbeite $id"
> > > > > >>>>>>>>>    command_mp4="/usr/local/bin/ffmpeg -y -nostdin -i
> > > > > >>>>>>>>> /OM_OLD_DIR/webapps/openmeetings/data/streams/hibernate/flvRecording_$id.avi
> > > > > >>>>>>>>> -c:v h264 -crf 24 -pix_fmt yuv420p -preset medium -profile:v baseline
> > > > > >>>>>>>>> -level 3.0 -movflags faststart -c:a aac -ar 22050 -b:a 32k
> > > > > >>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4"
> > > > > >>>>>>>>> #   echo $command_mp4
> > > > > >>>>>>>>>    command_png="/usr/local/bin/ffmpeg -y -nostdin -i
> > > > > >>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4 -vf
> > > > > >>>>>>>>> thumbnail,scale=640:-1 -frames:v 1
> > > > > >>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.png"
> > > > > >>>>>>>>> #   echo $command_png
> > > > > >>>>>>>>>    $command_mp4
> > > > > >>>>>>>>>    $command_png
> > > > > >>>>>>>>> done < convert_recordings.txt
> > > > > >>>>>>>>>
> > > > > >>>>>>>>> 4. wait a looooong time (I had over 500 videos)
> > > > > >>>>>>>>>
> > > > > >>>>>>>>>
> > > > > >>>>>>>>> Maybe ffmpeg command is a bit different for other versions.
> > > > > >>>>>>>>>
> > > > > >>>>>>>>> Greetings Peter
> > > > > >>>>>>>>>
> > > > > >>>>>>>>>
> > > > > >>>>>>>>>
> > > > > >>>>>>>>>
> > > > > >>>>>>>>>
> > > > > >>>>>>>>>
> > > > > >>
> > > > > >
> > > > >
> > > >
> > > >
> > > > --
> > > > WBR
> > > > Maxim aka solomax
> > >
> > >
> > >
> > > --
> > > WBR
> > > Maxim aka solomax
> >
> >
> >
> > --
> > WBR
> > Maxim aka solomax
>
>
>
> --
> WBR
> Maxim aka solomax



-- 
WBR
Maxim aka solomax

RE: conversion problem during update

Posted by Xavier M <xa...@hotmail.com>.
Hello,

Yes, it works fine with:
cd (Directory where the file to be converted is)
convert -density 125 OpenMeet.pdf +profile '*' -quality 100 page-%04d.png
(where OpenMeet.pdf is the name of the file to be converted).

Nota Bene : transparency is active in the results (the .png files) : when the background of the PDF-file is white, it becomes transparent in the PNG-files.

Xavier

________________________________
De : Maxim Solodovnik <so...@gmail.com>
Envoyé : lundi 15 juillet 2019 13:48
À : Openmeetings user-list
Objet : Re: conversion problem during update

even better if it will be "+profile '*'" (typo in `profile` is also fixed)

On Mon, 15 Jul 2019 at 16:17, Maxim Solodovnik <so...@gmail.com> wrote:
>
> This string "+ profil '*'"
> Should be "+profil '*'" (no space)
>
> On Mon, 15 Jul 2019 at 16:11, Xavier M <xa...@hotmail.com> wrote:
> >
> > Hi all,
> >
> > I just tested the command lines with a Mac... There must be a mistake somewhere, but it is quite encouraging.
> >
> >  * I used a copy of the tutorial of OpenMeetings Installation by Alvaro (16 pages), and put it into a directory "Test". I renamed it OpenMeet.pdf to (preventively) avoid some undesirable effects of spaces or long names.
> >  * I launched a console and cd into this directory.
> >  * I typed following command:
> > convert -density 125 OpenMeet.pdf + profil '*' -quality 100 page-%04d.png
> >   * I got following errors:
> > convert: unable to open image '+': No such file or directory @ error/blob.c/OpenBlob/3485.
> > convert: no decode delegate for this image format `' @ error/constitute.c/ReadImage/556.
> > convert: unable to open image 'profil': No such file or directory @ error/blob.c/OpenBlob/3485.
> > convert: unable to open image 'profil': No such file or directory @ error/blob.c/OpenBlob/3485.
> > convert: no decode delegate for this image format `' @ error/constitute.c/ReadImage/556.
> >  * BUT I've got now 32 new png-files, numerotated 0000 to 0035. The files page-0000.png and page-0015.png correspond to the first page of the PDF file.
> >
> > --> I guess that ImageMagick works, but that there is some problem with the options in the command lines.
> >
> > Hope this helps...
> > Xavier
> >
> > ________________________________
> > De : Maxim Solodovnik <so...@gmail.com>
> > Envoyé : jeudi 11 juillet 2019 09:44
> > À : Openmeetings user-list
> > Objet : Re: conversion problem during update
> >
> > the page seems to correct
> >
> > On Thu, 11 Jul 2019 at 14:42, Xavier M <xa...@hotmail.com> wrote:
> > >
> > > Just to check for step 1, due to the way it is written: do I follow the instructions here?
> > > https://imagemagick.org/script/download.php#macosx
> > >
> > >
> > >
> > > ________________________________
> > > De : Maxim Solodovnik <so...@gmail.com>
> > > Envoyé : jeudi 11 juillet 2019 09:33
> > > À : Openmeetings user-list
> > > Objet : Re: conversion problem during update
> > >
> > > Steps:
> > > 1) Install ImageMagic
> > > 2) create empty folder, cd into this folder, put any PDF file to it
> > > Using terminal/console app
> > > 3) run
> > > `PATH_TO_IMAGIC_BIN/convert -density 125 NAME_OF_PDF.pdf +profile
> > > '*' -quality 100 page-%04d.png`
> > >
> > > should be no errors
> > > (NOTE PDF conversion might be blocked in ImageMagic policy.xml file)
> > >
> > > On Thu, 11 Jul 2019 at 14:29, Xavier M <xa...@hotmail.com> wrote:
> > > >
> > > > Hi,
> > > >
> > > > I'm a Mac user at work - be aware that it is not a server on the web. I do not fully understand the point, but if you detail me the steps, I can maybe help? I'll find time to do on Monday or Tuesday.
> > > >
> > > > Xavier
> > > >
> > > > ________________________________
> > > > De : Peter Dähn <da...@vcrp.de>
> > > > Envoyé : jeudi 11 juillet 2019 09:13
> > > > À : user@openmeetings.apache.org
> > > > Objet : Re: conversion problem during update
> > > >
> > > > I will ask MAC user around here...
> > > >
> > > > Am 11.07.19 um 08:32 schrieb Maxim Solodovnik:
> > > > > I can test it on Windows
> > > > > Not on Mac :(
> > > > >
> > > > > should be easy:
> > > > > 1) install ImageMagic
> > > > > 2) run command
> > > > > 3) report back :)
> > > > >
> > > > > Are there any volunteers?
> > > > >
> > > > > On Thu, 11 Jul 2019 at 13:29, Peter Dähn <da...@vcrp.de> wrote:
> > > > >> you are right... I simply try to keep it in mind... Maybe updates to
> > > > >> 5.0.x will be done by moving to a new server. I think complete migration
> > > > >> with conversion etc. will to be tested by more admins... ;-)
> > > > >>
> > > > >> Greetings Peter
> > > > >>
> > > > >> Am 11.07.19 um 08:17 schrieb Maxim Solodovnik:
> > > > >>> Actually this is "one minute task" BUT
> > > > >>> Someone need to test it using Win and Mac (I guess it will work on Linux)
> > > > >>>
> > > > >>> On Thu, 11 Jul 2019 at 13:15, Peter Dähn <da...@vcrp.de> wrote:
> > > > >>>> Hi Maxim,
> > > > >>>>
> > > > >>>> seems to be. Does it hurt to add that parameter anyway?
> > > > >>>>
> > > > >>>> Greetigs Peter
> > > > >>>>
> > > > >>>> Am 11.07.19 um 07:17 schrieb Maxim Solodovnik:
> > > > >>>>> No answers for a long time
> > > > >>>>> I guess this one is not a common problem
> > > > >>>>>
> > > > >>>>> On Mon, 3 Jun 2019 at 13:44, Peter Dähn <da...@vcrp.de> wrote:
> > > > >>>>>> Hi Maxim,
> > > > >>>>>>
> > > > >>>>>> you are right, to add this would help, if it is a common problem.
> > > > >>>>>>
> > > > >>>>>> This is a really old file. It seems that it was already a pdf-file.
> > > > >>>>>> Original content of the folder was
> > > > >>>>>>
> > > > >>>>>> HASH.pdf, HASH.swf, library.xml and for each page of the pdf a
> > > > >>>>>> _thumb_page-XXXX.jpg.
> > > > >>>>>>
> > > > >>>>>> Greetings Peter
> > > > >>>>>>
> > > > >>>>>> Am 31.05.19 um 18:39 schrieb Maxim Solodovnik:
> > > > >>>>>>> Hello Peter,
> > > > >>>>>>>
> > > > >>>>>>> I guess you propose to add "profile" param to OM code :)
> > > > >>>>>>> I'm OK with it, could you check if your original document is being
> > > > >>>>>>> converted by OM UI as expected or not?
> > > > >>>>>>>
> > > > >>>>>>> On Fri, 31 May 2019 at 20:03, Peter Dähn <da...@vcrp.de> wrote:
> > > > >>>>>>>> Hi Maxim,
> > > > >>>>>>>>
> > > > >>>>>>>> I needed to convert some room files afterwards. I user command out of
> > > > >>>>>>>> the logs and got for some files an error.
> > > > >>>>>>>>
> > > > >>>>>>>> /usr/bin/convert -density 125
> > > > >>>>>>>> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf -quality
> > > > >>>>>>>> 100 /SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
> > > > >>>>>>>>
> > > > >>>>>>>> convert: profile 'icc': 'RGB ': RGB color space not permitted on
> > > > >>>>>>>> grayscale PNG
> > > > >>>>>>>> `/SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png' @
> > > > >>>>>>>> warning/png.c/MagickPNGWarningHandler/1654.
> > > > >>>>>>>>
> > > > >>>>>>>> I needed to add parameter +profile '*' . Now convert is working without
> > > > >>>>>>>> error.
> > > > >>>>>>>>
> > > > >>>>>>>> /usr/bin/convert -density 125
> > > > >>>>>>>> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf +profile
> > > > >>>>>>>> '*' -quality 100
> > > > >>>>>>>> /usr/lib/red5/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
> > > > >>>>>>>>
> > > > >>>>>>>> Greetings Peter
> > > > >>>>>>>>
> > > > >>>>>>>> Am 15.05.19 um 13:15 schrieb Peter Dähn:
> > > > >>>>>>>>> Hi,
> > > > >>>>>>>>>
> > > > >>>>>>>>> I had a little problem during the last update (from 3.0.7 to 4.0.8). I
> > > > >>>>>>>>> didn't realise, that ffmpeg didn't work after server update. The
> > > > >>>>>>>>> following om update went throug, despite the fact, that
> > > > >>>>>>>>> screen-recordings were not converted.
> > > > >>>>>>>>>
> > > > >>>>>>>>> That why I needed to figure out (with a little bit help of Maxim) how to
> > > > >>>>>>>>> manage that afterwards. I would like to share my steps, in case someone
> > > > >>>>>>>>> has a similar problem.
> > > > >>>>>>>>>
> > > > >>>>>>>>> 1. Get needed information from database (in my case it is postgres)
> > > > >>>>>>>>>
> > > > >>>>>>>>>  select id,hash from om_file where deleted=false and type='Recording'
> > > > >>>>>>>>> and dtype='Recording' order by id;
> > > > >>>>>>>>>
> > > > >>>>>>>>> 2. save the result in a text file e.g. convert_recordings.txt
> > > > >>>>>>>>>
> > > > >>>>>>>>> 3. prepare a little script (linux/bash)
> > > > >>>>>>>>>
> > > > >>>>>>>>> #!/bin/bash
> > > > >>>>>>>>> i=0
> > > > >>>>>>>>> while read line
> > > > >>>>>>>>> do
> > > > >>>>>>>>>    #echo "$line"
> > > > >>>>>>>>>    id=`echo $line | awk '{split($0, a, "|"); print a[1]}'`
> > > > >>>>>>>>>    #echo $id
> > > > >>>>>>>>>    hash=`echo $line | awk '{split($0, a, "|"); print a[2]}'`
> > > > >>>>>>>>>    #echo $hash
> > > > >>>>>>>>> #   echo "bearbeite $id"
> > > > >>>>>>>>>    command_mp4="/usr/local/bin/ffmpeg -y -nostdin -i
> > > > >>>>>>>>> /OM_OLD_DIR/webapps/openmeetings/data/streams/hibernate/flvRecording_$id.avi
> > > > >>>>>>>>> -c:v h264 -crf 24 -pix_fmt yuv420p -preset medium -profile:v baseline
> > > > >>>>>>>>> -level 3.0 -movflags faststart -c:a aac -ar 22050 -b:a 32k
> > > > >>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4"
> > > > >>>>>>>>> #   echo $command_mp4
> > > > >>>>>>>>>    command_png="/usr/local/bin/ffmpeg -y -nostdin -i
> > > > >>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4 -vf
> > > > >>>>>>>>> thumbnail,scale=640:-1 -frames:v 1
> > > > >>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.png"
> > > > >>>>>>>>> #   echo $command_png
> > > > >>>>>>>>>    $command_mp4
> > > > >>>>>>>>>    $command_png
> > > > >>>>>>>>> done < convert_recordings.txt
> > > > >>>>>>>>>
> > > > >>>>>>>>> 4. wait a looooong time (I had over 500 videos)
> > > > >>>>>>>>>
> > > > >>>>>>>>>
> > > > >>>>>>>>> Maybe ffmpeg command is a bit different for other versions.
> > > > >>>>>>>>>
> > > > >>>>>>>>> Greetings Peter
> > > > >>>>>>>>>
> > > > >>>>>>>>>
> > > > >>>>>>>>>
> > > > >>>>>>>>>
> > > > >>>>>>>>>
> > > > >>>>>>>>>
> > > > >>
> > > > >
> > > >
> > >
> > >
> > > --
> > > WBR
> > > Maxim aka solomax
> >
> >
> >
> > --
> > WBR
> > Maxim aka solomax
>
>
>
> --
> WBR
> Maxim aka solomax



--
WBR
Maxim aka solomax

Re: conversion problem during update

Posted by Maxim Solodovnik <so...@gmail.com>.
even better if it will be "+profile '*'" (typo in `profile` is also fixed)

On Mon, 15 Jul 2019 at 16:17, Maxim Solodovnik <so...@gmail.com> wrote:
>
> This string "+ profil '*'"
> Should be "+profil '*'" (no space)
>
> On Mon, 15 Jul 2019 at 16:11, Xavier M <xa...@hotmail.com> wrote:
> >
> > Hi all,
> >
> > I just tested the command lines with a Mac... There must be a mistake somewhere, but it is quite encouraging.
> >
> >  * I used a copy of the tutorial of OpenMeetings Installation by Alvaro (16 pages), and put it into a directory "Test". I renamed it OpenMeet.pdf to (preventively) avoid some undesirable effects of spaces or long names.
> >  * I launched a console and cd into this directory.
> >  * I typed following command:
> > convert -density 125 OpenMeet.pdf + profil '*' -quality 100 page-%04d.png
> >   * I got following errors:
> > convert: unable to open image '+': No such file or directory @ error/blob.c/OpenBlob/3485.
> > convert: no decode delegate for this image format `' @ error/constitute.c/ReadImage/556.
> > convert: unable to open image 'profil': No such file or directory @ error/blob.c/OpenBlob/3485.
> > convert: unable to open image 'profil': No such file or directory @ error/blob.c/OpenBlob/3485.
> > convert: no decode delegate for this image format `' @ error/constitute.c/ReadImage/556.
> >  * BUT I've got now 32 new png-files, numerotated 0000 to 0035. The files page-0000.png and page-0015.png correspond to the first page of the PDF file.
> >
> > --> I guess that ImageMagick works, but that there is some problem with the options in the command lines.
> >
> > Hope this helps...
> > Xavier
> >
> > ________________________________
> > De : Maxim Solodovnik <so...@gmail.com>
> > Envoyé : jeudi 11 juillet 2019 09:44
> > À : Openmeetings user-list
> > Objet : Re: conversion problem during update
> >
> > the page seems to correct
> >
> > On Thu, 11 Jul 2019 at 14:42, Xavier M <xa...@hotmail.com> wrote:
> > >
> > > Just to check for step 1, due to the way it is written: do I follow the instructions here?
> > > https://imagemagick.org/script/download.php#macosx
> > >
> > >
> > >
> > > ________________________________
> > > De : Maxim Solodovnik <so...@gmail.com>
> > > Envoyé : jeudi 11 juillet 2019 09:33
> > > À : Openmeetings user-list
> > > Objet : Re: conversion problem during update
> > >
> > > Steps:
> > > 1) Install ImageMagic
> > > 2) create empty folder, cd into this folder, put any PDF file to it
> > > Using terminal/console app
> > > 3) run
> > > `PATH_TO_IMAGIC_BIN/convert -density 125 NAME_OF_PDF.pdf +profile
> > > '*' -quality 100 page-%04d.png`
> > >
> > > should be no errors
> > > (NOTE PDF conversion might be blocked in ImageMagic policy.xml file)
> > >
> > > On Thu, 11 Jul 2019 at 14:29, Xavier M <xa...@hotmail.com> wrote:
> > > >
> > > > Hi,
> > > >
> > > > I'm a Mac user at work - be aware that it is not a server on the web. I do not fully understand the point, but if you detail me the steps, I can maybe help? I'll find time to do on Monday or Tuesday.
> > > >
> > > > Xavier
> > > >
> > > > ________________________________
> > > > De : Peter Dähn <da...@vcrp.de>
> > > > Envoyé : jeudi 11 juillet 2019 09:13
> > > > À : user@openmeetings.apache.org
> > > > Objet : Re: conversion problem during update
> > > >
> > > > I will ask MAC user around here...
> > > >
> > > > Am 11.07.19 um 08:32 schrieb Maxim Solodovnik:
> > > > > I can test it on Windows
> > > > > Not on Mac :(
> > > > >
> > > > > should be easy:
> > > > > 1) install ImageMagic
> > > > > 2) run command
> > > > > 3) report back :)
> > > > >
> > > > > Are there any volunteers?
> > > > >
> > > > > On Thu, 11 Jul 2019 at 13:29, Peter Dähn <da...@vcrp.de> wrote:
> > > > >> you are right... I simply try to keep it in mind... Maybe updates to
> > > > >> 5.0.x will be done by moving to a new server. I think complete migration
> > > > >> with conversion etc. will to be tested by more admins... ;-)
> > > > >>
> > > > >> Greetings Peter
> > > > >>
> > > > >> Am 11.07.19 um 08:17 schrieb Maxim Solodovnik:
> > > > >>> Actually this is "one minute task" BUT
> > > > >>> Someone need to test it using Win and Mac (I guess it will work on Linux)
> > > > >>>
> > > > >>> On Thu, 11 Jul 2019 at 13:15, Peter Dähn <da...@vcrp.de> wrote:
> > > > >>>> Hi Maxim,
> > > > >>>>
> > > > >>>> seems to be. Does it hurt to add that parameter anyway?
> > > > >>>>
> > > > >>>> Greetigs Peter
> > > > >>>>
> > > > >>>> Am 11.07.19 um 07:17 schrieb Maxim Solodovnik:
> > > > >>>>> No answers for a long time
> > > > >>>>> I guess this one is not a common problem
> > > > >>>>>
> > > > >>>>> On Mon, 3 Jun 2019 at 13:44, Peter Dähn <da...@vcrp.de> wrote:
> > > > >>>>>> Hi Maxim,
> > > > >>>>>>
> > > > >>>>>> you are right, to add this would help, if it is a common problem.
> > > > >>>>>>
> > > > >>>>>> This is a really old file. It seems that it was already a pdf-file.
> > > > >>>>>> Original content of the folder was
> > > > >>>>>>
> > > > >>>>>> HASH.pdf, HASH.swf, library.xml and for each page of the pdf a
> > > > >>>>>> _thumb_page-XXXX.jpg.
> > > > >>>>>>
> > > > >>>>>> Greetings Peter
> > > > >>>>>>
> > > > >>>>>> Am 31.05.19 um 18:39 schrieb Maxim Solodovnik:
> > > > >>>>>>> Hello Peter,
> > > > >>>>>>>
> > > > >>>>>>> I guess you propose to add "profile" param to OM code :)
> > > > >>>>>>> I'm OK with it, could you check if your original document is being
> > > > >>>>>>> converted by OM UI as expected or not?
> > > > >>>>>>>
> > > > >>>>>>> On Fri, 31 May 2019 at 20:03, Peter Dähn <da...@vcrp.de> wrote:
> > > > >>>>>>>> Hi Maxim,
> > > > >>>>>>>>
> > > > >>>>>>>> I needed to convert some room files afterwards. I user command out of
> > > > >>>>>>>> the logs and got for some files an error.
> > > > >>>>>>>>
> > > > >>>>>>>> /usr/bin/convert -density 125
> > > > >>>>>>>> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf -quality
> > > > >>>>>>>> 100 /SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
> > > > >>>>>>>>
> > > > >>>>>>>> convert: profile 'icc': 'RGB ': RGB color space not permitted on
> > > > >>>>>>>> grayscale PNG
> > > > >>>>>>>> `/SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png' @
> > > > >>>>>>>> warning/png.c/MagickPNGWarningHandler/1654.
> > > > >>>>>>>>
> > > > >>>>>>>> I needed to add parameter +profile '*' . Now convert is working without
> > > > >>>>>>>> error.
> > > > >>>>>>>>
> > > > >>>>>>>> /usr/bin/convert -density 125
> > > > >>>>>>>> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf +profile
> > > > >>>>>>>> '*' -quality 100
> > > > >>>>>>>> /usr/lib/red5/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
> > > > >>>>>>>>
> > > > >>>>>>>> Greetings Peter
> > > > >>>>>>>>
> > > > >>>>>>>> Am 15.05.19 um 13:15 schrieb Peter Dähn:
> > > > >>>>>>>>> Hi,
> > > > >>>>>>>>>
> > > > >>>>>>>>> I had a little problem during the last update (from 3.0.7 to 4.0.8). I
> > > > >>>>>>>>> didn't realise, that ffmpeg didn't work after server update. The
> > > > >>>>>>>>> following om update went throug, despite the fact, that
> > > > >>>>>>>>> screen-recordings were not converted.
> > > > >>>>>>>>>
> > > > >>>>>>>>> That why I needed to figure out (with a little bit help of Maxim) how to
> > > > >>>>>>>>> manage that afterwards. I would like to share my steps, in case someone
> > > > >>>>>>>>> has a similar problem.
> > > > >>>>>>>>>
> > > > >>>>>>>>> 1. Get needed information from database (in my case it is postgres)
> > > > >>>>>>>>>
> > > > >>>>>>>>>  select id,hash from om_file where deleted=false and type='Recording'
> > > > >>>>>>>>> and dtype='Recording' order by id;
> > > > >>>>>>>>>
> > > > >>>>>>>>> 2. save the result in a text file e.g. convert_recordings.txt
> > > > >>>>>>>>>
> > > > >>>>>>>>> 3. prepare a little script (linux/bash)
> > > > >>>>>>>>>
> > > > >>>>>>>>> #!/bin/bash
> > > > >>>>>>>>> i=0
> > > > >>>>>>>>> while read line
> > > > >>>>>>>>> do
> > > > >>>>>>>>>    #echo "$line"
> > > > >>>>>>>>>    id=`echo $line | awk '{split($0, a, "|"); print a[1]}'`
> > > > >>>>>>>>>    #echo $id
> > > > >>>>>>>>>    hash=`echo $line | awk '{split($0, a, "|"); print a[2]}'`
> > > > >>>>>>>>>    #echo $hash
> > > > >>>>>>>>> #   echo "bearbeite $id"
> > > > >>>>>>>>>    command_mp4="/usr/local/bin/ffmpeg -y -nostdin -i
> > > > >>>>>>>>> /OM_OLD_DIR/webapps/openmeetings/data/streams/hibernate/flvRecording_$id.avi
> > > > >>>>>>>>> -c:v h264 -crf 24 -pix_fmt yuv420p -preset medium -profile:v baseline
> > > > >>>>>>>>> -level 3.0 -movflags faststart -c:a aac -ar 22050 -b:a 32k
> > > > >>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4"
> > > > >>>>>>>>> #   echo $command_mp4
> > > > >>>>>>>>>    command_png="/usr/local/bin/ffmpeg -y -nostdin -i
> > > > >>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4 -vf
> > > > >>>>>>>>> thumbnail,scale=640:-1 -frames:v 1
> > > > >>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.png"
> > > > >>>>>>>>> #   echo $command_png
> > > > >>>>>>>>>    $command_mp4
> > > > >>>>>>>>>    $command_png
> > > > >>>>>>>>> done < convert_recordings.txt
> > > > >>>>>>>>>
> > > > >>>>>>>>> 4. wait a looooong time (I had over 500 videos)
> > > > >>>>>>>>>
> > > > >>>>>>>>>
> > > > >>>>>>>>> Maybe ffmpeg command is a bit different for other versions.
> > > > >>>>>>>>>
> > > > >>>>>>>>> Greetings Peter
> > > > >>>>>>>>>
> > > > >>>>>>>>>
> > > > >>>>>>>>>
> > > > >>>>>>>>>
> > > > >>>>>>>>>
> > > > >>>>>>>>>
> > > > >>
> > > > >
> > > >
> > >
> > >
> > > --
> > > WBR
> > > Maxim aka solomax
> >
> >
> >
> > --
> > WBR
> > Maxim aka solomax
>
>
>
> --
> WBR
> Maxim aka solomax



-- 
WBR
Maxim aka solomax

Re: conversion problem during update

Posted by Maxim Solodovnik <so...@gmail.com>.
This string "+ profil '*'"
Should be "+profil '*'" (no space)

On Mon, 15 Jul 2019 at 16:11, Xavier M <xa...@hotmail.com> wrote:
>
> Hi all,
>
> I just tested the command lines with a Mac... There must be a mistake somewhere, but it is quite encouraging.
>
>  * I used a copy of the tutorial of OpenMeetings Installation by Alvaro (16 pages), and put it into a directory "Test". I renamed it OpenMeet.pdf to (preventively) avoid some undesirable effects of spaces or long names.
>  * I launched a console and cd into this directory.
>  * I typed following command:
> convert -density 125 OpenMeet.pdf + profil '*' -quality 100 page-%04d.png
>   * I got following errors:
> convert: unable to open image '+': No such file or directory @ error/blob.c/OpenBlob/3485.
> convert: no decode delegate for this image format `' @ error/constitute.c/ReadImage/556.
> convert: unable to open image 'profil': No such file or directory @ error/blob.c/OpenBlob/3485.
> convert: unable to open image 'profil': No such file or directory @ error/blob.c/OpenBlob/3485.
> convert: no decode delegate for this image format `' @ error/constitute.c/ReadImage/556.
>  * BUT I've got now 32 new png-files, numerotated 0000 to 0035. The files page-0000.png and page-0015.png correspond to the first page of the PDF file.
>
> --> I guess that ImageMagick works, but that there is some problem with the options in the command lines.
>
> Hope this helps...
> Xavier
>
> ________________________________
> De : Maxim Solodovnik <so...@gmail.com>
> Envoyé : jeudi 11 juillet 2019 09:44
> À : Openmeetings user-list
> Objet : Re: conversion problem during update
>
> the page seems to correct
>
> On Thu, 11 Jul 2019 at 14:42, Xavier M <xa...@hotmail.com> wrote:
> >
> > Just to check for step 1, due to the way it is written: do I follow the instructions here?
> > https://imagemagick.org/script/download.php#macosx
> >
> >
> >
> > ________________________________
> > De : Maxim Solodovnik <so...@gmail.com>
> > Envoyé : jeudi 11 juillet 2019 09:33
> > À : Openmeetings user-list
> > Objet : Re: conversion problem during update
> >
> > Steps:
> > 1) Install ImageMagic
> > 2) create empty folder, cd into this folder, put any PDF file to it
> > Using terminal/console app
> > 3) run
> > `PATH_TO_IMAGIC_BIN/convert -density 125 NAME_OF_PDF.pdf +profile
> > '*' -quality 100 page-%04d.png`
> >
> > should be no errors
> > (NOTE PDF conversion might be blocked in ImageMagic policy.xml file)
> >
> > On Thu, 11 Jul 2019 at 14:29, Xavier M <xa...@hotmail.com> wrote:
> > >
> > > Hi,
> > >
> > > I'm a Mac user at work - be aware that it is not a server on the web. I do not fully understand the point, but if you detail me the steps, I can maybe help? I'll find time to do on Monday or Tuesday.
> > >
> > > Xavier
> > >
> > > ________________________________
> > > De : Peter Dähn <da...@vcrp.de>
> > > Envoyé : jeudi 11 juillet 2019 09:13
> > > À : user@openmeetings.apache.org
> > > Objet : Re: conversion problem during update
> > >
> > > I will ask MAC user around here...
> > >
> > > Am 11.07.19 um 08:32 schrieb Maxim Solodovnik:
> > > > I can test it on Windows
> > > > Not on Mac :(
> > > >
> > > > should be easy:
> > > > 1) install ImageMagic
> > > > 2) run command
> > > > 3) report back :)
> > > >
> > > > Are there any volunteers?
> > > >
> > > > On Thu, 11 Jul 2019 at 13:29, Peter Dähn <da...@vcrp.de> wrote:
> > > >> you are right... I simply try to keep it in mind... Maybe updates to
> > > >> 5.0.x will be done by moving to a new server. I think complete migration
> > > >> with conversion etc. will to be tested by more admins... ;-)
> > > >>
> > > >> Greetings Peter
> > > >>
> > > >> Am 11.07.19 um 08:17 schrieb Maxim Solodovnik:
> > > >>> Actually this is "one minute task" BUT
> > > >>> Someone need to test it using Win and Mac (I guess it will work on Linux)
> > > >>>
> > > >>> On Thu, 11 Jul 2019 at 13:15, Peter Dähn <da...@vcrp.de> wrote:
> > > >>>> Hi Maxim,
> > > >>>>
> > > >>>> seems to be. Does it hurt to add that parameter anyway?
> > > >>>>
> > > >>>> Greetigs Peter
> > > >>>>
> > > >>>> Am 11.07.19 um 07:17 schrieb Maxim Solodovnik:
> > > >>>>> No answers for a long time
> > > >>>>> I guess this one is not a common problem
> > > >>>>>
> > > >>>>> On Mon, 3 Jun 2019 at 13:44, Peter Dähn <da...@vcrp.de> wrote:
> > > >>>>>> Hi Maxim,
> > > >>>>>>
> > > >>>>>> you are right, to add this would help, if it is a common problem.
> > > >>>>>>
> > > >>>>>> This is a really old file. It seems that it was already a pdf-file.
> > > >>>>>> Original content of the folder was
> > > >>>>>>
> > > >>>>>> HASH.pdf, HASH.swf, library.xml and for each page of the pdf a
> > > >>>>>> _thumb_page-XXXX.jpg.
> > > >>>>>>
> > > >>>>>> Greetings Peter
> > > >>>>>>
> > > >>>>>> Am 31.05.19 um 18:39 schrieb Maxim Solodovnik:
> > > >>>>>>> Hello Peter,
> > > >>>>>>>
> > > >>>>>>> I guess you propose to add "profile" param to OM code :)
> > > >>>>>>> I'm OK with it, could you check if your original document is being
> > > >>>>>>> converted by OM UI as expected or not?
> > > >>>>>>>
> > > >>>>>>> On Fri, 31 May 2019 at 20:03, Peter Dähn <da...@vcrp.de> wrote:
> > > >>>>>>>> Hi Maxim,
> > > >>>>>>>>
> > > >>>>>>>> I needed to convert some room files afterwards. I user command out of
> > > >>>>>>>> the logs and got for some files an error.
> > > >>>>>>>>
> > > >>>>>>>> /usr/bin/convert -density 125
> > > >>>>>>>> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf -quality
> > > >>>>>>>> 100 /SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
> > > >>>>>>>>
> > > >>>>>>>> convert: profile 'icc': 'RGB ': RGB color space not permitted on
> > > >>>>>>>> grayscale PNG
> > > >>>>>>>> `/SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png' @
> > > >>>>>>>> warning/png.c/MagickPNGWarningHandler/1654.
> > > >>>>>>>>
> > > >>>>>>>> I needed to add parameter +profile '*' . Now convert is working without
> > > >>>>>>>> error.
> > > >>>>>>>>
> > > >>>>>>>> /usr/bin/convert -density 125
> > > >>>>>>>> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf +profile
> > > >>>>>>>> '*' -quality 100
> > > >>>>>>>> /usr/lib/red5/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
> > > >>>>>>>>
> > > >>>>>>>> Greetings Peter
> > > >>>>>>>>
> > > >>>>>>>> Am 15.05.19 um 13:15 schrieb Peter Dähn:
> > > >>>>>>>>> Hi,
> > > >>>>>>>>>
> > > >>>>>>>>> I had a little problem during the last update (from 3.0.7 to 4.0.8). I
> > > >>>>>>>>> didn't realise, that ffmpeg didn't work after server update. The
> > > >>>>>>>>> following om update went throug, despite the fact, that
> > > >>>>>>>>> screen-recordings were not converted.
> > > >>>>>>>>>
> > > >>>>>>>>> That why I needed to figure out (with a little bit help of Maxim) how to
> > > >>>>>>>>> manage that afterwards. I would like to share my steps, in case someone
> > > >>>>>>>>> has a similar problem.
> > > >>>>>>>>>
> > > >>>>>>>>> 1. Get needed information from database (in my case it is postgres)
> > > >>>>>>>>>
> > > >>>>>>>>>  select id,hash from om_file where deleted=false and type='Recording'
> > > >>>>>>>>> and dtype='Recording' order by id;
> > > >>>>>>>>>
> > > >>>>>>>>> 2. save the result in a text file e.g. convert_recordings.txt
> > > >>>>>>>>>
> > > >>>>>>>>> 3. prepare a little script (linux/bash)
> > > >>>>>>>>>
> > > >>>>>>>>> #!/bin/bash
> > > >>>>>>>>> i=0
> > > >>>>>>>>> while read line
> > > >>>>>>>>> do
> > > >>>>>>>>>    #echo "$line"
> > > >>>>>>>>>    id=`echo $line | awk '{split($0, a, "|"); print a[1]}'`
> > > >>>>>>>>>    #echo $id
> > > >>>>>>>>>    hash=`echo $line | awk '{split($0, a, "|"); print a[2]}'`
> > > >>>>>>>>>    #echo $hash
> > > >>>>>>>>> #   echo "bearbeite $id"
> > > >>>>>>>>>    command_mp4="/usr/local/bin/ffmpeg -y -nostdin -i
> > > >>>>>>>>> /OM_OLD_DIR/webapps/openmeetings/data/streams/hibernate/flvRecording_$id.avi
> > > >>>>>>>>> -c:v h264 -crf 24 -pix_fmt yuv420p -preset medium -profile:v baseline
> > > >>>>>>>>> -level 3.0 -movflags faststart -c:a aac -ar 22050 -b:a 32k
> > > >>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4"
> > > >>>>>>>>> #   echo $command_mp4
> > > >>>>>>>>>    command_png="/usr/local/bin/ffmpeg -y -nostdin -i
> > > >>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4 -vf
> > > >>>>>>>>> thumbnail,scale=640:-1 -frames:v 1
> > > >>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.png"
> > > >>>>>>>>> #   echo $command_png
> > > >>>>>>>>>    $command_mp4
> > > >>>>>>>>>    $command_png
> > > >>>>>>>>> done < convert_recordings.txt
> > > >>>>>>>>>
> > > >>>>>>>>> 4. wait a looooong time (I had over 500 videos)
> > > >>>>>>>>>
> > > >>>>>>>>>
> > > >>>>>>>>> Maybe ffmpeg command is a bit different for other versions.
> > > >>>>>>>>>
> > > >>>>>>>>> Greetings Peter
> > > >>>>>>>>>
> > > >>>>>>>>>
> > > >>>>>>>>>
> > > >>>>>>>>>
> > > >>>>>>>>>
> > > >>>>>>>>>
> > > >>
> > > >
> > >
> >
> >
> > --
> > WBR
> > Maxim aka solomax
>
>
>
> --
> WBR
> Maxim aka solomax



-- 
WBR
Maxim aka solomax

RE: conversion problem during update

Posted by Xavier M <xa...@hotmail.com>.
Hi all,

I just tested the command lines with a Mac... There must be a mistake somewhere, but it is quite encouraging.

 * I used a copy of the tutorial of OpenMeetings Installation by Alvaro (16 pages), and put it into a directory "Test". I renamed it OpenMeet.pdf to (preventively) avoid some undesirable effects of spaces or long names.
 * I launched a console and cd into this directory.
 * I typed following command:
convert -density 125 OpenMeet.pdf + profil '*' -quality 100 page-%04d.png
  * I got following errors:
convert: unable to open image '+': No such file or directory @ error/blob.c/OpenBlob/3485.
convert: no decode delegate for this image format `' @ error/constitute.c/ReadImage/556.
convert: unable to open image 'profil': No such file or directory @ error/blob.c/OpenBlob/3485.
convert: unable to open image 'profil': No such file or directory @ error/blob.c/OpenBlob/3485.
convert: no decode delegate for this image format `' @ error/constitute.c/ReadImage/556.
 * BUT I've got now 32 new png-files, numerotated 0000 to 0035. The files page-0000.png and page-0015.png correspond to the first page of the PDF file.

--> I guess that ImageMagick works, but that there is some problem with the options in the command lines.

Hope this helps...
Xavier

________________________________
De : Maxim Solodovnik <so...@gmail.com>
Envoyé : jeudi 11 juillet 2019 09:44
À : Openmeetings user-list
Objet : Re: conversion problem during update

the page seems to correct

On Thu, 11 Jul 2019 at 14:42, Xavier M <xa...@hotmail.com> wrote:
>
> Just to check for step 1, due to the way it is written: do I follow the instructions here?
> https://imagemagick.org/script/download.php#macosx
>
>
>
> ________________________________
> De : Maxim Solodovnik <so...@gmail.com>
> Envoyé : jeudi 11 juillet 2019 09:33
> À : Openmeetings user-list
> Objet : Re: conversion problem during update
>
> Steps:
> 1) Install ImageMagic
> 2) create empty folder, cd into this folder, put any PDF file to it
> Using terminal/console app
> 3) run
> `PATH_TO_IMAGIC_BIN/convert -density 125 NAME_OF_PDF.pdf +profile
> '*' -quality 100 page-%04d.png`
>
> should be no errors
> (NOTE PDF conversion might be blocked in ImageMagic policy.xml file)
>
> On Thu, 11 Jul 2019 at 14:29, Xavier M <xa...@hotmail.com> wrote:
> >
> > Hi,
> >
> > I'm a Mac user at work - be aware that it is not a server on the web. I do not fully understand the point, but if you detail me the steps, I can maybe help? I'll find time to do on Monday or Tuesday.
> >
> > Xavier
> >
> > ________________________________
> > De : Peter Dähn <da...@vcrp.de>
> > Envoyé : jeudi 11 juillet 2019 09:13
> > À : user@openmeetings.apache.org
> > Objet : Re: conversion problem during update
> >
> > I will ask MAC user around here...
> >
> > Am 11.07.19 um 08:32 schrieb Maxim Solodovnik:
> > > I can test it on Windows
> > > Not on Mac :(
> > >
> > > should be easy:
> > > 1) install ImageMagic
> > > 2) run command
> > > 3) report back :)
> > >
> > > Are there any volunteers?
> > >
> > > On Thu, 11 Jul 2019 at 13:29, Peter Dähn <da...@vcrp.de> wrote:
> > >> you are right... I simply try to keep it in mind... Maybe updates to
> > >> 5.0.x will be done by moving to a new server. I think complete migration
> > >> with conversion etc. will to be tested by more admins... ;-)
> > >>
> > >> Greetings Peter
> > >>
> > >> Am 11.07.19 um 08:17 schrieb Maxim Solodovnik:
> > >>> Actually this is "one minute task" BUT
> > >>> Someone need to test it using Win and Mac (I guess it will work on Linux)
> > >>>
> > >>> On Thu, 11 Jul 2019 at 13:15, Peter Dähn <da...@vcrp.de> wrote:
> > >>>> Hi Maxim,
> > >>>>
> > >>>> seems to be. Does it hurt to add that parameter anyway?
> > >>>>
> > >>>> Greetigs Peter
> > >>>>
> > >>>> Am 11.07.19 um 07:17 schrieb Maxim Solodovnik:
> > >>>>> No answers for a long time
> > >>>>> I guess this one is not a common problem
> > >>>>>
> > >>>>> On Mon, 3 Jun 2019 at 13:44, Peter Dähn <da...@vcrp.de> wrote:
> > >>>>>> Hi Maxim,
> > >>>>>>
> > >>>>>> you are right, to add this would help, if it is a common problem.
> > >>>>>>
> > >>>>>> This is a really old file. It seems that it was already a pdf-file.
> > >>>>>> Original content of the folder was
> > >>>>>>
> > >>>>>> HASH.pdf, HASH.swf, library.xml and for each page of the pdf a
> > >>>>>> _thumb_page-XXXX.jpg.
> > >>>>>>
> > >>>>>> Greetings Peter
> > >>>>>>
> > >>>>>> Am 31.05.19 um 18:39 schrieb Maxim Solodovnik:
> > >>>>>>> Hello Peter,
> > >>>>>>>
> > >>>>>>> I guess you propose to add "profile" param to OM code :)
> > >>>>>>> I'm OK with it, could you check if your original document is being
> > >>>>>>> converted by OM UI as expected or not?
> > >>>>>>>
> > >>>>>>> On Fri, 31 May 2019 at 20:03, Peter Dähn <da...@vcrp.de> wrote:
> > >>>>>>>> Hi Maxim,
> > >>>>>>>>
> > >>>>>>>> I needed to convert some room files afterwards. I user command out of
> > >>>>>>>> the logs and got for some files an error.
> > >>>>>>>>
> > >>>>>>>> /usr/bin/convert -density 125
> > >>>>>>>> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf -quality
> > >>>>>>>> 100 /SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
> > >>>>>>>>
> > >>>>>>>> convert: profile 'icc': 'RGB ': RGB color space not permitted on
> > >>>>>>>> grayscale PNG
> > >>>>>>>> `/SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png' @
> > >>>>>>>> warning/png.c/MagickPNGWarningHandler/1654.
> > >>>>>>>>
> > >>>>>>>> I needed to add parameter +profile '*' . Now convert is working without
> > >>>>>>>> error.
> > >>>>>>>>
> > >>>>>>>> /usr/bin/convert -density 125
> > >>>>>>>> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf +profile
> > >>>>>>>> '*' -quality 100
> > >>>>>>>> /usr/lib/red5/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
> > >>>>>>>>
> > >>>>>>>> Greetings Peter
> > >>>>>>>>
> > >>>>>>>> Am 15.05.19 um 13:15 schrieb Peter Dähn:
> > >>>>>>>>> Hi,
> > >>>>>>>>>
> > >>>>>>>>> I had a little problem during the last update (from 3.0.7 to 4.0.8). I
> > >>>>>>>>> didn't realise, that ffmpeg didn't work after server update. The
> > >>>>>>>>> following om update went throug, despite the fact, that
> > >>>>>>>>> screen-recordings were not converted.
> > >>>>>>>>>
> > >>>>>>>>> That why I needed to figure out (with a little bit help of Maxim) how to
> > >>>>>>>>> manage that afterwards. I would like to share my steps, in case someone
> > >>>>>>>>> has a similar problem.
> > >>>>>>>>>
> > >>>>>>>>> 1. Get needed information from database (in my case it is postgres)
> > >>>>>>>>>
> > >>>>>>>>>  select id,hash from om_file where deleted=false and type='Recording'
> > >>>>>>>>> and dtype='Recording' order by id;
> > >>>>>>>>>
> > >>>>>>>>> 2. save the result in a text file e.g. convert_recordings.txt
> > >>>>>>>>>
> > >>>>>>>>> 3. prepare a little script (linux/bash)
> > >>>>>>>>>
> > >>>>>>>>> #!/bin/bash
> > >>>>>>>>> i=0
> > >>>>>>>>> while read line
> > >>>>>>>>> do
> > >>>>>>>>>    #echo "$line"
> > >>>>>>>>>    id=`echo $line | awk '{split($0, a, "|"); print a[1]}'`
> > >>>>>>>>>    #echo $id
> > >>>>>>>>>    hash=`echo $line | awk '{split($0, a, "|"); print a[2]}'`
> > >>>>>>>>>    #echo $hash
> > >>>>>>>>> #   echo "bearbeite $id"
> > >>>>>>>>>    command_mp4="/usr/local/bin/ffmpeg -y -nostdin -i
> > >>>>>>>>> /OM_OLD_DIR/webapps/openmeetings/data/streams/hibernate/flvRecording_$id.avi
> > >>>>>>>>> -c:v h264 -crf 24 -pix_fmt yuv420p -preset medium -profile:v baseline
> > >>>>>>>>> -level 3.0 -movflags faststart -c:a aac -ar 22050 -b:a 32k
> > >>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4"
> > >>>>>>>>> #   echo $command_mp4
> > >>>>>>>>>    command_png="/usr/local/bin/ffmpeg -y -nostdin -i
> > >>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4 -vf
> > >>>>>>>>> thumbnail,scale=640:-1 -frames:v 1
> > >>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.png"
> > >>>>>>>>> #   echo $command_png
> > >>>>>>>>>    $command_mp4
> > >>>>>>>>>    $command_png
> > >>>>>>>>> done < convert_recordings.txt
> > >>>>>>>>>
> > >>>>>>>>> 4. wait a looooong time (I had over 500 videos)
> > >>>>>>>>>
> > >>>>>>>>>
> > >>>>>>>>> Maybe ffmpeg command is a bit different for other versions.
> > >>>>>>>>>
> > >>>>>>>>> Greetings Peter
> > >>>>>>>>>
> > >>>>>>>>>
> > >>>>>>>>>
> > >>>>>>>>>
> > >>>>>>>>>
> > >>>>>>>>>
> > >>
> > >
> >
>
>
> --
> WBR
> Maxim aka solomax



--
WBR
Maxim aka solomax

new version and mysql-connector

Posted by Stefan Kühl <st...@quatrekuehl.eu>.
Hey all, 

I'm going to run a new installation and wonder if I should wait for M2
or not?
Another question: Will mysql-connector-java-8.0.16.jar (out since march)
also work or is 8.0.16 hardcoded anywhere? 

Greetz 

Stefan

Re: conversion problem during update

Posted by Maxim Solodovnik <so...@gmail.com>.
the page seems to correct

On Thu, 11 Jul 2019 at 14:42, Xavier M <xa...@hotmail.com> wrote:
>
> Just to check for step 1, due to the way it is written: do I follow the instructions here?
> https://imagemagick.org/script/download.php#macosx
>
>
>
> ________________________________
> De : Maxim Solodovnik <so...@gmail.com>
> Envoyé : jeudi 11 juillet 2019 09:33
> À : Openmeetings user-list
> Objet : Re: conversion problem during update
>
> Steps:
> 1) Install ImageMagic
> 2) create empty folder, cd into this folder, put any PDF file to it
> Using terminal/console app
> 3) run
> `PATH_TO_IMAGIC_BIN/convert -density 125 NAME_OF_PDF.pdf +profile
> '*' -quality 100 page-%04d.png`
>
> should be no errors
> (NOTE PDF conversion might be blocked in ImageMagic policy.xml file)
>
> On Thu, 11 Jul 2019 at 14:29, Xavier M <xa...@hotmail.com> wrote:
> >
> > Hi,
> >
> > I'm a Mac user at work - be aware that it is not a server on the web. I do not fully understand the point, but if you detail me the steps, I can maybe help? I'll find time to do on Monday or Tuesday.
> >
> > Xavier
> >
> > ________________________________
> > De : Peter Dähn <da...@vcrp.de>
> > Envoyé : jeudi 11 juillet 2019 09:13
> > À : user@openmeetings.apache.org
> > Objet : Re: conversion problem during update
> >
> > I will ask MAC user around here...
> >
> > Am 11.07.19 um 08:32 schrieb Maxim Solodovnik:
> > > I can test it on Windows
> > > Not on Mac :(
> > >
> > > should be easy:
> > > 1) install ImageMagic
> > > 2) run command
> > > 3) report back :)
> > >
> > > Are there any volunteers?
> > >
> > > On Thu, 11 Jul 2019 at 13:29, Peter Dähn <da...@vcrp.de> wrote:
> > >> you are right... I simply try to keep it in mind... Maybe updates to
> > >> 5.0.x will be done by moving to a new server. I think complete migration
> > >> with conversion etc. will to be tested by more admins... ;-)
> > >>
> > >> Greetings Peter
> > >>
> > >> Am 11.07.19 um 08:17 schrieb Maxim Solodovnik:
> > >>> Actually this is "one minute task" BUT
> > >>> Someone need to test it using Win and Mac (I guess it will work on Linux)
> > >>>
> > >>> On Thu, 11 Jul 2019 at 13:15, Peter Dähn <da...@vcrp.de> wrote:
> > >>>> Hi Maxim,
> > >>>>
> > >>>> seems to be. Does it hurt to add that parameter anyway?
> > >>>>
> > >>>> Greetigs Peter
> > >>>>
> > >>>> Am 11.07.19 um 07:17 schrieb Maxim Solodovnik:
> > >>>>> No answers for a long time
> > >>>>> I guess this one is not a common problem
> > >>>>>
> > >>>>> On Mon, 3 Jun 2019 at 13:44, Peter Dähn <da...@vcrp.de> wrote:
> > >>>>>> Hi Maxim,
> > >>>>>>
> > >>>>>> you are right, to add this would help, if it is a common problem.
> > >>>>>>
> > >>>>>> This is a really old file. It seems that it was already a pdf-file.
> > >>>>>> Original content of the folder was
> > >>>>>>
> > >>>>>> HASH.pdf, HASH.swf, library.xml and for each page of the pdf a
> > >>>>>> _thumb_page-XXXX.jpg.
> > >>>>>>
> > >>>>>> Greetings Peter
> > >>>>>>
> > >>>>>> Am 31.05.19 um 18:39 schrieb Maxim Solodovnik:
> > >>>>>>> Hello Peter,
> > >>>>>>>
> > >>>>>>> I guess you propose to add "profile" param to OM code :)
> > >>>>>>> I'm OK with it, could you check if your original document is being
> > >>>>>>> converted by OM UI as expected or not?
> > >>>>>>>
> > >>>>>>> On Fri, 31 May 2019 at 20:03, Peter Dähn <da...@vcrp.de> wrote:
> > >>>>>>>> Hi Maxim,
> > >>>>>>>>
> > >>>>>>>> I needed to convert some room files afterwards. I user command out of
> > >>>>>>>> the logs and got for some files an error.
> > >>>>>>>>
> > >>>>>>>> /usr/bin/convert -density 125
> > >>>>>>>> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf -quality
> > >>>>>>>> 100 /SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
> > >>>>>>>>
> > >>>>>>>> convert: profile 'icc': 'RGB ': RGB color space not permitted on
> > >>>>>>>> grayscale PNG
> > >>>>>>>> `/SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png' @
> > >>>>>>>> warning/png.c/MagickPNGWarningHandler/1654.
> > >>>>>>>>
> > >>>>>>>> I needed to add parameter +profile '*' . Now convert is working without
> > >>>>>>>> error.
> > >>>>>>>>
> > >>>>>>>> /usr/bin/convert -density 125
> > >>>>>>>> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf +profile
> > >>>>>>>> '*' -quality 100
> > >>>>>>>> /usr/lib/red5/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
> > >>>>>>>>
> > >>>>>>>> Greetings Peter
> > >>>>>>>>
> > >>>>>>>> Am 15.05.19 um 13:15 schrieb Peter Dähn:
> > >>>>>>>>> Hi,
> > >>>>>>>>>
> > >>>>>>>>> I had a little problem during the last update (from 3.0.7 to 4.0.8). I
> > >>>>>>>>> didn't realise, that ffmpeg didn't work after server update. The
> > >>>>>>>>> following om update went throug, despite the fact, that
> > >>>>>>>>> screen-recordings were not converted.
> > >>>>>>>>>
> > >>>>>>>>> That why I needed to figure out (with a little bit help of Maxim) how to
> > >>>>>>>>> manage that afterwards. I would like to share my steps, in case someone
> > >>>>>>>>> has a similar problem.
> > >>>>>>>>>
> > >>>>>>>>> 1. Get needed information from database (in my case it is postgres)
> > >>>>>>>>>
> > >>>>>>>>>  select id,hash from om_file where deleted=false and type='Recording'
> > >>>>>>>>> and dtype='Recording' order by id;
> > >>>>>>>>>
> > >>>>>>>>> 2. save the result in a text file e.g. convert_recordings.txt
> > >>>>>>>>>
> > >>>>>>>>> 3. prepare a little script (linux/bash)
> > >>>>>>>>>
> > >>>>>>>>> #!/bin/bash
> > >>>>>>>>> i=0
> > >>>>>>>>> while read line
> > >>>>>>>>> do
> > >>>>>>>>>    #echo "$line"
> > >>>>>>>>>    id=`echo $line | awk '{split($0, a, "|"); print a[1]}'`
> > >>>>>>>>>    #echo $id
> > >>>>>>>>>    hash=`echo $line | awk '{split($0, a, "|"); print a[2]}'`
> > >>>>>>>>>    #echo $hash
> > >>>>>>>>> #   echo "bearbeite $id"
> > >>>>>>>>>    command_mp4="/usr/local/bin/ffmpeg -y -nostdin -i
> > >>>>>>>>> /OM_OLD_DIR/webapps/openmeetings/data/streams/hibernate/flvRecording_$id.avi
> > >>>>>>>>> -c:v h264 -crf 24 -pix_fmt yuv420p -preset medium -profile:v baseline
> > >>>>>>>>> -level 3.0 -movflags faststart -c:a aac -ar 22050 -b:a 32k
> > >>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4"
> > >>>>>>>>> #   echo $command_mp4
> > >>>>>>>>>    command_png="/usr/local/bin/ffmpeg -y -nostdin -i
> > >>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4 -vf
> > >>>>>>>>> thumbnail,scale=640:-1 -frames:v 1
> > >>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.png"
> > >>>>>>>>> #   echo $command_png
> > >>>>>>>>>    $command_mp4
> > >>>>>>>>>    $command_png
> > >>>>>>>>> done < convert_recordings.txt
> > >>>>>>>>>
> > >>>>>>>>> 4. wait a looooong time (I had over 500 videos)
> > >>>>>>>>>
> > >>>>>>>>>
> > >>>>>>>>> Maybe ffmpeg command is a bit different for other versions.
> > >>>>>>>>>
> > >>>>>>>>> Greetings Peter
> > >>>>>>>>>
> > >>>>>>>>>
> > >>>>>>>>>
> > >>>>>>>>>
> > >>>>>>>>>
> > >>>>>>>>>
> > >>
> > >
> >
>
>
> --
> WBR
> Maxim aka solomax



-- 
WBR
Maxim aka solomax

RE: conversion problem during update

Posted by Xavier M <xa...@hotmail.com>.
Just to check for step 1, due to the way it is written: do I follow the instructions here?
https://imagemagick.org/script/download.php#macosx



________________________________
De : Maxim Solodovnik <so...@gmail.com>
Envoyé : jeudi 11 juillet 2019 09:33
À : Openmeetings user-list
Objet : Re: conversion problem during update

Steps:
1) Install ImageMagic
2) create empty folder, cd into this folder, put any PDF file to it
Using terminal/console app
3) run
`PATH_TO_IMAGIC_BIN/convert -density 125 NAME_OF_PDF.pdf +profile
'*' -quality 100 page-%04d.png`

should be no errors
(NOTE PDF conversion might be blocked in ImageMagic policy.xml file)

On Thu, 11 Jul 2019 at 14:29, Xavier M <xa...@hotmail.com> wrote:
>
> Hi,
>
> I'm a Mac user at work - be aware that it is not a server on the web. I do not fully understand the point, but if you detail me the steps, I can maybe help? I'll find time to do on Monday or Tuesday.
>
> Xavier
>
> ________________________________
> De : Peter Dähn <da...@vcrp.de>
> Envoyé : jeudi 11 juillet 2019 09:13
> À : user@openmeetings.apache.org
> Objet : Re: conversion problem during update
>
> I will ask MAC user around here...
>
> Am 11.07.19 um 08:32 schrieb Maxim Solodovnik:
> > I can test it on Windows
> > Not on Mac :(
> >
> > should be easy:
> > 1) install ImageMagic
> > 2) run command
> > 3) report back :)
> >
> > Are there any volunteers?
> >
> > On Thu, 11 Jul 2019 at 13:29, Peter Dähn <da...@vcrp.de> wrote:
> >> you are right... I simply try to keep it in mind... Maybe updates to
> >> 5.0.x will be done by moving to a new server. I think complete migration
> >> with conversion etc. will to be tested by more admins... ;-)
> >>
> >> Greetings Peter
> >>
> >> Am 11.07.19 um 08:17 schrieb Maxim Solodovnik:
> >>> Actually this is "one minute task" BUT
> >>> Someone need to test it using Win and Mac (I guess it will work on Linux)
> >>>
> >>> On Thu, 11 Jul 2019 at 13:15, Peter Dähn <da...@vcrp.de> wrote:
> >>>> Hi Maxim,
> >>>>
> >>>> seems to be. Does it hurt to add that parameter anyway?
> >>>>
> >>>> Greetigs Peter
> >>>>
> >>>> Am 11.07.19 um 07:17 schrieb Maxim Solodovnik:
> >>>>> No answers for a long time
> >>>>> I guess this one is not a common problem
> >>>>>
> >>>>> On Mon, 3 Jun 2019 at 13:44, Peter Dähn <da...@vcrp.de> wrote:
> >>>>>> Hi Maxim,
> >>>>>>
> >>>>>> you are right, to add this would help, if it is a common problem.
> >>>>>>
> >>>>>> This is a really old file. It seems that it was already a pdf-file.
> >>>>>> Original content of the folder was
> >>>>>>
> >>>>>> HASH.pdf, HASH.swf, library.xml and for each page of the pdf a
> >>>>>> _thumb_page-XXXX.jpg.
> >>>>>>
> >>>>>> Greetings Peter
> >>>>>>
> >>>>>> Am 31.05.19 um 18:39 schrieb Maxim Solodovnik:
> >>>>>>> Hello Peter,
> >>>>>>>
> >>>>>>> I guess you propose to add "profile" param to OM code :)
> >>>>>>> I'm OK with it, could you check if your original document is being
> >>>>>>> converted by OM UI as expected or not?
> >>>>>>>
> >>>>>>> On Fri, 31 May 2019 at 20:03, Peter Dähn <da...@vcrp.de> wrote:
> >>>>>>>> Hi Maxim,
> >>>>>>>>
> >>>>>>>> I needed to convert some room files afterwards. I user command out of
> >>>>>>>> the logs and got for some files an error.
> >>>>>>>>
> >>>>>>>> /usr/bin/convert -density 125
> >>>>>>>> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf -quality
> >>>>>>>> 100 /SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
> >>>>>>>>
> >>>>>>>> convert: profile 'icc': 'RGB ': RGB color space not permitted on
> >>>>>>>> grayscale PNG
> >>>>>>>> `/SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png' @
> >>>>>>>> warning/png.c/MagickPNGWarningHandler/1654.
> >>>>>>>>
> >>>>>>>> I needed to add parameter +profile '*' . Now convert is working without
> >>>>>>>> error.
> >>>>>>>>
> >>>>>>>> /usr/bin/convert -density 125
> >>>>>>>> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf +profile
> >>>>>>>> '*' -quality 100
> >>>>>>>> /usr/lib/red5/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
> >>>>>>>>
> >>>>>>>> Greetings Peter
> >>>>>>>>
> >>>>>>>> Am 15.05.19 um 13:15 schrieb Peter Dähn:
> >>>>>>>>> Hi,
> >>>>>>>>>
> >>>>>>>>> I had a little problem during the last update (from 3.0.7 to 4.0.8). I
> >>>>>>>>> didn't realise, that ffmpeg didn't work after server update. The
> >>>>>>>>> following om update went throug, despite the fact, that
> >>>>>>>>> screen-recordings were not converted.
> >>>>>>>>>
> >>>>>>>>> That why I needed to figure out (with a little bit help of Maxim) how to
> >>>>>>>>> manage that afterwards. I would like to share my steps, in case someone
> >>>>>>>>> has a similar problem.
> >>>>>>>>>
> >>>>>>>>> 1. Get needed information from database (in my case it is postgres)
> >>>>>>>>>
> >>>>>>>>>  select id,hash from om_file where deleted=false and type='Recording'
> >>>>>>>>> and dtype='Recording' order by id;
> >>>>>>>>>
> >>>>>>>>> 2. save the result in a text file e.g. convert_recordings.txt
> >>>>>>>>>
> >>>>>>>>> 3. prepare a little script (linux/bash)
> >>>>>>>>>
> >>>>>>>>> #!/bin/bash
> >>>>>>>>> i=0
> >>>>>>>>> while read line
> >>>>>>>>> do
> >>>>>>>>>    #echo "$line"
> >>>>>>>>>    id=`echo $line | awk '{split($0, a, "|"); print a[1]}'`
> >>>>>>>>>    #echo $id
> >>>>>>>>>    hash=`echo $line | awk '{split($0, a, "|"); print a[2]}'`
> >>>>>>>>>    #echo $hash
> >>>>>>>>> #   echo "bearbeite $id"
> >>>>>>>>>    command_mp4="/usr/local/bin/ffmpeg -y -nostdin -i
> >>>>>>>>> /OM_OLD_DIR/webapps/openmeetings/data/streams/hibernate/flvRecording_$id.avi
> >>>>>>>>> -c:v h264 -crf 24 -pix_fmt yuv420p -preset medium -profile:v baseline
> >>>>>>>>> -level 3.0 -movflags faststart -c:a aac -ar 22050 -b:a 32k
> >>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4"
> >>>>>>>>> #   echo $command_mp4
> >>>>>>>>>    command_png="/usr/local/bin/ffmpeg -y -nostdin -i
> >>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4 -vf
> >>>>>>>>> thumbnail,scale=640:-1 -frames:v 1
> >>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.png"
> >>>>>>>>> #   echo $command_png
> >>>>>>>>>    $command_mp4
> >>>>>>>>>    $command_png
> >>>>>>>>> done < convert_recordings.txt
> >>>>>>>>>
> >>>>>>>>> 4. wait a looooong time (I had over 500 videos)
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>> Maybe ffmpeg command is a bit different for other versions.
> >>>>>>>>>
> >>>>>>>>> Greetings Peter
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>
> >
>


--
WBR
Maxim aka solomax

Re: conversion problem during update

Posted by Maxim Solodovnik <so...@gmail.com>.
Steps:
1) Install ImageMagic
2) create empty folder, cd into this folder, put any PDF file to it
Using terminal/console app
3) run
`PATH_TO_IMAGIC_BIN/convert -density 125 NAME_OF_PDF.pdf +profile
'*' -quality 100 page-%04d.png`

should be no errors
(NOTE PDF conversion might be blocked in ImageMagic policy.xml file)

On Thu, 11 Jul 2019 at 14:29, Xavier M <xa...@hotmail.com> wrote:
>
> Hi,
>
> I'm a Mac user at work - be aware that it is not a server on the web. I do not fully understand the point, but if you detail me the steps, I can maybe help? I'll find time to do on Monday or Tuesday.
>
> Xavier
>
> ________________________________
> De : Peter Dähn <da...@vcrp.de>
> Envoyé : jeudi 11 juillet 2019 09:13
> À : user@openmeetings.apache.org
> Objet : Re: conversion problem during update
>
> I will ask MAC user around here...
>
> Am 11.07.19 um 08:32 schrieb Maxim Solodovnik:
> > I can test it on Windows
> > Not on Mac :(
> >
> > should be easy:
> > 1) install ImageMagic
> > 2) run command
> > 3) report back :)
> >
> > Are there any volunteers?
> >
> > On Thu, 11 Jul 2019 at 13:29, Peter Dähn <da...@vcrp.de> wrote:
> >> you are right... I simply try to keep it in mind... Maybe updates to
> >> 5.0.x will be done by moving to a new server. I think complete migration
> >> with conversion etc. will to be tested by more admins... ;-)
> >>
> >> Greetings Peter
> >>
> >> Am 11.07.19 um 08:17 schrieb Maxim Solodovnik:
> >>> Actually this is "one minute task" BUT
> >>> Someone need to test it using Win and Mac (I guess it will work on Linux)
> >>>
> >>> On Thu, 11 Jul 2019 at 13:15, Peter Dähn <da...@vcrp.de> wrote:
> >>>> Hi Maxim,
> >>>>
> >>>> seems to be. Does it hurt to add that parameter anyway?
> >>>>
> >>>> Greetigs Peter
> >>>>
> >>>> Am 11.07.19 um 07:17 schrieb Maxim Solodovnik:
> >>>>> No answers for a long time
> >>>>> I guess this one is not a common problem
> >>>>>
> >>>>> On Mon, 3 Jun 2019 at 13:44, Peter Dähn <da...@vcrp.de> wrote:
> >>>>>> Hi Maxim,
> >>>>>>
> >>>>>> you are right, to add this would help, if it is a common problem.
> >>>>>>
> >>>>>> This is a really old file. It seems that it was already a pdf-file.
> >>>>>> Original content of the folder was
> >>>>>>
> >>>>>> HASH.pdf, HASH.swf, library.xml and for each page of the pdf a
> >>>>>> _thumb_page-XXXX.jpg.
> >>>>>>
> >>>>>> Greetings Peter
> >>>>>>
> >>>>>> Am 31.05.19 um 18:39 schrieb Maxim Solodovnik:
> >>>>>>> Hello Peter,
> >>>>>>>
> >>>>>>> I guess you propose to add "profile" param to OM code :)
> >>>>>>> I'm OK with it, could you check if your original document is being
> >>>>>>> converted by OM UI as expected or not?
> >>>>>>>
> >>>>>>> On Fri, 31 May 2019 at 20:03, Peter Dähn <da...@vcrp.de> wrote:
> >>>>>>>> Hi Maxim,
> >>>>>>>>
> >>>>>>>> I needed to convert some room files afterwards. I user command out of
> >>>>>>>> the logs and got for some files an error.
> >>>>>>>>
> >>>>>>>> /usr/bin/convert -density 125
> >>>>>>>> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf -quality
> >>>>>>>> 100 /SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
> >>>>>>>>
> >>>>>>>> convert: profile 'icc': 'RGB ': RGB color space not permitted on
> >>>>>>>> grayscale PNG
> >>>>>>>> `/SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png' @
> >>>>>>>> warning/png.c/MagickPNGWarningHandler/1654.
> >>>>>>>>
> >>>>>>>> I needed to add parameter +profile '*' . Now convert is working without
> >>>>>>>> error.
> >>>>>>>>
> >>>>>>>> /usr/bin/convert -density 125
> >>>>>>>> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf +profile
> >>>>>>>> '*' -quality 100
> >>>>>>>> /usr/lib/red5/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
> >>>>>>>>
> >>>>>>>> Greetings Peter
> >>>>>>>>
> >>>>>>>> Am 15.05.19 um 13:15 schrieb Peter Dähn:
> >>>>>>>>> Hi,
> >>>>>>>>>
> >>>>>>>>> I had a little problem during the last update (from 3.0.7 to 4.0.8). I
> >>>>>>>>> didn't realise, that ffmpeg didn't work after server update. The
> >>>>>>>>> following om update went throug, despite the fact, that
> >>>>>>>>> screen-recordings were not converted.
> >>>>>>>>>
> >>>>>>>>> That why I needed to figure out (with a little bit help of Maxim) how to
> >>>>>>>>> manage that afterwards. I would like to share my steps, in case someone
> >>>>>>>>> has a similar problem.
> >>>>>>>>>
> >>>>>>>>> 1. Get needed information from database (in my case it is postgres)
> >>>>>>>>>
> >>>>>>>>>  select id,hash from om_file where deleted=false and type='Recording'
> >>>>>>>>> and dtype='Recording' order by id;
> >>>>>>>>>
> >>>>>>>>> 2. save the result in a text file e.g. convert_recordings.txt
> >>>>>>>>>
> >>>>>>>>> 3. prepare a little script (linux/bash)
> >>>>>>>>>
> >>>>>>>>> #!/bin/bash
> >>>>>>>>> i=0
> >>>>>>>>> while read line
> >>>>>>>>> do
> >>>>>>>>>    #echo "$line"
> >>>>>>>>>    id=`echo $line | awk '{split($0, a, "|"); print a[1]}'`
> >>>>>>>>>    #echo $id
> >>>>>>>>>    hash=`echo $line | awk '{split($0, a, "|"); print a[2]}'`
> >>>>>>>>>    #echo $hash
> >>>>>>>>> #   echo "bearbeite $id"
> >>>>>>>>>    command_mp4="/usr/local/bin/ffmpeg -y -nostdin -i
> >>>>>>>>> /OM_OLD_DIR/webapps/openmeetings/data/streams/hibernate/flvRecording_$id.avi
> >>>>>>>>> -c:v h264 -crf 24 -pix_fmt yuv420p -preset medium -profile:v baseline
> >>>>>>>>> -level 3.0 -movflags faststart -c:a aac -ar 22050 -b:a 32k
> >>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4"
> >>>>>>>>> #   echo $command_mp4
> >>>>>>>>>    command_png="/usr/local/bin/ffmpeg -y -nostdin -i
> >>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4 -vf
> >>>>>>>>> thumbnail,scale=640:-1 -frames:v 1
> >>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.png"
> >>>>>>>>> #   echo $command_png
> >>>>>>>>>    $command_mp4
> >>>>>>>>>    $command_png
> >>>>>>>>> done < convert_recordings.txt
> >>>>>>>>>
> >>>>>>>>> 4. wait a looooong time (I had over 500 videos)
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>> Maybe ffmpeg command is a bit different for other versions.
> >>>>>>>>>
> >>>>>>>>> Greetings Peter
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>
> >
>


-- 
WBR
Maxim aka solomax

RE: conversion problem during update

Posted by Xavier M <xa...@hotmail.com>.
Hi,

I'm a Mac user at work - be aware that it is not a server on the web. I do not fully understand the point, but if you detail me the steps, I can maybe help? I'll find time to do on Monday or Tuesday.

Xavier

________________________________
De : Peter Dähn <da...@vcrp.de>
Envoyé : jeudi 11 juillet 2019 09:13
À : user@openmeetings.apache.org
Objet : Re: conversion problem during update

I will ask MAC user around here...

Am 11.07.19 um 08:32 schrieb Maxim Solodovnik:
> I can test it on Windows
> Not on Mac :(
>
> should be easy:
> 1) install ImageMagic
> 2) run command
> 3) report back :)
>
> Are there any volunteers?
>
> On Thu, 11 Jul 2019 at 13:29, Peter Dähn <da...@vcrp.de> wrote:
>> you are right... I simply try to keep it in mind... Maybe updates to
>> 5.0.x will be done by moving to a new server. I think complete migration
>> with conversion etc. will to be tested by more admins... ;-)
>>
>> Greetings Peter
>>
>> Am 11.07.19 um 08:17 schrieb Maxim Solodovnik:
>>> Actually this is "one minute task" BUT
>>> Someone need to test it using Win and Mac (I guess it will work on Linux)
>>>
>>> On Thu, 11 Jul 2019 at 13:15, Peter Dähn <da...@vcrp.de> wrote:
>>>> Hi Maxim,
>>>>
>>>> seems to be. Does it hurt to add that parameter anyway?
>>>>
>>>> Greetigs Peter
>>>>
>>>> Am 11.07.19 um 07:17 schrieb Maxim Solodovnik:
>>>>> No answers for a long time
>>>>> I guess this one is not a common problem
>>>>>
>>>>> On Mon, 3 Jun 2019 at 13:44, Peter Dähn <da...@vcrp.de> wrote:
>>>>>> Hi Maxim,
>>>>>>
>>>>>> you are right, to add this would help, if it is a common problem.
>>>>>>
>>>>>> This is a really old file. It seems that it was already a pdf-file.
>>>>>> Original content of the folder was
>>>>>>
>>>>>> HASH.pdf, HASH.swf, library.xml and for each page of the pdf a
>>>>>> _thumb_page-XXXX.jpg.
>>>>>>
>>>>>> Greetings Peter
>>>>>>
>>>>>> Am 31.05.19 um 18:39 schrieb Maxim Solodovnik:
>>>>>>> Hello Peter,
>>>>>>>
>>>>>>> I guess you propose to add "profile" param to OM code :)
>>>>>>> I'm OK with it, could you check if your original document is being
>>>>>>> converted by OM UI as expected or not?
>>>>>>>
>>>>>>> On Fri, 31 May 2019 at 20:03, Peter Dähn <da...@vcrp.de> wrote:
>>>>>>>> Hi Maxim,
>>>>>>>>
>>>>>>>> I needed to convert some room files afterwards. I user command out of
>>>>>>>> the logs and got for some files an error.
>>>>>>>>
>>>>>>>> /usr/bin/convert -density 125
>>>>>>>> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf -quality
>>>>>>>> 100 /SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
>>>>>>>>
>>>>>>>> convert: profile 'icc': 'RGB ': RGB color space not permitted on
>>>>>>>> grayscale PNG
>>>>>>>> `/SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png' @
>>>>>>>> warning/png.c/MagickPNGWarningHandler/1654.
>>>>>>>>
>>>>>>>> I needed to add parameter +profile '*' . Now convert is working without
>>>>>>>> error.
>>>>>>>>
>>>>>>>> /usr/bin/convert -density 125
>>>>>>>> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf +profile
>>>>>>>> '*' -quality 100
>>>>>>>> /usr/lib/red5/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
>>>>>>>>
>>>>>>>> Greetings Peter
>>>>>>>>
>>>>>>>> Am 15.05.19 um 13:15 schrieb Peter Dähn:
>>>>>>>>> Hi,
>>>>>>>>>
>>>>>>>>> I had a little problem during the last update (from 3.0.7 to 4.0.8). I
>>>>>>>>> didn't realise, that ffmpeg didn't work after server update. The
>>>>>>>>> following om update went throug, despite the fact, that
>>>>>>>>> screen-recordings were not converted.
>>>>>>>>>
>>>>>>>>> That why I needed to figure out (with a little bit help of Maxim) how to
>>>>>>>>> manage that afterwards. I would like to share my steps, in case someone
>>>>>>>>> has a similar problem.
>>>>>>>>>
>>>>>>>>> 1. Get needed information from database (in my case it is postgres)
>>>>>>>>>
>>>>>>>>>  select id,hash from om_file where deleted=false and type='Recording'
>>>>>>>>> and dtype='Recording' order by id;
>>>>>>>>>
>>>>>>>>> 2. save the result in a text file e.g. convert_recordings.txt
>>>>>>>>>
>>>>>>>>> 3. prepare a little script (linux/bash)
>>>>>>>>>
>>>>>>>>> #!/bin/bash
>>>>>>>>> i=0
>>>>>>>>> while read line
>>>>>>>>> do
>>>>>>>>>    #echo "$line"
>>>>>>>>>    id=`echo $line | awk '{split($0, a, "|"); print a[1]}'`
>>>>>>>>>    #echo $id
>>>>>>>>>    hash=`echo $line | awk '{split($0, a, "|"); print a[2]}'`
>>>>>>>>>    #echo $hash
>>>>>>>>> #   echo "bearbeite $id"
>>>>>>>>>    command_mp4="/usr/local/bin/ffmpeg -y -nostdin -i
>>>>>>>>> /OM_OLD_DIR/webapps/openmeetings/data/streams/hibernate/flvRecording_$id.avi
>>>>>>>>> -c:v h264 -crf 24 -pix_fmt yuv420p -preset medium -profile:v baseline
>>>>>>>>> -level 3.0 -movflags faststart -c:a aac -ar 22050 -b:a 32k
>>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4"
>>>>>>>>> #   echo $command_mp4
>>>>>>>>>    command_png="/usr/local/bin/ffmpeg -y -nostdin -i
>>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4 -vf
>>>>>>>>> thumbnail,scale=640:-1 -frames:v 1
>>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.png"
>>>>>>>>> #   echo $command_png
>>>>>>>>>    $command_mp4
>>>>>>>>>    $command_png
>>>>>>>>> done < convert_recordings.txt
>>>>>>>>>
>>>>>>>>> 4. wait a looooong time (I had over 500 videos)
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Maybe ffmpeg command is a bit different for other versions.
>>>>>>>>>
>>>>>>>>> Greetings Peter
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>
>


Re: conversion problem during update

Posted by Peter Dähn <da...@vcrp.de>.
I will ask MAC user around here...

Am 11.07.19 um 08:32 schrieb Maxim Solodovnik:
> I can test it on Windows
> Not on Mac :(
>
> should be easy:
> 1) install ImageMagic
> 2) run command
> 3) report back :)
>
> Are there any volunteers?
>
> On Thu, 11 Jul 2019 at 13:29, Peter Dähn <da...@vcrp.de> wrote:
>> you are right... I simply try to keep it in mind... Maybe updates to
>> 5.0.x will be done by moving to a new server. I think complete migration
>> with conversion etc. will to be tested by more admins... ;-)
>>
>> Greetings Peter
>>
>> Am 11.07.19 um 08:17 schrieb Maxim Solodovnik:
>>> Actually this is "one minute task" BUT
>>> Someone need to test it using Win and Mac (I guess it will work on Linux)
>>>
>>> On Thu, 11 Jul 2019 at 13:15, Peter Dähn <da...@vcrp.de> wrote:
>>>> Hi Maxim,
>>>>
>>>> seems to be. Does it hurt to add that parameter anyway?
>>>>
>>>> Greetigs Peter
>>>>
>>>> Am 11.07.19 um 07:17 schrieb Maxim Solodovnik:
>>>>> No answers for a long time
>>>>> I guess this one is not a common problem
>>>>>
>>>>> On Mon, 3 Jun 2019 at 13:44, Peter Dähn <da...@vcrp.de> wrote:
>>>>>> Hi Maxim,
>>>>>>
>>>>>> you are right, to add this would help, if it is a common problem.
>>>>>>
>>>>>> This is a really old file. It seems that it was already a pdf-file.
>>>>>> Original content of the folder was
>>>>>>
>>>>>> HASH.pdf, HASH.swf, library.xml and for each page of the pdf a
>>>>>> _thumb_page-XXXX.jpg.
>>>>>>
>>>>>> Greetings Peter
>>>>>>
>>>>>> Am 31.05.19 um 18:39 schrieb Maxim Solodovnik:
>>>>>>> Hello Peter,
>>>>>>>
>>>>>>> I guess you propose to add "profile" param to OM code :)
>>>>>>> I'm OK with it, could you check if your original document is being
>>>>>>> converted by OM UI as expected or not?
>>>>>>>
>>>>>>> On Fri, 31 May 2019 at 20:03, Peter Dähn <da...@vcrp.de> wrote:
>>>>>>>> Hi Maxim,
>>>>>>>>
>>>>>>>> I needed to convert some room files afterwards. I user command out of
>>>>>>>> the logs and got for some files an error.
>>>>>>>>
>>>>>>>> /usr/bin/convert -density 125
>>>>>>>> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf -quality
>>>>>>>> 100 /SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
>>>>>>>>
>>>>>>>> convert: profile 'icc': 'RGB ': RGB color space not permitted on
>>>>>>>> grayscale PNG
>>>>>>>> `/SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png' @
>>>>>>>> warning/png.c/MagickPNGWarningHandler/1654.
>>>>>>>>
>>>>>>>> I needed to add parameter +profile '*' . Now convert is working without
>>>>>>>> error.
>>>>>>>>
>>>>>>>> /usr/bin/convert -density 125
>>>>>>>> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf +profile
>>>>>>>> '*' -quality 100
>>>>>>>> /usr/lib/red5/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
>>>>>>>>
>>>>>>>> Greetings Peter
>>>>>>>>
>>>>>>>> Am 15.05.19 um 13:15 schrieb Peter Dähn:
>>>>>>>>> Hi,
>>>>>>>>>
>>>>>>>>> I had a little problem during the last update (from 3.0.7 to 4.0.8). I
>>>>>>>>> didn't realise, that ffmpeg didn't work after server update. The
>>>>>>>>> following om update went throug, despite the fact, that
>>>>>>>>> screen-recordings were not converted.
>>>>>>>>>
>>>>>>>>> That why I needed to figure out (with a little bit help of Maxim) how to
>>>>>>>>> manage that afterwards. I would like to share my steps, in case someone
>>>>>>>>> has a similar problem.
>>>>>>>>>
>>>>>>>>> 1. Get needed information from database (in my case it is postgres)
>>>>>>>>>
>>>>>>>>>  select id,hash from om_file where deleted=false and type='Recording'
>>>>>>>>> and dtype='Recording' order by id;
>>>>>>>>>
>>>>>>>>> 2. save the result in a text file e.g. convert_recordings.txt
>>>>>>>>>
>>>>>>>>> 3. prepare a little script (linux/bash)
>>>>>>>>>
>>>>>>>>> #!/bin/bash
>>>>>>>>> i=0
>>>>>>>>> while read line
>>>>>>>>> do
>>>>>>>>>    #echo "$line"
>>>>>>>>>    id=`echo $line | awk '{split($0, a, "|"); print a[1]}'`
>>>>>>>>>    #echo $id
>>>>>>>>>    hash=`echo $line | awk '{split($0, a, "|"); print a[2]}'`
>>>>>>>>>    #echo $hash
>>>>>>>>> #   echo "bearbeite $id"
>>>>>>>>>    command_mp4="/usr/local/bin/ffmpeg -y -nostdin -i
>>>>>>>>> /OM_OLD_DIR/webapps/openmeetings/data/streams/hibernate/flvRecording_$id.avi
>>>>>>>>> -c:v h264 -crf 24 -pix_fmt yuv420p -preset medium -profile:v baseline
>>>>>>>>> -level 3.0 -movflags faststart -c:a aac -ar 22050 -b:a 32k
>>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4"
>>>>>>>>> #   echo $command_mp4
>>>>>>>>>    command_png="/usr/local/bin/ffmpeg -y -nostdin -i
>>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4 -vf
>>>>>>>>> thumbnail,scale=640:-1 -frames:v 1
>>>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.png"
>>>>>>>>> #   echo $command_png
>>>>>>>>>    $command_mp4
>>>>>>>>>    $command_png
>>>>>>>>> done < convert_recordings.txt
>>>>>>>>>
>>>>>>>>> 4. wait a looooong time (I had over 500 videos)
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Maybe ffmpeg command is a bit different for other versions.
>>>>>>>>>
>>>>>>>>> Greetings Peter
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>
>


Re: conversion problem during update

Posted by Maxim Solodovnik <so...@gmail.com>.
I can test it on Windows
Not on Mac :(

should be easy:
1) install ImageMagic
2) run command
3) report back :)

Are there any volunteers?

On Thu, 11 Jul 2019 at 13:29, Peter Dähn <da...@vcrp.de> wrote:
>
> you are right... I simply try to keep it in mind... Maybe updates to
> 5.0.x will be done by moving to a new server. I think complete migration
> with conversion etc. will to be tested by more admins... ;-)
>
> Greetings Peter
>
> Am 11.07.19 um 08:17 schrieb Maxim Solodovnik:
> > Actually this is "one minute task" BUT
> > Someone need to test it using Win and Mac (I guess it will work on Linux)
> >
> > On Thu, 11 Jul 2019 at 13:15, Peter Dähn <da...@vcrp.de> wrote:
> >> Hi Maxim,
> >>
> >> seems to be. Does it hurt to add that parameter anyway?
> >>
> >> Greetigs Peter
> >>
> >> Am 11.07.19 um 07:17 schrieb Maxim Solodovnik:
> >>> No answers for a long time
> >>> I guess this one is not a common problem
> >>>
> >>> On Mon, 3 Jun 2019 at 13:44, Peter Dähn <da...@vcrp.de> wrote:
> >>>> Hi Maxim,
> >>>>
> >>>> you are right, to add this would help, if it is a common problem.
> >>>>
> >>>> This is a really old file. It seems that it was already a pdf-file.
> >>>> Original content of the folder was
> >>>>
> >>>> HASH.pdf, HASH.swf, library.xml and for each page of the pdf a
> >>>> _thumb_page-XXXX.jpg.
> >>>>
> >>>> Greetings Peter
> >>>>
> >>>> Am 31.05.19 um 18:39 schrieb Maxim Solodovnik:
> >>>>> Hello Peter,
> >>>>>
> >>>>> I guess you propose to add "profile" param to OM code :)
> >>>>> I'm OK with it, could you check if your original document is being
> >>>>> converted by OM UI as expected or not?
> >>>>>
> >>>>> On Fri, 31 May 2019 at 20:03, Peter Dähn <da...@vcrp.de> wrote:
> >>>>>> Hi Maxim,
> >>>>>>
> >>>>>> I needed to convert some room files afterwards. I user command out of
> >>>>>> the logs and got for some files an error.
> >>>>>>
> >>>>>> /usr/bin/convert -density 125
> >>>>>> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf -quality
> >>>>>> 100 /SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
> >>>>>>
> >>>>>> convert: profile 'icc': 'RGB ': RGB color space not permitted on
> >>>>>> grayscale PNG
> >>>>>> `/SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png' @
> >>>>>> warning/png.c/MagickPNGWarningHandler/1654.
> >>>>>>
> >>>>>> I needed to add parameter +profile '*' . Now convert is working without
> >>>>>> error.
> >>>>>>
> >>>>>> /usr/bin/convert -density 125
> >>>>>> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf +profile
> >>>>>> '*' -quality 100
> >>>>>> /usr/lib/red5/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
> >>>>>>
> >>>>>> Greetings Peter
> >>>>>>
> >>>>>> Am 15.05.19 um 13:15 schrieb Peter Dähn:
> >>>>>>> Hi,
> >>>>>>>
> >>>>>>> I had a little problem during the last update (from 3.0.7 to 4.0.8). I
> >>>>>>> didn't realise, that ffmpeg didn't work after server update. The
> >>>>>>> following om update went throug, despite the fact, that
> >>>>>>> screen-recordings were not converted.
> >>>>>>>
> >>>>>>> That why I needed to figure out (with a little bit help of Maxim) how to
> >>>>>>> manage that afterwards. I would like to share my steps, in case someone
> >>>>>>> has a similar problem.
> >>>>>>>
> >>>>>>> 1. Get needed information from database (in my case it is postgres)
> >>>>>>>
> >>>>>>>  select id,hash from om_file where deleted=false and type='Recording'
> >>>>>>> and dtype='Recording' order by id;
> >>>>>>>
> >>>>>>> 2. save the result in a text file e.g. convert_recordings.txt
> >>>>>>>
> >>>>>>> 3. prepare a little script (linux/bash)
> >>>>>>>
> >>>>>>> #!/bin/bash
> >>>>>>> i=0
> >>>>>>> while read line
> >>>>>>> do
> >>>>>>>    #echo "$line"
> >>>>>>>    id=`echo $line | awk '{split($0, a, "|"); print a[1]}'`
> >>>>>>>    #echo $id
> >>>>>>>    hash=`echo $line | awk '{split($0, a, "|"); print a[2]}'`
> >>>>>>>    #echo $hash
> >>>>>>> #   echo "bearbeite $id"
> >>>>>>>    command_mp4="/usr/local/bin/ffmpeg -y -nostdin -i
> >>>>>>> /OM_OLD_DIR/webapps/openmeetings/data/streams/hibernate/flvRecording_$id.avi
> >>>>>>> -c:v h264 -crf 24 -pix_fmt yuv420p -preset medium -profile:v baseline
> >>>>>>> -level 3.0 -movflags faststart -c:a aac -ar 22050 -b:a 32k
> >>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4"
> >>>>>>> #   echo $command_mp4
> >>>>>>>    command_png="/usr/local/bin/ffmpeg -y -nostdin -i
> >>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4 -vf
> >>>>>>> thumbnail,scale=640:-1 -frames:v 1
> >>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.png"
> >>>>>>> #   echo $command_png
> >>>>>>>    $command_mp4
> >>>>>>>    $command_png
> >>>>>>> done < convert_recordings.txt
> >>>>>>>
> >>>>>>> 4. wait a looooong time (I had over 500 videos)
> >>>>>>>
> >>>>>>>
> >>>>>>> Maybe ffmpeg command is a bit different for other versions.
> >>>>>>>
> >>>>>>> Greetings Peter
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >
>
>


-- 
WBR
Maxim aka solomax

Re: conversion problem during update

Posted by Peter Dähn <da...@vcrp.de>.
you are right... I simply try to keep it in mind... Maybe updates to
5.0.x will be done by moving to a new server. I think complete migration
with conversion etc. will to be tested by more admins... ;-)

Greetings Peter

Am 11.07.19 um 08:17 schrieb Maxim Solodovnik:
> Actually this is "one minute task" BUT
> Someone need to test it using Win and Mac (I guess it will work on Linux)
>
> On Thu, 11 Jul 2019 at 13:15, Peter Dähn <da...@vcrp.de> wrote:
>> Hi Maxim,
>>
>> seems to be. Does it hurt to add that parameter anyway?
>>
>> Greetigs Peter
>>
>> Am 11.07.19 um 07:17 schrieb Maxim Solodovnik:
>>> No answers for a long time
>>> I guess this one is not a common problem
>>>
>>> On Mon, 3 Jun 2019 at 13:44, Peter Dähn <da...@vcrp.de> wrote:
>>>> Hi Maxim,
>>>>
>>>> you are right, to add this would help, if it is a common problem.
>>>>
>>>> This is a really old file. It seems that it was already a pdf-file.
>>>> Original content of the folder was
>>>>
>>>> HASH.pdf, HASH.swf, library.xml and for each page of the pdf a
>>>> _thumb_page-XXXX.jpg.
>>>>
>>>> Greetings Peter
>>>>
>>>> Am 31.05.19 um 18:39 schrieb Maxim Solodovnik:
>>>>> Hello Peter,
>>>>>
>>>>> I guess you propose to add "profile" param to OM code :)
>>>>> I'm OK with it, could you check if your original document is being
>>>>> converted by OM UI as expected or not?
>>>>>
>>>>> On Fri, 31 May 2019 at 20:03, Peter Dähn <da...@vcrp.de> wrote:
>>>>>> Hi Maxim,
>>>>>>
>>>>>> I needed to convert some room files afterwards. I user command out of
>>>>>> the logs and got for some files an error.
>>>>>>
>>>>>> /usr/bin/convert -density 125
>>>>>> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf -quality
>>>>>> 100 /SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
>>>>>>
>>>>>> convert: profile 'icc': 'RGB ': RGB color space not permitted on
>>>>>> grayscale PNG
>>>>>> `/SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png' @
>>>>>> warning/png.c/MagickPNGWarningHandler/1654.
>>>>>>
>>>>>> I needed to add parameter +profile '*' . Now convert is working without
>>>>>> error.
>>>>>>
>>>>>> /usr/bin/convert -density 125
>>>>>> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf +profile
>>>>>> '*' -quality 100
>>>>>> /usr/lib/red5/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
>>>>>>
>>>>>> Greetings Peter
>>>>>>
>>>>>> Am 15.05.19 um 13:15 schrieb Peter Dähn:
>>>>>>> Hi,
>>>>>>>
>>>>>>> I had a little problem during the last update (from 3.0.7 to 4.0.8). I
>>>>>>> didn't realise, that ffmpeg didn't work after server update. The
>>>>>>> following om update went throug, despite the fact, that
>>>>>>> screen-recordings were not converted.
>>>>>>>
>>>>>>> That why I needed to figure out (with a little bit help of Maxim) how to
>>>>>>> manage that afterwards. I would like to share my steps, in case someone
>>>>>>> has a similar problem.
>>>>>>>
>>>>>>> 1. Get needed information from database (in my case it is postgres)
>>>>>>>
>>>>>>>  select id,hash from om_file where deleted=false and type='Recording'
>>>>>>> and dtype='Recording' order by id;
>>>>>>>
>>>>>>> 2. save the result in a text file e.g. convert_recordings.txt
>>>>>>>
>>>>>>> 3. prepare a little script (linux/bash)
>>>>>>>
>>>>>>> #!/bin/bash
>>>>>>> i=0
>>>>>>> while read line
>>>>>>> do
>>>>>>>    #echo "$line"
>>>>>>>    id=`echo $line | awk '{split($0, a, "|"); print a[1]}'`
>>>>>>>    #echo $id
>>>>>>>    hash=`echo $line | awk '{split($0, a, "|"); print a[2]}'`
>>>>>>>    #echo $hash
>>>>>>> #   echo "bearbeite $id"
>>>>>>>    command_mp4="/usr/local/bin/ffmpeg -y -nostdin -i
>>>>>>> /OM_OLD_DIR/webapps/openmeetings/data/streams/hibernate/flvRecording_$id.avi
>>>>>>> -c:v h264 -crf 24 -pix_fmt yuv420p -preset medium -profile:v baseline
>>>>>>> -level 3.0 -movflags faststart -c:a aac -ar 22050 -b:a 32k
>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4"
>>>>>>> #   echo $command_mp4
>>>>>>>    command_png="/usr/local/bin/ffmpeg -y -nostdin -i
>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4 -vf
>>>>>>> thumbnail,scale=640:-1 -frames:v 1
>>>>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.png"
>>>>>>> #   echo $command_png
>>>>>>>    $command_mp4
>>>>>>>    $command_png
>>>>>>> done < convert_recordings.txt
>>>>>>>
>>>>>>> 4. wait a looooong time (I had over 500 videos)
>>>>>>>
>>>>>>>
>>>>>>> Maybe ffmpeg command is a bit different for other versions.
>>>>>>>
>>>>>>> Greetings Peter
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>



Re: conversion problem during update

Posted by Maxim Solodovnik <so...@gmail.com>.
Actually this is "one minute task" BUT
Someone need to test it using Win and Mac (I guess it will work on Linux)

On Thu, 11 Jul 2019 at 13:15, Peter Dähn <da...@vcrp.de> wrote:
>
> Hi Maxim,
>
> seems to be. Does it hurt to add that parameter anyway?
>
> Greetigs Peter
>
> Am 11.07.19 um 07:17 schrieb Maxim Solodovnik:
> > No answers for a long time
> > I guess this one is not a common problem
> >
> > On Mon, 3 Jun 2019 at 13:44, Peter Dähn <da...@vcrp.de> wrote:
> >> Hi Maxim,
> >>
> >> you are right, to add this would help, if it is a common problem.
> >>
> >> This is a really old file. It seems that it was already a pdf-file.
> >> Original content of the folder was
> >>
> >> HASH.pdf, HASH.swf, library.xml and for each page of the pdf a
> >> _thumb_page-XXXX.jpg.
> >>
> >> Greetings Peter
> >>
> >> Am 31.05.19 um 18:39 schrieb Maxim Solodovnik:
> >>> Hello Peter,
> >>>
> >>> I guess you propose to add "profile" param to OM code :)
> >>> I'm OK with it, could you check if your original document is being
> >>> converted by OM UI as expected or not?
> >>>
> >>> On Fri, 31 May 2019 at 20:03, Peter Dähn <da...@vcrp.de> wrote:
> >>>> Hi Maxim,
> >>>>
> >>>> I needed to convert some room files afterwards. I user command out of
> >>>> the logs and got for some files an error.
> >>>>
> >>>> /usr/bin/convert -density 125
> >>>> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf -quality
> >>>> 100 /SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
> >>>>
> >>>> convert: profile 'icc': 'RGB ': RGB color space not permitted on
> >>>> grayscale PNG
> >>>> `/SERVER/webapps/openmeetings/data/upload/files/HASH/page-%04d.png' @
> >>>> warning/png.c/MagickPNGWarningHandler/1654.
> >>>>
> >>>> I needed to add parameter +profile '*' . Now convert is working without
> >>>> error.
> >>>>
> >>>> /usr/bin/convert -density 125
> >>>> /SERVER/webapps/openmeetings/data/upload/files/HASH/HASH.pdf +profile
> >>>> '*' -quality 100
> >>>> /usr/lib/red5/webapps/openmeetings/data/upload/files/HASH/page-%04d.png
> >>>>
> >>>> Greetings Peter
> >>>>
> >>>> Am 15.05.19 um 13:15 schrieb Peter Dähn:
> >>>>> Hi,
> >>>>>
> >>>>> I had a little problem during the last update (from 3.0.7 to 4.0.8). I
> >>>>> didn't realise, that ffmpeg didn't work after server update. The
> >>>>> following om update went throug, despite the fact, that
> >>>>> screen-recordings were not converted.
> >>>>>
> >>>>> That why I needed to figure out (with a little bit help of Maxim) how to
> >>>>> manage that afterwards. I would like to share my steps, in case someone
> >>>>> has a similar problem.
> >>>>>
> >>>>> 1. Get needed information from database (in my case it is postgres)
> >>>>>
> >>>>>  select id,hash from om_file where deleted=false and type='Recording'
> >>>>> and dtype='Recording' order by id;
> >>>>>
> >>>>> 2. save the result in a text file e.g. convert_recordings.txt
> >>>>>
> >>>>> 3. prepare a little script (linux/bash)
> >>>>>
> >>>>> #!/bin/bash
> >>>>> i=0
> >>>>> while read line
> >>>>> do
> >>>>>    #echo "$line"
> >>>>>    id=`echo $line | awk '{split($0, a, "|"); print a[1]}'`
> >>>>>    #echo $id
> >>>>>    hash=`echo $line | awk '{split($0, a, "|"); print a[2]}'`
> >>>>>    #echo $hash
> >>>>> #   echo "bearbeite $id"
> >>>>>    command_mp4="/usr/local/bin/ffmpeg -y -nostdin -i
> >>>>> /OM_OLD_DIR/webapps/openmeetings/data/streams/hibernate/flvRecording_$id.avi
> >>>>> -c:v h264 -crf 24 -pix_fmt yuv420p -preset medium -profile:v baseline
> >>>>> -level 3.0 -movflags faststart -c:a aac -ar 22050 -b:a 32k
> >>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4"
> >>>>> #   echo $command_mp4
> >>>>>    command_png="/usr/local/bin/ffmpeg -y -nostdin -i
> >>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.mp4 -vf
> >>>>> thumbnail,scale=640:-1 -frames:v 1
> >>>>> /OM_DIR/webapps/openmeetings/data/streams/hibernate/$hash.png"
> >>>>> #   echo $command_png
> >>>>>    $command_mp4
> >>>>>    $command_png
> >>>>> done < convert_recordings.txt
> >>>>>
> >>>>> 4. wait a looooong time (I had over 500 videos)
> >>>>>
> >>>>>
> >>>>> Maybe ffmpeg command is a bit different for other versions.
> >>>>>
> >>>>> Greetings Peter
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>
> >
>


-- 
WBR
Maxim aka solomax