Piwik Cron Job Issue
 

Hi,

Struggling already to much time with the following problem at a vps package.
I hope somebody can advise me on this.

I try to add a cronjob, so that piwik (newest version) can create automatic archives, but whatever I already tried i'm not getting it correct.
Cron Deamon does send every time notifications with errors. Not sure in which crontab I should add the lines the best,
but both "crontab -e" & "crontab -u www-data -e" are giving me the very same results.

The webserver does run on apache2 + php5. The path to php5 is "/usr/bin/php5" (which php5 command)
/var/spool/cron/crontabs# does have a 'root' and 'www-data' listed.

If I add :
MAILTO="[email protected]"
5 * * * * root /usr/bin/php5 /home/user001/public_html/folder1/misc/cron/archive.php -- url=http://2xx.3x.x7.x0/folder1/ > /home/user001/public_html/folder1/piwik-archive.log

Cron Deamon trows the following
/bin/sh: 1: cannot create /home/user001/public_html/folder1/piwik-archive.log: Permission denied
/bin/sh: 1: root: not found


This entrie :
MAILTO="[email protected]"
5 * * * * www-data /usr/bin/php5 /home/user001/public_html/folder1/misc/cron/archive.php -- url=http://2xx.3x.x7.x0/folder1/ > /home/user001/public_html/folder1/piwik-archive.log
gives me this.

/bin/sh: 1: cannot create /home/user001/public_html/folder1/piwik-archive.log: Permission denied
/bin/sh: 1: www-data: not found

archive.php has www-data as owner
piwik-archive.log has root as owner

Is there somebody that is able to catch where I did go wrong ?

Any valuable input is apreciated. (so DVTimes, stay the fuck out of this thread) :)

~ Renaldo,

cron probably needs to run as root or apache

Be careful with Piwik. One of my sites was hacked 2 months ago. The vulnerability was in Piwik.

Thanks for the advise. Did you run piwik on its own vps, or mixed up with other domains ?
I running piwik at a vps which just get used for piwik.

Did they hack you due to the include which you added or they started the hack at any of the piwik files ?

one bump :)