Hi
iam trying like this in my extension.conf
some one refered in the news group past
error in messages
Sep 1 21:31:42 WARNING[28610] file.c: File Goodbye does not exist in any format
Sep 1 21:31:42 WARNING[28610] file.c: Unable to open Goodbye (format ulaw): No such file or directory
Sep 1 21:31:42 WARNING[28610] app_playback.c: ast_streamfile failed on SIP/88888-3ca6 for Goodbye
exten => 888,1,Read(${CALLERIDNUM})
exten => 888,2,MYSQL(Connect connid 127.0.0.1 root password mydatabase)
exten => 888,3,MYSQL(Query resultid ${connid} select total from balance where username=${CALLERIDNUM})
exten => 888,4,MYSQL(Fetch fetch ${resultid} AMOUNT-DUE)
exten => 888,5,MYSQL(Clear ${resultid})
exten => 888,6,Playback(Goodbye)
exten => 888,7,Hangup
Sep 1 21:31:42 WARNING[28610] file.c: Unable to open Goodbye (format ulaw): No such file or directory
Sep 1 21:31:42 WARNING[28610] app_playback.c: ast_streamfile failed on SIP/88888-3ca6 for Goodbye
exten => 888,1,Read(${CALLERIDNUM})
exten => 888,2,MYSQL(Connect connid 127.0.0.1 root password mydatabase)
exten => 888,3,MYSQL(Query resultid ${connid} select total from balance where username=${CALLERIDNUM})
exten => 888,4,MYSQL(Fetch fetch ${resultid} AMOUNT-DUE)
exten => 888,5,MYSQL(Clear ${resultid})
exten => 888,6,Playback(Goodbye)
exten => 888,7,Hangup
iam calling from my extension to 888
Ram
On 9/1/06, John Millican <[EMAIL PROTECTED]> wrote:
On Friday September 01 2006 10:19 am, ram wrote:
> Hi
>
> thanks for the quick reply
>
> any documents to read to achive this
> or any examples would be great to read
>
> Ram
>
> On 9/1/06, John Millican <[EMAIL PROTECTED] > wrote:
> > On Friday September 01 2006 9:27 am, ram wrote:
> > > Hi
> > >
> > > how can i do balance anouncement by using asterisk
> > >
> > > take example, i have table balance , user name 99999, balance 200$
> > >
> > > user dial *98 or what ever, then i need anouce his balance is 200$, by
> > > reading from that row
> > >
> > > any clues how can i achive this or is this possible ?
> > >
> > > Ram
> >
> > Create an AGI script that does a db look up for the ballance and then
> > pass the
> > result back to Cepstral or Festival or your favorite text to speech
> > software.
> > John M
> >
Try google or voip-info.org and search for
Asterisk AGI should yeid some good results.
AGI can be called from the dial plan and written in your favorite language
i.e. PHP, C++, Perl, C, Java
or start here:
http://home.cogeco.ca/~camstuff/agi.html
http://asterisk.drunkcoder.com/agi.cgi
John M
_______________________________________________
--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
_______________________________________________ --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
