Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
pandoradb_data.sql violates constraints and cannot be loaded
#1
The pandoradb_data.sql file that is packaged with the Pandora FMS console package violates the constraints laid out in the pandoradb.sql schema and as such cannot be loaded.  The result is the following error:

"ERROR 1364 (HY000) at line 385: Field 'protocol' doesn't have a default value"

There might be other error in the file, but I can't even get past the above error.

I was performing a fresh install of Pandora FMS 752 and when running the install.php wizard, it would continually fail as per the attached screenshot.  I then decided to try loading the SQL scripts manually, to see what the error is.

I am using MariaDB version 10.3.25 and these are the steps I used when attempting manual loading:

1. mysql -u root -p
2. DROP DATABASE pandora;
3. CREATE DATABASE pandora;
4. QUIT;
5. mysql -u root -p pandora < /var/www/html/pandora_console/pandoradb.sql
6. mysql -u root -p pandora < /var/www/html/pandora_console/pandoradb_data.sql


.png   Screenshot_2021-03-28 Pandora FMS - Installation Wizard.png (Size: 37.32 KB / Downloads: 3)
 Reply


Users browsing this thread: 1 Guest(s)


(c) 2006-2018 Artica Soluciones Tecnológicas. Contents of this wiki are under Create Common Attribution v3 licence. | pandorafms.com | pandorafms.org

Theme © MyBB Themes