Hello Guest

Author Topic: Update DB Pandora FMS v5.1SP2 to Pandora FMS v6.0SP3  (Read 281 times)

0 Members and 1 Guest are viewing this topic.

Offline Willian Medeiros

  • Newbie
  • *
  • Posts: 5
  • Karma: 0
    • View Profile
Update DB Pandora FMS v5.1SP2 to Pandora FMS v6.0SP3
« on: November 04, 2016, 11:54:00 AM »
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

Offline antonio.s

  • Administrator
  • Smart member
  • *****
  • Posts: 288
  • Karma: 2
    • View Profile
Re: Update DB Pandora FMS v5.1SP2 to Pandora FMS v6.0SP3
« Reply #1 on: November 21, 2016, 06:56:44 AM »
Hello William,

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

Kind regards,
Antonio.

Offline Willian Medeiros

  • Newbie
  • *
  • Posts: 5
  • Karma: 0
    • View Profile
Re: Update DB Pandora FMS v5.1SP2 to Pandora FMS v6.0SP3
« Reply #2 on: November 23, 2016, 03:39:33 AM »
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

Offline antonio.s

  • Administrator
  • Smart member
  • *****
  • Posts: 288
  • Karma: 2
    • View Profile
Re: Update DB Pandora FMS v5.1SP2 to Pandora FMS v6.0SP3
« Reply #3 on: December 12, 2016, 02:24:15 AM »
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.

Offline Willian Medeiros

  • Newbie
  • *
  • Posts: 5
  • Karma: 0
    • View Profile
Re: Update DB Pandora FMS v5.1SP2 to Pandora FMS v6.0SP3
« Reply #4 on: January 05, 2017, 04:40:58 AM »
SO: CentOS Linux release 7.2.1511 (Core)
MySQL: mysql-community-server-5.6.34-2.el7.x86_64

Manual installation

Offline antonio.s

  • Administrator
  • Smart member
  • *****
  • Posts: 288
  • Karma: 2
    • View Profile
Re: Update DB Pandora FMS v5.1SP2 to Pandora FMS v6.0SP3
« Reply #5 on: January 09, 2017, 02:01:10 AM »
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.