Your session has been disabled Fresh Install

[boybawang]

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

[boybawang]

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

[ambiorixg12]

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

[boybawang]

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

[jassmix]

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

[middletn]

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