problem about INBOUND

[jslyg]

I follw your "create an inbound-group,point an external number at it and take calls" step,try it,the first time,i can dial in,the asterisk mesage is below"
--------------
Executing Ringing("SIP/1000-6d9f", "") in new stack
-- Executing Wait("SIP/1000-6d9f", "1") in new stack
-- Executing Answer("SIP/1000-6d9f", "") in new stack
-- Executing AGI("SIP/1000-6d9f", "agi-VDADcloser_inboundCID.agi|SALESLINE-----1000-----Closer-----park----999-----1") in new stack
-- Launched AGI Script /var/lib/asterisk/agi-bin/agi-VDADcloser_inboundCID.agi
Perl Environment Dump:
0|SALESLINE-----1000-----Closer-----park----999-----1|
AGI Environment Dump:
-- accountcode =
-- callerid = "1000"
-- channel = SIP/1000-6d9f
-- context = default
-- dnid = 8000
-- enhanced = 0.0
-- extension = 8000
-- language = en
-- priority = 4
-- rdnis = unknown
-- request = agi-VDADcloser_inboundCID.agi
-- type = SIP
-- uniqueid = 1157810258.20

INBOUND CALL VDCL STARTED
+++++ INBOUND CALL VDCL STARTED : |1157810258.20|SALESLINE|SIP/1000-6d9f|8000|SIP|Closer-1000|2006-09-09 5:57:40
AGI Environment Dump: |1157810258.20|SIP/1000-6d9f|8000|SIP|Closer|

INBOUND CALL RECEIVED IN FROM VDCL: Closer SIP/1000-6d9f
+++++ INBOUND VDCL START : |1157810258.20|SIP/1000-6d9f|8000|SIP|2006-09-09 5:57:40

|INSERT INTO vicidial_list (entry_date,modify_date,status,user,vendor_lead_code,source_id,list_id,called_since_last_reset,phone_code,phone_number,security_phrase,called_count,gmt_offset_now,comments) values('2006-09-09 5:57:40','2006090955740','INBND','1000','SALESLINE','VDCL','','Y','','1000','SALESLINE','1','-5.00','1000');|52|
FAIL (unexpected result '')
callerID changed: Y090955740000000052

|INSERT INTO vicidial_auto_calls values('','132.238.97.70','SALESLINE','LIVE','52','1157810258.20','Y090955740000000052','SIP/1000-6d9f','','1000','2006-09-09 5:57:40','IN')|

|INSERT INTO vicidial_closer_log (lead_id,campaign_id,call_date,start_epoch,status,phone_code,phone_number,user,processed) values('52','SALESLINE','2006-09-09 5:57:40','1157810260','QUEUE','','1000','VDCL','N')|
-- VDCL : |52|insert to vicidial_closer_log


|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='132.238.97.70' and campaign_id = 'SALESLINE' and call_time < "2006-09-09 5:57:40" and lead_id != '52';|
-- VDAD get agent: |360|0|1|update of vla table: SALESLINE|132.238.97.70
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='52',uniqueid='1157810258.20', channel='SIP/1000-6d9f', callerid='Y090955740000000052' where status IN('CLOSER','READY') and server_ip='132.238.97.70' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% SALESLINE %" and last_update_time > '19691231135955' order by last_call_finish limit 1;|


|SELECT conf_exten,user,extension FROM vicidial_live_agents where status = 'QUEUE' and server_ip='132.238.97.70' and campaign_id LIKE "%CLOSER%" and callerid='Y090955740000000052' and channel='SIP/1000-6d9f' order by last_call_time limit 1;|
-- VDCL XFER : |1|update of vac table: Y090955740000000052
|UPDATE vicidial_auto_calls set status='CLOSER' where callerid='Y090955740000000052';|
-- closer log : |1|update of vcl table: 52
|UPDATE vicidial_closer_log set user='7777' where lead_id='52' order by call_date desc limit 1;|

exiting the VDAD app, transferring call to 8600051
FAIL (unexpected result '')
FAIL (unexpected result '')
FAIL (unexpected result '')

XXXXXXXXXX VDAD transferred: start|stop 2006-09-09 5:57:40|2006-09-09 5:57:40
-- AGI Script agi-VDADcloser_inboundCID.agi completed, returning 0
-- Executing MeetMe("SIP/1000-6d9f", "8600051") in new stack

-------------------------------------
and in the vicidial windows,STATUS display"
Incoming: 1000 Group- Primary Sales Line Fronter: - 1000
------------------------
Vendor ID: SALESLINE
Phone: 1000
Show: SALESLINE
Comments: 1000


---------------------------
1)one question:why ohters information about this caller dont display?

----------------------------------

when i hangup,message below
--------------------------------
== Spawn extension (default, 8600051, 1) exited non-zero on 'SIP/1000-6d9f'
-- Executing DeadAGI("SIP/1000-6d9f", "call_log.agi|h") in new stack
-- Launched AGI Script /var/lib/asterisk/agi-bin/call_log.agi
+++++ CALL LOG HUNGUP: |1157810258.20|SIP/1000-6d9f|h|2006-09-09 6:02:34|min: |
-- AGI Script call_log.agi completed, returning 0
-- Executing DeadAGI("SIP/1000-6d9f", "VD_hangup.agi|PRI-----NODEBUG-----0---------------") in new stack
-- Launched AGI Script /var/lib/asterisk/agi-bin/VD_hangup.agi
Perl Environment Dump:
0|PRI-----NODEBUG-----0---------------|
AGI Environment Dump:
-- accountcode =
-- callerid = Y090955740000000052
-- channel = SIP/1000-6d9f
-- context = default
-- dnid = 8000
-- enhanced = 0.0
-- extension = h
-- language = en
-- priority = 2
-- rdnis = unknown
-- request = VD_hangup.agi
-- type = SIP
-- uniqueid = 1157810258.20
AGI Environment Dump: |1157810258.20|SIP/1000-6d9f|h|SIP|Y090955740000000052||2|

DEBUG: NODEBUG

VD_hangup : Y090955740000000052 SIP/1000-6d9f 2
+++++ VD hangup START : |1157810258.20|SIP/1000-6d9f|h|SIP|Y090955740000000052|52|2006-09-09 6:02:34||2||


|SELECT lead_id,callerid FROM vicidial_auto_calls where uniqueid = '1157810258.20' limit 1;|
-- VDAC record deleted: |1| |52|1157810258.20|Y090955740000000052|132.238.97.70


|SELECT start_epoch,status FROM vicidial_log where uniqueid='1157810258.20' and lead_id='52' limit 1;|

VD hangup: no VDL record found: 1157810258.20 52 1157810258.20


|SELECT start_epoch,status,closecallid FROM vicidial_closer_log where lead_id = '52' and call_date > "2006-09-09 00:02:34" order by call_date desc limit 1;|


|UPDATE vicidial_log set end_epoch='1157810554',length_in_sec='294' where uniqueid = '1157810258.20';|
-- VDAD vicidial_log update: |0|1157810258.20|


|UPDATE vicidial_closer_log set status='DROP',end_epoch='1157810554',length_in_sec='294' where closecallid = '48';|
-- VDCL update: |1|1157810258.20|48|
-------------------------------------------------------------------------------

WHEN use the same phone call again, get gs102 is unavailable
message is below:
----------------------------------------------
-- Executing Ringing("SIP/1000-7c7c", "") in new stack
-- Executing Wait("SIP/1000-7c7c", "1") in new stack
-- Executing Answer("SIP/1000-7c7c", "") in new stack
-- Executing AGI("SIP/1000-7c7c", "agi-VDADcloser_inboundCID.agi|SALESLINE-----1000-----Closer-----park----999-----1") in new stack
-- Launched AGI Script /var/lib/asterisk/agi-bin/agi-VDADcloser_inboundCID.agi
Perl Environment Dump:
0|SALESLINE-----1000-----Closer-----park----999-----1|
AGI Environment Dump:
-- accountcode =
-- callerid = "1000"
-- channel = SIP/1000-7c7c
-- context = default
-- dnid = 8000
-- enhanced = 0.0
-- extension = 8000
-- language = en
-- priority = 4
-- rdnis = unknown
-- request = agi-VDADcloser_inboundCID.agi
-- type = SIP
-- uniqueid = 1157810768.21

INBOUND CALL VDCL STARTED
+++++ INBOUND CALL VDCL STARTED : |1157810768.21|SALESLINE|SIP/1000-7c7c|8000|SIP|Closer-1000|2006-09-09 6:06:09
AGI Environment Dump: |1157810768.21|SIP/1000-7c7c|8000|SIP|Closer|

INBOUND CALL RECEIVED IN FROM VDCL: Closer SIP/1000-7c7c
+++++ INBOUND VDCL START : |1157810768.21|SIP/1000-7c7c|8000|SIP|2006-09-09 6:06:09

|INSERT INTO vicidial_list (entry_date,modify_date,status,user,vendor_lead_code,source_id,list_id,called_since_last_reset,phone_code,phone_number,security_phrase,called_count,gmt_offset_now,comments) values('2006-09-09 6:06:09','2006090960609','INBND','1000','SALESLINE','VDCL','','Y','','1000','SALESLINE','1','-5.00','1000');|53|
FAIL (unexpected result '')
callerID changed: Y090960609000000053

|INSERT INTO vicidial_auto_calls values('','132.238.97.70','SALESLINE','LIVE','53','1157810768.21','Y090960609000000053','SIP/1000-7c7c','','1000','2006-09-09 6:06:09','IN')|

|INSERT INTO vicidial_closer_log (lead_id,campaign_id,call_date,start_epoch,status,phone_code,phone_number,user,processed) values('53','SALESLINE','2006-09-09 6:06:09','1157810769','QUEUE','','1000','VDCL','N')|
-- VDCL : |53|insert to vicidial_closer_log


|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='132.238.97.70' and campaign_id = 'SALESLINE' and call_time < "2006-09-09 6:06:09" and lead_id != '53';|
-- VDAD get agent: |360|0|1|update of vla table: SALESLINE|132.238.97.70
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='53',uniqueid='1157810768.21', channel='SIP/1000-7c7c', callerid='Y090960609000000053' where status IN('CLOSER','READY') and server_ip='132.238.97.70' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% SALESLINE %" and last_update_time > '19691231135955' order by last_call_finish limit 1;|


|SELECT conf_exten,user,extension FROM vicidial_live_agents where status = 'QUEUE' and server_ip='132.238.97.70' and campaign_id LIKE "%CLOSER%" and callerid='Y090960609000000053' and channel='SIP/1000-7c7c' order by last_call_time limit 1;|
-- VDCL XFER : |1|update of vac table: Y090960609000000053
|UPDATE vicidial_auto_calls set status='CLOSER' where callerid='Y090960609000000053';|
-- closer log : |1|update of vcl table: 53
|UPDATE vicidial_closer_log set user='6666' where lead_id='53' order by call_date desc limit 1;|

exiting the VDAD app, transferring call to 102
FAIL (unexpected result '')
FAIL (unexpected result '')
FAIL (unexpected result '')

XXXXXXXXXX VDAD transferred: start|stop 2006-09-09 6:06:09|2006-09-09 6:06:09
-- AGI Script agi-VDADcloser_inboundCID.agi completed, returning 0
-- Executing Playback("SIP/1000-7c7c", "transfer|skip") in new stack
-- Playing 'transfer' (language 'en')
-- Executing Dial("SIP/1000-7c7c", "sip/gs102|20|to") in new stack
-- Called gs102
-- Got SIP response 486 "Busy Here" back from 132.238.97.97
-- SIP/gs102-bdda is busy
== Everyone is busy/congested at this time
-- Executing VoiceMail("SIP/1000-7c7c", "u102") in new stack
-- Playing 'vm-theperson' (language 'en')
Sep 9 06:06:12 WARNING[3612]: channel.c:472 ast_channel_walk_locked: Avoided initial deadlock for 'SIP/1000-7c7c', 10 retries!
-- Playing 'digits/1' (language 'en')
== Spawn extension (default, 102, 3) exited non-zero on 'SIP/1000-7c7c'
-- Executing DeadAGI("SIP/1000-7c7c", "call_log.agi|h") in new stack
-- Launched AGI Script /var/lib/asterisk/agi-bin/call_log.agi
+++++ CALL LOG HUNGUP: |1157810768.21|SIP/1000-7c7c|h|2006-09-09 6:06:14|min: |
-- AGI Script call_log.agi completed, returning 0
-- Executing DeadAGI("SIP/1000-7c7c", "VD_hangup.agi|PRI-----NODEBUG-----17-----BUSY----------") in new stack
-- Launched AGI Script /var/lib/asterisk/agi-bin/VD_hangup.agi
Perl Environment Dump:
0|PRI-----NODEBUG-----17-----BUSY----------|
AGI Environment Dump:
-- accountcode =
-- callerid = Y090960609000000053
-- channel = SIP/1000-7c7c
-- context = default
-- dnid = 8000
-- enhanced = 0.0
-- extension = h
-- language = en
-- priority = 2
-- rdnis = unknown
-- request = VD_hangup.agi
-- type = SIP
-- uniqueid = 1157810768.21
AGI Environment Dump: |1157810768.21|SIP/1000-7c7c|h|SIP|Y090960609000000053||2|

DEBUG: NODEBUG

VD_hangup : Y090960609000000053 SIP/1000-7c7c 2
+++++ VD hangup START : |1157810768.21|SIP/1000-7c7c|h|SIP|Y090960609000000053|53|2006-09-09 6:06:14||2||


|SELECT lead_id,callerid FROM vicidial_auto_calls where uniqueid = '1157810768.21' limit 1;|
-- VDAC record deleted: |1| |53|1157810768.21|Y090960609000000053|132.238.97.70


|SELECT start_epoch,status FROM vicidial_log where uniqueid='1157810768.21' and lead_id='53' limit 1;|

VD hangup: no VDL record found: 1157810768.21 53 1157810768.21


|SELECT start_epoch,status,closecallid FROM vicidial_closer_log where lead_id = '53' and call_date > "2006-09-09 00:06:14" order by call_date desc limit 1;|


|UPDATE vicidial_list set status='DROP' where lead_id = '53';|
-- VDAD vicidial_list update: |1|53


|UPDATE vicidial_log set status='DROP', end_epoch='1157810774',length_in_sec='5' where uniqueid = '1157810768.21';|
-- VDAD vicidial_log update: |0|1157810768.21|


|UPDATE vicidial_closer_log set status='DROP',end_epoch='1157810774',length_in_sec='5' where closecallid = '49';|

-------------------------------------------------------------
I FOUND BOTH CALL create two records in vicidial_list,
when i delete this two records from vicidial_list,I CAN CALL IN AGAIN!
---------------------

53 2006-09-09 06:06:09 20060909060614 DROP 1000 SALESLINE VDCL 0 -5.00 Y 1000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL SALESLINE 1000 1
52 2006-09-09 05:57:40 20060909060547 DEC 7777 SALESLINE VDCL 0 -5.00 Y 1000 0000-00-00 SALESLINE 1000 1
===============================================
my system is slackware 10.2,asterisk1.010

pls help,thanks!

[mflorell]

What information do you want to appear when an inbound call comes in?

to do a lookup against the existing database you need to use the CIDlookup AGI script for inbound.

[jslyg]

when a call come into vicidial,vicidial can display the caller 's information?
if the caller's dn in the vicidial_list,will it do it?
but now,my vicidial just display below information
Vendor ID: SALESLINE
Phone: 1000
Show: SALESLINE
Comments: 1000

[mflorell]

You should really do a test with the agi-VDADcloser_inboundCIDlookup.agi script instead and do it over live lines with real callerID delivery.

[jslyg]

Scalar found where operator expected at /var/lib/asterisk/agi-bin/agi-VDADcloser _inboundCIDlookup.agi line 271, near "$dbhA"
(Missing semicolon on previous line?)
syntax error at /var/lib/asterisk/agi-bin/agi-VDADcloser_inboundCIDlookup.agi li ne 271, near "$dbhA"
Execution of /var/lib/asterisk/agi-bin/agi-VDADcloser_inboundCIDlookup.agi abort ed due to compilation errors.




IS THIS A BUG?

[jslyg]

yes,a smaill error,SLOVED.

ANOTHER PROBLEM,below 1.....7,total seven option,but "CL_GALLERIA-----7275555134-----Closer-----park----------999-----1)
"
just SIX argument???????
why???




# ; 1. the full name of the IN GROUP to be used in vicidial for the inbound call
# ; 2. the phone number that was called, for the log entry
# ; 3. the callerID or lead_id of the person that called(usually overridden)
# ; 4. the park extension audio file name if used
# ; 5. the status of the call initially(usually not used)
# ; 6. the list_id to insert the new lead under if it is new (and callerID available)
# ; 7. the phone dialing code to insert with the new lead if new (and callerID available)
#
# ;inbound VICIDIAL calls:
#exten => 1234,1,Ringing ; call ringing
#exten => 1234,2,Wait(1) ; Wait 1 second for CID delivery from PRI
#exten => 1234,3,Answer ; Answer the line
#exten => 1234,4,AGI(agi-VDADcloser_inboundCID.agi,CL_GALLERIA-----7275555134-----Closer-----park----------999-----1)
#exten => 1234,5,Hangup

[mflorell]

between park and 999 are 10 dashes, the delimiter is five dashes so the field is empty.

[jslyg]

7275555134，HOW to use it?
like below?

; Extension 7275551212 - Inbound local number from PRI with 10 digit delivery
exten => 7275551212,1,Ringing
exten => 7275551212,2,Wait(1)
exten => 7275551212,3,AGI(call_logCID.agi,${EXTEN}-----${CALLERID}-----${CALLERIDNUM}-----${CALLERIDNAME})
exten => 7275551212,4,Answer
exten => 7275551212,5,Dial,sip/spa2000&sip/spa2001|30|to
exten => 7275551212,6,Voicemail,u2000


what the meaning of " 2. the phone number that was called, for the log entry"?????if no here,what will happen?

[mflorell]

The 2 priority to Wait for one second is so that CallerID information can be received on the call. This is necessary on most PRI circuits.

[jslyg]

exten => 1234,4,AGI(agi-VDADcloser_inboundCID.agi,CL_GALLERIA-----7275555134-----Closer-----park----------999-----1)

what does usement of "7275555134"?

"the phone number that was called, for the log entry",what's meaning????
it just log sth in the mysql??dont matter with vicidial????

pls help me

[mflorell]

It is actually placed in the "user" field when the call is placed into the vicidial_list table as a new lead, Other than that it is unused.