Analytics data not showing/visible

Hello,

I have installed Kaltura cluster 10.21CE. But I am unable to see any play,views graph in analytics page.
There is no activity in analytics part.

Below is my kaltlog output:-

2015-10-20 22:00:48 [0.000838] [122.184.129.18] [1887709079] [83] [API] [KalturaStatement->execute] DEBUG: Sql took - 0.00069212913513184 seconds
2015-10-20 22:00:48 [0.003485] [122.184.129.18] [1887709079] [84] [API] [DeliveryProfilePeer::getRemoteDeliveryByStorageId] ERR: exception ‘Exception’ with message ‘Delivery ID can’t be determined for storageId [4] ( PartnerId [106] ) and streamer type [ rtmp ]’ in /opt/kaltura/app/infra/log/KalturaLog.php:83
Stack trace:
#0 /opt/kaltura/app/alpha/lib/model/DeliveryProfilePeer.php(270): KalturaLog::err(‘Delivery ID can…’)


2015-10-20 22:01:27 [0.000671] [127.0.0.1] [107045507] [25] [API] [KalturaStatement->execute] DEBUG: Sql took - 0.00052118301391602 seconds
2015-10-20 22:01:27 [0.001612] [127.0.0.1] [107045507] [26] [API] [KalturaFrontController->getExceptionObject] ERR: exception ‘KalturaAPIException’ with message ‘delivery id [1004] is default and can’t be set’ in /opt/kaltura/app/api_v3/services/DeliveryProfileService.php:50
Stack trace:
#0 [internal function]: DeliveryProfileService->updateAction(‘1004’, Object(KalturaDeliveryProfileGenericAppleHttp))

2015-10-20 22:01:27 [0.000098] [1304722956] [31] [%context%] [Kaltura_Client_ClientBase->doQueue] DEBUG: execution time for [http://abc.com/api_v3/index.php?service=deliveryprofile&action=update]: [0.039644002914429]
2015-10-20 22:01:27 [0.003901] [1304722956] [32] [%context%] [ErrorController->errorAction] ERR: exception ‘Kaltura_Client_Exception’ with message ‘delivery id [1004] is default and can’t be set’ in /opt/kaltura/app/admin_console/lib/Kaltura/Client/ParseUtils.php:78
Stack trace:
#0 /opt/kaltura/app/admin_console/lib/Kaltura/Client/DeliveryProfileService.php(67): Kaltura_Client_ParseUtils::checkIfError(Object(SimpleXMLElement))

2015-10-20 22:01:38 [0.000609] [127.0.0.1] [794739193] [25] [API] [KalturaStatement->execute] DEBUG: Sql took - 0.00046586990356445 seconds
2015-10-20 22:01:38 [0.001205] [127.0.0.1] [794739193] [26] [API] [KalturaFrontController->getExceptionObject] ERR: exception ‘KalturaAPIException’ with message ‘delivery id [1004] is default and can’t be set’ in /opt/kaltura/app/api_v3/services/DeliveryProfileService.php:50
Stack trace:
#0 [internal function]: DeliveryProfileService->updateAction(‘1004’, Object(KalturaDeliveryProfile))

2015-10-20 22:01:38 [0.000104] [380255267] [25] [%context%] [Kaltura_Client_ClientBase->doQueue] DEBUG: execution time for [http://abc.com/api_v3/index.php?service=deliveryprofile&action=update]: [0.033416986465454]
2015-10-20 22:01:38 [0.001543] [380255267] [26] [%context%] [ErrorController->errorAction] ERR: exception ‘Kaltura_Client_Exception’ with message ‘delivery id [1004] is default and can’t be set’ in /opt/kaltura/app/admin_console/lib/Kaltura/Client/ParseUtils.php:78
Stack trace:
#0 /opt/kaltura/app/admin_console/lib/Kaltura/Client/DeliveryProfileService.php(67): Kaltura_Client_ParseUtils::checkIfError(Object(SimpleXMLElement))

I have also ran these below scripts:

/opt/kaltura/dwh/etlsource/execute/etl_hourly.sh -p /opt/kaltura/dwh -k /opt/kaltura/pentaho/pdi/kitchen.sh
/opt/kaltura/dwh/etlsource/execute/etl_update_dims.sh -p /opt/kaltura/dwh -k /opt/kaltura/pentaho/pdi/kitchen.sh
/opt/kaltura/dwh/etlsource/execute/etl_daily.sh -p /opt/kaltura/dwh -k /opt/kaltura/pentaho/pdi/kitchen.sh
/opt/kaltura/dwh/etlsource/execute/etl_perform_retention_policy.sh -p /opt/kaltura/dwh -k /opt/kaltura/pentaho/pdi/kitchen.sh
/opt/kaltura/app/alpha/scripts/dwh/dwh_plays_views_sync.sh >> /opt/kaltura/log/cron.log

Hello,

Have you played your videos from KMC or from an embedded code? if from KMC, it will not show as these plays are not reported.

Next, when playing from an embed code, check /opt/kaltura/log/kaltura_apache_access.log and ensure you see requests like:
GET //api_v3/index.php?service=stats&action=collect

After you validate that you indeed see these, please paste the output of each query in the troubeshooting section here https://github.com/kaltura/platform-install-packages/blob/Kajam-11.0.0/doc/kaltura-packages-faq.md#analytics-issues and lets see where it goes wrong.
Also, check for errors in the logs:
# grep ERROR /opt/kaltura/dwh/logs/*

Hello Jess,

I have played videos from embedded code but its not showing anything in KMC analytics.

I have checked /opt/kaltura/log/kaltura_apache_access.log and it is not showing requests like:
GET //api_v3/index.php?service=stats&action=collect

But all the output is like this:

122.184.129.18 - - [21/Oct/2015:10:48:34 +0530] “GET /p/101/sp/10100/thumbnail/entry_id/0_7aybl1a6/version/100002/acv/182/bgcolor/F7F7F7/type/2 HTTP/1.1” 200 9359 0/50366 “http://abc.com/index.php/kmc/kmc4” “Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.71 Safari/537.36” “-” 122.184.129.18 “cached-thumb-exists,a4566c1c52491ad15c1d8701eff5b0e7” “abc.com” 15369 1647438231 - 673 “-” “-” “-” “-” “public, max-age=3600, max-stale=0” -
122.184.129.18 - - [21/Oct/2015:10:48:34 +0530] “GET /p/101/sp/10100/thumbnail/entry_id/0_wuesha2w/version/100002/acv/172/bgcolor/F7F7F7/type/2 HTTP/1.1” 200 10291 0/61203 “http://abc.com/index.php/kmc/kmc4” “Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.71 Safari/537.36” “-” 122.184.129.18 “cached-thumb-exists,2289ad6a61804b25e6cbcc7d168b7ba5” “abc.com” 15370 740584557 - 673 “-” “-” “-” “-” “public, max-age=3600, max-stale=0” -
122.184.129.18 - - [21/Oct/2015:10:48:34 +0530] “GET /p/101/sp/10100/thumbnail/entry_id/0_5mzqqmhx/version/100002/acv/192/bgcolor/F7F7F7/type/2 HTTP/1.1” 200 4076 0/58701 “http://abc.com.com/index.php/kmc/kmc4” “Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.71 Safari/537.36” “-” 122.184.129.18 “cached-thumb-exists,71df0666065872f49d3fcf679a7321cd” “abc.com” 23450 981437940 - 673 “-” “-” “-” “-” “public, max-age=3600, max-stale=0” -
127.0.0.1 - - [21/Oct/2015:10:48:40 +0530] “POST /api_v3/index.php?service=system&action=ping HTTP/1.1” 200 477 0/1597 “-” “-” “-” 127.0.0.1 “cached-dispatcher,cache_v3-4573cb1b41aa602d154d9108d17cdd50,0.00017881393432617” “abc.com” 23449 - - 559 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [21/Oct/2015:10:48:40 +0530] “POST /api_v3/index.php?service=batchcontrol&action=reportStatus HTTP/1.1” 200 4213 0/112620 “-” “-” “-” 127.0.0.1 “-” “abc.com” 15368 205797678 - 9455 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1

The output for grep ERROR /opt/kaltura/dwh/logs/* is:
root@dwh ~]# grep ERROR /opt/kaltura/dwh/logs/*
/opt/kaltura/dwh/logs/etl_perform_retention_policy-20151021.log:ERROR 21-10 12:30:19,116 - Move old partitions to archive - An error occurred executing this job entry :
/opt/kaltura/dwh/logs/etl_perform_retention_policy-20151021.log:ERROR 21-10 12:30:19,194 - Kitchen - Finished with errors.

While running log files , I am getting java error like this one:

[root@dwh logs]# vi etl_perform_retention_policy-20151021.log

/opt/kaltura/pentaho/pdi/kitchen.sh: line 71: /etc/alternatives/jre/bin/java: No such file or directory
INFO 21-10 12:30:08,404 - Kitchen - Start of run.
INFO 21-10 12:30:08,620 - perform retention policy - Start of job execution
INFO 21-10 12:30:09,109 - perform retention policy - Starting entry [Seize retention lock]
INFO 21-10 12:30:09,110 - Seize retention lock - Loading transformation from XML file [/opt/kaltura/dwh/etlsource//common/seize_lock_by_name.ktr]
INFO 21-10 12:30:09,236 - seize_lock_by_name - Dispatching started for transformation [seize_lock_by_name]
INFO 21-10 12:30:09,316 - get_retention_lock_name - Dispatching started for transformation [get_retention_lock_name]
INFO 21-10 12:30:09,421 - Generate Row - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0)
INFO 21-10 12:30:09,428 - Mapping input specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
INFO 21-10 12:30:09,431 - Set lock name = retention_lock - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
INFO 21-10 12:30:09,434 - Mapping output specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
INFO 21-10 12:30:09,434 - Get lock name - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
INFO 21-10 12:30:09,436 - Create lock states - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
INFO 21-10 12:30:09,442 - Register lock - Finished processing (I=1, O=0, R=1, W=1, U=0, E=0)
INFO 21-10 12:30:09,444 - Lock is free - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
INFO 21-10 12:30:09,445 - Get free lock - Finished processing (I=1, O=0, R=1, W=1, U=0, E=0)
INFO 21-10 12:30:09,447 - Get Now - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
INFO 21-10 12:30:09,450 - Seize lock - Finished processing (I=1, O=0, R=1, W=1, U=1, E=0)
INFO 21-10 12:30:09,453 - perform retention policy - Starting entry [Move old partitions to archive]
ERROR 21-10 12:30:19,116 - Move old partitions to archive - An error occurred executing this job entry :
Couldn’t execute SQL: CALL move_innodb_to_archive()

Cannot remove all partitions, use DROP TABLE instead

INFO 21-10 12:30:19,117 - perform retention policy - Finished job entry [Move old partitions to archive] (result=[false])
INFO 21-10 12:30:19,117 - perform retention policy - Finished job entry [Seize retention lock] (result=[false])
INFO 21-10 12:30:19,117 - perform retention policy - Job execution finished
INFO 21-10 12:30:19,194 - Kitchen - Finished!
ERROR 21-10 12:30:19,194 - Kitchen - Finished with errors
INFO 21-10 12:30:19,194 - Kitchen - Start=2015/10/21 12:30:08.405, Stop=2015/10/21 12:30:19.194
INFO 21-10 12:30:19,195 - Kitchen - Processing ended after 10 seconds.
/opt/kaltura/pentaho/pdi/kitchen.sh: line 71: /etc/alternatives/jre/bin/java: No such file or directory
/opt/kaltura/pentaho/pdi/kitchen.sh: line 71: /etc/alternatives/jre/bin/java: No such file or directory
/opt/kaltura/pentaho/pdi/kitchen.sh: line 71: /etc/alternatives/jre/bin/java: No such file or directory
/opt/kaltura/pentaho/pdi/kitchen.sh: line 71: /etc/alternatives/jre/bin/java: No such file or directory

Hello,

So, a few issues here:

See:

Something seems to be wrong with your Java config, as least, as far as the alternatives mechanism is concerned.
I suggest you reinstall the RPM package that provides you with the java binary.

As far as the collect not showing up in the log, what’s the embed URL you’re playing from? I will look.

Hi jess,

We are saving this embedded code in html file and running on browser but there is still no analytics:
Embedded code is:

Can you please tell us how to install the rpm java package in kaltura Cluster 10.21 ?

Should be a symlink to alternatives:

[root@ce-csi ~]# ll /usr/bin/java
lrwxrwxrwx. 1 root root 22 Oct 21 08:13 /usr/bin/java -> /etc/alternatives/java

Which in turn symlinks to the actual binary:

[root@ce-csi ~]# ll /etc/alternatives/java
lrwxrwxrwx. 1 root root 46 Oct 21 08:13 /etc/alternatives/java -> /usr/lib/jvm/jre-1.7.0-openjdk.x86_64/bin/java

Which in my particular case belongs to this package:

[root@ce-csi ~]# rpm -qf /usr/lib/jvm/jre-1.7.0-openjdk.x86_64/bin/java
java-1.7.0-openjdk-1.7.0.71-2.5.3.2.el6_6.x86_64

Versions may vary depending on the distro you are working on.

Also see my note on the other error you see in the analytics logs.

Hi

We have three different instance for DWH, Mysql and NFS-: (NFS contains Batch, sphinx front ngxin vod) server but when we are checking/running these command on both server separately then they both show different version of JAVA,

ll /usr/bin/java
ll /etc/alternatives/java
rpm -qf /usr/lib/jvm/xyz/bin/java

(We have java-1.6.0-openjdk-1.6.0.0-1.66.1.13.0.el6.x86_64 this version on NFS server

and jre-1.7.0_45-fcs.x86_64 this version on DWH server )

May this cause problem for our analytic…?

Hi,

Your problem is that /etc/alternatives/jre/bin/java is a broken symlink probably. This is on the machine that runs the dwh scripts, i.e those in /etc/cron.d/kaltura-dwh

This is in addition to the other issue as seen in your dwh logs.

Actually i am not understanding

now what i have to do …
please can you tell how to come up form this issue ???

You need to:

Hi…

We have followed your (- follow instructions here: https://github.com/kaltura/platform-install-packages/blob/Kajam-11.0.0/doc/kaltura-packages-faq.md#couldnt-execute-sql-call-move_innodb_to_archive1 to fix “Cannot remove all partitions, use DROP TABLE instead”) instruction
and now our DWH logs are

/opt/kaltura/pentaho/pdi/kitchen.sh: line 11: cd: /root: Permission denied
/opt/kaltura/pentaho/pdi/kitchen.sh: line 71: /etc/alternatives/jre/bin/java: No such file or directory
/opt/kaltura/pentaho/pdi/kitchen.sh: line 71: /etc/alternatives/jre/bin/java: No such file or directory
sh: /opt/kaltura/bin/pentaho/kitchen.sh: No such file or directory
~

and our kaltlog output are

uires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:83
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [DropFold…’)

#6 {main}
2015-10-21 19:29:09 [0.000264] [1784356581] [22] [%context%] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [DropFolderSetStatusAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:83
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [DropFold…’)

#6 {main}
2015-10-21 19:29:09 [0.000249] [1784356581] [23] [%context%] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [EventNotificationTemplatesListAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:83
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [EventNot…’)

#6 {main}
2015-10-21 19:29:09 [0.000366] [1784356581] [24] [%context%] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [EventNotificationTemplateConfigureAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:83
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [EventNot…’)

#6 {main}
2015-10-21 19:29:09 [0.000305] [1784356581] [25] [%context%] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [EventNotificationTemplateUpdateStatusAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:83
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [EventNot…’)

==> /opt/kaltura/log/kaltura_apache_errors.log <==
[Wed Oct 21 19:29:09 2015] [error] [client 122.184.129.18] PHP Warning: Unknown class passed as parameter in /opt/kaltura/app/admin_console/lib/Kaltura/Client/ClientBase.php on line 728, referer: http://1.2.3.4/admin_console/

Hii,

While running command:

#logrotate -vvv -f /etc/logrotate.d/kaltura_apache

It says—error: cannot stat /etc/logrotate.d/kaltura_apache: No such file or directory

and also my kalturadw.dwh_fact_events table is empty.Is it the reason for analytics not showing up and how can i populate data in to this table.
Please help.

Hi Rahul,

/etc/logrotate.d/kaltura_apache should point to /opt/kaltura/app/configurations/logrotate/kaltura_apache
you can manually correct that with:
# ln -s /opt/kaltura/app/configurations/logrotate/kaltura_apache /etc/logrotate.d/
and then retry.

Ok Jess ,

Now i am unable to see any entry in dwh_fact_events, My old data is showing fine in analytic grapth but this month drop down box option in analytic showing nothing …
and even when i am playing any video through embedded code on my browser its not showing any entry in analytic,
How to insert values in this table dwh_fact_events ?

Hi,

when playing from an embed code, check /opt/kaltura/log/kaltura_apache_access.log and ensure you see requests like:
GET //api_v3/index.php?service=stats&action=collect

Then call kaltura-run-dwh.sh and look at the logs.

Hello Jess,

After playing Embedded code I am not getting GET //api_v3/index.php
but I am getting POST//api_v3/index.php
as my output for kaltura_apache_access.log are below:-

127.0.0.1 - - [23/Oct/2015:18:29:40 +0530] “POST /api_v3/index.php?service=batch&action=cleanExclusiveJobs HTTP/1.1” 200 413 0/250797 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 29035 1460169134 - 568 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:18:29:41 +0530] “POST /api_v3/index.php?service=batch&action=suspendJobs HTTP/1.1” 200 416 0/79212 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 26536 2080440872 - 567 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:18:29:47 +0530] “POST /api_v3/index.php?service=system&action=ping HTTP/1.1” 200 477 0/1340 “-” “-” “-” 127.0.0.1 “cached-dispatcher,cache_v3-4573cb1b41aa602d154d9108d17cdd50,0.00019097328186035” “abc.wddemo.com” 28943 - - 554 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:18:29:47 +0530] “POST /api_v3/index.php?service=livestream&action=list HTTP/1.1” 200 486 0/981216 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 27752 740502673 - 778 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:18:29:47 +0530] “POST /api_v3/index.php?service=batchcontrol&action=reportStatus HTTP/1.1” 200 4212 9/9912238 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 26535 30785672 - 9567 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:18:30:03 +0530] “POST /api_v3/index.php?service=system&action=ping HTTP/1.1” 200 477 0/1605 “-” “-” “-” 127.0.0.1 “cached-dispatcher,cache_v3-4573cb1b41aa602d154d9108d17cdd50,0.00017499923706055” “abc.wddemo.com” 29034 - - 558 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:18:30:03 +0530] “POST /api_v3/index.php?service=batchcontrol&action=reportStatus HTTP/1.1” 200 4214 1/1810520 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 29037 1355514856 - 9454 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:18:30:05 +0530] “POST /api_v3/index.php?service=dropfolder_dropfolder&action=list HTTP/1.1” 200 1720 0/465329 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 26537 612651301 - 725 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:18:30:05 +0530] “POST /api_v3/index.php?service=dropfolder_dropfolderfile&action=list HTTP/1.1” 200 490 0/480298 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 28942 116603916 - 762 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:18:30:06 +0530] “POST /api_v3/index.php?service=dropfolder_dropfolder&action=update HTTP/1.1” 200 879 0/175899 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 26533 216058693 - 742 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:18:30:06 +0530] “POST /api_v3/index.php?service=dropfolder_dropfolderfile&action=list HTTP/1.1” 200 1467 0/519786 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 26538 2050852162 - 763 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:18:30:07 +0530] “POST /api_v3/index.php?service=dropfolder_dropfolder&action=update HTTP/1.1” 200 1178 0/211625 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 26539 456742954 - 743 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:18:30:18 +0530] “POST /api_v3/index.php?service=livestream&action=list HTTP/1.1” 200 486 0/339504 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 29036 605238965 - 779 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:18:30:19 +0530] “POST /api_v3/index.php?service=system&action=ping HTTP/1.1” 200 477 0/1519 “-” “-” “-” 127.0.0.1 “cached-dispatcher,cache_v3-4573cb1b41aa602d154d9108d17cdd50,0.00017499923706055” “abc.wddemo.com” 28381 - - 559 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:18:30:41 +0530] “POST /api_v3/index.php?service=batch&action=updatePartnerLoadTable HTTP/1.1” 200 416 0/773866 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 26534 1617647644 - 580 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:18:30:41 +0530] “POST /api_v3/index.php?service=batch&action=cleanExclusiveJobs HTTP/1.1” 200 413 3/3368863 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 28941 1426742458 - 572 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:18:30:42 +0530] “POST /api_v3/index.php?service=batch&action=suspendJobs HTTP/1.1” 200 416 2/2433190 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 26592 1755986975 - 567 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:18:30:49 +0530] “POST /api_v3/index.php?service=livestream&action=list HTTP/1.1” 200 487 0/174920 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 29035 1972771137 - 778 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:18:30:19 +0530] “POST /api_v3/index.php?service=batchcontrol&action=reportStatus HTTP/1.1” 200 4214 35/35811579 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 26532 1044797478 - 26698 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:18:30:56 +0530] “POST /api_v3/index.php?service=system&action=ping HTTP/1.1” 200 477 0/1541 “-” “-” “-” 127.0.0.1 “cached-dispatcher,cache_v3-4573cb1b41aa602d154d9108d17cdd50,0.00017404556274414” “abc.wddemo.com” 26536 - - 559 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:18:30:56 +0530] “POST /api_v3/index.php?service=batchcontrol&action=reportStatus HTTP/1.1” 200 4213 1/1690926 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 28943 849249434 - 9572 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1

and output for my logrotate -vvv -f /etc/logrotate.d/kaltura_apache file are below:-

reading config file /etc/logrotate.d/kaltura_apache
reading config info for /opt/kaltura/log/kaltura_apache_errors.log
error: /etc/logrotate.d/kaltura_apache:12 unknown option ‘root’ – ignoring line
error: /etc/logrotate.d/kaltura_apache:12 unexpected text
reading config info for /opt/kaltura/log/kaltura_apache_access.log
error: /etc/logrotate.d/kaltura_apache:26 unknown option ‘root’ – ignoring line
error: /etc/logrotate.d/kaltura_apache:26 unexpected text
reading config info for /opt/kaltura/log/kaltura_apache_errors_ssl.log
error: /etc/logrotate.d/kaltura_apache:40 unknown option ‘root’ – ignoring line
error: /etc/logrotate.d/kaltura_apache:40 unexpected text
reading config info for /opt/kaltura/log/kaltura_apache_access_ssl.log
error: /etc/logrotate.d/kaltura_apache:54 unknown option ‘root’ – ignoring line
error: /etc/logrotate.d/kaltura_apache:54 unexpected text

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
considering log /opt/kaltura/log/kaltura_apache_errors.log
log needs rotating
rotating log /opt/kaltura/log/kaltura_apache_errors.log, log->rotateCount is 5
dateext suffix '-20151023’
glob pattern '-[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'
destination /opt/kaltura/log/kaltura_apache_errors.log-20151023.gz already exists, skipping rotation

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
considering log /opt/kaltura/log/kaltura_apache_access.log
log needs rotating
rotating log /opt/kaltura/log/kaltura_apache_access.log, log->rotateCount is 5
dateext suffix '-20151023’
glob pattern '-[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'
glob finding old rotated logs failed
renaming /opt/kaltura/log/kaltura_apache_access.log to /opt/kaltura/log/kaltura_apache_access.log-20151023
compressing log with: /bin/gzip
running last action script
Reloading httpd:

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
considering log /opt/kaltura/log/kaltura_apache_errors_ssl.log
log /opt/kaltura/log/kaltura_apache_errors_ssl.log does not exist – skipping
not running postrotate script, since no logs were rotated

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
considering log /opt/kaltura/log/kaltura_apache_access_ssl.log
log /opt/kaltura/log/kaltura_apache_access_ssl.log does not exist – skipping
not running last action script, since no logs will be rotated

Hi Rahul,

As long as there is no collect request in the access log, there is no point in checking further.
Please share a URL to an embed code so I may look at it.

Also, is this a clustered install or a single server?
When you play a video, try:
# tail -f /opt/kaltura/log/kaltura_apache_access.log

to make sure you are actually hitting the server…

Hello,

I am working on Kaltura cluster 10.21 server .

This is my URL:- file:///C:/Users/vinod.kumar/Desktop/aaa.html
and my embedded code are in below image:-

And output after playing embedded code are below:-

tail -f /opt/kaltura/log/kaltura_apache_access.log

127.0.0.1 - - [23/Oct/2015:19:08:47 +0530] “POST /api_v3/index.php?service=dropfolder_dropfolderfile&action=list HTTP/1.1” 200 1466 0/155116 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31218 564036377 - 763 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:19:08:17 +0530] “POST /api_v3/index.php?service=batchcontrol&action=reportStatus HTTP/1.1” 200 4213 29/29464261 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31340 396763180 - 9454 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:19:08:47 +0530] “POST /api_v3/index.php?service=dropfolder_dropfolder&action=update HTTP/1.1” 200 1179 1/1059366 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31346 1299282006 - 743 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:19:08:48 +0530] “POST /api_v3/index.php?service=system&action=ping HTTP/1.1” 200 477 0/1572 “-” “-” “-” 127.0.0.1 “cached-dispatcher,cache_v3-4573cb1b41aa602d154d9108d17cdd50,0.00016498565673828” “abc.wddemo.com” 31217 - - 558 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:19:08:48 +0530] “POST /api_v3/index.php?service=batchcontrol&action=reportStatus HTTP/1.1” 200 4214 2/2081691 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31221 1382802696 - 9571 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
122.184.129.18 - - [23/Oct/2015:19:09:01 +0530] “GET //api_v3/index.php?service=stats&action=collect&kalsig=d2e58f816a29d02b2c9e021303df1b24&event%3AcurrentPoint=42200&event%3Areferrer=http%253A%2F%2Fvideocms%2Ewebdunia%2Ecom%2Findex%2Ephp%2Fkmc%2Fkmc4&clientTag=kdp%3Av3%2E9%2E9&event%3AclientVer=3%2E0%3Av3%2E9%2E9&event%3AobjectType=KalturaStatsEvent&event%3AentryId=0%5F8hzinykp&partnerId=101&event%3AuiconfId=23449439&event%3Aduration=42&apiVersion=3%2E1%2E5&event%3AsessionId=FDF4B610%2D076A%2D8519%2DCEC0%2D94853B0A5D8B&event%3AeventTimestamp=1445607289000&ks=M2YxOTVlZTNlNGM5ZTVmYjZjY2ExNGRlODk1YjUxZmVjYzY3ZThiMHwxMDE7MTAxOzE0NDU2ODc0MzQ7MDsxNDQ1NjAxMDM0LjY1NTk7MDt2aWV3Oiosd2lkZ2V0OjE7Ow%3D%3D&ignoreNull=1&event%3ApartnerId=101&event%3AisFirstInSession=false&event%3Aseek=false&event%3AeventType=16 HTTP/1.1” 200 371 0/263 “-” “Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.71 Safari/537.36” “-” 122.184.129.18 “-” “abc.wddemo.com” 31219 - - 1281 “-” “-” “-” “-” “-” -
122.184.129.18 - - [23/Oct/2015:19:09:01 +0530] “GET //api_v3/index.php?service=stats&action=collect&kalsig=2cfb05d859141c6554accbc3a5823e31&event%3AcurrentPoint=42200&event%3Areferrer=http%253A%2F%2Fvideocms%2Ewebdunia%2Ecom%2Findex%2Ephp%2Fkmc%2Fkmc4&clientTag=kdp%3Av3%2E9%2E9&event%3AclientVer=3%2E0%3Av3%2E9%2E9&event%3AobjectType=KalturaStatsEvent&event%3AentryId=0%5F8hzinykp&partnerId=101&event%3AuiconfId=23449439&event%3Aduration=42&apiVersion=3%2E1%2E5&event%3AsessionId=FDF4B610%2D076A%2D8519%2DCEC0%2D94853B0A5D8B&event%3AeventTimestamp=1445607289016&ks=M2YxOTVlZTNlNGM5ZTVmYjZjY2ExNGRlODk1YjUxZmVjYzY3ZThiMHwxMDE7MTAxOzE0NDU2ODc0MzQ7MDsxNDQ1NjAxMDM0LjY1NTk7MDt2aWV3Oiosd2lkZ2V0OjE7Ow%3D%3D&ignoreNull=1&event%3ApartnerId=101&event%3AisFirstInSession=false&event%3Aseek=false&event%3AeventType=12 HTTP/1.1” 200 371 0/177 “-” “Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.71 Safari/537.36” “-” 122.184.129.18 “-” “abc.wddemo.com” 31224 - - 1281 “-” “-” “-” “-” “-” -
122.184.129.18 - - [23/Oct/2015:19:09:01 +0530] “GET //api_v3/index.php?service=stats&action=collect&kalsig=fda198345e2dfeca885f420f0aa5dcb0&event%3AcurrentPoint=0&event%3Areferrer=http%253A%2F%2Fvideocms%2Ewebdunia%2Ecom%2Findex%2Ephp%2Fkmc%2Fkmc4&clientTag=kdp%3Av3%2E9%2E9&event%3AclientVer=3%2E0%3Av3%2E9%2E9&event%3AobjectType=KalturaStatsEvent&event%3AentryId=0%5F8hzinykp&partnerId=101&event%3AuiconfId=23449439&event%3Aduration=42&apiVersion=3%2E1%2E5&event%3AsessionId=FDF4B610%2D076A%2D8519%2DCEC0%2D94853B0A5D8B&event%3AeventTimestamp=1445607289139&ks=M2YxOTVlZTNlNGM5ZTVmYjZjY2ExNGRlODk1YjUxZmVjYzY3ZThiMHwxMDE7MTAxOzE0NDU2ODc0MzQ7MDsxNDQ1NjAxMDM0LjY1NTk7MDt2aWV3Oiosd2lkZ2V0OjE7Ow%3D%3D&ignoreNull=1&event%3ApartnerId=101&event%3AisFirstInSession=false&event%3Aseek=false&event%3AeventType=13 HTTP/1.1” 200 371 0/282 “-” “Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.71 Safari/537.36” “-” 122.184.129.18 “-” “abc.wddemo.com” 31223 - - 1277 “-” “-” “-” “-” “-” -
122.184.129.18 - - [23/Oct/2015:19:09:01 +0530] “GET /serverip HTTP/1.1” 301 531 0/7413 “-” “Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.71 Safari/537.36” “-” 122.184.129.18 “-” “abc.wddemo.com” 31222 1165179464 - 534 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -
127.0.0.1 - - [23/Oct/2015:19:09:04 +0530] “POST /api_v3/index.php?service=system&action=ping HTTP/1.1” 200 477 0/1536 “-” “-” “-” 127.0.0.1 “cached-dispatcher,cache_v3-4573cb1b41aa602d154d9108d17cdd50,0.00017499923706055” “abc.wddemo.com” 31220 - - 559 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:19:09:04 +0530] “POST /api_v3/index.php?service=livestream&action=list HTTP/1.1” 200 486 5/5743115 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31218 250212603 - 774 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:19:09:04 +0530] “POST /api_v3/index.php?service=batchcontrol&action=reportStatus HTTP/1.1” 200 4213 9/9842195 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31340 273057821 - 9455 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:19:09:19 +0530] “POST /api_v3/index.php?service=batch&action=updatePartnerLoadTable HTTP/1.1” 200 416 0/115833 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31217 1588770853 - 584 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:19:09:19 +0530] “POST /api_v3/index.php?service=batch&action=cleanExclusiveJobs HTTP/1.1” 200 413 0/811248 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31346 2053277735 - 569 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:19:09:20 +0530] “POST /api_v3/index.php?service=system&action=ping HTTP/1.1” 200 477 0/1349 “-” “-” “-” 127.0.0.1 “cached-dispatcher,cache_v3-4573cb1b41aa602d154d9108d17cdd50,0.00016403198242188” “abc.wddemo.com” 31219 - - 558 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:19:09:20 +0530] “POST /api_v3/index.php?service=batch&action=suspendJobs HTTP/1.1” 200 416 0/85374 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31221 1339446915 - 567 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:19:09:21 +0530] “POST /api_v3/index.php?service=batchcontrol&action=reportStatus HTTP/1.1” 200 4214 2/2838930 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31224 2028582072 - 9571 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:19:09:35 +0530] “POST /api_v3/index.php?service=livestream&action=list HTTP/1.1” 200 487 0/641792 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31223 1157052932 - 779 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:19:09:36 +0530] “POST /api_v3/index.php?service=system&action=ping HTTP/1.1” 200 477 0/1546 “-” “-” “-” 127.0.0.1 “cached-dispatcher,cache_v3-4573cb1b41aa602d154d9108d17cdd50,0.00016283988952637” “abc.wddemo.com” 31222 - - 559 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:19:09:36 +0530] “POST /api_v3/index.php?service=batchcontrol&action=reportStatus HTTP/1.1” 200 4214 2/2194354 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31220 1497976480 - 9455 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:19:09:44 +0530] “POST /api_v3/index.php?service=dropfolder_dropfolder&action=list HTTP/1.1” 200 1721 0/127567 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31218 2129475184 - 725 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:19:09:45 +0530] “POST /api_v3/index.php?service=dropfolder_dropfolderfile&action=list HTTP/1.1” 200 490 0/156781 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31340 129363634 - 762 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:19:09:45 +0530] “POST /api_v3/index.php?service=dropfolder_dropfolder&action=update HTTP/1.1” 200 880 1/1880988 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31217 1656669997 - 742 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:19:09:47 +0530] “POST /api_v3/index.php?service=dropfolder_dropfolderfile&action=list HTTP/1.1” 200 1466 0/158213 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31346 953793463 - 763 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:19:09:47 +0530] “POST /api_v3/index.php?service=dropfolder_dropfolder&action=update HTTP/1.1” 200 1179 0/208699 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31219 1508783795 - 743 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:19:09:53 +0530] “POST /api_v3/index.php?service=system&action=ping HTTP/1.1” 200 477 0/1695 “-” “-” “-” 127.0.0.1 “cached-dispatcher,cache_v3-4573cb1b41aa602d154d9108d17cdd50,0.00019502639770508” “abc.wddemo.com” 31221 - - 558 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:19:09:53 +0530] “POST /api_v3/index.php?service=batchcontrol&action=reportStatus HTTP/1.1” 200 4214 0/983815 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31224 2013148938 - 9454 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1

OK, good, so, in the access log, I do see:
GET//api_v3/index.php?service=stats&action=collect

Now you can continue to run the DWH scripts and check for errors in /opt/kaltura/dwh/logs/

And also run the queries specified in: https://github.com/kaltura/platform-install-packages/blob/Kajam-11.0.0/doc/kaltura-packages-faq.md#analytics-issues

and see at which point data is not received.

Hello Jess,

I have tried everything whatever you have mentioned above
But i am still facing issue with
select * from kalturadw.dwh_fact_events where event_date_id >=%Y%m%d ;

query not showing any data in dwh_fact_events…
Can you tell me how to come up with this error ?

and I am getting this output in
tail -f /opt/kaltura/log/kaltura_apache_access.log

127.0.0.1 - - [23/Oct/2015:20:45:35 +0530] “POST /api_v3/index.php?service=contentdistribution_contentdistributionbatch&action=createRequiredJobs HTTP/1.1” 200 416 5/5050139 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31222 2142830984 - 625 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:20:45:42 +0530] “POST /api_v3/index.php?service=livestream&action=list HTTP/1.1” 200 486 1/1213335 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31346 531585370 - 779 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:20:45:38 +0530] “POST /api_v3/index.php?service=batchcontrol&action=reportStatus HTTP/1.1” 200 4213 5/5876144 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31221 231891248 - 9455 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:20:45:54 +0530] “POST /api_v3/index.php?service=system&action=ping HTTP/1.1” 200 477 0/1322 “-” “-” “-” 127.0.0.1 “cached-dispatcher,cache_v3-4573cb1b41aa602d154d9108d17cdd50,0.00014519691467285” “abc.wddemo.com” 31224 - - 558 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:20:45:54 +0530] “POST /api_v3/index.php?service=batch&action=updatePartnerLoadTable HTTP/1.1” 200 415 0/894804 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31340 725979446 - 584 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:20:45:55 +0530] “POST /api_v3/index.php?service=batch&action=suspendJobs HTTP/1.1” 200 416 0/702079 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31217 1978743820 - 568 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:20:45:54 +0530] “POST /api_v3/index.php?service=batch&action=cleanExclusiveJobs HTTP/1.1” 200 413 2/2652912 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31218 1265582244 - 572 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:20:45:54 +0530] “POST /api_v3/index.php?service=batchcontrol&action=reportStatus HTTP/1.1” 200 4213 19/19063564 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31223 162208650 - 9571 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:20:46:13 +0530] “POST /api_v3/index.php?service=livestream&action=list HTTP/1.1” 200 487 0/754958 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31219 1378412699 - 778 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:20:46:15 +0530] “POST /api_v3/index.php?service=system&action=ping HTTP/1.1” 200 477 0/1588 “-” “-” “-” 127.0.0.1 “cached-dispatcher,cache_v3-4573cb1b41aa602d154d9108d17cdd50,0.00017309188842773” “abc.wddemo.com” 31220 - - 557 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1

And out put for :- logrotate -vvv -f /etc/logrotate.d/kaltura_apache

reading config file /etc/logrotate.d/kaltura_apache
reading config info for /opt/kaltura/log/kaltura_apache_errors.log
error: /etc/logrotate.d/kaltura_apache:12 unknown option ‘root’ – ignoring line
error: /etc/logrotate.d/kaltura_apache:12 unexpected text
reading config info for /opt/kaltura/log/kaltura_apache_access.log
error: /etc/logrotate.d/kaltura_apache:26 unknown option ‘root’ – ignoring line
error: /etc/logrotate.d/kaltura_apache:26 unexpected text
reading config info for /opt/kaltura/log/kaltura_apache_errors_ssl.log
error: /etc/logrotate.d/kaltura_apache:40 unknown option ‘root’ – ignoring line
error: /etc/logrotate.d/kaltura_apache:40 unexpected text
reading config info for /opt/kaltura/log/kaltura_apache_access_ssl.log
error: /etc/logrotate.d/kaltura_apache:54 unknown option ‘root’ – ignoring line
error: /etc/logrotate.d/kaltura_apache:54 unexpected text

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
considering log /opt/kaltura/log/kaltura_apache_errors.log
log needs rotating
rotating log /opt/kaltura/log/kaltura_apache_errors.log, log->rotateCount is 5
dateext suffix '-20151023’
glob pattern '-[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'
destination /opt/kaltura/log/kaltura_apache_errors.log-20151023.gz already exists, skipping rotation

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
considering log /opt/kaltura/log/kaltura_apache_access.log
log needs rotating
rotating log /opt/kaltura/log/kaltura_apache_access.log, log->rotateCount is 5
dateext suffix '-20151023’
glob pattern '-[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'
glob finding old rotated logs failed
renaming /opt/kaltura/log/kaltura_apache_access.log to /opt/kaltura/log/kaltura_apache_access.log-20151023
compressing log with: /bin/gzip
running last action script
Reloading httpd:

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
considering log /opt/kaltura/log/kaltura_apache_errors_ssl.log
log /opt/kaltura/log/kaltura_apache_errors_ssl.log does not exist – skipping
not running postrotate script, since no logs were rotated

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
considering log /opt/kaltura/log/kaltura_apache_access_ssl.log
log /opt/kaltura/log/kaltura_apache_access_ssl.log does not exist – skipping
not running last action script, since no logs will be rotated