I’ve installed a few instances of LibreNMS before, but haven’t run into this yet.
Installing on CentOS 7 + MariaDB version is 10.6.3 + NGINX
Followed the instructions on: Installation CentOS 7 Nginx - LibreNMS Docs
Getting this upon Build Database on the Configure Database step within the Install process.
Migrating: 2018_07_03_091314_create_alert_log_table SQLSTATE[HY000]: General error: 1025 Error on rename of './librenms/alert_log' to './librenms/#sql-backup-95d-29ca' (errno: 168 "Unknown (generic) error from engine") (SQL: ALTER TABLE `alert_log` CHANGE `details` `details` longblob NULL ;)
I’ve tried dropping the database and running re-create so far. If I leave the database and retry instead, the error is table already present.
I’ve given permissions to the librenms user — seems still an error that might be permissions based?