Error on starting pandorafms after 5.0 to 5.1 update

[Jatii]

Like it

Up

0

Down

Drop it

::

Hello!

Had to manually create ff_start_utimestamp and then run the migration script again. Now pandora works but I still have a problem with recon scripts. Running recon migration script gives an error of missing ‘macro’s column. Could someone Post updated verision of database table schema for find missing columns.

One version (not up to date?) can be found from

http://wiki.pandorafms.com/index.php?title=Pandora:Documentation_en:PandoraFMS_Engineering#Pandora_FMS_Database_Design

Thank you

[Mario]

Like it

Up

0

Down

Drop it

::

Hi

Have you followed these steps?

http://wiki.pandorafms.com/index.php?title=Pandora:Documentation_en:Anexo_Upgrade#Upgrading_the_Database_Schemata_.28Major_Versions_only.29

wiki.pandorafms.com/index.php?title=Pandora:Documentation_en:Anexo_Upgrade#Updating_from_Version_5.0_to_5.1

[Jatii]

Like it

Up

0

Down

Drop it

::

Hi!

Yes I followed the instructions but currently, how ever running “/usr/share/pandora_server/util/pandora_migrate_recon_scripts.pl ”  Gave an error about missing about missing ‘macros’ column in the database.

I managed to fix the problem by examining the migrate_recon_scripts.pl and finding out that the missing column was in trecon_script table. I created the column manually on mysql console and after that I was able to run the migration script. Now everything works and I can create recon tasks again.

Seems that the migration scripts wont work if some of the columns are missing. Maybe modifying the scripts to create the columns automatically if not found would have solved the problem. I don’t have any idea why those columns were missing. Main thing is that everything is up and running again!

Thanks for all the readers and Mario’s reply

[Mario]

Like it

Up

0

Down

Drop it

::

OK

The truth is that it is very strange, the field is in the migration script …

./extras/pandoradb_migrate_5.0.x_to_5.1.mysql.sql:ALTER TABLE `tagente_estado` ADD COLUMN `ff_start_utimestamp` bigint(20) default 0;