No STATISTIC FOR SYSTEM

[brando16]

Hi all,

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

anyone have some ideas?

Thanks in advantages!!

[mflorell]

There is no image attached.

Please explain in more detail what "vicidial statistic global" is, I am unfamiliar with that term.

[brando16]

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

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...."

[blackbird2306]

Admin --> System Settings --> Make sure that the Voicemail server is set correctly to the right server!

[brando16]

Voicemail Server is set to an dialer server,it's correct? how to configure correct?

[blackbird2306]

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.

[brando16]

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.

[blackbird2306]

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.

[brando16]

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

[brando16]

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?

[blackbird2306]

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

[brando16]

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

[blackbird2306]

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