On Thu, 26 Aug 2021 at 21:03, Yah's Global Kingdom <[email protected]> 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 <[email protected]> > wrote: > >> >> >> On Wed, 25 Aug 2021 at 09:38, Yah's Global Kingdom <[email protected]> >> 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:[email protected] >>> :49952;transport=UDP;rinstance=fd20fb9e9a736274 >>> /SIP/Registry/horacecell : 172.58.69.178:45874 >>> :60:horacecell:sip:[email protected]: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 <[email protected]> >>> 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 <[email protected]> >>>> 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
