Hello,
Most parts of Analytics are working fine but we couldn’t be able to make Content Reports to update. Plays, drop-offs and so on are not updated. Bandwidth, used storage and so on are working fine though. Anything wrong on our side ?
Statistics for partners in the KAC are not updated as well while data in KMC (individual accounts) seems to reported fine.
We are using Kaltura 13.2 and no errors are reported into the logs. We chased and squashed all errors that were being reported into the logs and now we have no errors there. However, we still have no data.
Any hint about what could be wrong with our installation ?
Thanks,
How long have you waited for analytics to be processed? Some are only updated once per day.
There are no overt errors that appear in t /opt/kaltura/dwh/logs?
Hi Daniel
jess
September 29, 2017, 1:47pm
4
Hello @petruzzo79 ,
Start by going over https://github.com/kaltura/platform-install-packages/blob/Mercury-13.4.0/doc/kaltura-packages-faq.md#analytics-issues and confirming that everything is set up correctly.
Also, verify that your DB time zone settings are the same as the machine’s TZ and the value of the PHP date.timezone directive.
Hello @jess
select * from kalturadw_ds.locks ;
cat /opt/kaltura/log/kaltura_apache_access.log |grep “service=stats&action=collect” |wc -l
jess
September 29, 2017, 2:18pm
6
/opt/kaltura/log/kaltura_apache_access.log is the Apache access log on a given node but are they correctly rotated to /opt/kaltura/web/logs/?
This should be done by /etc/logrotate.d/kaltura_apache:
/opt/kaltura/log/kaltura_apache_access.log {
rotate 5
daily
missingok
compress
dateext
notifempty
lastaction
mv /opt/kaltura/log/kaltura_apache_access.log-`/bin/date +%Y%m%d`.gz /opt/kaltura/web/logs/`hostname`-kaltura_apache_access.log-`/bin/date +%Y%m%d-%H`.gz
service apache2 reload
endscript
su root kaltura
}
cat /etc/logrotate.d/kaltura_apache
/opt/kaltura/log/kaltura_apache_access.log {/bin/date +%Y%m%d.gz /opt/kaltura/web/logs/hostname-kaltura_apache_access.log-/bin/date +%Y%m%d-%H.gz
jess
September 29, 2017, 2:34pm
8
What’s the output for:
mysql> select * from kalturadw.dwh_fact_events where event_date_id >=%Y%m%d ;
the output is (compressed)
select file_id,event_id,event_type_id,event_date_id from kalturadw.dwh_fact_events where event_date_id >= 20170927;
[edit]full output
