asterisk users - Nov 2006 - Asterisk IVR functionality

Hi

i have an application developed with bayonne.

Recentely i'm experiencing some problems and i am planning to migrate
to asterisk.

I would like to know if i can do these things whit asterisk:

- IVR integration with database (mysql, insert,delete,update,select)
- TTS
- record exploration (for example, check if some resources are
available in the database, and list them to the user (via TTS))

Are these things possible?

Yes, you can but you need to use external software for TTS.

nik600 wrote:
> Hi
>
> i have an application developed with bayonne.
>
> Recentely i'm experiencing some problems and i am planning to migrate
> to asterisk.
>
> I would like to know if i can do these things whit asterisk:
>
> - IVR integration with database (mysql, insert,delete,update,select)
> - TTS
> - record exploration (for example, check if some resources are
> available in the database, and list them to the user (via TTS))
>
> Are these things possible?
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>

On 11/13/06, nik600 <nik600@gmail.com> wrote:
> i have an application developed with bayonne.
> I would like to know if i can do these things whit asterisk:
>
> - IVR integration with database (mysql, insert,delete,update,select)
Yes, you have to write AGI scripts to do this.
> - TTS
No idea.
> - record exploration (for example, check if some resources are
> available in the database, and list them to the user (via TTS))
Should be possible via AGI.

raj

On Mon, Nov 13, 2006 at 12:46:14PM +0100, nik600 wrote:
> Hi
> 
> i have an application developed with bayonne.
> 
> Recentely i'm experiencing some problems and i am planning to migrate
> to asterisk.
> 
> I would like to know if i can do these things whit asterisk:
> 
> - IVR integration with database (mysql, insert,delete,update,select)
Asterisk uses a system called AGI to provide IVR.  For more information
see http://www.voip-info.org/wiki-Asterisk+AGI.  As such, IVR
applications are just scripts.  You can use whatever the underlying
platform supports.
> - TTS
Text to Speech in Asterisk is supported by Festival
(http://www.voip-info.org/wiki/view/Festival).
> - record exploration (for example, check if some resources are
> available in the database, and list them to the user (via TTS))
Again, this just done by your script.  If you can do it in the
underlying langugae, you can do it in your IVR app.
> 
> Are these things possible?
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
> 
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users

On 11/13/06, Pavel Siderov <psiderov@nexcom.bg>
wrote:
> Yes, you can but you need to use external software for TTS.
>
ok, thanks

can you suggest me some example for the database interaction?

for example, how can i connect to the database?
how can i make a query and list the records found?

thanks