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 <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
>
