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 sedwa...@sedwards.com Voice: +1-760-468-3867 PST Newline Fax: +1-760-731-3000 -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users