Vicidial / Queuemetrics Integration Issue

[ztec_za]

Hi All, I've managed to setup vicidial / Queuemetrics integration. However, I am encountering a issue whereby calls are not "closed" in Queuemetrics. This leaves the realtime page in Queuemetrics with a flood of calls running up time even though the call has already ended. As far as I can see, it's because Vicidial is not sending correct entries in the Queue_log file in queuemetrics to say call has completed. The CALLSTATUS also does not get sent correctly either.
Dialing a manual call however, does not have this issue. Call is closed correctly and dispo is sent properly.
When Campaign is running on Autodial, the issue occurs.
After waiting a long time, eventually calls complete and show in Queuemetrics reports, however the Status Code (Disposition) is either blank or incorrect.
After checking, it seems the script on vicidial side seems to do a cleanup but not properly (/usr/share/astguiclient/AST_cleanup_agent_log.pl)
Calls then have ERI as dispo code after script runs.



Vicidial = VERSION: 2.14-669a
BUILD: 180411-1647

Queuemetrics = QueueMetrics - 21.04.8

Vicidial has been installed on top of Goautodial 4 (Which was built from Scratch on Centos 7 = https://goautodial.org/projects/goautod ... _CentOS_7X )
Using steps https://goautodial.org/boards/3/topics/18504

Has anyone came across this issue before? I've read everywhere and can't seem to figure out where the issue occurs.
Any input appreciated.

[mflorell]

First of all, I strongly recommend upgrading your VICIdial system. That version is over 3 years old and there are known security issues in it, there are also QM fixes within the last 3 years that you do not have.

As for your issue, did you add the crontab entries as detailed in the doc?
http://vicidial.org/docs/QUEUEMETRICS.txt

[ztec_za]

I've made sure all cron jobs are correct.
I tried updating by doing the following:
svn checkout svn://svn.eflo.net:3690/agc_2-X/trunk
cd /usr/src/astguiclient/trunk
perl install.pl

It seemed to have broken something. I got locked out with a admin user that worked before. I reset the pass through mysql and was able to login again.
However, now I cannot view any users or campaigns. I also can't change my own permissions either.

[mflorell]

Did you follow all of the instructions in the top of the "UPGRADE" document?

[ztec_za]

Yes I did, I restored the server to before the upgrade. Followed instructions doing the db_schema upgrades first then running install.pl to perform upgrade.
No errors occurred, but now I cannot login. Even after setting pass in the "pass" field of the vicidial_users table.

[mflorell]

Do you see any errors in the apache error_log?

[ztec_za]

Firstly, thanks so much for your assistance thus far. Very much appreciated.

I'm seeing this in the http error logs :

[Tue Jan 04 16:59:34.407530 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: waitforsilence_options in /var/www/html/vicidial/admin.php on line 4068
[Tue Jan 04 16:59:34.407539 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: no_agent_action_value in /var/www/html/vicidial/admin.php on line 4071
[Tue Jan 04 16:59:34.407547 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: areacode_filter_action_value in /var/www/html/vicidial/admin.php on line 4072
[Tue Jan 04 16:59:34.407550 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: vdc_header_date_format in /var/www/html/vicidial/admin.php on line 4075
[Tue Jan 04 16:59:34.407558 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: vdc_customer_date_format in /var/www/html/vicidial/admin.php on line 4076
[Tue Jan 04 16:59:34.407561 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: menu_name in /var/www/html/vicidial/admin.php on line 4077
[Tue Jan 04 16:59:34.407563 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: vdc_header_phone_format in /var/www/html/vicidial/admin.php on line 4080
[Tue Jan 04 16:59:34.407571 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: areacode_list in /var/www/html/vicidial/admin.php on line 4083
[Tue Jan 04 16:59:34.407579 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: ip_address in /var/www/html/vicidial/admin.php on line 4086
[Tue Jan 04 16:59:34.407592 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: lead_filter_sql in /var/www/html/vicidial/admin.php on line 4803
[Tue Jan 04 16:59:34.407602 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: list_mix_container in /var/www/html/vicidial/admin.php on line 4804
[Tue Jan 04 16:59:34.407604 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: survey_response_digit_map in /var/www/html/vicidial/admin.php on line 4805
[Tue Jan 04 16:59:34.407607 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: survey_camp_record_dir in /var/www/html/vicidial/admin.php on line 4806
[Tue Jan 04 16:59:34.407610 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: conf_override in /var/www/html/vicidial/admin.php on line 4807
[Tue Jan 04 16:59:34.407612 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: template_contents in /var/www/html/vicidial/admin.php on line 4808
[Tue Jan 04 16:59:34.407615 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: registration_string in /var/www/html/vicidial/admin.php on line 4809
[Tue Jan 04 16:59:34.407617 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: account_entry in /var/www/html/vicidial/admin.php on line 4810
[Tue Jan 04 16:59:34.407626 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: globals_string in /var/www/html/vicidial/admin.php on line 4812
[Tue Jan 04 16:59:34.407629 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: dialplan_entry in /var/www/html/vicidial/admin.php on line 4813
[Tue Jan 04 16:59:34.407640 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: custom_dialplan_entry in /var/www/html/vicidial/admin.php on line 4816
[Tue Jan 04 16:59:34.407642 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: tts_text in /var/www/html/vicidial/admin.php on line 4819
[Tue Jan 04 16:59:34.407651 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: carrier_description in /var/www/html/vicidial/admin.php on line 4823
[Tue Jan 04 16:59:34.407654 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: blind_monitor_message in /var/www/html/vicidial/admin.php on line 4827
[Tue Jan 04 16:59:34.407658 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: modify_url in /var/www/html/vicidial/admin.php on line 4831
[Tue Jan 04 16:59:34.407661 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: qualify_sql in /var/www/html/vicidial/admin.php on line 4835
[Tue Jan 04 16:59:34.407664 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: queuemetrics_socket_url in /var/www/html/vicidial/admin.php on line 4839
[Tue Jan 04 16:59:34.407666 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: agent_status_viewable_groups in /var/www/html/vicidial/admin.php on line 4843
[Tue Jan 04 16:59:34.407669 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: agent_allowed_chat_groups in /var/www/html/vicidial/admin.php on line 4845
[Tue Jan 04 16:59:34.407671 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: report_url in /var/www/html/vicidial/admin.php on line 4847
[Tue Jan 04 16:59:34.407684 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: agent_push_url in /var/www/html/vicidial/admin.php on line 4851
[Tue Jan 04 16:59:34.407687 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: waiting_call_url_on in /var/www/html/vicidial/admin.php on line 4855
[Tue Jan 04 16:59:34.407690 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: waiting_call_url_off in /var/www/html/vicidial/admin.php on line 4859
[Tue Jan 04 16:59:34.407692 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: sounds_web_server in /var/www/html/vicidial/admin.php on line 4863
[Tue Jan 04 16:59:34.407695 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: script_text in /var/www/html/vicidial/admin.php on line 4901
[Tue Jan 04 16:59:34.410014 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: DB in /var/www/html/vicidial/admin.php on line 5813
[Tue Jan 04 16:59:34.410287 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: force_logout in /var/www/html/vicidial/admin.php on line 5823
[Tue Jan 04 16:59:34.410368 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: DB in /var/www/html/vicidial/admin.php on line 5896
[Tue Jan 04 16:59:34.410441 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: DB in /var/www/html/vicidial/functions.php on line 54
[Tue Jan 04 16:59:34.750522 2022] [:error] [pid 15606] [client xxx:56254] PHP Notice: Undefined variable: DB in /var/www/html/vicidial/functions.php on line 102

[mflorell]

Do you have anything other than "PHP Notice"s in your error_log? Because those will not cause a page load to fail, we usually ignore them.

[carpenox]

Did u run the mysql update after svn update?