search

blak3r / yaai

SugarCRM Asterisk integration
http://www.sugarforge.org/projects/yaai
GNU General Public License v3.0
81 stars 85 forks source link

No POPUP while I/C call placed in queue #175

Open jagspaul opened 10 years ago

jagspaul commented 10 years ago

I am using

Asterisk-1.8.25.0, SugarCE-6.5.16, yaai 3.6.9 (callinize-community-3.6.9.zip)

When I placed incoming PSTN call directly to SIP user the POPUP displayed. [from-pstn] ;Incoming calls exten => s,1,Answer() exten => s,n,Dial(sip/1111)

But when the same call is placed on queue no POPUP displayed, while SIP user (queue member) is getting incoming call on SIP phone. Even after answer the call over sip phone no POPUP.

[from-pstn] ;Incoming calls exten => s,1,Answer() exten => s,n,Queue(Q110)

Please note that in the both cases asteriskLogger.php showing some error on terminals as follows.

asteriskLogger for with out queue:

[2014-02-23 12:42:33] ! --- Event ----------------------------------------------------------- ! Event --> Newchannel
! Privilege --> call,all
! Channel --> DAHDI/33-1
! ChannelState --> 9
! ChannelStateDesc --> Pre-ring
! CallerIDNum -->
! CallerIDName -->
! AccountCode -->
! Exten -->
! Context --> from-pstn
! Uniqueid --> 1393159353.84
! --------------------------------------------------------------------- [2014-02-23 12:42:33] ! --- Event ----------------------------------------------------------- ! Event --> DAHDIChannel
! Privilege --> call,all
! Channel --> DAHDI/33-1
! Uniqueid --> 1393159353.84
! DAHDISpan --> 2
! DAHDIChannel --> 33
! --------------------------------------------------------------------- ! AMI Event 'Newstate suppressed. [2014-02-23 12:42:35] ! --- Event ----------------------------------------------------------- ! Event --> NewCallerid
! Privilege --> call,all
! Channel --> DAHDI/33-1
! CallerIDNum --> 9432247551
! CallerIDName -->
! Uniqueid --> 1393159353.84
! CID-CallingPres --> 0 (Presentation Allowed, Not Screened)
! --------------------------------------------------------------------- CallerID Changed to: 9432247551 ! AMI Event 'Newstate suppressed. [2014-02-23 12:42:36] ! --- Event ----------------------------------------------------------- ! Event --> Newchannel
! Privilege --> call,all
! Channel --> SIP/1111-0000003b
! ChannelState --> 0
! ChannelStateDesc --> Down
! CallerIDNum -->
! CallerIDName -->
! AccountCode -->
! Exten -->
! Context --> from-sip
! Uniqueid --> 1393159356.85
! --------------------------------------------------------------------- [2014-02-23 12:42:36] ! --- Event ----------------------------------------------------------- ! Event --> NewCallerid
! Privilege --> call,all
! Channel --> SIP/1111-0000003b
! CallerIDNum --> s
! CallerIDName -->
! Uniqueid --> 1393159356.85
! CID-CallingPres --> 0 (Presentation Allowed, Not Screened)
! --------------------------------------------------------------------- CallerID Changed to: s [2014-02-23 12:42:36] ! --- Event ----------------------------------------------------------- ! Event --> Dial
! Privilege --> call,all
! SubEvent --> Begin
! Channel --> DAHDI/33-1
! Destination --> SIP/1111-0000003b
! CallerIDNum --> 9432247551
! CallerIDName -->
! ConnectedLineNum -->
! ConnectedLineName -->
! UniqueID --> 1393159353.84
! DestUniqueID --> 1393159356.85
! Dialstring --> 1111
! --------------------------------------------------------------------- ! Dial Event src=DAHDI/33-1 dest=SIP/1111-0000003b PHP Notice: Undefined index: event in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 439 ! Successfully created CALL record with id=c61bfc7e-4a34-77e3-81e9-5309ec26d748 Stripping callout prefix: Stripping callin prefix: CallerID is: 9432247551 Looking for user extension number in: SIP/1111-0000003b Channel Matched SIP/### style regex. Ext is:1111 Looking for user extension number in: SIP/1111-0000003b Channel Matched SIP/### style regex. Ext is:1111 inbound_extension = 1111 Inbound state detected... /^(sip\/[1-9][0-9][0-9][0-9]?[0-9]?-|Local)/i is astMatchInternal eChannel= DAHDI/33-1 eDestination=SIP/1111-0000003b PHP Notice: Undefined index: event in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 613 ! AMI Event 'Newstate suppressed. ! AMI Event 'Newstate suppressed. [2014-02-23 12:42:47] ! --- Event ----------------------------------------------------------- ! Event --> NewAccountCode
! Privilege --> call,all
! Channel --> SIP/1111-0000003b
! Uniqueid --> 1393159356.85
! AccountCode -->
! OldAccountCode -->
! --------------------------------------------------------------------- [2014-02-23 12:42:47] ! --- Event ----------------------------------------------------------- ! Event --> Bridge
! Privilege --> call,all
! Bridgestate --> Link
! Bridgetype --> core
! Channel1 --> DAHDI/33-1
! Channel2 --> SIP/1111-0000003b
! Uniqueid1 --> 1393159353.84
! Uniqueid2 --> 1393159356.85
! CallerID1 --> 9432247551
! CallerID2 --> s
! --------------------------------------------------------------------- DEBUG: Entered Bridge DEBUG: bridge inbound, updating the Link state Bridge isn't internal to internal Internal Queue Event Detected Internal Queue: SELECT id FROM asterisk_log WHERE remote_channel like 'DAHDI/33-1' and direction='I' and (channel = '' OR channel is NULL) Queue-Bridge ERROR: MULTIPLE MATCHING LINES IN ASTERISK LOG... BRIDGE LOGIC ISN'T BULLETPROOF [2014-02-23 12:42:54] ! --- Event ----------------------------------------------------------- ! Event --> Unlink
! Privilege --> call,all
! Channel1 --> DAHDI/33-1
! Channel2 --> SIP/1111-0000003b
! Uniqueid1 --> 1393159353.84
! Uniqueid2 --> 1393159356.85
! CallerID1 --> 9432247551
! CallerID2 --> s
! --------------------------------------------------------------------- [2014-02-23 12:42:54] ! --- Event ----------------------------------------------------------- ! Event --> Hangup
! Privilege --> call,all
! Channel --> SIP/1111-0000003b
! Uniqueid --> 1393159356.85
! CallerIDNum --> s
! CallerIDName -->
! ConnectedLineNum --> 9432247551
! ConnectedLineName -->
! Cause --> 16
! Cause-txt --> Normal Clearing
! --------------------------------------------------------------------- In DialEnd... 1393159356.85 PHP Notice: Undefined index: asterisk_only_log_calls_matching_user_extension in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 716

+++ findCallByAsteriskId(1393159356.85)

! Warning, results set was empty! [2014-02-23 12:42:54] ! --- Event ----------------------------------------------------------- ! Event --> Dial
! Privilege --> call,all
! SubEvent --> End
! Channel --> DAHDI/33-1
! UniqueID --> 1393159353.84
! DialStatus --> ANSWER
! --------------------------------------------------------------------- In DialEnd... 1393159353.84 PHP Notice: Undefined index: asterisk_only_log_calls_matching_user_extension in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 716

+++ findCallByAsteriskId(1393159353.84)

! Found entry in asterisk_log recordId=c61bfc7e-4a34-77e3-81e9-5309ec26d748 Array ( [bitter] => Array ( [id] => 99 [is_master] => 0 [call_record_id] => c61bfc7e-4a34-77e3-81e9-5309ec26d748 [asterisk_id] => 1393159353.84 [callstate] => Connected [uistate] => [callerID] => 9432247551 [channel] => SIP/1111-0000003b [remote_channel] => DAHDI/33-1 [timestamp_call] => 2014-02-23 12:42:37 [timestamp_link] => 2014-02-23 12:42:47 [timestamp_hangup] => [direction] => I [asterisk_dest_id] => 1393159356.85 [opencnam] => [answered] => 0 [user_extension] => 1111 [user_device] => 1111 [inbound_extension] => 1111 [bean_module] => [bean_id] => [bean_name] => [bean_link] => [bean_description] => [parent_module] => [parent_id] => [parent_name] => [parent_link] => [push_sent] => 0 )

[sweet] => Array
    (
        [assigned_user_name] => Jagadish Paul Administrator
        [modified_by_name] => Jagadish Paul Administrator
        [created_by_name] => Jagadish Paul Administrator
        [id] => c61bfc7e-4a34-77e3-81e9-5309ec26d748
        [name] => ** Automatic record **
        [date_entered] => 2014-02-23 12:42:36
        [date_modified] => 2014-02-23 12:42:37
        [modified_user_id] => 1
        [created_by] => 1
        [description] => 
        [deleted] => 0
        [assigned_user_id] => 1
        [duration_hours] => 0
        [duration_minutes] => 
        [date_start] => 
        [date_end] => 
        [parent_type] => 
        [status] => In Limbo
        [direction] => Inbound
        [parent_id] => 
        [reminder_time] => -1
        [email_reminder_time] => -1
        [email_reminder_sent] => 0
        [outlook_id] => 
        [contact_name] => 
        [repeat_type] => 
        [repeat_interval] => 1
        [repeat_dow] => 
        [repeat_until] => 
        [repeat_count] => 
        [repeat_parent_id] => 
        [recurring_source] => 
        [asterisk_caller_id_c] => 
        [asterisk_call_id_c] => 
        [asterisk_inbound_ext_c] => 
        [asterisk_user_ext_c] => 
    )

) Looking for user extension number in: SIP/1111-0000003b Channel Matched SIP/### style regex. Ext is:1111

+++ findUserByAsteriskExtension(1111)

! Assigned user id set to 1 Measured call duration is 7 seconds ! Call is not related to any record (no matches) ! Invalid Arguments passed to setRelationshipBetweenCallAndBean callRecordId=c61bfc7e-4a34-77e3-81e9-5309ec26d748, beanId=, beanType= ! Call start was 2014-02-23 12:42:37 Updating record in /Calls/ id=c61bfc7e-4a34-77e3-81e9-5309ec26d748... NAME: \ Automatic record ** DESCRIPTION: Cleaning up Failed Calls part1, asterisk_id = 1393159353.84 [2014-02-23 12:42:56] ! --- Event ----------------------------------------------------------- ! Event --> Hangup
! Privilege --> call,all
! Channel --> DAHDI/33-1
! Uniqueid --> 1393159353.84
! CallerIDNum --> 9432247551
! CallerIDName -->
! ConnectedLineNum -->
! ConnectedLineName -->
! Cause --> 16
! Cause-txt --> Normal Clearing
! --------------------------------------------------------------------- In DialEnd... 1393159353.84 PHP Notice: Undefined index: asterisk_only_log_calls_matching_user_extension in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 716

+++ findCallByAsteriskId(1393159353.84)

! Found entry in asterisk_log recordId=c61bfc7e-4a34-77e3-81e9-5309ec26d748 Array ( [bitter] => Array ( [id] => 99 [is_master] => 0 [call_record_id] => c61bfc7e-4a34-77e3-81e9-5309ec26d748 [asterisk_id] => 1393159353.84 [callstate] => Hangup [uistate] => [callerID] => 9432247551 [channel] => SIP/1111-0000003b [remote_channel] => DAHDI/33-1 [timestamp_call] => 2014-02-23 12:42:37 [timestamp_link] => 2014-02-23 12:42:47 [timestamp_hangup] => 2014-02-23 12:42:54 [direction] => I [asterisk_dest_id] => 1393159356.85 [opencnam] => [answered] => 1 [user_extension] => 1111 [user_device] => 1111 [inbound_extension] => 1111 [bean_module] => [bean_id] => [bean_name] => [bean_link] => [bean_description] => [parent_module] => [parent_id] => [parent_name] => [parent_link] => [push_sent] => 0 )

[sweet] => Array
    (
        [assigned_user_name] => Jagadish Paul Administrator
        [modified_by_name] => Jagadish Paul Administrator
        [created_by_name] => Jagadish Paul Administrator
        [id] => c61bfc7e-4a34-77e3-81e9-5309ec26d748
        [name] => Incoming call
        [date_entered] => 2014-02-23 12:42:36
        [date_modified] => 2014-02-23 12:42:55
        [modified_user_id] => 1
        [created_by] => 1
        [description] => 
        [deleted] => 0
        [assigned_user_id] => 1
        [duration_hours] => 0
        [duration_minutes] => 0
        [date_start] => 2014-02-23 12:42:37
        [date_end] => 2014-02-23 12:42:37
        [parent_type] => 
        [status] => Held
        [direction] => Inbound
        [parent_id] => 
        [reminder_time] => -1
        [email_reminder_time] => -1
        [email_reminder_sent] => 0
        [outlook_id] => 
        [contact_name] => 
        [repeat_type] => 
        [repeat_interval] => 1
        [repeat_dow] => 
        [repeat_until] => 
        [repeat_count] => 
        [repeat_parent_id] => 
        [recurring_source] => 
        [asterisk_caller_id_c] => 9432247551
        [asterisk_call_id_c] => 1393159353.84
        [asterisk_inbound_ext_c] => 1111
        [asterisk_user_ext_c] => 1111
    )

) Looking for user extension number in: SIP/1111-0000003b Channel Matched SIP/### style regex. Ext is:1111

+++ findUserByAsteriskExtension(1111)

! Assigned user id set to 1 Measured call duration is 9 seconds ! Call is not related to any record (no matches) ! Invalid Arguments passed to setRelationshipBetweenCallAndBean callRecordId=c61bfc7e-4a34-77e3-81e9-5309ec26d748, beanId=, beanType= ! Call start was 2014-02-23 12:42:37 Updating record in /Calls/ id=c61bfc7e-4a34-77e3-81e9-5309ec26d748... NAME: Incoming call DESCRIPTION: Cleaning up Failed Calls part1, asterisk_id = 1393159353.84

asteriskLogger for with queue:

AMI Login was a success! Waiting for call events... [2014-02-23 12:40:03] ! --- Event ----------------------------------------------------------- ! Event --> Newchannel
! Privilege --> call,all
! Channel --> DAHDI/33-1
! ChannelState --> 9
! ChannelStateDesc --> Pre-ring
! CallerIDNum -->
! CallerIDName -->
! AccountCode -->
! Exten -->
! Context --> from-pstn
! Uniqueid --> 1393159203.81
! --------------------------------------------------------------------- [2014-02-23 12:40:03] ! --- Event ----------------------------------------------------------- ! Event --> DAHDIChannel
! Privilege --> call,all
! Channel --> DAHDI/33-1
! Uniqueid --> 1393159203.81
! DAHDISpan --> 2
! DAHDIChannel --> 33
! --------------------------------------------------------------------- ! AMI Event 'Newstate suppressed. [2014-02-23 12:40:05] ! --- Event ----------------------------------------------------------- ! Event --> NewCallerid
! Privilege --> call,all
! Channel --> DAHDI/33-1
! CallerIDNum --> 9432247551
! CallerIDName -->
! Uniqueid --> 1393159203.81
! CID-CallingPres --> 0 (Presentation Allowed, Not Screened)
! --------------------------------------------------------------------- CallerID Changed to: 9432247551 ! AMI Event 'Newstate suppressed. [2014-02-23 12:40:06] ! --- Event ----------------------------------------------------------- ! Event --> Join
! Privilege --> call,all
! Channel --> DAHDI/33-1
! CallerIDNum --> 9432247551
! CallerIDName --> unknown
! ConnectedLineNum --> unknown
! ConnectedLineName --> unknown
! Queue --> Q110
! Position --> 1
! Count --> 1
! Uniqueid --> 1393159203.81
! --------------------------------------------------------------------- PHP Notice: Undefined index: Destination in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 437 ! Dial Event src=DAHDI/33-1 dest= PHP Notice: Undefined index: event in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 439 PHP Notice: Undefined index: Destination in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 448 DestUniqueID is empty, this must be a queue call... or logic error ! Successfully created CALL record with id=173b0967-3edc-9858-509c-5309ec80f1cc Stripping callout prefix: Stripping callin prefix: CallerID is: 9432247551 Looking for user extension number in: inbound_extension = Q110 Inbound state detected... /^(sip\/[1-9][0-9][0-9][0-9]?[0-9]?-|Local)/i is astMatchInternal eChannel= DAHDI/33-1 eDestination= PHP Notice: Undefined index: event in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 613 [2014-02-23 12:40:07] ! --- Event ----------------------------------------------------------- ! Event --> MusicOnHold
! Privilege --> call,all
! State --> Start
! Channel --> DAHDI/33-1
! UniqueID --> 1393159203.81
! Class --> default
! --------------------------------------------------------------------- [2014-02-23 12:40:07] ! --- Event ----------------------------------------------------------- ! Event --> Newchannel
! Privilege --> call,all
! Channel --> SIP/1111-00000039
! ChannelState --> 0
! ChannelStateDesc --> Down
! CallerIDNum -->
! CallerIDName -->
! AccountCode -->
! Exten -->
! Context --> from-sip
! Uniqueid --> 1393159206.82
! --------------------------------------------------------------------- ! AMI Event 'Newstate suppressed. [2014-02-23 12:40:21] ! --- Event ----------------------------------------------------------- ! Event --> Hangup
! Privilege --> call,all
! Channel --> SIP/1111-00000039
! Uniqueid --> 1393159206.82
! CallerIDNum -->
! CallerIDName -->
! ConnectedLineNum --> 9432247551
! ConnectedLineName -->
! Cause --> 16
! Cause-txt --> Normal Clearing
! --------------------------------------------------------------------- In DialEnd... 1393159206.82 PHP Notice: Undefined index: asterisk_only_log_calls_matching_user_extension in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 716

+++ findCallByAsteriskId(1393159206.82)

! Warning, results set was empty! [1393159206.82] FAILED TO FIND A CALL (note: there are two hangups per call, so this might not be an error) [2014-02-23 12:40:26] ! --- Event ----------------------------------------------------------- ! Event --> MusicOnHold
! Privilege --> call,all
! State --> Stop
! Channel --> DAHDI/33-1
! UniqueID --> 1393159203.81
! --------------------------------------------------------------------- [2014-02-23 12:40:33] ! --- Event ----------------------------------------------------------- ! Event --> MusicOnHold
! Privilege --> call,all
! State --> Start
! Channel --> DAHDI/33-1
! UniqueID --> 1393159203.81
! Class --> default
! --------------------------------------------------------------------- [2014-02-23 12:40:33] ! --- Event ----------------------------------------------------------- ! Event --> Newchannel
! Privilege --> call,all
! Channel --> SIP/1111-0000003a
! ChannelState --> 0
! ChannelStateDesc --> Down
! CallerIDNum -->
! CallerIDName -->
! AccountCode -->
! Exten -->
! Context --> from-sip
! Uniqueid --> 1393159233.83
! --------------------------------------------------------------------- ! AMI Event 'Newstate suppressed. ! AMI Event 'Newstate suppressed. [2014-02-23 12:40:37] ! --- Event ----------------------------------------------------------- ! Event --> MusicOnHold
! Privilege --> call,all
! State --> Stop
! Channel --> DAHDI/33-1
! UniqueID --> 1393159203.81
! --------------------------------------------------------------------- [2014-02-23 12:40:37] ! --- Event ----------------------------------------------------------- ! Event --> Leave
! Privilege --> call,all
! Channel --> DAHDI/33-1
! Queue --> Q110
! Count --> 0
! Position --> 1
! Uniqueid --> 1393159203.81
! --------------------------------------------------------------------- [2014-02-23 12:40:37] ! --- Event ----------------------------------------------------------- ! Event --> NewAccountCode
! Privilege --> call,all
! Channel --> SIP/1111-0000003a
! Uniqueid --> 1393159233.83
! AccountCode -->
! OldAccountCode -->
! --------------------------------------------------------------------- [2014-02-23 12:40:37] ! --- Event ----------------------------------------------------------- ! Event --> Bridge
! Privilege --> call,all
! Bridgestate --> Link
! Bridgetype --> core
! Channel1 --> DAHDI/33-1
! Channel2 --> SIP/1111-0000003a
! Uniqueid1 --> 1393159203.81
! Uniqueid2 --> 1393159233.83
! CallerID1 --> 9432247551
! CallerID2 -->
! --------------------------------------------------------------------- DEBUG: Entered Bridge DEBUG: bridge inbound, updating the Link state Bridge isn't internal to internal Internal Queue Event Detected Internal Queue: SELECT id FROM asterisk_log WHERE remote_channel like 'DAHDI/33-1' and direction='I' and (channel = '' OR channel is NULL) Queue-Bridge ERROR: MULTIPLE MATCHING LINES IN ASTERISK LOG... BRIDGE LOGIC ISN'T BULLETPROOF [2014-02-23 12:40:44] ! --- Event ----------------------------------------------------------- ! Event --> Unlink
! Privilege --> call,all
! Channel1 --> DAHDI/33-1
! Channel2 --> SIP/1111-0000003a
! Uniqueid1 --> 1393159203.81
! Uniqueid2 --> 1393159233.83
! CallerID1 --> 9432247551
! CallerID2 -->
! --------------------------------------------------------------------- [2014-02-23 12:40:44] ! --- Event ----------------------------------------------------------- ! Event --> Hangup
! Privilege --> call,all
! Channel --> SIP/1111-0000003a
! Uniqueid --> 1393159233.83
! CallerIDNum -->
! CallerIDName -->
! ConnectedLineNum --> 9432247551
! ConnectedLineName -->
! Cause --> 16
! Cause-txt --> Normal Clearing
! --------------------------------------------------------------------- In DialEnd... 1393159233.83 PHP Notice: Undefined index: asterisk_only_log_calls_matching_user_extension in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 716

+++ findCallByAsteriskId(1393159233.83)

! Warning, results set was empty! [1393159233.83] FAILED TO FIND A CALL (note: there are two hangups per call, so this might not be an error) [2014-02-23 12:40:44] ! --- Event ----------------------------------------------------------- ! Event --> Hangup
! Privilege --> call,all
! Channel --> DAHDI/33-1
! Uniqueid --> 1393159203.81
! CallerIDNum --> 9432247551
! CallerIDName -->
! ConnectedLineNum -->
! ConnectedLineName -->
! Cause --> 0
! Cause-txt --> Unknown
! --------------------------------------------------------------------- In DialEnd... 1393159203.81 PHP Notice: Undefined index: asterisk_only_log_calls_matching_user_extension in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 716

+++ findCallByAsteriskId(1393159203.81)

! Found entry in asterisk_log recordId=173b0967-3edc-9858-509c-5309ec80f1cc Array ( [bitter] => Array ( [id] => 98 [is_master] => 0 [call_record_id] => 173b0967-3edc-9858-509c-5309ec80f1cc [asterisk_id] => 1393159203.81 [callstate] => Connected [uistate] => [callerID] => 9432247551 [channel] => [remote_channel] => DAHDI/33-1 [timestamp_call] => 2014-02-23 12:40:07 [timestamp_link] => 2014-02-23 12:40:37 [timestamp_hangup] => [direction] => I [asterisk_dest_id] => 1393159203.81 [opencnam] => [answered] => 0 [user_extension] => Q110 [user_device] => Q110 [inbound_extension] => Q110 [bean_module] => [bean_id] => [bean_name] => [bean_link] => [bean_description] => [parent_module] => [parent_id] => [parent_name] => [parent_link] => [push_sent] => 0 )

[sweet] => Array
    (
        [assigned_user_name] => Jagadish Paul Administrator
        [modified_by_name] => Jagadish Paul Administrator
        [created_by_name] => Jagadish Paul Administrator
        [id] => 173b0967-3edc-9858-509c-5309ec80f1cc
        [name] => ** Automatic record **
        [date_entered] => 2014-02-23 12:40:06
        [date_modified] => 2014-02-23 12:40:07
        [modified_user_id] => 1
        [created_by] => 1
        [description] => 
        [deleted] => 0
        [assigned_user_id] => 1
        [duration_hours] => 0
        [duration_minutes] => 
        [date_start] => 
        [date_end] => 
        [parent_type] => 
        [status] => In Limbo
        [direction] => Inbound
        [parent_id] => 
        [reminder_time] => -1
        [email_reminder_time] => -1
        [email_reminder_sent] => 0
        [outlook_id] => 
        [contact_name] => 
        [repeat_type] => 
        [repeat_interval] => 1
        [repeat_dow] => 
        [repeat_until] => 
        [repeat_count] => 
        [repeat_parent_id] => 
        [recurring_source] => 
        [asterisk_caller_id_c] => 
        [asterisk_call_id_c] => 
        [asterisk_inbound_ext_c] => 
        [asterisk_user_ext_c] => 
    )

) Looking for user extension number in:

+++ findUserByAsteriskExtension()

! Assigned user id set to seed_chris_id Measured call duration is 7 seconds ! Call is not related to any record (no matches) ! Invalid Arguments passed to setRelationshipBetweenCallAndBean callRecordId=173b0967-3edc-9858-509c-5309ec80f1cc, beanId=, beanType= ! Call start was 2014-02-23 12:40:07 Updating record in /Calls/ id=173b0967-3edc-9858-509c-5309ec80f1cc... NAME: \ Automatic record ** DESCRIPTION: Cleaning up Failed Calls part1, asterisk_id = 1393159203.81

Waiting for your help.

Thanks & regards Jags

jagspaul commented 10 years ago

please note this point from previous post log (call with queue)

DEBUG: Entered Bridge DEBUG: bridge inbound, updating the Link state Bridge isn't internal to internal Internal Queue Event Detected Internal Queue: SELECT id FROM asterisk_log WHERE remote_channel like 'DAHDI/33-1' and direction='I' and (channel = '' OR channel is NULL) Queue-Bridge ERROR: MULTIPLE MATCHING LINES IN ASTERISK LOG... BRIDGE LOGIC ISN'T BULLETPROOF

as ERROR: MULTIPLE MATCHING LINES IN ASTERISK LOG then I deleted all record. delete from asterisk_log; and found Popup coming while call is answer through sip user (call on queue test). But on popup while sip phone is ringing. The log is following below.

[2014-02-23 17:46:20] ! --- Event ----------------------------------------------------------- ! Event --> Newchannel
! Privilege --> call,all
! Channel --> DAHDI/33-1
! ChannelState --> 9
! ChannelStateDesc --> Pre-ring
! CallerIDNum -->
! CallerIDName -->
! AccountCode -->
! Exten -->
! Context --> from-pstn
! Uniqueid --> 1393177580.9
! --------------------------------------------------------------------- [2014-02-23 17:46:20] ! --- Event ----------------------------------------------------------- ! Event --> DAHDIChannel
! Privilege --> call,all
! Channel --> DAHDI/33-1
! Uniqueid --> 1393177580.9
! DAHDISpan --> 2
! DAHDIChannel --> 33
! --------------------------------------------------------------------- ! AMI Event 'Newstate suppressed. [2014-02-23 17:46:23] ! --- Event ----------------------------------------------------------- ! Event --> NewCallerid
! Privilege --> call,all
! Channel --> DAHDI/33-1
! CallerIDNum --> 9432247551
! CallerIDName -->
! Uniqueid --> 1393177580.9
! CID-CallingPres --> 0 (Presentation Allowed, Not Screened)
! --------------------------------------------------------------------- CallerID Changed to: 9432247551 ! AMI Event 'Newstate suppressed. [2014-02-23 17:46:24] ! --- Event ----------------------------------------------------------- ! Event --> Join
! Privilege --> call,all
! Channel --> DAHDI/33-1
! CallerIDNum --> 9432247551
! CallerIDName --> unknown
! ConnectedLineNum --> unknown
! ConnectedLineName --> unknown
! Queue --> Q110
! Position --> 1
! Count --> 1
! Uniqueid --> 1393177580.9
! --------------------------------------------------------------------- PHP Notice: Undefined index: Destination in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 437 ! Dial Event src=DAHDI/33-1 dest= PHP Notice: Undefined index: event in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 439 PHP Notice: Undefined index: Destination in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 448 DestUniqueID is empty, this must be a queue call... or logic error ! Successfully created CALL record with id=3c977b5a-aef8-7ddf-584a-530a335df009 Stripping callout prefix: Stripping callin prefix: CallerID is: 9432247551 Looking for user extension number in: inbound_extension = Q110 Inbound state detected... /^(sip\/[1-9][0-9][0-9]?[0-9]?-|Local)/i is astMatchInternal eChannel= DAHDI/33-1 eDestination= PHP Notice: Undefined index: event in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 613 [2014-02-23 17:46:24] ! --- Event ----------------------------------------------------------- ! Event --> MusicOnHold
! Privilege --> call,all
! State --> Start
! Channel --> DAHDI/33-1
! UniqueID --> 1393177580.9
! Class --> default
! --------------------------------------------------------------------- [2014-02-23 17:46:24] ! --- Event ----------------------------------------------------------- ! Event --> Newchannel
! Privilege --> call,all
! Channel --> SIP/1111-00000005
! ChannelState --> 0
! ChannelStateDesc --> Down
! CallerIDNum -->
! CallerIDName -->
! AccountCode -->
! Exten -->
! Context --> from-sip
! Uniqueid --> 1393177584.10
! --------------------------------------------------------------------- ! AMI Event 'Newstate suppressed. ! AMI Event 'Newstate suppressed. [2014-02-23 17:46:31] ! --- Event ----------------------------------------------------------- ! Event --> MusicOnHold
! Privilege --> call,all
! State --> Stop
! Channel --> DAHDI/33-1
! UniqueID --> 1393177580.9
! --------------------------------------------------------------------- [2014-02-23 17:46:31] ! --- Event ----------------------------------------------------------- ! Event --> Leave
! Privilege --> call,all
! Channel --> DAHDI/33-1
! Queue --> Q110
! Count --> 0
! Position --> 1
! Uniqueid --> 1393177580.9
! --------------------------------------------------------------------- [2014-02-23 17:46:31] ! --- Event ----------------------------------------------------------- ! Event --> NewAccountCode
! Privilege --> call,all
! Channel --> SIP/1111-00000005
! Uniqueid --> 1393177584.10
! AccountCode -->
! OldAccountCode -->
! --------------------------------------------------------------------- [2014-02-23 17:46:31] ! --- Event ----------------------------------------------------------- ! Event --> Bridge
! Privilege --> call,all
! Bridgestate --> Link
! Bridgetype --> core
! Channel1 --> DAHDI/33-1
! Channel2 --> SIP/1111-00000005
! Uniqueid1 --> 1393177580.9
! Uniqueid2 --> 1393177584.10
! CallerID1 --> 9432247551
! CallerID2 -->
! --------------------------------------------------------------------- DEBUG: Entered Bridge DEBUG: bridge inbound, updating the Link state Bridge isn't internal to internal Internal Queue Event Detected Internal Queue: SELECT id FROM asterisk_log WHERE remote_channel like 'DAHDI/33-1' and direction='I' and (channel = '' OR channel is NULL) Queue-Bridge Detected changing the channel to: SIP/1111-00000005 !WARNING: wasn't able to extract the user device from channel : SIP/1111-00000005 PHP Notice: Undefined offset: 0 in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 2141 Looking for user extension number in: SIP/1111-00000005 Channel Matched SIP/### style regex. Ext is:1111 Queue UPDATE QUERY: UPDATE asterisk_log SET channel='SIP/1111-00000005', user_extension='1111', user_device='' WHERE id='133' [2014-02-23 17:46:41] ! --- Event ----------------------------------------------------------- ! Event --> Unlink
! Privilege --> call,all
! Channel1 --> DAHDI/33-1
! Channel2 --> SIP/1111-00000005
! Uniqueid1 --> 1393177580.9
! Uniqueid2 --> 1393177584.10
! CallerID1 --> 9432247551
! CallerID2 -->
! --------------------------------------------------------------------- [2014-02-23 17:46:41] ! --- Event ----------------------------------------------------------- ! Event --> Hangup
! Privilege --> call,all
! Channel --> SIP/1111-00000005
! Uniqueid --> 1393177584.10
! CallerIDNum -->
! CallerIDName -->
! ConnectedLineNum --> 9432247551
! ConnectedLineName -->
! Cause --> 16
! Cause-txt --> Normal Clearing
! --------------------------------------------------------------------- In DialEnd... 1393177584.10 PHP Notice: Undefined index: asterisk_only_log_calls_matching_user_extension in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 716

+++ findCallByAsteriskId(1393177584.10)

! Warning, results set was empty! [1393177584.10] FAILED TO FIND A CALL (note: there are two hangups per call, so this might not be an error) [2014-02-23 17:46:41] ! --- Event ----------------------------------------------------------- ! Event --> Hangup
! Privilege --> call,all
! Channel --> DAHDI/33-1
! Uniqueid --> 1393177580.9
! CallerIDNum --> 9432247551
! CallerIDName -->
! ConnectedLineNum -->
! ConnectedLineName -->
! Cause --> 0
! Cause-txt --> Unknown
! --------------------------------------------------------------------- In DialEnd... 1393177580.9 PHP Notice: Undefined index: asterisk_only_log_calls_matching_user_extension in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 716

+++ findCallByAsteriskId(1393177580.9)

! Found entry in asterisk_log recordId=3c977b5a-aef8-7ddf-584a-530a335df009 Array ( [bitter] => Array ( [id] => 133 [is_master] => 0 [call_record_id] => 3c977b5a-aef8-7ddf-584a-530a335df009 [asterisk_id] => 1393177580.9 [callstate] => Connected [uistate] => [callerID] => 9432247551 [channel] => SIP/1111-00000005 [remote_channel] => DAHDI/33-1 [timestamp_call] => 2014-02-23 17:46:24 [timestamp_link] => 2014-02-23 17:46:31 [timestamp_hangup] => [direction] => I [asterisk_dest_id] => 1393177580.9 [opencnam] => [answered] => 0 [user_extension] => 1111 [user_device] => [inbound_extension] => Q110 [bean_module] => contacts [bean_id] => c64a7978-c3ad-4335-bfc1-530a0a1605bc [bean_name] => Mr. jags con paul [bean_link] => http://localhost/SugarCE-Full-6.5.16/index.php?module=Contacts&action=DetailView&record=c64a7978-c3ad-4335-bfc1-530a0a1605bc [bean_description] => [parent_module] => accounts [parent_id] => [parent_name] => [parent_link] => [push_sent] => 0 )

[sweet] => Array
    (
        [assigned_user_name] => Jagadish Paul Administrator
        [modified_by_name] => Jagadish Paul Administrator
        [created_by_name] => Jagadish Paul Administrator
        [id] => 3c977b5a-aef8-7ddf-584a-530a335df009
        [name] => ** Automatic record **
        [date_entered] => 2014-02-23 17:46:24
        [date_modified] => 2014-02-23 17:46:37
        [modified_user_id] => 1
        [created_by] => 1
        [description] => 
        [deleted] => 0
        [assigned_user_id] => 1
        [duration_hours] => 0
        [duration_minutes] => 
        [date_start] => 
        [date_end] => 
        [parent_type] => Accounts
        [status] => In Limbo
        [direction] => Inbound
        [parent_id] => 
        [reminder_time] => -1
        [email_reminder_time] => -1
        [email_reminder_sent] => 0
        [outlook_id] => 
        [contact_name] => paul
        [repeat_type] => 
        [repeat_interval] => 1
        [repeat_dow] => 
        [repeat_until] => 
        [repeat_count] => 
        [repeat_parent_id] => 
        [recurring_source] => 
        [asterisk_caller_id_c] => 
        [asterisk_call_id_c] => 
        [asterisk_inbound_ext_c] => 
        [asterisk_user_ext_c] => 
    )

) Looking for user extension number in: SIP/1111-00000005 Channel Matched SIP/### style regex. Ext is:1111

+++ findUserByAsteriskExtension(1111)

! Assigned user id set to 1 Measured call duration is 11 seconds Bean Id already set by callListener to: c64a7978-c3ad-4335-bfc1-530a0a1605bc Establishing relation to Contacts ID: c64a7978-c3ad-4335-bfc1-530a0a1605bc, Call Record ID: 3c977b5a-aef8-7ddf-584a-530a335df009 ! No results returned ! Call start was 2014-02-23 17:46:24 Updating record in /Calls/ id=3c977b5a-aef8-7ddf-584a-530a335df009... NAME: \ Automatic record ** DESCRIPTION: Cleaning up Failed Calls part1, asterisk_id = 1393177580.9

askhogan commented 10 years ago

Try the cloud version at www.callinize.com we will give you several months free.

We are not supporting the module at this time. On Feb 23, 2014 4:46 AM, "Jagadish Paul" notifications@github.com wrote:

I am using

Asterisk-1.8.25.0, SugarCE-6.5.16, yaai 3.6.9 (callinize-community-3.6.9.zip)

When I placed incoming PSTN call directly to SIP user the POPUP displayed. [from-pstn] ;Incoming calls exten => s,1,Answer() exten => s,n,Dial(sip/1111)

But when the same call is placed on queue no POPUP displayed, while SIP user (queue member) is getting incoming call on SIP phone. Even after answer the call over sip phone no POPUP.

[from-pstn] ;Incoming calls exten => s,1,Answer() exten => s,n,Queue(Q110)

Please note that in the both cases asteriskLogger.php showing some error on terminals as follows. asteriskLogger for with out queue:

[2014-02-23 12:42:33] ! --- Event ----------------------------------------------------------- ! Event --> Newchannel

! Privilege --> call,all

! Channel --> DAHDI/33-1

! ChannelState --> 9

! ChannelStateDesc --> Pre-ring

! CallerIDNum -->

! CallerIDName -->

! AccountCode -->

! Exten -->

! Context --> from-pstn

! Uniqueid --> 1393159353.84

! --------------------------------------------------------------------- [2014-02-23 12:42:33] ! --- Event ----------------------------------------------------------- ! Event --> DAHDIChannel

! Privilege --> call,all

! Channel --> DAHDI/33-1

! Uniqueid --> 1393159353.84

! DAHDISpan --> 2

! DAHDIChannel --> 33

! --------------------------------------------------------------------- ! AMI Event 'Newstate suppressed. [2014-02-23 12:42:35] ! --- Event ----------------------------------------------------------- ! Event --> NewCallerid

! Privilege --> call,all

! Channel --> DAHDI/33-1

! CallerIDNum --> 9432247551

! CallerIDName -->

! Uniqueid --> 1393159353.84

! CID-CallingPres --> 0 (Presentation Allowed, Not Screened)

! --------------------------------------------------------------------- CallerID Changed to: 9432247551 ! AMI Event 'Newstate suppressed. [2014-02-23 12:42:36] ! --- Event ----------------------------------------------------------- ! Event --> Newchannel

! Privilege --> call,all

! Channel --> SIP/1111-0000003b

! ChannelState --> 0

! ChannelStateDesc --> Down

! CallerIDNum -->

! CallerIDName -->

! AccountCode -->

! Exten -->

! Context --> from-sip

! Uniqueid --> 1393159356.85

! --------------------------------------------------------------------- [2014-02-23 12:42:36] ! --- Event ----------------------------------------------------------- ! Event --> NewCallerid

! Privilege --> call,all

! Channel --> SIP/1111-0000003b

! CallerIDNum --> s

! CallerIDName -->

! Uniqueid --> 1393159356.85

! CID-CallingPres --> 0 (Presentation Allowed, Not Screened)

! --------------------------------------------------------------------- CallerID Changed to: s [2014-02-23 12:42:36] ! --- Event ----------------------------------------------------------- ! Event --> Dial

! Privilege --> call,all

! SubEvent --> Begin

! Channel --> DAHDI/33-1

! Destination --> SIP/1111-0000003b

! CallerIDNum --> 9432247551

! CallerIDName -->

! ConnectedLineNum -->

! ConnectedLineName -->

! UniqueID --> 1393159353.84

! DestUniqueID --> 1393159356.85

! Dialstring --> 1111

! --------------------------------------------------------------------- ! Dial Event src=DAHDI/33-1 dest=SIP/1111-0000003b PHP Notice: Undefined index: event in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 439 ! Successfully created CALL record with id=c61bfc7e-4a34-77e3-81e9-5309ec26d748 Stripping callout prefix: Stripping callin prefix: CallerID is: 9432247551 Looking for user extension number in: SIP/1111-0000003b Channel Matched SIP/### style regex. Ext is:1111 Looking for user extension number in: SIP/1111-0000003b Channel Matched SIP/### style regex. Ext is:1111 inbound_extension = 1111 Inbound state detected... /^(sip\/[1-9][0-9][0-9][0-9]?[0-9]?-|Local)/i is astMatchInternal eChannel= DAHDI/33-1 eDestination=SIP/1111-0000003b PHP Notice: Undefined index: event in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 613 ! AMI Event 'Newstate suppressed. ! AMI Event 'Newstate suppressed. [2014-02-23 12:42:47] ! --- Event ----------------------------------------------------------- ! Event --> NewAccountCode

! Privilege --> call,all

! Channel --> SIP/1111-0000003b

! Uniqueid --> 1393159356.85

! AccountCode -->

! OldAccountCode -->

! --------------------------------------------------------------------- [2014-02-23 12:42:47] ! --- Event ----------------------------------------------------------- ! Event --> Bridge

! Privilege --> call,all

! Bridgestate --> Link

! Bridgetype --> core

! Channel1 --> DAHDI/33-1

! Channel2 --> SIP/1111-0000003b

! Uniqueid1 --> 1393159353.84

! Uniqueid2 --> 1393159356.85

! CallerID1 --> 9432247551

! CallerID2 --> s

! --------------------------------------------------------------------- DEBUG: Entered Bridge DEBUG: bridge inbound, updating the Link state Bridge isn't internal to internal Internal Queue Event Detected Internal Queue: SELECT id FROM asterisk_log WHERE remote_channel like 'DAHDI/33-1' and direction='I' and (channel = '' OR channel is NULL) Queue-Bridge ERROR: MULTIPLE MATCHING LINES IN ASTERISK LOG... BRIDGE LOGIC ISN'T BULLETPROOF [2014-02-23 12:42:54] ! --- Event ----------------------------------------------------------- ! Event --> Unlink

! Privilege --> call,all

! Channel1 --> DAHDI/33-1

! Channel2 --> SIP/1111-0000003b

! Uniqueid1 --> 1393159353.84

! Uniqueid2 --> 1393159356.85

! CallerID1 --> 9432247551

! CallerID2 --> s

! --------------------------------------------------------------------- [2014-02-23 12:42:54] ! --- Event ----------------------------------------------------------- ! Event --> Hangup

! Privilege --> call,all

! Channel --> SIP/1111-0000003b

! Uniqueid --> 1393159356.85

! CallerIDNum --> s

! CallerIDName -->

! ConnectedLineNum --> 9432247551

! ConnectedLineName -->

! Cause --> 16

! Cause-txt --> Normal Clearing

! --------------------------------------------------------------------- In DialEnd... 1393159356.85 PHP Notice: Undefined index: asterisk_only_log_calls_matching_user_extension in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 716 +++ findCallByAsteriskId(1393159356.85)

! Warning, results set was empty! [2014-02-23 12:42:54] ! --- Event ----------------------------------------------------------- ! Event --> Dial

! Privilege --> call,all

! SubEvent --> End

! Channel --> DAHDI/33-1

! UniqueID --> 1393159353.84

! DialStatus --> ANSWER

! --------------------------------------------------------------------- In DialEnd... 1393159353.84 PHP Notice: Undefined index: asterisk_only_log_calls_matching_user_extension in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 716 +++ findCallByAsteriskId(1393159353.84)

! Found entry in asterisk_log recordId=c61bfc7e-4a34-77e3-81e9-5309ec26d748 Array ( [bitter] => Array ( [id] => 99 [is_master] => 0 [call_record_id] => c61bfc7e-4a34-77e3-81e9-5309ec26d748 [asterisk_id] => 1393159353.84 [callstate] => Connected [uistate] => [callerID] => 9432247551 [channel] => SIP/1111-0000003b [remote_channel] => DAHDI/33-1 [timestamp_call] => 2014-02-23 12:42:37 [timestamp_link] => 2014-02-23 12:42:47 [timestamp_hangup] => [direction] => I [asterisk_dest_id] => 1393159356.85 [opencnam] => [answered] => 0 [user_extension] => 1111 [user_device] => 1111 [inbound_extension] => 1111 [bean_module] => [bean_id] => [bean_name] => [bean_link] => [bean_description] => [parent_module] => [parent_id] => [parent_name] => [parent_link] => [push_sent] => 0 )

[sweet] => Array ( [assigned_user_name] => Jagadish Paul Administrator [modified_by_name] => Jagadish Paul Administrator [created_by_name] => Jagadish Paul Administrator [id] => c61bfc7e-4a34-77e3-81e9-5309ec26d748 [name] => \ Automatic record ** [date_entered] => 2014-02-23 12:42:36 [date_modified] => 2014-02-23 12:42:37 [modified_user_id] => 1 [created_by] => 1 [description] => [deleted] => 0 [assigned_user_id] => 1 [duration_hours] => 0 [duration_minutes] => [date_start] => [date_end] => [parent_type] => [status] => In Limbo [direction] => Inbound [parent_id] => [reminder_time] => -1 [email_reminder_time] => -1 [email_reminder_sent] => 0 [outlook_id] => [contact_name] => [repeat_type] => [repeat_interval] => 1 [repeat_dow] => [repeat_until] => [repeat_count] => [repeat_parent_id] => [recurring_source] => [asterisk_caller_id_c] => [asterisk_call_id_c] => [asterisk_inbound_ext_c] => [asterisk_user_ext_c] => )

) Looking for user extension number in: SIP/1111-0000003b Channel Matched SIP/### style regex. Ext is:1111 +++ findUserByAsteriskExtension(1111)

! Assigned user id set to 1 Measured call duration is 7 seconds ! Call is not related to any record (no matches) ! Invalid Arguments passed to setRelationshipBetweenCallAndBean callRecordId=c61bfc7e-4a34-77e3-81e9-5309ec26d748, beanId=, beanType= ! Call start was 2014-02-23 12:42:37 Updating record in /Calls/ id=c61bfc7e-4a34-77e3-81e9-5309ec26d748... NAME: \ Automatic record ** DESCRIPTION: Cleaning up Failed Calls part1, asterisk_id = 1393159353.84 [2014-02-23 12:42:56] ! --- Event ----------------------------------------------------------- ! Event --> Hangup

! Privilege --> call,all

! Channel --> DAHDI/33-1

! Uniqueid --> 1393159353.84

! CallerIDNum --> 9432247551

! CallerIDName -->

! ConnectedLineNum -->

! ConnectedLineName -->

! Cause --> 16

! Cause-txt --> Normal Clearing

! --------------------------------------------------------------------- In DialEnd... 1393159353.84 PHP Notice: Undefined index: asterisk_only_log_calls_matching_user_extension in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 716 +++ findCallByAsteriskId(1393159353.84)

! Found entry in asterisk_log recordId=c61bfc7e-4a34-77e3-81e9-5309ec26d748 Array ( [bitter] => Array ( [id] => 99 [is_master] => 0 [call_record_id] => c61bfc7e-4a34-77e3-81e9-5309ec26d748 [asterisk_id] => 1393159353.84 [callstate] => Hangup [uistate] => [callerID] => 9432247551 [channel] => SIP/1111-0000003b [remote_channel] => DAHDI/33-1 [timestamp_call] => 2014-02-23 12:42:37 [timestamp_link] => 2014-02-23 12:42:47 [timestamp_hangup] => 2014-02-23 12:42:54 [direction] => I [asterisk_dest_id] => 1393159356.85 [opencnam] => [answered] => 1 [user_extension] => 1111 [user_device] => 1111 [inbound_extension] => 1111 [bean_module] => [bean_id] => [bean_name] => [bean_link] => [bean_description] => [parent_module] => [parent_id] => [parent_name] => [parent_link] => [push_sent] => 0 )

[sweet] => Array ( [assigned_user_name] => Jagadish Paul Administrator [modified_by_name] => Jagadish Paul Administrator [created_by_name] => Jagadish Paul Administrator [id] => c61bfc7e-4a34-77e3-81e9-5309ec26d748 [name] => Incoming call [date_entered] => 2014-02-23 12:42:36 [date_modified] => 2014-02-23 12:42:55 [modified_user_id] => 1 [created_by] => 1 [description] => [deleted] => 0 [assigned_user_id] => 1 [duration_hours] => 0 [duration_minutes] => 0 [date_start] => 2014-02-23 12:42:37 [date_end] => 2014-02-23 12:42:37 [parent_type] => [status] => Held [direction] => Inbound [parent_id] => [reminder_time] => -1 [email_reminder_time] => -1 [email_reminder_sent] => 0 [outlook_id] => [contact_name] => [repeat_type] => [repeat_interval] => 1 [repeat_dow] => [repeat_until] => [repeat_count] => [repeat_parent_id] => [recurring_source] => [asterisk_caller_id_c] => 9432247551 [asterisk_call_id_c] => 1393159353.84 [asterisk_inbound_ext_c] => 1111 [asterisk_user_ext_c] => 1111 )

) Looking for user extension number in: SIP/1111-0000003b Channel Matched SIP/### style regex. Ext is:1111 +++ findUserByAsteriskExtension(1111)

! Assigned user id set to 1 Measured call duration is 9 seconds ! Call is not related to any record (no matches) ! Invalid Arguments passed to setRelationshipBetweenCallAndBean callRecordId=c61bfc7e-4a34-77e3-81e9-5309ec26d748, beanId=, beanType= ! Call start was 2014-02-23 12:42:37 Updating record in /Calls/ id=c61bfc7e-4a34-77e3-81e9-5309ec26d748... NAME: Incoming call DESCRIPTION: Cleaning up Failed Calls part1, asterisk_id = 1393159353.84 asteriskLogger for with queue:

AMI Login was a success! Waiting for call events... [2014-02-23 12:40:03] ! --- Event ----------------------------------------------------------- ! Event --> Newchannel

! Privilege --> call,all

! Channel --> DAHDI/33-1

! ChannelState --> 9

! ChannelStateDesc --> Pre-ring

! CallerIDNum -->

! CallerIDName -->

! AccountCode -->

! Exten -->

! Context --> from-pstn

! Uniqueid --> 1393159203.81

! --------------------------------------------------------------------- [2014-02-23 12:40:03] ! --- Event ----------------------------------------------------------- ! Event --> DAHDIChannel

! Privilege --> call,all

! Channel --> DAHDI/33-1

! Uniqueid --> 1393159203.81

! DAHDISpan --> 2

! DAHDIChannel --> 33

! --------------------------------------------------------------------- ! AMI Event 'Newstate suppressed. [2014-02-23 12:40:05] ! --- Event ----------------------------------------------------------- ! Event --> NewCallerid

! Privilege --> call,all

! Channel --> DAHDI/33-1

! CallerIDNum --> 9432247551

! CallerIDName -->

! Uniqueid --> 1393159203.81

! CID-CallingPres --> 0 (Presentation Allowed, Not Screened)

! --------------------------------------------------------------------- CallerID Changed to: 9432247551 ! AMI Event 'Newstate suppressed. [2014-02-23 12:40:06] ! --- Event ----------------------------------------------------------- ! Event --> Join

! Privilege --> call,all

! Channel --> DAHDI/33-1

! CallerIDNum --> 9432247551

! CallerIDName --> unknown

! ConnectedLineNum --> unknown

! ConnectedLineName --> unknown

! Queue --> Q110

! Position --> 1

! Count --> 1

! Uniqueid --> 1393159203.81

! --------------------------------------------------------------------- PHP Notice: Undefined index: Destination in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 437 ! Dial Event src=DAHDI/33-1 dest= PHP Notice: Undefined index: event in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 439 PHP Notice: Undefined index: Destination in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 448 DestUniqueID is empty, this must be a queue call... or logic error ! Successfully created CALL record with id=173b0967-3edc-9858-509c-5309ec80f1cc Stripping callout prefix: Stripping callin prefix: CallerID is: 9432247551 Looking for user extension number in: inbound_extension = Q110 Inbound state detected... /^(sip\/[1-9][0-9][0-9][0-9]?[0-9]?-|Local)/i is astMatchInternal eChannel= DAHDI/33-1 eDestination= PHP Notice: Undefined index: event in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 613 [2014-02-23 12:40:07] ! --- Event ----------------------------------------------------------- ! Event --> MusicOnHold

! Privilege --> call,all

! State --> Start

! Channel --> DAHDI/33-1

! UniqueID --> 1393159203.81

! Class --> default

! --------------------------------------------------------------------- [2014-02-23 12:40:07] ! --- Event ----------------------------------------------------------- ! Event --> Newchannel

! Privilege --> call,all

! Channel --> SIP/1111-00000039

! ChannelState --> 0

! ChannelStateDesc --> Down

! CallerIDNum -->

! CallerIDName -->

! AccountCode -->

! Exten -->

! Context --> from-sip

! Uniqueid --> 1393159206.82

! --------------------------------------------------------------------- ! AMI Event 'Newstate suppressed. [2014-02-23 12:40:21] ! --- Event ----------------------------------------------------------- ! Event --> Hangup

! Privilege --> call,all

! Channel --> SIP/1111-00000039

! Uniqueid --> 1393159206.82

! CallerIDNum -->

! CallerIDName -->

! ConnectedLineNum --> 9432247551

! ConnectedLineName -->

! Cause --> 16

! Cause-txt --> Normal Clearing

! --------------------------------------------------------------------- In DialEnd... 1393159206.82 PHP Notice: Undefined index: asterisk_only_log_calls_matching_user_extension in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 716 +++ findCallByAsteriskId(1393159206.82)

! Warning, results set was empty! [1393159206.82] FAILED TO FIND A CALL (note: there are two hangups per call, so this might not be an error) [2014-02-23 12:40:26] ! --- Event ----------------------------------------------------------- ! Event --> MusicOnHold

! Privilege --> call,all

! State --> Stop

! Channel --> DAHDI/33-1

! UniqueID --> 1393159203.81

! --------------------------------------------------------------------- [2014-02-23 12:40:33] ! --- Event ----------------------------------------------------------- ! Event --> MusicOnHold

! Privilege --> call,all

! State --> Start

! Channel --> DAHDI/33-1

! UniqueID --> 1393159203.81

! Class --> default

! --------------------------------------------------------------------- [2014-02-23 12:40:33] ! --- Event ----------------------------------------------------------- ! Event --> Newchannel

! Privilege --> call,all

! Channel --> SIP/1111-0000003a

! ChannelState --> 0

! ChannelStateDesc --> Down

! CallerIDNum -->

! CallerIDName -->

! AccountCode -->

! Exten -->

! Context --> from-sip

! Uniqueid --> 1393159233.83

! --------------------------------------------------------------------- ! AMI Event 'Newstate suppressed. ! AMI Event 'Newstate suppressed. [2014-02-23 12:40:37] ! --- Event ----------------------------------------------------------- ! Event --> MusicOnHold

! Privilege --> call,all

! State --> Stop

! Channel --> DAHDI/33-1

! UniqueID --> 1393159203.81

! --------------------------------------------------------------------- [2014-02-23 12:40:37] ! --- Event ----------------------------------------------------------- ! Event --> Leave

! Privilege --> call,all

! Channel --> DAHDI/33-1

! Queue --> Q110

! Count --> 0

! Position --> 1

! Uniqueid --> 1393159203.81

! --------------------------------------------------------------------- [2014-02-23 12:40:37] ! --- Event ----------------------------------------------------------- ! Event --> NewAccountCode

! Privilege --> call,all

! Channel --> SIP/1111-0000003a

! Uniqueid --> 1393159233.83

! AccountCode -->

! OldAccountCode -->

! --------------------------------------------------------------------- [2014-02-23 12:40:37] ! --- Event ----------------------------------------------------------- ! Event --> Bridge

! Privilege --> call,all

! Bridgestate --> Link

! Bridgetype --> core

! Channel1 --> DAHDI/33-1

! Channel2 --> SIP/1111-0000003a

! Uniqueid1 --> 1393159203.81

! Uniqueid2 --> 1393159233.83

! CallerID1 --> 9432247551

! CallerID2 -->

! --------------------------------------------------------------------- DEBUG: Entered Bridge DEBUG: bridge inbound, updating the Link state Bridge isn't internal to internal Internal Queue Event Detected Internal Queue: SELECT id FROM asterisk_log WHERE remote_channel like 'DAHDI/33-1' and direction='I' and (channel = '' OR channel is NULL) Queue-Bridge ERROR: MULTIPLE MATCHING LINES IN ASTERISK LOG... BRIDGE LOGIC ISN'T BULLETPROOF [2014-02-23 12:40:44] ! --- Event ----------------------------------------------------------- ! Event --> Unlink

! Privilege --> call,all

! Channel1 --> DAHDI/33-1

! Channel2 --> SIP/1111-0000003a

! Uniqueid1 --> 1393159203.81

! Uniqueid2 --> 1393159233.83

! CallerID1 --> 9432247551

! CallerID2 -->

! --------------------------------------------------------------------- [2014-02-23 12:40:44] ! --- Event ----------------------------------------------------------- ! Event --> Hangup

! Privilege --> call,all

! Channel --> SIP/1111-0000003a

! Uniqueid --> 1393159233.83

! CallerIDNum -->

! CallerIDName -->

! ConnectedLineNum --> 9432247551

! ConnectedLineName -->

! Cause --> 16

! Cause-txt --> Normal Clearing

! --------------------------------------------------------------------- In DialEnd... 1393159233.83 PHP Notice: Undefined index: asterisk_only_log_calls_matching_user_extension in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 716 +++ findCallByAsteriskId(1393159233.83)

! Warning, results set was empty! [1393159233.83] FAILED TO FIND A CALL (note: there are two hangups per call, so this might not be an error) [2014-02-23 12:40:44] ! --- Event ----------------------------------------------------------- ! Event --> Hangup

! Privilege --> call,all

! Channel --> DAHDI/33-1

! Uniqueid --> 1393159203.81

! CallerIDNum --> 9432247551

! CallerIDName -->

! ConnectedLineNum -->

! ConnectedLineName -->

! Cause --> 0

! Cause-txt --> Unknown

! --------------------------------------------------------------------- In DialEnd... 1393159203.81 PHP Notice: Undefined index: asterisk_only_log_calls_matching_user_extension in /var/www/SugarCE-Full-6.5.16/custom/modules/Asterisk/asteriskLogger.php on line 716 +++ findCallByAsteriskId(1393159203.81)

! Found entry in asterisk_log recordId=173b0967-3edc-9858-509c-5309ec80f1cc Array ( [bitter] => Array ( [id] => 98 [is_master] => 0 [call_record_id] => 173b0967-3edc-9858-509c-5309ec80f1cc [asterisk_id] => 1393159203.81 [callstate] => Connected [uistate] => [callerID] => 9432247551 [channel] => [remote_channel] => DAHDI/33-1 [timestamp_call] => 2014-02-23 12:40:07 [timestamp_link] => 2014-02-23 12:40:37 [timestamp_hangup] => [direction] => I [asterisk_dest_id] => 1393159203.81 [opencnam] => [answered] => 0 [user_extension] => Q110 [user_device] => Q110 [inbound_extension] => Q110 [bean_module] => [bean_id] => [bean_name] => [bean_link] => [bean_description] => [parent_module] => [parent_id] => [parent_name] => [parent_link] => [push_sent] => 0 )

[sweet] => Array ( [assigned_user_name] => Jagadish Paul Administrator [modified_by_name] => Jagadish Paul Administrator [created_by_name] => Jagadish Paul Administrator [id] => 173b0967-3edc-9858-509c-5309ec80f1cc [name] => \ Automatic record ** [date_entered] => 2014-02-23 12:40:06 [date_modified] => 2014-02-23 12:40:07 [modified_user_id] => 1 [created_by] => 1 [description] => [deleted] => 0 [assigned_user_id] => 1 [duration_hours] => 0 [duration_minutes] => [date_start] => [date_end] => [parent_type] => [status] => In Limbo [direction] => Inbound [parent_id] => [reminder_time] => -1 [email_reminder_time] => -1 [email_reminder_sent] => 0 [outlook_id] => [contact_name] => [repeat_type] => [repeat_interval] => 1 [repeat_dow] => [repeat_until] => [repeat_count] => [repeat_parent_id] => [recurring_source] => [asterisk_caller_id_c] => [asterisk_call_id_c] => [asterisk_inbound_ext_c] => [asterisk_user_ext_c] => )

) Looking for user extension number in: +++ findUserByAsteriskExtension()

! Assigned user id set to seed_chris_id Measured call duration is 7 seconds ! Call is not related to any record (no matches) ! Invalid Arguments passed to setRelationshipBetweenCallAndBean callRecordId=173b0967-3edc-9858-509c-5309ec80f1cc, beanId=, beanType= ! Call start was 2014-02-23 12:40:07 Updating record in /Calls/ id=173b0967-3edc-9858-509c-5309ec80f1cc... NAME: \ Automatic record ** DESCRIPTION: Cleaning up Failed Calls part1, asterisk_id = 1393159203.81

Waiting for your help.

Thanks & regards Jags

Reply to this email directly or view it on GitHubhttps://github.com/blak3r/yaai/issues/175 .

jagspaul commented 10 years ago

My asterisk is running behind a NAT (router). Router having global IP but asterisk box having private IP. I am very much confuse how to use the cloud version.