Announcement

Collapse
No announcement yet.

plugin database mysql: Cannot connect, Access denied

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • plugin database mysql: Cannot connect, Access denied

    using plug-in to check the local database mysql error arises:
    Code:
    Cannot connect: Access denied for user 'centreon-engine'@'localhost' (using password: YES)
    with other plug-ins are no problems.

    attempt to connect to this user:
    Code:
    mysql -u centreon-engine -p
    Enter password:
    ERROR 1045 (28000): Access denied for user 'centreon-engine'@'localhost' (using password: YES)
    such a user does not even exist:
    Code:
    MariaDB [mysql]> select user,host from user;
    +----------+------------------+
    | user     | host             |
    +----------+------------------+
    | root     | 127.0.0.1        |
    | root     | ::1              |
    |          | localhost        |
    | centreon | localhost        |
    | root     | localhost        |
    |          | rnd-oms-centreon |
    | root     | rnd-oms-centreon |
    +----------+------------------+
    Last edited by JerzyStuhr; 1 November 2015, 21:36.

  • #2
    example of command for checking:
    Code:
    $USER1$/centreon-plugins/centreon_plugins.pl --plugin database::mysql::plugin --mode connection-time --sqlmode dbi --host localhost --user root --password PASSWORD
    and this embodiment of the command line:
    ./centreon_plugins.pl --plugin database::mysql:lugin --mode connection-time --sqlmode dbi --host localhost --user root --password PASSWORD
    OK: Connection established in 0.034s. | 'connection_time'=34ms;;;0;

    Comment


    • #3
      Help is required, it has earned itself

      User centreon-engine with a blank password:
      Code:
      mysql -u centreon-engine -p
      Enter password: 
      Welcome to the MariaDB monitor.  Commands end with ; or \g.

      Comment


      • #4
        People, Im trying to execute in centreon the script "reporting_rrd.pl" --> https://github.com/sgaudart/reporting_rrd
        But when I am execute the script:
        [[email protected] plugins]# perl reporting_rrd.pl --hostfile enodeb.txt --service S1aplnkTOP
        Use of uninitialized value $password in concatenation (.) or string at reporting_rrd.pl line 203.
        Enter password:
        ERROR 1045 (28000): Access denied for user 'centreon'@'localhost' (using password: NO)
        enodeb.txt service:S1aplnkTOP From:01-06-2017 to 01-07-2017
        +----------+---------+--------+-------+
        Use of uninitialized value $unit in concatenation (.) or string at reporting_rrd.pl line 304.
        | hostname | service | metric | value ()|
        +----------+---------+--------+-------+
        +----------+---------+--------+-------+
        [[email protected] plugins]#

        Help me please!
        thanks!

        Comment

        Working...
        X