Welcome to Pandora FMS Community!

Find answers, ask questions, and connect with our community around the world.

Welcome to Pandora FMS Community Forums Soporte de la comunidad Database access denied using online installer

  • Database access denied using online installer

    Posted by unlisted on May 11, 2023 at 17:15

    How do I get the online installer (curl -sSL https://pfms.me/deploy-pandora-el8 | bash) to successfully setup and configure a new FMS installation on a new RHEL8 install? It goes through the scripts fine and then fails with ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES) at the point of creating Pandora FMS database. I have tried it with and without first installing MySQL. Even when the script does everything from scratch, including Percona (MySQL) server I still get the same message.

    unlisted replied 1 year, 2 months ago 2 Members · 2 Replies
  • 2 Replies
  • vic

    Administrator
    May 12, 2023 at 13:12
    1418 Karma points
    Community awards: bulb Bright ideas
    Community rank: tentacle_master_icon Tentacle Master
    Like it
    Up
    0
    Down
    Drop it
    ::

    Hi unlisted!

    Is the machine new? Or is it a machine to be reused?

    It is possible that if it has some MySQL package already installed it might fail, since it would have other configurations than the update script.

    Can you tell us which OS version you have?

    Best regards,

    Víctor.

  • unlisted

    Member
    May 12, 2023 at 17:36
    19 Karma points
    Community rank: tentacle-noob-1 Tentacle noob
    Like it
    Up
    0
    Down
    Drop it
    ::

    It was a new RHEL 8 installation. I found the issue. I had installed MySQL using the yum package installer since I was planning on the yum installation method for Pandora FMS. I removed MySQL, again via yum, in order to use the online installer method. But there were some files that remained.

    The resolution was to remove /var/lib/mysql manually.