Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Pandora_server crashes with error.
#1
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.
 Reply
#2
(06-27-2012, 12:50 PM)Blitzkrieg link Wrote: 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 ?
 Reply
#3
Sorry for my bad manners.
Code:
mysql-server-5.5.25
pandora_server-4.0.1_1
pandora_console-4.0.1_1
 Reply
#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.
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.
 Reply
#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.
 Reply
#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.
 Reply
#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.
 Reply
#8
Thanks for your answer. I will upgrade it when it appears in FreeBSD ports.
 Reply


Users browsing this thread: 1 Guest(s)


(c) 2006-2018 Artica Soluciones Tecnológicas. Contents of this wiki are under Create Common Attribution v3 licence. | pandorafms.com | pandorafms.org

Theme © MyBB Themes