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
