You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by Siovel Rodriguez <si...@gmail.com> on 2019/04/11 15:09:56 UTC
Asterisk Integration
Hello Maxim and other members of the OM community, I am trying to integrate
om4.04 with Asterisk. I followed the steps of this link
https://openmeetings.apache.org/voip-sip-integration.html but I have left
the doubt with the following configuration
Configure MySQL module:
Set valid data for MySQL in /etc/asterisk/res_config_mysql.conf:
Example
[general]
dbhost = 127.0.0.1
dbname = openmeetings
dbuser = root
dbpass =
dbport = 3306
dbsock = /var/lib/mysql/mysql.sock
dbcharset = utf8
requirements = warn
The database openmeetings is the database of the installation of OM4.04 or
is that of Asterisk?. In that case that database is not created and the
following error appears in the Asterisk logs.
Apr 11 10:40:20] ERROR [1315] res_config_mysql.c: MySQL RealTime: Failed to
connect database server openmeetings on 127.0.0.1 (err 1049). Check debug
for more info.
Please, I would appreciate your help
Greetings
Re: Asterisk Integration
Posted by Siovel Rodriguez <si...@gmail.com>.
Thanks Maxim.
Greetings
El mié., 15 may. 2019 a las 6:16, Maxim Solodovnik (<so...@gmail.com>)
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 <si...@gmail.com> 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 (<
> solomax666@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 -vvvvvvvv`
> >> No MySql related errors
> >>
> >>
> >> On Fri, 19 Apr 2019 at 11:24, Siovel Rodriguez <si...@gmail.com>
> wrote:
> >>>
> >>> Thanks Maxim. I'll be waiting for your help. Very thankful
> >>>
> >>> El jue., 18 abr. 2019 a las 23:42, Maxim Solodovnik (<
> solomax666@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 <si...@gmail.com>
> 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 (<
> siovelrm@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 (<
> solomax666@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 <
> siovelrm@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 (<
> solomax666@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 <
> siovelrm@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 base?
> >>>> >>>>>> What should I do?
> >>>> >>>>>>
> >>>> >>>>>> El jue., 11 abr. 2019 a las 11:35, Maxim Solodovnik (<
> solomax666@gmail.com>) escribió:
> >>>> >>>>>>>
> >>>> >>>>>>> This section describes OM database
> >>>> >>>>>>>
> >>>> >>>>>>> On Thu, 11 Apr 2019 at 22:10, Siovel Rodriguez <
> siovelrm@gmail.com> wrote:
> >>>> >>>>>>>>
> >>>> >>>>>>>> Hello Maxim and other members of the OM community, I am
> trying to integrate om4.04 with Asterisk. I followed the steps of this link
> https://openmeetings.apache.org/voip-sip-integration.html but I have left
> the doubt with the following configuration
> >>>> >>>>>>>>
> >>>> >>>>>>>> Configure MySQL module:
> >>>> >>>>>>>>
> >>>> >>>>>>>> Set valid data for MySQL in
> /etc/asterisk/res_config_mysql.conf:
> >>>> >>>>>>>> Example
> >>>> >>>>>>>>
> >>>> >>>>>>>>
> >>>> >>>>>>>> [general]
> >>>> >>>>>>>> dbhost = 127.0.0.1
> >>>> >>>>>>>> dbname = openmeetings
> >>>> >>>>>>>> dbuser = root
> >>>> >>>>>>>> dbpass =
> >>>> >>>>>>>> dbport = 3306
> >>>> >>>>>>>> dbsock = /var/lib/mysql/mysql.sock
> >>>> >>>>>>>> dbcharset = utf8
> >>>> >>>>>>>> requirements = warn
> >>>> >>>>>>>>
> >>>> >>>>>>>> The database openmeetings is the database of the
> installation of OM4.04 or is that of Asterisk?. In that case that database
> is not created and the following error appears in the Asterisk logs.
> >>>> >>>>>>>> Apr 11 10:40:20] ERROR [1315] res_config_mysql.c: MySQL
> RealTime: Failed to connect database server openmeetings on 127.0.0.1 (err
> 1049). Check debug for more info.
> >>>> >>>>>>>>
> >>>> >>>>>>>> Please, I would appreciate your help
> >>>> >>>>>>>>
> >>>> >>>>>>>> Greetings
> >>>> >>>>>>>
> >>>> >>>>>>>
> >>>> >>>>>>>
> >>>> >>>>>>> --
> >>>> >>>>>>> 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: Asterisk Integration
Posted by Maxim Solodovnik <so...@gmail.com>.
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 <si...@gmail.com> 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 (<so...@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 -vvvvvvvv`
>> No MySql related errors
>>
>>
>> On Fri, 19 Apr 2019 at 11:24, Siovel Rodriguez <si...@gmail.com> wrote:
>>>
>>> Thanks Maxim. I'll be waiting for your help. Very thankful
>>>
>>> El jue., 18 abr. 2019 a las 23:42, Maxim Solodovnik (<so...@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 <si...@gmail.com> 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 (<si...@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 (<so...@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 <si...@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 (<so...@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 <si...@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 base?
>>>> >>>>>> What should I do?
>>>> >>>>>>
>>>> >>>>>> El jue., 11 abr. 2019 a las 11:35, Maxim Solodovnik (<so...@gmail.com>) escribió:
>>>> >>>>>>>
>>>> >>>>>>> This section describes OM database
>>>> >>>>>>>
>>>> >>>>>>> On Thu, 11 Apr 2019 at 22:10, Siovel Rodriguez <si...@gmail.com> wrote:
>>>> >>>>>>>>
>>>> >>>>>>>> Hello Maxim and other members of the OM community, I am trying to integrate om4.04 with Asterisk. I followed the steps of this link https://openmeetings.apache.org/voip-sip-integration.html but I have left the doubt with the following configuration
>>>> >>>>>>>>
>>>> >>>>>>>> Configure MySQL module:
>>>> >>>>>>>>
>>>> >>>>>>>> Set valid data for MySQL in /etc/asterisk/res_config_mysql.conf:
>>>> >>>>>>>> Example
>>>> >>>>>>>>
>>>> >>>>>>>>
>>>> >>>>>>>> [general]
>>>> >>>>>>>> dbhost = 127.0.0.1
>>>> >>>>>>>> dbname = openmeetings
>>>> >>>>>>>> dbuser = root
>>>> >>>>>>>> dbpass =
>>>> >>>>>>>> dbport = 3306
>>>> >>>>>>>> dbsock = /var/lib/mysql/mysql.sock
>>>> >>>>>>>> dbcharset = utf8
>>>> >>>>>>>> requirements = warn
>>>> >>>>>>>>
>>>> >>>>>>>> The database openmeetings is the database of the installation of OM4.04 or is that of Asterisk?. In that case that database is not created and the following error appears in the Asterisk logs.
>>>> >>>>>>>> Apr 11 10:40:20] ERROR [1315] res_config_mysql.c: MySQL RealTime: Failed to connect database server openmeetings on 127.0.0.1 (err 1049). Check debug for more info.
>>>> >>>>>>>>
>>>> >>>>>>>> Please, I would appreciate your help
>>>> >>>>>>>>
>>>> >>>>>>>> Greetings
>>>> >>>>>>>
>>>> >>>>>>>
>>>> >>>>>>>
>>>> >>>>>>> --
>>>> >>>>>>> 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: Asterisk Integration
Posted by Siovel Rodriguez <si...@gmail.com>.
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 (<so...@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 -vvvvvvvv`
> No MySql related errors
>
>
> On Fri, 19 Apr 2019 at 11:24, Siovel Rodriguez <si...@gmail.com> wrote:
>
>> Thanks Maxim. I'll be waiting for your help. Very thankful
>>
>> El jue., 18 abr. 2019 a las 23:42, Maxim Solodovnik (<
>> solomax666@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 <si...@gmail.com>
>>> 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 (<
>>> siovelrm@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 (<
>>> solomax666@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 <si...@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 (<
>>> solomax666@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 <si...@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 base?
>>> >>>>>> What should I do?
>>> >>>>>>
>>> >>>>>> El jue., 11 abr. 2019 a las 11:35, Maxim Solodovnik (<
>>> solomax666@gmail.com>) escribió:
>>> >>>>>>>
>>> >>>>>>> This section describes OM database
>>> >>>>>>>
>>> >>>>>>> On Thu, 11 Apr 2019 at 22:10, Siovel Rodriguez <
>>> siovelrm@gmail.com> wrote:
>>> >>>>>>>>
>>> >>>>>>>> Hello Maxim and other members of the OM community, I am trying
>>> to integrate om4.04 with Asterisk. I followed the steps of this link
>>> https://openmeetings.apache.org/voip-sip-integration.html but I have
>>> left the doubt with the following configuration
>>> >>>>>>>>
>>> >>>>>>>> Configure MySQL module:
>>> >>>>>>>>
>>> >>>>>>>> Set valid data for MySQL in /etc/asterisk/res_config_mysql.conf:
>>> >>>>>>>> Example
>>> >>>>>>>>
>>> >>>>>>>>
>>> >>>>>>>> [general]
>>> >>>>>>>> dbhost = 127.0.0.1
>>> >>>>>>>> dbname = openmeetings
>>> >>>>>>>> dbuser = root
>>> >>>>>>>> dbpass =
>>> >>>>>>>> dbport = 3306
>>> >>>>>>>> dbsock = /var/lib/mysql/mysql.sock
>>> >>>>>>>> dbcharset = utf8
>>> >>>>>>>> requirements = warn
>>> >>>>>>>>
>>> >>>>>>>> The database openmeetings is the database of the installation
>>> of OM4.04 or is that of Asterisk?. In that case that database is not
>>> created and the following error appears in the Asterisk logs.
>>> >>>>>>>> Apr 11 10:40:20] ERROR [1315] res_config_mysql.c: MySQL
>>> RealTime: Failed to connect database server openmeetings on 127.0.0.1 (err
>>> 1049). Check debug for more info.
>>> >>>>>>>>
>>> >>>>>>>> Please, I would appreciate your help
>>> >>>>>>>>
>>> >>>>>>>> Greetings
>>> >>>>>>>
>>> >>>>>>>
>>> >>>>>>>
>>> >>>>>>> --
>>> >>>>>>> WBR
>>> >>>>>>> Maxim aka solomax
>>> >>>>>
>>> >>>>>
>>> >>>>>
>>> >>>>> --
>>> >>>>> WBR
>>> >>>>> Maxim aka solomax
>>> >>>
>>> >>>
>>> >>>
>>> >>> --
>>> >>> WBR
>>> >>> Maxim aka solomax
>>>
>>>
>>>
>>> --
>>> WBR
>>> Maxim aka solomax
>>>
>>
>
> --
> WBR
> Maxim aka solomax
>
Re: Asterisk Integration
Posted by Maxim Solodovnik <so...@gmail.com>.
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 -vvvvvvvv`
No MySql related errors
On Fri, 19 Apr 2019 at 11:24, Siovel Rodriguez <si...@gmail.com> wrote:
> Thanks Maxim. I'll be waiting for your help. Very thankful
>
> El jue., 18 abr. 2019 a las 23:42, Maxim Solodovnik (<so...@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 <si...@gmail.com>
>> 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 (<
>> siovelrm@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 (<
>> solomax666@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 <si...@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 (<
>> solomax666@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 <si...@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 base?
>> >>>>>> What should I do?
>> >>>>>>
>> >>>>>> El jue., 11 abr. 2019 a las 11:35, Maxim Solodovnik (<
>> solomax666@gmail.com>) escribió:
>> >>>>>>>
>> >>>>>>> This section describes OM database
>> >>>>>>>
>> >>>>>>> On Thu, 11 Apr 2019 at 22:10, Siovel Rodriguez <
>> siovelrm@gmail.com> wrote:
>> >>>>>>>>
>> >>>>>>>> Hello Maxim and other members of the OM community, I am trying
>> to integrate om4.04 with Asterisk. I followed the steps of this link
>> https://openmeetings.apache.org/voip-sip-integration.html but I have
>> left the doubt with the following configuration
>> >>>>>>>>
>> >>>>>>>> Configure MySQL module:
>> >>>>>>>>
>> >>>>>>>> Set valid data for MySQL in /etc/asterisk/res_config_mysql.conf:
>> >>>>>>>> Example
>> >>>>>>>>
>> >>>>>>>>
>> >>>>>>>> [general]
>> >>>>>>>> dbhost = 127.0.0.1
>> >>>>>>>> dbname = openmeetings
>> >>>>>>>> dbuser = root
>> >>>>>>>> dbpass =
>> >>>>>>>> dbport = 3306
>> >>>>>>>> dbsock = /var/lib/mysql/mysql.sock
>> >>>>>>>> dbcharset = utf8
>> >>>>>>>> requirements = warn
>> >>>>>>>>
>> >>>>>>>> The database openmeetings is the database of the installation of
>> OM4.04 or is that of Asterisk?. In that case that database is not created
>> and the following error appears in the Asterisk logs.
>> >>>>>>>> Apr 11 10:40:20] ERROR [1315] res_config_mysql.c: MySQL
>> RealTime: Failed to connect database server openmeetings on 127.0.0.1 (err
>> 1049). Check debug for more info.
>> >>>>>>>>
>> >>>>>>>> Please, I would appreciate your help
>> >>>>>>>>
>> >>>>>>>> Greetings
>> >>>>>>>
>> >>>>>>>
>> >>>>>>>
>> >>>>>>> --
>> >>>>>>> WBR
>> >>>>>>> Maxim aka solomax
>> >>>>>
>> >>>>>
>> >>>>>
>> >>>>> --
>> >>>>> WBR
>> >>>>> Maxim aka solomax
>> >>>
>> >>>
>> >>>
>> >>> --
>> >>> WBR
>> >>> Maxim aka solomax
>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>
--
WBR
Maxim aka solomax
Re: Asterisk Integration
Posted by Siovel Rodriguez <si...@gmail.com>.
Thanks Maxim. I'll be waiting for your help. Very thankful
El jue., 18 abr. 2019 a las 23:42, Maxim Solodovnik (<so...@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 <si...@gmail.com> 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 (<si...@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 (<
> solomax666@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 <si...@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 (<
> solomax666@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 <si...@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 base?
> >>>>>> What should I do?
> >>>>>>
> >>>>>> El jue., 11 abr. 2019 a las 11:35, Maxim Solodovnik (<
> solomax666@gmail.com>) escribió:
> >>>>>>>
> >>>>>>> This section describes OM database
> >>>>>>>
> >>>>>>> On Thu, 11 Apr 2019 at 22:10, Siovel Rodriguez <si...@gmail.com>
> wrote:
> >>>>>>>>
> >>>>>>>> Hello Maxim and other members of the OM community, I am trying to
> integrate om4.04 with Asterisk. I followed the steps of this link
> https://openmeetings.apache.org/voip-sip-integration.html but I have left
> the doubt with the following configuration
> >>>>>>>>
> >>>>>>>> Configure MySQL module:
> >>>>>>>>
> >>>>>>>> Set valid data for MySQL in /etc/asterisk/res_config_mysql.conf:
> >>>>>>>> Example
> >>>>>>>>
> >>>>>>>>
> >>>>>>>> [general]
> >>>>>>>> dbhost = 127.0.0.1
> >>>>>>>> dbname = openmeetings
> >>>>>>>> dbuser = root
> >>>>>>>> dbpass =
> >>>>>>>> dbport = 3306
> >>>>>>>> dbsock = /var/lib/mysql/mysql.sock
> >>>>>>>> dbcharset = utf8
> >>>>>>>> requirements = warn
> >>>>>>>>
> >>>>>>>> The database openmeetings is the database of the installation of
> OM4.04 or is that of Asterisk?. In that case that database is not created
> and the following error appears in the Asterisk logs.
> >>>>>>>> Apr 11 10:40:20] ERROR [1315] res_config_mysql.c: MySQL RealTime:
> Failed to connect database server openmeetings on 127.0.0.1 (err 1049).
> Check debug for more info.
> >>>>>>>>
> >>>>>>>> Please, I would appreciate your help
> >>>>>>>>
> >>>>>>>> Greetings
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>> --
> >>>>>>> WBR
> >>>>>>> Maxim aka solomax
> >>>>>
> >>>>>
> >>>>>
> >>>>> --
> >>>>> WBR
> >>>>> Maxim aka solomax
> >>>
> >>>
> >>>
> >>> --
> >>> WBR
> >>> Maxim aka solomax
>
>
>
> --
> WBR
> Maxim aka solomax
>
Re: Asterisk Integration
Posted by Maxim Solodovnik <so...@gmail.com>.
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 <si...@gmail.com> 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 (<si...@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 (<so...@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 <si...@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 (<so...@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 <si...@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 base?
>>>>>> What should I do?
>>>>>>
>>>>>> El jue., 11 abr. 2019 a las 11:35, Maxim Solodovnik (<so...@gmail.com>) escribió:
>>>>>>>
>>>>>>> This section describes OM database
>>>>>>>
>>>>>>> On Thu, 11 Apr 2019 at 22:10, Siovel Rodriguez <si...@gmail.com> wrote:
>>>>>>>>
>>>>>>>> Hello Maxim and other members of the OM community, I am trying to integrate om4.04 with Asterisk. I followed the steps of this link https://openmeetings.apache.org/voip-sip-integration.html but I have left the doubt with the following configuration
>>>>>>>>
>>>>>>>> Configure MySQL module:
>>>>>>>>
>>>>>>>> Set valid data for MySQL in /etc/asterisk/res_config_mysql.conf:
>>>>>>>> Example
>>>>>>>>
>>>>>>>>
>>>>>>>> [general]
>>>>>>>> dbhost = 127.0.0.1
>>>>>>>> dbname = openmeetings
>>>>>>>> dbuser = root
>>>>>>>> dbpass =
>>>>>>>> dbport = 3306
>>>>>>>> dbsock = /var/lib/mysql/mysql.sock
>>>>>>>> dbcharset = utf8
>>>>>>>> requirements = warn
>>>>>>>>
>>>>>>>> The database openmeetings is the database of the installation of OM4.04 or is that of Asterisk?. In that case that database is not created and the following error appears in the Asterisk logs.
>>>>>>>> Apr 11 10:40:20] ERROR [1315] res_config_mysql.c: MySQL RealTime: Failed to connect database server openmeetings on 127.0.0.1 (err 1049). Check debug for more info.
>>>>>>>>
>>>>>>>> Please, I would appreciate your help
>>>>>>>>
>>>>>>>> Greetings
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> WBR
>>>>>>> Maxim aka solomax
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> WBR
>>>>> Maxim aka solomax
>>>
>>>
>>>
>>> --
>>> WBR
>>> Maxim aka solomax
--
WBR
Maxim aka solomax
Re: Asterisk Integration
Posted by Siovel Rodriguez <si...@gmail.com>.
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 (<si...@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 (<so...@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 <si...@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 (<
>>> solomax666@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 <si...@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 base?
>>>>> What should I do?
>>>>>
>>>>> El jue., 11 abr. 2019 a las 11:35, Maxim Solodovnik (<
>>>>> solomax666@gmail.com>) escribió:
>>>>>
>>>>>> This section describes OM database
>>>>>>
>>>>>> On Thu, 11 Apr 2019 at 22:10, Siovel Rodriguez <si...@gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>> Hello Maxim and other members of the OM community, I am trying to
>>>>>>> integrate om4.04 with Asterisk. I followed the steps of this link
>>>>>>> https://openmeetings.apache.org/voip-sip-integration.html but I
>>>>>>> have left the doubt with the following configuration
>>>>>>>
>>>>>>> Configure MySQL module:
>>>>>>>
>>>>>>> Set valid data for MySQL in /etc/asterisk/res_config_mysql.conf:
>>>>>>> Example
>>>>>>>
>>>>>>>
>>>>>>> [general]
>>>>>>> dbhost = 127.0.0.1
>>>>>>> dbname = openmeetings
>>>>>>> dbuser = root
>>>>>>> dbpass =
>>>>>>> dbport = 3306
>>>>>>> dbsock = /var/lib/mysql/mysql.sock
>>>>>>> dbcharset = utf8
>>>>>>> requirements = warn
>>>>>>>
>>>>>>> The database openmeetings is the database of the installation of
>>>>>>> OM4.04 or is that of Asterisk?. In that case that database is not
>>>>>>> created and the following error appears in the Asterisk logs.
>>>>>>> Apr 11 10:40:20] ERROR [1315] res_config_mysql.c: MySQL RealTime:
>>>>>>> Failed to connect database server openmeetings on 127.0.0.1 (err 1049). Check
>>>>>>> debug for more info.
>>>>>>>
>>>>>>> Please, I would appreciate your help
>>>>>>>
>>>>>>> Greetings
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> WBR
>>>>>> Maxim aka solomax
>>>>>>
>>>>>
>>>>
>>>> --
>>>> WBR
>>>> Maxim aka solomax
>>>>
>>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>
Re: Lets encrypt
Posted by Maxim Solodovnik <so...@gmail.com>.
OM5 is based on Tomcat9 without any major customizations (only port is
customized)
So your question is "How to configure Tomcat with Letsencrypt" :)
Here is the first link from google:
https://medium.com/@raupach/how-to-install-lets-encrypt-with-tomcat-3db8a469e3d2
there are lots of unnecessary steps in this guide but it can help :)
I would say you need to
1) set up certbot to get and renew your cert
2) set up this certificate in Tomcat:
<Connector port="5443" ............................... SSLEnabled="true">
<SSLHostConfig>
<Certificate certificateFile="conf/cert.pem"
certificateKeyFile="conf/privkey.pem"
certificateChainFile="conf/chain.pem" />
</SSLHostConfig>
</Connector>
As an alternative you can set Apache/Nginx as front end proxy to do SSL :)
On Thu, 18 Apr 2019 at 13:01, René Scholz
<re...@abakus-edv-systems.de> wrote:
>
> Hello,
>
> it's possible that everybody knows how to do: Is everywhere a manual how
> I can implement a letsencrypt-certificate in OM5?
>
> Best regards,
>
> René
--
WBR
Maxim aka solomax
Lets encrypt
Posted by René Scholz <re...@abakus-edv-systems.de>.
Hello,
it's possible that everybody knows how to do: Is everywhere a manual how
I can implement a letsencrypt-certificate in OM5?
Best regards,
René
Re: Asterisk Integration
Posted by Siovel Rodriguez <si...@gmail.com>.
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 (<so...@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 <si...@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 (<
>> solomax666@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 <si...@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 base?
>>>> What should I do?
>>>>
>>>> El jue., 11 abr. 2019 a las 11:35, Maxim Solodovnik (<
>>>> solomax666@gmail.com>) escribió:
>>>>
>>>>> This section describes OM database
>>>>>
>>>>> On Thu, 11 Apr 2019 at 22:10, Siovel Rodriguez <si...@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> Hello Maxim and other members of the OM community, I am trying to
>>>>>> integrate om4.04 with Asterisk. I followed the steps of this link
>>>>>> https://openmeetings.apache.org/voip-sip-integration.html but I have
>>>>>> left the doubt with the following configuration
>>>>>>
>>>>>> Configure MySQL module:
>>>>>>
>>>>>> Set valid data for MySQL in /etc/asterisk/res_config_mysql.conf:
>>>>>> Example
>>>>>>
>>>>>>
>>>>>> [general]
>>>>>> dbhost = 127.0.0.1
>>>>>> dbname = openmeetings
>>>>>> dbuser = root
>>>>>> dbpass =
>>>>>> dbport = 3306
>>>>>> dbsock = /var/lib/mysql/mysql.sock
>>>>>> dbcharset = utf8
>>>>>> requirements = warn
>>>>>>
>>>>>> The database openmeetings is the database of the installation of
>>>>>> OM4.04 or is that of Asterisk?. In that case that database is not
>>>>>> created and the following error appears in the Asterisk logs.
>>>>>> Apr 11 10:40:20] ERROR [1315] res_config_mysql.c: MySQL RealTime:
>>>>>> Failed to connect database server openmeetings on 127.0.0.1 (err 1049). Check
>>>>>> debug for more info.
>>>>>>
>>>>>> Please, I would appreciate your help
>>>>>>
>>>>>> Greetings
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> WBR
>>>>> Maxim aka solomax
>>>>>
>>>>
>>>
>>> --
>>> WBR
>>> Maxim aka solomax
>>>
>>
>
> --
> WBR
> Maxim aka solomax
>
Re: Asterisk Integration
Posted by Maxim Solodovnik <so...@gmail.com>.
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 <si...@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 (<so...@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 <si...@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 base?
>>> What should I do?
>>>
>>> El jue., 11 abr. 2019 a las 11:35, Maxim Solodovnik (<
>>> solomax666@gmail.com>) escribió:
>>>
>>>> This section describes OM database
>>>>
>>>> On Thu, 11 Apr 2019 at 22:10, Siovel Rodriguez <si...@gmail.com>
>>>> wrote:
>>>>
>>>>> Hello Maxim and other members of the OM community, I am trying to
>>>>> integrate om4.04 with Asterisk. I followed the steps of this link
>>>>> https://openmeetings.apache.org/voip-sip-integration.html but I have
>>>>> left the doubt with the following configuration
>>>>>
>>>>> Configure MySQL module:
>>>>>
>>>>> Set valid data for MySQL in /etc/asterisk/res_config_mysql.conf:
>>>>> Example
>>>>>
>>>>>
>>>>> [general]
>>>>> dbhost = 127.0.0.1
>>>>> dbname = openmeetings
>>>>> dbuser = root
>>>>> dbpass =
>>>>> dbport = 3306
>>>>> dbsock = /var/lib/mysql/mysql.sock
>>>>> dbcharset = utf8
>>>>> requirements = warn
>>>>>
>>>>> The database openmeetings is the database of the installation of
>>>>> OM4.04 or is that of Asterisk?. In that case that database is not
>>>>> created and the following error appears in the Asterisk logs.
>>>>> Apr 11 10:40:20] ERROR [1315] res_config_mysql.c: MySQL RealTime:
>>>>> Failed to connect database server openmeetings on 127.0.0.1 (err 1049). Check
>>>>> debug for more info.
>>>>>
>>>>> Please, I would appreciate your help
>>>>>
>>>>> Greetings
>>>>>
>>>>
>>>>
>>>> --
>>>> WBR
>>>> Maxim aka solomax
>>>>
>>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>
--
WBR
Maxim aka solomax
Re: Asterisk Integration
Posted by Siovel Rodriguez <si...@gmail.com>.
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 (<so...@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 <si...@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 base?
>> What should I do?
>>
>> El jue., 11 abr. 2019 a las 11:35, Maxim Solodovnik (<
>> solomax666@gmail.com>) escribió:
>>
>>> This section describes OM database
>>>
>>> On Thu, 11 Apr 2019 at 22:10, Siovel Rodriguez <si...@gmail.com>
>>> wrote:
>>>
>>>> Hello Maxim and other members of the OM community, I am trying to
>>>> integrate om4.04 with Asterisk. I followed the steps of this link
>>>> https://openmeetings.apache.org/voip-sip-integration.html but I have
>>>> left the doubt with the following configuration
>>>>
>>>> Configure MySQL module:
>>>>
>>>> Set valid data for MySQL in /etc/asterisk/res_config_mysql.conf:
>>>> Example
>>>>
>>>>
>>>> [general]
>>>> dbhost = 127.0.0.1
>>>> dbname = openmeetings
>>>> dbuser = root
>>>> dbpass =
>>>> dbport = 3306
>>>> dbsock = /var/lib/mysql/mysql.sock
>>>> dbcharset = utf8
>>>> requirements = warn
>>>>
>>>> The database openmeetings is the database of the installation of OM4.04
>>>> or is that of Asterisk?. In that case that database is not created and
>>>> the following error appears in the Asterisk logs.
>>>> Apr 11 10:40:20] ERROR [1315] res_config_mysql.c: MySQL RealTime:
>>>> Failed to connect database server openmeetings on 127.0.0.1 (err 1049). Check
>>>> debug for more info.
>>>>
>>>> Please, I would appreciate your help
>>>>
>>>> Greetings
>>>>
>>>
>>>
>>> --
>>> WBR
>>> Maxim aka solomax
>>>
>>
>
> --
> WBR
> Maxim aka solomax
>
Re: Asterisk Integration
Posted by Maxim Solodovnik <so...@gmail.com>.
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 <si...@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 base?
> What should I do?
>
> El jue., 11 abr. 2019 a las 11:35, Maxim Solodovnik (<so...@gmail.com>)
> escribió:
>
>> This section describes OM database
>>
>> On Thu, 11 Apr 2019 at 22:10, Siovel Rodriguez <si...@gmail.com>
>> wrote:
>>
>>> Hello Maxim and other members of the OM community, I am trying to
>>> integrate om4.04 with Asterisk. I followed the steps of this link
>>> https://openmeetings.apache.org/voip-sip-integration.html but I have
>>> left the doubt with the following configuration
>>>
>>> Configure MySQL module:
>>>
>>> Set valid data for MySQL in /etc/asterisk/res_config_mysql.conf:
>>> Example
>>>
>>>
>>> [general]
>>> dbhost = 127.0.0.1
>>> dbname = openmeetings
>>> dbuser = root
>>> dbpass =
>>> dbport = 3306
>>> dbsock = /var/lib/mysql/mysql.sock
>>> dbcharset = utf8
>>> requirements = warn
>>>
>>> The database openmeetings is the database of the installation of OM4.04
>>> or is that of Asterisk?. In that case that database is not created and
>>> the following error appears in the Asterisk logs.
>>> Apr 11 10:40:20] ERROR [1315] res_config_mysql.c: MySQL RealTime: Failed
>>> to connect database server openmeetings on 127.0.0.1 (err 1049). Check
>>> debug for more info.
>>>
>>> Please, I would appreciate your help
>>>
>>> Greetings
>>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>
--
WBR
Maxim aka solomax
Re: Asterisk Integration
Posted by Siovel Rodriguez <si...@gmail.com>.
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 (<so...@gmail.com>)
escribió:
> This section describes OM database
>
> On Thu, 11 Apr 2019 at 22:10, Siovel Rodriguez <si...@gmail.com> wrote:
>
>> Hello Maxim and other members of the OM community, I am trying to
>> integrate om4.04 with Asterisk. I followed the steps of this link
>> https://openmeetings.apache.org/voip-sip-integration.html but I have
>> left the doubt with the following configuration
>>
>> Configure MySQL module:
>>
>> Set valid data for MySQL in /etc/asterisk/res_config_mysql.conf:
>> Example
>>
>>
>> [general]
>> dbhost = 127.0.0.1
>> dbname = openmeetings
>> dbuser = root
>> dbpass =
>> dbport = 3306
>> dbsock = /var/lib/mysql/mysql.sock
>> dbcharset = utf8
>> requirements = warn
>>
>> The database openmeetings is the database of the installation of OM4.04
>> or is that of Asterisk?. In that case that database is not created and
>> the following error appears in the Asterisk logs.
>> Apr 11 10:40:20] ERROR [1315] res_config_mysql.c: MySQL RealTime: Failed
>> to connect database server openmeetings on 127.0.0.1 (err 1049). Check
>> debug for more info.
>>
>> Please, I would appreciate your help
>>
>> Greetings
>>
>
>
> --
> WBR
> Maxim aka solomax
>
Re: Asterisk Integration
Posted by Maxim Solodovnik <so...@gmail.com>.
This section describes OM database
On Thu, 11 Apr 2019 at 22:10, Siovel Rodriguez <si...@gmail.com> wrote:
> Hello Maxim and other members of the OM community, I am trying to
> integrate om4.04 with Asterisk. I followed the steps of this link
> https://openmeetings.apache.org/voip-sip-integration.html but I have left
> the doubt with the following configuration
>
> Configure MySQL module:
>
> Set valid data for MySQL in /etc/asterisk/res_config_mysql.conf:
> Example
>
>
> [general]
> dbhost = 127.0.0.1
> dbname = openmeetings
> dbuser = root
> dbpass =
> dbport = 3306
> dbsock = /var/lib/mysql/mysql.sock
> dbcharset = utf8
> requirements = warn
>
> The database openmeetings is the database of the installation of OM4.04 or
> is that of Asterisk?. In that case that database is not created and the
> following error appears in the Asterisk logs.
> Apr 11 10:40:20] ERROR [1315] res_config_mysql.c: MySQL RealTime: Failed
> to connect database server openmeetings on 127.0.0.1 (err 1049). Check
> debug for more info.
>
> Please, I would appreciate your help
>
> Greetings
>
--
WBR
Maxim aka solomax