On Mon, 10 May 2010, Myles Wakeham wrote:
> I am running Asterisk 1.4.2 and recently we changed the SIP provider of
> our main incoming DID number. The new provider prefixes all CallerID
> records with a +1 in front of the number, whereas the previous SIP
> provider did not.
>
> Consequently now all my blacklisted numbers aren't matching in my
> Dialplan, so I'm getting tele-spammed.
Probably all those left-leaning weenies that think AZ doesn't have the
right to remove criminals in the face of a disinterested federal
government :)
> Is there a way that I can work with the blacklist database like a SQL
> database, and just apply a script to update all numbers and add the
> prefix to them if they don't have it already?
>
> Myles
> --
> -----------------------------
> Myles Wakeham
> Director of Engineering
> Tech Solutions USA, Inc.
> Scottsdale, Arizona USA
> www.techsolusa.com
> Phone +1-480-451-7440
Off the top of my head...
mysql> create table foo as select * from blacklisted_anis;
mysql> update foo set ani = concat('+1', ani) where ani not like
'+1%';
mysql> select * from foo limit 10;
If you like what you see, roll the dice with your production database.
--
Thanks in advance,
-------------------------------------------------------------------------
Steve Edwards sedwards at sedwards.com Voice: +1-760-468-3867 PST
Newline Fax: +1-760-731-3000