Re: New wave of H.323 spam calls posing as Mera RTU

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  : [email protected]
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 <[email protected]> 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:[email protected]
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/