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
