Pandora FMS Community

Pandora_server crashes with error.

Blitzkrieg · 27 jun 2012, 16:50 · 8 mensajes · 58 visitas

  1. Inicio del debate

    Pandora_server crashes with this error in pandora_server.error

    DBD::mysql::st execute failed: BIGINT UNSIGNED value is out of range in '((unix_timestamp() - `pandora`.`tagente_estado`.`current_interval`) - `pandora`.`tagente_estado`.`last_execution_try`)' at /usr/local/lib/perl5/site_perl/5.14.2/PandoraFMS/DB.pm line 399.
    
  2. Pandora_server crashes with this error in pandora_server.error

    DBD::mysql::st execute failed: BIGINT UNSIGNED value is out of range in '((unix_timestamp() - `pandora`.`tagente_estado`.`current_interval`) - `pandora`.`tagente_estado`.`last_execution_try`)' at /usr/local/lib/perl5/site_perl/5.14.2/PandoraFMS/DB.pm line 399.
    

    Version of pandora ?, what version of MySQL server are you running ?

  3. Sorry for my bad manners.

    mysql-server-5.5.25
    pandora_server-4.0.1_1
    pandora_console-4.0.1_1
    
  4. And have another problem. Use WMI template to find network devices. It found devices with 3:3 but cant get values of that WMI parameters. It all 0. It is default WMI template. If i assign this template to the agent manually it works fine. But after restarting pandora server it is not working. In pandora_server.error i see following error.

    NTSTATUS: NT_STATUS_ACCESS_DENIED - Access denied
    NTSTATUS: NT_STATUS_ACCESS_DENIED - Access denied
    NTSTATUS: NT_STATUS_ACCESS_DENIED - Access denied
    NTSTATUS: NT_STATUS_ACCESS_DENIED - Access denied
    NTSTATUS: NT_STATUS_ACCESS_DENIED - Access denied
    NTSTATUS: NT_STATUS_CONNECTION_REFUSED - NT_STATUS_CONNECTION_REFUSED
    NTSTATUS: NT_STATUS_ACCESS_DENIED - Access denied
    

    I know that it is mean that user that i use to query WMI parameters have no access for this operation. But it is have it. It is work fine if i create agent manually.

  5. I fix error with Access denied. Sometimes WMI works without using domain prefix in username. But sometimes it is not. But every value of this monitoring is 0 in group that i have made to join discovered hosts. If i use this template to assign it manually it is works fine.

  6. With tcpdump i see that WMI query done and data from monitored host was send. But in pandora_console i dont see any changes.

  7. Try to upgrade to 4.0.2, I think we solve a problem related with negative UNIX timestamp a few weeks ago in the server. If problem persist, we will try to identify the bug.

  8. Thanks for your answer. I will upgrade it when it appears in FreeBSD ports.

Entra en tu cuenta para publicar.