Re: User Manual for OpenMeetings 503

[Denis Noctor]

Of course.

Sent from my iPhone

> On Apr 2, 2020, at 10:05 PM, Maxim Solodovnik  wrote:
> 
> This is awesome news :)
> 
> please register at Confluence 
> https://cwiki.apache.org/confluence/display/OPENMEETINGS
> Send me you user id (I'll grant you karma to update pages)
> 
> Let's put it into 
> https://cwiki.apache.org/confluence/display/OPENMEETINGS/Manuals+user+OpenMeetings+various
> 
> I will be happy to review
> Maybe other users can also help :)
> 
>> On Fri, 3 Apr 2020 at 04:06, K. Kamhamea  wrote:
>> Hello,
>> I've written a new user manual for Version 5. The one that I downloaded was 
>> outdated (Version 2). 37 pages of a pdf file so far. The chapters  
>> Installation and Administration are ready, but filled with lots and lots of 
>> questions and suggestions for improvements. Is there someone who wants to 
>> review the manual? Where can I upload the file.
>> Best.
> 
> 
> -- 
> Best regards,
> Maxim

Re: User Manual for OpenMeetings 503

[R. Scholz]

Sure!
Best regards,

René


Am 03.04.2020 um 06:05 schrieb Maxim Solodovnik:

This is awesome news :)

please register at Confluence 
https://cwiki.apache.org/confluence/display/OPENMEETINGS

Send me you user id (I'll grant you karma to update pages)

Let's put it into 
https://cwiki.apache.org/confluence/display/OPENMEETINGS/Manuals+user+OpenMeetings+various


I will be happy to review
Maybe other users can also help :)

On Fri, 3 Apr 2020 at 04:06, K. Kamhamea > wrote:


Hello,
I've written a new user manual for Version 5. The one that I
downloaded was outdated (Version 2). 37 pages of a pdf file so
far. The chapters  Installation and Administration are ready, but
filled with lots and lots of questions and suggestions for
improvements. Is there someone who wants to review the manual?
Where can I upload the file.
Best.



--
Best regards,
Maxim

Re: User Manual for OpenMeetings 503

[Maxim Solodovnik]

This is awesome news :)

please register at Confluence
https://cwiki.apache.org/confluence/display/OPENMEETINGS
Send me you user id (I'll grant you karma to update pages)

Let's put it into
https://cwiki.apache.org/confluence/display/OPENMEETINGS/Manuals+user+OpenMeetings+various

I will be happy to review
Maybe other users can also help :)

On Fri, 3 Apr 2020 at 04:06, K. Kamhamea  wrote:

> Hello,
> I've written a new user manual for Version 5. The one that I downloaded
> was outdated (Version 2). 37 pages of a pdf file so far. The chapters
> Installation and Administration are ready, but filled with lots and lots of
> questions and suggestions for improvements. Is there someone who wants to
> review the manual? Where can I upload the file.
> Best.
>


-- 
Best regards,
Maxim

Re: Installation of OpenMeetings 5.0.0-M3 fails - database connexion ?

[Xavier M]

Hello Maxim,

(previously not on the user list...)


The commands work under MariaDB but:

 * The result is the same at the end of the web installer (using 
openmeetingsbis, see below).


 * I have got a strange behaviour with MariaDB. I indicate here the 
command in the shell, with bold for the strange thing (creation of an 
"openmeetings" user fails while I previously dropped open503):


/~$ sudo mysql -u root -p//
//Enter password: //
//Welcome to the MariaDB monitor.  Commands end with ; or \g.//
//Your MariaDB connection id is 5527//
//Server version: 10.1.44-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04//
//
//Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.//
//
//Type 'help;' or '\h' for help. Type '\c' to clear the current input 
statement.//

//
//MariaDB [(none)]> DROP DATABASE open503;//
//Query OK, 4 rows affected (0.73 sec)//
//
//MariaDB [(none)]> CREATE DATABASE open503 DEFAULT CHARACTER SET 
'utf8mb4';//

//Query OK, 1 row affected (0.00 sec)//
//
//MariaDB [(none)]> CREATE USER 'openmeetings'@'localhost' IDENTIFIED BY 
'some_password';//
//*ERROR 1396 (HY000): Operation CREATE USER failed for 
'openmeetings'@'localhost'*//
//MariaDB [(none)]> CREATE USER 'openmeetingsbis'@'localhost' IDENTIFIED 
BY 'some_password';//

//Query OK, 0 rows affected (0.00 sec)//
//
//MariaDB [(none)]> GRANT ALL PRIVILEGES ON open503.* TO 
'openmeetingsbis'@'localhost';//

//Query OK, 0 rows affected (0.02 sec)//
//
//MariaDB [(none)]> quit//
//Bye/

I don't understand anymore...


Have a good evening,

Xavier


Le 02/04/2020 à 19:19, Maxim Solodovnik a écrit :

Hello Xavier,

unfortunately your sql commands doesn't work for me (I'm using MySql 
NOT MariaDB)

Could you please check if following commands will work for you?

CREATE DATABASE open503 DEFAULT CHARACTER SET 'utf8mb4';
CREATE USER 'openmeetings'@'localhost' IDENTIFIED BY 'some_password' ;
GRANT ALL PRIVILEGES ON open503.* TO 'openmeetings'@'localhost';



On Thu, 2 Apr 2020 at 23:25, Maxim Solodovnik > wrote:


Will check if this is reproducible and will report back here

On Thu, 2 Apr 2020 at 23:19, Xavier M mailto:xa...@hotmail.com>> wrote:

Thank you Maxim for your answer. Unfortunately, I intended to
use OpenMeetings to record videos... that's why it was
problematic that Media Server was not found !

Please note that I just guess it could be bound with database.
The log does not exactly correspond to it. Moreover, I changed
utf8 by utf8mb4 : this may be a reason why it does not work ?

I try to clarify "manually" : but I guess I can make the test
again and screenshot this part if needed.

First, I enter these commands under MariaDB (please note that
I did not "FLUSH PRIVILEGES", according to Alvaro's tutorial) :

sudo mysql -u root -p

CREATE DATABASE open503 DEFAULT CHARACTER SET 'utf8mb4';

GRANT ALL PRIVILEGES ON open503.* TO
'openmeetings'@'localhost' IDENTIFIED BY 'some_password' WITH
GRANT OPTION;

quit


Then, on my webbased installation, I entered following :

DbType : MySQL
DbHost : localhost
Db port : 3306 (I have to recognize that I have no idea of the
port)
Name of the db : open503
DbUser : openmeetings
DbPassword : some_password

As I clicked on "Check", all seemed to work correctly. Then I
clicked on "Next".
--> I realise that I could not configure that it was utf8mb4
and not utf8. May it be the reason ?

Thanks,
Xavier







*De :* Maxim Solodovnik mailto:solomax...@gmail.com>>
*Envoyé :* jeudi 2 avril 2020 13:55
*À :* Openmeetings user-list mailto:user@openmeetings.apache.org>>
*Objet :* Re: Installation of OpenMeetings 5.0.0-M3 fails -
database connexion ?
Could you please clarify your steps at DB screen?
(maybe you can record short video?)

On Thu, 2 Apr 2020 at 17:18, Xavier M mailto:xa...@hotmail.com>> wrote:

Hi there,

I was still using OM 5.0.0-M1 and had suddenly an
unidentified problem connection the Media Server, as if
Kurento wasn't loaded. I decided to install "from fresh"
OM 5.0.0-M3, using Alavaro's tutorial.

All worked fine (I noticed that I had to change Kurento's
user) until I had to press "Finish". Especially, I checked
the DB-configuration (named open503, but with another
username/password) with the button of the web-installer.

A I clicked in "Finish", I received following error
(please see below). Does anyone know what went wrong?
Nota Bene: I deleted /opt/open503/ and /opt/omdb.mv.db and
installed OM 5.0.0-M3 again: and the 

User Manual for OpenMeetings 503

[K. Kamhamea]

Hello,
I've written a new user manual for Version 5. The one that I downloaded was
outdated (Version 2). 37 pages of a pdf file so far. The chapters
Installation and Administration are ready, but filled with lots and lots of
questions and suggestions for improvements. Is there someone who wants to
review the manual? Where can I upload the file.
Best.

Re: inconsistencies between browsers/OSs

[YUP]

Hi, it could be a problem of UDP ports. Can you check whether UDP
ports are open or close in your firewall?
Regards,
Yarema

On Thu, Apr 2, 2020 at 9:10 PM Orm Finnendahl
 wrote:
>
> Hi,
>
>  finally our OM server is working with https behind the firewall and
> NAT, ldap ist working too and we were able to succefully establish a
> stable conference between two linux boxes running firefox with
> audio/video (yey!).
>
> om is really amazing work, thanks to everyone, who contributed!
>
> Unfortunately we get varying success regarding audio/video with other
> OS/browser combinations: On OSX it seems to work with firefox but with
> Safari audio/video works locally, but the remote linux user is
> invisible/inaudible for the OSX user. With other OSX users and on a
> Windows/Firefox <-> Linux/Firefox combination, video and audio of the
> other side isn't working on both machines, etc...
>
> Is this a known issue? I searched the ML archives and the Web and
> couldn't find relevant information. Are there any recommendations how
> to troubleshoot the problems?
>
> It seems quite inconsistent and I don't know yet whether it's a setup
> problem on the user's/administrator's side. All participants of two
> part conferences state that they see their own audio/video and see the
> empty video frame of the other participant whitout hearing anything
> although seeing the green button of the other participant flash.
>
> We are using 5.0.0-M3, Revision b739f87
>
> --
> Orm

inconsistencies between browsers/OSs

[Orm Finnendahl]

Hi,

 finally our OM server is working with https behind the firewall and
NAT, ldap ist working too and we were able to succefully establish a
stable conference between two linux boxes running firefox with
audio/video (yey!).

om is really amazing work, thanks to everyone, who contributed!

Unfortunately we get varying success regarding audio/video with other
OS/browser combinations: On OSX it seems to work with firefox but with
Safari audio/video works locally, but the remote linux user is
invisible/inaudible for the OSX user. With other OSX users and on a
Windows/Firefox <-> Linux/Firefox combination, video and audio of the
other side isn't working on both machines, etc...

Is this a known issue? I searched the ML archives and the Web and
couldn't find relevant information. Are there any recommendations how
to troubleshoot the problems?

It seems quite inconsistent and I don't know yet whether it's a setup
problem on the user's/administrator's side. All participants of two
part conferences state that they see their own audio/video and see the
empty video frame of the other participant whitout hearing anything
although seeing the green button of the other participant flash.

We are using 5.0.0-M3, Revision b739f87

--
Orm

Re: Missing download button for recording inside the room

[R. Scholz]

Hello,

when I invite someone only with email-address this one get, before 
entering the room, an input-box who can input his name - preallocated 
with "Guest".
In the newest M4-version (yesterdfay) I see only the tree 
input-textboxes. No "OK" or something else. Where is it?


Best regards,

René

Re: Missing download button for recording inside the room

[Mikhail Zhmurin]

Now that you mention it, it is happened on chrome mostly. I'll ask teachers
for some feedback on FF and will keep my  eye on it as well. Again thank
you for your replies you are very helpful. Last question, I've noticed
speed tester for OM in the link you've send me. It is a great idea since we
are  getting a lot of bandwidth related questions from teachers. Is it a
future thing or it's possible to implement this thing on my server on 5.0.0
m3? Also is this a universal thing or it's based on specific server
configuration? Because if it is I'll simply send them the link you gave me
to test their internet connection. Hoping to hear from you about the mp4
download button in moodle.


чт, 2 апр. 2020 г. в 23:22, Maxim Solodovnik :

> Registration is opened :)
>
> According to disconnections
> https://issues.apache.org/jira/browse/OPENMEETINGS-2209
> https://issues.apache.org/jira/browse/OPENMEETINGS-2207
> https://issues.apache.org/jira/browse/OPENMEETINGS-2206
>
> Additionally there was report on this list
> That disconnections happen in Chrome but NOT in FF
> What browser are you using? At what OS?
>
> On Fri, 3 Apr 2020 at 00:19, Mikhail Zhmurin 
> wrote:
>
>> I understand that it's individual, we will make some kind of
>> announcement in moodle for everybody then. Could you please give me login
>> and pass for the link you've send me?
>> Still notification about screen share/recording being stoped by system
>> error or loss of connection would really help. Maybe someday in future :)
>>
>> чт, 2 апр. 2020 г. в 23:12, Maxim Solodovnik :
>>
>>> mp4 download should work
>>> will try to double-check
>>>
>>> Such things are so "individual" :(
>>> Can you check demo-next: https://om.alteametasoft.com:8443/next/
>>> Is it more recognizable?
>>>
>>> There is OM config option which opens screen-sharing started by the
>>> teacher automatically
>>> Maybe this will help?
>>>
>>> On Fri, 3 Apr 2020 at 00:08, Mikhail Zhmurin 
>>> wrote:
>>>
 Good evening/day/morning, Maxim
 I'm entirely sure what are you talking about. If you talking about
 setting my room in "show recording" mode inside moodle than I can only pick
 which recording participants will watch, .mp4 download button is inactive
 for some reason.
 Also since we are talking about UI improvements: is it possible to
 somehow make "screen share" button more recognizible. Because I've had
 multiple complaints from teachers (we're using moodle+om for middle school)
 that teachers can't seem to understand which button to press to start
 screen share. Same goes for students, no one really notices that screen
 share started and even though teacher told them that they enabled screen
 share it causes confusion among students because they simply don't know
 what to do to see presenters screen.. I know it's a little bit lazy but
 somekind of pop up notification or maybe a system message in chat would
 drastically improve workflow for everybody. Also it would really help if
 somekind of notification would be visible for presenter in case of
 recording or screen share was stopped not by presenter. A lot of presenters
 (teachers) simply don't notice that recording or screen share has stopped
 by itself (loss of connection/kms problem or whatever).
  Thank you very much in advance.

 чт, 2 апр. 2020 г. в 22:23, Maxim Solodovnik :

> https://issues.apache.org/jira/browse/OPENMEETINGS-2217
> (I'll see what can be done)
>
> BTW Recordings can be downloaded from Moodle (in activity edit mode)
>
> On Thu, 2 Apr 2020 at 23:21, Mikhail Zhmurin <
> zhmurin.mikh...@gmail.com> wrote:
>
>> Hello,
>> I'm sorry if I understood OM's workflow wrong, but I'm missing
>> download button for recordings made from inside the room. What I mean is
>> after conference is over, I can't seem to download recording even though
>> converting is over. There's simply no "download" button. But if I login 
>> to
>> dashboard separately I can download it from "recordings". Is this a bug 
>> or
>> a feature? This wouldn't be a problem but since I'm using moodle as LMS 
>> and
>> om as a plugin for conferences, users can't login into dashboard and
>> download recordings simply because they have no rights to do so.
>>
>
>
> --
> WBR
> Maxim aka solomax
>

>>>
>>> --
>>> WBR
>>> Maxim aka solomax
>>>
>>
>
> --
> WBR
> Maxim aka solomax
>

Re: Missing download button for recording inside the room

[Maxim Solodovnik]

Registration is opened :)

According to disconnections
https://issues.apache.org/jira/browse/OPENMEETINGS-2209
https://issues.apache.org/jira/browse/OPENMEETINGS-2207
https://issues.apache.org/jira/browse/OPENMEETINGS-2206

Additionally there was report on this list
That disconnections happen in Chrome but NOT in FF
What browser are you using? At what OS?

On Fri, 3 Apr 2020 at 00:19, Mikhail Zhmurin 
wrote:

> I understand that it's individual, we will make some kind of
> announcement in moodle for everybody then. Could you please give me login
> and pass for the link you've send me?
> Still notification about screen share/recording being stoped by system
> error or loss of connection would really help. Maybe someday in future :)
>
> чт, 2 апр. 2020 г. в 23:12, Maxim Solodovnik :
>
>> mp4 download should work
>> will try to double-check
>>
>> Such things are so "individual" :(
>> Can you check demo-next: https://om.alteametasoft.com:8443/next/
>> Is it more recognizable?
>>
>> There is OM config option which opens screen-sharing started by the
>> teacher automatically
>> Maybe this will help?
>>
>> On Fri, 3 Apr 2020 at 00:08, Mikhail Zhmurin 
>> wrote:
>>
>>> Good evening/day/morning, Maxim
>>> I'm entirely sure what are you talking about. If you talking about
>>> setting my room in "show recording" mode inside moodle than I can only pick
>>> which recording participants will watch, .mp4 download button is inactive
>>> for some reason.
>>> Also since we are talking about UI improvements: is it possible to
>>> somehow make "screen share" button more recognizible. Because I've had
>>> multiple complaints from teachers (we're using moodle+om for middle school)
>>> that teachers can't seem to understand which button to press to start
>>> screen share. Same goes for students, no one really notices that screen
>>> share started and even though teacher told them that they enabled screen
>>> share it causes confusion among students because they simply don't know
>>> what to do to see presenters screen.. I know it's a little bit lazy but
>>> somekind of pop up notification or maybe a system message in chat would
>>> drastically improve workflow for everybody. Also it would really help if
>>> somekind of notification would be visible for presenter in case of
>>> recording or screen share was stopped not by presenter. A lot of presenters
>>> (teachers) simply don't notice that recording or screen share has stopped
>>> by itself (loss of connection/kms problem or whatever).
>>>  Thank you very much in advance.
>>>
>>> чт, 2 апр. 2020 г. в 22:23, Maxim Solodovnik :
>>>
 https://issues.apache.org/jira/browse/OPENMEETINGS-2217
 (I'll see what can be done)

 BTW Recordings can be downloaded from Moodle (in activity edit mode)

 On Thu, 2 Apr 2020 at 23:21, Mikhail Zhmurin 
 wrote:

> Hello,
> I'm sorry if I understood OM's workflow wrong, but I'm missing
> download button for recordings made from inside the room. What I mean is
> after conference is over, I can't seem to download recording even though
> converting is over. There's simply no "download" button. But if I login to
> dashboard separately I can download it from "recordings". Is this a bug or
> a feature? This wouldn't be a problem but since I'm using moodle as LMS 
> and
> om as a plugin for conferences, users can't login into dashboard and
> download recordings simply because they have no rights to do so.
>


 --
 WBR
 Maxim aka solomax

>>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>

-- 
WBR
Maxim aka solomax

Re: Installation of OpenMeetings 5.0.0-M3 fails - database connexion ?

[Maxim Solodovnik]

Hello Xavier,

unfortunately your sql commands doesn't work for me (I'm using MySql NOT
MariaDB)
Could you please check if following commands will work for you?

CREATE DATABASE open503 DEFAULT CHARACTER SET 'utf8mb4';
CREATE USER 'openmeetings'@'localhost' IDENTIFIED BY 'some_password' ;
GRANT ALL PRIVILEGES ON open503.* TO 'openmeetings'@'localhost';



On Thu, 2 Apr 2020 at 23:25, Maxim Solodovnik  wrote:

> Will check if this is reproducible and will report back here
>
> On Thu, 2 Apr 2020 at 23:19, Xavier M  wrote:
>
>> Thank you Maxim for your answer. Unfortunately, I intended to use
>> OpenMeetings to record videos... that's why it was problematic that Media
>> Server was not found !
>>
>> Please note that I just guess it could be bound with database. The log
>> does not exactly correspond to it. Moreover, I changed utf8 by utf8mb4 :
>> this may be a reason why it does not work ?
>>
>> I try to clarify "manually" : but I guess I can make the test again and
>> screenshot this part if needed.
>>
>> First, I enter these commands under MariaDB (please note that I did not
>> "FLUSH PRIVILEGES", according to Alvaro's tutorial) :
>>
>> sudo mysql -u root -p
>>
>> CREATE DATABASE open503 DEFAULT CHARACTER SET 'utf8mb4';
>>
>> GRANT ALL PRIVILEGES ON open503.* TO 'openmeetings'@'localhost'
>> IDENTIFIED BY 'some_password' WITH GRANT OPTION;
>>
>> quit
>>
>> Then, on my webbased installation, I entered following :
>>
>> DbType : MySQL
>> DbHost : localhost
>> Db port : 3306 (I have to recognize that I have no idea of the port)
>> Name of the db : open503
>> DbUser : openmeetings
>> DbPassword : some_password
>>
>> As I clicked on "Check", all seemed to work correctly. Then I clicked on
>> "Next".
>> --> I realise that I could not configure that it was utf8mb4 and not
>> utf8. May it be the reason ?
>>
>> Thanks,
>> Xavier
>>
>>
>>
>>
>>
>>
>> --
>> *De :* Maxim Solodovnik 
>> *Envoyé :* jeudi 2 avril 2020 13:55
>> *À :* Openmeetings user-list 
>> *Objet :* Re: Installation of OpenMeetings 5.0.0-M3 fails - database
>> connexion ?
>>
>> Could you please clarify your steps at DB screen?
>> (maybe you can record short video?)
>>
>> On Thu, 2 Apr 2020 at 17:18, Xavier M  wrote:
>>
>> Hi there,
>>
>> I was still using OM 5.0.0-M1 and had suddenly an unidentified problem
>> connection the Media Server, as if Kurento wasn't loaded. I decided to
>> install "from fresh" OM 5.0.0-M3, using Alavaro's tutorial.
>>
>> All worked fine (I noticed that I had to change Kurento's user) until I
>> had to press "Finish". Especially, I checked the DB-configuration (named
>> open503, but with another username/password) with the button of the
>> web-installer.
>>
>> A I clicked in "Finish", I received following error (please see below).
>> Does anyone know what went wrong?
>> Nota Bene: I deleted /opt/open503/ and /opt/omdb.mv.db and installed OM
>> 5.0.0-M3 again: and the same happened.
>> It seems that there is a problem with a table named open503.configuration
>> which would not exist...
>>
>> Thanks in advance,
>> Xavier
>>
>> -
>>
>> L'installation a échoué
>>
>> > error> org.apache.openjpa.persistence.PersistenceException: The transaction 
>> has been rolled back.  See the nested exceptions for details on the errors 
>> that occurred.
>> FailedObject: org.apache.openmeetings.db.entity.basic.Configuration@7ce099e2
>>  at 
>> org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2470)
>>  at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2308)
>>  at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2199)
>>  at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1962)
>>  at org.apache.openjpa.kernel.QueryImpl.isInMemory(QueryImpl.java:1028)
>>  at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:902)
>>  at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:843)
>>  at 
>> org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601)
>>  at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297)
>>  at 
>> org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314)
>>  at 
>> org.apache.openmeetings.db.dao.basic.ConfigurationDao.get(ConfigurationDao.java:190)
>>  at 
>> org.apache.openmeetings.db.dao.basic.ConfigurationDao.get(ConfigurationDao.java:197)
>>  at 
>> org.apache.openmeetings.db.dao.basic.ConfigurationDao.getString(ConfigurationDao.java:247)
>>  at 
>> org.apache.openmeetings.db.dao.basic.ConfigurationDao.reloadCrypt(ConfigurationDao.java:416)
>>  at 
>> org.apache.openmeetings.db.dao.basic.ConfigurationDao.update(ConfigurationDao.java:317)
>>  at 
>> org.apache.openmeetings.db.dao.basic.ConfigurationDao.update(ConfigurationDao.java:285)
>>  at 
>> org.apache.openmeetings.db.dao.basic.ConfigurationDao$$FastClassBySpringCGLIB$$2f9526f2.invoke()
>>  at 
>> 

Re: Missing download button for recording inside the room

[Mikhail Zhmurin]

I understand that it's individual, we will make some kind of
announcement in moodle for everybody then. Could you please give me login
and pass for the link you've send me?
Still notification about screen share/recording being stoped by system
error or loss of connection would really help. Maybe someday in future :)

чт, 2 апр. 2020 г. в 23:12, Maxim Solodovnik :

> mp4 download should work
> will try to double-check
>
> Such things are so "individual" :(
> Can you check demo-next: https://om.alteametasoft.com:8443/next/
> Is it more recognizable?
>
> There is OM config option which opens screen-sharing started by the
> teacher automatically
> Maybe this will help?
>
> On Fri, 3 Apr 2020 at 00:08, Mikhail Zhmurin 
> wrote:
>
>> Good evening/day/morning, Maxim
>> I'm entirely sure what are you talking about. If you talking about
>> setting my room in "show recording" mode inside moodle than I can only pick
>> which recording participants will watch, .mp4 download button is inactive
>> for some reason.
>> Also since we are talking about UI improvements: is it possible to
>> somehow make "screen share" button more recognizible. Because I've had
>> multiple complaints from teachers (we're using moodle+om for middle school)
>> that teachers can't seem to understand which button to press to start
>> screen share. Same goes for students, no one really notices that screen
>> share started and even though teacher told them that they enabled screen
>> share it causes confusion among students because they simply don't know
>> what to do to see presenters screen.. I know it's a little bit lazy but
>> somekind of pop up notification or maybe a system message in chat would
>> drastically improve workflow for everybody. Also it would really help if
>> somekind of notification would be visible for presenter in case of
>> recording or screen share was stopped not by presenter. A lot of presenters
>> (teachers) simply don't notice that recording or screen share has stopped
>> by itself (loss of connection/kms problem or whatever).
>>  Thank you very much in advance.
>>
>> чт, 2 апр. 2020 г. в 22:23, Maxim Solodovnik :
>>
>>> https://issues.apache.org/jira/browse/OPENMEETINGS-2217
>>> (I'll see what can be done)
>>>
>>> BTW Recordings can be downloaded from Moodle (in activity edit mode)
>>>
>>> On Thu, 2 Apr 2020 at 23:21, Mikhail Zhmurin 
>>> wrote:
>>>
 Hello,
 I'm sorry if I understood OM's workflow wrong, but I'm missing download
 button for recordings made from inside the room. What I mean is after
 conference is over, I can't seem to download recording even though
 converting is over. There's simply no "download" button. But if I login to
 dashboard separately I can download it from "recordings". Is this a bug or
 a feature? This wouldn't be a problem but since I'm using moodle as LMS and
 om as a plugin for conferences, users can't login into dashboard and
 download recordings simply because they have no rights to do so.

>>>
>>>
>>> --
>>> WBR
>>> Maxim aka solomax
>>>
>>
>
> --
> WBR
> Maxim aka solomax
>

Re: Missing download button for recording inside the room

[Maxim Solodovnik]

mp4 download should work
will try to double-check

Such things are so "individual" :(
Can you check demo-next: https://om.alteametasoft.com:8443/next/
Is it more recognizable?

There is OM config option which opens screen-sharing started by the teacher
automatically
Maybe this will help?

On Fri, 3 Apr 2020 at 00:08, Mikhail Zhmurin 
wrote:

> Good evening/day/morning, Maxim
> I'm entirely sure what are you talking about. If you talking about setting
> my room in "show recording" mode inside moodle than I can only pick which
> recording participants will watch, .mp4 download button is inactive for
> some reason.
> Also since we are talking about UI improvements: is it possible to somehow
> make "screen share" button more recognizible. Because I've had multiple
> complaints from teachers (we're using moodle+om for middle school) that
> teachers can't seem to understand which button to press to start screen
> share. Same goes for students, no one really notices that screen share
> started and even though teacher told them that they enabled screen share it
> causes confusion among students because they simply don't know what to do
> to see presenters screen.. I know it's a little bit lazy but somekind of
> pop up notification or maybe a system message in chat would drastically
> improve workflow for everybody. Also it would really help if somekind of
> notification would be visible for presenter in case of recording or screen
> share was stopped not by presenter. A lot of presenters (teachers) simply
> don't notice that recording or screen share has stopped by itself (loss of
> connection/kms problem or whatever).
>  Thank you very much in advance.
>
> чт, 2 апр. 2020 г. в 22:23, Maxim Solodovnik :
>
>> https://issues.apache.org/jira/browse/OPENMEETINGS-2217
>> (I'll see what can be done)
>>
>> BTW Recordings can be downloaded from Moodle (in activity edit mode)
>>
>> On Thu, 2 Apr 2020 at 23:21, Mikhail Zhmurin 
>> wrote:
>>
>>> Hello,
>>> I'm sorry if I understood OM's workflow wrong, but I'm missing download
>>> button for recordings made from inside the room. What I mean is after
>>> conference is over, I can't seem to download recording even though
>>> converting is over. There's simply no "download" button. But if I login to
>>> dashboard separately I can download it from "recordings". Is this a bug or
>>> a feature? This wouldn't be a problem but since I'm using moodle as LMS and
>>> om as a plugin for conferences, users can't login into dashboard and
>>> download recordings simply because they have no rights to do so.
>>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>

-- 
WBR
Maxim aka solomax

Re: Missing download button for recording inside the room

[Mikhail Zhmurin]

Good evening/day/morning, Maxim
I'm entirely sure what are you talking about. If you talking about setting
my room in "show recording" mode inside moodle than I can only pick which
recording participants will watch, .mp4 download button is inactive for
some reason.
Also since we are talking about UI improvements: is it possible to somehow
make "screen share" button more recognizible. Because I've had multiple
complaints from teachers (we're using moodle+om for middle school) that
teachers can't seem to understand which button to press to start screen
share. Same goes for students, no one really notices that screen share
started and even though teacher told them that they enabled screen share it
causes confusion among students because they simply don't know what to do
to see presenters screen.. I know it's a little bit lazy but somekind of
pop up notification or maybe a system message in chat would drastically
improve workflow for everybody. Also it would really help if somekind of
notification would be visible for presenter in case of recording or screen
share was stopped not by presenter. A lot of presenters (teachers) simply
don't notice that recording or screen share has stopped by itself (loss of
connection/kms problem or whatever).
 Thank you very much in advance.

чт, 2 апр. 2020 г. в 22:23, Maxim Solodovnik :

> https://issues.apache.org/jira/browse/OPENMEETINGS-2217
> (I'll see what can be done)
>
> BTW Recordings can be downloaded from Moodle (in activity edit mode)
>
> On Thu, 2 Apr 2020 at 23:21, Mikhail Zhmurin 
> wrote:
>
>> Hello,
>> I'm sorry if I understood OM's workflow wrong, but I'm missing download
>> button for recordings made from inside the room. What I mean is after
>> conference is over, I can't seem to download recording even though
>> converting is over. There's simply no "download" button. But if I login to
>> dashboard separately I can download it from "recordings". Is this a bug or
>> a feature? This wouldn't be a problem but since I'm using moodle as LMS and
>> om as a plugin for conferences, users can't login into dashboard and
>> download recordings simply because they have no rights to do so.
>>
>
>
> --
> WBR
> Maxim aka solomax
>

Re: Openmeetings Docker behind reverse proxy

[YUP]

Hi,
Please try my config for proxy pass in nginx. My nginx listen port
2443 with ssl, openmeetings runs in docker with standart ports
exposed:

server {
listen   2443 ssl http2;
listen [::]:2443 ssl http2;
server_name  localhost;

  location /openmeetings {
proxy_pass https://localhost:5443/openmeetings;
proxy_set_header Host $host;
proxy_http_version 1.1;
proxy_set_header Upgrade $http_upgrade;
proxy_set_header Connection "upgrade";
}

You can also add kurento if you wish:

location /kurento {
# prevents 502 bad gateway error
proxy_buffers 8 32k;
proxy_buffer_size 64k;
# redirect all HTTP traffic to localhost:8088;
proxy_pass http://127.0.0.1:/kurento;
# enables WS support
proxy_http_version 1.1;
proxy_set_header Upgrade $http_upgrade;
proxy_set_header Connection "upgrade";
proxy_read_timeout 9;
}

On Thu, Apr 2, 2020 at 3:01 PM Arndt, Wolfgang  wrote:
>
> Hi,
>
> when i read this right i have to modify conf/jee-container.xml
>
> in the container.
>
> I cannot find a file like that in there.
>
>
>
> Second: I have to proxy websockets, too.
>
>
>
> I have no idea, how to doi this with 
> https://github.com/nginx-proxy/nginx-proxy
>
>
>
> Wolfgang
>
>
>
>
>
>
>
>
>
>
> Von: Maxim Solodovnik 
> Gesendet: Donnerstag, 2. April 2020 13:51
> An: Openmeetings user-list 
> Betreff: Re: Openmeetings Docker behind reverse proxy
>
>
>
> https://stackoverflow.com/questions/51721771/apache-openmeetings-4-0-4-csrf-attack-when-using-apache2-as-proxypass
>
> + search in this ML :)))
>
>
>
> On Thu, 2 Apr 2020 at 18:19, Arndt, Wolfgang  wrote:
>
> Hi,
>
> my Openmeetings docker is working now. So i took the next step:
>
>
>
> I use the nginx-letsencrypt ssl proxy 
> (https://hub.docker.com/r/jrcs/letsencrypt-nginx-proxy-companion/) to 
> auto-generate certs. This is working with other containers.
>
>
>
> As in the grafana expample from the page above , i start the OM-Docker 
> container with an additional -e "VIRTUAL_PORT=5080"
>
>
>
> Now i can connect via the proxy to my OM container, the login page opens but 
> i cannot login.
>
>
>
>
>
> INFO  04-02 10:59:37.346 o.a.w.p.h.CsrfPreventionRequestCycleListener:779 
> [nio-5080-exec-6] - Possible CSRF attack, request URL: 
> http://om.x.de/openmeetings/wicket/bookmarkable/org.apache.openmeetings.web.pages.auth.SignInPage,
>  Origin: https://om.x.de, action: aborted with error 400 Origin does not 
> correspond to request
>
>
>
>
>
> Wolfgang
>
>
>
>
> --
>
> WBR
> Maxim aka solomax

Re: Installation of OpenMeetings 5.0.0-M3 fails - database connexion ?

[Maxim Solodovnik]

Will check if this is reproducible and will report back here

On Thu, 2 Apr 2020 at 23:19, Xavier M  wrote:

> Thank you Maxim for your answer. Unfortunately, I intended to use
> OpenMeetings to record videos... that's why it was problematic that Media
> Server was not found !
>
> Please note that I just guess it could be bound with database. The log
> does not exactly correspond to it. Moreover, I changed utf8 by utf8mb4 :
> this may be a reason why it does not work ?
>
> I try to clarify "manually" : but I guess I can make the test again and
> screenshot this part if needed.
>
> First, I enter these commands under MariaDB (please note that I did not
> "FLUSH PRIVILEGES", according to Alvaro's tutorial) :
>
> sudo mysql -u root -p
>
> CREATE DATABASE open503 DEFAULT CHARACTER SET 'utf8mb4';
>
> GRANT ALL PRIVILEGES ON open503.* TO 'openmeetings'@'localhost'
> IDENTIFIED BY 'some_password' WITH GRANT OPTION;
>
> quit
>
> Then, on my webbased installation, I entered following :
>
> DbType : MySQL
> DbHost : localhost
> Db port : 3306 (I have to recognize that I have no idea of the port)
> Name of the db : open503
> DbUser : openmeetings
> DbPassword : some_password
>
> As I clicked on "Check", all seemed to work correctly. Then I clicked on
> "Next".
> --> I realise that I could not configure that it was utf8mb4 and not utf8.
> May it be the reason ?
>
> Thanks,
> Xavier
>
>
>
>
>
>
> --
> *De :* Maxim Solodovnik 
> *Envoyé :* jeudi 2 avril 2020 13:55
> *À :* Openmeetings user-list 
> *Objet :* Re: Installation of OpenMeetings 5.0.0-M3 fails - database
> connexion ?
>
> Could you please clarify your steps at DB screen?
> (maybe you can record short video?)
>
> On Thu, 2 Apr 2020 at 17:18, Xavier M  wrote:
>
> Hi there,
>
> I was still using OM 5.0.0-M1 and had suddenly an unidentified problem
> connection the Media Server, as if Kurento wasn't loaded. I decided to
> install "from fresh" OM 5.0.0-M3, using Alavaro's tutorial.
>
> All worked fine (I noticed that I had to change Kurento's user) until I
> had to press "Finish". Especially, I checked the DB-configuration (named
> open503, but with another username/password) with the button of the
> web-installer.
>
> A I clicked in "Finish", I received following error (please see below).
> Does anyone know what went wrong?
> Nota Bene: I deleted /opt/open503/ and /opt/omdb.mv.db and installed OM
> 5.0.0-M3 again: and the same happened.
> It seems that there is a problem with a table named open503.configuration
> which would not exist...
>
> Thanks in advance,
> Xavier
>
> -
>
> L'installation a échoué
>
>  
> org.apache.openjpa.persistence.PersistenceException: The transaction has been 
> rolled back.  See the nested exceptions for details on the errors that 
> occurred.
> FailedObject: org.apache.openmeetings.db.entity.basic.Configuration@7ce099e2
>   at 
> org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2470)
>   at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2308)
>   at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2199)
>   at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1962)
>   at org.apache.openjpa.kernel.QueryImpl.isInMemory(QueryImpl.java:1028)
>   at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:902)
>   at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:843)
>   at 
> org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601)
>   at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297)
>   at 
> org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314)
>   at 
> org.apache.openmeetings.db.dao.basic.ConfigurationDao.get(ConfigurationDao.java:190)
>   at 
> org.apache.openmeetings.db.dao.basic.ConfigurationDao.get(ConfigurationDao.java:197)
>   at 
> org.apache.openmeetings.db.dao.basic.ConfigurationDao.getString(ConfigurationDao.java:247)
>   at 
> org.apache.openmeetings.db.dao.basic.ConfigurationDao.reloadCrypt(ConfigurationDao.java:416)
>   at 
> org.apache.openmeetings.db.dao.basic.ConfigurationDao.update(ConfigurationDao.java:317)
>   at 
> org.apache.openmeetings.db.dao.basic.ConfigurationDao.update(ConfigurationDao.java:285)
>   at 
> org.apache.openmeetings.db.dao.basic.ConfigurationDao$$FastClassBySpringCGLIB$$2f9526f2.invoke()
>   at 
> org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
>   at 
> org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:769)
>   at 
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
>   at 
> org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:747)
>   at 
> 

Re: Missing download button for recording inside the room

[Maxim Solodovnik]

https://issues.apache.org/jira/browse/OPENMEETINGS-2217
(I'll see what can be done)

BTW Recordings can be downloaded from Moodle (in activity edit mode)

On Thu, 2 Apr 2020 at 23:21, Mikhail Zhmurin 
wrote:

> Hello,
> I'm sorry if I understood OM's workflow wrong, but I'm missing download
> button for recordings made from inside the room. What I mean is after
> conference is over, I can't seem to download recording even though
> converting is over. There's simply no "download" button. But if I login to
> dashboard separately I can download it from "recordings". Is this a bug or
> a feature? This wouldn't be a problem but since I'm using moodle as LMS and
> om as a plugin for conferences, users can't login into dashboard and
> download recordings simply because they have no rights to do so.
>


-- 
WBR
Maxim aka solomax

Missing download button for recording inside the room

[Mikhail Zhmurin]

Hello,
I'm sorry if I understood OM's workflow wrong, but I'm missing download
button for recordings made from inside the room. What I mean is after
conference is over, I can't seem to download recording even though
converting is over. There's simply no "download" button. But if I login to
dashboard separately I can download it from "recordings". Is this a bug or
a feature? This wouldn't be a problem but since I'm using moodle as LMS and
om as a plugin for conferences, users can't login into dashboard and
download recordings simply because they have no rights to do so.

RE: Installation of OpenMeetings 5.0.0-M3 fails - database connexion ?

[Xavier M]

Thank you Maxim for your answer. Unfortunately, I intended to use OpenMeetings 
to record videos... that's why it was problematic that Media Server was not 
found !

Please note that I just guess it could be bound with database. The log does not 
exactly correspond to it. Moreover, I changed utf8 by utf8mb4 : this may be a 
reason why it does not work ?

I try to clarify "manually" : but I guess I can make the test again and 
screenshot this part if needed.

First, I enter these commands under MariaDB (please note that I did not "FLUSH 
PRIVILEGES", according to Alvaro's tutorial) :

sudo mysql -u root -p

CREATE DATABASE open503 DEFAULT CHARACTER SET 'utf8mb4';

GRANT ALL PRIVILEGES ON open503.* TO 'openmeetings'@'localhost' IDENTIFIED BY 
'some_password' WITH GRANT OPTION;

quit

Then, on my webbased installation, I entered following :

DbType : MySQL
DbHost : localhost
Db port : 3306 (I have to recognize that I have no idea of the port)
Name of the db : open503
DbUser : openmeetings
DbPassword : some_password

As I clicked on "Check", all seemed to work correctly. Then I clicked on "Next".
--> I realise that I could not configure that it was utf8mb4 and not utf8. May 
it be the reason ?

Thanks,
Xavier







De : Maxim Solodovnik 
Envoyé : jeudi 2 avril 2020 13:55
À : Openmeetings user-list 
Objet : Re: Installation of OpenMeetings 5.0.0-M3 fails - database connexion ?

Could you please clarify your steps at DB screen?
(maybe you can record short video?)

On Thu, 2 Apr 2020 at 17:18, Xavier M 
mailto:xa...@hotmail.com>> wrote:
Hi there,

I was still using OM 5.0.0-M1 and had suddenly an unidentified problem 
connection the Media Server, as if Kurento wasn't loaded. I decided to install 
"from fresh" OM 5.0.0-M3, using Alavaro's tutorial.

All worked fine (I noticed that I had to change Kurento's user) until I had to 
press "Finish". Especially, I checked the DB-configuration (named open503, but 
with another username/password) with the button of the web-installer.

A I clicked in "Finish", I received following error (please see below). Does 
anyone know what went wrong?
Nota Bene: I deleted /opt/open503/ and /opt/omdb.mv.db and installed OM 
5.0.0-M3 again: and the same happened.
It seems that there is a problem with a table named open503.configuration which 
would not exist...

Thanks in advance,
Xavier

-

L'installation a échoué

 
org.apache.openjpa.persistence.PersistenceException: The transaction has been 
rolled back.  See the nested exceptions for details on the errors that occurred.
FailedObject: org.apache.openmeetings.db.entity.basic.Configuration@7ce099e2
at 
org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2470)
at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2308)
at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2199)
at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1962)
at org.apache.openjpa.kernel.QueryImpl.isInMemory(QueryImpl.java:1028)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:902)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:843)
at 
org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601)
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297)
at 
org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314)
at 
org.apache.openmeetings.db.dao.basic.ConfigurationDao.get(ConfigurationDao.java:190)
at 
org.apache.openmeetings.db.dao.basic.ConfigurationDao.get(ConfigurationDao.java:197)
at 
org.apache.openmeetings.db.dao.basic.ConfigurationDao.getString(ConfigurationDao.java:247)
at 
org.apache.openmeetings.db.dao.basic.ConfigurationDao.reloadCrypt(ConfigurationDao.java:416)
at 
org.apache.openmeetings.db.dao.basic.ConfigurationDao.update(ConfigurationDao.java:317)
at 
org.apache.openmeetings.db.dao.basic.ConfigurationDao.update(ConfigurationDao.java:285)
at 
org.apache.openmeetings.db.dao.basic.ConfigurationDao$$FastClassBySpringCGLIB$$2f9526f2.invoke()
at 
org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at 
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:769)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at 
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:747)
at 
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:366)
at 
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at 

Re: Openmeetings Docker behind reverse proxy

[Maxim Solodovnik]

This detailed how-to is for version 4.0.x
I have asked multiple times to ask SO question so I can put up-to-date
5.0.x config, but no question :)

please search mailing list https://openmeetings.markmail.org/
server.xml need to be modified

According to nginx: I'm not an expert here :(

On Thu, 2 Apr 2020 at 20:01, Arndt, Wolfgang 
wrote:

> Hi,
>
> when i read this right i have to modify conf/jee-container.xml
>
> in the container.
>
> I cannot find a file like that in there.
>
>
>
> Second: I have to proxy websockets, too.
>
>
>
> I have no idea, how to doi this with
> https://github.com/nginx-proxy/nginx-proxy
>
>
>
> Wolfgang
>
>
>
>
>
>
>
>
>
>
> *Von:* Maxim Solodovnik 
> *Gesendet:* Donnerstag, 2. April 2020 13:51
> *An:* Openmeetings user-list 
> *Betreff:* Re: Openmeetings Docker behind reverse proxy
>
>
>
>
> https://stackoverflow.com/questions/51721771/apache-openmeetings-4-0-4-csrf-attack-when-using-apache2-as-proxypass
>
> + search in this ML :)))
>
>
>
> On Thu, 2 Apr 2020 at 18:19, Arndt, Wolfgang 
> wrote:
>
> Hi,
>
> my Openmeetings docker is working now. So i took the next step:
>
>
>
> I use the nginx-letsencrypt ssl proxy (
> https://hub.docker.com/r/jrcs/letsencrypt-nginx-proxy-companion/) to
> auto-generate certs. This is working with other containers.
>
>
>
> As in the grafana expample from the page above , i start the OM-Docker
> container with an additional -e "VIRTUAL_PORT=5080"
>
>
>
> Now i can connect via the proxy to my OM container, the login page opens
> but i cannot login.
>
>
>
>
>
> INFO  04-02 10:59:37.346 o.a.w.p.h.CsrfPreventionRequestCycleListener:779
> [nio-5080-exec-6] - Possible CSRF attack, request URL:
> http://om.x.de/openmeetings/wicket/bookmarkable/org.apache.openmeetings.web.pages.auth.SignInPage,
> Origin: https://om.x.de, action: aborted with error 400 Origin does
> not correspond to request
>
>
>
>
>
> Wolfgang
>
>
>
>
> --
>
> WBR
> Maxim aka solomax
>


-- 
WBR
Maxim aka solomax

AW: Openmeetings Docker behind reverse proxy

[Arndt , Wolfgang]

Hi,

when i read this right i have to modify conf/jee-container.xml

in the container.

I cannot find a file like that in there.

 
Second: I have to proxy websockets, too.

 
I have no idea, how to doi this with https://github.com/nginx-proxy/nginx-proxy

 
Wolfgang



 
 
 
 
Von: Maxim Solodovnik 
Gesendet: Donnerstag, 2. April 2020 13:51
An: Openmeetings user-list 
Betreff: Re: Openmeetings Docker behind reverse proxy

 
https://stackoverflow.com/questions/51721771/apache-openmeetings-4-0-4-csrf-attack-when-using-apache2-as-proxypass

+ search in this ML :)))

 
On Thu, 2 Apr 2020 at 18:19, Arndt, Wolfgang  wrote:

Hi,

my Openmeetings docker is working now. So i took the next step:

 
I use the nginx-letsencrypt ssl proxy 
(https://hub.docker.com/r/jrcs/letsencrypt-nginx-proxy-companion/) to 
auto-generate certs. This is working with other containers.

 
As in the grafana expample from the page above , i start the OM-Docker 
container with an additional -e "VIRTUAL_PORT=5080"

 
Now i can connect via the proxy to my OM container, the login page opens but i 
cannot login.

 
 
INFO  04-02 10:59:37.346 o.a.w.p.h.CsrfPreventionRequestCycleListener:779 
[nio-5080-exec-6] - Possible CSRF attack, request URL: 
http://om.x.de/openmeetings/wicket/bookmarkable/org.apache.openmeetings.web.pages.auth.SignInPage,
 Origin: https://om.x.de, action: aborted with error 400 Origin does not 
correspond to request

 
 
Wolfgang



 
--

WBR
Maxim aka solomax

Re: Installation of OpenMeetings 5.0.0-M3 fails - database connexion ?

[Maxim Solodovnik]

Could you please clarify your steps at DB screen?
(maybe you can record short video?)

On Thu, 2 Apr 2020 at 17:18, Xavier M  wrote:

> Hi there,
>
> I was still using OM 5.0.0-M1 and had suddenly an unidentified problem
> connection the Media Server, as if Kurento wasn't loaded. I decided to
> install "from fresh" OM 5.0.0-M3, using Alavaro's tutorial.
>
> All worked fine (I noticed that I had to change Kurento's user) until I
> had to press "Finish". Especially, I checked the DB-configuration (named
> open503, but with another username/password) with the button of the
> web-installer.
>
> A I clicked in "Finish", I received following error (please see below).
> Does anyone know what went wrong?
> Nota Bene: I deleted /opt/open503/ and /opt/omdb.mv.db and installed OM
> 5.0.0-M3 again: and the same happened.
> It seems that there is a problem with a table named open503.configuration
> which would not exist...
>
> Thanks in advance,
> Xavier
>
> -
>
> L'installation a échoué
>
>  
> org.apache.openjpa.persistence.PersistenceException: The transaction has been 
> rolled back.  See the nested exceptions for details on the errors that 
> occurred.
> FailedObject: org.apache.openmeetings.db.entity.basic.Configuration@7ce099e2
>   at 
> org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2470)
>   at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2308)
>   at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2199)
>   at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1962)
>   at org.apache.openjpa.kernel.QueryImpl.isInMemory(QueryImpl.java:1028)
>   at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:902)
>   at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:843)
>   at 
> org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601)
>   at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297)
>   at 
> org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314)
>   at 
> org.apache.openmeetings.db.dao.basic.ConfigurationDao.get(ConfigurationDao.java:190)
>   at 
> org.apache.openmeetings.db.dao.basic.ConfigurationDao.get(ConfigurationDao.java:197)
>   at 
> org.apache.openmeetings.db.dao.basic.ConfigurationDao.getString(ConfigurationDao.java:247)
>   at 
> org.apache.openmeetings.db.dao.basic.ConfigurationDao.reloadCrypt(ConfigurationDao.java:416)
>   at 
> org.apache.openmeetings.db.dao.basic.ConfigurationDao.update(ConfigurationDao.java:317)
>   at 
> org.apache.openmeetings.db.dao.basic.ConfigurationDao.update(ConfigurationDao.java:285)
>   at 
> org.apache.openmeetings.db.dao.basic.ConfigurationDao$$FastClassBySpringCGLIB$$2f9526f2.invoke()
>   at 
> org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
>   at 
> org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:769)
>   at 
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
>   at 
> org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:747)
>   at 
> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:366)
>   at 
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)
>   at 
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
>   at 
> org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:747)
>   at 
> org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
>   at 
> org.apache.openmeetings.db.dao.basic.ConfigurationDao$$EnhancerBySpringCGLIB$$ffb65391.update()
>   at 
> org.apache.openmeetings.installation.ImportInitvalues.loadConfiguration(ImportInitvalues.java:363)
>   at 
> org.apache.openmeetings.installation.ImportInitvalues.loadSystem(ImportInitvalues.java:553)
>   at 
> org.apache.openmeetings.installation.ImportInitvalues.loadAll(ImportInitvalues.java:563)
>   at 
> org.apache.openmeetings.installation.Wicket_Proxy_ImportInitvalues$$FastClassByCGLIB$$14cc0e15.invoke()
>   at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
>   at 
> org.apache.wicket.proxy.LazyInitProxyFactory$AbstractCGLibInterceptor.intercept(LazyInitProxyFactory.java:364)
>   at 
> org.apache.openmeetings.installation.Wicket_Proxy_ImportInitvalues$$EnhancerByCGLIB$$fc81f545.loadAll()
>   at 
> org.apache.openmeetings.web.pages.install.InstallWizard$InstallProcess.run(InstallWizard.java:751)
>   at java.base/java.lang.Thread.run(Thread.java:834)
> Caused by:  general error> org.apache.openjpa.persistence.PersistenceException: Table 
> 

Re: Openmeetings Docker behind reverse proxy

[Maxim Solodovnik]

https://stackoverflow.com/questions/51721771/apache-openmeetings-4-0-4-csrf-attack-when-using-apache2-as-proxypass
+ search in this ML :)))

On Thu, 2 Apr 2020 at 18:19, Arndt, Wolfgang 
wrote:

> Hi,
>
> my Openmeetings docker is working now. So i took the next step:
>
>
>
> I use the nginx-letsencrypt ssl proxy (
> https://hub.docker.com/r/jrcs/letsencrypt-nginx-proxy-companion/) to
> auto-generate certs. This is working with other containers.
>
>
>
> As in the grafana expample from the page above , i start the OM-Docker
> container with an additional -e "VIRTUAL_PORT=5080"
>
>
>
> Now i can connect via the proxy to my OM container, the login page opens
> but i cannot login.
>
>
>
>
>
> INFO  04-02 10:59:37.346 o.a.w.p.h.CsrfPreventionRequestCycleListener:779
> [nio-5080-exec-6] - Possible CSRF attack, request URL:
> http://om.x.de/openmeetings/wicket/bookmarkable/org.apache.openmeetings.web.pages.auth.SignInPage,
> Origin: https://om.x.de, action: aborted with error 400 Origin does
> not correspond to request
>
>
>
>
>
> Wolfgang
>


-- 
WBR
Maxim aka solomax

Openmeetings Docker behind reverse proxy

[Arndt , Wolfgang]

Hi,

my Openmeetings docker is working now. So i took the next step:

 
I use the nginx-letsencrypt ssl proxy 
(https://hub.docker.com/r/jrcs/letsencrypt-nginx-proxy-companion/) to 
auto-generate certs. This is working with other containers.

 
As in the grafana expample from the page above , i start the OM-Docker 
container with an additional -e "VIRTUAL_PORT=5080"

 
Now i can connect via the proxy to my OM container, the login page opens but i 
cannot login.

 
 
INFO  04-02 10:59:37.346 o.a.w.p.h.CsrfPreventionRequestCycleListener:779 
[nio-5080-exec-6] - Possible CSRF attack, request URL: 
http://om.x.de/openmeetings/wicket/bookmarkable/org.apache.openmeetings.web.pages.auth.SignInPage,
 Origin: https://om.x.de, action: aborted with error 400 Origin does not 
correspond to request

 
 
Wolfgang

Installation of OpenMeetings 5.0.0-M3 fails - database connexion ?

[Xavier M]

Hi there,

I was still using OM 5.0.0-M1 and had suddenly an unidentified problem 
connection the Media Server, as if Kurento wasn't loaded. I decided to install 
"from fresh" OM 5.0.0-M3, using Alavaro's tutorial.

All worked fine (I noticed that I had to change Kurento's user) until I had to 
press "Finish". Especially, I checked the DB-configuration (named open503, but 
with another username/password) with the button of the web-installer.

A I clicked in "Finish", I received following error (please see below). Does 
anyone know what went wrong?
Nota Bene: I deleted /opt/open503/ and /opt/omdb.mv.db and installed OM 
5.0.0-M3 again: and the same happened.
It seems that there is a problem with a table named open503.configuration which 
would not exist...

Thanks in advance,
Xavier

-

L'installation a échoué

 
org.apache.openjpa.persistence.PersistenceException: The transaction has been 
rolled back.  See the nested exceptions for details on the errors that occurred.
FailedObject: org.apache.openmeetings.db.entity.basic.Configuration@7ce099e2
at 
org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2470)
at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2308)
at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2199)
at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1962)
at org.apache.openjpa.kernel.QueryImpl.isInMemory(QueryImpl.java:1028)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:902)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:843)
at 
org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601)
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297)
at 
org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314)
at 
org.apache.openmeetings.db.dao.basic.ConfigurationDao.get(ConfigurationDao.java:190)
at 
org.apache.openmeetings.db.dao.basic.ConfigurationDao.get(ConfigurationDao.java:197)
at 
org.apache.openmeetings.db.dao.basic.ConfigurationDao.getString(ConfigurationDao.java:247)
at 
org.apache.openmeetings.db.dao.basic.ConfigurationDao.reloadCrypt(ConfigurationDao.java:416)
at 
org.apache.openmeetings.db.dao.basic.ConfigurationDao.update(ConfigurationDao.java:317)
at 
org.apache.openmeetings.db.dao.basic.ConfigurationDao.update(ConfigurationDao.java:285)
at 
org.apache.openmeetings.db.dao.basic.ConfigurationDao$$FastClassBySpringCGLIB$$2f9526f2.invoke()
at 
org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at 
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:769)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at 
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:747)
at 
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:366)
at 
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at 
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:747)
at 
org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
at 
org.apache.openmeetings.db.dao.basic.ConfigurationDao$$EnhancerBySpringCGLIB$$ffb65391.update()
at 
org.apache.openmeetings.installation.ImportInitvalues.loadConfiguration(ImportInitvalues.java:363)
at 
org.apache.openmeetings.installation.ImportInitvalues.loadSystem(ImportInitvalues.java:553)
at 
org.apache.openmeetings.installation.ImportInitvalues.loadAll(ImportInitvalues.java:563)
at 
org.apache.openmeetings.installation.Wicket_Proxy_ImportInitvalues$$FastClassByCGLIB$$14cc0e15.invoke()
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at 
org.apache.wicket.proxy.LazyInitProxyFactory$AbstractCGLibInterceptor.intercept(LazyInitProxyFactory.java:364)
at 
org.apache.openmeetings.installation.Wicket_Proxy_ImportInitvalues$$EnhancerByCGLIB$$fc81f545.loadAll()
at 
org.apache.openmeetings.web.pages.install.InstallWizard$InstallProcess.run(InstallWizard.java:751)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by:  org.apache.openjpa.persistence.PersistenceException: Table 
'open503.configuration' doesn't exist {prepstmnt 1187243401 INSERT INTO 
configuration (deleted, inserted, updated, comment, fromVersion, om_key, type, 
value, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=1146, state=42S02]
FailedObject: