Question

After import database cant login with Admin

  • 25 October 2023
  • 9 replies
  • 192 views
ensenada
Badge +4

Hello,

 

After step Retrieve the databases of migration document

https://docs.centreon.com/docs/migrate/migrate-from-el-to-debian/#prerequisites

I cant log in web interface with admin and his credential.

In login.log i got

Authentication failed for 'admin' : invalid credentials

What config file i must check to change the password ?

 

Many thanks,

9 replies

Laurent
Rank
Userlevel 6
Badge +18

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

 

ensenada
Badge +4

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.

ensenada
Badge +4

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?

ensenada
Badge +4

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 !!

Laurent
Rank
Userlevel 6
Badge +18

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

ensenada
Badge +4

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

Laurent
Rank
Userlevel 6
Badge +18

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

ponchoh
Rank
Userlevel 4
Badge +13

Hello @ensenada are you using the actual contact id?

this is from your screen shot.

 

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

ensenada
Badge +4

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

Reply


Terms & ConditionsCookie settings