vicidial.org

Hi,

We are using vicidial for 60+ calling executives with no predictive dialling as of now. The vicidial installation is from the scratch in cluster architecture with following structure
1 DB Server
2 Asterisk Server (phones are divided)
1 GUI Server

All are running CentOS 6.9 on Quad Core machine with 16GB RAM.

The calling executives are getting 2 errors
1. While dialling, the fields are getting populated by "undefined" (even the phone numbers) and the call is getting connected.
2. The executives are getting MySQL connect ERROR: Can't connect to MySQL server on 'SERVER IP' (99). This error is coming to random executives.


After searching on google, I have come to know that it is related to MySQL configuration. Please find below the mysql config

Code: Select all

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
max_connections=8000
max_heap_table_size=1024M
query_cache_size = 0
skip-external-locking
key_buffer_size = 512M
max_allowed_packet = 12000M
table_open_cache = 8192
sort_buffer_size = 4M
net_buffer_length = 8K
read_buffer_size = 4M
read_rnd_buffer_size = 16M
myisam_sort_buffer_size = 64M
thread_cache_size = 50   

thread_concurrency=8
skip-name-resolve
connect_timeout=60
long_query_time=3
log_slow_queries
open_files_limit=24576
expire_logs_days=3
default-storage-engine=MyISAM
table_definition_cache=8192
table_cache=8192
myisam_recover
myisam_repair_threads=1
wait_timeout=120


[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

It is affecting our calling process as the proper data is not getting fetched. Please help me regarding this.
Thanks in advance.

Scratch Install | Vicidial 2.14-620a Build 170623-2142 | Asterisk 11.25.1 | In Cluster | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel(R) Xeon(R) CPU E3-1225 v5 @ 3.30GHz

That could be caused by several different issues. Usually it is inadequate hardware on the database server, or improper configuration.

Is there a specific reason you didn't use VICIbox for this installation? As part of it's installation it tunes the servers to the dedicated task you select for them, such as: database, webserver or dialer.