You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by Yah's Global Kingdom <ya...@gmail.com> on 2021/08/23 22:27:11 UTC

Settngs for Sip Manager

@Maxium
Asterisk:
Where are these settings located?

sip.manager.user=
sip.manager.password=
sip.manager.timeout=

Re: Settngs for Sip Manager

Posted by Maxim Solodovnik <so...@gmail.com>.
On Sat, 28 Aug 2021 at 05:30, Yah's Global Kingdom <ya...@gmail.com>
wrote:

> Thanks for your responses Maxim,
> I understand now and I have corrected:
> /etc/asterisk/manager.conf
> /etc/asterisk/extension.conf
>
> I manually added the extension to the Asterisk internal key-value DB
>
> meetings*CLI> database show
> /SIP/Registry/horace                              : 98.174.244.227:49952:60:horace:sip:horace@98.174.244.227:49952;transport=UDP;rinstance=0165778b0d1a09b9
> /SIP/Registry/horacecell                          : 172.58.69.178:45874:60:horacecell:sip:horacecell@172.58.69.178:45874;transport=UDP;rinstance=42c80f10d1bbc35f
> /dundi/secret                                     : HxawUR7CiWPsyMBN73Q2bQ==;HUnEDvN5+h2GVC1pW4GEYw==
> /dundi/secretexpiry                               : 1630104193
> /openmeetings/rooms                               : 40011
>
> the above line looks correct :)))


> /pbx/UUID                                         : 7dd6882b-8da9-4099-a6a7-3012970c94ca
> 6 results found.
>
> I still get invalid extension when I try to dial into the conference.  Also when I create a room and SIP enable it, should openmeetings be updating the asterisk internal key-value DB?
>
> According to the output of your Asterisk
It is being updated :)


> I think that it should be, so perhaps there is something still wrong between my /etc/asterisk/manager.conf and the /opt/om/webapps/openmeetings/WEB-INF/classes/openmeetings.properties settings.
>
> Thanks for all your help in getting me this far.
>
>
If I were you I would create new instance of Asterisk
Perform steps from https://openmeetings.apache.org/AsteriskIntegration.html
one-by-one very carefully (no other changes)
Then test
Then improve
Then contribute back :))))


>
> On Thu, Aug 26, 2021 at 7:05 AM Maxim Solodovnik <so...@gmail.com>
> wrote:
>
>>
>>
>> On Thu, 26 Aug 2021 at 21:03, Yah's Global Kingdom <ya...@gmail.com>
>> wrote:
>>
>>> Maxim, even if my openmeetings database is open504, this needs to be set
>>> to openmeetings?
>>>
>>
>> Yes
>> This is NOT MySQL OM DB
>> This is Asterisk internal key-value DB :)
>>
>>
>>>
>>> On Tue, Aug 24, 2021 at 11:09 PM Maxim Solodovnik <so...@gmail.com>
>>> wrote:
>>>
>>>>
>>>>
>>>> On Wed, 25 Aug 2021 at 09:38, Yah's Global Kingdom <ya...@gmail.com>
>>>> wrote:
>>>>
>>>>> Hi Maxim,
>>>>>
>>>>> Thanks for responding:
>>>>> What I am getting is invalid extension,  when I run asterisk -rx
>>>>> database show, I don't see anything from openmeetings
>>>>>
>>>>> meetings*CLI> database show
>>>>> /SIP/Registry/horace                              : 1.1.1.1:49952
>>>>> :60:horace:sip:horace@1.1.1.1.1
>>>>> :49952;transport=UDP;rinstance=fd20fb9e9a736274
>>>>> /SIP/Registry/horacecell                          : 172.58.69.178:45874
>>>>> :60:horacecell:sip:horacecell@172.58.69.178:45874
>>>>> ;transport=UDP;rinstance=d0bae988fae57944
>>>>> /dundi/secret                                     :
>>>>> Bk1zG+mtsgGrpKsMJw09EA==;wS1dMgw+F1jfle4crmWRAA==
>>>>> /dundi/secretexpiry                               : 1629852193
>>>>>
>>>>> /pbx/UUID                                         :
>>>>> 7dd6882b-8da9-4099-a6a7-3012970c94ca
>>>>> 5 results found.
>>>>>
>>>>> I am confused by these two lines in the Extensions.conf:
>>>>> exten =>
>>>>> _400X!,1,GotoIf($[${DB_EXISTS(open504/rooms/${EXTEN})}]?ok:notavail)
>>>>> exten => _400X!,n(ok),SET(PIN=${DB(open504/rooms/${EXTEN})})
>>>>>
>>>>
>>>> Well
>>>> I'm not sure why do you have such portion of config :(
>>>>
>>>> "reference" config looks like
>>>> https://openmeetings.apache.org/AsteriskIntegration.html#configure-extensions
>>>>
>>>> `openmeetings/rooms/....` is NOT DB table but some internal Asterisk
>>>> key-value DB
>>>> so `open504/rooms` looks wrong here
>>>> It should be `openmeetings/rooms`
>>>>
>>>>
>>>>
>>>>>
>>>>> 1.  in the database open504 I don't find a table named rooms, the
>>>>> table name in the database is room.
>>>>> 2.   I don't know why it is not registering the open504 database with
>>>>> Asterisk,  I am thinking the transport Agent is suppose to do that somehow,
>>>>> (just me thinking)
>>>>>
>>>>> meetings*CLI>
>>>>> Tables_in_open504      |
>>>>> +------------------------+
>>>>> | address                |
>>>>> | appointment            |
>>>>> | chat                   |
>>>>> | conference_log         |
>>>>> | configuration          |
>>>>> | email_queue            |
>>>>> | extra_menu             |
>>>>> | file_log               |
>>>>> | group_user             |
>>>>> | invitation             |
>>>>> | ldapconfig             |
>>>>> | meeting_member         |
>>>>> | menu_group             |
>>>>> | oauth_mapping          |
>>>>> | oauth_server           |
>>>>> | om_calendar            |
>>>>> | om_file                |
>>>>> | om_group               |
>>>>> | om_user                |
>>>>> | om_user_right          |
>>>>> | private_message        |
>>>>> | private_message_folder |
>>>>> | recording_chunk        |
>>>>> | room                   |
>>>>> | room_file              |
>>>>> | room_group             |
>>>>> | room_hide_element      |
>>>>> | room_moderator         |
>>>>> | room_poll              |
>>>>> | room_poll_answer       |
>>>>> | sessiondata            |
>>>>> | sipusers               |
>>>>> | soaplogin              |
>>>>> | user_contact           |
>>>>> +------------------------+
>>>>> 34 rows in set (0.00 sec)
>>>>>
>>>>>
>>>>>
>>>>> +----------------------+--------------+------+-----+---------+----------------+
>>>>> | Field                | Type         | Null | Key | Default | Extra
>>>>>        |
>>>>>
>>>>> +----------------------+--------------+------+-----+---------+----------------+
>>>>> | id                   | bigint(20)   | NO   | PRI | NULL    |
>>>>> auto_increment |
>>>>> | deleted              | bit(1)       | NO   |     | NULL    |
>>>>>        |
>>>>> | inserted             | datetime     | YES  |     | NULL    |
>>>>>        |
>>>>> | updated              | datetime     | YES  |     | NULL    |
>>>>>        |
>>>>> | allow_recording      | bit(1)       | NO   |     | NULL    |
>>>>>        |
>>>>> | allow_user_questions | bit(1)       | NO   |     | NULL    |
>>>>>        |
>>>>> | appointment          | bit(1)       | NO   |     | NULL    |
>>>>>        |
>>>>> | audio_only           | bit(1)       | NO   |     | NULL    |
>>>>>        |
>>>>> | capacity             | bigint(20)   | YES  |     | NULL    |
>>>>>        |
>>>>> | chat_moderated       | bit(1)       | NO   |     | NULL    |
>>>>>        |
>>>>> | chat_opened          | bit(1)       | NO   |     | NULL    |
>>>>>        |
>>>>> | closed               | bit(1)       | NO   |     | NULL    |
>>>>>        |
>>>>> | comment              | text         | YES  |     | NULL    |
>>>>>        |
>>>>> | confno               | varchar(255) | YES  |     | NULL    |
>>>>>        |
>>>>> | demo_room            | bit(1)       | NO   |     | NULL    |
>>>>>        |
>>>>> | demo_time            | int(11)      | YES  |     | NULL    |
>>>>>        |
>>>>> | external_id          | varchar(255) | YES  |     | NULL    |
>>>>>        |
>>>>> | files_opened         | bit(1)       | NO   |     | NULL    |
>>>>>        |
>>>>> | ispublic             | bit(1)       | NO   |     | NULL    |
>>>>>        |
>>>>> | moderated            | bit(1)       | NO   |     | NULL    |
>>>>>        |
>>>>> | name                 | varchar(255) | YES  | MUL | NULL    |
>>>>>        |
>>>>> | owner_id             | bigint(20)   | YES  |     | NULL    |
>>>>>        |
>>>>> | pin                  | varchar(255) | YES  |     | NULL    |
>>>>>        |
>>>>> | redirect_url         | varchar(255) | YES  |     | NULL    |
>>>>>        |
>>>>> | sip_enabled          | bit(1)       | NO   |     | NULL    |
>>>>>        |
>>>>> | tag                  | varchar(10)  | YES  |     | NULL    |
>>>>>        |
>>>>> | type                 | varchar(20)  | YES  |     | NULL    |
>>>>>        |
>>>>> | wait_moderator       | bit(1)       | NO   |     | NULL    |
>>>>>        |
>>>>> | wait_for_recording   | bit(1)       | NO   |     | NULL    |
>>>>>        |
>>>>>
>>>>> +----------------------+--------------+------+-----+---------+----------------+
>>>>>
>>>>> mysql> select id, name, pin from room  where name = "YAHs Global
>>>>> Kingdom Classroom" \g
>>>>> +----+-------------------------------+------+
>>>>> | id | name                          | pin  |
>>>>> +----+-------------------------------+------+
>>>>> | 11 | YAHs Global Kingdom Classroom | 9999 |
>>>>> +----+-------------------------------+------+
>>>>> 1 row in set (0.00 sec)
>>>>>
>>>>> mysql>
>>>>>
>>>>> from manger.conf
>>>>> [open504]
>>>>> secret = 12345
>>>>> deny=0.0.0.0/0.0.0.0
>>>>> permit=127.0.0.1/255.255.255.0
>>>>> read = all
>>>>> write = all
>>>>>
>>>>> "openmeetings.settings"
>>>>> sip.hostname=meetings.glorytoyah.org
>>>>> sip.manager.port=5038
>>>>> sip.manager.user=open504
>>>>> sip.manager.password=12345 - Assuming this is the value from
>>>>> manger.conf [open504]
>>>>> sip.manager.timeout=10000
>>>>>
>>>>> sip.ws.local.port.min=6666
>>>>> sip.ws.local.port.max=7666
>>>>> ## 127.0.0.1 is NOT working here
>>>>> sip.ws.local.host=public IP
>>>>> sip.ws.remote.port=8088
>>>>> sip.ws.remote.user=omsip_user
>>>>> sip.ws.remote.password=12345
>>>>>
>>>>>
>>>>>
>>>>> On Mon, Aug 23, 2021 at 7:57 PM Maxim Solodovnik <so...@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> Not sure I got the question :(
>>>>>>
>>>>>> You can specify these settings by editing
>>>>>> https://github.com/apache/openmeetings/blob/master/openmeetings-web/src/main/webapp/WEB-INF/classes/openmeetings.properties#L68
>>>>>> file
>>>>>> (located at
>>>>>> ${OM_HOME}/webapps/openmeetings/WEB-INF/classes/openmeetings.properties)
>>>>>>
>>>>>> On Asterisk side it is located here:
>>>>>> https://openmeetings.apache.org/AsteriskIntegration.html#configure-asterisk-manager
>>>>>>
>>>>>>
>>>>>> On Tue, 24 Aug 2021 at 05:27, Yah's Global Kingdom <ya...@gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>> @Maxium
>>>>>>> Asterisk:
>>>>>>> Where are these settings located?
>>>>>>>
>>>>>>> sip.manager.user=
>>>>>>> sip.manager.password=
>>>>>>> sip.manager.timeout=
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Best regards,
>>>>>> Maxim
>>>>>>
>>>>>
>>>>
>>>> --
>>>> Best regards,
>>>> Maxim
>>>>
>>>
>>
>> --
>> Best regards,
>> Maxim
>>
>

-- 
Best regards,
Maxim

Re: Settngs for Sip Manager

Posted by Yah's Global Kingdom <ya...@gmail.com>.
Thanks for your responses Maxim,
I understand now and I have corrected:
/etc/asterisk/manager.conf
/etc/asterisk/extension.conf

I manually added the extension to the Asterisk internal key-value DB

meetings*CLI> database show
/SIP/Registry/horace                              :
98.174.244.227:49952:60:horace:sip:horace@98.174.244.227:49952;transport=UDP;rinstance=0165778b0d1a09b9
/SIP/Registry/horacecell                          :
172.58.69.178:45874:60:horacecell:sip:horacecell@172.58.69.178:45874;transport=UDP;rinstance=42c80f10d1bbc35f
/dundi/secret                                     :
HxawUR7CiWPsyMBN73Q2bQ==;HUnEDvN5+h2GVC1pW4GEYw==
/dundi/secretexpiry                               : 1630104193
/openmeetings/rooms                               : 40011
/pbx/UUID                                         :
7dd6882b-8da9-4099-a6a7-3012970c94ca
6 results found.

I still get invalid extension when I try to dial into the conference.
Also when I create a room and SIP enable it, should openmeetings be
updating the asterisk internal key-value DB?
I think that it should be, so perhaps there is something still wrong
between my /etc/asterisk/manager.conf and the
/opt/om/webapps/openmeetings/WEB-INF/classes/openmeetings.properties
settings.

Thanks for all your help in getting me this far.


On Thu, Aug 26, 2021 at 7:05 AM Maxim Solodovnik <so...@gmail.com>
wrote:

>
>
> On Thu, 26 Aug 2021 at 21:03, Yah's Global Kingdom <ya...@gmail.com>
> wrote:
>
>> Maxim, even if my openmeetings database is open504, this needs to be set
>> to openmeetings?
>>
>
> Yes
> This is NOT MySQL OM DB
> This is Asterisk internal key-value DB :)
>
>
>>
>> On Tue, Aug 24, 2021 at 11:09 PM Maxim Solodovnik <so...@gmail.com>
>> wrote:
>>
>>>
>>>
>>> On Wed, 25 Aug 2021 at 09:38, Yah's Global Kingdom <ya...@gmail.com>
>>> wrote:
>>>
>>>> Hi Maxim,
>>>>
>>>> Thanks for responding:
>>>> What I am getting is invalid extension,  when I run asterisk -rx
>>>> database show, I don't see anything from openmeetings
>>>>
>>>> meetings*CLI> database show
>>>> /SIP/Registry/horace                              : 1.1.1.1:49952
>>>> :60:horace:sip:horace@1.1.1.1.1
>>>> :49952;transport=UDP;rinstance=fd20fb9e9a736274
>>>> /SIP/Registry/horacecell                          : 172.58.69.178:45874
>>>> :60:horacecell:sip:horacecell@172.58.69.178:45874
>>>> ;transport=UDP;rinstance=d0bae988fae57944
>>>> /dundi/secret                                     :
>>>> Bk1zG+mtsgGrpKsMJw09EA==;wS1dMgw+F1jfle4crmWRAA==
>>>> /dundi/secretexpiry                               : 1629852193
>>>>
>>>> /pbx/UUID                                         :
>>>> 7dd6882b-8da9-4099-a6a7-3012970c94ca
>>>> 5 results found.
>>>>
>>>> I am confused by these two lines in the Extensions.conf:
>>>> exten =>
>>>> _400X!,1,GotoIf($[${DB_EXISTS(open504/rooms/${EXTEN})}]?ok:notavail)
>>>> exten => _400X!,n(ok),SET(PIN=${DB(open504/rooms/${EXTEN})})
>>>>
>>>
>>> Well
>>> I'm not sure why do you have such portion of config :(
>>>
>>> "reference" config looks like
>>> https://openmeetings.apache.org/AsteriskIntegration.html#configure-extensions
>>>
>>> `openmeetings/rooms/....` is NOT DB table but some internal Asterisk
>>> key-value DB
>>> so `open504/rooms` looks wrong here
>>> It should be `openmeetings/rooms`
>>>
>>>
>>>
>>>>
>>>> 1.  in the database open504 I don't find a table named rooms, the table
>>>> name in the database is room.
>>>> 2.   I don't know why it is not registering the open504 database with
>>>> Asterisk,  I am thinking the transport Agent is suppose to do that somehow,
>>>> (just me thinking)
>>>>
>>>> meetings*CLI>
>>>> Tables_in_open504      |
>>>> +------------------------+
>>>> | address                |
>>>> | appointment            |
>>>> | chat                   |
>>>> | conference_log         |
>>>> | configuration          |
>>>> | email_queue            |
>>>> | extra_menu             |
>>>> | file_log               |
>>>> | group_user             |
>>>> | invitation             |
>>>> | ldapconfig             |
>>>> | meeting_member         |
>>>> | menu_group             |
>>>> | oauth_mapping          |
>>>> | oauth_server           |
>>>> | om_calendar            |
>>>> | om_file                |
>>>> | om_group               |
>>>> | om_user                |
>>>> | om_user_right          |
>>>> | private_message        |
>>>> | private_message_folder |
>>>> | recording_chunk        |
>>>> | room                   |
>>>> | room_file              |
>>>> | room_group             |
>>>> | room_hide_element      |
>>>> | room_moderator         |
>>>> | room_poll              |
>>>> | room_poll_answer       |
>>>> | sessiondata            |
>>>> | sipusers               |
>>>> | soaplogin              |
>>>> | user_contact           |
>>>> +------------------------+
>>>> 34 rows in set (0.00 sec)
>>>>
>>>>
>>>>
>>>> +----------------------+--------------+------+-----+---------+----------------+
>>>> | Field                | Type         | Null | Key | Default | Extra
>>>>        |
>>>>
>>>> +----------------------+--------------+------+-----+---------+----------------+
>>>> | id                   | bigint(20)   | NO   | PRI | NULL    |
>>>> auto_increment |
>>>> | deleted              | bit(1)       | NO   |     | NULL    |
>>>>        |
>>>> | inserted             | datetime     | YES  |     | NULL    |
>>>>        |
>>>> | updated              | datetime     | YES  |     | NULL    |
>>>>        |
>>>> | allow_recording      | bit(1)       | NO   |     | NULL    |
>>>>        |
>>>> | allow_user_questions | bit(1)       | NO   |     | NULL    |
>>>>        |
>>>> | appointment          | bit(1)       | NO   |     | NULL    |
>>>>        |
>>>> | audio_only           | bit(1)       | NO   |     | NULL    |
>>>>        |
>>>> | capacity             | bigint(20)   | YES  |     | NULL    |
>>>>        |
>>>> | chat_moderated       | bit(1)       | NO   |     | NULL    |
>>>>        |
>>>> | chat_opened          | bit(1)       | NO   |     | NULL    |
>>>>        |
>>>> | closed               | bit(1)       | NO   |     | NULL    |
>>>>        |
>>>> | comment              | text         | YES  |     | NULL    |
>>>>        |
>>>> | confno               | varchar(255) | YES  |     | NULL    |
>>>>        |
>>>> | demo_room            | bit(1)       | NO   |     | NULL    |
>>>>        |
>>>> | demo_time            | int(11)      | YES  |     | NULL    |
>>>>        |
>>>> | external_id          | varchar(255) | YES  |     | NULL    |
>>>>        |
>>>> | files_opened         | bit(1)       | NO   |     | NULL    |
>>>>        |
>>>> | ispublic             | bit(1)       | NO   |     | NULL    |
>>>>        |
>>>> | moderated            | bit(1)       | NO   |     | NULL    |
>>>>        |
>>>> | name                 | varchar(255) | YES  | MUL | NULL    |
>>>>        |
>>>> | owner_id             | bigint(20)   | YES  |     | NULL    |
>>>>        |
>>>> | pin                  | varchar(255) | YES  |     | NULL    |
>>>>        |
>>>> | redirect_url         | varchar(255) | YES  |     | NULL    |
>>>>        |
>>>> | sip_enabled          | bit(1)       | NO   |     | NULL    |
>>>>        |
>>>> | tag                  | varchar(10)  | YES  |     | NULL    |
>>>>        |
>>>> | type                 | varchar(20)  | YES  |     | NULL    |
>>>>        |
>>>> | wait_moderator       | bit(1)       | NO   |     | NULL    |
>>>>        |
>>>> | wait_for_recording   | bit(1)       | NO   |     | NULL    |
>>>>        |
>>>>
>>>> +----------------------+--------------+------+-----+---------+----------------+
>>>>
>>>> mysql> select id, name, pin from room  where name = "YAHs Global
>>>> Kingdom Classroom" \g
>>>> +----+-------------------------------+------+
>>>> | id | name                          | pin  |
>>>> +----+-------------------------------+------+
>>>> | 11 | YAHs Global Kingdom Classroom | 9999 |
>>>> +----+-------------------------------+------+
>>>> 1 row in set (0.00 sec)
>>>>
>>>> mysql>
>>>>
>>>> from manger.conf
>>>> [open504]
>>>> secret = 12345
>>>> deny=0.0.0.0/0.0.0.0
>>>> permit=127.0.0.1/255.255.255.0
>>>> read = all
>>>> write = all
>>>>
>>>> "openmeetings.settings"
>>>> sip.hostname=meetings.glorytoyah.org
>>>> sip.manager.port=5038
>>>> sip.manager.user=open504
>>>> sip.manager.password=12345 - Assuming this is the value from
>>>> manger.conf [open504]
>>>> sip.manager.timeout=10000
>>>>
>>>> sip.ws.local.port.min=6666
>>>> sip.ws.local.port.max=7666
>>>> ## 127.0.0.1 is NOT working here
>>>> sip.ws.local.host=public IP
>>>> sip.ws.remote.port=8088
>>>> sip.ws.remote.user=omsip_user
>>>> sip.ws.remote.password=12345
>>>>
>>>>
>>>>
>>>> On Mon, Aug 23, 2021 at 7:57 PM Maxim Solodovnik <so...@gmail.com>
>>>> wrote:
>>>>
>>>>> Not sure I got the question :(
>>>>>
>>>>> You can specify these settings by editing
>>>>> https://github.com/apache/openmeetings/blob/master/openmeetings-web/src/main/webapp/WEB-INF/classes/openmeetings.properties#L68
>>>>> file
>>>>> (located at
>>>>> ${OM_HOME}/webapps/openmeetings/WEB-INF/classes/openmeetings.properties)
>>>>>
>>>>> On Asterisk side it is located here:
>>>>> https://openmeetings.apache.org/AsteriskIntegration.html#configure-asterisk-manager
>>>>>
>>>>>
>>>>> On Tue, 24 Aug 2021 at 05:27, Yah's Global Kingdom <ya...@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> @Maxium
>>>>>> Asterisk:
>>>>>> Where are these settings located?
>>>>>>
>>>>>> sip.manager.user=
>>>>>> sip.manager.password=
>>>>>> sip.manager.timeout=
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Best regards,
>>>>> Maxim
>>>>>
>>>>
>>>
>>> --
>>> Best regards,
>>> Maxim
>>>
>>
>
> --
> Best regards,
> Maxim
>

Re: Settngs for Sip Manager

Posted by Maxim Solodovnik <so...@gmail.com>.
On Thu, 26 Aug 2021 at 21:03, Yah's Global Kingdom <ya...@gmail.com>
wrote:

> Maxim, even if my openmeetings database is open504, this needs to be set
> to openmeetings?
>

Yes
This is NOT MySQL OM DB
This is Asterisk internal key-value DB :)


>
> On Tue, Aug 24, 2021 at 11:09 PM Maxim Solodovnik <so...@gmail.com>
> wrote:
>
>>
>>
>> On Wed, 25 Aug 2021 at 09:38, Yah's Global Kingdom <ya...@gmail.com>
>> wrote:
>>
>>> Hi Maxim,
>>>
>>> Thanks for responding:
>>> What I am getting is invalid extension,  when I run asterisk -rx
>>> database show, I don't see anything from openmeetings
>>>
>>> meetings*CLI> database show
>>> /SIP/Registry/horace                              : 1.1.1.1:49952
>>> :60:horace:sip:horace@1.1.1.1.1
>>> :49952;transport=UDP;rinstance=fd20fb9e9a736274
>>> /SIP/Registry/horacecell                          : 172.58.69.178:45874
>>> :60:horacecell:sip:horacecell@172.58.69.178:45874
>>> ;transport=UDP;rinstance=d0bae988fae57944
>>> /dundi/secret                                     :
>>> Bk1zG+mtsgGrpKsMJw09EA==;wS1dMgw+F1jfle4crmWRAA==
>>> /dundi/secretexpiry                               : 1629852193
>>>
>>> /pbx/UUID                                         :
>>> 7dd6882b-8da9-4099-a6a7-3012970c94ca
>>> 5 results found.
>>>
>>> I am confused by these two lines in the Extensions.conf:
>>> exten =>
>>> _400X!,1,GotoIf($[${DB_EXISTS(open504/rooms/${EXTEN})}]?ok:notavail)
>>> exten => _400X!,n(ok),SET(PIN=${DB(open504/rooms/${EXTEN})})
>>>
>>
>> Well
>> I'm not sure why do you have such portion of config :(
>>
>> "reference" config looks like
>> https://openmeetings.apache.org/AsteriskIntegration.html#configure-extensions
>>
>> `openmeetings/rooms/....` is NOT DB table but some internal Asterisk
>> key-value DB
>> so `open504/rooms` looks wrong here
>> It should be `openmeetings/rooms`
>>
>>
>>
>>>
>>> 1.  in the database open504 I don't find a table named rooms, the table
>>> name in the database is room.
>>> 2.   I don't know why it is not registering the open504 database with
>>> Asterisk,  I am thinking the transport Agent is suppose to do that somehow,
>>> (just me thinking)
>>>
>>> meetings*CLI>
>>> Tables_in_open504      |
>>> +------------------------+
>>> | address                |
>>> | appointment            |
>>> | chat                   |
>>> | conference_log         |
>>> | configuration          |
>>> | email_queue            |
>>> | extra_menu             |
>>> | file_log               |
>>> | group_user             |
>>> | invitation             |
>>> | ldapconfig             |
>>> | meeting_member         |
>>> | menu_group             |
>>> | oauth_mapping          |
>>> | oauth_server           |
>>> | om_calendar            |
>>> | om_file                |
>>> | om_group               |
>>> | om_user                |
>>> | om_user_right          |
>>> | private_message        |
>>> | private_message_folder |
>>> | recording_chunk        |
>>> | room                   |
>>> | room_file              |
>>> | room_group             |
>>> | room_hide_element      |
>>> | room_moderator         |
>>> | room_poll              |
>>> | room_poll_answer       |
>>> | sessiondata            |
>>> | sipusers               |
>>> | soaplogin              |
>>> | user_contact           |
>>> +------------------------+
>>> 34 rows in set (0.00 sec)
>>>
>>>
>>>
>>> +----------------------+--------------+------+-----+---------+----------------+
>>> | Field                | Type         | Null | Key | Default | Extra
>>>      |
>>>
>>> +----------------------+--------------+------+-----+---------+----------------+
>>> | id                   | bigint(20)   | NO   | PRI | NULL    |
>>> auto_increment |
>>> | deleted              | bit(1)       | NO   |     | NULL    |
>>>      |
>>> | inserted             | datetime     | YES  |     | NULL    |
>>>      |
>>> | updated              | datetime     | YES  |     | NULL    |
>>>      |
>>> | allow_recording      | bit(1)       | NO   |     | NULL    |
>>>      |
>>> | allow_user_questions | bit(1)       | NO   |     | NULL    |
>>>      |
>>> | appointment          | bit(1)       | NO   |     | NULL    |
>>>      |
>>> | audio_only           | bit(1)       | NO   |     | NULL    |
>>>      |
>>> | capacity             | bigint(20)   | YES  |     | NULL    |
>>>      |
>>> | chat_moderated       | bit(1)       | NO   |     | NULL    |
>>>      |
>>> | chat_opened          | bit(1)       | NO   |     | NULL    |
>>>      |
>>> | closed               | bit(1)       | NO   |     | NULL    |
>>>      |
>>> | comment              | text         | YES  |     | NULL    |
>>>      |
>>> | confno               | varchar(255) | YES  |     | NULL    |
>>>      |
>>> | demo_room            | bit(1)       | NO   |     | NULL    |
>>>      |
>>> | demo_time            | int(11)      | YES  |     | NULL    |
>>>      |
>>> | external_id          | varchar(255) | YES  |     | NULL    |
>>>      |
>>> | files_opened         | bit(1)       | NO   |     | NULL    |
>>>      |
>>> | ispublic             | bit(1)       | NO   |     | NULL    |
>>>      |
>>> | moderated            | bit(1)       | NO   |     | NULL    |
>>>      |
>>> | name                 | varchar(255) | YES  | MUL | NULL    |
>>>      |
>>> | owner_id             | bigint(20)   | YES  |     | NULL    |
>>>      |
>>> | pin                  | varchar(255) | YES  |     | NULL    |
>>>      |
>>> | redirect_url         | varchar(255) | YES  |     | NULL    |
>>>      |
>>> | sip_enabled          | bit(1)       | NO   |     | NULL    |
>>>      |
>>> | tag                  | varchar(10)  | YES  |     | NULL    |
>>>      |
>>> | type                 | varchar(20)  | YES  |     | NULL    |
>>>      |
>>> | wait_moderator       | bit(1)       | NO   |     | NULL    |
>>>      |
>>> | wait_for_recording   | bit(1)       | NO   |     | NULL    |
>>>      |
>>>
>>> +----------------------+--------------+------+-----+---------+----------------+
>>>
>>> mysql> select id, name, pin from room  where name = "YAHs Global Kingdom
>>> Classroom" \g
>>> +----+-------------------------------+------+
>>> | id | name                          | pin  |
>>> +----+-------------------------------+------+
>>> | 11 | YAHs Global Kingdom Classroom | 9999 |
>>> +----+-------------------------------+------+
>>> 1 row in set (0.00 sec)
>>>
>>> mysql>
>>>
>>> from manger.conf
>>> [open504]
>>> secret = 12345
>>> deny=0.0.0.0/0.0.0.0
>>> permit=127.0.0.1/255.255.255.0
>>> read = all
>>> write = all
>>>
>>> "openmeetings.settings"
>>> sip.hostname=meetings.glorytoyah.org
>>> sip.manager.port=5038
>>> sip.manager.user=open504
>>> sip.manager.password=12345 - Assuming this is the value from manger.conf
>>> [open504]
>>> sip.manager.timeout=10000
>>>
>>> sip.ws.local.port.min=6666
>>> sip.ws.local.port.max=7666
>>> ## 127.0.0.1 is NOT working here
>>> sip.ws.local.host=public IP
>>> sip.ws.remote.port=8088
>>> sip.ws.remote.user=omsip_user
>>> sip.ws.remote.password=12345
>>>
>>>
>>>
>>> On Mon, Aug 23, 2021 at 7:57 PM Maxim Solodovnik <so...@gmail.com>
>>> wrote:
>>>
>>>> Not sure I got the question :(
>>>>
>>>> You can specify these settings by editing
>>>> https://github.com/apache/openmeetings/blob/master/openmeetings-web/src/main/webapp/WEB-INF/classes/openmeetings.properties#L68
>>>> file
>>>> (located at
>>>> ${OM_HOME}/webapps/openmeetings/WEB-INF/classes/openmeetings.properties)
>>>>
>>>> On Asterisk side it is located here:
>>>> https://openmeetings.apache.org/AsteriskIntegration.html#configure-asterisk-manager
>>>>
>>>>
>>>> On Tue, 24 Aug 2021 at 05:27, Yah's Global Kingdom <ya...@gmail.com>
>>>> wrote:
>>>>
>>>>> @Maxium
>>>>> Asterisk:
>>>>> Where are these settings located?
>>>>>
>>>>> sip.manager.user=
>>>>> sip.manager.password=
>>>>> sip.manager.timeout=
>>>>>
>>>>
>>>>
>>>> --
>>>> Best regards,
>>>> Maxim
>>>>
>>>
>>
>> --
>> Best regards,
>> Maxim
>>
>

-- 
Best regards,
Maxim

Re: Settngs for Sip Manager

Posted by Yah's Global Kingdom <ya...@gmail.com>.
Maxim, even if my openmeetings database is open504, this needs to be set to
openmeetings?

On Tue, Aug 24, 2021 at 11:09 PM Maxim Solodovnik <so...@gmail.com>
wrote:

>
>
> On Wed, 25 Aug 2021 at 09:38, Yah's Global Kingdom <ya...@gmail.com>
> wrote:
>
>> Hi Maxim,
>>
>> Thanks for responding:
>> What I am getting is invalid extension,  when I run asterisk -rx database
>> show, I don't see anything from openmeetings
>>
>> meetings*CLI> database show
>> /SIP/Registry/horace                              : 1.1.1.1:49952
>> :60:horace:sip:horace@1.1.1.1.1
>> :49952;transport=UDP;rinstance=fd20fb9e9a736274
>> /SIP/Registry/horacecell                          : 172.58.69.178:45874
>> :60:horacecell:sip:horacecell@172.58.69.178:45874
>> ;transport=UDP;rinstance=d0bae988fae57944
>> /dundi/secret                                     :
>> Bk1zG+mtsgGrpKsMJw09EA==;wS1dMgw+F1jfle4crmWRAA==
>> /dundi/secretexpiry                               : 1629852193
>>
>> /pbx/UUID                                         :
>> 7dd6882b-8da9-4099-a6a7-3012970c94ca
>> 5 results found.
>>
>> I am confused by these two lines in the Extensions.conf:
>> exten =>
>> _400X!,1,GotoIf($[${DB_EXISTS(open504/rooms/${EXTEN})}]?ok:notavail)
>> exten => _400X!,n(ok),SET(PIN=${DB(open504/rooms/${EXTEN})})
>>
>
> Well
> I'm not sure why do you have such portion of config :(
>
> "reference" config looks like
> https://openmeetings.apache.org/AsteriskIntegration.html#configure-extensions
>
> `openmeetings/rooms/....` is NOT DB table but some internal Asterisk
> key-value DB
> so `open504/rooms` looks wrong here
> It should be `openmeetings/rooms`
>
>
>
>>
>> 1.  in the database open504 I don't find a table named rooms, the table
>> name in the database is room.
>> 2.   I don't know why it is not registering the open504 database with
>> Asterisk,  I am thinking the transport Agent is suppose to do that somehow,
>> (just me thinking)
>>
>> meetings*CLI>
>> Tables_in_open504      |
>> +------------------------+
>> | address                |
>> | appointment            |
>> | chat                   |
>> | conference_log         |
>> | configuration          |
>> | email_queue            |
>> | extra_menu             |
>> | file_log               |
>> | group_user             |
>> | invitation             |
>> | ldapconfig             |
>> | meeting_member         |
>> | menu_group             |
>> | oauth_mapping          |
>> | oauth_server           |
>> | om_calendar            |
>> | om_file                |
>> | om_group               |
>> | om_user                |
>> | om_user_right          |
>> | private_message        |
>> | private_message_folder |
>> | recording_chunk        |
>> | room                   |
>> | room_file              |
>> | room_group             |
>> | room_hide_element      |
>> | room_moderator         |
>> | room_poll              |
>> | room_poll_answer       |
>> | sessiondata            |
>> | sipusers               |
>> | soaplogin              |
>> | user_contact           |
>> +------------------------+
>> 34 rows in set (0.00 sec)
>>
>>
>>
>> +----------------------+--------------+------+-----+---------+----------------+
>> | Field                | Type         | Null | Key | Default | Extra
>>      |
>>
>> +----------------------+--------------+------+-----+---------+----------------+
>> | id                   | bigint(20)   | NO   | PRI | NULL    |
>> auto_increment |
>> | deleted              | bit(1)       | NO   |     | NULL    |
>>      |
>> | inserted             | datetime     | YES  |     | NULL    |
>>      |
>> | updated              | datetime     | YES  |     | NULL    |
>>      |
>> | allow_recording      | bit(1)       | NO   |     | NULL    |
>>      |
>> | allow_user_questions | bit(1)       | NO   |     | NULL    |
>>      |
>> | appointment          | bit(1)       | NO   |     | NULL    |
>>      |
>> | audio_only           | bit(1)       | NO   |     | NULL    |
>>      |
>> | capacity             | bigint(20)   | YES  |     | NULL    |
>>      |
>> | chat_moderated       | bit(1)       | NO   |     | NULL    |
>>      |
>> | chat_opened          | bit(1)       | NO   |     | NULL    |
>>      |
>> | closed               | bit(1)       | NO   |     | NULL    |
>>      |
>> | comment              | text         | YES  |     | NULL    |
>>      |
>> | confno               | varchar(255) | YES  |     | NULL    |
>>      |
>> | demo_room            | bit(1)       | NO   |     | NULL    |
>>      |
>> | demo_time            | int(11)      | YES  |     | NULL    |
>>      |
>> | external_id          | varchar(255) | YES  |     | NULL    |
>>      |
>> | files_opened         | bit(1)       | NO   |     | NULL    |
>>      |
>> | ispublic             | bit(1)       | NO   |     | NULL    |
>>      |
>> | moderated            | bit(1)       | NO   |     | NULL    |
>>      |
>> | name                 | varchar(255) | YES  | MUL | NULL    |
>>      |
>> | owner_id             | bigint(20)   | YES  |     | NULL    |
>>      |
>> | pin                  | varchar(255) | YES  |     | NULL    |
>>      |
>> | redirect_url         | varchar(255) | YES  |     | NULL    |
>>      |
>> | sip_enabled          | bit(1)       | NO   |     | NULL    |
>>      |
>> | tag                  | varchar(10)  | YES  |     | NULL    |
>>      |
>> | type                 | varchar(20)  | YES  |     | NULL    |
>>      |
>> | wait_moderator       | bit(1)       | NO   |     | NULL    |
>>      |
>> | wait_for_recording   | bit(1)       | NO   |     | NULL    |
>>      |
>>
>> +----------------------+--------------+------+-----+---------+----------------+
>>
>> mysql> select id, name, pin from room  where name = "YAHs Global Kingdom
>> Classroom" \g
>> +----+-------------------------------+------+
>> | id | name                          | pin  |
>> +----+-------------------------------+------+
>> | 11 | YAHs Global Kingdom Classroom | 9999 |
>> +----+-------------------------------+------+
>> 1 row in set (0.00 sec)
>>
>> mysql>
>>
>> from manger.conf
>> [open504]
>> secret = 12345
>> deny=0.0.0.0/0.0.0.0
>> permit=127.0.0.1/255.255.255.0
>> read = all
>> write = all
>>
>> "openmeetings.settings"
>> sip.hostname=meetings.glorytoyah.org
>> sip.manager.port=5038
>> sip.manager.user=open504
>> sip.manager.password=12345 - Assuming this is the value from manger.conf
>> [open504]
>> sip.manager.timeout=10000
>>
>> sip.ws.local.port.min=6666
>> sip.ws.local.port.max=7666
>> ## 127.0.0.1 is NOT working here
>> sip.ws.local.host=public IP
>> sip.ws.remote.port=8088
>> sip.ws.remote.user=omsip_user
>> sip.ws.remote.password=12345
>>
>>
>>
>> On Mon, Aug 23, 2021 at 7:57 PM Maxim Solodovnik <so...@gmail.com>
>> wrote:
>>
>>> Not sure I got the question :(
>>>
>>> You can specify these settings by editing
>>> https://github.com/apache/openmeetings/blob/master/openmeetings-web/src/main/webapp/WEB-INF/classes/openmeetings.properties#L68
>>> file
>>> (located at
>>> ${OM_HOME}/webapps/openmeetings/WEB-INF/classes/openmeetings.properties)
>>>
>>> On Asterisk side it is located here:
>>> https://openmeetings.apache.org/AsteriskIntegration.html#configure-asterisk-manager
>>>
>>>
>>> On Tue, 24 Aug 2021 at 05:27, Yah's Global Kingdom <ya...@gmail.com>
>>> wrote:
>>>
>>>> @Maxium
>>>> Asterisk:
>>>> Where are these settings located?
>>>>
>>>> sip.manager.user=
>>>> sip.manager.password=
>>>> sip.manager.timeout=
>>>>
>>>
>>>
>>> --
>>> Best regards,
>>> Maxim
>>>
>>
>
> --
> Best regards,
> Maxim
>

Re: Settngs for Sip Manager

Posted by Maxim Solodovnik <so...@gmail.com>.
On Wed, 25 Aug 2021 at 09:38, Yah's Global Kingdom <ya...@gmail.com>
wrote:

> Hi Maxim,
>
> Thanks for responding:
> What I am getting is invalid extension,  when I run asterisk -rx database
> show, I don't see anything from openmeetings
>
> meetings*CLI> database show
> /SIP/Registry/horace                              : 1.1.1.1:49952
> :60:horace:sip:horace@1.1.1.1.1
> :49952;transport=UDP;rinstance=fd20fb9e9a736274
> /SIP/Registry/horacecell                          : 172.58.69.178:45874
> :60:horacecell:sip:horacecell@172.58.69.178:45874
> ;transport=UDP;rinstance=d0bae988fae57944
> /dundi/secret                                     :
> Bk1zG+mtsgGrpKsMJw09EA==;wS1dMgw+F1jfle4crmWRAA==
> /dundi/secretexpiry                               : 1629852193
>
> /pbx/UUID                                         :
> 7dd6882b-8da9-4099-a6a7-3012970c94ca
> 5 results found.
>
> I am confused by these two lines in the Extensions.conf:
> exten =>
> _400X!,1,GotoIf($[${DB_EXISTS(open504/rooms/${EXTEN})}]?ok:notavail)
> exten => _400X!,n(ok),SET(PIN=${DB(open504/rooms/${EXTEN})})
>

Well
I'm not sure why do you have such portion of config :(

"reference" config looks like
https://openmeetings.apache.org/AsteriskIntegration.html#configure-extensions

`openmeetings/rooms/....` is NOT DB table but some internal Asterisk
key-value DB
so `open504/rooms` looks wrong here
It should be `openmeetings/rooms`



>
> 1.  in the database open504 I don't find a table named rooms, the table
> name in the database is room.
> 2.   I don't know why it is not registering the open504 database with
> Asterisk,  I am thinking the transport Agent is suppose to do that somehow,
> (just me thinking)
>
> meetings*CLI>
> Tables_in_open504      |
> +------------------------+
> | address                |
> | appointment            |
> | chat                   |
> | conference_log         |
> | configuration          |
> | email_queue            |
> | extra_menu             |
> | file_log               |
> | group_user             |
> | invitation             |
> | ldapconfig             |
> | meeting_member         |
> | menu_group             |
> | oauth_mapping          |
> | oauth_server           |
> | om_calendar            |
> | om_file                |
> | om_group               |
> | om_user                |
> | om_user_right          |
> | private_message        |
> | private_message_folder |
> | recording_chunk        |
> | room                   |
> | room_file              |
> | room_group             |
> | room_hide_element      |
> | room_moderator         |
> | room_poll              |
> | room_poll_answer       |
> | sessiondata            |
> | sipusers               |
> | soaplogin              |
> | user_contact           |
> +------------------------+
> 34 rows in set (0.00 sec)
>
>
>
> +----------------------+--------------+------+-----+---------+----------------+
> | Field                | Type         | Null | Key | Default | Extra
>    |
>
> +----------------------+--------------+------+-----+---------+----------------+
> | id                   | bigint(20)   | NO   | PRI | NULL    |
> auto_increment |
> | deleted              | bit(1)       | NO   |     | NULL    |
>    |
> | inserted             | datetime     | YES  |     | NULL    |
>    |
> | updated              | datetime     | YES  |     | NULL    |
>    |
> | allow_recording      | bit(1)       | NO   |     | NULL    |
>    |
> | allow_user_questions | bit(1)       | NO   |     | NULL    |
>    |
> | appointment          | bit(1)       | NO   |     | NULL    |
>    |
> | audio_only           | bit(1)       | NO   |     | NULL    |
>    |
> | capacity             | bigint(20)   | YES  |     | NULL    |
>    |
> | chat_moderated       | bit(1)       | NO   |     | NULL    |
>    |
> | chat_opened          | bit(1)       | NO   |     | NULL    |
>    |
> | closed               | bit(1)       | NO   |     | NULL    |
>    |
> | comment              | text         | YES  |     | NULL    |
>    |
> | confno               | varchar(255) | YES  |     | NULL    |
>    |
> | demo_room            | bit(1)       | NO   |     | NULL    |
>    |
> | demo_time            | int(11)      | YES  |     | NULL    |
>    |
> | external_id          | varchar(255) | YES  |     | NULL    |
>    |
> | files_opened         | bit(1)       | NO   |     | NULL    |
>    |
> | ispublic             | bit(1)       | NO   |     | NULL    |
>    |
> | moderated            | bit(1)       | NO   |     | NULL    |
>    |
> | name                 | varchar(255) | YES  | MUL | NULL    |
>    |
> | owner_id             | bigint(20)   | YES  |     | NULL    |
>    |
> | pin                  | varchar(255) | YES  |     | NULL    |
>    |
> | redirect_url         | varchar(255) | YES  |     | NULL    |
>    |
> | sip_enabled          | bit(1)       | NO   |     | NULL    |
>    |
> | tag                  | varchar(10)  | YES  |     | NULL    |
>    |
> | type                 | varchar(20)  | YES  |     | NULL    |
>    |
> | wait_moderator       | bit(1)       | NO   |     | NULL    |
>    |
> | wait_for_recording   | bit(1)       | NO   |     | NULL    |
>    |
>
> +----------------------+--------------+------+-----+---------+----------------+
>
> mysql> select id, name, pin from room  where name = "YAHs Global Kingdom
> Classroom" \g
> +----+-------------------------------+------+
> | id | name                          | pin  |
> +----+-------------------------------+------+
> | 11 | YAHs Global Kingdom Classroom | 9999 |
> +----+-------------------------------+------+
> 1 row in set (0.00 sec)
>
> mysql>
>
> from manger.conf
> [open504]
> secret = 12345
> deny=0.0.0.0/0.0.0.0
> permit=127.0.0.1/255.255.255.0
> read = all
> write = all
>
> "openmeetings.settings"
> sip.hostname=meetings.glorytoyah.org
> sip.manager.port=5038
> sip.manager.user=open504
> sip.manager.password=12345 - Assuming this is the value from manger.conf
> [open504]
> sip.manager.timeout=10000
>
> sip.ws.local.port.min=6666
> sip.ws.local.port.max=7666
> ## 127.0.0.1 is NOT working here
> sip.ws.local.host=public IP
> sip.ws.remote.port=8088
> sip.ws.remote.user=omsip_user
> sip.ws.remote.password=12345
>
>
>
> On Mon, Aug 23, 2021 at 7:57 PM Maxim Solodovnik <so...@gmail.com>
> wrote:
>
>> Not sure I got the question :(
>>
>> You can specify these settings by editing
>> https://github.com/apache/openmeetings/blob/master/openmeetings-web/src/main/webapp/WEB-INF/classes/openmeetings.properties#L68
>> file
>> (located at
>> ${OM_HOME}/webapps/openmeetings/WEB-INF/classes/openmeetings.properties)
>>
>> On Asterisk side it is located here:
>> https://openmeetings.apache.org/AsteriskIntegration.html#configure-asterisk-manager
>>
>>
>> On Tue, 24 Aug 2021 at 05:27, Yah's Global Kingdom <ya...@gmail.com>
>> wrote:
>>
>>> @Maxium
>>> Asterisk:
>>> Where are these settings located?
>>>
>>> sip.manager.user=
>>> sip.manager.password=
>>> sip.manager.timeout=
>>>
>>
>>
>> --
>> Best regards,
>> Maxim
>>
>

-- 
Best regards,
Maxim

Re: Settngs for Sip Manager

Posted by Yah's Global Kingdom <ya...@gmail.com>.
Hi Maxim,

Thanks for responding:
What I am getting is invalid extension,  when I run asterisk -rx database
show, I don't see anything from openmeetings

meetings*CLI> database show
/SIP/Registry/horace                              : 1.1.1.1:49952
:60:horace:sip:horace@1.1.1.1.1
:49952;transport=UDP;rinstance=fd20fb9e9a736274
/SIP/Registry/horacecell                          : 172.58.69.178:45874
:60:horacecell:sip:horacecell@172.58.69.178:45874
;transport=UDP;rinstance=d0bae988fae57944
/dundi/secret                                     :
Bk1zG+mtsgGrpKsMJw09EA==;wS1dMgw+F1jfle4crmWRAA==
/dundi/secretexpiry                               : 1629852193

/pbx/UUID                                         :
7dd6882b-8da9-4099-a6a7-3012970c94ca
5 results found.

I am confused by these two lines in the Extensions.conf:
exten =>
_400X!,1,GotoIf($[${DB_EXISTS(open504/rooms/${EXTEN})}]?ok:notavail)
exten => _400X!,n(ok),SET(PIN=${DB(open504/rooms/${EXTEN})})

1.  in the database open504 I don't find a table named rooms, the table
name in the database is room.
2.   I don't know why it is not registering the open504 database with
Asterisk,  I am thinking the transport Agent is suppose to do that somehow,
(just me thinking)

meetings*CLI>
Tables_in_open504      |
+------------------------+
| address                |
| appointment            |
| chat                   |
| conference_log         |
| configuration          |
| email_queue            |
| extra_menu             |
| file_log               |
| group_user             |
| invitation             |
| ldapconfig             |
| meeting_member         |
| menu_group             |
| oauth_mapping          |
| oauth_server           |
| om_calendar            |
| om_file                |
| om_group               |
| om_user                |
| om_user_right          |
| private_message        |
| private_message_folder |
| recording_chunk        |
| room                   |
| room_file              |
| room_group             |
| room_hide_element      |
| room_moderator         |
| room_poll              |
| room_poll_answer       |
| sessiondata            |
| sipusers               |
| soaplogin              |
| user_contact           |
+------------------------+
34 rows in set (0.00 sec)


+----------------------+--------------+------+-----+---------+----------------+
| Field                | Type         | Null | Key | Default | Extra
   |
+----------------------+--------------+------+-----+---------+----------------+
| id                   | bigint(20)   | NO   | PRI | NULL    |
auto_increment |
| deleted              | bit(1)       | NO   |     | NULL    |
   |
| inserted             | datetime     | YES  |     | NULL    |
   |
| updated              | datetime     | YES  |     | NULL    |
   |
| allow_recording      | bit(1)       | NO   |     | NULL    |
   |
| allow_user_questions | bit(1)       | NO   |     | NULL    |
   |
| appointment          | bit(1)       | NO   |     | NULL    |
   |
| audio_only           | bit(1)       | NO   |     | NULL    |
   |
| capacity             | bigint(20)   | YES  |     | NULL    |
   |
| chat_moderated       | bit(1)       | NO   |     | NULL    |
   |
| chat_opened          | bit(1)       | NO   |     | NULL    |
   |
| closed               | bit(1)       | NO   |     | NULL    |
   |
| comment              | text         | YES  |     | NULL    |
   |
| confno               | varchar(255) | YES  |     | NULL    |
   |
| demo_room            | bit(1)       | NO   |     | NULL    |
   |
| demo_time            | int(11)      | YES  |     | NULL    |
   |
| external_id          | varchar(255) | YES  |     | NULL    |
   |
| files_opened         | bit(1)       | NO   |     | NULL    |
   |
| ispublic             | bit(1)       | NO   |     | NULL    |
   |
| moderated            | bit(1)       | NO   |     | NULL    |
   |
| name                 | varchar(255) | YES  | MUL | NULL    |
   |
| owner_id             | bigint(20)   | YES  |     | NULL    |
   |
| pin                  | varchar(255) | YES  |     | NULL    |
   |
| redirect_url         | varchar(255) | YES  |     | NULL    |
   |
| sip_enabled          | bit(1)       | NO   |     | NULL    |
   |
| tag                  | varchar(10)  | YES  |     | NULL    |
   |
| type                 | varchar(20)  | YES  |     | NULL    |
   |
| wait_moderator       | bit(1)       | NO   |     | NULL    |
   |
| wait_for_recording   | bit(1)       | NO   |     | NULL    |
   |
+----------------------+--------------+------+-----+---------+----------------+

mysql> select id, name, pin from room  where name = "YAHs Global Kingdom
Classroom" \g
+----+-------------------------------+------+
| id | name                          | pin  |
+----+-------------------------------+------+
| 11 | YAHs Global Kingdom Classroom | 9999 |
+----+-------------------------------+------+
1 row in set (0.00 sec)

mysql>

from manger.conf
[open504]
secret = 12345
deny=0.0.0.0/0.0.0.0
permit=127.0.0.1/255.255.255.0
read = all
write = all

"openmeetings.settings"
sip.hostname=meetings.glorytoyah.org
sip.manager.port=5038
sip.manager.user=open504
sip.manager.password=12345 - Assuming this is the value from manger.conf
[open504]
sip.manager.timeout=10000

sip.ws.local.port.min=6666
sip.ws.local.port.max=7666
## 127.0.0.1 is NOT working here
sip.ws.local.host=public IP
sip.ws.remote.port=8088
sip.ws.remote.user=omsip_user
sip.ws.remote.password=12345



On Mon, Aug 23, 2021 at 7:57 PM Maxim Solodovnik <so...@gmail.com>
wrote:

> Not sure I got the question :(
>
> You can specify these settings by editing
> https://github.com/apache/openmeetings/blob/master/openmeetings-web/src/main/webapp/WEB-INF/classes/openmeetings.properties#L68
> file
> (located at
> ${OM_HOME}/webapps/openmeetings/WEB-INF/classes/openmeetings.properties)
>
> On Asterisk side it is located here:
> https://openmeetings.apache.org/AsteriskIntegration.html#configure-asterisk-manager
>
>
> On Tue, 24 Aug 2021 at 05:27, Yah's Global Kingdom <ya...@gmail.com>
> wrote:
>
>> @Maxium
>> Asterisk:
>> Where are these settings located?
>>
>> sip.manager.user=
>> sip.manager.password=
>> sip.manager.timeout=
>>
>
>
> --
> Best regards,
> Maxim
>

Re: Settngs for Sip Manager

Posted by Maxim Solodovnik <so...@gmail.com>.
Not sure I got the question :(

You can specify these settings by editing
https://github.com/apache/openmeetings/blob/master/openmeetings-web/src/main/webapp/WEB-INF/classes/openmeetings.properties#L68
file
(located at
${OM_HOME}/webapps/openmeetings/WEB-INF/classes/openmeetings.properties)

On Asterisk side it is located here:
https://openmeetings.apache.org/AsteriskIntegration.html#configure-asterisk-manager


On Tue, 24 Aug 2021 at 05:27, Yah's Global Kingdom <ya...@gmail.com>
wrote:

> @Maxium
> Asterisk:
> Where are these settings located?
>
> sip.manager.user=
> sip.manager.password=
> sip.manager.timeout=
>


-- 
Best regards,
Maxim