Pandora FMS Community

SQL errors in Pandora

Christophe · 22 feb 2023, 13:47 · 5 mensajes · 72 visitas

  1. Inicio del debate

    Hello,

    For some time now, there are SQL errors that appear on some pages of Pandora. I have analyzed two of the queries that cause problems, it seems that they are the queries counting the total number of agents and those counting the total number of alerts on the home page and in the tactical view (by the way the number of agents and alerts are no longer displayed). There are also other SQL errors that are displayed.

    We have the case on the majority of our Pandora servers, except on one, but all are in version Pandora FMS v7.0NG.767 Hope - OUM 767 - MR 59.

    Do the messages come from development errors or is it a problem that we have introduced?

    Thanks in advance,

    Kind regards

    2023-02-22-13_44_57-Pandora-FMS-Systeme-de-surveillance-flexible.png52 KB · PNG
    2023-02-22-13_44_57-Pandora-FMS-Systeme-de-surveillance-flexible.png
  2. Hi Christophe,

    Can you check that your MySQL has been optimised in your /etc/my.cnf file?

    On the other hand, you can check if in the /etc/my.cnf file you have the following parameter as follows.

    sql_mode=""
    

    Best regards,

    Víc.

  3. Thanks for your answer,

    I compared the /etc/my.cnf files of a server where the error is present and the server where there is no error, which are indeed different.

    I changed the file of the server with the error to be the same as the server with no error and restarted the server.

    But when I reload the page, the SQL errors are still there.

    I put you a capture of the two files, on the left the one of the server displaying the errors and on the right the one of the server which does not display any errors

    2023-02-22-17_40_47-C__Users_mdubail.KUBA_Documents_Pandora_KP1.0_my.cnf-Notepad.png23 KB · PNG
    2023-02-22-17_40_47-C__Users_mdubail.KUBA_Documents_Pandora_KP1.0_my.cnf-Notepad.png
  4. Hi Christophe,

    Can you tell us what version of MySQL all the nodes on which the problem is found have?

    In case it is a MySQL compatibility problem.

    Best regards,

    Víc.

  5. I solved the problem by analyzing the code, it was a group with a id_grupo = 0 in the database that was causing the problem.

    Thanks for your help !

Entra en tu cuenta para publicar.