Update DB Pandora FMS v5.1SP2 to Pandora FMS v6.0SP3

[antonio]

Like it

Up

0

Down

Drop it

::

Hello William,

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

Kind regards,
Antonio.

[willian-medeiros]

Like it

Up

0

Down

Drop it

::

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

[antonio]

Like it

Up

0

Down

Drop it

::

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.

[willian-medeiros]

Like it

Up

0

Down

Drop it

::

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

Manual installation

[antonio]

Like it

Up

0

Down

Drop it

::

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.