[asterisk-users] IVR - Automatic Attendant database query

[Mike Clark]

Dirk Enrique Seiffert wrote:

>Hello,
>
>I am new to Asterisk, looking for a PBX solution doing and automatic
>response based on a database query. I spent some hours googling, reading
>manuals without too much luck. (Maybe I am just blind ...)
>
>What we want to reach:
>
>Caller dials in, gets prompted to dial an extension depending on the
>information he is looking for. Lets say "Dial 1 if you want to know if
>your account is active". After dialing the number caller gets prompted to
>dial his personal code. Based on this code we need do to a query to an
>external Sybase database. Depending on the query result we will play a
>recording to the caller. "Yes, your account is active", "Sorry, your
>account has been disabled..."
>
>I couldn't find any examples on the auto attendent reading responses from
>a database, though it looks like a common task to me. Can anybody provide
>some hints, links, directions or experiences for this kind of
>configuration?
>
>Thanks a lot
>
>Dirk
>
>
>  
>
Take a look here:

http://www.voip-info.org/wiki-Asterisk+AGI

This will get you going on AGI. From an AGI script, you can query 
databases. We do several apps with PHP and MySQL.


Mike Clark