Hi
as i have posted before iam trying to integrate IVR with Balance
exten => 888,1,Read(${CALLERIDNUM})
exten => 888,2,MYSQL(Connect connid 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 ${AMOUNT-DUE})
exten => 888,7,MYSQL(Clear ${resultid})
exten => 888,8,MYSQL(Disconnect ${connid})
exten => 888,2,MYSQL(Connect connid 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 ${AMOUNT-DUE})
exten => 888,7,MYSQL(Clear ${resultid})
exten => 888,8,MYSQL(Disconnect ${connid})
I have added in the extension.conf above config
when i dial from X-lite ( my users ID 88888) to 888, its going to Asterisk
after some time it hangs up automatically
when i see the log, its getting the balance "17" in my case
but its not able to play that value
so i have added the GSM file before the Amount Value.
Sep 13 16:18:50 WARNING[3647]: file.c:512 ast_openstream_full: File card-balance-is 17 does not exist in any format
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
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
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
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
can some one help me to resolve this problem
i feel some where iam doing mistake.
Ram
_______________________________________________ --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