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