vicidial.org

Hi Vicidial,

Vicidial Info
VERSION: 2.14-765a
BUILD: 200815-0015

I am currently trying again to install Vicidial using Centos 7.

I was able to install Vicidial on Centos 7. I was able to add data on Campaigns, List, Ingroup, DID, Carriers.

Add phone was fixed using this command to mysql ALTER TABLE phones ALTER template_id SET DEFAULT ' ';

The problem is that I am unable to edit System Settings.

Also I already tried to Grant All Privileges to cron and custom user, but still, I am unable to edit the system settings.

After editing systems setting, there is not data encoded on the DB.

Thanks!

What does your apache error_log show?

Hi Matt,

I am using
Centos 7
MariaDB 13.24
Php 7.3

I encountered below error.

Incorrect integer value: '' for column `asterisk`.`vicidial_live_agents`.`lead_id` at row 1|INSERT INTO vicidial_live_agents (user,server_ip,conf_exten,extension,status,lead_id,campaign_id,uniqueid,callerid,channel,random_id,last_call_time,last_update_time,last_call_finish,user_level,campaign_weight,calls_today,last_state_change,outbound_autodial,manager_ingroup_set,on_hook_ring_time,on_hook_agent,campaign_grade,last_inbound_call_time_filtered,last_inbound_call_finish_filtered) values etc..

Upon further investigation, I was able to make it work.

I compared the sql_mode from my previous installations. Then discovered that previous MariaDB installations have sql_mode set to NO_ENGINE_SUBSTITUTION.

Then I set sql_mode=NO_ENGINE_SUBSTITUTION

then systemctl restart mariadb.

This fixed the issue.

Thanks!

good postback

you can download the vicibox my.cnf as it have the basic tuning settings for mariadb which is a good reference