Impossible to log in

Support & Bugs
1

Hi there, and thank you in advance for your help.

I have tried and checked many things before posting here.
I installed Matomo, but for the past month, I haven’t been able to log in.

I tried using an SQL query to create a super admin, but nothing is working.
I can’t use the password reset option since I don’t have the email feature enabled.

Every time I try something, I get the following error message:

Error: Incorrect username and/or password.
“error”: Password or username does not exist.

However, the user exists in the database.

Could you please help me find a solution?

Thanks!

2

Maybe this helps you?

How do I change the Super User’s password when password recovery emails are not sent? FAQ - How to - Matomo Analytics Platform

EDIT: Btw, in my matomo DB the table is called ‘user’, not ‘matomo_user’ like in the example code on that page. However, you will know yours because you say the user is in the DB.

3

Thank you for you answer. The thing is, i cannot run the command on the first part of this : https://matomo.org/faq/how-to/faq_191/ since i cannot get an access of a linux server …
let me know if you think of any other solution
thanks !

4

So you have access to your DB server but not to a linux server? how/where did you install your matomo without access to a server?

I don’t think a linux server is required. you need to run the php function password_hash(md5("changeMe"), PASSWORD_DEFAULT) which should work on any php installation.

this generates a password hash that matomo can use so you can replace the existing hash in your DB which corresponds to the password you dont remember.

[EDIT: I just tried. with this command with my password I successfully get a hash that looks correct. however, it is not the same hash that is in my DB. So I am not sure if this really works. maybe that information is old? That FAQ page refers to “Matomo 3.0 or newer” which is really old. Maybe a newer Matomo is doing different things to get the hash (liks salt).]

5

Yes that’s the point …
i installed matomo on siteground hosting and cannot run php functions … ;(
I think this informaiton is old since when i generate new password from php command, it does not work in fact
im not sure to know what im supposed to do now
thanks