Hello
I’ve got a working kaltura CE working on a allinone server with SSL
I can upload a video, watch it from the flavor tab and i can also embed the code on an external server fine. The problem is that the analytics from playing the video are not showing up anywhere.
I started to follow the analytics troubleshooting from here: https://github.com/kaltura/platform-install-packages/blob/Propus-16.8.0/doc/kaltura-packages-faq.md#analytics-issues The first step is to check if you have the following pattern
[service=stats&action=collect]
in the [/opt/kaltura/log/kaltura_apache_access.log] file
tail -f ./kaltura_apache_access_ssl.log | grep “api_v3/index.php?service=”
The above is giving me the following:
- /api_v3/index.php?service=multirequest&
- /api_v3/index.php?service=uiconf
- /api_v3/index.php?service=session&
but no /api_v3/index.php?service=stats
It’s not even getting to the cron job steps.
I also did the following, just in case:
MariaDB [(none)]> select * from kalturadw_ds.locks ; +---------+----------------+-----------+------------+ | lock_id | lock_name | lock_time | lock_state | +---------+----------------+-----------+------------+ | 1 | daily_lock | NULL | 0 | | 2 | retention_lock | NULL | 0 | +---------+----------------+-----------+------------+ 2 rows in set (0.00 sec)
No lock as per the above
MariaDB [(none)]> select * from kalturadw_ds.files; Empty set (0.00 sec)
No access files as per the above
MariaDB [(none)]> select * from kalturadw.dwh_fact_events; Empty set (0.01 sec)
Nothing in the above
Executed /opt/kaltura/bin/kaltura-run-dwh.sh
[root@kaltura-dev-v5 log]# sh /opt/kaltura/bin/kaltura-run-dwh.sh reading config file /etc/logrotate.d/kaltura_apache Allocating hash table for state file, size 15360 B Handling 4 logs rotating pattern: /opt/kaltura/log/kaltura_apache_errors.log forced from command line (5 rotations) empty log files are not rotated, old logs are removed switching euid to 0 and egid to 7373 considering log /opt/kaltura/log/kaltura_apache_errors.log log /opt/kaltura/log/kaltura_apache_errors.log does not exist -- skipping not running postrotate script, since no logs were rotated switching euid to 0 and egid to 0 rotating pattern: /opt/kaltura/log/kaltura_apache_access.log forced from command line (5 rotations) empty log files are not rotated, old logs are removed switching euid to 0 and egid to 7373 considering log /opt/kaltura/log/kaltura_apache_access.log log /opt/kaltura/log/kaltura_apache_access.log does not exist -- skipping not running last action script, since no logs will be rotated switching euid to 0 and egid to 0 rotating pattern: /opt/kaltura/log/kaltura_apache_errors_ssl.log forced from command line (5 rotations) empty log files are not rotated, old logs are removed switching euid to 0 and egid to 7373 considering log /opt/kaltura/log/kaltura_apache_errors_ssl.log log does not need rotating (log is empty)not running postrotate script, since no logs were rotated switching euid to 0 and egid to 0 rotating pattern: /opt/kaltura/log/kaltura_apache_access_ssl.log forced from command line (5 rotations) empty log files are not rotated, old logs are removed switching euid to 0 and egid to 7373 considering log /opt/kaltura/log/kaltura_apache_access_ssl.log log needs rotating rotating log /opt/kaltura/log/kaltura_apache_access_ssl.log, log->rotateCount is 5 dateext suffix '-20201013' glob pattern '-[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]' glob finding old rotated logs failed fscreate context set to system_u:object_r:usr_t:s0 renaming /opt/kaltura/log/kaltura_apache_access_ssl.log to /opt/kaltura/log/kaltura_apache_access_ssl.log-20201013 compressing log with: /bin/gzip set default create context to system_u:object_r:usr_t:s0 switching uid to 0 and gid to 7373 running last action script switching euid to 0 and egid to 0 Redirecting to /bin/systemctl reload httpd.service switching euid to 0 and egid to 0 set default create context bash: /opt/kaltura/log/cron.log: Permission denied
After all did, i loaded a page on the external server that contained the embed video, played it until the end, here’s the output of
tail -f ./kaltura_apache_access_ssl.log | grep “api_v3/index.php?service=”
XX.XX.XX.XX - - [13/Oct/2020:19:21:10 +0000] “GET /api_v3/index.php?service=session&action=startWidgetSession&apiVersion=3.1.6&format=3&clientTag=html5iframe%3A2.83%2Ccache_st%3A+&ignoreNull=1&widgetId=_102&expiry=86400&kalsig=cdee821915cc16bcc4cddc433961ec77 HTTP/1.1” 200 4065 0/36366 “-” “curl/7.11.1” “-” XX.XX.XX.XX “-” “kaltura-dev-v5.cXXXXX.com” 6976 992883017 + 832 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -
XX.XX.XX.XX - - [13/Oct/2020:19:21:10 +0000] “GET /api_v3/index.php?service=uiconf&action=get&apiVersion=3.1.6&format=3&clientTag=html5iframe%3A2.83%2Ccache_st%3A+&ignoreNull=1&id=23
448172&ks=OWUyZGViNmJjMzgwY2I1NmY2M2E4MDk4MDQ2NDFkZDBmNTRhYjA5MXwxMDI7MTAyOzE2MDI3MDMyNzA7MDsxNjAyNjE2ODcwLjgwMjM7MDt2aWV3Oiosd2lkZ2V0OjE7Ow%3D%3D&kalsig=27ba17af95718bc6bcf66c538535f
fd1 HTTP/1.1” 200 4364 0/74407 “-” “curl/7.11.1” “-” XX.XX.XX.XX “-” “kaltura-dev-v5.cXXXXX.com” 7004 1362788776 + 941 “-” “-” “-” “-” “no-store, no-cache, must
-revalidate, post-check=0, pre-check=0” 102
XX.XX.XX.XX - - [13/Oct/2020:19:21:11 +0000] “GET /api_v3/index.php?service=session&action=startWidgetSession&apiVersion=3.1.6&format=3&clientTag=html5iframe%3A2.83%2Ccache_st%3A+160
2616471&ignoreNull=1&widgetId=_102&expiry=86400&kalsig=a93cfe1e2bd1e6a5f193c2ec31b016fd HTTP/1.1” 200 4063 0/13557 “-” “Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/85.0.4183.121 Safari/537.36” “-” XX.XX.XX.XX “-” “kaltura-dev-v5.cXXXXX.com” 7004 116984674 + 936 “-” “-” “-” “-” “no-store, no-cache, must-reval
idate, post-check=0, pre-check=0” -
XX.XX.XX.XX - - [13/Oct/2020:19:21:11 +0000] “GET /api_v3/index.php?service=multirequest&apiVersion=3.1.6&format=3&clientTag=html5iframe%3A2.83%2Ccache_st%3A+1602616471&ignoreNull=1&
1%3Aservice=baseEntry&1%3Aaction=list&1%3Afilter%3AobjectType=KalturaBaseEntryFilter&1%3Afilter%3AredirectFromEntryId=0_3z3s914c&1%3AresponseProfile%3Atype=2&1%3AresponseProfile%3Afie
lds=userId%2CcreatorId&1%3Aks=ZDJmODZjN2ZlNTU2MTcyMzk3MDc2YjBkYmIwNmQ0OWNhZjkyODFjM3wxMDI7MTAyOzE2MDI3MDMyNzE7MDsxNjAyNjE2ODcxLjE0NTU7MDt2aWV3Oiosd2lkZ2V0OjE7Ow%3D%3D&2%3Aservice=base
Entry&2%3Aaction=getContextData&2%3AcontextDataParams%3AobjectType=KalturaEntryContextDataParams&2%3AcontextDataParams%3AflavorTags=all&2%3AcontextDataParams%3Areferrer=https%3A%2F%2F
lp-web-dXXXXX.com%2F&2%3AcontextDataParams%3AuserAgent=Mozilla%2F5.0+%28X11%3B+Linux+x86_64%29+AppleWebKit%2F537.36+%28KHTML%2C+like+Gecko%29+Chrome%2F85.0.
4183.121+Safari%2F537.36&2%3AentryId=%7B1%3Aresult%3Aobjects%3A0%3Aid%7D&2%3Aks=ZDJmODZjN2ZlNTU2MTcyMzk3MDc2YjBkYmIwNmQ0OWNhZjkyODFjM3wxMDI7MTAyOzE2MDI3MDMyNzE7MDsxNjAyNjE2ODcxLjE0NTU
7MDt2aWV3Oiosd2lkZ2V0OjE7Ow%3D%3D&3%3Aservice=metadata_metadata&3%3Aaction=list&3%3Afilter%3AobjectType=KalturaMetadataFilter&3%3Afilter%3AmetadataObjectTypeEqual=1&3%3Afilter%3Aobjec
tIdEqual=%7B1%3Aresult%3Aobjects%3A0%3Aid%7D&3%3Afilter%3AorderBy=%2BcreatedAt&3%3A0=metadataPager&3%3A1%3AobjectType=KalturaFilterPager&3%3A1%3ApageSize=1&3%3Aks=ZDJmODZjN2ZlNTU2MTcy
Mzk3MDc2YjBkYmIwNmQ0OWNhZjkyODFjM3wxMDI7MTAyOzE2MDI3MDMyNzE7MDsxNjAyNjE2ODcxLjE0NTU7MDt2aWV3Oiosd2lkZ2V0OjE7Ow%3D%3D&4%3Aservice=cuepoint_cuepoint&4%3Aaction=list&4%3Afilter%3AobjectT
ype=KalturaCuePointFilter&4%3Afilter%3AentryIdEqual=%7B1%3Aresult%3Aobjects%3A0%3Aid%7D&4%3Afilter%3AorderBy=%2BstartTime&4%3Aks=ZDJmODZjN2ZlNTU2MTcyMzk3MDc2YjBkYmIwNmQ0OWNhZjkyODFjM3
wxMDI7MTAyOzE2MDI3MDMyNzE7MDsxNjAyNjE2ODcxLjE0NTU7MDt2aWV3Oiosd2lkZ2V0OjE7Ow%3D%3D&kalsig=0a989009578424984250a2a202edcf9d HTTP/1.1” 200 5446 0/179103 “-” “Mozilla/5.0 (X11; Linux x86
_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.121 Safari/537.36” “-”
XX.XX.XX.XX “-” “kaltura-dev-v5.cXXXXX.com” 6977 1550467901 + 2618 “-” “-” "
-" “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” 102
I got 4 entry that contained the api_v3/index.php?service= entry but no service=stats
I saw some troubleshooting steps for cron related problem and DB problem, but not for data missing from the log file.
I’ve found a post that had a similar problem, but his got fixed without an explanation.
Has anybody experienced this before and was able to fix it?
Thank you!