Pandora FMS Community

Update to the latest version

Girardot · 3 nov 2022, 16:14 · 5 mensajes · 132 visitas

errorUpdate
  1. Inicio del debate
    Hello, We have updated our server to the latest Pandora version (FMS V7.0NG.765). When I run database checks through the tool, I get the following errors that I don't know how to fix. Can you explain to me how to do it?
    Regards.
    log.txt4.8 KB · TXT
    1SUCCÈS
    2Succès! Pandora FMS La base de données contient toutes les tables
    3 ERREUR
    4Unsuccessful the field id_agent_module_inventory in the table tagent_module_inventory must be set as defined in the SQL file.
    5 INFORMATION
    6
    7
    8Please check the SQL file for to know the kind of extra config needed.
    9 ERREUR
    10Unsuccessful the field id_agent_module_log in the table tagent_module_log must be set as defined in the SQL file.
    11 INFORMATION
    12
    13
    14Please check the SQL file for to know the kind of extra config needed.
    15 ERREUR
    Vista previa truncada. descargar
    log.png27 KB · PNG
    log.png
  2. Hi Girardot,

    Can you tell us from which version you have upgraded?

    Can you tell us how you upgraded?

    Because from the errors it seems that it is a database structure problem (the RMs are not applied correctly).

    In any case, I recommend you to upgrade using packages.

    Console package.

    Server package.

    Manual database update.

    Anyway, I will attach the link to our wiki to show you the procedure.

    https://pandorafms.com/manual/start?id=en/quickguides/update\_version\_7\_0ng

    Best regards,

    Víc.

  3. Hello

    Thank you for your reply.

    I have multiple Pandora servers.

    I have the problem with several versions :

    Pandora FMS v7.0NG.765 -> Pandora FMS v7.0NG.766

    Pandora FMS v7.0NG.758 -> Pandora FMS v7.0NG.766

    Here is the procedure I follow :

    - With the Admin account, from the Warp Update menu -> Online Update, I installe the update.

    - I download the file pandora_server.conf and update the pandora_server.conf.new.

    - Once updated I replace the file on the server after having renamed it correctly.

    - Then, in the "Administrative tools" menu -> "Check database schema", I test the database.

    - I execute the SQL queries indicated by the tool.

    Regards.

    Sébastien

  4. Hi Girardot,

    As far as I can see from what you say, both servers do not have the same version at console and server level.

    Could I update them manually via packages and then reapply the MR files from the pre-upgrade MR?

    Use the following link.

    https://pandorafms.com/manual/start?id=en/quickguides/update\_version\_7\_0ng

    Don't forget to restart the Pandora FMS server processes to apply the upgrade changes correctly.

    Best regards,

    Víctor.

  5. Hi,

    I think I solved my problem. I don't know why but I had auto_increment which was no longer present on some tables in the database.

    After putting them back, I have no more errors.

    Regards.

Entra en tu cuenta para publicar.