Solved

Not able to login after migrating to 21.10

muhammed.suhile
Badge +3

Hi Legends,

 

I did migrate centreon from 2.8.32 to 21.10 and I am not able login to centreon web. I am getting error “Your credentials are incorrect.”. I have tried both localhost and ldap credentials, both are not working.

  1. /var/log/centreon/login.log   -- is empty
  2. /var/log/centreon/ldapsearch.log  -- result is below

[02/03/2022 11:14] LDAP Error : Invalid credentials

[02/03/2022 11:14] LDAP Connect : Bind : Invalid credentials

[02/03/2022 11:14] LDAP Connect : connection error 

  1. /var/log/centreon/ldap.log   - is not available.

I followed these steps and the upgrade was successful and I am still able to access CLI.

 

 Please help me.

icon

Best answer by Kriko 3 March 2022, 13:17

View original

16 replies

muhammed.suhile
Badge +3

I have already verified in centreon.contact table that “contact_auth_type” to “local” for the admin user.

K
Userlevel 5
Badge +16

Hello @muhammed.suhile ,

Do you have done the change of the apache configuration ?

Could you give us the 10-centreon.conf of your apache configuration ?

 

It should be in /opt/rh/httpd24/root/etc/httpd/conf.d/ directory.

if you can also provide us your centreon-error.log in the folder /var/log/php-fpm it could be interresting!

muhammed.suhile
Badge +3

Not changed any configs, Apart from changing mysql password for centreon user to fix “MySQL error : cannot connect to database centreon: Access denied for user 'centreon'@'localhost' (using password: YES)”

-10-centreon.conf

#
# Section added by Centreon Install Setup
#
Header set X-Frame-Options: "sameorigin"
Header always edit Set-Cookie ^(.*)$ $1;HttpOnly
ServerSignature Off
ServerTokens Prod
TraceEnable Off

Alias /centreon/api /usr/share/centreon
Alias /centreon /usr/share/centreon/www/

<LocationMatch ^/centreon/(?!api/latest/|api/beta/|api/v[0-9]+/|api/v[0-9]+\.[0-9]+/)(.*\.php(/.*)?)$>
    ProxyPassMatch fcgi://127.0.0.1:9042/usr/share/centreon/www/$1
</LocationMatch>

<LocationMatch ^/centreon/(authentication|api/(latest|beta|v[0-9]+|v[0-9]+\.[0-9]+))/.*$>
    ProxyPassMatch fcgi://127.0.0.1:9042/usr/share/centreon/api/index.php/$1
</LocationMatch>

ProxyTimeout 300

<Directory "/usr/share/centreon/www">
    DirectoryIndex index.php
    Options Indexes
    AllowOverride all
    Order allow,deny
    Allow from all
    Require all granted
    <IfModule mod_php5.c>
        php_admin_value engine Off
    </IfModule>

    FallbackResource /centreon/index.html

    AddType text/plain hbs
</Directory>

<Directory "/usr/share/centreon/api">
    Options Indexes
    AllowOverride all
    Order allow,deny
    Allow from all
    Require all granted
    <IfModule mod_php5.c>
        php_admin_value engine Off
    </IfModule>

    AddType text/plain hbs
</Directory>

RedirectMatch ^/$ /centreon

 

 

K
Userlevel 5
Badge +16

Ok seems good.
And what do you have in /var/log/php-fpm/centreon-error.log when you try to login ?

what is the return of :

systemctl status mariadbd
systemctl status httpd24-httpd
systemctl status php-fpm

 

muhammed.suhile
Badge +3

 centreon-error.log

 

[02-Mar-2022 06:59:12 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:00:12 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:01:13 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:02:13 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:03:13 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:04:13 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:05:14 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:06:14 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:07:15 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:08:15 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:09:15 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:10:15 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:11:16 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:12:16 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:13:17 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:14:17 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:15:17 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:16:17 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:17:18 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:18:18 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:19:18 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:20:18 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:21:21 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:22:21 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:23:22 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:24:22 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:25:30 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:26:28 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:27:29 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:28:29 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:29:29 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:30:29 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:31:30 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:32:30 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:33:30 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:34:30 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:35:31 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:36:31 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:37:31 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:38:31 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:39:31 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:40:31 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:41:32 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:42:32 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:43:32 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:44:32 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:45:33 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:46:33 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:47:34 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:48:34 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:49:34 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:50:34 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:51:34 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:52:34 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:53:35 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:54:35 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:55:35 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:56:35 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:57:35 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:58:35 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 07:59:36 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 08:00:36 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 08:01:36 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 08:02:36 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 08:03:36 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 08:04:36 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 08:05:37 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 08:06:16 America/New_York] PHP Warning:  Undefined array key "finish" in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 49
[02-Mar-2022 08:06:16 America/New_York] PHP Warning:  Attempt to read property "value" on null in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 49
[02-Mar-2022 08:06:16 America/New_York] PHP Warning:  Undefined array key "finish" in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 68
[02-Mar-2022 08:06:16 America/New_York] PHP Warning:  Attempt to read property "value" on null in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 68
[02-Mar-2022 08:06:20 America/New_York] PHP Warning:  Undefined array key "finish" in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 49
[02-Mar-2022 08:06:20 America/New_York] PHP Warning:  Attempt to read property "value" on null in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 49
[02-Mar-2022 08:06:20 America/New_York] PHP Warning:  Undefined array key "blockPreview" in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 61
[02-Mar-2022 08:06:20 America/New_York] PHP Warning:  Attempt to read property "value" on null in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 61
[02-Mar-2022 08:06:20 America/New_York] PHP Warning:  Undefined array key "finish" in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 68
[02-Mar-2022 08:06:20 America/New_York] PHP Warning:  Attempt to read property "value" on null in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 68
[02-Mar-2022 08:06:37 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 08:07:37 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 08:08:37 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 08:09:16 America/New_York] PHP Warning:  Undefined array key "finish" in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 49
[02-Mar-2022 08:09:16 America/New_York] PHP Warning:  Attempt to read property "value" on null in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 49
[02-Mar-2022 08:09:16 America/New_York] PHP Warning:  Undefined array key "finish" in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 68
[02-Mar-2022 08:09:16 America/New_York] PHP Warning:  Attempt to read property "value" on null in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 68
[02-Mar-2022 08:09:19 America/New_York] PHP Warning:  Undefined array key "finish" in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 49
[02-Mar-2022 08:09:19 America/New_York] PHP Warning:  Attempt to read property "value" on null in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 49
[02-Mar-2022 08:09:19 America/New_York] PHP Warning:  Undefined array key "blockPreview" in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 61
[02-Mar-2022 08:09:19 America/New_York] PHP Warning:  Attempt to read property "value" on null in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 61
[02-Mar-2022 08:09:19 America/New_York] PHP Warning:  Undefined array key "finish" in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 68
[02-Mar-2022 08:09:19 America/New_York] PHP Warning:  Attempt to read property "value" on null in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 68
[02-Mar-2022 08:09:37 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 08:10:37 America/New_York] CRITICAL: SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) {"context":"[object] (PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'centreon'@'localhost' (using password: YES) at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}

[02-Mar-2022 08:11:38 America/New_York] CRITICAL: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'centreon.security_authentication_tokens' doesn't exist {"context":"[object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'centreon.security_authentication_tokens' doesn't exist at /usr/share/centreon/src/Security/Infrastructure/Repository/AuthenticationRepository.php:201)"}

[02-Mar-2022 08:12:39 America/New_York] CRITICAL: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'centreon.security_authentication_tokens' doesn't exist {"context":"[object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'centreon.security_authentication_tokens' doesn't exist at /usr/share/centreon/src/Security/Infrastructure/Repository/AuthenticationRepository.php:201)"}

[02-Mar-2022 08:12:48 America/New_York] PHP Warning:  Undefined array key "finish" in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 49
[02-Mar-2022 08:12:48 America/New_York] PHP Warning:  Attempt to read property "value" on null in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 49
[02-Mar-2022 08:12:48 America/New_York] PHP Warning:  Undefined array key "finish" in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 68
[02-Mar-2022 08:12:48 America/New_York] PHP Warning:  Attempt to read property "value" on null in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 68
[02-Mar-2022 08:12:52 America/New_York] PHP Warning:  Undefined array key "finish" in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 49
[02-Mar-2022 08:12:52 America/New_York] PHP Warning:  Attempt to read property "value" on null in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 49
[02-Mar-2022 08:12:52 America/New_York] PHP Warning:  Undefined array key "finish" in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 68
[02-Mar-2022 08:12:52 America/New_York] PHP Warning:  Attempt to read property "value" on null in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 68
[02-Mar-2022 08:13:01 America/New_York] PHP Warning:  Trying to access array offset on value of type bool in /usr/share/centreon/www/install/php/Update-19.10.0-beta.3.php on line 331
[02-Mar-2022 08:13:17 America/New_York] PHP Warning:  Trying to access array offset on value of type bool in /usr/share/centreon/www/install/step_upgrade/step5.php on line 54
[02-Mar-2022 08:13:39 America/New_York] CRITICAL: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'centreon.security_authentication_tokens' doesn't exist {"context":"[object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'centreon.security_authentication_tokens' doesn't exist at /usr/share/centreon/src/Security/Infrastructure/Repository/AuthenticationRepository.php:201)"}

[02-Mar-2022 08:13:39 America/New_York] CRITICAL: Error while searching provider configuration: 'local' {"context":"[object] (Security\\Domain\\Authentication\\Exceptions\\ProviderException(code: 0): Error while searching provider configuration: 'local' at /usr/share/centreon/src/Security/Domain/Authentication/Exceptions/ProviderException.php:64)\n[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'centreon.provider_configuration' doesn't exist at /usr/share/centreon/src/Security/Infrastructure/Repository/ProviderRepository.php:90)"}

[02-Mar-2022 08:14:39 America/New_York] CRITICAL: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'centreon.security_authentication_tokens' doesn't exist {"context":"[object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'centreon.security_authentication_tokens' doesn't exist at /usr/share/centreon/src/Security/Infrastructure/Repository/AuthenticationRepository.php:201)"}

[02-Mar-2022 08:14:48 America/New_York] CRITICAL: Error while searching provider configuration: 'local' {"context":"[object] (Security\\Domain\\Authentication\\Exceptions\\ProviderException(code: 0): Error while searching provider configuration: 'local' at /usr/share/centreon/src/Security/Domain/Authentication/Exceptions/ProviderException.php:64)\n[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'centreon.provider_configuration' doesn't exist at /usr/share/centreon/src/Security/Infrastructure/Repository/ProviderRepository.php:90)"}

[02-Mar-2022 08:14:50 America/New_York] CRITICAL: Error while searching provider configuration: 'local' {"context":"[object] (Security\\Domain\\Authentication\\Exceptions\\ProviderException(code: 0): Error while searching provider configuration: 'local' at /usr/share/centreon/src/Security/Domain/Authentication/Exceptions/ProviderException.php:64)\n[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'centreon.provider_configuration' doesn't exist at /usr/share/centreon/src/Security/Infrastructure/Repository/ProviderRepository.php:90)"}

[02-Mar-2022 08:14:50 America/New_York] CRITICAL: Error while searching provider configuration: 'local' {"context":"[object] (Security\\Domain\\Authentication\\Exceptions\\ProviderException(code: 0): Error while searching provider configuration: 'local' at /usr/share/centreon/src/Security/Domain/Authentication/Exceptions/ProviderException.php:64)\n[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'centreon.provider_configuration' doesn't exist at /usr/share/centreon/src/Security/Infrastructure/Repository/ProviderRepository.php:90)"}

[02-Mar-2022 08:14:51 America/New_York] CRITICAL: Error while searching provider configuration: 'local' {"context":"[object] (Security\\Domain\\Authentication\\Exceptions\\ProviderException(code: 0): Error while searching provider configuration: 'local' at /usr/share/centreon/src/Security/Domain/Authentication/Exceptions/ProviderException.php:64)\n[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'centreon.provider_configuration' doesn't exist at /usr/share/centreon/src/Security/Infrastructure/Repository/ProviderRepository.php:90)"}

[02-Mar-2022 08:14:52 America/New_York] CRITICAL: Error while searching provider configuration: 'local' {"context":"[object] (Security\\Domain\\Authentication\\Exceptions\\ProviderException(code: 0): Error while searching provider configuration: 'local' at /usr/share/centreon/src/Security/Domain/Authentication/Exceptions/ProviderException.php:64)\n[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'centreon.provider_configuration' doesn't exist at /usr/share/centreon/src/Security/Infrastructure/Repository/ProviderRepository.php:90)"}

[02-Mar-2022 08:14:58 America/New_York] CRITICAL: Error while searching provider configuration: 'local' {"context":"[object] (Security\\Domain\\Authentication\\Exceptions\\ProviderException(code: 0): Error while searching provider configuration: 'local' at /usr/share/centreon/src/Security/Domain/Authentication/Exceptions/ProviderException.php:64)\n[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'centreon.provider_configuration' doesn't exist at /usr/share/centreon/src/Security/Infrastructure/Repository/ProviderRepository.php:90)"}

[02-Mar-2022 08:14:59 America/New_York] CRITICAL: Error while searching provider configuration: 'local' {"context":"[object] (Security\\Domain\\Authentication\\Exceptions\\ProviderException(code: 0):
 

 

muhammed.suhile
Badge +3

uploaded the /var/log/php-fpm/centreon-error.log and its waiting for approval.

  1. [root@papernm04 php-fpm]# systemctl status mariadbd
    Unit mariadbd.service could not be found.

  2. [root@papernm04 php-fpm]# systemctl status httpd24-httpd
    ● httpd24-httpd.service - The Apache HTTP Server
       Loaded: loaded (/usr/lib/systemd/system/httpd24-httpd.service; enabled; vendor preset: disabled)
       Active: active (running) since Wed 2022-03-02 14:11:53 EST; 14h ago
     Main PID: 1107 (httpd)
       Status: "Total requests: 946; Idle/Busy workers 100/0;Requests/sec: 0.0182; Bytes served/sec:  17 B/sec"
       CGroup: /system.slice/httpd24-httpd.service
               ├─1107 /opt/rh/httpd24/root/usr/sbin/httpd -DFOREGROUND
               ├─1385 /opt/rh/httpd24/root/usr/sbin/httpd -DFOREGROUND
               ├─1386 /opt/rh/httpd24/root/usr/sbin/httpd -DFOREGROUND
               ├─1387 /opt/rh/httpd24/root/usr/sbin/httpd -DFOREGROUND
               ├─1392 /opt/rh/httpd24/root/usr/sbin/httpd -DFOREGROUND
               ├─1399 /opt/rh/httpd24/root/usr/sbin/httpd -DFOREGROUND
               ├─1646 /opt/rh/httpd24/root/usr/sbin/httpd -DFOREGROUND
               └─7262 /opt/rh/httpd24/root/usr/sbin/httpd -DFOREGROUND

    Mar 02 14:11:52 papernm04 systemd[1]: Starting The Apache HTTP Server...
    Mar 02 14:11:53 papernm04 httpd-scl-wrapper[1107]: AH00558: httpd: Could not reliably determine the server's fully qualified d...essage
    Mar 02 14:11:53 papernm04 systemd[1]: Started The Apache HTTP Server.
    Hint: Some lines were ellipsized, use -l to show in full.

  3. [root@papernm04 php-fpm]# systemctl status php-fpm
    ● php-fpm.service - The PHP FastCGI Process Manager
       Loaded: loaded (/usr/lib/systemd/system/php-fpm.service; enabled; vendor preset: disabled)
      Drop-In: /etc/systemd/system/php-fpm.service.d
               └─centreon.conf
       Active: active (running) since Wed 2022-03-02 14:11:55 EST; 14h ago
     Main PID: 1111 (php-fpm)
       Status: "Processes active: 0, idle: 5, Requests: 946, slow: 0, Traffic: 0req/sec"
       CGroup: /system.slice/php-fpm.service
               ├─1111 php-fpm: master process (/etc/php-fpm.conf)
               ├─1533 php-fpm: pool www
               ├─1534 php-fpm: pool www
               ├─1535 php-fpm: pool www
               ├─1536 php-fpm: pool www
               └─1537 php-fpm: pool www

    Mar 02 14:11:52 papernm04 systemd[1]: Starting The PHP FastCGI Process Manager...
    Mar 02 14:11:55 papernm04 systemd[1]: Started The PHP FastCGI Process Manager.
     

muhammed.suhile
Badge +3

I have updated database password for centreon user for below files as advised in the migration document.

/etc/centreon/centreon.conf.php

/etc/centreon/conf.pm file

/etc/centreon/config.d/10-database.yaml

muhammed.suhile
Badge +3

Here is what I am getting in  /var/log/php-fpm/centreon-error.log when login.

------------------------------ 

[03-Mar-2022 05:20:06 America/New_York] CRITICAL: Error while searching provider configuration: 'local' {"context":"[object] (Security\\Domain\\Authentication\\Exceptions\\ProviderException(code: 0): Error while searching provider configuration: 'local' at /usr/share/centreon/src/Security/Domain/Authentication/Exceptions/ProviderException.php:64)\n[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'centreon.provider_configuration' doesn't exist at /usr/share/centreon/src/Security/Infrastructure/Repository/ProviderRepository.php:90)"}
 

K
Userlevel 5
Badge +16

Coudl you create the following table:
 

CREATE TABLE `provider_configuration` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `is_forced` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

Try to connect to your mysql using mysql command and once connected you can use the following command:
 

use centreon;

 

muhammed.suhile
Badge +3

Created the table successfully. but still not able to login.

 

Error in mariadb service status same as before.

--------------------------------------

Mar 03 05:34:02 papernm04 mariadbd[3662]: 2022-03-03  5:34:02 18 [Warning] Access denied for user 'centreon'@'localhost' (using password: YES)

------------------------------------

 

centreon-error.log got a new error now.

[03-Mar-2022 05:36:09 America/New_York] CRITICAL: Provider configuration (local) not found {"context":"[object] (Security\\Domain\\Authentication\\Exceptions\\ProviderException(code: 0): Provider configuration (local) not found at /usr/share/centreon/src/Security/Domain/Authentication/Exceptions/ProviderException.php:38)"}

K
Userlevel 5
Badge +16

Sorry about this, I forgot something.
could play this request:
 

INSERT INTO `provider_configuration` VALUES (1,'local','local',1,1);

 

muhammed.suhile
Badge +3

Added the values to the table.

centreon-error.log now.

[03-Mar-2022 05:46:55 America/New_York] WARNING: Warning: Undefined array key "enable_one_click_export" {"exception":"[object] (ErrorException(code: 0): Warning: Undefined array key \"enable_one_click_export\" at /usr/share/centreon/src/Centreon/Infrastructure/Contact/ContactRepositoryRDB.php:385)"}

[03-Mar-2022 05:46:55 America/New_York] WARNING: Warning: Undefined array key "enable_one_click_export" {"exception":"[object] (ErrorException(code: 0): Warning: Undefined array key \"enable_one_click_export\" at /usr/share/centreon/src/Centreon/Infrastructure/Contact/ContactRepositoryRDB.php:385)"}

[03-Mar-2022 05:46:55 America/New_York] CRITICAL: Error while searching authentication tokens {"context":"[object] (Centreon\\Domain\\Authentication\\Exception\\AuthenticationException(code: 0): Error while searching authentication tokens at /usr/share/centreon/src/Centreon/Domain/Authentication/Exception/AuthenticationException.php:123)\n[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'centreon.security_authentication_tokens' doesn't exist at /usr/share/centreon/src/Security/Infrastructure/Repository/AuthenticationRepository.php:201)"}

 

K
Userlevel 5
Badge +16

It seems to miss a lot of tables.
Could you send me the output of the following command (in mysql prompt)

use centreon;
SHOW TABLES;

And I will send you all the missing tables.

muhammed.suhile
Badge +3

+----------------------------------------+
| Tables_in_centreon                     |
+----------------------------------------+
| acl_actions                            |
| acl_actions_rules                      |
| acl_group_actions_relations            |
| acl_group_contactgroups_relations      |
| acl_group_contacts_relations           |
| acl_group_topology_relations           |
| acl_groups                             |
| acl_res_group_relations                |
| acl_resources                          |
| acl_resources_hc_relations             |
| acl_resources_hg_relations             |
| acl_resources_host_relations           |
| acl_resources_hostex_relations         |
| acl_resources_meta_relations           |
| acl_resources_poller_relations         |
| acl_resources_sc_relations             |
| acl_resources_service_relations        |
| acl_resources_sg_relations             |
| acl_topology                           |
| acl_topology_relations                 |
| auth_ressource                         |
| auth_ressource_host                    |
| auth_ressource_info                    |
| cb_field                               |
| cb_fieldgroup                          |
| cb_fieldset                            |
| cb_list                                |
| cb_list_values                         |
| cb_log                                 |
| cb_log_level                           |
| cb_module                              |
| cb_module_relation                     |
| cb_tag                                 |
| cb_tag_type_relation                   |
| cb_type                                |
| cb_type_field_relation                 |
| cfg_centreonbroker                     |
| cfg_centreonbroker_info                |
| cfg_centreonbroker_log                 |
| cfg_nagios                             |
| cfg_nagios_broker_module               |
| cfg_resource                           |
| cfg_resource_instance_relations        |
| command                                |
| command_arg_description                |
| command_categories                     |
| command_categories_relation            |
| connector                              |
| contact                                |
| contact_feature                        |
| contact_host_relation                  |
| contact_hostcommands_relation          |
| contact_param                          |
| contact_service_relation               |
| contact_servicecommands_relation       |
| contactgroup                           |
| contactgroup_contact_relation          |
| contactgroup_host_relation             |
| contactgroup_hostgroup_relation        |
| contactgroup_service_relation          |
| contactgroup_servicegroup_relation     |
| cron_operation                         |
| css_color_menu                         |
| custom_view_default                    |
| custom_view_user_relation              |
| custom_views                           |
| dependency                             |
| dependency_hostChild_relation          |
| dependency_hostParent_relation         |
| dependency_hostgroupChild_relation     |
| dependency_hostgroupParent_relation    |
| dependency_metaserviceChild_relation   |
| dependency_metaserviceParent_relation  |
| dependency_serviceChild_relation       |
| dependency_serviceParent_relation      |
| dependency_servicegroupChild_relation  |
| dependency_servicegroupParent_relation |
| downtime                               |
| downtime_cache                         |
| downtime_host_relation                 |
| downtime_hostgroup_relation            |
| downtime_period                        |
| downtime_service_relation              |
| downtime_servicegroup_relation         |
| escalation                             |
| escalation_contactgroup_relation       |
| escalation_host_relation               |
| escalation_hostgroup_relation          |
| escalation_meta_service_relation       |
| escalation_service_relation            |
| escalation_servicegroup_relation       |
| extended_host_information              |
| extended_service_information           |
| giv_components_template                |
| giv_graphs_template                    |
| host                                   |
| host_hostparent_relation               |
| host_service_relation                  |
| host_template_relation                 |
| hostcategories                         |
| hostcategories_relation                |
| hostgroup                              |
| hostgroup_hg_relation                  |
| hostgroup_relation                     |
| informations                           |
| locale                                 |
| meta_contact                           |
| meta_contactgroup_relation             |
| meta_service                           |
| meta_service_relation                  |
| mod_ppm_categories                     |
| mod_ppm_host_service_relation          |
| mod_ppm_icons                          |
| mod_ppm_information_url                |
| mod_ppm_pluginpack                     |
| mod_ppm_pluginpack_command             |
| mod_ppm_pluginpack_dependency          |
| mod_ppm_pluginpack_host                |
| mod_ppm_pluginpack_service             |
| mod_ppm_resultset_tpl                  |
| modules_informations                   |
| nagios_macro                           |
| nagios_server                          |
| ns_host_relation                       |
| ods_view_details                       |
| on_demand_macro_command                |
| on_demand_macro_host                   |
| on_demand_macro_service                |
| options                                |
| platform_topology                      |
| poller_command_relations               |
| provider_configuration                 |
| remote_servers                         |
| rs_poller_relation                     |
| service                                |
| service_categories                     |
| service_categories_relation            |
| servicegroup                           |
| servicegroup_relation                  |
| session                                |
| task                                   |
| timeperiod                             |
| timeperiod_exceptions                  |
| timeperiod_exclude_relations           |
| timeperiod_include_relations           |
| timezone                               |
| topology                               |
| topology_JS                            |
| traps                                  |
| traps_group                            |
| traps_group_relation                   |
| traps_matching_properties              |
| traps_preexec                          |
| traps_service_relation                 |
| traps_vendor                           |
| user_filter                            |
| view_img                               |
| view_img_dir                           |
| view_img_dir_relation                  |
| virtual_metrics                        |
| widget_models                          |
| widget_parameters                      |
| widget_parameters_field_type           |
| widget_parameters_multiple_options     |
| widget_parameters_range                |
| widget_preferences                     |
| widget_views                           |
| widgets                                |
| ws_token                               |
+----------------------------------------+
169 rows in set (0.001 sec)
 

K
Userlevel 5
Badge +16

Here we go:

 

CREATE TABLE `security_token` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `token` varchar(255) NOT NULL,
  `creation_date` bigint(20) unsigned NOT NULL,
  `expiration_date` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_token` (`token`),
  KEY `token_index` (`token`),
  KEY `expiration_index` (`expiration_date`)
) ENGINE=InnoDB AUTO_INCREMENT=31270 DEFAULT CHARSET=utf8;

CREATE TABLE `security_authentication_tokens` (
  `token` varchar(255) NOT NULL,
  `provider_token_id` int(11) DEFAULT NULL,
  `provider_token_refresh_id` int(11) DEFAULT NULL,
  `provider_configuration_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`token`),
  KEY `security_authentication_tokens_token_fk` (`token`),
  KEY `security_authentication_tokens_provider_token_id_fk` (`provider_token_id`),
  KEY `security_authentication_tokens_provider_token_refresh_id_fk` (`provider_token_refresh_id`),
  KEY `security_authentication_tokens_configuration_id_fk` (`provider_configuration_id`),
  KEY `security_authentication_tokens_user_id_fk` (`user_id`),
  CONSTRAINT `security_authentication_tokens_configuration_id_fk` FOREIGN KEY (`provider_configuration_id`) REFERENCES `provider_configuration` (`id`) ON DELETE CASCADE,
  CONSTRAINT `security_authentication_tokens_provider_token_id_fk` FOREIGN KEY (`provider_token_id`) REFERENCES `security_token` (`id`) ON DELETE CASCADE,
  CONSTRAINT `security_authentication_tokens_provider_token_refresh_id_fk` FOREIGN KEY (`provider_token_refresh_id`) REFERENCES `security_token` (`id`) ON DELETE SET NULL,
  CONSTRAINT `security_authentication_tokens_user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `contact` (`contact_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `security_token` VALUES (31208,'7ZuKM890VBZUOQPqGekOKRWvz04/z+btOpR2cCju72HwIvxfrCAvPhghFlq3WJvH',1643365783,1646316822),(31268,'prsc83mbq9fq8ejrgrgbm19kg0',1646299161,1646306454),(31269,'3NXyO/DY48X7ouCzKlsWt6DY7xT7o8NdjCdy8OCmhDhMhGRAPM9jvBFlvW5S3++c',1646299214,1646306415);

INSERT INTO `security_authentication_tokens` VALUES ('3NXyO/DY48X7ouCzKlsWt6DY7xT7o8NdjCdy8OCmhDhMhGRAPM9jvBFlvW5S3++c',31269,NULL,1,1),('7ZuKM890VBZUOQPqGekOKRWvz04/z+btOpR2cCju72HwIvxfrCAvPhghFlq3WJvH',31208,NULL,1,1),('prsc83mbq9fq8ejrgrgbm19kg0',31268,NULL,1,1);


I hope that I forgot nothing.

muhammed.suhile
Badge +3

Thank you, It worked.

You are great.

Reply


Terms & ConditionsCookie settings