Has anyone encountered a problem where the default site is not being added to the site table? I’m installing the latest piwik and can’t log in after completion. The tables were correctly created and the MySQL user has correct permissions:
[size=small]| GRANT USAGE ON . TO ‘piwik_user’@‘host’ IDENTIFIED BY PASSWORD
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX,
ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW
VIEW, CREATE ROUTINE, ALTER ROUTINE ON
piwik.* TO ‘piwik_user’@'host’
WITH GRANT OPTION |[/size]
Here’s the login error using session_save_handler = “files”:
[size=small]Error: no website was found in this Piwik installation.
Check the table ‘piwik_site’ in your database, it should contain your Piwik websites.[/size]
Here’s the login error using session_save_handler = “dbtable”
[size=small]Error: Form security failed. Please reload the form and check that your cookies are enabled[/size]
I’ve tried using mysqli and pdo_mysql but got the same result. Thanks in advance for any feedback.