On Mon, Nov 30, 2015 at 9:36 AM, Robert Edeker <idxman01@xxxxxxxxx> wrote: > I second that. Not using any SQL back-ends at this time. > > We have some control via the firewall by Geographic area and business hours, > but nevertheless want to block spam. OK, so if I create a table called "banTable" in MySQL, and insert the following: create table banTable( acceptCall boolean default false, vendor varchar(64) not null) (probably doesn't work but that's OK) insert into banTable(acceptCall,vendor) values(false,"Mera"); Then I create a SQLAuth section in the gatekeeper.ini: CallQuery = SELECT acceptCall FROM banTable WHERE vendor LIKE %{Vendor} And if I have sql in the routing then it should work to block Mera calls? And I can put cisco ooh323 as the other vendor to auto-block? ------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 _______________________________________________________ Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Archive: http://sourceforge.net/mailarchive/forum.php?forum_name=openh323gk-users Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users Homepage: http://www.gnugk.org/