Danny hi, I just did:
$loc=$agi.get_variable('CHANNEL') $my.query("UPDATE call_log SET local = #{$loc}, endtime = NOW() WHERE id = #{call_log_id}") No success - what happens is that it breaks somewhere and neither local nor endtime gets updated. If i remove $loc = ... and SET local = #{$loc}, from query, it works. Here is the logging from the console that I have now: -- SIP/vaso-065a answered Zap/22-1 -- Hungup 'Zap/35-1' -- Hungup 'Zap/34-1' -- Hungup 'Zap/33-1' -- Hungup 'Zap/32-1' -- Executing DumpChan("SIP/vaso-065a", "") in new stack Dumping Info For Channel: SIP/vaso-065a: ============================================================================ ==== Info: Name= SIP/vaso-065a Type= SIP UniqueID= 1280409971.1496 CallerID= 8221 CallerIDName= (N/A) DNIDDigits= (N/A) State= Up (6) Rings= 0 NativeFormat= 2 WriteFormat= 4 ReadFormat= 4 1stFileDescriptor= 74 Framesin= 4 Framesout= 0 TimetoHangup= 0 ElapsedTime= 0h0m0s Context= macro-testing Extension= s Priority= 1 CallGroup= PickupGroup= Application= DumpChan Data= (Empty) Blocking_in= (Not Blocking) Variables: MACRO_DEPTH=1> MACRO_PRIORITY=1 MACRO_CONTEXT=siptest ============================================================================ ==== -- Executing Set("SIP/vaso-065a", "WHO=SIP/vaso-065a") in new stack -- Executing Answer("SIP/vaso-f139", "") in new stack == Auto fallthrough, channel 'SIP/vaso-f139' status is 'UNKNOWN' -- Channel 0/22, span 1 got hangup request AGI Tx >> 200 result=-1 == Spawn extension (incoming, 8221, 1) exited non-zero on 'Zap/22-1' -- Hungup 'Zap/22-1' -- Executing Answer("SIP/vaso-e6cd", "") in new stack == Auto fallthrough, channel 'SIP/vaso-e6cd' status is 'UNKNOWN' In case you wanted to tell me to try $loc=$agi.get_variable('WHO') - tried that too, same thing. This is driving me nuts to be frank. From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Danny Nicholas Sent: Thursday, July 29, 2010 3:09 PM To: 'Asterisk Users Mailing List - Non-Commercial Discussion' Subject: Re: [asterisk-users] Urgent help = RUBY & AGI Strictly a shot in the dark, but have you tried $loc=$agi.get_variable('CHANNEL') ? __________ Information from ESET NOD32 Antivirus, version of virus signature database 5323 (20100729) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users