[asterisk-users] IVR not able to Play the Balance.. need some helphere

ram talk2ram at gmail.com
Wed Sep 13 06:17:58 MST 2006


thanks for the quick reply

yes as suggested i did the Following modification

exten => 888,1,Read(${CALLERIDNUM})
exten => 888,2,MYSQL(Connect connid root password database)
exten => 888,3,MYSQL(Query resultid ${connid} select\ saldo\ from\ balance\
where\ username=${CALLERIDNUM})
exten => 888,4,Wait(1)
exten => 888,5,MYSQL(Fetch fetch ${resultid} AMOUNT-DUE)
exten => 888,6,Playback(card-balance-is)
exten => 888,7,Wait(2)
exten => 888,8,Playback(${AMOUNT-DUE})
exten => 888,9,MYSQL(Clear ${resultid})
exten => 888,10,MYSQL(Disconnect ${connid})

when i dial 888, i get sound card balance is,then after few seconds hangup.

and i see in debug the following error

Sep 13 18:46:59 WARNING[3907]: file.c:512 ast_openstream_full: File 17 does
not exist in any format
Sep 13 18:46:59 WARNING[3907]: file.c:824 ast_streamfile: Unable to open 17
(format gsm): No such file or directory

how to play the results

can some one help me in this regard

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20060913/e98b9a21/attachment.htm

More information about the asterisk-users mailing list