Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Error on starting pandorafms after 5.0 to 5.1 update
#1
Hello!

I am getting error below when starting pandora_server. Running pandora_server.conf gives:

DBD::mysql::db do failed: Unknown column 'ff_start_utimestamp' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 811.

Does anyone know the solution for this?
 Reply
#2
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
 Reply
#3
Hi

Have you followed these steps?

http://wiki.pandorafms.com/index.php?tit...ns_only.29

wiki.pandorafms.com/index.php?title=PandoraBig Grinocumentation_en:Anexo_Upgrade#Updating_from_Version_5.0_to_5.1
 Reply
#4
Hi!

Yes I followed the instructions but currently, how ever running "/usr/share/pandora_server/util/pandora_migrate_recon_scripts.pl <dbname> <dbhost> <dbuser> <dbpass>"  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


 Reply
#5
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;
 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