vicidial.org

Hi Guys,

Ive recently tried intalling Vicidial on Ubuntu Server 16.04.6 LTS distro, I managed to install all components and get the proper screen values without them going missing, when doing a test login to a test campaign asterisk does not call the phone i set in the phone login setting, my softphone x-lite is logged in to the asterisk server, I immediately get a YOUR SESSION is DISABLED.


Vicidial VERSION: 2.14-717a
Vicidial BUILD: 190724-1603
Revision: 3131
Asterisk Version: asterisk-1.8.23.0-vici
DAHDI Version: Dahdi-linux-complete-2.10.2+2.10.2
Operating System: Ubuntu Server 16.04.6 LTS

anyone encountered this while doing a fresh scratch install on ubuntu 16.04?

Dont know why install from scratch if you have an ISO file, but this error is due that there is no record on the vicidial_live_agents table for that agent. Make a quick check to your DB to see if there is table corrupted o better install from the VICIBOX iso file

anyway I figured it out, howto pdf will be coming this time with ubuntu 18.04 server, mariadb 10.4 + asterisk 13 + dahdi 3

Im having similar problem - can you share the fix info - thanks

This solution is specific to MariaDB 10.4 but may apply to others

First have a look at the following log file: /var/www/html/agc/vicidial_mysqli_errors.txt (change to your web directory as appropriate)
if you see something similar to the below, it's more than likely a setting in mariadb

Incorrect integer value: '' for column `hostname`.`vicidial_live_agents`.`lead_id` at row 1|INSERT INTO vicidial_live_agents (user,server_ip,conf_exten,exte$

In MariaDB 10.4, STRICT MODE is ON by default. You can check by going to your database console (mysql) and entering the following:

SHOW VARIABLES LIKE 'sql_mode';

If it's on, you'll get a response similar to that below

+---------------+-------------------------------------------------------------------------------------------+
| Variable_name | Value |
+---------------+-------------------------------------------------------------------------------------------+
| sql_mode | STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+---------------+-------------------------------------------------------------------------------------------+
1 row in set (0.001 sec)

The solution is fairly simple. Edit your my.cnf and under the [mysqld] add the following line

sql_mode =""

restart MariaDB and run the query again and you should get the following

+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| sql_mode | |
+---------------+-------+
1 row in set (0.001 sec)

Regards