Validate.php db schema idiocy

Help
#1

Sorry, I’m only allowed one image, so it’s all below:
You can see the problem; validate.php tells me my schema needs to be changed to exactly what I already have.

image
image961×700 19.9 KB

And what the timezone nonsense is all about I don’t know because it’s set by the system to America/Los_Angeles (via timedatectl) and in /etc/php/7.4/cli/php.ini, /etc/php/7.4/fpm/php.ini as well.
Any insight would be appreciated. The problem doesn’t seem to be critical as librenms is running fine.

#2

I’ve had this happen in a fresh install where we remediated it by connecting to the DB with ‘mysql -u root’ to enter the DB application and entering ‘use librenms’ to select the librenms DB and then copy/pasting the sql statements. Let me know if this helped! :slight_smile:

#3

Thanks for the reply. Unfortunately that won’t help because the results of those statements are already in effect. Just for grins I ran them anyway, but nothing changed.