[g3ko]

Morning,

Attempted to migrate to RC1 from 5.0 SP4 today but came across a few issues.

Greeted with the above error upon logging into Pandora FMS
https://flic.kr/p/o5dh9e

Custom Reports that were present on 5.0 SP4 have gone and the ability to add new fails
https://flic.kr/p/o6ZqJ2

Further issue is trying to add a custom graph on the visual console, it allows the selection of the module, however, it never appears on the page.

Thanks,

@g3ko

[ivo_yordanov]

Hello

Have you executed the migrate scripts for the new version?

Regards
Ivo

[g3ko]

no that might make sense, is there a quick how to guide I can follow?

Ta,

@g3ko

[ivo_yordanov]

Hello

You can take a look at the official information at the Pandora FMS wiki:
http://wiki.pandorafms.com/index.php?tit...her_System

Regards
Ivo

[g3ko]

Hi,

Thanks for the link. So let me run through this, I need to update Pandora from 5.0 SP4 to 5.1 RC1 as per normal upgrade. Then I need to run the migration script?

Is this the script which needs to be run? I am sorry about asking so many questions, my background is windows rather than linux.

/usr/share/pandora_server/util/pandora_migrate_recon_scripts.pl <dbname> <dbhost> <dbuser> <dbpass>

Thanks,

@G3KO

[ivo_yordanov]

Hello

You must execute the migrate scripts for mysql located in /var/www/html/pandora_console/extras/

Regards
Ivo

[g3ko]

Hi,

Ok I have duplicated our old version of pandora so I can figure out how to upgrade cleanly.

I can go to the folder path /var/www/html/pandora_console/extras/ and see:

pandoradb_migrate_5.0.x_to_5.1.mysql.sql

How do I run this? All the database details have the default name and password if that helps you advise me?

[mario.pulido]

If you have installed PandoraFMS ISO, the execution is:

cat /var/www/html/pandora_console/extras/pandoradb_migrate_5.0.x_to_5.1.mysql.sql  | mysql -u root -ppandora -D pandora

Regards

[g3ko]

Well that worked fine. I could have sworn I did that command though.

Thanks for your help as always.

@g3ko