vicidial_carrier_log table remains empty

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

vicidial_carrier_log table remains empty

Postby sqlerror » Thu Nov 21, 2013 11:00 am

VERSION: 2.8-417a
BUILD: 131019-0849
Revision: 2039

With this new install we encounter that the MySQL table vicidial_carrier_log remains empty.
Carrier logging is set to 'Y'.

Do I forget a setting or is this table only used by ViCiDial when doing automated outbound calls?

Any help is much appreciated,

Geert
Vicibox 8.1.2
Version: 2.14b0.5
SVN Version: 3058
DB Schema Version: 1561
sqlerror
 
Posts: 12
Joined: Sun Mar 04, 2012 4:29 am
Location: Netherlands

Re: vicidial_carrier_log table remains empty

Postby DomeDan » Fri Nov 22, 2013 8:15 am

In your carrier dialplan entry, did you add "AGI(agi://127.0.0.1:4577/call_log)" like in the example carriers?
Vicidial Partner. Region: Sweden/Norway.
Does Vicidial installation, configuration, customization, add-ons, CRM implementation, support, upgrading, network-related, pentesting etc. Remote and onsite assistance.
Email: domedan (at) gmail.com
DomeDan
 
Posts: 1226
Joined: Tue Jan 04, 2011 9:17 am
Location: Sweden

Re: vicidial_carrier_log table remains empty

Postby sqlerror » Sat Nov 23, 2013 3:01 pm

DomeDan wrote:In your carrier dialplan entry, did you add "AGI(agi://127.0.0.1:4577/call_log)" like in the example carriers?


Yep ...
Vicibox 8.1.2
Version: 2.14b0.5
SVN Version: 3058
DB Schema Version: 1561
sqlerror
 
Posts: 12
Joined: Sun Mar 04, 2012 4:29 am
Location: Netherlands

Re: vicidial_carrier_log table remains empty

Postby williamconley » Sat Nov 23, 2013 3:57 pm

only used by ViCiDial when doing automated outbound calls?

Yep.

Inbound calls have other tables.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: vicidial_carrier_log table remains empty

Postby sqlerror » Sat Nov 23, 2013 7:52 pm

williamconley wrote:
only used by ViCiDial when doing automated outbound calls?

Yep.

Inbound calls have other tables.

Hi Wiiliam,
Yes, I am aware of that inbound calls have other tables.
The situation is that I need to be able to report duration and status of outbound calls that are placed manually using 3way tranfers on inbound calls to external destinations.

So how would I identify the call details of the third call leg in a 3way consultative transfer if manual outgoing calls are not logged in the carrier_log table even if these transfers are placed via our outbound SIP carrier ?
Vicibox 8.1.2
Version: 2.14b0.5
SVN Version: 3058
DB Schema Version: 1561
sqlerror
 
Posts: 12
Joined: Sun Mar 04, 2012 4:29 am
Location: Netherlands

Re: vicidial_carrier_log table remains empty

Postby williamconley » Sat Nov 23, 2013 11:58 pm

I believe 3-way calls are treated as manual dial calls. different logs. each type of call has at least one log table.

make one, and see which logs it appears in. note that after the call terminates, the "hangup" command will initiate a cleanup script that puts the appropriate length of call on the record so all your data should be available in the log when you do find it. :)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: vicidial_carrier_log table remains empty

Postby sqlerror » Sun Nov 24, 2013 2:08 pm

Hello William,
I can find the outbound call in that is part of a 3way-call but I guess I need some custom destination in the dialplan to be able to link the outbound call to the inbound call from where the 3th party has been called.
The situation is that the customer has an online reception service and both the incoming call and the external transfered calls must be reported for usage and billing.
The most useable data I now can use are in the recording_log, but that will need no delay with recording what might effect perfomance.
Vicibox 8.1.2
Version: 2.14b0.5
SVN Version: 3058
DB Schema Version: 1561
sqlerror
 
Posts: 12
Joined: Sun Mar 04, 2012 4:29 am
Location: Netherlands

Re: vicidial_carrier_log table remains empty

Postby williamconley » Sun Nov 24, 2013 6:42 pm

all calls involved SHOULD be linked to the lead_id for that lead. And since that lead should be connected to your client (based on DID from which it arrived?) you should be able to assemble what you need with mysql using the lead as the common thread.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: vicidial_carrier_log table remains empty

Postby sqlerror » Mon Nov 25, 2013 4:19 am

I was trying to follow channels and contexts, your lead id(ea) is the track I will now follow. Thanks for the hint!
Vicibox 8.1.2
Version: 2.14b0.5
SVN Version: 3058
DB Schema Version: 1561
sqlerror
 
Posts: 12
Joined: Sun Mar 04, 2012 4:29 am
Location: Netherlands


Return to Support

Who is online

Users browsing this forum: Bing [Bot] and 79 guests