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

[Steve Totaro]

ram wrote:
> Hi
>  
> thanks for the quick reply
>  
> yes as suggested i did the Following modification
>  
> exten => 888,1,Read(${CALLERIDNUM})
> exten => 888,2,MYSQL(Connect connid 127.0.0.1 <http://127.0.0.1> 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
>  
> Ram
Maybe if you copy 17.gsm from /sounds/digits to /sounds it might work or 
put the path in the playback priority 8.

Thanks,
Steve Totaro