I think I’ve found a bug.
Piwik was working fine after I added the first site, however after adding a second site Piwik stopped collecting stats. Removing the second site doesn’t remedy the problem. The only way to fix it is to delete the database and reinstall.
I should also add that no data is being logged in the piwik_log_visit table after adding the second site.