Database Maintenance Error

[manu]

Like it

Up

0

Down

Drop it

::

How do you execute it?

[daniels]

Like it

Up

0

Down

Drop it

::

Hi Manuel,

It is in my crontab:

00 22 * * * /var/www/html/pandora_server/util/pandora_db.pl /etc/pandora/pandora_server.conf 2>&1 | /bin/mail -s “Pandora DB” “my_email@my_domain”

I tried to execute it by hand and have the same result:

[root@sifilis util]# ./pandora_db.pl /etc/pandora/pandora_server.conf

Pandora FMS DB Tool 2.0 PS090112 Copyright (c) 2004-2008 Sancho Lerena
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=360 days, COMPACT=30 days, STEP=1) …

[PURGE] Deleting old access data (More than 24hr)
[PURGE] Deleting old event data (More than 360 days)…
[PURGE] Deleting old data…
[PURGE] Delete old data (string) …
[PURGE] Delete old session data
Undefined subroutine &main::db_delete called at ./pandora_db.pl line 107.

Any idea?

[Sancho]

Like it

Up

0

Down

Drop it

::

RUn the latest SVN code in branches. It works fine (i’ve tested a few hours ago).

Dont forget to do a make; make install on the server svn code

[daniels]

Like it

Up

0

Down

Drop it

::

Thank you Nil, worked perfectly.

I was missing the “make; make install” step.

Unfortunatly, during the problems and trying to fixed, I messed up some things and lost all my history data 🙁 Now I have only one mouth of history.

I did a lot of changes in the last weeks and have an old backup with old data. I will check if its possible to use it or try to merge all the data (sounds a little hard and I don’t know if will be possible).

Thanks for your time and help 😉

Regards.