I can't log in anymore. Is it because of OIDC login since 1.42.0?

[simon]

Hello to all,

I just realised today that I can no longer log in to my Matomo installation.
Not with any of the Cloudron users.

As I only log in from time to time, this may well have been the case for some time.

I currently have the app 1.44.1 (Matomo 5.0.1) installed. Two week ago, version 1.42.0 was switched to OICD. That could be the problem.
Unfortunately there is nothing in the log. Only a 403. The error message in the login frontend is "Error: Username and/or password is not correct."
Does anyone know a solution?

[girish]

Do you see a login with cloudron button like below?

[simon]

No. Just the remember me an the sign in.

[girish]

@simon and are you using Cloudron user management ? If you go to the Access Control section in Cloudron dashboard, do you see User management or Dashboard visibility. Only the former uses OIDC login.

[simon]

I'm using "User management" with "Only allow the following users and groups". But "Allow all users from this Cloudron" makes no difference anyway. "Dashboard visibility" is not available as an option

[girish]

@simon thanks, so it is using Cloudron user management. It should see the Cloudron Login button but for some reason it is not. Are you not able to login as the admin user either?

Do you think you can write to us at support@cloudron.io and we can debug further. Looks like the OIDC plugin is not getting enabled.

[girish]

The issue here was that the tables had a prefix. The package wasn't taking this into account when running sql queries. Not sure why/how they have a prefix. But I have fixed the package to accommodate them nevertheless.

[girish]

It was a bit more involved in @simon's instance. Looks like the db came from an old instance. The tables are still MyISAM and have the wrong character set preventing migrations.

For the future, I converted the tables using something like below:

SET @DATABASE_NAME = 'xx';

SELECT  CONCAT('ALTER TABLE `', table_name, '` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ENGINE=InnoDB;') AS sql_statements
FROM    information_schema.tables AS tb
WHERE   table_schema = @DATABASE_NAME
AND     `ENGINE` = 'MyISAM'
AND     `TABLE_TYPE` = 'BASE TABLE'
ORDER BY table_name DESC;

[girish]

Also https://matomo.org/faq/troubleshooting/faq_25610/