asteriskLogger.php not working properly?

[ninjanody]

Hello,

I have SuiteCRM (Sugar 6.5.2) installed on CentOS 7 and separate server for PBX with elastix distro (asterisk 1.8.20.0) , i have followed all the steps and i have no records on calls module or incoming popups. Click to dial works but display wrong CID.

Asterisk SugarCRM Connector: 2.3.0.9 for v6.x & checked with Asterisk SugarCRM Connector: 3.3.6 (creates problem with the dropdown menus)

Here is the log from calling to my DID which is applied to my internal SIP/161 from my mobile 690XXXXXXX

Logging to: asteriskLog.txt

(Config processed)

Selecting DB Name: suitecrm ! Trying SOAP login endpoint=[http://192.168.0.110/suitecrm/soap.php] user=[soap] password=[ soap-pass ] ! Successful SOAP login id=-1 user=soap GUID=-1

Successfully opened socket connection to 192.168.0.4:5038

! AMI Login action returned with rc=Asterisk Call Manager/1.1

[2015-11-03 11:48:02] ! --- Event ----------------------------------------------------------- ! Event -->
! --------------------------------------------------------------------- [2015-11-03 11:48:02] ! --- Event ----------------------------------------------------------- ! Event --> DAHDIChannel
! Privilege --> call,all
! Channel --> DAHDI/i2/690XXXXXXX-770d
! Uniqueid --> 1446544067.676683
! DAHDISpan --> 2
! DAHDIChannel --> 8
! --------------------------------------------------------------------- [2015-11-03 11:48:02] ! --- Event ----------------------------------------------------------- ! Event --> NewCallerid
! Privilege --> call,all
! Channel --> DAHDI/i2/690XXXXXXX-770d
! CallerIDNum --> 690XXXXXXX
! CallerIDName --> 690XXXXXXX
! Uniqueid --> 1446544067.676683
! CID-CallingPres --> 0 (Presentation Allowed, Not Screened)
! --------------------------------------------------------------------- [2015-11-03 11:48:02] ! --- Event ----------------------------------------------------------- ! Event --> DAHDIChannel
! Privilege --> call,all
! Channel --> DAHDI/i2/690XXXXXXX-770d
! Uniqueid --> 1446544067.676683
! DAHDISpan --> 2
! DAHDIChannel --> 8
! --------------------------------------------------------------------- [2015-11-03 11:48:02] ! --- Event ----------------------------------------------------------- ! Event --> NewCallerid
! Privilege --> call,all
! Channel --> DAHDI/i2/690XXXXXXX-770d
! CallerIDNum --> 690XXXXXXX
! CallerIDName --> 690XXXXXXX
! Uniqueid --> 1446544067.676683
! CID-CallingPres --> 0 (Presentation Allowed, Not Screened)
! --------------------------------------------------------------------- [2015-11-03 11:48:02] ! --- Event ----------------------------------------------------------- ! Event --> NewCallerid
! Privilege --> call,all
! Channel --> DAHDI/i2/690XXXXXXX-770d
! CallerIDNum --> 690XXXXXXX
! CallerIDName --> 690XXXXXXX
! Uniqueid --> 1446544067.676683
! CID-CallingPres --> 0 (Presentation Allowed, Not Screened)
! --------------------------------------------------------------------- [2015-11-03 11:48:02] ! --- Event ----------------------------------------------------------- ! Event --> NewCallerid
! Privilege --> call,all
! Channel --> DAHDI/i2/690XXXXXXX-770d
! CallerIDNum --> 690XXXXXXX
! CallerIDName --> 690XXXXXXX
! Uniqueid --> 1446544067.676683
! CID-CallingPres --> 0 (Presentation Allowed, Not Screened)
! --------------------------------------------------------------------- [2015-11-03 11:48:03] ! --- Event ----------------------------------------------------------- ! Event --> Dial
! Privilege --> call,all
! SubEvent --> Begin
! Channel --> DAHDI/i2/690XXXXXXX-770d
! Destination --> SIP/161-00064630
! CallerIDNum --> 690XXXXXXX
! CallerIDName --> 690XXXXXXX
! ConnectedLineNum -->
! ConnectedLineName -->
! UniqueID --> 1446544067.676683
! DestUniqueID --> 1446544067.676684
! Dialstring --> 161
! --------------------------------------------------------------------- ! Dial Event src=DAHDI/i2/690XXXXXXX-770d dest=SIP/161-00064630 [2015-11-03 11:48:03] ! --- Event ----------------------------------------------------------- ! Event --> Dial
! Privilege --> call,all
! SubEvent --> Begin
! Channel --> DAHDI/i2/690XXXXXXX-770d
! Destination --> SIP/161-00064630
! CallerIDNum --> 690XXXXXXX
! CallerIDName --> 690XXXXXXX
! ConnectedLineNum -->
! ConnectedLineName -->
! UniqueID --> 1446544067.676683
! DestUniqueID --> 1446544067.676684
! Dialstring --> 161
! --------------------------------------------------------------------- ! Dial Event src=DAHDI/i2/690XXXXXXX-770d dest=SIP/161-00064630 ! Successfully created CALL record with id=-1

• Stripping callin prefix:
• CallerID is: (preg_match(/^(SIP/[1-9][0-9][0-9]?-| Local)/i, ) && !preg_match(/^(SIP/[1-9][0-9][0-9]?-| Local)/i, SIP/161-00064630))INSERT INTO asterisk_log (asterisk_id, call_record_id, channel, remote_channel, callstate, direction, CallerID, timestampCall, asterisk_dest_id) VALUES('','-1','SIP/161-00064630','DAHDI/i2/690XXXXXXX-770d','Dial','I','',NOW(),'1446544067.676684') Inbound state detected... /^(SIP/[1-9][0-9][0-9]?-| Local)/i is astMatchInternal eChannel= DAHDI/i2/690XXXXXXX-770d eDestination=SIP/161-00064630 ! Successfully created CALL record with id=-1
• Stripping callin prefix:
• CallerID is: (preg_match(/^(SIP/[1-9][0-9][0-9]?-| Local)/i, ) && !preg_match(/^(SIP/[1-9][0-9][0-9]?-| Local)/i, SIP/161-00064630))INSERT INTO asterisk_log (asterisk_id, call_record_id, channel, remote_channel, callstate, direction, CallerID, timestampCall, asterisk_dest_id) VALUES('','-1','SIP/161-00064630','DAHDI/i2/690XXXXXXX-770d','Dial','I','',NOW(),'1446544067.676684') Inbound state detected... /^(SIP/[1-9][0-9][0-9]?-| Local)/i is astMatchInternal eChannel= DAHDI/i2/690XXXXXXX-770d eDestination=SIP/161-00064630 [2015-11-03 11:48:06] ! --- Event ----------------------------------------------------------- ! Event --> NewAccountCode
  ! Privilege --> call,all
  ! Channel --> SIP/161-00064630
  ! Uniqueid --> 1446544067.676684
  ! AccountCode -->
  ! OldAccountCode -->
  ! --------------------------------------------------------------------- [2015-11-03 11:48:06] ! --- Event ----------------------------------------------------------- ! Event --> Bridge
  ! Privilege --> call,all
  ! Bridgestate --> Link
  ! Bridgetype --> core
  ! Channel1 --> DAHDI/i2/690XXXXXXX-770d
  ! Channel2 --> SIP/161-00064630
  ! Uniqueid1 --> 1446544067.676683
  ! Uniqueid2 --> 1446544067.676684
  ! CallerID1 --> 690XXXXXXX
  ! CallerID2 --> 161
  ! --------------------------------------------------------------------- [2015-11-03 11:48:06] ! --- Event ----------------------------------------------------------- ! Event --> NewAccountCode
  ! Privilege --> call,all
  ! Channel --> SIP/161-00064630
  ! Uniqueid --> 1446544067.676684
  ! AccountCode -->
  ! OldAccountCode -->
  ! --------------------------------------------------------------------- [2015-11-03 11:48:06] ! --- Event ----------------------------------------------------------- ! Event --> Bridge
  ! Privilege --> call,all
  ! Bridgestate --> Link
  ! Bridgetype --> core
  ! Channel1 --> DAHDI/i2/690XXXXXXX-770d
  ! Channel2 --> SIP/161-00064630
  ! Uniqueid1 --> 1446544067.676683
  ! Uniqueid2 --> 1446544067.676684
  ! CallerID1 --> 690XXXXXXX
  ! CallerID2 --> 161
  ! --------------------------------------------------------------------- [2015-11-03 11:48:16] ! --- Event ----------------------------------------------------------- ! Event --> Unlink
  ! Privilege --> call,all
  ! Channel1 --> DAHDI/i2/690XXXXXXX-770d
  ! Channel2 --> SIP/161-00064630
  ! Uniqueid1 --> 1446544067.676683
  ! Uniqueid2 --> 1446544067.676684
  ! CallerID1 --> 690XXXXXXX
  ! CallerID2 --> 161
  ! --------------------------------------------------------------------- [2015-11-03 11:48:16] ! --- Event ----------------------------------------------------------- ! Event --> Unlink
  ! Privilege --> call,all
  ! Channel1 --> DAHDI/i2/690XXXXXXX-770d
  ! Channel2 --> SIP/161-00064630
  ! Uniqueid1 --> 1446544067.676683
  ! Uniqueid2 --> 1446544067.676684
  ! CallerID1 --> 690XXXXXXX
  ! CallerID2 --> 161
  ! --------------------------------------------------------------------- [2015-11-03 11:48:16] ! --- Event ----------------------------------------------------------- ! Event --> Hangup
  ! Privilege --> call,all
  ! Channel --> SIP/161-00064630
  ! Uniqueid --> 1446544067.676684
  ! CallerIDNum --> 161
  ! CallerIDName --> IT Department
  ! ConnectedLineNum --> 690XXXXXXX
  ! ConnectedLineName --> 690XXXXXXX
  ! Cause --> 16
  ! Cause-txt --> Normal Clearing
  ! ---------------------------------------------------------------------

  +++ findCallByAsteriskId(1446544067.676684)

  ! Warning, results set was empty! [1446544067.676684] FAILED TO FIND A CALL (note: there are two hangups per call, so this might not be an error) [2015-11-03 11:48:16] ! --- Event ----------------------------------------------------------- ! Event --> Hangup
  ! Privilege --> call,all
  ! Channel --> SIP/161-00064630
  ! Uniqueid --> 1446544067.676684
  ! CallerIDNum --> 161
  ! CallerIDName --> IT Department
  ! ConnectedLineNum --> 690XXXXXXX
  ! ConnectedLineName --> 690XXXXXXX
  ! Cause --> 16
  ! Cause-txt --> Normal Clearing
  ! --------------------------------------------------------------------- [2015-11-03 11:48:16] ! --- Event ----------------------------------------------------------- ! Event --> Dial
  ! Privilege --> call,all
  ! SubEvent --> End
  ! Channel --> DAHDI/i2/690XXXXXXX-770d
  ! UniqueID --> 1446544067.676683
  ! DialStatus --> ANSWER
  ! ---------------------------------------------------------------------

  +++ findCallByAsteriskId(1446544067.676684)

  ! Warning, results set was empty! [1446544067.676684] FAILED TO FIND A CALL (note: there are two hangups per call, so this might not be an error) [2015-11-03 11:48:16] ! --- Event ----------------------------------------------------------- ! Event --> Hangup
  ! Privilege --> call,all
  ! Channel --> DAHDI/i2/690XXXXXXX-770d
  ! Uniqueid --> 1446544067.676683
  ! CallerIDNum --> 690XXXXXXX
  ! CallerIDName --> 690XXXXXXX
  ! ConnectedLineNum --> 161
  ! ConnectedLineName --> IT Department
  ! Cause --> 16
  ! Cause-txt --> Normal Clearing
  ! ---------------------------------------------------------------------

  +++ findCallByAsteriskId(1446544067.676683)

  ! Warning, results set was empty! [1446544067.676683] FAILED TO FIND A CALL (note: there are two hangups per call, so this might not be an error) [2015-11-03 11:48:16] ! --- Event ----------------------------------------------------------- ! Event --> Dial
  ! Privilege --> call,all
  ! SubEvent --> End
  ! Channel --> DAHDI/i2/690XXXXXXX-770d
  ! UniqueID --> 1446544067.676683
  ! DialStatus --> ANSWER
  ! --------------------------------------------------------------------- [2015-11-03 11:48:16] ! --- Event ----------------------------------------------------------- ! Event --> Hangup
  ! Privilege --> call,all
  ! Channel --> DAHDI/i2/690XXXXXXX-770d
  ! Uniqueid --> 1446544067.676683
  ! CallerIDNum --> 690XXXXXXX
  ! CallerIDName --> 690XXXXXXX
  ! ConnectedLineNum --> 161
  ! ConnectedLineName --> IT Department
  ! Cause --> 16
  ! Cause-txt --> Normal Clearing
  ! ---------------------------------------------------------------------

  +++ findCallByAsteriskId(1446544067.676683)

  ! Warning, results set was empty! [1446544067.676683] FAILED TO FIND A CALL (note: there are two hangups per call, so this might not be an error)

[ninjanody]

This is my settings at Asterisk Configuration

[ninjanody]

Anyone with same problem that solve it?