@Timur, could you please answer this question @Horace, please send your questions to user/dev lists
---------- Forwarded message ---------- From: Horace Miles <[email protected]> Date: 14 August 2014 20:45 Subject: RE: Pointer on WB To: Maxim Solodovnik <[email protected]> I see that the VOIP integration will allow multiple people to dial into a conference room. Is there a way to automatically assign the ext for incoming calls based upon the conference ID? *From:* Maxim Solodovnik [mailto:[email protected]] *Sent:* Tuesday, August 12, 2014 7:52 AM *To:* Horace Miles *Subject:* Re: Pointer on WB this keys are created via JAVA code of OM in case this part of config is made properly: Update Openmeetings with creadentials for Asterisk manager. Modify /opt/red5/webapps/openmeetings/WEB-INF/classes/openmeetings-applicationContext.xml find *<bean id="sipDao" class="org.apache.openmeetings.db.dao.room.SipDao">* uncomment its parameters and set it to your custom values. IMPORTANT: this step should be done *BEFORE* system install/restore otherwise all SIP related room information will be lost On 12 August 2014 20:43, Horace Miles <[email protected]> wrote: Good morning/afternoon or evening Maxim, There was no databse entry in the astdb table for openmeetings/rooms So I did the following Database put openmeetings rooms 40000 as test and now it shows asterisk –rx “database show” Has an entry openmeetings/rooms 40000. The sip transport now stays in the room YEAH….. Since this was a fresh install of Asterisk per the Integration instructions should there be an instruction to add the family openmeetings key rooms to the astDB or did I miss this somewhere? Since I only used the red5sip-integration_3.0 guide. Is there anything else that I as a novice would need to know or install to make an outgoing call? Thanks for all your help *From:* Maxim Solodovnik [mailto:[email protected]] *Sent:* Monday, August 11, 2014 11:08 AM *To:* Horace Miles *Cc:* Openmeetings user-list; Тимур Тлеукенов *Subject:* Re: Pointer on WB please provide documentation change, I'll merge it :) On 12 August 2014 00:46, Horace Miles <[email protected]> wrote: My apologies to Turmik. I had a completely different understanding of how this was working. Thanks for your reply and info. I had read this information as well in the extension programming documentation for Asterisk, but thought Openmeetings was trying to use it in a different manner. The documentation should include some information on this to pre-clude future novice users as myself from making this same mistake. Miles *From:* Maxim Solodovnik [mailto:[email protected]] *Sent:* Monday, August 11, 2014 8:20 AM *To:* Horace Miles *Cc:* Openmeetings user-list; Тимур Тлеукенов *Subject:* Re: Pointer on WB It is by desing, OM DB has table "room" Asterisk key has name "/openmeetings/rooms" it doesn't need to match On 11 August 2014 21:46, Horace Miles <[email protected]> wrote: Thanks Maxim, Why would my openmeetings database not have a rooms table but have one name room? *From:* Maxim Solodovnik [mailto:[email protected]] *Sent:* Monday, August 11, 2014 7:50 AM *To:* Horace Miles *Cc:* Openmeetings user-list; Тимур Тлеукенов *Subject:* Re: Pointer on WB sudo asterisk -rx "database show" /openmeetings/rooms/4002 : /openmeetings/rooms/40096 : so in my case local asterisk key/value DB is quered On 11 August 2014 20:19, Horace Miles <[email protected]> wrote: Thanks Timur, That is what the Asterisk documentations says that dbexist does. However, as I am reading the code it is being used to query the openmeetings database and not the AstDB. The code below is from the Openmeetings SOAP and VOIP Integration wiki. exten => _400X!,1,GotoIf($[${DB_EXISTS(openmeetings/rooms/${EXTEN})}]?ok:notavail) so according to your explaination openmeetings/rooms is being used to stored blacklisted numbers? Because if that is the case the bridge will never be reached because in my database the following is true: table Rooms does not exist table room does exist table room holds all of the room information for all rooms created with the extension for that room If this is being used for the blacklist then the following line will never be reached because the extensions are in this table exten => _400X!,n(ok),Confbridge(${EXTEN},default_bridge,red5sip_user) - this line will never be reached if that is the way the GotoIF line is being used. When I see the code above it is saying if the extension exist in the room table then connect to the bridge if it does not then hangup. The problem is openmeetings/rooms table does not exist but table/room does exist and as far as I can tell there is no way for the query to look at the field with the extension in it, it is simply going to rooms or room table and not looking at a particular field. In this case not finding a field it returns a 0 does not exist and goes to the hangup line. I can reverse the logic and say if 0 is returned then run the confbridge line but I don’t think it is designed to work that way. So is there suppose to be a table with the name ‘rooms’? If so where can I find the layout or schema for it? What routines in Openmeetings will update the table. Because either something is missing OR there is a typo in the documentation AND/OR there is a typo and missing code in the DBEXIST line what would tell DBEXIST what field to check for the confo number? Miles *From:* Тимур Тлеукенов [mailto:[email protected]] *Sent:* Sunday, August 10, 2014 11:02 PM *To:* Maxim Solodovnik *Cc:* Openmeetings user-list *Subject:* Re: Pointer on WB Hello, This extension code doesn't access openmeetings database, it uses internal asterisk database AstDB. It is key/value database. If record "open30/room/${EXTEN})}" (where ${EXTEN} is name of calling extension) exists in asterisk database, then extension will be blocked. Related asterisk database documentation: http://www.voip-info.org/wiki/view/Asterisk+func+db http://www.voip-info.org/wiki/view/Asterisk+func+db_exists -- WBR Maxim aka solomax -- WBR Maxim aka solomax -- WBR Maxim aka solomax -- WBR Maxim aka solomax -- WBR Maxim aka solomax
