vicidial.org

Hello, all of a sudden my listloader custom layout / template stopped working.

When I go to upload leads I am not given the option to match fields in my file with my custom fields. Any leads I do attempt to upload get a 100% "Bad" message.

I was working with a test campaign and a test list that was previously uploaded and worked in the past. I cleared out the test list because I was making some changes to custom fields. I wanted to reupload the test list to the test campaign to see how the custom fields would look.

Here's how the screen looks after uploading a file and selecting "Custom Layout"


Here's how the screen looks after uploading leads and choosing the "Template Builder"


I've searched the forum and found another thread where the user was hacked. I'm hoping that's not the case.

Everything worked fine before but it's been a while since I've uploaded new leads so I cannot say how long this has been going on but I just discovered it today.

I'm not sure where to start to figure out what happened and how to resolve this.

Here's my build info:

Vicibox10
Version: 2.14b0.5
SVN Version: 3529
DB Schema Version: 1645

Thanks for your help!

If you are using the template, you no longer get the option to map the fields. To get the map, use custom not custom template.

If you don't get a field list when using Custom (without template), it's likely that the system did not recognize your field list/file format. Try an old list.

williamconley wrote:If you are using the template, you no longer get the option to map the fields. To get the map, use custom not custom template.

If you don't get a field list when using Custom (without template), it's likely that the system did not recognize your field list/file format. Try an old list.

Thanks, William, but the option to map fields are not there whether I choose the custom layout, an existing custom template, or try to create a new custom template.

I'm not certain but from reading the forums I think my system has been compromised. It can still make dials, but I am unable to load new leads.

I've already started building a new system with the latest version and locked it down with a whitelist firewall.

I am able to upload the exact same list to the NEW dialer and I am presented with the field mapping options. So clearly something is broken on the other dialer.



But if you have any other ideas I am open.

try running a mysqlcheck

mysqlcheck --all-databases --auto-repair

carpenox wrote:try running a mysqlcheck

mysqlcheck --all-databases --auto-repair

Code: Select all

VICIbox10:~ # mysqlcheck --all-databases --auto-repair
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.cid_channels_recent_174138190082          OK
asterisk.conferences                               OK
asterisk.contact_information                       OK
asterisk.custom_1000                               OK
asterisk.custom_1002                               OK
asterisk.custom_1003                               OK
asterisk.custom_201                                OK
asterisk.dialable_inventory_snapshots              OK
asterisk.groups_alias                              OK
asterisk.help_documentation                        OK
asterisk.inbound_email_attachments                 OK
asterisk.inbound_numbers                           OK
asterisk.leave_vm_message_groups                   OK
asterisk.leave_vm_message_groups_entries           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.park_log_archive                          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.quality_control_checkpoint_log            OK
asterisk.quality_control_checkpoints               OK
asterisk.quality_control_queue                     OK
asterisk.quality_control_scorecards                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_dial_campaigns             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_agent_visibility_log             OK
asterisk.vicidial_agent_visibility_log_archive     OK
asterisk.vicidial_agent_vmm_overrides              OK
asterisk.vicidial_ajax_log                         OK
asterisk.vicidial_amd_log                          OK
asterisk.vicidial_amd_log_archive                  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_bench_agent_log                  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_ccc_log                          OK
asterisk.vicidial_ccc_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_dnc_queue                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_log_archive                  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_caller_codes             OK
asterisk.vicidial_inbound_caller_codes_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_khomp_log                        OK
asterisk.vicidial_language_phrases                 OK
asterisk.vicidial_languages                        OK
asterisk.vicidial_lead_24hour_calls                OK
asterisk.vicidial_lead_call_daily_counts           OK
asterisk.vicidial_lead_call_quota_counts           OK
asterisk.vicidial_lead_call_quota_counts_archive   OK
asterisk.vicidial_lead_filters                     OK
asterisk.vicidial_lead_messages                    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_extended_sip                 OK
asterisk.vicidial_log_extended_sip_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_peer_event_log                   OK
asterisk.vicidial_peer_event_log_archive           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_recent_ascb_calls                OK
asterisk.vicidial_recent_ascb_calls_archive        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_security_event_log               OK
asterisk.vicidial_server_carriers                  OK
asterisk.vicidial_server_trunks                    OK
asterisk.vicidial_session_data                     OK
asterisk.vicidial_sessions_recent                  OK
asterisk.vicidial_sessions_recent_archive          OK
asterisk.vicidial_settings_containers              OK
asterisk.vicidial_shared_drops                     OK
asterisk.vicidial_shared_log                       OK
asterisk.vicidial_shifts                           OK
asterisk.vicidial_sip_action_log                   OK
asterisk.vicidial_sip_action_log_archive           OK
asterisk.vicidial_sip_event_archive_details        OK
asterisk.vicidial_sip_event_log                    OK
asterisk.vicidial_sip_event_log_0                  OK
asterisk.vicidial_sip_event_log_1                  OK
asterisk.vicidial_sip_event_log_2                  OK
asterisk.vicidial_sip_event_log_3                  OK
asterisk.vicidial_sip_event_log_4                  OK
asterisk.vicidial_sip_event_log_5                  OK
asterisk.vicidial_sip_event_log_6                  OK
asterisk.vicidial_sip_event_recent                 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_tiltx_shaken_log                 OK
asterisk.vicidial_timeclock_audit_log              OK
asterisk.vicidial_timeclock_log                    OK
asterisk.vicidial_timeclock_status                 OK
asterisk.vicidial_tts_prompts                      OK
asterisk.vicidial_two_factor_auth                  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_vmm_counts                       OK
asterisk.vicidial_vmm_counts_archive               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
mysql.column_stats                                 OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.global_priv                                  OK
mysql.gtid_slave_pos                               OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.index_stats                                  OK
mysql.innodb_index_stats                           OK
mysql.innodb_table_stats                           OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.roles_mapping                                OK
mysql.servers                                      OK
mysql.table_stats                                  OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.transaction_registry                         OK
Vicibox10:~ #


Still the same issue. There is no lead field mapping options when uploading a list.

check if you have this line in your /etc/my.cnf file

sql_mode="NO_ENGINE_SUBSTITUTION"

carpenox wrote:check if you have this line in your /etc/my.cnf file

sql_mode="NO_ENGINE_SUBSTITUTION"

nope

Code: Select all

# The following options will be passed to all MariaDB clients
[client]
# Please note that storing the password in this file is not safe. For this
# purpose you can, for example, list your password in the [client] section
# of the '~/.my.cnf' configuration file with an access mode set to 400 or 600.
# password   = your_password
# port       = 3306
# socket     = /run/mysql/mysql.sock

# The MariaDB server
[mysqld]

# For security reasons, bind to 127.0.0.1 by default to enable networking
# only on the loopback interface.
bind-address    = 127.0.0.1

# If log-error is not set, mysqld will write to "/var/lib/mysql/$HOSTNAME.err"
# which is not beneficial for rotating the log file if it grows in size.
log-error       = /var/log/mysql/mysqld.log

# Enable the slow query log to see queries with especially long duration
# slow_query_log=1
# slow_query_log_file = /var/log/mysql/mysqld_slow.log

# Operations 'LOAD DATA', 'SELECT ... INTO' and 'LOAD FILE()' will only
# work with files in the specified directory
secure_file_priv = /var/lib/mysql-files

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin=mysql-bin
# binlog_format=mixed

# Remove leading # if you want to store your database elsewhere
# datadir       = /var/lib/mysql

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id       = 1

# These are commonly set, remove the # and set as required.
# port = 3306
# socket = /run/mysql/mysql.sock

# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M


add it just below # The MariaDB server
[mysqld]

and then restart mysql

carpenox wrote:add it just below # The MariaDB server
[mysqld]

and then restart mysql

I added that and restarted mysql but I still cannot load leads. :/

check the error logs for apache and see what u find