[Asterisk-Users] Blocking the 'Do Not Call" List

[mattf]

An AGI script can exit any way you want it to. You can have it set the
extension and the Priority to whatever you desire, you're not limited to +1
or +101 you can have it be anything. 

As for speed, AGI scripts that we use on a daily basis do thousands of
searches a day through a 800,000 record table in less than a second(on a
dedicated 3.2GHz MySQL DB machine) so looking through a million shouldn't be
too bad. Asterisk will wait for the AGI to finish.

I'll email you a script off-list that you may be able to take some code from
to do your script.

MATT---


-----Original Message-----
From: drodden [mailto:drodden at webunited.net]
Sent: Tuesday, August 10, 2004 2:20 PM
To: asterisk-users at lists.digium.com
Subject: Re: [Asterisk-Users] Blocking the 'Do Not Call" List


We're not doing the entire list, just the key area codes this customer
will be calling. But yes, it's over a million and I definitely did not
intend on putting it in the dialplan.

We can make the specs of the machine nice, and put an optimized MySQL on
it, this should help with the query. Maybe even break up the tables by
area code. So that the Perl script first checks the area code, and then
only queries that table for that phone number. If MySQL finds a match,
the Perl script would return a special error code to Asterisk? If no
match, it'll exit normally. Can an AGI script exit with a +1 or a +101
kind of like the CheckGroup command does? ie if it finds a match, exist
with +201, if no match, exit with +1

Then I could do something like this:
exten _9NXXNXXNXXX => 1,AGI(check_dnc)
exten _9NXXNXXNXXX => 2,Dial(SIP/${EXTEN:1}@3640)
exten _9NXXNXXNXXX => 3,Congestion
exten _9NXXNXXNXXX => 202,BackGround(sorry-is-on-dnc)
exten _9NXXNXXNXXX => 203,Hangup

I wonder how long that AGI would take to execute, and if Asterisk would
wait for it. Does anybody have a sample AGI script I could use as a
reference?

On Tue, 2004-08-10 at 13:28, Josh Roberson wrote:
> Chris,   While you are thinking logically, This will just as 
> un-effective as putting them all in the dialplan, as the DBGet() and 
> DBPut() functionality deals with the internal astdb (db1 database). 
> 
> I would reccomend going the AGI route at this time, until we have better 
> functionality for DB handling.
> 
> -Josh
> 
> Chris Shaw wrote:
> 
> >Why use AGI? Why not just use the builtin DBGet() and DBPut() functions
in
> >*?
> >
> >    -Chris
> >
> >----- Original Message -----
> >From: "drodden" <drodden at webunited.net>
> >To: <asterisk-users at lists.digium.com>
> >Sent: Tuesday, August 10, 2004 9:22 AM
> >Subject: [Asterisk-Users] Blocking the 'Do Not Call" List
> >
> >
> >  
> >
> >>Anybody have any experience with blocking numbers in the U.S's Do Not
> >>Call list?
> >>
> >>We have a customer that will be getting their own Asterisk server from
> >>us, and they want it to be check outbound numbers against the do not
> >>call list; this is for a backup, in case there's a slip up and one of
> >>their people try to dial somebody on the do not call list.
> >>
> >>The list has millions of numbers, and I don't think the extensions.conf
> >>file could handle me listing all million+ phone numbers and making it
> >>play a sound like "That number is on the do not call list", and then
> >>creating a _NXXNXXNXXX extension at the very bottom. The list would take
> >>up all it's memory. Anybody have a more elegant solution? Maybe an AGI
> >>script to match the outbound phone number against a column in a table in
> >>a MySQL database? Is there something similar already written that I can
> >>just modify?
> >>    
> >>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
> 

_______________________________________________
Asterisk-Users mailing list
Asterisk-Users at lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users