Posts: 6
Threads: 2
Joined: Nov 2013
Reputation:
0
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?
Posts: 6
Threads: 2
Joined: Nov 2013
Reputation:
0
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
Posts: 711
Threads: 3
Joined: Nov 2012
Reputation:
0
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;