Moved installation to new server, now cannot login


i recently relocated my site and piwik to a new server at the same hosting group.
my site is working fine. however, piwik will not let me login with the superuser login details i was previously using.
i looked in the piwik database for the users table and saw only one record in there, which is for ‘anonymous’.
i imagine i should replace the anonymous user with the superuser.

anyone know what’s occurring here and the correct fix?


no-one seen this before?

(Matthieu Aubry) #3

do you have a ‘superuser_access’ column in the piwik_user table?

If so please create a new row in this table for your super user.

Then see this FAQ: How do I change the Super User's password when password recovery emails are not sent? - Analytics Platform - Matomo

(note: the upgrade should have done this automatically for you, ref: matomo/2.0.4-b5.php at master · matomo-org/matomo · GitHub )


i’m not sure exactly what occurred here, but i think the cause of the problem is that my mysql backup was failing and the backup i restored from was incomplete.
in any case, i found that i needed to restart the php-fpm process in nginx and then the install worked ok (though my data from piwik is gone forever, due to the failed backups).