Re: Asterisk Integration

2019-05-15 Thread Siovel Rodriguez
Thanks Maxim.

Greetings

El mié., 15 may. 2019 a las 6:16, Maxim Solodovnik ()
escribió:

> Hello Siovel,
>
> sorry for the long response we had long public holidays :)))
>
> If I do remember correctly to connect you need to:
> 1) run Asterisk
> 2) run OM with Asterisk support
> 3) run red5-sip connected with OM
> 4) open Admin->Rooms
> 5) go to particular room settings and check "Enable SIP transport in the
> room"
> As a result you should have "SIP number" assigned to room
> (optionally you can also set PIN at this stage)
>
> later on you can enter this room via any native client and you will
> see "SIP Transport" user in user list
>
> BAD news: video support is buggy and unstable :(
> I plan to re-implement the whole integration for 5.0.0
> No estimates so far :(
>
> On Tue, 30 Apr 2019 at 10:35, Siovel Rodriguez  wrote:
> >
> > Hello Maxim, thanks for your response. I will try to do the whole
> process again. Anyway I have some doubts. I installed the Zoiper
> application to perform the tests, I logged in with the user red5sip_user in
> the Zoiper application and wanted to know if after logging in I should see
> that user (red5sip_user) inside a room in OM to be able to make the video
> conference . If you could comment a bit on the mechanism of operation I
> would appreciate it because it is not entirely clear to me.
> >
> > Please, I would appreciate your help
> > Greetings
> >
> > El vie., 26 abr. 2019 a las 1:31, Maxim Solodovnik (<
> solomax...@gmail.com>) escribió:
> >>
> >> Hello Siovel,
> >>
> >> I'm sorry it took so long, finally I was able to find time and perform
> step-by step config one more time
> >>
> >> My steps (at Ubuntu 16.04 server):
> >> 1) apt remove --purge asterisk
> >> 2) manually delete /etc/asterisk /usr/src/asterisk /var/spool/asterisk
> >> 3) perform all steps from official guide
> https://openmeetings.apache.org/voip-sip-integration.html
> >> 4) run asterisk in debug mode: `reset && sudo asterisk -`
> >> No MySql related errors
> >>
> >>
> >> On Fri, 19 Apr 2019 at 11:24, Siovel Rodriguez 
> wrote:
> >>>
> >>> Thanks Maxim. I'll be waiting for your help. Very thankful
> >>>
> >>> El jue., 18 abr. 2019 a las 23:42, Maxim Solodovnik (<
> solomax...@gmail.com>) escribió:
> 
>  Hello Siovel,
>  I'm reading your emails
>  And i have this task in my TODO list
> 
>  thanks for pinging me :)
> 
>  On Fri, 19 Apr 2019 at 10:36, Siovel Rodriguez 
> wrote:
>  >
>  > Hi Maxim, I'm still trying to integrate OM with Asterisk. I have
> some doubts. I installed the Zoiper application to perform the tests, I
> logged in with the user red5sip_user in the Zoiper application and wanted
> to know if after logging in I should see that user (red5sip_user) inside a
> room in OM to be able to make the video conference. If you could comment a
> bit on the mechanism of operation I would appreciate it because it is not
> entirely clear to me.
>  >
>  > Regards
>  >
>  > El mié., 17 abr. 2019 a las 10:34, Siovel Rodriguez (<
> siove...@gmail.com>) escribió:
>  >>
>  >> Hi Maxim, I'm still trying to integrate OM with Asterisk. I have
> some doubts. I installed the Zoiper application to perform the tests, I
> logged in with the user red5sip_user in the Zoiper application and wanted
> to know if after logging in I should see that user (red5sip_user) inside a
> room in OM to be able to make the video conference. If you could comment a
> bit on the mechanism of operation I would appreciate it because it is not
> entirely clear to me.
>  >>
>  >> Regards
>  >>
>  >> El jue., 11 abr. 2019 a las 21:12, Maxim Solodovnik (<
> solomax...@gmail.com>) escribió:
>  >>>
>  >>> Just have opened old database with working integration
>  >>> There is no `asterisk` table
>  >>>
>  >>> Will try to find time and double-check steps
>  >>>
>  >>> On Fri, 12 Apr 2019 at 01:03, Siovel Rodriguez <
> siove...@gmail.com> wrote:
>  
>   Yes Maxim, I did everything exactly as it says in the site. Even
> with the asterisk version, the asterisk-13.17.0
>  
>   El jue., 11 abr. 2019 a las 12:44, Maxim Solodovnik (<
> solomax...@gmail.com>) escribió:
>  >
>  > I have configured Asterisk several years ago
>  > If I do remember correctly steps listed at site are complete
>  >
>  > Not sure when I'll be able to double check everything :(
>  > Can you check you are using same version and follow the
> instruction step-by-step?
>  >
>  > On Thu, 11 Apr 2019 at 23:13, Siovel Rodriguez <
> siove...@gmail.com> wrote:
>  >>
>  >> I changed by now I have this in the Asterisk logs
>  >>
>  >> [Apr 11 11:54:05] WARNING[1326] res_config_mysql.c: MySQL
> RealTime: Failed to query database: Table 'open404.asterisk' doesn't exist
>  >>
>  >> Should be create an Asterisk table in open404 data 

Re: OM-access with 2 subdomains

2019-05-15 Thread R. Scholz

... and the port defined in the base-url.



Am 15.05.2019 um 17:53 schrieb Scholz, Rene:

Hello Maxim,

it ever uses the base-url from the configuration for generating the link.

Best regards,

René




Am Mittwoch, den 15.05.2019 um 12:20 schrieb Maxim Solodovnik:

Hello Rene,

If I do remember correctly current base URL (retrieved via JS
callback) is used while invitations generation
So this should work as follows:

1) user A access OM at port 5443
2) generates the link (send invitation)
Result: base URL has port 5443

1) user B access OM at port 5444
2) generates the link (send invitation)
Result: base URL has port 5444

Can you check if it works for you?

On Wed, 15 May 2019 at 13:48, R. Scholz
 wrote:
>
> Hello,
>
> I want to access my OM-instance over 2 Subdomains.
> One subdomain use port 5443 (with the correct certificate) the other
> over port 5444.
>
> When I send an invitation the link-generator use the setting in the
> OM-configuration.
> Thats clear.
>
> My Idea:
> Is it possible to implement "a wildcard" so the invitation-link
use the
> invoking address?
> Or is it possible to implement different URL-settings for
different port?
> Or any other idea?
>
> With best regards,
>
> René



-- 
WBR

Maxim aka solomax





Re: OM-access with 2 subdomains

2019-05-15 Thread Scholz, Rene
Hello Maxim,


it ever uses the base-url from the configuration for generating the
link.


Best regards,

René

    



Am Mittwoch, den 15.05.2019 um 12:20 schrieb Maxim Solodovnik:


Hello Rene,

If I do remember correctly current base URL (retrieved via JS
callback) is used while invitations generation
So this should work as follows:

1) user A access OM at port 5443
2) generates the link (send invitation)
Result: base URL has port 5443

1) user B access OM at port 5444
2) generates the link (send invitation)
Result: base URL has port 5444

Can you check if it works for you?

On Wed, 15 May 2019 at 13:48, R. Scholz
 wrote:
>
> Hello,
>
> I want to access my OM-instance over 2 Subdomains.
> One subdomain use port 5443 (with the correct certificate) the other
> over port 5444.
>
> When I send an invitation the link-generator use the setting in the
> OM-configuration.
> Thats clear.
>
> My Idea:
> Is it possible to implement "a wildcard" so the invitation-link use
the
> invoking address?
> Or is it possible to implement different URL-settings for different
port?
> Or any other idea?
>
> With best regards,
>
> René



-- 
WBR
Maxim aka solomax


conversion problem during update

2019-05-15 Thread 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 long time (I had over 500 videos)


Maybe ffmpeg command is a bit different for other versions.

Greetings Peter







Re: OM-access with 2 subdomains

2019-05-15 Thread Maxim Solodovnik
Hello Rene,

If I do remember correctly current base URL (retrieved via JS
callback) is used while invitations generation
So this should work as follows:

1) user A access OM at port 5443
2) generates the link (send invitation)
Result: base URL has port 5443

1) user B access OM at port 5444
2) generates the link (send invitation)
Result: base URL has port 5444

Can you check if it works for you?

On Wed, 15 May 2019 at 13:48, R. Scholz
 wrote:
>
> Hello,
>
> I want to access my OM-instance over 2 Subdomains.
> One subdomain use port 5443 (with the correct certificate) the other
> over port 5444.
>
> When I send an invitation the link-generator use the setting in the
> OM-configuration.
> Thats clear.
>
> My Idea:
> Is it possible to implement "a wildcard" so the invitation-link use the
> invoking address?
> Or is it possible to implement different URL-settings for different port?
> Or any other idea?
>
> With best regards,
>
> René



-- 
WBR
Maxim aka solomax


Re: Asterisk Integration

2019-05-15 Thread Maxim Solodovnik
Hello Siovel,

sorry for the long response we had long public holidays :)))

If I do remember correctly to connect you need to:
1) run Asterisk
2) run OM with Asterisk support
3) run red5-sip connected with OM
4) open Admin->Rooms
5) go to particular room settings and check "Enable SIP transport in the room"
As a result you should have "SIP number" assigned to room
(optionally you can also set PIN at this stage)

later on you can enter this room via any native client and you will
see "SIP Transport" user in user list

BAD news: video support is buggy and unstable :(
I plan to re-implement the whole integration for 5.0.0
No estimates so far :(

On Tue, 30 Apr 2019 at 10:35, Siovel Rodriguez  wrote:
>
> Hello Maxim, thanks for your response. I will try to do the whole process 
> again. Anyway I have some doubts. I installed the Zoiper application to 
> perform the tests, I logged in with the user red5sip_user in the Zoiper 
> application and wanted to know if after logging in I should see that user 
> (red5sip_user) inside a room in OM to be able to make the video conference . 
> If you could comment a bit on the mechanism of operation I would appreciate 
> it because it is not entirely clear to me.
>
> Please, I would appreciate your help
> Greetings
>
> El vie., 26 abr. 2019 a las 1:31, Maxim Solodovnik () 
> escribió:
>>
>> Hello Siovel,
>>
>> I'm sorry it took so long, finally I was able to find time and perform 
>> step-by step config one more time
>>
>> My steps (at Ubuntu 16.04 server):
>> 1) apt remove --purge asterisk
>> 2) manually delete /etc/asterisk /usr/src/asterisk /var/spool/asterisk
>> 3) perform all steps from official guide 
>> https://openmeetings.apache.org/voip-sip-integration.html
>> 4) run asterisk in debug mode: `reset && sudo asterisk -`
>> No MySql related errors
>>
>>
>> On Fri, 19 Apr 2019 at 11:24, Siovel Rodriguez  wrote:
>>>
>>> Thanks Maxim. I'll be waiting for your help. Very thankful
>>>
>>> El jue., 18 abr. 2019 a las 23:42, Maxim Solodovnik 
>>> () escribió:

 Hello Siovel,
 I'm reading your emails
 And i have this task in my TODO list

 thanks for pinging me :)

 On Fri, 19 Apr 2019 at 10:36, Siovel Rodriguez  wrote:
 >
 > Hi Maxim, I'm still trying to integrate OM with Asterisk. I have some 
 > doubts. I installed the Zoiper application to perform the tests, I 
 > logged in with the user red5sip_user in the Zoiper application and 
 > wanted to know if after logging in I should see that user (red5sip_user) 
 > inside a room in OM to be able to make the video conference. If you 
 > could comment a bit on the mechanism of operation I would appreciate it 
 > because it is not entirely clear to me.
 >
 > Regards
 >
 > El mié., 17 abr. 2019 a las 10:34, Siovel Rodriguez 
 > () escribió:
 >>
 >> Hi Maxim, I'm still trying to integrate OM with Asterisk. I have some 
 >> doubts. I installed the Zoiper application to perform the tests, I 
 >> logged in with the user red5sip_user in the Zoiper application and 
 >> wanted to know if after logging in I should see that user 
 >> (red5sip_user) inside a room in OM to be able to make the video 
 >> conference. If you could comment a bit on the mechanism of operation I 
 >> would appreciate it because it is not entirely clear to me.
 >>
 >> Regards
 >>
 >> El jue., 11 abr. 2019 a las 21:12, Maxim Solodovnik 
 >> () escribió:
 >>>
 >>> Just have opened old database with working integration
 >>> There is no `asterisk` table
 >>>
 >>> Will try to find time and double-check steps
 >>>
 >>> On Fri, 12 Apr 2019 at 01:03, Siovel Rodriguez  
 >>> wrote:
 
  Yes Maxim, I did everything exactly as it says in the site. Even with 
  the asterisk version, the asterisk-13.17.0
 
  El jue., 11 abr. 2019 a las 12:44, Maxim Solodovnik 
  () escribió:
 >
 > I have configured Asterisk several years ago
 > If I do remember correctly steps listed at site are complete
 >
 > Not sure when I'll be able to double check everything :(
 > Can you check you are using same version and follow the instruction 
 > step-by-step?
 >
 > On Thu, 11 Apr 2019 at 23:13, Siovel Rodriguez  
 > wrote:
 >>
 >> I changed by now I have this in the Asterisk logs
 >>
 >> [Apr 11 11:54:05] WARNING[1326] res_config_mysql.c: MySQL RealTime: 
 >> Failed to query database: Table 'open404.asterisk' doesn't exist
 >>
 >> Should be create an Asterisk table in open404 data base?
 >> What should I do?
 >>
 >> El jue., 11 abr. 2019 a las 11:35, Maxim Solodovnik 
 >> () escribió:
 >>>
 >>> This section describes OM database
 >>>
 >>> On Thu, 11 Apr 2019 at 22:10, Siovel 

OM-access with 2 subdomains

2019-05-15 Thread R. Scholz

Hello,

I want to access my OM-instance over 2 Subdomains.
One subdomain use port 5443 (with the correct certificate) the other 
over port 5444.


When I send an invitation the link-generator use the setting in the 
OM-configuration.

Thats clear.

My Idea:
Is it possible to implement "a wildcard" so the invitation-link use the 
invoking address?

Or is it possible to implement different URL-settings for different port?
Or any other idea?

With best regards,

René


Re: https-certificate - Lets encrypt

2019-05-15 Thread R. Scholz

Hello and good morning,

yesterday in the evening I had successfully installed the lets 
encrypt-certificate.


Great.

If anybody wants a "step-by-step-receipt" to implement a lets-encrypt 
certificate in a computer behind a firewall

(no access over port 80): Send me a hint. I have some notes (in german).
Requirement: You must have access to the DNS-Settings of your Domain 
(Sub-Domain) to add a record.


With best regards,

René



Am 14.05.2019 um 15:36 schrieb Maxim Solodovnik:

Maybe "certificateChainFile="conf/chain.pem""  should be fullchain.pem?
Additionally you can turn ON SSL debug logging to get more details

On Tue, 14 May 2019 at 20:33, René Scholz
 wrote:

Hello,

I try to import an lets encrypt-certificate into OM 5-M2.

With a few commands I have 4 certificates (wildcard-certificate):
cert.pem
chain.pem
fullchain.pem
privkey.pem

I try to edit the server.xml, remark the original lines for "connector port 
5443" and replace it with:


   
 
   


And - nothing. Tomcat doesn't start with the error

14-May-2019 15:31:13.005 SCHWERWIEGEND [main] 
org.apache.catalina.startup.Catalina.start Cannot start server, server instance 
is not configured

Have anyone a hint where I make a mistake?

With best regards,

René