After import database cant login with Admin

Hi @ensenada the password for users are encrypted into database. You can’t read it but you can reset it. See 

Sorry Laurent, but i dont understand

Admin is not a database user:

MariaDB [(none)]> SELECT user, host FROM mysql.user;
+-------------+-----------+
| User        | Host      |
+-------------+-----------+
| centreon    | localhost |
| mariadb.sys | localhost |
| mysql       | localhost |
| root        | localhost |
+-------------+-----------+

However I have tried it but i have this error:

UPDATE contact SET login_attempts = NULL, blocking_time = NULL WHERE contact_id = 'Admin';
ERROR 1046 (3D000): No database selected

Also comment that it had centreon integrated with Active Directoy, when i try login with my domain account no error appears but it doesn't load either web interface.

I have tried this

I have read this post

I have try all solutions and still i cant login in web

And why appears v 22.10.9 if i have install the last version 23 ? is it because of the database import?

I have tried to restart the apache service and now I have no password error but the interface still does not load correctly. I will check the logs and open a new thread

Thanks to all !!

HI @ensenada can you check /var/log/php-fpm/centreon-errors.log?

 I havent errors on /var/log/php8.1-fpm.log

Thanks for help, now im trying to finish the migration

Can you check /var/log/apache2/error*.log?

Hello @ensenada are you using the actual contact id?

this is from your screen shot.

if you are using admin maybe contact id 1? 🤔🤷‍♂️

Hello @ensenada are you using the actual contact id?

this is from your screen shot.

 

if you are using admin maybe contact id 1? 🤔🤷‍♂️

Yeah, i solved with this command

UPDATE contact_password SET password = md5('centreon') WHERE contact_id = 1;

Thanks