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
