I have just installed 2.2.2 on a new host running Debin 7.5 in the UK with a Europe/London timezone on the OS and in PHP. However for some reason Piwik cron job uses UTC which is 1 hour different from my server time.
I have checked every single setting I can think of but still can’t track the problem down.
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2014-05-16 10:52:22 |
+---------------------+
1 row in set (0.00 sec)
mysql> quit
Bye
root@analytics:~# date
Fri May 16 10:52:55 BST 2014
root@analytics:~# /usr/bin/php5 /usr/share/piwik/console core:archive --url=http://analytics.domain.com/
INFO CoreConsole[2014-05-16 09:53:09] [d875d] ---------------------------
INFO CoreConsole[2014-05-16 09:53:09] [d875d] INIT
INFO CoreConsole[2014-05-16 09:53:09] [d875d] Piwik is installed at: http://analytics.domain.com/index.php
INFO CoreConsole[2014-05-16 09:53:09] [d875d] Running Piwik 2.2.2 as Super User
Any insight in how to resolve this would really be appreciated.