vicidial.org

Good day all.

I am currently running into an issue where the vicidial_carrier_log is only populated in one in every ~1000 calls no matter the hangup reason. Is there a way to tweak this? currently using vicibox on VERSION: 2.14-670a BUILD: 180424-1521 with one carrier and only launching one campaign. I am using remote agents w multiple lines dialed at a 1:1 ratio

as an example this is what my current live screen presents


http://prntscr.com/jcj5k6

Has anyone come across this where only .01% of calls make it to vicidial_carrier_log ?

lordzer wrote:Good day all.

I am currently running into an issue where the vicidial_carrier_log is only populated in one in every ~1000 calls no matter the hangup reason. Is there a way to tweak this? currently using vicibox on VERSION: 2.14-670a BUILD: 180424-1521 with one carrier and only launching one campaign. I am using remote agents w multiple lines dialed at a 1:1 ratio

1) You posted your Version with Build: Good. Please also post your installation method with Version. If the installation method is not a Vicidial .iso (such as Vicibox), please also post a link to the installation instructions you used.

2) Carrier log is either populated or not based on the setting in admin->servers->(choose server)->Carrier Logging Active

If that's not the case, then you may have a crashed table that kills a process before logging occurs. Try:

Code: Select all

mysqlcheck --all-databases --auto-repair --user=cron -p1234

3) If no tables are crashed, consider checking the screens for asterisk and autodial and/or the Vicidial logs in /var/log/astguiclient (which are also activated by a setting in admin->servers) for error notices.

Code: Select all

screen -list

williamconley wrote:

lordzer wrote:Good day all.

I am currently running into an issue where the vicidial_carrier_log is only populated in one in every ~1000 calls no matter the hangup reason. Is there a way to tweak this? currently using vicibox on VERSION: 2.14-670a BUILD: 180424-1521 with one carrier and only launching one campaign. I am using remote agents w multiple lines dialed at a 1:1 ratio

1) You posted your Version with Build: Good. Please also post your installation method with Version. If the installation method is not a Vicidial .iso (such as Vicibox), please also post a link to the installation instructions you used.

Vicibox8 iso vicibox.org instructions for a single server

williamconley wrote:2) Carrier log is either populated or not based on the setting in admin->servers->(choose server)->Carrier Logging Active

It Is indeed enabled as evidenced by the fact that a small portion of the calls are being logged to the vicidial_carrier_log table, I had checked this multiple times to make sure but only 1 in 1000 or so calls get inserted

the below image is from the live screen after 10000 calls in the last 24h

http://prntscr.com/jgd3tl

williamconley wrote:If that's not the case, then you may have a crashed table that kills a process before logging occurs. Try:

Code: Select all

mysqlcheck --all-databases --auto-repair --user=cron -p1234

The following was the output, I believe no errors (carrier log is OK)

Code: Select all

asterisk.audio_store_details                       OK
asterisk.call_log                                  OK
asterisk.call_log_archive                          OK
asterisk.callcard_accounts                         OK
asterisk.callcard_accounts_details                 OK
asterisk.callcard_log                              OK
asterisk.cid_channels_recent                       OK
asterisk.conferences                               OK
asterisk.contact_information                       OK
asterisk.dialable_inventory_snapshots              OK
asterisk.groups_alias                              OK
asterisk.inbound_email_attachments                 OK
asterisk.inbound_numbers                           OK
asterisk.live_channels
note     : The storage engine for the table doesn't support check
asterisk.live_inbound                              OK
asterisk.live_inbound_log                          OK
asterisk.live_sip_channels
note     : The storage engine for the table doesn't support check
asterisk.nanpa_prefix_exchanges_fast               OK
asterisk.nanpa_prefix_exchanges_master             OK
asterisk.nanpa_wired_to_wireless                   OK
asterisk.nanpa_wireless_to_wired                   OK
asterisk.park_log                                  OK
asterisk.parked_channels
note     : The storage engine for the table doesn't support check
asterisk.parked_channels_recent                    OK
asterisk.phone_favorites                           OK
asterisk.phones                                    OK
asterisk.phones_alias                              OK
asterisk.recording_log                             OK
asterisk.recording_log_archive                     OK
asterisk.recording_log_deletion_queue              OK
asterisk.routing_initiated_recordings              OK
asterisk.server_performance                        OK
asterisk.server_updater
note     : The storage engine for the table doesn't support check
asterisk.servers                                   OK
asterisk.system_settings                           OK
asterisk.twoday_call_log                           OK
asterisk.twoday_recording_log                      OK
asterisk.twoday_vicidial_agent_log                 OK
asterisk.twoday_vicidial_closer_log                OK
asterisk.twoday_vicidial_log                       OK
asterisk.twoday_vicidial_xfer_log                  OK
asterisk.user_call_log                             OK
asterisk.user_call_log_archive                     OK
asterisk.vicibox                                   OK
asterisk.vicidial_admin_log                        OK
asterisk.vicidial_agent_function_log               OK
asterisk.vicidial_agent_function_log_archive       OK
asterisk.vicidial_agent_log                        OK
asterisk.vicidial_agent_log_archive                OK
asterisk.vicidial_agent_skip_log                   OK
asterisk.vicidial_agent_sph                        OK
asterisk.vicidial_ajax_log                         OK
asterisk.vicidial_amm_multi                        OK
asterisk.vicidial_api_log                          OK
asterisk.vicidial_api_log_archive                  OK
asterisk.vicidial_api_urls                         OK
asterisk.vicidial_api_urls_archive                 OK
asterisk.vicidial_areacode_filters                 OK
asterisk.vicidial_asterisk_output                  OK
asterisk.vicidial_auto_calls
note     : The storage engine for the table doesn't support check
asterisk.vicidial_automated_reports                OK
asterisk.vicidial_avatar_audio                     OK
asterisk.vicidial_avatars                          OK
asterisk.vicidial_call_menu                        OK
asterisk.vicidial_call_menu_options                OK
asterisk.vicidial_call_notes                       OK
asterisk.vicidial_call_notes_archive               OK
asterisk.vicidial_call_time_holidays               OK
asterisk.vicidial_call_times                       OK
asterisk.vicidial_callbacks                        OK
asterisk.vicidial_callbacks_archive                OK
asterisk.vicidial_campaign_agents                  OK
asterisk.vicidial_campaign_cid_areacodes           OK
asterisk.vicidial_campaign_dnc                     OK
asterisk.vicidial_campaign_hotkeys                 OK
asterisk.vicidial_campaign_hour_counts             OK
asterisk.vicidial_campaign_hour_counts_archive     OK
asterisk.vicidial_campaign_server_stats
note     : The storage engine for the table doesn't support check
asterisk.vicidial_campaign_stats                   OK
asterisk.vicidial_campaign_stats_debug             OK
asterisk.vicidial_campaign_statuses                OK
asterisk.vicidial_campaigns                        OK
asterisk.vicidial_campaigns_list_mix               OK
asterisk.vicidial_carrier_hour_counts              OK
asterisk.vicidial_carrier_hour_counts_archive      OK
asterisk.vicidial_carrier_log                      OK
asterisk.vicidial_carrier_log_archive              OK
asterisk.vicidial_chat_archive                     OK
asterisk.vicidial_chat_log                         OK
asterisk.vicidial_chat_log_archive                 OK
asterisk.vicidial_chat_participants                OK
asterisk.vicidial_cid_groups                       OK
asterisk.vicidial_closer_log                       OK
asterisk.vicidial_closer_log_archive               OK
asterisk.vicidial_comments                         OK
asterisk.vicidial_conf_templates                   OK
asterisk.vicidial_conferences                      OK
asterisk.vicidial_configuration                    OK
asterisk.vicidial_country_iso_tld                  OK
asterisk.vicidial_cpd_log                          OK
asterisk.vicidial_custom_cid                       OK
asterisk.vicidial_custom_leadloader_templates      OK
asterisk.vicidial_custom_reports                   OK
asterisk.vicidial_daily_max_stats                  OK
asterisk.vicidial_daily_ra_stats                   OK
asterisk.vicidial_dial_log                         OK
asterisk.vicidial_dial_log_archive                 OK
asterisk.vicidial_did_agent_log                    OK
asterisk.vicidial_did_agent_log_archive            OK
asterisk.vicidial_did_log                          OK
asterisk.vicidial_did_ra_extensions                OK
asterisk.vicidial_dnc                              OK
asterisk.vicidial_dnc_log                          OK
asterisk.vicidial_dnccom_filter_log                OK
asterisk.vicidial_dnccom_scrub_log                 OK
asterisk.vicidial_drop_lists                       OK
asterisk.vicidial_drop_log                         OK
asterisk.vicidial_drop_log_archive                 OK
asterisk.vicidial_drop_rate_groups                 OK
asterisk.vicidial_dtmf_log                         OK
asterisk.vicidial_email_accounts                   OK
asterisk.vicidial_email_list                       OK
asterisk.vicidial_email_log                        OK
asterisk.vicidial_extension_groups                 OK
asterisk.vicidial_filter_phone_groups              OK
asterisk.vicidial_filter_phone_numbers             OK
asterisk.vicidial_grab_call_log                    OK
asterisk.vicidial_hopper
note     : The storage engine for the table doesn't support check
asterisk.vicidial_html_cache_stats                 OK
asterisk.vicidial_inbound_callback_queue           OK
asterisk.vicidial_inbound_callback_queue_archive   OK
asterisk.vicidial_inbound_dids                     OK
asterisk.vicidial_inbound_group_agents             OK
asterisk.vicidial_inbound_groups                   OK
asterisk.vicidial_inbound_survey_log               OK
asterisk.vicidial_inbound_survey_log_archive       OK
asterisk.vicidial_ingroup_hour_counts              OK
asterisk.vicidial_ingroup_hour_counts_archive      OK
asterisk.vicidial_ip_list_entries                  OK
asterisk.vicidial_ip_lists                         OK
asterisk.vicidial_ivr                              OK
asterisk.vicidial_ivr_response                     OK
asterisk.vicidial_language_phrases                 OK
asterisk.vicidial_languages                        OK
asterisk.vicidial_lead_filters                     OK
asterisk.vicidial_lead_recycle                     OK
asterisk.vicidial_lead_search_log                  OK
asterisk.vicidial_lead_search_log_archive          OK
asterisk.vicidial_list                             OK
asterisk.vicidial_list_alt_phones                  OK
asterisk.vicidial_list_pins                        OK
asterisk.vicidial_list_update_log                  OK
asterisk.vicidial_lists                            OK
asterisk.vicidial_lists_custom                     OK
asterisk.vicidial_lists_fields                     OK
asterisk.vicidial_live_agents                      OK
asterisk.vicidial_live_chats                       OK
asterisk.vicidial_live_inbound_agents              OK
asterisk.vicidial_log                              OK
asterisk.vicidial_log_archive                      OK
asterisk.vicidial_log_extended                     OK
asterisk.vicidial_log_extended_archive             OK
asterisk.vicidial_log_noanswer                     OK
asterisk.vicidial_log_noanswer_archive             OK
asterisk.vicidial_manager                          OK
asterisk.vicidial_manager_chat_log                 OK
asterisk.vicidial_manager_chat_log_archive         OK
asterisk.vicidial_manager_chats                    OK
asterisk.vicidial_manager_chats_archive            OK
asterisk.vicidial_manual_dial_queue                OK
asterisk.vicidial_monitor_calls                    OK
asterisk.vicidial_monitor_log                      OK
asterisk.vicidial_music_on_hold                    OK
asterisk.vicidial_music_on_hold_files              OK
asterisk.vicidial_nanpa_filter_log                 OK
asterisk.vicidial_nanpa_prefix_codes               OK
asterisk.vicidial_outbound_ivr_log                 OK
asterisk.vicidial_outbound_ivr_log_archive         OK
asterisk.vicidial_override_ids                     OK
asterisk.vicidial_pause_codes                      OK
asterisk.vicidial_phone_codes                      OK
asterisk.vicidial_postal_codes                     OK
asterisk.vicidial_process_log                      OK
asterisk.vicidial_process_trigger_log              OK
asterisk.vicidial_process_triggers                 OK
asterisk.vicidial_qc_agent_log                     OK
asterisk.vicidial_qc_codes                         OK
asterisk.vicidial_recording_access_log             OK
asterisk.vicidial_remote_agent_log                 OK
asterisk.vicidial_remote_agents                    OK
asterisk.vicidial_report_log                       OK
asterisk.vicidial_rt_monitor_log                   OK
asterisk.vicidial_rt_monitor_log_archive           OK
asterisk.vicidial_screen_colors                    OK
asterisk.vicidial_screen_labels                    OK
asterisk.vicidial_scripts                          OK
asterisk.vicidial_server_carriers                  OK
asterisk.vicidial_server_trunks                    OK
asterisk.vicidial_session_data                     OK
asterisk.vicidial_settings_containers              OK
asterisk.vicidial_shifts                           OK
asterisk.vicidial_state_call_times                 OK
asterisk.vicidial_stations                         OK
asterisk.vicidial_status_categories                OK
asterisk.vicidial_status_groups                    OK
asterisk.vicidial_statuses                         OK
asterisk.vicidial_territories                      OK
asterisk.vicidial_timeclock_audit_log              OK
asterisk.vicidial_timeclock_log                    OK
asterisk.vicidial_timeclock_status                 OK
asterisk.vicidial_tts_prompts                      OK
asterisk.vicidial_url_log                          OK
asterisk.vicidial_url_multi                        OK
asterisk.vicidial_urls                             OK
asterisk.vicidial_user_closer_log                  OK
asterisk.vicidial_user_groups                      OK
asterisk.vicidial_user_list_new_lead               OK
asterisk.vicidial_user_log                         OK
asterisk.vicidial_user_territories                 OK
asterisk.vicidial_user_territory_log               OK
asterisk.vicidial_users                            OK
asterisk.vicidial_vdad_log                         OK
asterisk.vicidial_voicemail                        OK
asterisk.vicidial_webservers                       OK
asterisk.vicidial_xfer_log                         OK
asterisk.vicidial_xfer_log_archive                 OK
asterisk.vicidial_xfer_presets                     OK
asterisk.vicidial_xfer_stats                       OK
asterisk.vtiger_rank_data                          OK
asterisk.vtiger_rank_parameters                    OK
asterisk.vtiger_vicidial_roles                     OK
asterisk.web_client_sessions
note     : The storage engine for the table doesn't support check
asterisk.www_phrases                               OK


williamconley wrote:3) If no tables are crashed, consider checking the screens for asterisk and autodial and/or the Vicidial logs in /var/log/astguiclient (which are also activated by a setting in admin->servers) for error notices.

Code: Select all

screen -list

I am checking now, but admit I do not know specifically what i am looking for

lordzer wrote:Vicibox8 iso vicibox.org instructions for a single server

That's the "brochure/discussion" description of the installer. The technical version (which you should always use) is something more like 8.X.X.

Code: Select all

or the Vicidial logs in /var/log/astguiclient

Code: Select all

screen -list

I am checking now, but admit I do not know specifically what i am looking for

You could have started by posting the output of screen -list ...? or checking the logs for errors ...? (often the word "error" is a hint ... but other possibilities exist!)

Sorry, it is the current version on the site, my apologies http://download.vicidial.com/iso/vicibox/server/ViciBox_v8.x86_64-8.0.1.iso (8.0.1) with the http://download.vicidial.com/iso/vicibox/server/ViciBox_v7-Install.pdf Installation Manual for ViciBox v.7.0 instructions followed


I'm not sure the particular log, but my best guess was the FASTagiout log, there are no errors contained therein for the day and I am currently parsing the rest of the log files (quite large) and will get back to you.

the following is the output from screen -list

There are screens on:
30284.ASTupdate (Detached)
23267.ASTemail (Detached)
14606.ASTVDremote (Detached)
6118.ASTVDadapt (Detached)
2472.ASTVDadFILL (Detached)
2469.ASTfastlog (Detached)
2459.ASTVDauto (Detached)
2456.ASTlisten (Detached)
2453.ASTsend (Detached)
2313.asterisk (Detached)
2308.astshell20180509142052 (Detached)

technically, any of those screens could contain errors which could be helpful. Viewing them and seeing if there are any during problem times may prove educational if there is a crash causing the log entries to fail.

This command will show you what's really happening and will show agi script errors if they occur while you're watching:

Code: Select all

screen -r asterisk

ctrl-a ctrl-d to exit, and be careful while you're in there as this is the asterisk console which can kill asterisk if you do more than observe and leave

There are also hard-logs (not in a database) in both /var/log/asterisk and /var/log/astguiclient (the latter based on log configuration under admin->servers)

call quality issues are rarely logged.