[asterisk-users] IVR and MySQL

[Fabio Ardeola]

James / Atis / Thiago

Let say that the user entry during the call is a
reference number of a house to rent. Would be possible
to check if the reference number is a valid entry on
the MySQL database and then base on its answer define
the next menu item on the IVR menu.

Thanks,
Fabio


--- James FitzGibbon <james.fitzgibbon at gmail.com>
wrote:

> On 8/14/07, Atis <atis at best.eu.org> wrote:
> >
> > That's possible, but i wouldn't recommend on large
> production system.
> > Using MySQL you would need to connect and
> disconnect all the time, and
> > it takes resources.. I would suggest to append
> that info to CDR
> > userfield (if you are storing your CDR in MySQL),
> and run periodically
> > some script that extracts them. Of course it's
> more complex, but that
> > would be my way.
> 
> 
> If the data you wish to store is more complex than
> stuffing in the CDR
> userfield would allow, you can always call out to an
> AGI which can write the
> data to whatever file format you want for later
> loading into a database.
> 
> If you used FastAGI and a pre-forking AGI server
> model, you could even take
> the database connection hit when the AGI server
> starts.  The per-call cost
> would then be the cost to establish the socket
> connection to the AGI server
> from Asterisk, the cost to perform the SQL inserts
> over an established
> database connection, plus whatever other calculation
> or transformation you
> needed to do before doing the insert.
> 
> That architecture would hold up under a fairly large
> load.  Perl's
> Asterisk::FastAGI framework lets you specify the
> number of pre-forked
> children to launch, plus you can tell each child to
> exit (spawning a
> replacement for the pool) after processing a certain
> number of
> transactions.  It's very similar to the Apache
> prefork model.
> 
> -- 
> j.
> > _______________________________________________
> --Bandwidth and Colocation Provided by
> http://www.api-digital.com--
> 
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   
http://lists.digium.com/mailman/listinfo/asterisk-users



      ____________________________________________________________________________________
Park yourself in front of a world of choices in alternative vehicles. Visit the Yahoo! Auto Green Center.
http://autos.yahoo.com/green_center/