Pandora FMS Community

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

Willian Medeiros · 4 nov 2016, 22:54 · 6 mensajes · 60 visitas

  1. Inicio del debate

    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

  2. Hello William, Can you paste here the command you are using? What is your current version? Kind regards, Antonio.

  3. 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

  4. 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.

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

  6. 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.

Entra en tu cuenta para publicar.