asterisk users - Jul 2013 - asterisk and IVR

Hello list,

i need your help about the IVR please

i have asterisk 1.4 installed and i configure an IVR like below

exten => 529,1,Ringing()
exten => 529,n,Wait(4)
exten => 529,n,Goto(home,s,1)

[home]
exten => s,1,SetGlobalVar(sounds_path=/var/lib/asterisk/sounds/)
exten => s,n,Background(${sounds_path}welcome)
exten => s,n,WaitExten(5)
exten => s,n,goto(home,s,1)
exten => i,1,Playback(${sounds_path}erreur-saisie)
exten => i,2,goto(home,s,1)
exten => t,1,Goto(home,s,1)
exten => 1,1,Goto(call,s,1)




[call]
exten => s,1,NoOp(User chose support option)
exten => s,n,Dial(SIP/228, 30)
exten => s,n,NoOp(User chose support option)
exten => s,n,MYSQL(Connect connid localhost database login password)
exten => s,n,MYSQL(Query resultid ${connid} INSERT\ INTO\ menu\  SET\
callerid='${CALLERID(num)}'\, calldate=now()\, ext="no
response"\)
exten => s,n,MYSQL(Clear ${resultid})
exten => s,n,MYSQL(Disconnect ${connid})
exten => s,n,hangup

when i call the number 529 i can get the home and when i press 1 i get the
call  when there is no response from my sip/228 i can store the date and
time in my database

but when i handel the call from my sip i can't store the data in my table

calldate                         callerid                          ext
2013-07-25 14:09:20 0661xxxxxx     No response

my question how can i do in order to store the data in my database with the
ext = response or no response

thanks and regards
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20130725/fdd069d1/attachment.htm>

On Thursday 25 July 2013, Salaheddine Elharit wrote:
> i have asterisk 1.4 installed and i configure an IVR like below
> .....  stuff deleted .....
> when i call the number 529 i can get the home and when i press 1 i get the
> call  when there is no response from my sip/228 i can store the date and
> time in my database
> 
> but when i handel the call from my sip i can't store the data in my
table
> 
> calldate                         callerid                          ext
> 2013-07-25 14:09:20 0661xxxxxx     No response
> 
> my question how can i do in order to store the data in my database with the
> ext = response or no response
You need to do this from an extension called "h"  (which gets run when
a call
is hung up),  in the same context where the call was placed.  You can look at 
the variables ${DIALSTATUS} and ${HANGUPCAUSE} to see how the call went.

-- 
AJS

Answers come *after* questions.