[Blitzkrieg]

Pandora_server crashes with this error in pandora_server.error

Code:

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.

[slerena]

Pandora_server crashes with this error in pandora_server.error

Code:

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 ?

[Blitzkrieg]

Sorry for my bad manners.

Code:

mysql-server-5.5.25
pandora_server-4.0.1_1
pandora_console-4.0.1_1

[Blitzkrieg]

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.

Code:

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.

[Blitzkrieg]

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.

[Blitzkrieg]

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

[slerena]

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.

[Blitzkrieg]

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