Hello,
My Analitics have stopped working, the locks are all on 0, everything seems fine. There’s one thing i don’t understand, in the situation where i have a cluster and all the apache logs are on the front node, but the dwh mysql and sphinx are on a separate server, how are the apache access logs going to be read by the dwh process, i have the symlink created
Moves the access logs per node onto the NFS under /opt/kaltura/web/logs/ which should be mounted on the DWH node, the DWH node, knows where to find them because of /opt/kaltura/dwh/.kettle/kettle.properties:
Maybe this can help you. We serve all our content through a nginx CDN/Frontend. I had a timing problem with the frontend logrotate script because it was compressing the logs AFTER Kaltura was looking for the files.
I changed compress for nodelaycompres and problem solved. This is my modified frontend script:
Thank you @Jess, @David.Eusse,
I haven’t worked on that yet because I had a lot of work in other areas, will try both your solutions soon and let you know how everything went.
Again thank you very much for the prompt responses.
Hello Jess,
So I’ve checked the etl user and password that’s in kettle.proprieties, i was able to connect to the mysql.
On the NFS /opt/kaltura/web/log i have the .gz apache logs from the front node. So everything look fine so far, what should i check further ?
Edit1: The etl logs retention/update/hourly/daily have absolutely no errors.
Edit2: When i do mysql> SELECT * FROM dwh_fact_events order by event_time DESC; the last entry is from 2017-1-27. meaninig today, this means the data is getting populated into the db.
Edit3: tail -f /var/log/cron on the dwh node:
Jan 27 08:00:01 mysql CROND[12992]: (root) CMD (root /opt/kaltura/dwh/etlsource/execute/etl_hourly.sh -p /opt/kaltura/dwh -k /opt/kaltura/pentaho/pdi/kitchen.sh)
Jan 27 08:00:01 mysql CROND[12991]: (root) CMD (root /opt/kaltura/dwh/etlsource/execute/etl_update_dims.sh -p /opt/kaltura/dwh -k /opt/kaltura/pentaho/pdi/kitchen.sh)
Jan 27 08:00:01 mysql CROND[12993]: (kaltura) CMD (/opt/kaltura/dwh/etlsource/execute/etl_update_dims.sh -p /opt/kaltura/dwh -k /opt/kaltura/pentaho/pdi/kitchen.sh)
Jan 27 08:00:01 mysql CROND[12994]: (kaltura) CMD (/opt/kaltura/dwh/etlsource/execute/etl_hourly.sh -p /opt/kaltura/dwh -k /opt/kaltura/pentaho/pdi/kitchen.sh)
Jan 27 08:01:01 mysql CROND[14475]: (root) CMD (run-parts /etc/cron.hourly)
Jan 27 08:01:01 mysql run-parts(/etc/cron.hourly)[14475]: starting 0anacron
Jan 27 08:01:01 mysql run-parts(/etc/cron.hourly)[14484]: finished 0anacron