On Sat, 28 Aug 2021 at 05:30, Yah's Global Kingdom <yahs...@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 <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 >> > -- Best regards, Maxim
