Hi, please check the documentation fro SQLAuth: Your SQL query must always return something. Yours looks it won't return anything for valid calls which would disconnect them. Also, make sure you properly quote the parameters from GnuGk in your SQL statements. Regards, Jan -- Jan Willamowius, Founder of the GNU Gatekeeper Project EMail : jan@xxxxxxxxxxxxxx Website: http://www.gnugk.org Support: http://www.willamowius.com/gnugk-support.html Relaxed Communications GmbH Frahmredder 91 22393 Hamburg Geschäftsführer: Jan Willamowius HRB 125261 (Amtsgericht Hamburg) USt-IdNr: DE286003584 Robert Kulagowski wrote: > On Mon, Nov 30, 2015 at 9:36 AM, Robert Edeker <idxman01@xxxxxxxxx> wrote: > > 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/
