Auto-Archive on windows fails" mysql driver not installed

Support & Bugs
1

I’ve tried searching for this problem, but could only find non-windows solutions.

I’m running Piwik on Windows Server 2008 w/ IIS7 and recently tried to set up auto-archiving. When i run this at the command line:

C:\php-5.4.4-Win32-VC9-x86\php.exe C:\inetpub\wwwroot\piwik
misc\cron\archive.php --url=http://localhost/piwik/

I get the following error:
ERROR: During Piwik init, Message: The mysql driver is not currently installed

Now i know mysql is installed as Piwik has worked perfectly for months. What exactly does it mean by this? Do i need to add the path to mysql to my PATH variable? Are these different drivers that don’t come with PIWIK?

I’d appreciate any help, thanks!
Also, PIWIK is fantastic, keep up the great work :slight_smile:

2

Check that mysqk is enabled in the PHP/CLI/php.ini file (specific to CLI which is command line php)

3

Thank you, that was the problem. I used IIS 7 to download, install and configure PHP for PIWIK, but then re-downloaded php again to use for running this script.

I just needed to find and use the existing php installation. FYI if you have performed a default installation of IIS 7, PHP and PIWIK on a Windows Server 2008, then this command should work:

“C:\Program Files (x86)\PHP\v5.3\php.exe” C:\inetpub\wwwroot\piwik\misc\cron\archive.php --url=http://localhost/piwik/