please provide documentation change, I'll merge it :)
On 12 August 2014 00:46, Horace Miles <horace.mi...@myit-solutions.com> 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:solomax...@gmail.com] > *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 <horace.mi...@myit-solutions.com> > wrote: > > Thanks Maxim, > > > > Why would my openmeetings database not have a rooms table but have one > name room? > > > > *From:* Maxim Solodovnik [mailto:solomax...@gmail.com] > *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 <horace.mi...@myit-solutions.com> > 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:timur.tleuke...@gmail.com] > *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