Welcome to Pandora FMS Community!

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

Welcome to Pandora FMS Community Forums Community support Ubuntu 22.04 Error PANDORA Install

  • Ubuntu 22.04 Error PANDORA Install

    Posted by Manuel on January 24, 2023 at 16:10

    Hello,

    I have a problem with the installation of pandora on a Linux 22.04 server

    When I follow the installation via the tutorials, I have a problem with the following packages

    ———————————————————————————————————

    pandorafms-console dépend de php-gettext ; cependant :

    Le paquet php-gettext n’est pas installé.

    pandorafms-console dépend de php7.2-zip | php-zip ; cependant :

    Le paquet php7.2-zip n’est pas installé.

    Le paquet php-zip n’est pas installé.

    ———————————————————————————————————

    Further in the procedure, I have a problem with mysql

    I have the following error

    ———————————————————————————————————

    MariaDB [(none)]> use mysql

    Reading table information for completion of table and column names

    You can turn off this feature to get a quicker startup with -A

    Database changed

    MariaDB [mysql]> UPDATE user SET plugin=’mysql_native_password’ WHERE User=’root’;

    ERROR 1356 (HY000): View ‘mysql.user’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

    ———————————————————————————————————

    I need help

    Tanks a lot

    Manuel replied 1 year, 10 months ago 2 Members · 2 Replies
  • 2 Replies
  • Sergio

    Administrator
    January 24, 2023 at 17:22
    1322 Karma points
    Community rank: tentacle_master_icon Tentacle Master
    Like it
    Up
    0
    Down
    Drop it
    ::

    Hello,

    When installing a new Ubuntu Server 22.04 Pandora FMS installation you can actually use a script that configures and install all dependencies in the server.

    You can take a look at our documentation here:

    https://pandorafms.com/manual/en/documentation/02_installation/01_installing#online_installation_tool

    The point 1.8.4 explains everything related to Ubuntu 22.04 online Installation requisites and steps where you can find the installation script that you can use to deploy pandora in a freshly new Ubuntu Server 22.04 installation

    curl -SsL https://pfms.me/deploy-pandora-ubuntu | bash

    We strongly recommend you to use this script as it will solve many of the errors you have at the moment.

    Just be aware that you need to have a newly fresh ubuntu server installation so the script has no conflict with packages, mysql, nor apache deployment as we can see that you already installed Maria DB in your server.

    If you have the chance to start with a fresh installation this will make it way easier to install.

    In case you cannot start over, please let us know and we can try to help you solve some of the issues you mention but bear in mind that we don’t recommend Maria DB as MySQL manager.

    Kind regards,

    Sergio B.

  • Manuel

    Member
    January 25, 2023 at 16:45
    100 Karma points
    Community rank: tentacle-noob-1 Tentacle noob
    Like it
    Up
    0
    Down
    Drop it
    ::

    Thank you very much Sergio

    I am indeed used to Ubuntu servers, and I did’nt look for others solutions, with Pandroa prerequisites.

    So I launched the implementation of Pandora with CentOs 7

    I also test the installation with docker, but I’m a total novice… (Problem with the mysql link, in an independent docker if I understand correctly…).