<div>Hi</div>
<div> </div>
<div>as i have posted before iam trying to integrate IVR with Balance</div>
<div> </div>
<div>exten => 888,1,Read(${CALLERIDNUM})<br>exten => 888,2,MYSQL(Connect connid <a href="http://127.0.0.1">127.0.0.1</a> root password database)<br>exten => 888,3,MYSQL(Query resultid ${connid} select\ saldo\ from\ balance\ where\ username=${CALLERIDNUM})
<br>exten => 888,4,Wait(1)<br>exten => 888,5,MYSQL(Fetch fetch ${resultid} AMOUNT-DUE)<br>exten => 888,6,Playback(card-balance-is ${AMOUNT-DUE})<br>exten => 888,7,MYSQL(Clear ${resultid})<br>exten => 888,8,MYSQL(Disconnect ${connid})
<br> </div>
<div> </div>
<div>I have added in the extension.conf above config</div>
<div> </div>
<div>when i dial from X-lite ( my users ID 88888) to 888, its going to Asterisk </div>
<div> </div>
<div>after some time it hangs up automatically</div>
<div> </div>
<div>when i see the log, its getting the balance "17" in my case</div>
<div>but its not able to play that value</div>
<div> </div>
<div>so i have added the GSM file before the Amount Value.</div>
<div> </div>
<div>Sep 13 16:18:50 WARNING[3647]: file.c:512 ast_openstream_full: File card-balance-is 17 does not exist in any format<br>Sep 13 16:18:50 WARNING[3647]: file.c:824 ast_streamfile: Unable to open card-balance-is 17 (format gsm): No such file or directory
<br>Sep 13 16:18:50 WARNING[3647]: app_playback.c:132 playback_exec: ast_streamfile failed on SIP/88888-b7a4 for card-balance-is 17<br> </div>
<div> </div>
<div>can some one help me to resolve this problem</div>
<div>i feel some where iam doing mistake.</div>
<div> </div>
<div>Ram</div>