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 <solomax...@gmail.com>
wrote:
>
>
> On Thu, 26 Aug 2021 at 21:03, Yah's Global Kingdom <yahs...@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 <solomax...@gmail.com>
>> wrote:
>>
>>>
>>>
>>> On Wed, 25 Aug 2021 at 09:38, Yah's Global Kingdom <yahs...@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 <solomax...@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 <yahs...@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
>
