No STATISTIC FOR SYSTEM

All installation and configuration problems and questions

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

No STATISTIC FOR SYSTEM

Postby brando16 » Fri May 18, 2018 6:23 am

Hi all,

a few day the vicidial statistic global does not work anymore!!! the image was attached.

anyone have some ideas?

Thanks in advantages!!
Vicibox VERSION: 2.14-580a | BUILD: 161029-2304 | OpenSuSE v.42.1 64-bit | Kernel v.4.1.13 | Asterisk v.11.25.1-vici | DAHDI v.2.10.2 | LibPRI v.1.4.14 | Amfletec VoiceSync v.1.3.8 | ViciDial SVN Trunk v.2.12-533a build 161205-1650 revision 2461
brando16
 
Posts: 88
Joined: Tue Jul 30, 2013 11:00 am

Re: No STATISTIC FOR SYSTEM

Postby mflorell » Fri May 18, 2018 7:03 am

There is no image attached.

Please explain in more detail what "vicidial statistic global" is, I am unfamiliar with that term.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: No STATISTIC FOR SYSTEM

Postby brando16 » Fri May 18, 2018 7:48 am

ok you have right! :lol: i explain in detail... :lol:

when you log in the first page you visualize report some data whitin yesterday and today data we haven't this data. Appear "NO ACTIVITY FOR...."
Vicibox VERSION: 2.14-580a | BUILD: 161029-2304 | OpenSuSE v.42.1 64-bit | Kernel v.4.1.13 | Asterisk v.11.25.1-vici | DAHDI v.2.10.2 | LibPRI v.1.4.14 | Amfletec VoiceSync v.1.3.8 | ViciDial SVN Trunk v.2.12-533a build 161205-1650 revision 2461
brando16
 
Posts: 88
Joined: Tue Jul 30, 2013 11:00 am

Re: No STATISTIC FOR SYSTEM

Postby blackbird2306 » Fri May 18, 2018 10:45 am

Admin --> System Settings --> Make sure that the Voicemail server is set correctly to the right server!
Vicibox 6.0.2 from Vicibox_v.6.0.x86_64-6.0.2.iso | Vicidial 2.12-560a build: 160617-1427 | Asterisk 1.8.32.3
blackbird2306
 
Posts: 409
Joined: Mon Jun 23, 2014 5:31 pm

Re: No STATISTIC FOR SYSTEM

Postby brando16 » Fri May 18, 2018 10:49 am

Voicemail Server is set to an dialer server,it's correct? how to configure correct?
Vicibox VERSION: 2.14-580a | BUILD: 161029-2304 | OpenSuSE v.42.1 64-bit | Kernel v.4.1.13 | Asterisk v.11.25.1-vici | DAHDI v.2.10.2 | LibPRI v.1.4.14 | Amfletec VoiceSync v.1.3.8 | ViciDial SVN Trunk v.2.12-533a build 161205-1650 revision 2461
brando16
 
Posts: 88
Joined: Tue Jul 30, 2013 11:00 am

Re: No STATISTIC FOR SYSTEM

Postby blackbird2306 » Fri May 18, 2018 11:15 am

Setting it to a valid dialer is correct. Try to force a dialplan reload in system settings (set "Reload Dialplan On Servers" to 1 and submit) and then restart/reboot system after a while.
Vicibox 6.0.2 from Vicibox_v.6.0.x86_64-6.0.2.iso | Vicidial 2.12-560a build: 160617-1427 | Asterisk 1.8.32.3
blackbird2306
 
Posts: 409
Joined: Mon Jun 23, 2014 5:31 pm

Re: No STATISTIC FOR SYSTEM

Postby brando16 » Tue May 22, 2018 3:32 am

I do what you tell me but the NO ACTIVITY... rest.

any idea I set the voicemail server with the right dialer and then after 4/5 hours i reboot the system.
Vicibox VERSION: 2.14-580a | BUILD: 161029-2304 | OpenSuSE v.42.1 64-bit | Kernel v.4.1.13 | Asterisk v.11.25.1-vici | DAHDI v.2.10.2 | LibPRI v.1.4.14 | Amfletec VoiceSync v.1.3.8 | ViciDial SVN Trunk v.2.12-533a build 161205-1650 revision 2461
brando16
 
Posts: 88
Joined: Tue Jul 30, 2013 11:00 am

Re: No STATISTIC FOR SYSTEM

Postby blackbird2306 » Wed May 23, 2018 8:26 am

What is output of (in linux cli):
Code: Select all
mysql -D asterisk -e 'SELECT * FROM `vicidial_daily_max_stats` ORDER BY `update_time` desc limit 20;'

Another possible thing is a configuration issue with timezone and local time settings.
Vicibox 6.0.2 from Vicibox_v.6.0.x86_64-6.0.2.iso | Vicidial 2.12-560a build: 160617-1427 | Asterisk 1.8.32.3
blackbird2306
 
Posts: 409
Joined: Mon Jun 23, 2014 5:31 pm

Re: No STATISTIC FOR SYSTEM

Postby brando16 » Wed May 23, 2018 10:32 am

I retrieve this from your query

Code: Select all
| stats_date | stats_flag | stats_type | campaign_id       | update_time         | closed_time | max_channels | max_calls | max_inbound | max_outbound | max_agents | max_remote_agents | total_calls |
+------------+------------+------------+-------------------+---------------------+-------------+--------------+-----------+-------------+--------------+------------+-------------------+-------------+
| 2018-05-22 | OPEN       | INGROUP    | ING_FIN_PHC03     | 2018-05-23 17:29:04 | NULL        |            0 |         0 |           8 |            0 |         15 |                 0 |         440 |
| 2018-05-23 | OPEN       | CAMPAIGN   | AnconaPh          | 2018-05-23 17:28:30 | NULL        |            0 |         0 |           0 |            6 |          9 |                 0 |         648 |
| 2018-05-22 | OPEN       | INGROUP    | ING00017          | 2018-05-23 17:27:40 | NULL        |            0 |         0 |          10 |            0 |         20 |                 0 |         617 |
| 2018-05-22 | OPEN       | INGROUP    | AGENTDIRECT       | 2018-05-23 17:27:39 | NULL        |            0 |         0 |           4 |            0 |         73 |                 0 |          71 |
| 2018-05-23 | OPEN       | CAMPAIGN   | MultiCca          | 2018-05-23 17:26:39 | NULL        |            0 |         0 |           0 |          203 |         39 |                 0 |       16572 |
| 2018-05-23 | OPEN       | CAMPAIGN   | bites_ma          | 2018-05-23 17:25:08 | NULL        |            0 |         0 |           0 |           14 |         31 |                 0 |        4180 |
| 2018-05-23 | OPEN       | CAMPAIGN   | SEnelADR          | 2018-05-23 17:24:59 | NULL        |            0 |         0 |           0 |           22 |          1 |                 0 |        7817 |
| 2018-05-22 | OPEN       | INGROUP    | 86023             | 2018-05-23 17:23:54 | NULL        |            0 |         0 |           6 |            0 |         26 |                 0 |         210 |
| 2018-05-23 | OPEN       | CAMPAIGN   | cca_mul2          | 2018-05-23 17:23:24 | NULL        |            0 |         0 |           0 |          184 |         39 |                 0 |       27030 |
| 2018-05-23 | OPEN       | CAMPAIGN   | PHC03_NP          | 2018-05-23 17:20:24 | NULL        |            0 |         0 |           0 |           26 |         30 |                 0 |        3119 |
| 2018-05-22 | OPEN       | INGROUP    | ING_GEST_IRC      | 2018-05-23 17:19:49 | NULL        |            0 |         0 |           4 |            0 |         10 |                 0 |         121 |
| 2018-05-22 | OPEN       | INGROUP    | ING86016          | 2018-05-23 17:19:49 | NULL        |            0 |         0 |           1 |            0 |          3 |                 0 |           3 |
| 2018-05-22 | OPEN       | CAMPAIGN   | Mona2CCA          | 2018-05-23 17:11:02 | NULL        |            0 |         0 |           0 |            0 |          8 |                 0 |           4 |
| 2018-05-22 | OPEN       | INGROUP    | 86025             | 2018-05-23 17:09:22 | NULL        |            0 |         0 |           1 |            0 |          2 |                 0 |           5 |
| 2018-05-22 | OPEN       | INGROUP    | Ing13_ORD         | 2018-05-23 17:09:11 | NULL        |            0 |         0 |          11 |            0 |         26 |                 0 |         928 |
| 2018-05-23 | OPEN       | CAMPAIGN   | Post_Esa          | 2018-05-23 16:57:16 | NULL        |            0 |         0 |           0 |            3 |          2 |                 0 |          58 |
| 2018-05-22 | OPEN       | INGROUP    | ING_ESTRA_ENERGIE | 2018-05-23 16:53:50 | NULL        |            0 |         0 |           3 |            0 |          4 |                 0 |          30 |
| 2018-05-22 | OPEN       | CAMPAIGN   | Enel_Sof          | 2018-05-23 16:49:20 | NULL        |            0 |         0 |           0 |           22 |         29 |                 0 |        7926 |
| 2018-05-22 | OPEN       | INGROUP    | ING86012          | 2018-05-23 16:43:06 | NULL        |            0 |         0 |          13 |            0 |          5 |                 0 |        1099 |
| 2018-05-23 | OPEN       | CAMPAIGN   | ENERGIE           | 2018-05-23 16:18:52 | NULL        |            0 |         0 |           0 |            4 |          4 |                 0 |         391


We are configured all server to sync time on sql server. how do you mean?
with timezone and local time settings


thanks
Vicibox VERSION: 2.14-580a | BUILD: 161029-2304 | OpenSuSE v.42.1 64-bit | Kernel v.4.1.13 | Asterisk v.11.25.1-vici | DAHDI v.2.10.2 | LibPRI v.1.4.14 | Amfletec VoiceSync v.1.3.8 | ViciDial SVN Trunk v.2.12-533a build 161205-1650 revision 2461
brando16
 
Posts: 88
Joined: Tue Jul 30, 2013 11:00 am

Re: No STATISTIC FOR SYSTEM

Postby brando16 » Thu May 24, 2018 2:17 am

I do what you tell me but the statistic appers only for yesterday and for today nothing appers. The data are not correct, the number of max agents doesn't correct.

other suggestion?
Vicibox VERSION: 2.14-580a | BUILD: 161029-2304 | OpenSuSE v.42.1 64-bit | Kernel v.4.1.13 | Asterisk v.11.25.1-vici | DAHDI v.2.10.2 | LibPRI v.1.4.14 | Amfletec VoiceSync v.1.3.8 | ViciDial SVN Trunk v.2.12-533a build 161205-1650 revision 2461
brando16
 
Posts: 88
Joined: Tue Jul 30, 2013 11:00 am

Re: No STATISTIC FOR SYSTEM

Postby blackbird2306 » Thu May 24, 2018 4:56 am

As you can see on your posted table the calls were populated, but somehow the ADMIN_keepalive.pl process won't set the stats_flag='CLOSED'. They are all 'OPEN'. Further the row with daily 'TOTAL' seems to be missing (a reason for your symptom "No activity for...") . Possible reasons:
1. active_voicemail_server is not set to the right one
2. "Timeclock End Of Day" in system settings is not correct
3. time settings configuration issue
4. admin keepalive process doesn't start at certain times (or at all)
Post us from "/etc/astguiclient.conf" file the variables starting with "VARserver_ip" => and "VARactive_keepalives"

and from linux cli:
mysql -D asterisk -e 'SELECT `active_voicemail_server`,`timeclock_end_of_day`,`timeclock_last_reset_date` FROM `system_settings`;'

and crontab settings (from cli):
crontab -l
Vicibox 6.0.2 from Vicibox_v.6.0.x86_64-6.0.2.iso | Vicidial 2.12-560a build: 160617-1427 | Asterisk 1.8.32.3
blackbird2306
 
Posts: 409
Joined: Mon Jun 23, 2014 5:31 pm

Re: No STATISTIC FOR SYSTEM

Postby brando16 » Thu May 24, 2018 10:30 am

astguiclient.conf(new server):

VARserver_ip => ip correct of this server
VARactive_keepalives => 123468



output of query (Mysql master server):

Code: Select all
+-------------------------+----------------------+---------------------------+
| active_voicemail_server | timeclock_end_of_day | timeclock_last_reset_date |
+-------------------------+----------------------+---------------------------+
| 192.168.100.65          | 2100                 | 2018-05-23                |
+-------------------------+----------------------+---------------------------+


In effect this ip of voicemail server is the ip of new server and I set another ip from vicidial interface this is the problem?

crontab -l (new server):

Code: Select all
# DO NOT EDIT THIS FILE - edit the master and reinstall.
# (/tmp/rootcron installed on Wed May 23 14:28:44 2018)
# (Cronie version 4.2)
### keepalive script for astguiclient processes
* * * * * /usr/share/astguiclient/ADMIN_keepalive_ALL.pl

### Compress log files and remove the really old ones
25 2 * * * /usr/bin/find /var/log/astguiclient -maxdepth 1 -type f -mtime +1 -print | grep -v \.gz | xargs gzip -9 >/dev/null 2>&1
30 2 * * * /usr/bin/find /var/log/astguiclient -maxdepth 1 -type f -mtime 1 -print | grep -v \.gz | xargs gzip -9 >/dev/null 2>&1
28 0 * * * /usr/bin/find /var/log/astguiclient -maxdepth 1 -type f -mtime +30 -print | xargs rm -f
30 0 * * * /usr/bin/find / -maxdepth 1 -name "screenlog.0*" -mtime +30 -print | xargs rm -f
35 2 * * * /usr/bin/find /var/log/asterisk -maxdepth 1 -type f -mtime +1 -print | grep -v \.gz | xargs gzip -9 >/dev/null 2>&1
40 2 * * * /usr/bin/find /var/log/asterisk -maxdepth 1 -type f -mtime 1 -print | grep -v \.gz | xargs gzip -9 >/dev/null 2>&1
29 0 * * * /usr/bin/find /var/log/asterisk -maxdepth 3 -type f -mtime +30 -print | xargs rm -f

### recording mixing/compressing/ftping scripts
#0,3,6,9,12,15,18,21,24,27,30,33,36,39,42,45,48,51,54,57 * * * * /usr/share/astguiclient/AST_CRON_audio_1_move_mix.pl
0,3,6,9,12,15,18,21,24,27,30,33,36,39,42,45,48,51,54,57 * * * * /usr/share/astguiclient/AST_CRON_audio_1_move_mix.pl --MIX
0,3,6,9,12,15,18,21,24,27,30,33,36,39,42,45,48,51,54,57 * * * * /usr/share/astguiclient/AST_CRON_audio_1_move_VDonly.pl
1,4,7,10,13,16,19,22,25,28,31,34,37,40,43,46,49,52,55,58 * * * * /usr/share/astguiclient/AST_CRON_audio_2_compress.pl --MP3
2,5,8,11,14,17,20,23,26,29,32,35,38,41,44,47,50,53,56,59 * * * * /usr/share/astguiclient/AST_CRON_audio_3_ftp.pl --MP3
#0 1 * * * /usr/share/astguiclient/AST_CRON_audio_4_ftp2.pl --ftp-server=server.ip --ftp-login=user --ftp-pass=pass --ftp-directory=/ --ftp-persistent --ftp-validate --transfer-limit=100000 --list-limit=100000

### remove old recordings more than 7 days old, and delete originals after 1 day
#24 0 * * * /usr/bin/find /var/spool/asterisk/monitorDONE -maxdepth 2 -type f -mtime +7 -print | xargs rm -f
24 1 * * * /usr/bin/find /var/spool/asterisk/monitorDONE/ORIG -maxdepth 2 -type f -mtime +1 -print | xargs rm -f

### kill Hangup script for Asterisk updaters
* * * * * /usr/share/astguiclient/AST_manager_kill_hung_congested.pl

### updater for voicemail
* * * * * /usr/share/astguiclient/AST_vm_update.pl

### updater for conference validator
* * * * * /usr/share/astguiclient/AST_conf_update.pl

### reset several temporary-info tables in the database
2 1 * * * /usr/share/astguiclient/AST_reset_mysql_vars.pl

### Reboot nightly to manage asterisk issues and memory leaks - uncomment if issues arise
#30 6 * * * /sbin/reboot

### remove text to speech file more than 4 days old
#20 0 * * * /usr/bin/find /var/lib/asterisk/sounds/tts/ -maxdepth 2 -type f -mtime +4 -print | xargs rm -f

## uncomment below if you want to log agent phone_ip
#*/5 * * * * /usr/share/astguiclient/AST_phone_update.pl --agent-lookup



I hope this is clear

thanks
Vicibox VERSION: 2.14-580a | BUILD: 161029-2304 | OpenSuSE v.42.1 64-bit | Kernel v.4.1.13 | Asterisk v.11.25.1-vici | DAHDI v.2.10.2 | LibPRI v.1.4.14 | Amfletec VoiceSync v.1.3.8 | ViciDial SVN Trunk v.2.12-533a build 161205-1650 revision 2461
brando16
 
Posts: 88
Joined: Tue Jul 30, 2013 11:00 am

Re: No STATISTIC FOR SYSTEM

Postby blackbird2306 » Thu May 24, 2018 7:52 pm

I think somehow there is in admin keepalive a missing process. The "AST_VDadapt.pl" script gathers the daily total stats for the actual "today" part. I've just read in another post, that you have problems with dialing on a new server. Please change the "/etc/astguiclient.conf" file just for testing purposes (add "5" / ignore: this must only be on one server in your cluster):
Code: Select all
VARactive_keepalives => 1234568

In addition change the system setting "Timeclock End Of Day" to default 0000
Vicibox 6.0.2 from Vicibox_v.6.0.x86_64-6.0.2.iso | Vicidial 2.12-560a build: 160617-1427 | Asterisk 1.8.32.3
blackbird2306
 
Posts: 409
Joined: Mon Jun 23, 2014 5:31 pm


Return to Support

Who is online

Users browsing this forum: Bing [Bot], Google [Bot], njr and 88 guests