-
pandoradb_data.sql violates constraints and cannot be loaded
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
-
0 Replies
Sorry, there were no replies found.