AsteriskCRM
Сломал голову над этой проблемой.
На сервере стоит Trixbox (System Status Version: 2.6.2.4), Asterisk 1.6.0.10. Есть готовые решения для колцентров - asterCC-BOX, но так как система уже работает, то установил astercc-0.14-beta, настраивал по http://astercrm.blog.com/tag/astercrm/.
Всё установилось и работает, но есть один баг. Не определяется номер входящего звонка (Dialing to 143), соответственно у оператора всплывает окно добавления записи под номером самого агента.
Для сравнения установил на виртуальной машине asterCC-BOX, настройки аналогичные и там такой ошибки нет (Incoming call from 158 channel: SIP/158), новая запись 158.
Сравнил логи tail -f /tmp/astercrmDebug.log (звонок с SIP/158 в обоих случаях)
На trixbox
2010-Aug-10 13:15:16 192.168.0.183 - SELECT * From queue_agent WHERE agent LIKE 'local/143@%'
2010-Aug-10 13:15:16 192.168.0.183 - SELECT id FROM dialedlist WHERE dialednumber = 143 AND dialedtime > (now()-INTERVAL 600 SECOND) ORDER BY dialedtime DESC LIMIT 1
2010-Aug-10 13:15:16 192.168.0.183 - SELECT id,customerid FROM contact WHERE phone LIKE '%143' OR phone = '143' OR phone1 LIKE '%143' OR phone1 = '143' OR phone2 LIKE '%143' OR phone2 = '143' OR mobile LIKE '%143' OR mobile = '143' AND groupid=1 LIMIT 0,1
2010-Aug-10 13:15:16 192.168.0.183 - SELECT id FROM customer WHERE phone LIKE '%143' OR mobile LIKE '%143' OR phone = '143' OR mobile = '143' AND groupid = 1
2010-Aug-10 13:15:16 192.168.0.183 - SELECT * FROM contact WHERE phone LIKE '%14%' OR phone1 LIKE '%14%' OR phone2 LIKE '%14%' AND groupid=1
2010-Aug-10 13:15:16 192.168.0.183 - SELECT * FROM customer WHERE phone LIKE '%14%' AND groupid = 1
2010-Aug-10 13:15:18 192.168.0.183 - SELECT * From queue_agent WHERE agent = 'Agent/Agent/143'
На виртуальной машине с astercc-BOX
2010-Aug-10 13:21:05 192.168.20.1 - SELECT * From queue_agent WHERE agent = 'Agent/Agent/157' OR agent LIKE 'Local/157@%'
2010-Aug-10 13:21:05 192.168.20.1 - SELECT id FROM dialedlist WHERE dialednumber = 158 AND dialedtime > (now()-INTERVAL 600 SECOND) ORDER BY dialedtime DESC LIMIT 1
2010-Aug-10 13:21:05 192.168.20.1 - SELECT * FROM trunkinfo WHERE didnumber = '143'
2010-Aug-10 13:21:05 192.168.20.1 - SELECT * FROM trunkinfo WHERE trunkchannel = 'SIP/158'
2010-Aug-10 13:21:05 192.168.20.1 - SELECT id,customerid FROM contact WHERE phone LIKE '%158' OR phone1 LIKE '%158' OR phone2 LIKE '%158' OR mobile LIKE '%158' AND groupid=0 LIMIT 0,1
2010-Aug-10 13:21:05 192.168.20.1 - SELECT id FROM customer WHERE phone LIKE '%158' OR mobile LIKE '%158' AND groupid = 0
2010-Aug-10 13:21:05 192.168.20.1 - SELECT * FROM contact WHERE phone LIKE '%15%' OR phone1 LIKE '%15%' OR phone2 LIKE '%15%' AND groupid=0
2010-Aug-10 13:21:05 192.168.20.1 - SELECT * FROM customer WHERE phone LIKE '%15%' AND groupid = 0
2010-Aug-10 13:21:08 192.168.20.1 - SELECT * From queue_agent WHERE agent = 'Agent/Agent/157' OR agent LIKE 'Local/157@%'
Как видим отличия в 2-х строках
2010-Aug-10 13:21:05 192.168.20.1 - SELECT * FROM trunkinfo WHERE didnumber = '143'
2010-Aug-10 13:21:05 192.168.20.1 - SELECT * FROM trunkinfo WHERE trunkchannel = 'SIP/158'
и dialednumber в первом случае не правильно определён.
лог от * в комлектации trixbox
Reliably Transmitting (NAT) to 192.168.0.143:5060:
INVITE sip:143@192.168.0.143:5060 SIP/2.0
Via: SIP/2.0/UDP 192.168.0.140:5060;branch=z9hG4bK37f9e747;rport
Max-Forwards: 70
From: "LednevAN" <sip:158@192.168.0.140>;tag=as35c50f45
To: <sip:143@192.168.0.143:5060>
Contact: <sip:158@192.168.0.140>
Call-ID: 2052c00d2508b13b0c35dfe9487fefb0@192.168.0.140
CSeq: 102 INVITE
User-Agent: Asterisk PBX 1.6.0.10-FONCORE-r40
Date: Thu, 12 Aug 2010 07:54:14 GMT
Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, SUBSCRIBE, NOTIFY
Supported: replaces, timer
Content-Type: application/sdp
Content-Length: 401
v=0
o=root 1040503296 1040503296 IN IP4 192.168.0.140
s=Asterisk PBX 1.6.0.10-FONCORE-r40
c=IN IP4 192.168.0.140
b=CT:384
t=0 0
m=audio 14886 RTP/AVP 0 8 101
a=rtpmap:0 PCMU/8000
a=rtpmap:8 PCMA/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-16
a=silenceSupp:off - - - -
a=ptime:20
a=sendrecv
m=video 19832 RTP/AVP 34 99
a=rtpmap:34 H263/90000
a=rtpmap:99 H264/90000
a=sendrecv
---
-- Called 143
trixbox1*CLI>
<--- Transmitting (NAT) to 192.168.0.183:5060 --->
SIP/2.0 180 Ringing
Via: SIP/2.0/UDP 192.168.0.183:5060;branch=z9hG4bK-d8754z-07f7f2b581c42f37-1---d8754z-;received=192.168.0.183
From: <sip:158@192.168.0.140;transport=UDP>;tag=b7776f62
To: <sip:143@192.168.0.140;transport=UDP>;tag=as3fcc75e6
Call-ID: NmFiZWNmMGUwNWRjMTcwYmM0ZGI3Y2E1YWQ3MGRhMDY.
CSeq: 2 INVITE
User-Agent: Asterisk PBX 1.6.0.10-FONCORE-r40
Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, SUBSCRIBE, NOTIFY
Supported: replaces, timer
Contact: <sip:143@192.168.0.140>
Content-Length: 0
Товарищи специалисты окажите помощь начинающему. Заранее спасибо.
c
|
