Pandora FMS community forums
Update DB Pandora FMS v5.1SP2 to Pandora FMS v6.0SP3 - Printable Version

+- Pandora FMS community forums (https://pandorafms.com/community-forums)
+-- Forum: Pandora FMS (https://pandorafms.com/community-forums/forum-3.html)
+--- Forum: Advanced troubleshooting and problems (https://pandorafms.com/community-forums/forum-11.html)
+--- Thread: Update DB Pandora FMS v5.1SP2 to Pandora FMS v6.0SP3 (/thread-8112.html)



Update DB Pandora FMS v5.1SP2 to Pandora FMS v6.0SP3 - Willian Medeiros - 11-04-2016

Hello,

When i exec SQL to Update DB "pandoradb_migrate_5.1_to_6.0.mysql.sql"

I receive this error: ERROR 1048 (23000) at line 28: Column 'id_policy_module' cannot be null


Re: Update DB Pandora FMS v5.1SP2 to Pandora FMS v6.0SP3 - antonio - 11-21-2016

Hello William,

Can you paste here the command you are using? What is your current version?

Kind regards,
Antonio.


Re: Update DB Pandora FMS v5.1SP2 to Pandora FMS v6.0SP3 - Willian Medeiros - 11-23-2016

Hello,

Command: cat pandoradb_migrate_5.1_to_6.0.mysql.sql | mysql -uroot -p -D pandora

Version: Pandora FMS v5.1SP2
New Version:  Pandora FMS v6.0SP3


Re: Update DB Pandora FMS v5.1SP2 to Pandora FMS v6.0SP3 - antonio - 12-12-2016

Hello,

We need more details about your setup. What is the distribution you are using? Is it an appliance ISO installation or manual installation? What is your MySQL version?

Regards,
Antonio.


Re: Update DB Pandora FMS v5.1SP2 to Pandora FMS v6.0SP3 - Willian Medeiros - 01-05-2017

SO: CentOS Linux release 7.2.1511 (Core)
MySQL: mysql-community-server-5.6.34-2.el7.x86_64

Manual installation


Re: Update DB Pandora FMS v5.1SP2 to Pandora FMS v6.0SP3 - antonio - 01-09-2017

Hello William,

It looks like some line of the pandoradb_migrate is incorrect. What is the console version you installed to get it? I would suggest you to manually update your console with rpm -Uvh with the packages you can find here: https://sourceforge.net/projects/pandora/files/Pandora%20FMS%206.0/SP4Final/RHEL_CentOS/
And then try to apply the database update.

Is your environment a new fresh installation or are you updating from an older installation that has already data on it?

Kind regards,
Antonio.