Welcome to Pandora FMS Community!

Find answers, ask questions, and connect with our community around the world.

Welcome to Pandora FMS Community Forums Community support ERROR in pandora_db.pl (UnixDate) [SOLVED]

  • ERROR in pandora_db.pl (UnixDate) [SOLVED]

    Posted by ivanhoe on December 7, 2009 at 19:15

    Hi,

    I’m working with Pandora v3.0RC1 installed from ISO. I’ve upgraded the server and its tools, such as the pandora_db.pl file.

    I find the following error when I run it:

    ————————————-
    1Q3srv # perl /usr/share/pandora_server/util/pandora_db.pl /etc/pandora/pandora_server.conf

    Pandora FMS DB Tool 3.0-dev PS090930 Copyright (c) 2004-2008 Artica ST
    This program is Free Software, licensed under the terms of GPL License v2
    You can download latest versions and documentation at http://www.pandorafms.org
    Pandora DB now initialized and running (PURGE=60 days, COMPACT=15 days, STEP=1) …

    Starting at 2009-12-07 14:57:38
    [PURGE] Deleting old event data (More than 60 days)…
    [PURGE] Deleting old data…
    [PURGE] Delete old data (string) …
    [PURGE] Delete pending deleted modules (data table)…
    [PURGE] Delete pending deleted modules (data string table)…
    [PURGE] Delete pending deleted modules (data inc  table)…
    [PURGE] Delete pending deleted modules (status, module table)…
    [PURGE] Delete old session data
    [PURGE] Delete old data from SNMP Traps
    [PURGE] Deleting old access data (More than 24hr)
    [CHECKDB] Deleting non-init data…
    [CHECKDB] Checking database consistency (Missing status)…
    [CHECKDB] Checking database consistency (Missing module)…
    [COMPACT] Compacting data until 2009-11-22 14:57:38
    Undefined subroutine &main::UnixDate called at /usr/share/pandora_server/util/pandora_db.pl line 230.
    ————————————-

    Anybody knows how can I install that Perl module? It wasn’t in the original Pandora ISO file (SuSE based) 🙁

    Thanks!

    summa_sp replied 15 years, 2 months ago 3 Members · 3 Replies
  • 3 Replies
  • raul

    Member
    December 7, 2009 at 20:15
    0 Karma points
    Community rank: tentacle-noob-1 Tentacle noob
    Like it
    Up
    0
    Down
    Drop it
    ::

    Have you tried cpan Date::Manip ?

  • ivanhoe

    Member
    December 9, 2009 at 20:49
    0 Karma points
    Community rank: tentacle-noob-1 Tentacle noob
    Like it
    Up
    0
    Down
    Drop it
    ::

    You can mark this topic as solved! 🙂
    Thanks!

  • summa_sp

    Member
    December 16, 2009 at 01:32
    0 Karma points
    Community rank: tentacle-noob-1 Tentacle noob
    Like it
    Up
    0
    Down
    Drop it
    ::

    Im running the 3.0 RC2 image, and I’m getting the same error.  I installed the cpan Date::Manip module successfully, but the pandora.db script still throws the same error. 

    Starting at 2009-12-15 15:36:34
    [PURGE] Deleting old event data (More than 60 days)…
    [PURGE] Deleting old data…
    [PURGE] Delete old data (string) …
    [PURGE] Delete pending deleted modules (data table)…
    [PURGE] Delete pending deleted modules (data string table)…
    [PURGE] Delete pending deleted modules (data inc  table)…
    [PURGE] Delete pending deleted modules (status, module table)…
    [PURGE] Delete old session data
    [PURGE] Delete old data from SNMP Traps
    [PURGE] Deleting old access data (More than 24hr)
    [CHECKDB] Deleting non-init data…
    [CHECKDB] Checking database consistency (Missing status)…
    [CHECKDB] Checking database consistency (Missing module)…
    [COMPACT] Compacting data until 2009-11-30 15:36:40
    Undefined subroutine &main::UnixDate called at /usr/share/pandora_server/util/pandora_db.pl line 230.