Unable to make changes on System Settings

Any and all non-support discussions

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

Unable to make changes on System Settings

Postby rbbumanlag » Mon Aug 17, 2020 3:43 am

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!
Last edited by rbbumanlag on Mon Aug 17, 2020 9:03 am, edited 1 time in total.
rbbumanlag
 
Posts: 74
Joined: Mon Sep 26, 2016 10:37 am

Re: Unable to make changes on System Settings

Postby mflorell » Mon Aug 17, 2020 7:27 am

What does your apache error_log show?
mflorell
Site Admin
 
Posts: 17804
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Unable to make changes on System Settings

Postby rbbumanlag » Mon Aug 17, 2020 8:58 am

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!
rbbumanlag
 
Posts: 74
Joined: Mon Sep 26, 2016 10:37 am

Re: Unable to make changes on System Settings

Postby carpenox » Mon Aug 17, 2020 11:59 am

good postback
Leap 15.2 | Version: 2.14-822a | BUILD: 210715-1248| SVN Version: 3483 | DB Schema Version: 1639 | Asterisk 13.38.2-vici
www.CyburDial.net -:- 844-PC-SATA-2 -:- My Blog: http://vicidial.blog -:- Whatsapp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 1478
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL

Re: Unable to make changes on System Settings

Postby boybawang » Wed Sep 02, 2020 9:27 am

you can download the vicibox my.cnf as it have the basic tuning settings for mariadb which is a good reference
Vicidial Installation + Configuration + Support + Custom Development
Download my ebook on installing vicidial for free http://download.vicidial.com/ubuntu/VIC ... 100331.pdf
skype: deodax.cordova@gmail.com
m: +639172063730
boybawang
 
Posts: 987
Joined: Sat Nov 14, 2009 1:18 pm
Location: Dumaguete City, Negros Oriental, Philippines


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 37 guests